With the development of computer technology and quality of education in the schools to keep deepening the practical ability of students the school more and more attention, so the school hours in various classes of experimental courses are also increasing. How do I schedule the teaching laboratory experiments Timetable? In the past in the laboratory management, can only be arranged through artificial means. However, along with expanding the scope of various disciplines in various faculties of the experimental subjects subjects gradually increased, Course Scheduling work seems very complicated, and this prompted us to adopt some means of auxiliary support. Therefore, the laboratory became a need for Course Scheduling System. The laboratory experiment Teaching Course Scheduling System is a product of this demand. It is based on B / S mode, remote access to a laboratory Course Scheduling System. Let those who manually Course Scheduling Course Scheduling, and then the background detected by the system to avoid arranging schedule conflicts. This system is developed by the ASP.NET technology, created by the SQL Server 2000 back-end database.
Key words labs, curriculum, time adjustment, arranging schedule
Graduation Project Manual (Thesis) Foreign Summary
Title The Design of Experimental Course Scheduling System
Abstract
Along with the continuous development of computer technology and deepening of quality education in schools, school has been paying more and more attention to the practical ability of students.The experimental courses of every class are also increasing. How to arrange laboratory experiment teaching classes? In the past of laboratory management, we just schedule through artificial means.But with the ever-expanding range of various disciplines.The experimental subjects have been gradually increasing in each department, this job seems very difficult.This prompted us to adopt some other means to help.Therefore, the timetable of experimental teaching has become necessary.
The experimental course scheduling system is a product for such demand.It is based on B / S model and can be accessed through the Internet.Teachers can schedule the courses manually, then detected by the system background to avoid conflicts.The system is developed by the ASP.NET and the database created by SQL Server 2000.
Keywords laboratory, course, time adjusting, course scheduling
Directory
1 INTRODUCTION 1
1.1 Background 1 topics
1.2 The research situation at home and abroad, trends 1
1.3 The subject of the contents of Chapter 2
2 System Requirements Analysis 2
2.1 System Requirements Background 2
2.2 Feasibility Analysis 3
3 Database Design 4
3.1 Database Selection 4
3.2 system, ER diagram 4
3.3 Database Table Design 5
3.4 The main database operation code 7
4 System Design 8
4.1 The overall modeling system, 8
4.2 System Design 12
5 System Test 20
5.1 The purpose of system testing 21
5.2 Test Methods 21
5.3 The content of the test 21
5.4 Test Time 21
5.5 Test Results 22
5.6 Test Results Analysis 25
Conclusion 26
Thanks 27
References 28
Supplementary Appendix A System Interface Design 29
1 Introduction
1.1 Background issues
With the quality of education in the schools to keep deepening the practical ability of students the school more and more attention, so the school laboratory and experimental courses more and more hours. How do I schedule the teaching laboratory experiments Timetable? In the past, laboratory management, can only be arranged through artificial means. However, along with expanding the scope of various disciplines in various faculties of the experimental subjects subjects gradually increased, so that a large class, many teachers, so that the complex laboratory information management laboratory dizziness brain up, can not reasonably be quickly and efficiently arranging schedule worked out a corresponding program. Course Scheduling using manual methods, and sometimes it takes a month or longer to complete a semester Course Scheduling tasks . This prompted us to adopt some means of auxiliary support. Therefore, the laboratory became a need for Course Scheduling System. As a part of computer applications, using the computer lab Course Scheduling of school management, with the incomparable advantage of manual management. For example: quick search, find convenient, high reliability, large memory capacity, security and good, long life and low cost. These advantages can greatly improve management efficiency, but also schools, scientific and standardized management, and an important condition for integration with the world.
Laboratory of Experimental Teaching Course Scheduling System precisely in order to reduce the workload of laboratory management staff to achieve automation of laboratory management to address the perennial problem of Experimental Teaching Course Scheduling of laboratory management office software. In this paper, under the guidance of the relevant theory, put forward an application in my laboratory, Department of Experimental Teaching Course Scheduling System design methods, and a number of specific issues are given the appropriate solution. However, due to technology and the limited experience and data overload, the system there are still many deficiencies. Because it did not take into account the issue of conflict and teachers, laboratory conflict, but also taking into account the odd and even weeks of courses, and many other resource use issues; Besides, given the characteristics of university teaching, but also deal with a class lesson, such as placement classes. To solve these problems, in this specially made some exploration of the database design, and architecture choice and the demarcation of the module have been carefully adjusted. The design is close to user needs, organizational structure and reasonable and reflects the large amount of block diagram model of the system planning.
1.2 The research situation at home and abroad, trends
The Laboratory Course Scheduling System is still the main problems, "Course Scheduling problem." Foreign Course Scheduling issues for the study earlier. 1963 CC Gotlieb in his article "The Construction of Class-Teacher Time-Tables" proposed a mathematical model for Timetable Planning. The article raises questions about Course Scheduling attention. 1976 S Even in his paper "The Complexity of Timetable And Multi Commodity Flow Problem" , the first proof of class schedule problem is NP complete. S Even the argument further to the school timetable to bring people enhanced our understanding of the complexity of issues to the level of theory. Course Scheduling Problem domestic late in 1984, Lin and Lin Yao-Rui Zhang Xi in the Tsinghua University "Tsinghua University" was published on the subject of experimental research, "artificial intelligence technology in the Timetable Planning Application" .
To make the presentation more accurate class schedule, reasonable, fast, university academic departments have been using computers to carry out Course Scheduling management and has developed some of the applicable Course Scheduling System. We find that the software has the following deficiencies: Each semester courses, teachers, classroom information is relatively fixed, but it can not be reused; can not save the historical data of each semester, inconvenience teachers Timetable previous query; did not provide the user''s sub - class-use system; Automated Course Scheduling slower; formation Timetable size is not fixed, increasing difficulty printing. So now the Course Scheduling System is to address these issues direction.
Today, the domestic software market, there have been many general-purpose type of Course Scheduling software, such as "Course Scheduling worry-free", "Course Scheduling master" and so on. These generic software, some of the schools are often unable to meet the special requirements, there is nothing specific. For this reason, I am the specific requirements of laboratory management, I designed and developed in our laboratory Course Scheduling System.
Subject content of each chapter 1.3
This paper is divided into five chapters, the structure as follows:
The first chapter analyzes the subject of the research background, introduced the subject of current research status and development trend and put forward the necessity of this research project and a brief follow-up the contents of each chapter.
Chapter II describes the system requirements analysis, implementation of the system is divided into four parts, the specific introduction of the system should be implemented functionality, analysis of user characteristics, in studying the Course Scheduling System to consider the various factors to make a viable analysis.
Chapter III designed the database structure, draw the ER diagram of the system, design the database tables for teachers, students table, class table, curriculum, laboratory table, time to adjust the table, professional table and curriculum scheduling, analysis of the database The structure and introduced a major operation on the database code.
The fourth chapter describes the system''s registry subsystems, Course Scheduling subsystem, class schedule release subsystem and the basic model of the integrated management of subsystems, depict the realization of the various sub-process map, specifically describes the design of each module, listing After achieving the system''s main interface, and has done a correlation analysis.
Chapter V describes the purpose of system testing, methods, introduced the test content and test the system time, from functional testing, performance testing, sub-module test and comprehensive test analysis of four aspects of the system test results.
2 System Requirements Analysis
2.1 System Requirements Background
2.1.1 The function of the system requirements analysis
The system discharges a reasonable timetable for the purpose of experimental course, in order to reduce the workload of laboratory management, this system is mainly carried out by the Teacher Course Scheduling and administrators background operation. Laboratory Course Scheduling system provides several functions as follows.
a) Log: including the legitimacy of the user authentication, the user''s classification, and in accordance with the different user types assigned different permissions.
b) Course Scheduling function: through the known information, as far as possible to avoid the class, teachers, laboratory conflict, usually by the Teacher the basis of known information for at least one week in advance for arranging schedule. Doing so the teacher can choose to school hours to facilitate the emission of schools, teachers and students are satisfied with the experimental teaching curriculum. Teacher Course Scheduling If you want to cancel one week in advance should be conducted if we want to transfer the temporary suspension of classes to be with the administrator to conduct the operation by the administrator.
c) Release Timetable: The class schedule scheduled to publish a good experimental teaching, the different users according to their class schedule required by the queries in different ways. The system also enables the school timetable to import word in this feature, so you can easily print row of a good curriculum.
d) integrated management: mainly the management of personal information, student information, teacher information, laboratory information, course information, class information, given the specific circumstances of our department, in this system also enables out rate and the total for each course the calculation of the number of man-hours and use word or excel export.
2.1.2 User Characteristics
In general, the department of laboratory managers and teachers in an uneven level of computer operation, which requires the lab Course Scheduling System friendly interface, easy to use, simple and clear, so that lab managers and teachers quickly learn to mode of operation of the system to complete the experimental teaching course arrangement, but since we are computer science, all teachers are more familiar with the operation of the computer, so this is not a problem.
2.2 Feasibility Analysis
2.2.1 The system must take into account the factors
Under the current structure of university curriculum set characteristics, laboratory Course Scheduling System to consider the following factors:
First of all: To do each class, teachers, laboratories and other resources do not conflict, it is the teaching laboratory experiments the most basic principles of Course Scheduling System.
2nd: Student uniformity of the distribution of school hours. Homogeneity of time refers to the same course within a week the number of arrangements in the days of uniformity. For example, in a data structure classes three times a week to be on the test class, then the row''s class is best not to be continuous for three days and simple, that is to give students the time point of the buffer, in this case the Course Scheduling System to be to be the best from the three experimental classes scheduled Monday, Wednesday, Friday for the three days.
3rd: Student Experiments sessions distribution uniformity. This is to ensure a class curriculum is not always in a single day of the first two or are always the last one or two. The second and the third function is better achieved because of the specific course arrangement of this system is its own row of Instructors, so choose the time would be more reasonable. This is also the Course Scheduling System is different from the market some of the existing system, a major aspect of course arrangement.
2.2.2 the feasibility of
If you want to find a universal optimal condition to meet any of Course Scheduling algorithm is a very difficult task. Take into account the various needs of the previously mentioned factors to be considered "second best" option in a sub-optimal approach can be to some extent to meet the needs of their students table. I have this system is based on this approach to design. This system is to achieve at the time and space, select the best combination of arranging schedule program. The entire experiment by the Teacher Education Course Scheduling process of manually arranging schedule, the computer will do the background processing, arranging schedule the program to determine whether the current database, the program already in conflict. If the program after the submission of a Course Scheduling conflict had arisen, the system will be given tips, arranging schedule who do the appropriate adjustments. Of course, in some special cases, the system administrator can also be arranging schedule or cancel arranging schedule.
In view of the above-mentioned points, in the provision of system operation under the environmental conditions, this system is feasible.
3 Database Design
3.1 Database Selection
Course Scheduling System in our laboratory is to use the SQL Server 2000 to create the database. SQL Server 2000 from a range of products formed, not only to meet the largest data processing systems and commercial Web sites need to store data, but also for individuals or small businesses to provide easy to use data storage services.
3.2 system, ER diagram
