Excel操作题自动阅卷算法的设计与实现

Design and Implementation of Automatic Marking Algorithm on Excel Operation

根据Excel教学大纲的要求,总结出Excel考核的若干知识点,根据这些知识点提出了基于VBA技术的自动阅卷算法,并引入数据挖掘中的相异度与相似度作为单元格内容评分的度量,使得评分更加科学、合理。同时给出了一个Excel文档自动阅卷实例。

Certain knowledge assessment of Excel is summarized according to the requirements of Excel syllabus.Automatic scoring algorithm based on VBA technology is proposed according to these points,and dissimilarity and similarity of data mining are introduced as grade of cell contents,making the score more scientific and reasonable.An automatic scoring instance of Excel document is given in this paper.