red1.org Forum Index red1.org
Nihili est - in vita priore ego imperator romanus fui
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

TIME-TABLING MODULE - INITIAL STUDY

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    red1.org Forum Index -> College ERP Project
View previous topic :: View next topic  
Author Message
khairin
Regular


Joined: 27 Apr 2005
Posts: 57
PostPosted: Thu May 04, 2006 3:56 pm    Post subject: TIME-TABLING MODULE - INITIAL STUDY Reply with quote
TIMETABLING – SYSTEM


ASSIGNING GROUPS TO ALL ACTIVE STUDENTS

i. Before the beginning of a new session (eg. 2006/2007-M), the Timetabling Committee (TT) will collect the names of all active students.

Eg. Active Students = 2200 students

ii. This list is then divided into the student’s respective programs.

Eg. DPP = 900 students
DIT = 500 students
DSK = 250 students
etc….

iii. Each program is broken into semesters.

Eg. DPP (900 students) - Sem 1 = 200
- Sem 2 = 50
- Sem 3 = 180
etc…

iv. TT will then assign groups to each of the students. Usually if number of students in a certain semester exceeds 60 people, it will be divided into sub-groups. The preferred format in use is:

Eg. DPP1A which means DPP program Semester 1 Group A.

v. At the end of this exercise each student will be assigned to a group.


ASSIGNING GROUPS TO ALL ACTIVE SUBJECTS

i. Before the beginning of a new session (eg. 2006/2007-M), the TT will also collect the list of subject enrolments. The list looks like something like:

Eg. SAK1234 – DSK – 250 enrolments
SAK1000 – DSK – 30 enrolments
LAN1003 – DPP – 200 enrolments
LAN1003 – DIT – 40 enrolments
etc…

ii. TT will refer each enrolment to their respective groups.

Eg. SAK1234 – DSK2A – 45 enrolments
SAK1234 – DSK2B – 47 enrolments
SAK1234 – DSK3A – 3 enrolments

iii. TT should also decide whether to create a classroom for subjects with small enrolments (<10 enrolments).

iv. TT also responsible in combining the common subjects into one group eg. LAN1003 combine DPP with DIT) if thought necessary.

v. TT also have to reserve classes for expected new student intakes which should all be in Semester 1.


THE REST IS ENTIRELY ON MECCA TO GENERATE / POPULATE THE TIME-TABLE…
Back to top
View user's profile Send private message
red1
Site Admin


Joined: 06 Jul 2004
Posts: 1756
Location: Kuala Lumpur, Malaysia
PostPosted: Tue Aug 15, 2006 4:59 pm    Post subject: Reply with quote
Tables to setup are
Code:
DROP TABLE IF EXISTS `tt_prepare_classroom`;
CREATE TABLE `tt_prepare_classroom` (
    `uid` varchar(50),
    `subject_id` varchar(50),
    `section_id` varchar(50),
    `teacher_id` varchar(50),
    `room_id` varchar(50),
    `user_session` varchar(50),
    `slot_constraint` varchar(50),
    `day_constraint` varchar(50)
);
DROP TABLE IF EXISTS `tt_room_impl`;
CREATE TABLE `tt_room_impl` (
    `room_id` varchar(50),
    `room_code` varchar(50),
    `room_name` varchar(50)
);
DROP TABLE IF EXISTS `tt_schedule`;
CREATE TABLE `tt_schedule` (
    `subject_id` varchar(50),
    `section_id` varchar(50),
    `teacher_id` varchar(50),
    `room_id` varchar(50),
    `day_id` int,
    `slot_id` int,
    `uid` varchar(50),
    `user_session` varchar(50)
);

DROP TABLE IF EXISTS `tt_section_impl`;
CREATE TABLE `tt_section_impl` (
    `section_id` varchar(50),
    `section_code` varchar(50),
    `section_name` varchar(255)
);
DROP TABLE IF EXISTS `tt_slot_span`;
CREATE TABLE `tt_slot_span` (
    `uid` varchar(50),
    `slot_count` int
);
DROP TABLE IF EXISTS `tt_teacher_impl`;
CREATE TABLE `tt_teacher_impl` (
    `teacher_id` varchar(50),
    `teacher_code` varchar(50),
    `teacher_name` varchar(100)
);
Left out tt_section cos its already in present system. Do it only if absent:
Code:
DROP TABLE IF EXISTS `tt_section`;
CREATE TABLE `tt_section` (
    `subject_id` varchar(50),
    `section_id` varchar(50),
    `student_id` varchar(50),
    `session_id` varchar(50),
    `uid` varchar(50)
);
Back to top
View user's profile Send private message Send e-mail Visit poster's website
red1
Site Admin


Joined: 06 Jul 2004
Posts: 1756
Location: Kuala Lumpur, Malaysia
PostPosted: Mon Dec 04, 2006 4:28 am    Post subject: Reply with quote
The TimeTable system structure with the SubjectSection is now aligned.

Following this http://sourceforge.net/forum/forum.php?thread_id=1620607&forum_id=482271 at the bottom is given the final success of this module. Pls follow the instructions in that thread, i.e. the creation of a extra section_class in tt_section.

Also run the migration from the MarkBySubject module, which will set all the sections to its A,B,C.. L section_classes. Make backup before running this.

Then test looking up students of any Subject_section. Then test adding and deleting from selection. Always refresh after each action by clicking on the GET button.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    red1.org Forum Index -> College ERP Project All times are GMT + 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group