基于AutoIt3/VBA的Excel操作题自动批量批改程序的设计

摘要

This paper designs a sort of automatic batch correcting program framework for Excelloperation subjects based on AutoIt3 and VBA.Firstly,according to the checking requirements of Excelloperating skill, it divides the marking points and corresponding score for each subject of Excelloperation subjects,and then it applies VBA to achieve the automatic correcting program for Excelloperation subjects for every single student. Finally,it applies AutoIt3 to implement the automatic batch correcting program for Excelloperation subjects for multiple students.%基于AutoIt3和VBA设计一种针对Excel操作题的自动批量批改程序框架。依据Excel操作技能考核要求对Excel操作题各小题划分评分点和对应分值，应用VBA实现单个学生Excel操作题自动批改程序，并应用AutoIt3实现多个学生Excel操作题自动批量批改程序。