This paper introduces the present situation of grade management in our school and the general situation of Visual basic6.0 language. This paper focuses on the implementation process of student achievement management system, including system analysis, system investigation, data flow analysis, functional design, database design, system physical configuration scheme, system implementation, system testing and debugging. The main functions of this system are user management, student registration, class information input, student information input, class curriculum input, school professional information input, course information input, student achievement input, teacher information input and data input. . . . . . . . . . . Including functional requirements description, database design and so on. The fourth chapter introduces the concrete implementation of the system. The fifth chapter is the conclusion and experience of this system development.

Student achievement management system, function, characteristics, paper content.

abstract

This paper describes the present situation of grade management in our school and the general situation of Visual basic6.0 language. This paper mainly introduces the realization process of student achievement management system. . . . . . . . . Such as functional requirements description and database design ... and so on. . The concrete implementation of the system is introduced. The fifth chapter is about the conclusion and realization of the system development process.

keyword

Student achievement management system, function, characteristics, paper content

catalogue

abstract

foreword

Chapter 1 Introduction

The development background of 1. 1

1.2 development goals

Significance of the project 1.3

Technical preparation for 1.4 system development

Chapter II System Analysis

2. 1 system requirements analysis

2. 1. 1 systematic investigation

2. 1.2 organizational setup

2. 1.3 user requirements

2. 1.4 system business flow chart

2. 1.5 system design idea

2. 1.6 system design analysis

2. 1.7 system function analysis

2.2 New system logic scheme

2.2. 1 data flow diagram (DFD for short)

data dictionary

2.2.3 Propose a new system logic model.

System boundary

Chapter III System Design

3. 1 Brief introduction to the functional requirements of the student achievement inquiry system

3.2 Description of functional requirements

3.3 System objective requirements

3.4 System Platform Selection

3.5 Database design

3.5. 1 database requirements analysis

3.5.2 Conceptual structure design of database

3.5.3. Logical structure design (transformation from E-R diagram to relational model)

Chapter IV System Implementation

4. 1 Example of program design for each subsystem module

4.2 The purpose and principle of software testing

4.3 subsystem testing

4.4 Software Operation and Conversion

Chapter V Conclusion

thank you

refer to

Chapter I Introduction

1. 1 project development background

In the past few years, the management of students' grades in various schools was basically carried out by hand. With the increase of the scale of each school, the amount of data involved in student achievement management is increasing, and some schools have to rely on increasing manpower and material resources to manage student achievement. But manual management is inefficient. . . . . . . Therefore, I want to take this graduation project as an opportunity to develop a general management system for college students' grades, which is not only applicable to all departments of our school, but also applicable to other schools.

I chose my alma mater to design this system for two main reasons:

One is:. . . . . . . Report.

1.2 project development objectives

Establish a student achievement management system, use computers to manage students' achievements, and further improve the efficiency and modernization level of running schools. Help teachers improve their work efficiency and realize the systematization, standardization and automation of student achievement information management workflow.

Significance of the project 1.3

At present, the management level of college students' grades in China is generally not high, and some of them still stay on the basis of paper media. This kind of management can't adapt to the development of the times because it wastes a lot of manpower and material resources. In today's information age, this traditional management method will inevitably be replaced by a computer-based information management system. If the system can be adopted by schools, it will change the situation of manually managing students' grades in the past, establish a good image of running schools and improve work efficiency.

Technical preparation for 1.4 system development

The present situation and development of 1.4. 1 database technology

Database is a computer software technology that appeared in the late 1960s. Although it has only a history of more than 30 years, it still exists in theory and time. . . . . . . . . . . . . . . . . . . . . . . . . . . .

2, information query flow chart

user

Grade data table

Category data table

Course data sheet

Student data sheet

Query condition

Query result

Student information entry

Score information entry

Class information entry

Course information input

Figure 2-4 student information query flow chart

3. 1 Brief introduction to the functional requirements of the student achievement inquiry system

The inquiry system of students' grades plays an extremely important role in strengthening the management of students' grades in schools. Due to the expanding enrollment scale and the increasing number of students in colleges and universities, the traditional manual score management is not only heavy workload, but also prone to problems.

3.2 Description of functional requirements

1, user management function

Users are divided into three categories: administrators, teachers and students. Administrators, teachers and students all need to log in with user names and passwords. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Teachers can manage students' information and achievement information from the perspective of students. Student information includes student number, name, class, birthday, gender, address, telephone number and resume. When the teacher double-clicks a student's information with the mouse, it can automatically display the student's academic performance in all courses, and automatically calculate the student's total score and average score. In the achievement information, teachers can add, modify and delete academic achievements. And the report can be printed.

3. Student score checking function

After the student user logs in, students can see their own student information and achievement information. Student information includes student number, name, class, birthday, gender, address, telephone number and resume. The grade information includes the grade information of all courses of the student. . . . . . . . . . . . . . . . . . . . . . . . . .

Private Sub CmdOk_Click()

Dim Conn as the new ADODB. relationship

Dim mlink as a string

mlink = " provider = Microsoft . jet . oledb . 3.5 1； Data source = score.mdb "

Connect. click on the link

Prompt when user name and password are empty.

If Text 1. Text = ""So

MsgBox "please. . . . . . . . . . . . . . . . . . . . . . . . . . . . .

In the frmlogin form, if the user logs in successfully, the MDI main form as shown in Figure 4-3 will appear.

4-3 System Main Form

If it is a student user, some menu items are not available, and only some functions of the system can be run (that is, re-login and information inquiry functions are available). As shown in Figure 4-4.

Option explicit

When changing a recordset, you need to refresh the entire grid control.

Sub-refresh grid ()

grdScan。 Data member = ""

grdScan。 recover one's spirit

if data env . rssql student . state & lt； & gtadStateClosed and then dataenv.rsssqlstudent.close.

DataEnv.rssqlStudent.Open

grdScan。 DataMember = "sqlStudent "

GrdScan。 Referee ... abstract

This paper introduces the present situation of grade management in our school and the general situation of Visual basic6.0 language. This paper focuses on the implementation process of student achievement management system, including system analysis, system investigation, data flow analysis, functional design, database design, system physical configuration scheme, system implementation, system testing and debugging. The main functions of this system are user management, student registration, class information input, student information input, class curriculum input, school professional information input, course information input, student achievement input, teacher information input and data input. . . . . . . . . . . Including functional requirements description, database design and so on. The fourth chapter introduces the concrete implementation of the system. The fifth chapter is the conclusion and experience of this system development.

Student achievement management system, function, characteristics, paper content.

abstract

This paper describes the present situation of grade management in our school and the general situation of Visual basic6.0 language. This paper mainly introduces the realization process of student achievement management system. . . . . . . . . Such as functional requirements description and database design ... and so on. . The concrete implementation of the system is introduced. The fifth chapter is about the conclusion and realization of the system development process.

keyword

Student achievement management system, function, characteristics, paper content

catalogue

abstract

foreword

Chapter 1 Introduction

The development background of 1. 1

1.2 development goals

Significance of the project 1.3

Technical preparation for 1.4 system development

Chapter II System Analysis

2. 1 system requirements analysis

2. 1. 1 systematic investigation

2. 1.2 organizational setup

2. 1.3 user requirements

2. 1.4 system business flow chart

2. 1.5 system design idea

2. 1.6 system design analysis

2. 1.7 system function analysis

2.2 New system logic scheme

2.2. 1 data flow diagram (DFD for short)

data dictionary

2.2.3 Propose a new system logic model.

System boundary

Chapter III System Design

3. 1 Brief introduction to the functional requirements of the student achievement inquiry system

3.2 Description of functional requirements

3.3 System objective requirements

3.4 System Platform Selection

3.5 Database design

3.5. 1 database requirements analysis

3.5.2 Conceptual structure design of database

3.5.3. Logical structure design (transformation from E-R diagram to relational model)

Chapter IV System Implementation

4. 1 Example of program design for each subsystem module

4.2 The purpose and principle of software testing

4.3 subsystem testing

4.4 Software Operation and Conversion

Chapter V Conclusion

thank you

refer to

Chapter I Introduction

1. 1 project development background

In the past few years, the management of students' grades in various schools was basically carried out by hand. With the increase of the scale of each school, the amount of data involved in student achievement management is increasing, and some schools have to rely on increasing manpower and material resources to manage student achievement. But manual management is inefficient. . . . . . . Therefore, I want to take this graduation project as an opportunity to develop a general management system for college students' grades, which is not only applicable to all departments of our school, but also applicable to other schools.

I chose my alma mater to design this system for two main reasons:

One is:. . . . . . . Report.

1.2 project development objectives

Establish a student achievement management system, use computers to manage students' achievements, and further improve the efficiency and modernization level of running schools. Help teachers improve their work efficiency and realize the systematization, standardization and automation of student achievement information management workflow.

Significance of the project 1.3

At present, the management level of college students' grades in China is generally not high, and some of them still stay on the basis of paper media. This kind of management can't adapt to the development of the times because it wastes a lot of manpower and material resources. In today's information age, this traditional management method will inevitably be replaced by a computer-based information management system. If the system can be adopted by schools, it will change the situation of manually managing students' grades in the past, establish a good image of running schools and improve work efficiency.

Technical preparation for 1.4 system development

The present situation and development of 1.4. 1 database technology

Database is a computer software technology that appeared in the late 1960s. Although it has only a history of more than 30 years, it still exists in theory and time. . . . . . . . . . . . . . . . . . . . . . . . . . . .

2, information query flow chart

user

Grade data table

Category data table

Course data sheet

Student data sheet

Query condition

Query result

Student information entry

Score information entry

Class information entry

Course information input

Figure 2-4 student information query flow chart

3. 1 Brief introduction to the functional requirements of the student achievement inquiry system

The inquiry system of students' grades plays an extremely important role in strengthening the management of students' grades in schools. Due to the expanding enrollment scale and the increasing number of students in colleges and universities, the traditional manual score management is not only heavy workload, but also prone to problems.

3.2 Description of functional requirements

1, user management function

Users are divided into three categories: administrators, teachers and students. Administrators, teachers and students all need to log in with user names and passwords. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Teachers can manage students' information and achievement information from the perspective of students. Student information includes student number, name, class, birthday, gender, address, telephone number and resume. When the teacher double-clicks a student's information with the mouse, it can automatically display the student's academic performance in all courses, and automatically calculate the student's total score and average score. In the achievement information, teachers can add, modify and delete academic achievements. And the report can be printed.

3. Student score checking function

After the student user logs in, students can see their own student information and achievement information. Student information includes student number, name, class, birthday, gender, address, telephone number and resume. The grade information includes the grade information of all courses of the student. . . . . . . . . . . . . . . . . . . . . . . . . .

Private Sub CmdOk_Click()

Dim Conn as the new ADODB. relationship

Dim mlink as a string

mlink = " provider = Microsoft . jet . oledb . 3.5 1； Data source = score.mdb "

Connect. click on the link

Prompt when user name and password are empty.

If Text 1. Text = ""So

MsgBox "please. . . . . . . . . . . . . . . . . . . . . . . . . . . . .

In the frmlogin form, if the user logs in successfully, the MDI main form as shown in Figure 4-3 will appear.

4-3 System Main Form

If it is a student user, some menu items are not available, and only some functions of the system can be run (that is, re-login and information inquiry functions are available). As shown in Figure 4-4.

Option explicit

When changing a recordset, you need to refresh the entire grid control.

Sub-refresh grid ()

grdScan。 Data member = ""

grdScan。 recover one's spirit

if data env . rssql student . state & lt； & gtadStateClosed and then dataenv.rsssqlstudent.close.

DataEnv.rssqlStudent.Open

grdScan。 DataMember = "sqlStudent "

grdScan。 Referee ...