基于规则的Excel自动阅卷软件的设计与实现  

Based on the Rules of the Design and Implementation of Automatic Marking Software Excel

作　　者：郎博[1] LANG Bo(College of Information Engineering,Zhengzhou University,Zhengzhou,Henan 450001,China)

机构地区：[1]郑州大学信息工程学院,河南郑州450001

出　　处：《教育教学论坛》2016年第43期255-256,共2页Education And Teaching Forum

摘　　要：Excel操作题是计算机基础考试的一个重点考核内容。为了提高Excel操作题的阅卷效率,结合VBA技术,本文设计并实现了通过Excel对象的定义及相应方法、属性的调用与获取,给出VB编程实现Excel自动判卷的基本原理与方法。测试结果表明,系统运行良好,评分准确可靠,可以有效提高教师的阅卷效率,为其他考试阅卷系统的设计提供参考。The examination for Excel operating-question is the emphasis of computer application basis examination.In order to improve the scoring efficiency of Excel operating-question,the auto marking technology is analyzed,and applying VBA to office automatic marking is put forward according to the inner structure features of the document in order to overcome the shortcomings of previous method and the code of VBA for an example of automatic marking of a excel document is given. Test results shows that the system is running wellwhith an accurate score,reliable.It can improve the efficiency of the teacher marking,and marking system design provides a reference for other exams.

关 键 词：VBA 自动阅卷 操作题 EXCEL对象 

分 类 号：G642.41[文化科学—高等教育学]