摘要
介绍了一种利用VBA工具及Office对象模型,分析了Excel文档中对象属性,并将这些属性信息运用于Excel文档的自动阅卷与评分系统,并随时对试题进行添加和更新,实现了考试计时、自动或手动出卷、自动判卷评分、考生的成绩管理统计等功能。
This paper introduces an automatic reading and grading system which use VBA tool and office object model, and analyzes object attribute in the excel document. In the system the questions can be added and updated at any time, and we can use the functions as following, exam timing, automatic or manual setting questions, automatic reading, and managing the scores.
出处
《电脑开发与应用》
2012年第7期32-33,36,共3页
Computer Development & Applications
关键词
VBA
对象属性
自动阅卷与评分
VBA, object attribute, automatic reading and grading