| Excel操作题自动阅卷算法的设计与实现 |
| |
| 引用本文： | 刘宇君.Excel操作题自动阅卷算法的设计与实现[J].电脑开发与应用,2014(7):56-60. |
| |
| 作者姓名： | 刘宇君 |
| |
| 作者单位： | 太原工业学院,太原030008 |
| |
| 摘 要： | 根据Excel教学大纲的要求,总结出Excel考核的若干知识点,根据这些知识点提出了基于VBA技术的自动阅卷算法,并引入数据挖掘中的相异度与相似度作为单元格内容评分的度量,使得评分更加科学、合理。同时给出了一个Excel文档自动阅卷实例。
|
| 关 键 词： | 算法 Excel 自动阅卷 相异度 相似度 |
Design and Implementation of Automatic Marking Algorithm on Excel Operation |
| |
| LIU Yu-jun.Design and Implementation of Automatic Marking Algorithm on Excel Operation[J].Computer Development & Applications,2014(7):56-60. |
| |
| Authors: | LIU Yu-jun |
| |
| Affiliation: | LIU Yu-jun;(Taiyuan Institute of Technology; Taiyuan 030008, China) |
| |
| Abstract: | 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. |
| |
| Keywords: | algorithm Excel automatic marking dissimilarity similarity |
| 本文献已被 CNKI 维普 等数据库收录！ |
