EXCEL文档自动阅卷评分算法设计

Design of the Automatic Marking Algorithm for Excel Document

根据EXCEL文档的功能归纳出考核的若干知识点,提出了各个考核知识点的自动阅卷评分算法.通过引入模糊数学中的单向贴近度作为评价EXCEL文档的度量依据,有效地减少了误判.此外,对公式与函数操作考核知识点,设计了一个巧妙的算法,解决了无法穷举标准答案的难题.同时,分析了考生常见的误操作及其引起的关联错误,设计了相应的阅卷容错算法,为EXCEL文档的自动阅卷提供了一种合理和准确的评分方法.

This paper introduces knowledge aspects of Excel test according to the function of EXCEL. Automatic marking algorithm for each knowledge aspects are presented. Single applicability in fuzzy mathematics is used as measure basis to evaluate the result of EXCEL documents, and the mistakes of marking are reduced effectively. Moreover, an ingenious algorithm for knowledge aspect of formula and function operation is presented, and the difficulty to exhaust the standard answer has been solved. Simultaneously, a fault-tolerant algorithm for correlative mistake caused by the wrong operation is presented. A comprehensive and accurate method is provided for EXCEL document marking.