高校招生管理系统的设计与实现
|
摘要
近年来,随着我国高校改革的不断深入,招生规模在不断扩大,招生工作所用到的数据信息越来越多,越来越细,录取工作核心人员越来越少,时间要求越来越短,安全性能要求也越来越高。为提高整个招生工作的效率,需要不断改善招生管理工作,因此,迫切需要适用‘的招生管理系统的软件,提高工作效率,保证整个招生数据的准确性、完整性,使高等学校招生工作和学生管理工作更加科学化、规范化。高校招生管理系统是为了提高高校招生的工作效率,实现招生工作科学化、制度化管理的有效工具。由于高等学校招生地域的广泛,人数的众多、专业分配复杂、时间限制等问题给高校招生工作带来了很多的不便。因此,招生工作的现代化必然要求招生信息管理的现代化,运用高校招生管理系统来实现对招生信息处理已经成为一种趋势,而且高校招生管理系统已经不能只满足于对数据的简单处理和查询等功能,而应该为招生工作提供有效辅助。
文章完成高校招生管理系统的设计,并对历年招生信息产生的数据建立数据仓库,对历年产生的招生数据进行了集中和整合。本文主要工作有以下两个方面：
1)文章通过分析现有的招生管理系统,及相关高校信息管理系统进行详细研究,分析主要研究工作。初步完成高校招生管理系统开发,包括整个系统的需求分析、系统设计模块的具体实现以及数据库的设计。实现招生信息数据的标准化,提高招生工作的准确性、有效性、公平性,减少招生经费支出,减轻招生人员工作强度。
2)利用SQL Server 2005及其主要的组件对招生数据建立数据仓库,进行OALP分析,对生源的结构进行了分析,以发现考生生源地、年份、报考专业与考生之间的内在关系。最后利用数据挖掘工具,建立决策数模型,分析理工类学生报考科类为分类属性,以考生性别为测试属性进行分类,从而分析理工类学生的报考意向。
With the continuously deepening the reform of high education system,expanding of the enrollment of students,a large number of enrolment data needed to be addressed. To improve the efficiency of the entire enrollment,it's necessary to improve enrollment management continuously,and therefore,there is an urgent need for a complete,and the applicable Enrollment Management System software to alleviate the labor intensity of staffs, to improve work efficiency,and ensure that the entire enrollment data accuracy and completeness. The system will make the student recruiting and management more scientific and standardized. The University Enrollment Management System is intended to improve the efficiency of its students, the students can work to achieve scientific,systematic and effective management tool. The large amount of students recruited from nationwide area is. large,the complexity of major assignment,the time constraints and other issues lead to the recruiting work a lot of trouble. College enrollment data is very important,is the foundational data of university management,and provides the information assurance of the high school information system. Therefore,the use of college and university enrolment management system to achieve the enrollment information processing has become a trend,but college enrollment management system can not just be satisfied with the simple processing of the data and query functions,and should provide an effective recruitment to support decision-making capacity.
The article College Enrollment Management System to complete the design,enrollment information and calendar year data generated by the establishment of data warehouses,the calendar year of enrollment data for a centralized and integrated. This paper work on two aspects;
1) Through analysis of the existing enrollment management systems,and related information management system for colleges and universities conduct a detailed study and analysis of major research work. Initially completed college enrollment management system development,including the whole system needs analysis,system design and realization of the specific module of the database design. Admission to achieve standardization of data,increased enrollment of accuracy,effectiveness,equity,reducing expenditures for students,staff strength to reduce enrollment.
2) The use of SQL Server 2005 and its main components of the BI to establish data warehouse,OALP analysis of the structure of the students were analyzed to find candidates to students,year,specialty and took the intrinsic relationship between the examinee. Finally,use the data mining tools,the establishment of decision-making model of science and engineering students took classified by type of property,to test candidates for the attributes of gender classification,analysis of science and engineering students took the intention.
文章完成高校招生管理系统的设计,并对历年招生信息产生的数据建立数据仓库,对历年产生的招生数据进行了集中和整合。本文主要工作有以下两个方面：
1)文章通过分析现有的招生管理系统,及相关高校信息管理系统进行详细研究,分析主要研究工作。初步完成高校招生管理系统开发,包括整个系统的需求分析、系统设计模块的具体实现以及数据库的设计。实现招生信息数据的标准化,提高招生工作的准确性、有效性、公平性,减少招生经费支出,减轻招生人员工作强度。
2)利用SQL Server 2005及其主要的组件对招生数据建立数据仓库,进行OALP分析,对生源的结构进行了分析,以发现考生生源地、年份、报考专业与考生之间的内在关系。最后利用数据挖掘工具,建立决策数模型,分析理工类学生报考科类为分类属性,以考生性别为测试属性进行分类,从而分析理工类学生的报考意向。
With the continuously deepening the reform of high education system,expanding of the enrollment of students,a large number of enrolment data needed to be addressed. To improve the efficiency of the entire enrollment,it's necessary to improve enrollment management continuously,and therefore,there is an urgent need for a complete,and the applicable Enrollment Management System software to alleviate the labor intensity of staffs, to improve work efficiency,and ensure that the entire enrollment data accuracy and completeness. The system will make the student recruiting and management more scientific and standardized. The University Enrollment Management System is intended to improve the efficiency of its students, the students can work to achieve scientific,systematic and effective management tool. The large amount of students recruited from nationwide area is. large,the complexity of major assignment,the time constraints and other issues lead to the recruiting work a lot of trouble. College enrollment data is very important,is the foundational data of university management,and provides the information assurance of the high school information system. Therefore,the use of college and university enrolment management system to achieve the enrollment information processing has become a trend,but college enrollment management system can not just be satisfied with the simple processing of the data and query functions,and should provide an effective recruitment to support decision-making capacity.
The article College Enrollment Management System to complete the design,enrollment information and calendar year data generated by the establishment of data warehouses,the calendar year of enrollment data for a centralized and integrated. This paper work on two aspects;
1) Through analysis of the existing enrollment management systems,and related information management system for colleges and universities conduct a detailed study and analysis of major research work. Initially completed college enrollment management system development,including the whole system needs analysis,system design and realization of the specific module of the database design. Admission to achieve standardization of data,increased enrollment of accuracy,effectiveness,equity,reducing expenditures for students,staff strength to reduce enrollment.
2) The use of SQL Server 2005 and its main components of the BI to establish data warehouse,OALP analysis of the structure of the students were analyzed to find candidates to students,year,specialty and took the intrinsic relationship between the examinee. Finally,use the data mining tools,the establishment of decision-making model of science and engineering students took classified by type of property,to test candidates for the attributes of gender classification,analysis of science and engineering students took the intention.
引文
[1]教育部高校学生司,清华大学计算机系.全国普通高校招生网上录取系统院校使用手册.2001：50-53
[2](加)Jiawei Han, Micheline Kamber著.范明等译.数据挖掘概念与技术.北京：机械工业出版社,2001.8
[3]薛华成.管理信息系统第3版.北京：清华大学出版社,1999.5
[4]邝孔武.管理信息系统分析与设计.西安电子科技大学出版社,1995.12
[5]薛华成.管理信息系统第3版.北京：清华大学出版社,1999.5
[6]郑人杰,殷人昆,陶永雷.实用软件工程第2版.北京：清华大学出版社,1998.4
[7]曾凡奇.基于Internet的管理信息系统.中国财政经济出版社,2001.8
[8]群力.IT让高考录取人人平等.信息系统工程.2005-06
[9]赵国栋,汪琼.中国、美国及香港地区高校信息化发展状况比较研究.2003-02
[10]史敏.对高校信息化建设的思考.中国高教研究.2005-02
[11]夏明会.我国高校互联网信息资源现状分析和建议.现代远距离教育.现代远程教育研究.2002-4
[12]张红,李生智.利用ASP.NET实现基于B/S结构的查询系统.2004.2
[13]胡业江,张全伙.基于ASP.NET的WEB数据库的分页显示.计算机系统应用.2004.1
[14]耿建勇,鲁士文.微软.NET框架下提取在线Web数据的方法.计算机系统应用.2004.4
[15]秦鑫,朱绍文.微软.NET框架数据访问结构.计算机系统应用.2002.12
[16](美)Reed Jacobson, Stacia Misner著.顾晓波译.清华大学出版社.2007.11
[17]董震,朱晓光,数据仓库实践问题浅析.中国金融电脑,2005.9,61-63
[18]韩家炜,数据挖掘：概念与技术.北京机械工业出版社,2001
[19]杨雪艳,数据挖掘在企业中的应用.中国科技信息研究所硕士学位论文,2004.8
[20]敖广武,数据挖掘技术在教务管理系统中的应用,辽宁科技大学,2007年
[21]赵卫东,《商务智能》,清华大学出版社,2009年
[22]杨兆清.没有围墙的大学：中国大学展开数字校园图景[N].经济观察报,2005209203.
[23]杨晓,任清珍,苏灵.数据仓库、数据集市和数据挖掘[J].现代计算机,1998,(2).
[24]孟凡强.CRM行动手册[M].北京：机械工业出版社,2002.
[25]董荣凤,王海宴,立新立,肖东,大学生素质评测专家系统的开发和应用[J].中国管理科学,2000,(8).
[26]Inmon,W1H1王志海等译1数据仓库[M]1北京：机械工业出版社,2003：201
[27]陈京民1数据仓库原理、设计与应用.[M]1北京：中国水利水电出版社,2004：4-61
[28]王珊等1数据仓库技术与联机分析处理[M]1北京：科学出版社,1999：14-231
[29]软件工程导论[M].张海藩.清华大学出版社
[30]SQL数据库设计从入门到精通[M].潇湘工作室.人民邮电出版社2001.10
[31]数据库系统及应用.崔巍编著[M].高等教育出版社
[32]Raghu Ramakrishnan数据库管理系统原理与设计(第三版)[M].周立柱等译.北京：清华大学出版社,2004.
[33]数据库系统教程(第二版)[M].施伯乐等.北京：高等教育出版社,2003.
[34]数据库系统教程[M],施伯乐、汪卫.丁宝康.高等教育出版社2003-08
[35]刘乃丽.精通ASP.NET 2.0+SQL Server 2005项目开发[M].北京：人民邮电出版社,2007
[36]陈冠军.精通ASP.NET 2.0典型模块设计与实现[M].北京：人民邮电出版社,2007
[37]Abraham Silberschatz, et al. Database system Concepts (Fourth Edition). Beijing:China Machine Press,2003.
[38]David M. Kroenke.数据库处理——基础、设计与实现(第八版)[M].施伯乐等译.北京：电子工业出版社,2003.
[39]Thomas Connolly, et al数据库系统——设计、实现与管理(第三版)[M].宁洪等译.北京：电子工业出版社,2004.
[40]Raghu Ramakrishnan.数据库管理系统原理与设计(第三版)[M].周立柱等译.北京：清华大学出版社,2004.
[41]Date C. J. An Introduction to Database system. Addison-Wesley,1995 [M]
[42]Kaner,C.,J.Falk,and H.Q.Nguyen,Testing [M] ComputerSoftware,2nd edition,VanNostrand Reinhold,1993
[2](加)Jiawei Han, Micheline Kamber著.范明等译.数据挖掘概念与技术.北京：机械工业出版社,2001.8
[3]薛华成.管理信息系统第3版.北京：清华大学出版社,1999.5
[4]邝孔武.管理信息系统分析与设计.西安电子科技大学出版社,1995.12
[5]薛华成.管理信息系统第3版.北京：清华大学出版社,1999.5
[6]郑人杰,殷人昆,陶永雷.实用软件工程第2版.北京：清华大学出版社,1998.4
[7]曾凡奇.基于Internet的管理信息系统.中国财政经济出版社,2001.8
[8]群力.IT让高考录取人人平等.信息系统工程.2005-06
[9]赵国栋,汪琼.中国、美国及香港地区高校信息化发展状况比较研究.2003-02
[10]史敏.对高校信息化建设的思考.中国高教研究.2005-02
[11]夏明会.我国高校互联网信息资源现状分析和建议.现代远距离教育.现代远程教育研究.2002-4
[12]张红,李生智.利用ASP.NET实现基于B/S结构的查询系统.2004.2
[13]胡业江,张全伙.基于ASP.NET的WEB数据库的分页显示.计算机系统应用.2004.1
[14]耿建勇,鲁士文.微软.NET框架下提取在线Web数据的方法.计算机系统应用.2004.4
[15]秦鑫,朱绍文.微软.NET框架数据访问结构.计算机系统应用.2002.12
[16](美)Reed Jacobson, Stacia Misner著.顾晓波译.清华大学出版社.2007.11
[17]董震,朱晓光,数据仓库实践问题浅析.中国金融电脑,2005.9,61-63
[18]韩家炜,数据挖掘：概念与技术.北京机械工业出版社,2001
[19]杨雪艳,数据挖掘在企业中的应用.中国科技信息研究所硕士学位论文,2004.8
[20]敖广武,数据挖掘技术在教务管理系统中的应用,辽宁科技大学,2007年
[21]赵卫东,《商务智能》,清华大学出版社,2009年
[22]杨兆清.没有围墙的大学：中国大学展开数字校园图景[N].经济观察报,2005209203.
[23]杨晓,任清珍,苏灵.数据仓库、数据集市和数据挖掘[J].现代计算机,1998,(2).
[24]孟凡强.CRM行动手册[M].北京：机械工业出版社,2002.
[25]董荣凤,王海宴,立新立,肖东,大学生素质评测专家系统的开发和应用[J].中国管理科学,2000,(8).
[26]Inmon,W1H1王志海等译1数据仓库[M]1北京：机械工业出版社,2003：201
[27]陈京民1数据仓库原理、设计与应用.[M]1北京：中国水利水电出版社,2004：4-61
[28]王珊等1数据仓库技术与联机分析处理[M]1北京：科学出版社,1999：14-231
[29]软件工程导论[M].张海藩.清华大学出版社
[30]SQL数据库设计从入门到精通[M].潇湘工作室.人民邮电出版社2001.10
[31]数据库系统及应用.崔巍编著[M].高等教育出版社
[32]Raghu Ramakrishnan数据库管理系统原理与设计(第三版)[M].周立柱等译.北京：清华大学出版社,2004.
[33]数据库系统教程(第二版)[M].施伯乐等.北京：高等教育出版社,2003.
[34]数据库系统教程[M],施伯乐、汪卫.丁宝康.高等教育出版社2003-08
[35]刘乃丽.精通ASP.NET 2.0+SQL Server 2005项目开发[M].北京：人民邮电出版社,2007
[36]陈冠军.精通ASP.NET 2.0典型模块设计与实现[M].北京：人民邮电出版社,2007
[37]Abraham Silberschatz, et al. Database system Concepts (Fourth Edition). Beijing:China Machine Press,2003.
[38]David M. Kroenke.数据库处理——基础、设计与实现(第八版)[M].施伯乐等译.北京：电子工业出版社,2003.
[39]Thomas Connolly, et al数据库系统——设计、实现与管理(第三版)[M].宁洪等译.北京：电子工业出版社,2004.
[40]Raghu Ramakrishnan.数据库管理系统原理与设计(第三版)[M].周立柱等译.北京：清华大学出版社,2004.
[41]Date C. J. An Introduction to Database system. Addison-Wesley,1995 [M]
[42]Kaner,C.,J.Falk,and H.Q.Nguyen,Testing [M] ComputerSoftware,2nd edition,VanNostrand Reinhold,1993