Campus information management and teaching platform integration system (for SQL2005)

Main functions of the system:

<1> Comprehensive platform functions (intranet):

1. The comprehensive platform system administrator can set subjects, grades, and class codes, enter school information, set user permissions, handle graduation upgrades, and manage student comment databases. System administrator password: JWGL, which can be changed after logging in.

2. Student status management: Student data can be entered in a variety of ways. It can be entered by the administrator, the class teacher (the system administrator can only enter the data of this class with different permissions), or only the name of the student can be entered, and the student can log in to modify the information and save it. Data can also be imported from an EXCEL table, but the fields in the first row of the spreadsheet must be the same as the downloaded mode, and the order can be different.

3. Score processing:

① Scores can be entered in various forms, either by the administrator, or by the administrator with separate permissions for different grades and subjects. Scores of other subjects cannot be modified. Or you can also import data from EXCEL tables.

②Analysis of scores in this system, grade ranking table (by type of score, name), performance progress comparison (progress in each subject and total score progress are reflected on the same table), class (level) analysis table, and score analysis table for the same subject (containing comparison calculations between the teacher's four items (average score, excellent rate, pass rate, poor student rate) and school data). Total score histogram, comparison histogram. All data can be exported to EXCEL tables and can also be printed. When printing, you need to set up IE to print automatically.

③The performance data in recent years (ten years) are queried in the form of a line chart.

4. Students are rewarded for hard work and punished for laziness.

5. Enter students’ moral education, attendance and class teacher’s comments.

6. Input post-graduation work such as the student’s graduation destination after graduation.

7. Teacher personnel file management (the introduction can be introduced by subject teachers on the external website).

8. Upload and query teachers’ work plans and summaries for each semester.

9. The final grade data (number of students, average scores, excellent rate, passing rate) are transferred to the past grade database, and the grade data of recent years (ten years) can be compared and queried in the form of a line chart.

<2> Home page functions (external network):

1. The most senior administrator of the system can manage all functions of all internal and external networks and authorize registered users to have permission to publish files and general user permissions (two permissions: those that can upload courseware and those that cannot). After registration, users must be authorized by the administrator before they can download courseware, etc. System administrator for the first time using the system: admin Password: admin can be changed after logging in.

2. Publish files Users can publish school text news, graphic news, academic affairs, moral work, general affairs work, party and league union work, teacher and student award information, etc.

3. School introduction, school leadership team (you can check current and previous team members), teacher style, etc.

4. Upload files Users can upload courseware, lesson plans, test questions, papers, teaching software, etc.

5. General users can download courseware and other information.

6. Browsing function for non-registered users.

<3> Integrated teaching and question bank platform WEB services:

1. Server side: This system integrates the WEB service of teaching and question bank, which changes the limitations of the local area network and enables remote access. The database is installed in the DATA folder of this directory. The mathematics question bank has two file names, "Mathematics Question Bank.MDF" and "Mathematics Question Bank_Log.Ldf." The teaching platform can log in to the database of ten subjects. You can copy these two files and rename both files at the same time as Chinese question bank, political question bank, physics question bank, chemistry question bank, English question bank, history question bank, geography question bank, biology question bank, and computer question bank. Note that only the name is changed, "_Log.Ldf" cannot be modified. For example: , "Chinese question bank.MDF" and "Chinese question bank_Log.Ldf". The contents of the database are stored in encrypted binary format. Only after logging in to the client's teaching platform software and decrypting it can it be viewed and used. I have completed the teaching process and mathematics question bank of the three-year junior high school mathematics teaching platform. The file is about 670M.

2. Client teaching platform software:

A. You must first install Framework 4.0 (or connect to the Internet when installing this system. When installing this system, it will check whether your system has Framework 4.0 installed, and if not, it will be downloaded automatically).

B. Install software on this system.

C. Login User admin Password: admin You can add new users (demo only).

D. It only takes one class time for users to write the content of a class on the platform, which is about the same time as handwriting lesson plans. Various forms of files can be inserted. There is drawing software in the system, which can be used for on-site teaching. It is especially suitable for animation teaching of graphics rotation, translation, axial symmetry, drawing parabola, hyperbola, straight line and so on in junior middle school mathematics.

E. The exercises are called on-site for teaching and examination. After the examination, you can add and delete questions in the examination column. Finally, export WORD for typesetting and printing, or you can print directly.