| 摘 要: 教务管理系统是高校必不可少的教学管理软件，随着需求的提升教务管理系统也在不断地升级改造；因新 旧系统数据库的兼容性问题而存在的安全隐患，过渡期间一些高校同时有两套教务管理系统在运行，两个系统中的成绩 如何生成一张完整的毕业生成绩单就成了问题。利用VBA编程手段把从新旧系统中导出的Excel成绩表自动生成每个学 生按学期分布的毕业生成绩单，大大减轻了教务人员的工作负担。文中介绍了有关方法和技术，以对遇到相同或相近问 题的读者有所启示。 |
| 关键词: 毕业生成绩单；生成；软件；教务管理系统；Excel VBA |
|
中图分类号: TP311
文献标识码: A
|
| 基金项目: 2015年新疆师范大学教学团队“大学生信息技术创新教学团队”，新疆师范大学计算机应用技术重点学科. |
|
| Development and Application of the Graduate Transcript Generation Software |
|
MA Zhiming，Yeerken·JALUNMUHAN，ZHAO Qing，Abduryim·TURSUN1,2
|
1.( 1.College of Computer Science and Technology, Xinjiang Normal University, Urumqi 830054, China;2.
2.AltayRadio and Television University, Altay 836500, China )
|
| Abstract: As an indispensable teaching management software application for colleges and universities,the educational administration management system keeps upgrading along with the increased demands.Potential security threats are caused by the compatibility problem between the database of the new system and that of the old.During the period of transition in some colleges,two educational administration management systems are running simultaneously,which brings a new research subject:how to generate a complete graduate transcript from the two systems.This paper adopts VBA to export the grade sheets in all the semesters from Excel and then automatically generate the transcript for each graduate,which effectively eases the workload of educational administrators.The paper elaborates on the method and technology,providing some reference to relative studies and readers in this field. |
| Keywords: graduate transcripts;generation; software;the educational administration management system;excel VBA |
