|Table of Contents|

Design of the Automatic Marking Algorithm for Excel Document(PDF)

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

Issue:
2007年03期
Page:
70-73
Research Field:
Publishing date:

Info

Title:
Design of the Automatic Marking Algorithm for Excel Document
Author(s):
Peng Zuomin
School of Mathematics and Computer Science,Nanjing Normal University,Nanjing 210097,China
Keywords:
automa tic m ark ing excel do cum en t s ing le applicability
PACS:
TP301.6
DOI:
-
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:
-
Last Update: 2013-06-04