Student Information Management System of Student Affairs Office
(Software Requirements Statement)
1 Introduction 2
1. 1 writing purpose 2
1.2 background 2
1.3 Definition 2
1.4 Reference 2
2 Task overview 2
2. 1 objective 2
2.2 User characteristics 2
2.3 Assumptions and Constraints 2
3 requirements 2
3. 1 Provisions on Functions 2
3.2 Provisions for other functions 2
3.3 Input and Output Requirements 2
3.4 Data management capability requirements 2
4 Operating Environment Regulations 2
4. 1 equipment 2
4.2 Supporting Software 2
4.3 Interface 2
4.4 Control 2
1 Introduction
The use of 1. 1
With the development of society, the scale of schools is getting bigger and bigger, and the educational management institutions of schools are getting bigger and bigger. In order to make the school manage students' information conveniently, efficiently and dynamically, and improve work efficiency, my research group designed the system, which provides a complete student information management model, including all the basic information of students at school, so that managers can obtain and dynamically process relevant information in time, reducing a lot of expenses and greatly improving work efficiency. It has played a great role in further improving the efficiency of the school and improving the management level of colleges and universities!
1.2 background
Software Name: College Students' Archives Management System
Developers and users: This software is used for XXXX office, and the copyright and use right belong to the developer.
1.3 definition
& lt>
1.4 reference
Visual Basic Programming Course, edited by Yang Li, China Water Conservancy Publishing House, July 2004.
SQL Server 2000 Course, edited by Gong Bo, Beijing Hope Electronic Publishing House, July 2002.
Visual Basic Database System Development Example Navigation, edited by Tamia Liu, People's Posts and Telecommunications Publishing House, June 5438+ 10, 2004.
Introduction to Software Engineering (4th Edition), Zhang, Tsinghua University Publishing House, June 2005.
2 task overview
2. 1 target
With the expansion of college entrance examination, the number of students in our school is increasing rapidly every year, and there will be about 30 thousand to 40 thousand people in Yaohu campus. As an important student management department of the school, the student affairs office includes six functional departments: student affairs office, student management department, student education department, student dormitory management department, psychological counseling center and work-study management center. It is a specialized agency responsible for the education, management and service of school students. Facing the huge student information, the manual and paper management mode gradually highlights more and more disadvantages, such as consuming a lot of manpower, heavy workload, cumbersome work, easy to make mistakes, which is not conducive to work.
Therefore, it has become an urgent task for student management in our school to use computer software to compile a software specially responsible for managing student files and other computer-aided management of student files.
This system is based on the typical m is system (VB+SQL) framework, providing customers with comprehensive student file management. Users can dynamically manage students' information through the system, and all departments of the student affairs office can share relevant data sources, thus realizing data unification, reducing data errors and improving work efficiency. On the other hand, users can import and store the data sources of Excel documents or word documents into the database system through the specific interface provided by the system, and can operate them. And generate related data tables and export them as word or excel documents, which is convenient for printing and submitting documents to higher authorities.
Implementation mode diagram: (group diagram)
Due to the huge information system of the student affairs office, it is difficult for team members to achieve it in a short time. After communicating with the staff of the Student Affairs Office and soliciting the opinions of the tutors, the team members decided to start with the Management Section of the Student Affairs Office to realize a subsystem of the Student Affairs Office, because the Management Section is the basic management of the whole school's student information, and it is also the premise guarantee for all the database materials of all other departments. It can be said that the management system of the management department has been realized, and the interface with other departments has been reserved. It is equivalent to completing half the task of the whole student affairs information system, so we decided to start with the management department and complete the most important step of our project.
Management department system business flow chart:
2.2 User characteristics
The system generally requires users to have a certain level of computer operation: the roles of users are divided into administrators, operators and ordinary users. All users must log in to the system by username and password. If the user name and password cannot be found in the database, the user will not be able to log in to the system.
Users enter the system with different permissions and different functions. If he logs in as an administrator, all the functions of the system can be operated. If he logs in as an operator, he can only operate some of them. If he logs in as an ordinary user, he can only view relevant information, but can't change all information.
2.3 Assumptions and constraints
The system is maintained by the undergraduate development team of Software College.
Development member: Xu Fujun Zeng Hongxing Xi Qingqing Instructor: Zeng Yalin.
Development time: 2005 10-2006 1 month.
3 demand adjustment
3. 1 Provisions on functions
From the business flow chart of the management department above, we quickly got the functional analysis of the management department system. Each marked item can be stored in a table in the database, and the basic table operations can be specified as follows:
1. Basic information of students:
Function description:
● Modification of students' basic information: in the query function, enter the corresponding conditions, find the record you want to modify, and then modify the corresponding fields as needed. The fields that can be modified include student number, name, gender, nationality, date of birth, political outlook, home address, urban marital status, ID number, dormitory address, telephone admission time, university professional education, etc.
● Delete students' basic information: first query the records to be deleted, and then decide whether to delete the whole record or only some fields according to the actual situation. If some fields are deleted, only non-primary keys can be operated. The non-primary key fields are name, gender, nationality, date of birth, political outlook, marital status, home address, ID number, dormitory address and education.
● Add students' basic information: when adding a record, the primary key cannot be blank, otherwise the record will fail to be added.
● Inquiry of students' basic information: in the inquiry conditions, you can find relevant records by entering the inquiry field; If it is a rough query, the first record of all relevant records will be displayed; Then click the button to view all the queried records; If it is a detailed query, records will be displayed.
● Export of students' basic information: The queried data can be exported to generate EXCEL documents, which is convenient for printing and uploading documents.
2. Students' family information
Function description:
● Data source: Import the excel forms filled in and handed in by colleges according to the prescribed format into the corresponding database.
● Query: enter corresponding query conditions to find relevant records.
● Data export: export the tables in the database to excel or word documents.
● Other additions, deletions and modifications are the same as those of the basic table.
3. Students' educational experience
Function description:
● Data source: Import the excel form filled in by the college according to the specified format into the corresponding database.
● Addition, deletion and modification of students' educational experience information: With the change of people's educational level, we can add corresponding attributes to the table accordingly.
Its implementation method is similar to the operation of basic information.
● Query: enter relevant query conditions to find corresponding record information.
● Data export: export the tables in the database in the form of excel or word to facilitate direct printing or submission of documents.
4. Comprehensive evaluation of students' quality-professional achievement table
Function description:
● Basic operations of inputting, deleting and modifying professional performance evaluation information.
●-Query of professional achievement evaluation information: in the query criteria, enter a query field to query related records; It can be divided into precise query and detailed query.
● Export of professional performance evaluation information: query data can be imported into excel or word documents, which is convenient for printing or submitting materials. .
5. Comprehensive evaluation of students' quality-conduct evaluation form
Function description:
● Data source: Import the excel table in the specified format into the corresponding database, so as to dynamically change the corresponding database.
● Query: according to the prompted query conditions, enter the corresponding fields to find the relevant records in the database.
● Data export: query data can be imported into excel or word documents, which is convenient for printing or submitting materials.
● Basic operations of inputting, deleting and modifying conduct evaluation information.
6. Students' comprehensive evaluation form
Function description:
● Data source: Import the excel table in the specified format into the corresponding database, so as to dynamically change the corresponding database data.
● Basic operations of comprehensive evaluation information entry, deletion and modification.
● Query: according to the prompted query conditions, enter the corresponding fields to find the relevant records in the database.
● Data export: query data can be imported into excel or word documents, which is convenient for printing or submitting materials.
7. Scholarship information
Function description:
● Scholarship information addition: enter the newly added scholarship information and related fields according to its format.
● Delete scholarship information: you can delete any scholarship information that has been abolished for various reasons.
● Information query: You can query the relevant scholarship information according to the query conditions.
8. Student incentive information:
Function description:
● Reward information addition: when adding a record, the primary key cannot be blank, otherwise the record addition will fail.
● Delete reward information: first query the record to be deleted, and then decide whether to delete the whole record or only some fields according to the actual situation.
● Reward information modification: in the query function, enter the corresponding conditions, find the record you want to modify, and then modify the corresponding fields as needed.
● Reward information viewing: according to actual needs, enter corresponding conditions in the prompted query conditions to view relevant record information.
● Data export: according to the actual needs, export the fields of related records in the database in the form of excel or word documents, which is convenient for printing.
9. Student discipline information
Function description:
● Discipline information addition: when adding a record, the primary key cannot be blank, otherwise the record addition will fail.
● Disciplinary information deletion: first query the record to be deleted, and then determine whether to delete the whole record or only some fields according to the actual situation.
● Violation information modification: in the query function, enter the corresponding conditions, find the record to be modified, and then modify the corresponding fields as needed.
● View subject information: according to the actual needs, enter the corresponding fields in the prompted query conditions to view the relevant record information.
● Data export: according to the actual needs, export the information recorded in the database in the form of excel or word documents, which is convenient for printing and submitting documents.
10. System management
Function description:
● Add user information: If employees enter the department, they can use this function to increase the corresponding operation authority.
Delete user information: delete the personnel transferred by personnel change and related records, thereby revoking the original operation authority.
● Modify user information: in query criteria, enter the fields to be queried, find out records and modify related fields.
View user information: the administrator views all user information.
3.2 Other functional provisions
1 1. college information table
Function description:
It is mainly the basic operations such as adding, deleting and modifying, and it is the functional authority of the administrator of the whole system, based on each subsystem. When choosing the basic information table operation of other information tables, you must first find your own college.
12. Professional information table
Function description:
It is mainly the basic operations such as adding, deleting and modifying. It is the functional authority of the administrator of the whole system and is based on each subsystem. When choosing the basic information table operation of other information tables, you must first find your own major.
13. Class information table
Function description:
Mainly add, delete, modify and other basic operations, it is the function and authority of the administrator of the whole student affairs office system, and it is based on each subsystem. When selecting the basic information table operation of other information tables, you must first find your own class.
Note: The management of each department of the Student Affairs Office is based on the actual situation of each major and class in each college, including students' basic information, comprehensive evaluation operation and reward information. , managed by each class statistics. Therefore, the information operation of the three tables of colleges, majors and classes is directly set by the system administrator when the whole system is established. Subsystem administrators of other departments can only query and select operations, and cannot modify, delete or add them.
3.3 Input and output requirements
When the user logs in, the data type of the user name must be simplified Chinese and English, other types are not supported, and it cannot exceed 20 characters.
The password input length is no more than 20 characters.
Users must import data sources into the system in a fixed format (such as EXCEL format), or enter data as needed.
All management information can be queried and displayed in the table provided by the system.
If users need it, they can export the required information (such as students and their information) in the required format.
3.4 Data management capability requirements
database administration
● Data import: All documents submitted by the college will be used as the original data source of all information, which can be directly imported into the database to generate data, saving the time of manual entry and greatly improving the work efficiency.
● Database backup: first open the directory file to save the database, and then use. Bak suffix
● Database recovery: If the database loses some data for some reason, you can use the database recovery function to modify the database, thus ensuring the normal operation of the system.
This system establishes a subsystem for each department, but the database is a unified whole. Only one database has been established.
The database of the management department of the Student Affairs Office must include the following tables: user basic information table, student basic information table, student family information table, student resume table, student reward table, punishment table, student professional achievement table, student conduct table, comprehensive evaluation table, college information table, professional information table, class information table, etc. For the convenience of users, detailed information can be established in the database design document.
4 Operating environment regulations
4. 1 equipment and its supporting software
1, hardware requirements
(1) CPU: Celeron 300 or above.
(2) Memory: 128M, 256M is recommended.
(3) Hard disk: The remaining space is required to be greater than 5GB. 2. Operating system requirements
( 1) Windows2000
(2) Windows xp 3 and other software requirements
( 1)Microsoft SQL Server2000
(2) Microsoft Visual Basic 6.0 Chinese version.
(3) Microsoft Office 2003 series office software
4.2 interface
This product is an independent system, and all the contents are self-contained. Through the interface, you can import Excel data sources and print them out in document format. In addition, there is no specific communication protocol support with other software.
Interface between users and software: users must log in to the system through passwords.
Software and hardware interface: The operation of this system must have certain hardware support, such as CPU, memory, hard disk, and corresponding operating system and other software requirements.
Software-to-software interface: Pay attention to the use of global variables and non-global variables when calling between modules.
Accept the physical or logical configuration of any system-based application system. It can describe the physical topological structure of system hardware and system software executed on this structure, as well as the topological structure and communication path of system nodes, components running on nodes, logical units in components, etc.
4.3 control
Import database through Excel. After users with different identities and permissions enter the system, click the menu item "Import Data Source" to enter the interface of importing database and select the Excel data source needed on the host disk. On the other hand, users can export the required data information to Excel or word documents and print them out as needed!
In addition, the estimated cost of this system includes physical equipment such as hardware and computers and software such as (SQL Server+VB)! Therefore, the development of this system has high practicability!
Note: There is still some soil that can't be pasted. You can tell me your E_mail if you need it, and I'll send it to you ~