Excel答案非唯一考核点自动阅卷技术分析

摘要

Excel operation of automatic marking,generally through the VBA technology to realize the automatic marking,However,if there is more than one correct results,using existing Excel marking method is prone to marking error.For Excel operation,the correct result is not the only one,is most likely to occur two types,namely criteria range definition and function to use,by way of example,introduces several methods to help accurate marking,including sorting method,equivalent referencing method,enumeration method,special parameter validation method,equivalent condition method.Practice has proved that,if there is more than one correct results,In the automatic marking process,the use of these methods can reduce the appearance of the scoring error and scoring missing,to improve the accuracy of automatic marking.%Excel操作题自动阅卷,一般通过VBA技术实现自动阅卷,然而现有Excel阅卷方法在处理答案非唯一考核点时容易出现阅卷错误.针对Excel操作最可能出现答案非唯一的两种考核点,即条件区域的定义和函数的使用,通过举例,介绍有助于准确阅卷的几种方法,包括排序法、等效引用法、列举法、特殊参数验证法、等效条件法.实践证明,使用这些方法能够减少答案非唯一考核点自动阅卷过程中出现误判、漏判,提高了自动阋卷的准确性.