[1]彭作民.EXCEL文档自动阅卷评分算法设计[J].南京师范大学学报(工程技术版),2007,07(03):070-73.
 Peng Zuomin.Design of the Automatic Marking Algorithm for Excel Document[J].Journal of Nanjing Normal University(Engineering and Technology),2007,07(03):070-73.
点击复制

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

南京师范大学学报(工程技术版)[ISSN:1006-6977/CN:61-1281/TN]

卷:
07卷
期数:
2007年03期
页码:
070-73
栏目:
出版日期:
2007-09-30

文章信息/Info

Title:
Design of the Automatic Marking Algorithm for Excel Document
作者:
彭作民;
南京师范大学数学与计算机科学学院 江苏南京210097
Author(s):
Peng Zuomin
School of Mathematics and Computer Science,Nanjing Normal University,Nanjing 210097,China
关键词:
自动阅卷 Excel文档 单向贴近度
Keywords:
automa tic m ark ing excel do cum en t s ing le applicability
分类号:
TP301.6
摘要:
根据EXCEL文档的功能归纳出考核的若干知识点,提出了各个考核知识点的自动阅卷评分算法.通过引入模糊数学中的单向贴近度作为评价EXCEL文档的度量依据,有效地减少了误判.此外,对公式与函数操作考核知识点,设计了一个巧妙的算法,解决了无法穷举标准答案的难题.同时,分析了考生常见的误操作及其引起的关联错误,设计了相应的阅卷容错算法,为EXCEL文档的自动阅卷提供了一种合理和准确的评分方法.
Abstract:
Th is paper introduces know ledge aspects of Ex ce l test accord ing to the func tion o f EXCEL. Autom atic m ark ing a lgor ithm for each know ledge aspects are presented. S ing le app licab ility in fuzzy m athem atics is used as m easure basis to evalua te the resu lt of EXCEL docum en ts, and them istakes ofm ark ing are reduced e ffectively. M oreove r, an ingenious algorithm for know ledge aspect of formu la and func tion ope ra tion is presented, and the d ifficulty to exhaust the standa rd answ er has been so lv ed. Sim ultaneously, a fau lt-to lerant a lgor ithm for corre lative m istake caused by the w rong operation is presented. A com prehensiv e and accurate m ethod is prov ided fo r EXCEL docum en t ma rking.

参考文献/References:

[ 1] 廖恩扬. 面向对象对O ffice 文档操作自动评分[ J]. 计算机应用, 2002, 22( 8): 119-120.
Liao Enyang. Autom ated Office docum enta tion operation based on OOP[ J] . Com pute r Applica tions, 2002, 22 ( 8): 119-120. ( in Chinese)
[ 2] 姚立国, 姚晖. 计算机基础考试中Office操作题自动阅卷的实现[ J] , 四川教育学院学报, 2003, 19( 12): 85-86.
Yao Liguo, YaoH u.i Rea liza tion o f autom atic access ing test papers for o ffice operating questions in e lem en tary com puter ex amina tion [ J]. Journa l o f Sichuan Institute of Educa tion, 2003, 19( 12): 85-86. ( in Chinese)
[ 3] 倪应华. 基于XML自动阅卷算法的设计与实现[ J]. 仪器仪表学报, 2005, 26( 8): 704-705.
N i Y inghua. Rea lization of the a lg rithm fo r autom aticm a rking exam papers on XML[ J]. Ch inese Journa l of Sc ientific Instrum ent, 2005, 26( 8) : 704-705. ( in Ch inese)
[ 4] 赵丽琴. 浅误VBA 在Exce l 2000中的应用[ J]. 成都教育学院学报, 2004, 18( 7): 58-59.
Zhao Liqin. D iscussion o f VBA app lica tion in Exce l 2000[ J]. Journal o f Chengdu College o f Educa tion, 2004, 18 ( 7): 58-59. ( in Chinese)
[ 5] 荣棋. VBA在教学工作中的应用—— 标准化考试阅卷[ J]. 上海应用技术学院学报, 2002, 2( 1): 69-72.
Rong Q .i VBA in teach ing rou tine—— using VBA to m a rk standard ize ex am [ J]. Journa l of Shangha i Institute o f Techno logy, 2002, 2( 1) : 69-72. ( in Chinese)
[ 6] 杨峻, 睢丹. VBA 在Ex ce l中的应用[ J]. 安阳大学学报, 2003( 2): 44-45.
Yang Jun, Sui Dan. Application of VBA to Ex ce l[ J]. Journal of AnyangUn ive rs ity, 2003( 2): 44-45. ( in Ch inese)
[ 7] 张燕姑. 论模糊概念的度量[ J]. 计算机工程与应用, 2004, 40( 14) : 86-88.
Zhang Yangu. On fuzzy measurem ent of fuzzy concept[ J]. Com pute r Eng ineering and App lica tions, 2004, 40( 14): 86-88. ( in Chinese)
[ 8] 王永生. 计算机阅卷中主观题型的单层模糊综合评判[ J] . 青海大学学报, 2000, 18( 3): 46-49.
W ang Yong sheng. Sing lew ay fuzzy com prehension judg e o f the subjective part in checking exam ina tion papers by computers [ J] . Journa l of Q ingha iUn iversity, 2000, 18( 3): 46-49. ( in Ch inese)

备注/Memo

备注/Memo:
作者简介: 彭作民( 1961-) , 讲师, 主要从事网络与数据库系统等方面的教学与研究. E-m ail:zmpeng@ n jnu. edu. cn
更新日期/Last Update: 2013-06-04