操作题自动评分系统的设计与实现

Design and implementation of automatic scoring system for computer operation question

针对Word2000、Excel2000上机操作题采用手工方式批阅效率偏低问题,首先提出了操作题自动评分系统的设计思想,即先通过设置标准答案系统设置操作题答案,然后启动自动评分系统实现自动评分。介绍了所采用的Visual Basic for Application(VBA)技术、Word对象模型和Excel对象模型,并设计了标准答案数据表和学生成绩表用于存储操作题答案和学生成绩,详细描述了设置标准答案和自动评分系统的实现过程,提出了实现操作题自动评分的一些关键算法并给出了部分源代码。实验结果表明,采用所设计的自动评分系统能够显著提高操作题评分的效率。

Aimed at inefficiency of manually scoring operation question of Word 2000 and Excel 2000, a design idea for automatic scoring system for computer operation question is put forward, that first, setting answer through the system of setting standard answer, then, launching the automatic scoring system to automatically scoring. The adopted technology of visual basic for application （VBA）, word object model and excel object model is briefly introduced. To store standard answer and student score, standard answer table and student score table are created. Then, the realization of setting standard answer and automatic scoring and some important algorithm are described in detail. Some source code is given. The experimental results show the designed system significantly improve the efficiency of scoring computer operation question.