目前,我校的校基金项目申请还在采用传统纸质表格申请方式,数据的格式和有效性需要人工校对;评委必须集中在一起才能评分。而管理员还要人工的整理申请表和统计评委的评分,申请的工作量很大。 本系统是针对河南科技大学基金申请、评委打分以及帐号管理等方面工作而开发信息管理系统。并根据学校的实际要求,分析了学校基金申报及评委打分系统的具体功能,主要是基金申请的全过程、用户需求分析以及系统设计中的技术分析。本系统实现了网上下载word文档填写申请、网上评分、统计结果以及各种用户权限的管理等功能,减轻学校基金申报到立项的工作量,保证了评分及统计的公平性,促进了学校基金申请效率的提高,节约了人力和物力。 教师可以下载word文档在本地填写提交给管理员由管理员入库;评委可以通过校园网随时随地的对申请项目进行打分;管理员通过系统管理各种用户的权限,并提功必要的答疑,公布通过的申请等。本系统使用SQL Server 作为数据库,通过ADO技术连接数据库。 关键词:VBA、完整性、有效性、校验 ABSTRACT Nowadays , the fund item application of the school in my school still adopts the traditional form which used paper. Tata need some people to check whether the format is true and usefulness .The regent must concentrate together to point it ,while the adminstrater also sort the application’s information.The workload of the application is very big. This system beats aspects such as apply for application and the manage account number .According to the actual request of the school, we analyzed the school declare This system carry the management that the word text file fills in the application, on-line grade point and statisticses the result and various customer legal power an so on . function, the fund that eases the school declares the workload of sign the item the equity for statistics, and promoting the fund of the school apply for the exaltation of the efficiency and material resourceses. The teacher can download the word text file and fill in ,then hand over to be store in warehouse by the managing person for managing person;The regent can pass the campus net at any time and anywhere of carry on beating the cent to the a 本文选自毕业设计http://myeducs.cn |