| With the education scale of Party School expanding,the class numbers of diploma education is increasing.The courses are always planned to learn in spare time to the class of diploma education.The situation of learning-time,classroom is complex. At the same time, due to the Party School teachers, classrooms and other resource constraints, course schedule arranging often causes conflict, heavy workload by hand,which affects the normal working order. Unlike secondary education,the Party School learning-Time-Unit is morning, afternoon or evening. Each learing-time-Unit couples only one course. These classes have lessons on Saturday or Sunday; every class has 3 courses each semester, each course has 8 times to teach. Therefore, we must develop the course schedule arranging system to meet the need of Party School. At present, it is still blank that studying the course schedule arranging of party school. Developed the course schedule arranging system is to upgrade the work for Party School.This course schedule arranging system is founded under the environment of Jbuilder9 and MySQL4.0. Based on feasibility analyzing and system requirment analyzing, the article makes a concise description about of design-project,functional model,interface designing and database system designing.The system adopts MVC 3 layered architecture ,so it is easy operating, maintaining and expanding.As the Party School curriculum is different from those offered by other colleges. Each week the course arranging of classes is different, so automatic course arranging, manual adjustment and system conflict detection methods are adopted.The contents of Conflict detection are that there are different courses in the same classroom or the teacher has different curriculums at the same time .For this reason, design a two-dimensional form:It is a two-dimensional blank table which regards (Room and morning,afternoon or evening) as the X-axis, date as Y-axis . The set (grade, course and teacher) is regarded as a arranging-unit to be stored in the two-dimensional table . At present there are not over 20 classrooms to be permitted in the two-dimensional table. As the two-dimensional form has solved the conflict in the classrooms and dates , it is focus that solving the conflict of teacher.Manual course arrangement, the system verifies whether the set (grade, course and teacher) is selected or integrated, then checks whether it has been added . Some classes having lesson together must have the same course and have the same teacher .Finally tests if the teacher exists conflict,not, the set(grade,course and teacher) would be put in the table.Course Scheduling automatically, the problem boils down to: how to arrange eight days (all Saturday, Sunday) to counsel time for each class in one semester. Generally there are more than 16 weeks each semester. So each classroom available dates can be divided into 4 date-group to accommodate 4 classes.For every class, there are 6 course-group (all different order of 3 courses). First get class; further get classroom, get date-group, take course-group ; judge whether teachers conflict? If conflict, adjust course-group; still conflict, adjust date-group; conflict also, adjust the classroom; results still conflict, the class will not be able to scheduled. Do notconflict, courses are put into right position;fetch next class.......Making date-groupand course-group simplified the resolution of the conflict, improved time-efficiency.The constraint of course scheduling problems is divided into two types, namely: hard constraint and soft constraint. Hard constraint is that due to resource constraints, classrooms and teachers must meet the conditions. The soft limit may try to meet, such as one teacher not willing to have lessons in the evening, the other teacher likes to work on Saturday morning and so on The course schedule arranging System did not consider the soft limit, which is the system's deficiencies. Waitting to study further.At the end of this article, references are listed. |
PDF Full Text Request