red1.org

[red1]

This is just a workaround alternative for teachers who knows the subjects' sections in the classroom setup.

The system works as i am able to create a section and mark the subject and print it to excel.

Do it this way:
1) Run TimeTabling > Setup Classroom (SubjectSectionModule.java)
2) Put in the same sample subject as the Teacher '203' i.e. PN1123.
3) Select Section 1
4) Put in Matric No. i.e. 04010701
5) Goto Student Marking By Subject Module
6) Select Program '13' and Tutor '230'
7) Click on Get Program button
8 ) Subject PN1123 will show up
9) Now only select Section 1, Session Nov05/06 and List Students
10) Only that student 04010701 shows in List
11) Export to Excel

I have relabelled the VM to make it clearer ... i.e. 'Steps' 1. ... 2...

[Gan MH]

The system worked with the steps given by red1 above.

There are two things need to aware of:

1- To ensure a student name appeared in subject marking under a particular subject section, make sure the subject-section setup (SubjectSectionModule.java) is synchronized with student’s program structure.

2- To ensure the Excel Exporter working properly, you must have at least 1 student in the list.

[khairin]

This idea was discuss when we started designing the Subject Marking module but couldn’t be implemented because lack of data. So I think now we can look back at the idea again….

While maintaining the “mecca.sis.exam.MarkBySubjectModule”, create a new module based on it to direct lecturers straight to the subjects registered to them. Meaning, upon login, lecturers may click on the Subject Marking tab and the screen will automatically list out all his / her subjects and may choose any of the subject to continue keying in marks.

Currently, the Teacher Registration Module (mecca.sis.registration.TeacherRegistrationModule), lists out all (250+) available subjects regardless whether there are currently students registered to it or not. The data is then stored in the table “member_subject”.

Ideally, we want to register teacher to subject based on the current classroom allocation utilizing the “tt_section” table. Meaning for each section_id, one lecturer is allocated to it. And at the Teacher Registration Module, the screen lists out the classroom list for the current session. Eg:

[red1]

MEMBER SUBJECT
`member_id` varchar(50) default NULL,
`subject_id` varchar(50) default NULL,
`role` varchar(50) default NULL,
`status` varchar(50) default NULL,
`date_apply` date default NULL,
`date_enroll` date default NULL,
`module_id` varchar(50) default NULL

Purpose: member_subject is tutor =< subjects
*TODO* for getting list of subjects taught by a selected tutor SQL-A
Select subject_id from Member_Subject where Member_ID = selectedTutor

SECTION
`subject_id` varchar(50) default NULL,
`section_id` varchar(50) default NULL,
`student_id` varchar(50) default NULL,
`session_id` varchar(50) default NULL,
`uid` varchar(50) default NULL

Pirpose: tt_section is students >= section
add program_code

SQL-B Subject chosen selects from member_subject MS, tt_section TS where for students in that section AND that subject. into earlier SQL-A.

Questions:
1) How is teacher tagged to section? thru which table? Join via MS to Sec? That may give rite studentslist
2) why add program_code?

[khairin]

Answers:
1) We would've prefer the teacher to be tagged somewhere during the timetabling process. MS is the better option but might need to add a couple of new fields: section_id (to link with tt_section) and session_id (as subject may change lecturers every new semester and may also be linked to tt_section).

2) program_code quite important bcoz cases of same subject codes but different programs (eg. maths, english, moral etc) but its purely for report purposes only. for this exercise i think better ignore it as program_code can also be derived from student_course later for reporting. so no need to add the field....

tq...

[red1]

Khairin,
So now we add one field to the table below.
Then use the SQL shown to extract just the rite students during Exam Marking.
U think this is ok?

SECTION
`subject_id` varchar(50) default NULL, add tutor_id
`section_id` varchar(50) default NULL,
`student_id` varchar(50) default NULL,
`session_id` varchar(50) default NULL,
`uid` varchar(50) default NULL

SQL = Select student_id from tt_section where tutor_id = tutor_id (login);

But the TeacherRegistration has to:

1) Make pull down selection of subjects to show only those that has students taking them
2) Select also the Class Section besides the Subject that tutor shall teach.
3) Thus that tutor id is also included into the tt_section table alongside subject and section.

[red1]

Codes changed in TeacherRegistrationModule.java at addTeacher()

[red1]

Khairin,
I have created a MarkByTutorModule.java to handle the login straight from tutor where only need to select Classroom and Session and will get the right students, not others!

Already posted to CVS, and sent http://red1.org/university/mecca2.jar
http://red1.org/university/vtl.zip
http://red1.org/university/x.html