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

Design and Implementation of Automatic Marking Algorithm on Excel Operation

作　　者：刘宇君[1] 

机构地区：[1]太原工业学院,太原030008

出　　处：《电脑开发与应用》2014年第7期56-60,共5页Computer Development & Applications

摘　　要：根据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.

关 键 词：算法 EXCEL 自动阅卷 相异度 相似度 

分 类 号：TP311.52[自动化与计算机技术—计算机软件与理论]