Star Sky Score Management System 1.05

The Starry Sky Score Management System is a set of website applications specifically designed to meet the statistics and analysis of high school, junior high school, and elementary school scores.

Star Sky Score Management System 1.05 update record:

1. On November 19, 2011, the function of adding teachers and students was improved, and the use of duplicate accounts or student IDs was prohibited;

2. On November 19, 2011, the function of automatically deleting students and other information when deleting a class was improved;

3. On November 19, 2011, the function of importing and exporting original scores was improved;

4. Many errors were corrected on November 20, 2011;

5. On November 20, 2011, the problem that the test statistics were not deleted when deleting the test was fixed.

6. On November 21, 2011, the system was renamed: Xingkong Academic Evaluation System.

Features:

1. Record student performance over a long period of time and generate curve charts;

2. Adding exams is easy, and exams can be generated directly from Excel score sheets;

3. The generated statistical analysis is detailed and comprehensive.

Score management:

1. Import and export student scores through Excel, and enter student scores through examination number.

2. Calculate student scores and export statistical results to web pages and Excel

The main statistical projects include:

a. Statistics of students’ total scores, average scores, class rankings and grade rankings by class;

b. The total score, average score, and each score range (below 50 points, 50-60 points, 60-70 points, 70-80 points, 80-90 points, 90-100 points) of the statistics class by subject and the whole level, The number of low scores, the number of qualified people, the number of excellent students, the number of high scores, the low score rate, the pass rate, the excellent rate, the high score rate, the four rates and the four rates are one point;

c. Statistics of the average scores of each class and the whole level, each score range (less than 450 points, less than 450 points, 540-630, 630-720, 810-900), the number of low scores, the number of qualified people, the number of outstanding people, and the number of high scores , low score rate, pass rate, excellent rate, high score rate, four rate and, four rate one point.

3. Modify & set:

a. Modification of subject full marks;

b. Add or delete exam students by class;

c. Randomly generate test numbers for exam students, import test numbers from Excel files, and export candidate information.

Add exam:

Adding method 1: Add based on system student status and system subject data.

Adding method two: Directly import data tables that have completed exams and have scores. If the imported data is the same as the system’s student status or subject, the program will automatically associate it. For example, the student’s student ID number and the system ID number will be automatically recorded to the student. under the name. The imported data can also be used for students, classes or subjects that are not in the system, but in this case the students cannot check their scores. It can be used to temporarily count the scores of a certain test and obtain statistical tables, such as for the score statistics of external schools.

Student Management:

The class teacher or administrator manages classes and students: operations such as adding, importing, deleting, adjusting classes, changing passwords, modifying enrollment and departure status, and viewing historical scores.

Subject Teacher:

Subject and subject teacher management: add, modify, delete subjects; modify students' teachers.

Teacher management:

Add, import, modify, delete, set permissions, and teach subjects for teachers.

Permission management:

Add, modify, and delete teacher user group permissions.

Log in:

Teachers and students log in at the same place. Students log in with their student ID and password. After logging in, they can check historical results.

Installation method:

1. Attached SQL2005 database: RP2011t.mdf. If you are upgrading an old version, you do not need to modify the database. You only need to run update.aspx once. You can delete this file after running it.

2. Modify the database user and password in Web.config

3. Place the file in the virtual directory for access

Administrator login account: admin Password: admin

4. The Excel export function server requires the following settings:

Problems with Excel operation permissions in Asp.Net

It is caused by insufficient permissions of Excel's DCom component, so follow the original steps to set it up, as follows:

1: Install office Excel software on the server;

2: Enter dcomcnfg.exe in "Start"->"Run" to start "Component Services";

3: Double-click "Component Services"->"Computer"->"My Computer"->"DCOM Configuration";

4: Find "Microsoft Excel Application" in "DCOM Configuration", right-click on it, and then click "Properties" to pop up the "Microsoft Excel Application Properties" dialog box;

5: Click the "Identification" tab and select "Interactive User";

6: Click the "Security" tab, click "Customize" on "Startup and Activation Permissions", then click the corresponding "Edit" button, and fill in a "NETWORKSERVICE" user in the pop-up "Security" dialog box (note To select this computer name), and give it "Local Start" and "Local Activation" permissions. Add ASPNET users in XP system and 2000 system;

7: Still on the "Security" tab, click "Customize" on "Access Permissions", then click "Edit", add a "NETWORKSERVICE" user in the pop-up "Security" dialog box, and then assign it to "Local access" permission.

Note: Step 5 is required, otherwise the following error will occur:

There is insufficient memory or disk space and Microsoft Office Excel cannot open or save any documents again. ?To make more available memory, close workbooks or programs that you no longer use. ?To free up disk space, delete unnecessary files on the corresponding disk.