A course design of management information system is urgently needed.

1 performance management system-analysis report (I don't know how to post a data flow chart here, so I posted relevant pictures in the space) (In addition, the data dictionary is in tabular form, but it will change when I post it here. )

I. Introduction

1. system name: student achievement management information system

2. Development goal: To develop a student achievement management information system with simple operation, friendly interface, flexibility, practicality, safety and reliability.

The development of the system is aimed at educational administrators and teachers, which can improve the efficiency of statistical analysis of school students' grades, reduce the burden of educational administrators on student performance management and statistics, and improve the standardized management of school students' grades.

The score management system can collect and sort out students' scores in time, so that the relevant departments of the school can obtain reliable information of students' scores in time and facilitate management.

3. Main functions:

The users of this system can be divided into the following aspects according to their users-administrators and teachers of the Academic Affairs Office:

(1) After logging in, the administrator of the Academic Affairs Office can enter the educational administration personnel module, where you can query personal information, teachers' residence title salary, student information, grades and exit the system.

(2) Teachers should be able to enter, add, modify, delete and query students' scores when logging into the teacher management subsystem; Query teacher information, modify personal login password, modify personal information, etc.

(3) the calculation and statistics of students' scores in single and general subjects, such as total score, average score, highest score and lowest score, are automated; Information can be queried by class and individual; Information can be published on the network to realize data sharing;

(4) can automatically check the input error.

4. Development background

Every school needs to make a statistical analysis of the final exam results at the end of the term, which must be completed within nearly one week after the end of the exam. Statistical analysis of a large number of achievement data is time-consuming and laborious, and it is easy to make mistakes if it is only done by hand. With the rapid development of computer technology, computers are rapidly popularized in daily management applications, and it is imperative to use computers to manage students' grades. Therefore, it is necessary to develop a complete, safe, reliable, fast and simple performance management information system to meet the needs of schools for performance entry, statistics, inquiry, reporting and printing.

Two. System objectives and feasibility of development

1. System goal:

(1) To provide the administrators of the Academic Affairs Office with the information of students' basic grades in each semester, grade and class as the basis for summarizing, analyzing, evaluating and summarizing their grades.

(2) It is convenient for teachers in each class to record and count students' grades, improve work efficiency and reduce the burden; Summing up experience and improving teaching quality.

(3) Realize the rapid and convenient processing of a large number of results data information, and complete the processing requirements such as input, addition, modification, deletion, statistics, query and sorting of results.

(4) output printed transcripts and various performance reports.

2. Feasibility of development

(1) Name, function, target, etc. It has been mentioned before and will not be repeated here.

(2) System environment and tools:

A. software environment:

Client: Windows2000, Windows2003, Windows XP.

Server: WindowsNT/Windows2000 and above operating systems.

Programming language: SOL

Database: Access2003

Hardware environment:

There are high-performance electronic computers, large-capacity storage devices, personal computers (terminals) and connected network cables. , thus forming a computer network sharing information resources, printers, scanners, etc.

(3) System design principles:

1) The system runs safely and reliably with good stability;

2) The system has good manageability and maintainability;

3) The input interface of the system is friendly, the operation is simple and easy, and the input workload of users is reduced as much as possible;

4) Allow multiple data input methods, realize multiple queries, and allow fuzzy queries;

5) The data is normative and holistic, which facilitates the comparative analysis between the data.

(4) System feasibility analysis:

A. Technical feasibility: The system requires to run in an environment above windows2000, and the background database adopts access2003, using SOL programming and connecting the database through ADO, which are relatively easy to realize at present. The program stores some data that need to be called frequently in memory, which can improve the running speed of the program.

B. Economic feasibility: Economically, using this system can improve the efficiency of grade information management, provide higher efficiency for educational administration personnel and save the expenditure of human resources.

C. Feasibility of management: At work, the amount of information that the academic staff manages students is very large. The development of this system can greatly improve the work efficiency of educational administrators. It is convenient to store and modify the results at any time in the future and inquire about the results information. It is a more humanized management system.

(5). Conclusion of system analysis:

From the above analysis, we can develop this system.

Three. Overview of current system

1. Survey of current system status

The existing student achievement management system is mainly aimed at the storage and statistics of achievement data information, and the system design is cumbersome, the management is not professional enough, too many people are needed, and the security and confidentiality of the system are not good; The query function is simple and the data sharing degree is not high.

2. Description of system requirements

(1) The system needs to enhance the query function on the basis of data entry, storage and statistical automation;

(2) We should be able to make full use of the Internet to expand information sharing;

(3) Designate administrators, define management authority, standardize management, and improve the security and confidentiality of the system.

Four. Logical scheme of the new system

1. Business flow chart

2. Data flow chart

(1) Top chart:

(2) the first floor:

(3) The second floor:

A: Certification chart:

B: grade change processing part:

C: certification of educators:

3. Data dictionary

A: Data storage portal:

Composition of numerical names

D 1. 1

Teacher information table teacher number, teacher name, teacher title, class and college taught.

D 1.2

Students record the academic number, name, course name, course number, course score and teacher number.

D 1.3

The name, number and position of the educator in the information table of the educator.

D 1.4

The evaluation of teachers and the analysis of students' achievements after feedback from the staff of the Academic Affairs Office.

B: data processing project:

Digital name input processing logic output

P 1. 1 Certification processes the teacher's login information and checks whether the teacher's employee number and password are consistent-

P 1.2 grade change deals with the entry, modification and deletion of students' academic grades, and checks whether the wrong student grade record sheet has been entered.

P 1.3 grade query processing students' class, student number, name query students' grades, sorting and other student record.

P 1.4

Identity authentication handles the login information of the educational staff, and checks the number and password of the educational staff-

P 1.5 grade query processing student number, grade, student number query class scores, sorting and semester average scores and other student records and feedback information to teachers.

C: data element project:

Description of decimal value range of numeric name data type length

0 1 teacher number N 8 0

02 teacher's name C 8

03 teacher title C 6

04 teach N 8 0 class

05 student ID number 8 0

06 student name C 8

07 course name C 16

08 course number 10

Grade 09 N 3 1 0~~ 100

10 Number of academic staff N 8 0

1 1 academic name C 8

12 academic title C 6

Verb (abbreviation of verb) system implementation plan:

1. Division of tasks:

Preliminary system planning:

Fill in the experimental report and draw a chart:

System programming,

Post-system detection and improvement:

2. Timetable:

System analysis stage: June 2006.11-2.6.13.

System design stage: June 20, 2006-June 24, 2006.

System implementation stage: June 25-29, 2006.

_______________________________________________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________________________________

2 system design report:

System design report

I. Overview

Based on the requirements analysis specification, aiming at the management requirements of academic administrators and teachers for students' grades, referring to the existing development environment, using the available resources and use environment, the characteristics that can meet the corresponding functions are designed, and the functions of classes and class members are constructed and determined.

Second, the environmental description

1. Hardware environment: CPU model Pentium III or above, memory 128M or above.

System environment: Windows98 and WindowsXP can be used.

2. Development environment: It is developed under Access software, which is an object-oriented development tool, easy to use and friendly in interface.

Third, the module diagram

Fourth, the function module

This system is roughly divided into the following four functional modules.

1. User login module

User login module: (Administrator of Academic Affairs Office-Ye Fei-Password: 95028 1)

(Teacher-Liuli-Password: 980 102)

A: After logging in, the administrator of the Academic Affairs Office can enter the educational administration personnel management module, where he can inquire about personal information, teachers' residence, students' information and grades, and exit the system.

B: After logging in, teachers can enter the teacher management module, where they can modify their personal data, inquire about students' information, inquire about the grades of their own classes, inquire about the grades of other classes, and quit logging in.

2. Query and modify module

Comprises the following four modules:

Answer: Student personal information inquiry module: This module is divided into student personal module and class module. The students' personal module contains students' basic information and grades, and can be used to query students' teams, colleges, majors, English grades and other related operations;

In the class module, you can query student information by class.

B: Teacher information query and modification module: this module is mainly used for educational administrators, and can query the whole or designated individuals by opening the "Teacher Table" or "Teacher Personal Information", such as setting the length of service and salary of teachers, and modifying, adding and deleting the salary of each length of service and the corresponding length of service.

C: grade inquiry and revision module: this module is divided into three parts: inquiring and revising students' personal grades according to the designated student number; Query the grade of the class taught by the teacher according to the designated staff number; According to the specified class number or specialty number, the comprehensive score query includes the teacher's query about the scores of other classes (but not without the right to modify).

The specific contents of grade inquiry include grade inquiry of specified subjects, grade sorting, ranking, average score and failed subjects inquiry, etc.

D: User information modification module: this module is used for educational administrators and teachers to modify passwords or user names, teachers' teaching classes and salary titles.

3. Exit the module

After modifying the query, exit the score management system through the exit module to ensure the safety of the system and personal information.

Verb (abbreviation of verb) code design;

1 User login module code:

A: The administrator of the Academic Affairs Office logs in.

◆ Staff of Private Sub-Academic Affairs Office login _ click ()

About the error GoTo Err_ Academic Affairs Office personnel login _ click

Dim stDocName as a string

stDocName = ChrW(25945)ChrW(2 1 153)； ChrW(22788) and amp chrw (20154) & ChrW(2 1592)ChrW(3033 1)& amp； ChrW(24405)

DoCmd。 RunMacro stDocName

Exit _ Academic Affairs Office staff login _ Click:

outlet connection

Err_ Academic Affairs Office staff login _ Click:

MsgBox error. describe

Resume Exit _ Academic Affairs Office Staff Login _ Click

End joint

B: teacher login

◆ Personal education teacher login _ click ()

Go to Err_ teacher login _ click when there is an error.

Dim stDocName as a string

Stdocname = chrw (25945) chrw (24072) and amp chrw (30331)&; ChrW(24405)

DoCmd。 RunMacro stDocName

Exit _ teacher login _ click:

outlet connection

Err_ teacher login _ click:

MsgBox error. describe

Resume Exit _ Teacher Login _ Click

End joint

◆ Private Sub ok_Click ()

If Len(Nz (me! UserName)) = 0 and Len(Nz(Me! UserPassword)) = 0

MsgBox "user name and password are empty! Please enter ",vbCritical," error "

Me! User name. SetFocus

ElseIf Len(Nz (me! User name)) = 0

MsgBox "user name is empty! Please enter ",vbCritical," error "

Me! User name. SetFocus

ElseIf Len(Nz (me! UserPassword)) = 0

MsgBox "password is empty! Please enter ",vbCritical," error "

Me! User name. SetFocus

other

If I! User name = "Liuli"

If UCase (me! UserPassword) = "980 102 "

MsgBox "Welcome!" , vbInformation, "success"

DoCmd。 OpenForm "teachers' comprehensive information query"

other

MsgBox "Incorrect password, abnormal exit." , vbCritical, "error"

DoCmd。 close

If ... it will be over.

other

MsgBox "The user name is wrong, so I quit abnormally." , vbCritical, "error"

DoCmd。 close

If ... it will be over.

If ... it will be over.

End joint

2 students' personal information query module code

A: Specify student information inquiry:

◆ Private subcommand 1_Click ()

Go to Err_Command 1_Click when an error occurs.

Dim stDocName as a string

Stdocname = CHRW (23398) CHRW (29983) and AMPCHW (20010) and AMPCHW (20154)&; ChrW(20449) and ampChrW(24687) and ampChrW(26597) and ampChrW(-29726).

DoCmd。 OpenQuery standard document name, acNormal, acEdit.

Exit _ Command 1 _ Click:

outlet connection

Err _ command 1 _ click:

MsgBox error. describe

Resume Exit _ Command 1 _ Click

End joint

B: information inquiry of the whole class:

◆ Private subcommand 20_Click ()

Go to Err_Command20_Click when an error occurs.

Dim stDocName as a string

St docname = CHRW (29677) CHRW (32423) and ampChrW(23398) and ampChrW(29983) and ampChrW(20449) and ampChrW(24687) and ampChrW(26597) and AMPCHW (-29726).

DoCmd。 OpenQuery standard document name, acNormal, acEdit.

Exit command 20 Click:

outlet connection

Error Command 20 _ Click:

MsgBox error. describe

Resume Exit _ Command 20 _ Click

End joint

3 teacher information query and modify module code

A: Designated teacher information inquiry

◆ Private subcommand 13_Click ()

Go to Err_Command 13_Click when an error occurs.

Dim stDocName as a string

Stdocname = CHRW (25945) CHRW (24072) and ampChrW(20449) and ampChrW(24687) and AMPCHW (21333) CHW (20010) and ampChrW(26597).

DoCmd。 OpenQuery standard document name, acNormal, acEdit.

Exit _ Command 13 _ Click:

outlet connection

Err _ command 13 _ Click:

MsgBox error. describe

Resume Exit _ Command 13 _ Click

End joint

B: all teachers' information inquiry:

◆ Private subcommand 14_Click ()

Go to Err_Command 14_Click when an error occurs.

Dim stDocName as a string

Stdocname = chrw (25945) chrw (24072) and ampChrW(20449) and ampChrW(24687) and ampChrW(26597) and ampChrW(-29726).

DoCmd。 OpenQuery standard document name, acNormal, acEdit.

Exit _ Command 14 _ Click:

outlet connection

Err _ command 14 _ click:

MsgBox error. describe

Resume Exit _ Command 14 _ Click

End joint

4 grade query and modify the module code

Answer: For the individual scores of designated students:

◆ Private subcommand 23_Click ()

Go to Err_Command23_Click when an error occurs.

Dim stDocName as a string

Stdocname = CHRW (23398) CHRW (29983) and AMPCHW (20010) and AMPCHW (20154)&; ChrW(25 104)ChrW(32489) and ampChrW(26597) and ampChrW(-29726).

DoCmd。 OpenQuery standard document name, acNormal, acEdit.

Exit command 23 Click:

outlet connection

Error Command 23 _ Click:

MsgBox error. describe

Resume Exit _ Command 23 _ Click

End joint

B: Inquire about the comprehensive scores of designated classes.

◆ Private subcommand 24_Click ()

Go to Err_Command24_Click when an error occurs.

Dim stDocName as a string

Stdocname = CHRW (25353) CHRW (29677) and ampChrW(32423) and ampChrW(26597) and AMPCHW (-29726); ChrW(23398) and ampChrW(29983) and amp chrw (25104) chrw (32489)

DoCmd。 OpenQuery standard document name, acNormal, acEdit.

Exit command 24 Click:

outlet connection

Error Command 24 _ Click:

MsgBox error. describe

Resume Exit _ Command 24 _ Click

End joint

5 User information modification module code

◆ Private subcommand 28_Click ()

Go to Err_Command28_Click when an error occurs.

Dim stDocName as a string

stDocName = ChrW(25945)ChrW(2 1 153)； ChrW(22788) and amp chrw (20154) & ChrW(2 1592)ChrW(20449) and ampChrW(24687) and ampChrW(26597) and ampChrW(-29726).

DoCmd。 OpenQuery standard document name, acNormal, acEdit.

Exit command 28 Click:

outlet connection

Error Command 28 _ Click:

MsgBox error. describe

Resume Exit _ Command 28 _ Click

End joint

6 exit module code

◆ Private subcommand 3 1_Click ()

Go to Err_Command3 1_Click when an error occurs.

DoCmd。 give up

Exit _ Command 3 1 _ Click:

outlet connection

Err _ command 3 1 _ click:

MsgBox error. describe

Resume Exit _ Command 3 1 _ Click

End joint

__________________________________________________________________________________________________________

3 system implementation report