Starry Sky Score Management System v1.05

Xingkong Score Management System (score statistics system, Xingkong academic evaluation system, score management system, student status management system) ASP.NET online version is a set of website applications specifically designed to meet the performance statistics and analysis of high schools, junior high schools, and elementary schools.

Test address: http://lmy.sdedu.net/rp2011t/

Login account: test

Login password: test

Star Score Management System v1.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 of Star Sky Score Management System:

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 on the same page. 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.

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

3. Place the file in the virtual directory for access. If the partition is in NTFS format, please set read and write permissions;

4. 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.

pieces.

5. Administrator login account: admin Password: admin

6. After logging in, add classes, students, subjects, teachers...

7. 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 shown below:

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, then click "Properties", and the pop-up

Open 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 in the pop-up "

In the "Security" dialog box, add a "NETWORKSERVICE" user (note that you must select this computer name), and give it "Local startup" and "This computer name".

Activate "permissions locally. Add ASPNET users in XP systems and 2000 systems;

7: Still on the "Security" tab, click "Customize" on "Access Permissions", then click "Edit", and in the pop-up "Security" dialog box

Also add a "NETWORKSERVICE" user and grant "local access" permissions.

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 get more

There is too much available memory, please close workbooks or programs that are no longer in use. ?To free up disk space, delete unnecessary files on the corresponding disk.

pieces.