论文部分内容阅读
毕业证书发放与查询是学校日常管理工作的重要内容,要想知道某位学生是哪一年毕业的,以及是否符合学校毕业证书发放条件,传统的查询方法是采用逐个工作簿查找的方式,工作量大且查询效率低,给教务管理人员的工作带来极大的不便。经过研究发现,学生的毕业信息以及技能鉴定情况均采用Excel表格的形式存放,而Excel提供了强大的编程功能,笔者深入研究了Excel的功能,结合学校实际情况,开发出了毕业证书查询系统,使教务管理人员从机械的、重复的查询工作中解脱出来,提高了工作效率。本文详细介绍基于Excel的毕业证书信息查询系统的设计与制作方法。
Graduation certificate issuance and inquiry is an important part of the daily management of the school. To know which year a student graduated and whether it meets the conditions for issuing a school diploma, the traditional method of inquiry is to use a workbook-by-work search and work Large quantity and low query efficiency bring great inconvenience to the educational administration personnel’s work. After the study found that the graduation information and skills assessment of students are stored in the form of Excel, and Excel provides a powerful programming features, the author in-depth study of the Excel function, combined with the actual situation of the school, developed a diploma query system, The educational administration staff from the mechanical, repeated querying work freed, improve work efficiency. This article describes in detail the graduation certificate information inquiry system design and production method based on Excel.