red1.org

red1

As requested, we have changed the above to
1) Mark by subject will filter by Tutor ID. Just select the Tutor ID from the top right pull down. This is as fast workaround. Later we may put in login for them to go straight.

2) Marking implementation is now filtered by Program Code for the convenience of user.

Tested codes and Vms, committed to CVS.

Gan MH · Senior Joined: 08 Apr 2005 Posts: 350

Tested above and here are my comments:

1.1) Adding a tutor to subject will create a new tutor_id. i.e. I added tutor "gan" to 2 different subjects, in the top right pull down you will see tutor "gan" appears two times. Perhaps, we can allow user to select existing tutor from a pull down list, if does not exist then allow adding new tutor_id (just like what we did in fee structure module, selecting of fee_code).
1.2) I think the VM was not committed, pls check.

2) Program Selection for ALL category does not functioning.

red1 · Posted: Tue Apr 11, 2006 7:12 pm Post subject:

refering to Gan's feedback testing above:

1.1) solved...
Pls checkout MarkBySubjectModule from CVS again to see

1.2) sorry.. i cannot check stuff if i dont know the name. Always supply complete filename. thnx.

2) All category not supposed to be there... already changed VM to show - Pls Select - instead.
Pls checkout marking_impl.vm

Gan MH · Senior Joined: 08 Apr 2005 Posts: 350

Tested and everything seems ok now.

1.2) I was referring to vtl/sis/exam/get_by_subject.vm. Just checked back and the file seems updated from the last modified date.

Now, Khairin has to setup User Template for "Teacher" user role in the live database. Then, register exisiting CICT tutors under this user role. I shall assist remotely on this setup.

Gan MH · Senior Joined: 08 Apr 2005 Posts: 350

I just found out that, adding a tutor to subject does not create record in table "user", which mean user have to repeat work 2 times.

By right it should be integrated where a new tutor record is created in table "user" with user role "teacher" at the same time when a tutor_id is added to a subject.

For the moment (pilot testing), Khairin can create one universal teacher login for all teachers at CICT.

khairin · Regular Joined: 27 Apr 2005 Posts: 57

We've almost complete setting up the teacher-subject assignment.

Plan to fully utilize very soon.

But since the students name is removed please ensure that the Subject-Marking table is sorted by Student_id (Matric No.).

Also, please provide an export to excel button for the Subject-Marking page.

Tq...

red1 · Posted: Tue Apr 18, 2006 12:34 pm Post subject:

Already modified StudentMarkData.java to allow sorting by matric no.

Sent to CVS.

Gan MH · Senior Joined: 08 Apr 2005 Posts: 350

Due to exam results for UPM and SCU programs are returned using a different type of student id, Khairin created a new field “alternate_id” and imported data into student_course table. The latest db dump is available at: http://red1.org/barn/Cybernetics/0604191740.zip

I have created $student.alt_id in vtl/sis/exam/get_by_subject.vm. Now, we need to get and put it in JAVA mecca.sis.exam.MarkBySubjectModule.

red1 · Posted: Thu Apr 20, 2006 11:08 am Post subject:

done ... synched already .... just one java StudentMarkData.java... tested ok the W* alt ids came out in the vtl/sis/exam/get_by_subject.vm
In public static Vector getStudentList(String subject_id, String session_id, String program_code) throws Exception { chip in..

khairin · Regular Joined: 27 Apr 2005 Posts: 57

observations perhaps BUGS:

case:

matric no. : 03060841
program : 13-Diploma Pengurusan Perniagaan
subject enrolled : PN1123
lecturer : 230

problem: record did not appear in Subject-Marking page. record do appear in Student-Marking page. we confirm student's enrolment by checking Course-Enrolment page.

extra note: PN1123 subject for this student was added manually (not through the auto-generated process which pulls data from original course structure).

Gan MH · Senior Joined: 08 Apr 2005 Posts: 350

The above case happened on those deferred case. In the subject marking, the subject was found left in the initial session before deferred.

We tried dropping that subject and adding it back again. However, it still does not showed up correctly in subject marking under the correct semester session.

red1 · Posted: Wed Apr 26, 2006 8:43 pm Post subject:

i found out that for defered students the SQL in StudentMarkData.java to GetStudentList still refers to student_course.intake_session which is wrong as the student_status.batch_id is accurate to show that the defered batch has jumped to the next one.

Thus i modify as follows

khairin · Regular Joined: 27 Apr 2005 Posts: 57

Dear Red1,

Code is correct....

239 is the true number...

why decrease from 297 to 239? Maybe that's because u went one better.... u now even discard students who is currently deferred from appearing in the list which is one of our aim in the first place... i'll check on it later....

so now i'll be waiting for the updated jars...

tq!

red1 · Posted: Thu Apr 27, 2006 12:29 pm Post subject:

wah.. hebatnyaa aku niiii... dasyot! dasyot! Very Happy

Ok, thats wonderful to hear! I also suspected like that. That means Sam's DB model is very sophisticated. Its merely forming the rite SQL query to the DB to get whatever we want.

khairin · Regular Joined: 27 Apr 2005 Posts: 57

dear red1,

sorry a bit of false alarm regarding the SQL...

it seems that students who is currently defer for the semester, their enrolment still comes out unless we manually withdraw their subjects...

tried a bit of SQL, this seems to be the best output without having to withdraw their subjects manually....

red1 · Posted: Wed May 03, 2006 12:08 pm Post subject:

I merely add and ss.status='active' at the end of the SQL. Done in StudentMarkData.java and compiled for Khairin. Tested here seems ok.

khairin · Regular Joined: 27 Apr 2005 Posts: 57

Feedbacks from lecturers using the subject_marking module

1. For lecturers who key in their data at a slower rate, sometimes found out that their session has timed-out. As a result they had to re-enter from the last time they saved. khairin: I advised the lecturers to make sure to save their work frequently. Also i like to request that the system increase the time-out timer a bit more...

2. Some lecturers are fond to enter non-numerical values... eg X, Absent, F, or even blanks in the mark fields. When they try saving, the system won't accept and lecturers have to press BACK button, skim through all the data they entered to repair the non-numerical values. khairin: perhaps its better if the system detects these errors at point of entry rather than later....

3. Subjects with more than one lecturers have to take turn to key in their marks. Otherwise overwriting will occur. khairin: this problem will be solved once we sort out the time-tabling module in which lecturers will only mark students from their own pre-assigned classes.

4. Lecturers wish that their screen will automatically load only the subject they're in charge. khairin: also will be solved by the time-tabling module.

5. At peak period, usually shortly after examinations, a high number of lecturers are logged on to the system. Once or twice the system crashed and had to re-start. khairin: time to tweak the reserved memory or add RAM?

6. Some lecturers asked for the CVS export button in the module for their own personal record & analysis. khairin: requested before...

7. Head of Schools (bosses to the lecturers) would love a page/report on the progress of the lecturers in entering their data. Examples: How many lecturers have or haven't enter marks for certain subjects, or what is the mean average marks currently for a certain subjects or the whole program... etc its more like live reports... khairin: these are merely simple reports....

Gan MH · Senior Joined: 08 Apr 2005 Posts: 350

I saw an "Export to Excel" button in Student Marking By Subject. However, it returned error when I click on this button. Is this bug? or the coding is still not complete?

red1 · Posted: Sat May 20, 2006 7:06 pm Post subject:

Now the Excel export is done. Pls collect MarkBySubject.java and get_by_subject.vm from CVS.

While doing this i notice that the Marks has Mark.Type = "Points" and possibly = "Grade" which is A, B, C automatically if set. So pls check with Sam if he did sumtin like that, and wer to activate that. U can search the codes/vm that does Mark.setType.

Gan MH · Senior Joined: 08 Apr 2005 Posts: 350

Tested Excel export, it's working fine.

Yes, we have the configurator to define mark input type whether to be Percentage, Actual Mark, or Grade. However, this does not resolve the external marking scenario, which will be a combo of internal Actual Mark and external Grade.

Maybe Khairin can try out the mark type and see there is any potential workaround to handle the UPM cases.

red1 · Posted: Sun May 21, 2006 6:09 pm Post subject:

UPM aside, does this mean that the early issue of exmaners marking in grade and not points is solved by this MarkType?

If so, ok for the vm, but NOT the excel exporter which i make to print points only. I will only make the Excel to show grade if its needed by user.

Gan MH · Senior Joined: 08 Apr 2005 Posts: 350

Yes, the exam module can support three different type of mark input:
1) Actual Mark
2) Percentage
3) Grade

However, it's currently limitted to 1 marking scheme : 1 MarkType

red1 · Posted: Tue May 23, 2006 8:53 am Post subject:

After discussions with Gan/Sam, i now understand that we merely need to link the Marking By Subject to Group (or section as in Sam's TimeTable system).

The section/group id means that Students no longer grouped by Subjects but Group. Teacher instead will be tagged to Groups and not subjects.

Subjects already split into sections under TimeTable system.

Thus:
> MarkBySubject = select Teacher > select Group > list Students

> TimeTable = Teacher > Subject > Group > assign to slot schedule

Code Changes needed:
1) MarkBySubject - filter by section_id from tt_section in getStudentList to associate student/subject to section. Then filter by tt_schedule to associate teacher to section. Thus list will be more finer.

Data Changes needed:
1) Setup TimeTable Schedule and Section tables.

red1 · Posted: Wed May 24, 2006 10:34 pm Post subject:

i m making a simpler way to select by group (section). Pls take from CVS.

Now user has two choices - by Tutor or by Section (Class group) which takes student list from TimeTable's section setup.

So pls setup TimeTable Section's student list first to try.

Gan MH · Senior Joined: 08 Apr 2005 Posts: 350

I have tested this new module, but it did not work.
First, I add student A to AC1000 ASAS PERAKAUNAN, Section 1 in TimeTable module.
Then, I select Section 1, AC1000 ASAS PERAKAUNAN in Marking by Subject module.
Student A does not appear in the marking list.

Theoretically this concept works, but I feel there are some confusions:

1- Teacher will have difficult identifying which Section is belongs to which subject in the drop-down menu.

2- When selection by Class Section, the system should disable the program selection. Teacher only identify which Subject and which Section Group to that subject to mark.

3- There are conflicts between the TimeTable Student Setup and Program Structure Setup. Examples:
a- I add a student to AC1000 ASAS PERAKAUNAN in TimeTable module, but his Program Structure is not updated
b- I add student A to MAT2001 MATEMATIK ASAS I, but actually according to his Program Structure Setup he should be taking subject MAT2101 MATEMATIK ASAS I.

P/S: After all, the system should identify subjects attached to a student from the Program Structure. TimeTable module will only be the student-subject group configurator.

Also, the Excel Exporter is not working after checking out the latest version from CVS.