基于VBA的学业提示及学籍变动统计系统设计——以天津职业大学为例

Design of academic tip and demotions accounting system based on VBA:taking Tianjin Vocational University as an example

2017年起,天津职业大学逐步改革推进学分制教学管理方式,在校生每学期的学业提示和每学年的降级情况通过学分相关规定进行统计。而现有教务管理系统目前尚不能提供相应的数据支持,给教学管理人员的统计工作造成极大负担。文章运用Excel VBA开发了一个供教学管理人员使用的学业提示及学籍变动统计系统,具有支持数据表导入、成绩自动分析、特殊数据标注、学分自动汇总、学业情况通知书自动生成等功能,有效提升了工作效率。

Tianjin Vocational Institute has adopted the student status management mode of the credit system since the class of 2017.The statistic of students’academic tip of each semester and demotion of each year is based on the credit system.However,the educational administration system cannot provide corresponding data support.An accounting system of academic tips and demotions based on Excel VBA is designed for teaching administrators,which has the functions of supporting data table import,automatic score analysis,special data annotation,automatic credit summary,and automatic generation of academic status notification and so on,the working efficiency would be effectively improved.