基于网络的高校学生信息管理系统的研究与实现
摘要
随着近年来高校扩招政策的出台,高校办学规模不断扩大,学生数量急剧增加,面对庞大的信息量,如何提高资源的利用率,做到信息的规范管理、科学统计和快速查询,已成为学生信息管理乃至整个学校管理的重点。为此,本文设计开发了一套基于网络的学生信息管理系统。根据高校学生事务管理工作,分析了高校学生管理工作中的实际情况,对学生信息管理系统进行了规划,制定了学生信息管理的数据流程图和数据字典,并在此基础上研究和构建了学生信息管理系统的各功能模块,实现了学生信息管理系统的代码设计。通过对学生信息的采集、传递、储存、加工、维护和使用,来规范高校学生信息管理,将会大大提高学校学生工作管理水平。
系统的功能较强,操作简单,数据可在线输入,数据与信息可分布式共享。使用这一学生管理信息系统,可以方便地进行我校的学生管理,并实现相应的管理功能、查询功能,为学校的统计、分析与决策提供有力的支持。
Nowadays,in the era of Information, Computer Networking has become the powerful motive force in the process of social and economic development. It is significant to improve student information management level by Network technique. At the same time,with the deepening of educational reform of our country and the issued expanding enrollment policy, the number of enrolled students of Universities is increasing rapidly. How to increase the utilization rate and normative management, reasonable statistic and fast search have become the carry focus students' information management department and even the focus of the whole college. In the actual university educational supervisory work, it will be able to raise the school enducational management level and the work efficiency greatly, by gathering, transfaring, storing, processing, maintaining, and using the information of student to regulate the university educational administration and that will come with a higher standard of university student informationmanagement. Therefore, we have designed the student's information management system.
The actual situation of university educational administration work has been analyzed. we have made the plan,the data flow chart and the data dictionary of student information management system. Comparing various foundations above, we also studied and constructed the functional module of student information management system, realizing the code design of it. The work which is finished by the article is as follows:
1.Analyzes the present condition of student management and the contructive target to the future of higher vocational institute, discussing meaning of developingstudents' information management system.
2.Analyzes technique characteristics of C/S mode and B/S mode, and puts forward the software configuring system which takes B/S mode according to InterNet system characteristics of higher vocational institute and makes use of stored procedure and trigger to raise handling efficiency.
3.Makes a comprehensive research on .NET technologe and discusses methods to access database by ADO.NET and to implement certification and authorization by ASP.NET.
4.Carries out data exchange design by XML technique, and forms a standard data exchange platform to make system more open-up and extensible .In the background database management, elaborating how to spread, move, statistics analysis about data
5.Puts forward homologous solution to safe mechanism and performance optimization of InterNet environment.
6.Designs a foundation information user-defined model and a report user-defined model according to students work controller's actual requirement, which is convenient to students work controller to manage foundation information data and to print a report by oneself.
Student information management system is the task which is carried out on basis of the needs of student management, the actual needs of information resources to be shared and the real need when developing the operation. Its ultimate aim is to make student information management realize computerization, wholly Network, information-based and standardization. Through the student information management system, we can make all college students’information transmits normally in LAN and improve the management quality. In addition, we can make full use of the campus Network to make some useful information in one school, even through the InterNet,realize the data flow and utilization which actually highlights the significant role that Network play. The system will mainly complete the followed functions: Student Basic Information Management; Class Information Management; Checking Attendance Management; Punishment Information Management; Commendation Information Management; Daily Management; Comprehensive Evaluation Management; Apartment Management; Subsidizing Management; Quality Development Management and so on. The followings are specific contents.
1. System Maintenance:
System Maintenance is made up of authority maintenance, password maintenance, code maintenance, operating log, system backup, system initialization and system help, etc.
2. Student Basic Information
Student basic information management is one of the most essential and important links. In order to guarantee the whole student basic information integrality and consistency, student basic information data base makes full use of the existed data from the Educational Administration Management System of Chang Chun University. Therefore, the two systems will transmit data through data converting interface to register the student basic information.
3. Class Information
Class information is the essential unit of student work management, which consists of all kinds of student basic information. Only the office workers which deal with the job of student, can check up the total student quantities of each class or the quantities of boys and girls, add or cancel some student information and make an operation when there is the abnormal case with student information. The above-mentioned information will appear automatically.
4. Punishment Information Management
This part is made up of punishment information maintenance and checking statistical analysis function, etc. It can check and find out the punishment information according to the student number, name, academic year, year, gender, college, grade and many combination terms and also output the information. It can also make statistical classifications and print the result, according to the checking information mentioned above.
5. Checking Attendance Information
The teachers need to check attendance for every course and fill out the monitor’s daily list. The student daily working manager of the department will register the attendance information according to the diary so that student working ministry, all the colleges and masters can check the student attendance easily. At the same time, they will punish some corresponding students who break the law, according to the“Student Handbook”.
6. Commendation Information Management
This module mainly realize the information-based office working Network with all kinds of scholarships, grants and the student with excellent work. All the department corresponding persons will report the proper candidate list in the light of regulate forms according to the student work ministry controller’s notice. Then the officer of the student scholarship and grants will audit and then put the records into the student comprehensive evaluation data base.
7. Department Management
Students department is an important link in the student daily management.It is made up of essential information management (story/unit/layer/dormitory/bed), dormitory assignation, dormitory management, dormitory adjustment and some counted situations of students. It can complete the collection and figures about each week/month/semester/academic year of student civilization dormitory and punishment information through the system.
8. Subsidizing Management
It is made up of the configuration of subsidized items、ratios and quota; student applications from the InterNet; poverty students’subsidy; National Grants; Campus Grants; National Loan For Study; checking work between colleges and student work ministry and some other subsidized items maintenance and statistical analysis.
9. Daily Management
It is made up of student identity card transacting business and typing certifications, giving out railway ticket preferential cards, informing, downloading and uploading data, administrating the head of department pillar-box and psychology consulting and so on.
The above technique characteristics get a valid verification in the try running period of system, and make reference for the Network construction of student management work of the other higher vocational institute.This systematic function is relatively strong, and simple to operate.Students can be conveniently managed.This realizes the corresponding functions of management and inquiry function, and offers a strong support for statistics, analysis and making policy of the university.
系统的功能较强,操作简单,数据可在线输入,数据与信息可分布式共享。使用这一学生管理信息系统,可以方便地进行我校的学生管理,并实现相应的管理功能、查询功能,为学校的统计、分析与决策提供有力的支持。
Nowadays,in the era of Information, Computer Networking has become the powerful motive force in the process of social and economic development. It is significant to improve student information management level by Network technique. At the same time,with the deepening of educational reform of our country and the issued expanding enrollment policy, the number of enrolled students of Universities is increasing rapidly. How to increase the utilization rate and normative management, reasonable statistic and fast search have become the carry focus students' information management department and even the focus of the whole college. In the actual university educational supervisory work, it will be able to raise the school enducational management level and the work efficiency greatly, by gathering, transfaring, storing, processing, maintaining, and using the information of student to regulate the university educational administration and that will come with a higher standard of university student informationmanagement. Therefore, we have designed the student's information management system.
The actual situation of university educational administration work has been analyzed. we have made the plan,the data flow chart and the data dictionary of student information management system. Comparing various foundations above, we also studied and constructed the functional module of student information management system, realizing the code design of it. The work which is finished by the article is as follows:
1.Analyzes the present condition of student management and the contructive target to the future of higher vocational institute, discussing meaning of developingstudents' information management system.
2.Analyzes technique characteristics of C/S mode and B/S mode, and puts forward the software configuring system which takes B/S mode according to InterNet system characteristics of higher vocational institute and makes use of stored procedure and trigger to raise handling efficiency.
3.Makes a comprehensive research on .NET technologe and discusses methods to access database by ADO.NET and to implement certification and authorization by ASP.NET.
4.Carries out data exchange design by XML technique, and forms a standard data exchange platform to make system more open-up and extensible .In the background database management, elaborating how to spread, move, statistics analysis about data
5.Puts forward homologous solution to safe mechanism and performance optimization of InterNet environment.
6.Designs a foundation information user-defined model and a report user-defined model according to students work controller's actual requirement, which is convenient to students work controller to manage foundation information data and to print a report by oneself.
Student information management system is the task which is carried out on basis of the needs of student management, the actual needs of information resources to be shared and the real need when developing the operation. Its ultimate aim is to make student information management realize computerization, wholly Network, information-based and standardization. Through the student information management system, we can make all college students’information transmits normally in LAN and improve the management quality. In addition, we can make full use of the campus Network to make some useful information in one school, even through the InterNet,realize the data flow and utilization which actually highlights the significant role that Network play. The system will mainly complete the followed functions: Student Basic Information Management; Class Information Management; Checking Attendance Management; Punishment Information Management; Commendation Information Management; Daily Management; Comprehensive Evaluation Management; Apartment Management; Subsidizing Management; Quality Development Management and so on. The followings are specific contents.
1. System Maintenance:
System Maintenance is made up of authority maintenance, password maintenance, code maintenance, operating log, system backup, system initialization and system help, etc.
2. Student Basic Information
Student basic information management is one of the most essential and important links. In order to guarantee the whole student basic information integrality and consistency, student basic information data base makes full use of the existed data from the Educational Administration Management System of Chang Chun University. Therefore, the two systems will transmit data through data converting interface to register the student basic information.
3. Class Information
Class information is the essential unit of student work management, which consists of all kinds of student basic information. Only the office workers which deal with the job of student, can check up the total student quantities of each class or the quantities of boys and girls, add or cancel some student information and make an operation when there is the abnormal case with student information. The above-mentioned information will appear automatically.
4. Punishment Information Management
This part is made up of punishment information maintenance and checking statistical analysis function, etc. It can check and find out the punishment information according to the student number, name, academic year, year, gender, college, grade and many combination terms and also output the information. It can also make statistical classifications and print the result, according to the checking information mentioned above.
5. Checking Attendance Information
The teachers need to check attendance for every course and fill out the monitor’s daily list. The student daily working manager of the department will register the attendance information according to the diary so that student working ministry, all the colleges and masters can check the student attendance easily. At the same time, they will punish some corresponding students who break the law, according to the“Student Handbook”.
6. Commendation Information Management
This module mainly realize the information-based office working Network with all kinds of scholarships, grants and the student with excellent work. All the department corresponding persons will report the proper candidate list in the light of regulate forms according to the student work ministry controller’s notice. Then the officer of the student scholarship and grants will audit and then put the records into the student comprehensive evaluation data base.
7. Department Management
Students department is an important link in the student daily management.It is made up of essential information management (story/unit/layer/dormitory/bed), dormitory assignation, dormitory management, dormitory adjustment and some counted situations of students. It can complete the collection and figures about each week/month/semester/academic year of student civilization dormitory and punishment information through the system.
8. Subsidizing Management
It is made up of the configuration of subsidized items、ratios and quota; student applications from the InterNet; poverty students’subsidy; National Grants; Campus Grants; National Loan For Study; checking work between colleges and student work ministry and some other subsidized items maintenance and statistical analysis.
9. Daily Management
It is made up of student identity card transacting business and typing certifications, giving out railway ticket preferential cards, informing, downloading and uploading data, administrating the head of department pillar-box and psychology consulting and so on.
The above technique characteristics get a valid verification in the try running period of system, and make reference for the Network construction of student management work of the other higher vocational institute.This systematic function is relatively strong, and simple to operate.Students can be conveniently managed.This realizes the corresponding functions of management and inquiry function, and offers a strong support for statistics, analysis and making policy of the university.
引文
[1]吴健强.浅谈高校学生管理信息化建设的几点认识[J].新疆大学学报(社会科版),2002,30(7): 154-156.
[2]任善拘,段清,何彦彬等.高校学生管理信息系统建设的实践与思考[J].思想战线,1998,增刊:103-106.
[3]樊银亭,何鸿云.基于客户机/服务器体系的二层与三层结构研究[[J].计算机应用研究,2001.
[4]马宏伟,田丽,徐进.校园网络环境下学生管理信息系统的设计与实现[[J].山东建筑工程学院学报,2001.
[5]林风,李维章,赵莉.动态网站设计捷径一ASP[M].西安电子科技大学出版社,2000.
[6]上海德恩计算机技术有限公司支持.Http://www.deen4u.com/chuangyi.asp.
[7]博嘉科技.刘洪海.网络数据库开发实战ASP与电子商务[M].中国铁道出版社,2002
[8] Doug Lowe著,王澜,李朝虎等译.客户服务器使用指南[M].北京:电子工业出版社,1998.
[9] David M Peterson. Microsoft’s .NET framework: New platform for softwaredevelopment.Business Communications Review [J].2002, 32(11): P57-61.
[10]丁贵.ASP及ASP.NET编程基础与实例[M].北京:机械工业出版社,2004.P 192-224.
[11] Simon Robinson等著.C#高级编程(杨浩等译)[M].清华大学出版社,2004.P5-24.
[12] Chris Goode,John Kauff ian. ASP.NET 1.0入门经典一C#编程篇(杨浩译)[M].清华大学出版社2002.P182-200.
[13]何东隆,李美真.精通XML与网页设计高级教程[M].北京:中国青年出版社,2002.
[14] Kouresh Ardestani,Kevin Koffman.高效掌握ADO.NET-C#编程篇(张哲峰译)[M].清华大学出版社2003.
[15]梅中辉,经业枝.NET技术中的数据访问—ADO.NET[J].微型计算机信息2003,19(1):P70—71 .
[16] Kouresh Ardestani,Kevin Koffman.高效掌握ADO.NET-C#编程篇(张哲峰译)[M].清华大学出版社2003.P36—44.
[17]施平安.ASP.NET基础教程一C#案例版[M].清华大学出版社,2004.
[18]刘宁.基于.Net框架的“学土在线”系统的设计与实现:硕士学位论文[D].中国地质大学(北京)2006.
[19]叶安胜.基于.Net架构的WEB数据库访问技术的研究与应用[D]:硕士学位论文.西安:电子科技大学,2004.
[20]马军.ASP.NET 2.0网络应用系统开发[M].人民邮电出版社,2006.
[21]张瑜,李杰,刘跃军.ASP.NET网络应用与开发[M].清华大学出版社,2006.
[22](美)Mike Gunderloy. SQL Server 2005从入门到精通[M].北京:电子工业出版社,2006.
[23] Stephen Walther,汤涛译.ASP.NET揭秘(第二版)[M].中国电力出版社,2004.
[24](意)Dino Esposito.ASP.NET2.0技术内幕[M].清华大学出版社,2006.
[2]任善拘,段清,何彦彬等.高校学生管理信息系统建设的实践与思考[J].思想战线,1998,增刊:103-106.
[3]樊银亭,何鸿云.基于客户机/服务器体系的二层与三层结构研究[[J].计算机应用研究,2001.
[4]马宏伟,田丽,徐进.校园网络环境下学生管理信息系统的设计与实现[[J].山东建筑工程学院学报,2001.
[5]林风,李维章,赵莉.动态网站设计捷径一ASP[M].西安电子科技大学出版社,2000.
[6]上海德恩计算机技术有限公司支持.Http://www.deen4u.com/chuangyi.asp.
[7]博嘉科技.刘洪海.网络数据库开发实战ASP与电子商务[M].中国铁道出版社,2002
[8] Doug Lowe著,王澜,李朝虎等译.客户服务器使用指南[M].北京:电子工业出版社,1998.
[9] David M Peterson. Microsoft’s .NET framework: New platform for softwaredevelopment.Business Communications Review [J].2002, 32(11): P57-61.
[10]丁贵.ASP及ASP.NET编程基础与实例[M].北京:机械工业出版社,2004.P 192-224.
[11] Simon Robinson等著.C#高级编程(杨浩等译)[M].清华大学出版社,2004.P5-24.
[12] Chris Goode,John Kauff ian. ASP.NET 1.0入门经典一C#编程篇(杨浩译)[M].清华大学出版社2002.P182-200.
[13]何东隆,李美真.精通XML与网页设计高级教程[M].北京:中国青年出版社,2002.
[14] Kouresh Ardestani,Kevin Koffman.高效掌握ADO.NET-C#编程篇(张哲峰译)[M].清华大学出版社2003.
[15]梅中辉,经业枝.NET技术中的数据访问—ADO.NET[J].微型计算机信息2003,19(1):P70—71 .
[16] Kouresh Ardestani,Kevin Koffman.高效掌握ADO.NET-C#编程篇(张哲峰译)[M].清华大学出版社2003.P36—44.
[17]施平安.ASP.NET基础教程一C#案例版[M].清华大学出版社,2004.
[18]刘宁.基于.Net框架的“学土在线”系统的设计与实现:硕士学位论文[D].中国地质大学(北京)2006.
[19]叶安胜.基于.Net架构的WEB数据库访问技术的研究与应用[D]:硕士学位论文.西安:电子科技大学,2004.
[20]马军.ASP.NET 2.0网络应用系统开发[M].人民邮电出版社,2006.
[21]张瑜,李杰,刘跃军.ASP.NET网络应用与开发[M].清华大学出版社,2006.
[22](美)Mike Gunderloy. SQL Server 2005从入门到精通[M].北京:电子工业出版社,2006.
[23] Stephen Walther,汤涛译.ASP.NET揭秘(第二版)[M].中国电力出版社,2004.
[24](意)Dino Esposito.ASP.NET2.0技术内幕[M].清华大学出版社,2006.