| Curriculum scheduling is a work which is loaded down with trivial details for the educational administration departments of the universities. The well settlement of the curriculum scheduling problem has the extremely vital significance on the development of the entire teaching work. The characteristics of our university are that, there are more students, more curriculums, but insufficient classrooms, especially insufficient multimedia classrooms. As the result of relatively lacking of the teachers and administration staff, the classroom and the equipments, how to arrange and assign them reasonably for fully using the teaching resources is the problem which we have to face. Artificial curriculum scheduling not only has the heavy duty, low efficiency, and makes mistakes easily, and is difficult to maintain. It is hard to schedule a class-table which all parties are satisfied with. Therefore, the author myself designs and develops the curriculum choosing and scheduling system in universities for fulfilling the demand of the practices of our university.Under the instruction of the related theory, on the basis of the analyzing some curriculum-scheduling soft wares before, this paper carries on the comprehensive educational administration system design under the multi-layered network environment, which utilizes the B/S technology, and uses MVC model of JAVA, the STRUTS frame and the Oracle database. In particular, the paper introduces the functional environment of the system, the design thought and the main functions. Simultaneously it introduces the special assistant functions, such as the computer pre-scheduling, curriculum-adjusting, making-up, the handwork adding, and the important method of getting curriculum-scheduling data resources through the Internet. And it also has carried on the analysis and the explanation for the system on many aspects from the administrative level and the functions. Through the middleware technology, it has solved the data sharing and the relation among each module. Finally it introduces the algorithm of the technical difficulties, such as the automatic curriculum-scheduling. In this paper, it makes some special explorations to the database design, and makes some delicate adjustments to the construction choice and the module division. It also shows the humanity operation in the menu design. This design draws close to the user's practical requirements, and it has the full functions, and manifests the system plan with lots of the UML model maps.This curriculum-scheduling system develops assistant curriculum-scheduling software for utilizing the computer's characteristics, such as the high operating speed, the high efficiency. It fully utilizes and exerts the computer's superiorities, and gives the massive complex judgments and operations to the computer for the automatic transaction. The staff of the educational administration only needs to establish various curriculums and the curriculum-scheduling requirements according to the teaching plan. According to the characteristics of the different curriculums as well as the requests of class teachers, the computer will arrange the curriculum in the scientific, fast, and reasonable ways, and produce a basic class schedule. After the suitable hand-made adjustments, it will satisfactorily apply to the new semester.The curriculum-scheduling management function is the key point and the difficulty of this system design. It not only considers the conflict problem of resources, such as the classrooms, teachers and the classes and grades, but also considers each kind of complex restraint conditions. In the algorithm design, it adopts lots of the backtracking algorithm, and enhances software operational time effectively. Simultaneously, it solves parts of problems such as the time complexities and the spatial complexities. In the premise which does not destroy the stability of the overall algorithm stable as far as possible, it guarantees the stability of the main module algorithm.Except realizing the function of the automatic curriculum-scheduling, the curriculum choosing and scheduling system of universities is also an general educational administration management system, which integrates the entire school various curriculum into a data sheet that is unified to be planned and maintained by the school administration office. The curriculum information includes the management of each part in teaching, such as the curriculum number, curriculum, the study period, the credits, the curriculum type, the way of curriculum test, the department which the curriculum is taught, the provision of the teaching plan, the teaching assignment declared by the teacher, the curriculum-choosing of the students, the grade management. The functions of system are followed:(1) The user registration, logging on, the revision of users' information, for confirming the validity of the user, and managing user's basic information.(2) The input of the basic student information, and the basic classroom information.It is included student name, class and grade, student number and so on, and classroom number, classroom position, seating capacity, and whether it is prepared for the inputting of the basic information such as the multimedia classroom, and for other system modules.(3) Student grade and credit management.Open this function for the teacher user. This module teacher inputs, according to the teaching assignment declared by him, grades and the credit of the students who choose his curriculum.(4) The teacher declares the teaching assignment of each semester to a higher authority. Open this function for the teacher user. This module teacher, according to the teaching plan, declares the teaching assignment, the students, and the teaching places and so on, of each semester to a higher authority.(5) The student chooses the curriculum according to the teaching plan, and chooses the teacher.Open this function for the student user. This module student may, according to the teaching assignment declared by the teacher, choose the curriculum taught by some specific teacher in corresponding semester.(6) The system carries on the curriculum scheduling according to the related information, and produces the class schedule which the students follow.Open this function for the system manager. This module is the core of this system. The manager only needs to choose the specific semester. The system may automatically produce the schedule of that semester, according to the teaching assignment which the teacher submits and the restrained conditions established by the manager in advance.(7) Management and the inquiry of the curriculum schedule.Open this function for the system manager. This module manager may revise or delete in manual way one curriculum in the curriculum schedule of specific semester which is already produced according to the specific request, in order for the produced curriculum schedule to conform to the reality need. After the curriculum schedule produced, the manager, the teachers and the students all could carry on the inquiry. The manager may inquire the curriculum schedule information of this classroom, according to the classroom name which in the system has already added. The teacher may inquire his curriculum schedule of the specific semester. The student may inquire all curricula schedules of the specific semester.This system may be logged on for three different kinds of users, including the manager user, the teacher user and the student user. The different users have the different rights. The manager user's functions have the personal information management, the registers management, the classroom information management, the curriculum-scheduling system management, the curriculum schedule management and the inquiry of classroom schedule; The teacher user's functions have the personal information management, the teaching assignment management, the student grades management, and the inquiry of the teachers' curriculum schedule; The student user's functions include the individual information management, the student curriculum-choosing management, the grade inquiry management, and the student curriculum-schedule management.At present, this system is used on trial in our university. But because of the limited time, and my limited knowledge, some deficiency also needs the continuous improvement for this system to become a perfect functional system of curriculum-choosing and curriculum-scheduling. |