开放式结构操作类自动阅卷系统的设计与实现
|
摘要
随着社会信息化程度的日益提高，信息技术已经成为中小学生必修的一门学科，操作类的题目必然要用无纸化的考试才能客观反映学生的动手能力和知识的掌握程度。目前，市场上已经有很多考试系统和自动阅卷的系统，这些配套的自动阅卷系统，一般都是用户提出要求，然后由软件设计师绑定试题和试题的标准阅卷信息，最后将成品展示给用户，而用户则不能实现对试题内容及试题标准阅卷信息的管理。
可是，教学是多样化的，信息技术教材的变化又非常快，在教学过程，师生都要面临多次的操作-练习-反馈，对于操作类作业的批改如果用手工，工作量比较大，如果借用现有系统，不能自主命题，题目太旧，没有针对性。
本文规范了阅卷信息，设计了office操作题的教师出题、学生练习后的自动阅卷。在实现系统设计过程中，以PowerPoint为阐述对象，给出阅卷信息规范的两个关键问题：其一是对PowerPoint具体操作进行分类，并且对每一个具体操作进行编号，这是实现系统设计的基础；然后运用阅卷信息语言生成系统生成标准阅卷信息，这是实现系统设计的关键性问题。第二个是自动阅卷系统的实现，运用VB工具，查询、匹配数据库和考生操作的VBA属性值，面向自动阅卷信息数据库中的字段进行编程，不针对固定的操作进行阅卷，真正实现题目的开放。
本系统改进了传统的非开放式的阅卷系统针对具体题目编写阅卷信息，题目改变则要修改阅卷程序代码才能实现自动阅卷的繁琐，采用阅卷程序只与阅卷信息库有关，用户只要修改试题库和阅卷信息库就能实现自动阅卷的方法，实现了由使用者自行对操作类题目命题，并自动产生阅卷信息的开放式系统。
Informationize with society degree's gradually rise, IT already becomes one discipline that primary and secondary school students has to study, the examination questions handling a kind needs getting to work reflecting student through to there being no the examination ability that paper spends objectively surely ability and the knowledge grasping degree. At present, already have many examination system and automation go over examination papers system on the marketplace, these supporting automation go over examination papers systematically, being that the consumer adjures in general, go over examination papers then from software designer binding examination questions and the examination questions standard information, the final general finished product shows to the consumer, but the consumer is the information administration can not come true going over examination papers to examination questions content and the examination questions standard.
Teaching is to diversify but, IT teaching material change is in teaching process very quickly, the operation- exercise that teacher and student all asks to be confronted with many times- couples back, handwork, amount of work are comparatively big, the proposition, examination questions are very old, does not have a pertinence if borrowing now available system, being able to not act on self's own to correcting handling kind school assignment if using.
The main body of a book standard go over examination papers information, the teacher having designed that office handles a problem's set a theme, the student practices automation in the day after tomorrow going over examination papers. In realizing system designing process, take PowerPoint as two $64 questions setting forth a marriage partner, giving an information norm out going over examination papers: One is that concrete operations carries out classification on PowerPoint, carries out a serial number on every concrete operations, this is to realize the basis that system designs and; Apply then go over examination papers information language generation system generates a standard going over examination papers information, this is to realize the critical problem that system designs. Second be systematic realization, the implement wielding VB go over examination papers voluntarily, VBA attribute value that inquiry, data base and examinee mating handle, go over examination papers facing automation syllable in information data base carries out a programming, opening to the outside world going over examination papers, realizing examination questions really specifically for fixed operation is in progress.
This system has improved the tradition must open dyadic going over examination papers systematically going over examination papers specifically for concrete examination questions write information, examination questions changes miscellaneous and trivial state being that procedure code ability realizes an automation going over examination papers ask modification to go over examination papers, adopt to go over examination papers procedure information warehouse has been connected with to going over examination papers only , information warehouse has been therefore likely to realize the method going over examination papers voluntarily as long as the consumer revising item pool and going over examination papers , has come true the information open type is systematic from user proper motion to handling the kind examination questions proposition, and the automation creation going over examination papers.
可是，教学是多样化的，信息技术教材的变化又非常快，在教学过程，师生都要面临多次的操作-练习-反馈，对于操作类作业的批改如果用手工，工作量比较大，如果借用现有系统，不能自主命题，题目太旧，没有针对性。
本文规范了阅卷信息，设计了office操作题的教师出题、学生练习后的自动阅卷。在实现系统设计过程中，以PowerPoint为阐述对象，给出阅卷信息规范的两个关键问题：其一是对PowerPoint具体操作进行分类，并且对每一个具体操作进行编号，这是实现系统设计的基础；然后运用阅卷信息语言生成系统生成标准阅卷信息，这是实现系统设计的关键性问题。第二个是自动阅卷系统的实现，运用VB工具，查询、匹配数据库和考生操作的VBA属性值，面向自动阅卷信息数据库中的字段进行编程，不针对固定的操作进行阅卷，真正实现题目的开放。
本系统改进了传统的非开放式的阅卷系统针对具体题目编写阅卷信息，题目改变则要修改阅卷程序代码才能实现自动阅卷的繁琐，采用阅卷程序只与阅卷信息库有关，用户只要修改试题库和阅卷信息库就能实现自动阅卷的方法，实现了由使用者自行对操作类题目命题，并自动产生阅卷信息的开放式系统。
Informationize with society degree's gradually rise, IT already becomes one discipline that primary and secondary school students has to study, the examination questions handling a kind needs getting to work reflecting student through to there being no the examination ability that paper spends objectively surely ability and the knowledge grasping degree. At present, already have many examination system and automation go over examination papers system on the marketplace, these supporting automation go over examination papers systematically, being that the consumer adjures in general, go over examination papers then from software designer binding examination questions and the examination questions standard information, the final general finished product shows to the consumer, but the consumer is the information administration can not come true going over examination papers to examination questions content and the examination questions standard.
Teaching is to diversify but, IT teaching material change is in teaching process very quickly, the operation- exercise that teacher and student all asks to be confronted with many times- couples back, handwork, amount of work are comparatively big, the proposition, examination questions are very old, does not have a pertinence if borrowing now available system, being able to not act on self's own to correcting handling kind school assignment if using.
The main body of a book standard go over examination papers information, the teacher having designed that office handles a problem's set a theme, the student practices automation in the day after tomorrow going over examination papers. In realizing system designing process, take PowerPoint as two $64 questions setting forth a marriage partner, giving an information norm out going over examination papers: One is that concrete operations carries out classification on PowerPoint, carries out a serial number on every concrete operations, this is to realize the basis that system designs and; Apply then go over examination papers information language generation system generates a standard going over examination papers information, this is to realize the critical problem that system designs. Second be systematic realization, the implement wielding VB go over examination papers voluntarily, VBA attribute value that inquiry, data base and examinee mating handle, go over examination papers facing automation syllable in information data base carries out a programming, opening to the outside world going over examination papers, realizing examination questions really specifically for fixed operation is in progress.
This system has improved the tradition must open dyadic going over examination papers systematically going over examination papers specifically for concrete examination questions write information, examination questions changes miscellaneous and trivial state being that procedure code ability realizes an automation going over examination papers ask modification to go over examination papers, adopt to go over examination papers procedure information warehouse has been connected with to going over examination papers only , information warehouse has been therefore likely to realize the method going over examination papers voluntarily as long as the consumer revising item pool and going over examination papers , has come true the information open type is systematic from user proper motion to handling the kind examination questions proposition, and the automation creation going over examination papers.
引文
[1] 郑衍衡，段汉周，凌捷．Access2000数据库自动阅卷系统的设计与实现[J]．《微型电脑应用》．2001-02：
[2] 白秋产，金春霞．计算机一级考试练习自测系统的设计与实现[J]．《兰州工业高等专科学校学报》．2002-03：
[3] 刘文浩，房培玉．Office宏在考试自动阅卷中的应用[j]．烟台师范学院学报(自然科学版)．2005-03：张海藩．
[4] 骆红波，李舟军，余炳尧，马永进．PowerPoint文档对象分析与自动阅卷的实现[j]．《计算机与现代化》．2006年第2期：
[5] Time工作室．AcceSS 2000[M]．人民邮电出版社．1999-7：
[6] 梁恩主．Visual BasiC 6.0编程与实例解析[M]．科学出版社．2000：
[7] 清汉计算机工作室．Visual Basic 6.0数据库开发实例[M]．机械工业出版社．2000-6：
[8] 何文俊．Visual BasiC 6.0编程实例精解[M]．北京希望电子出版社．2000：
[9] 清宏计算机工作室．Visual Basic编程技巧(多媒体与系统篇) [M]．机械工业出版社．2001-1：
[10] 李桂成，崔军．数据库操作题自动阅卷的设计与实现[J]．《计算机工程与设计》．2004-06：
[11] 王贺艳．《信息技术基础》无纸考试及自动阅卷系统的设计[j]．承德石油高等专科学校学报．2003-12：
[12] 软件工程导论[M]．清华大学出版社．2002-7：
[13] 门槛创作室．Visual Basic 6.0中文版[M]．科学出版社．2000：
[14] 詹国华，姚争为，张量．PowerPoint文档自动阅卷功能的实现[j]．计算机工程与应用．2002-06：
[15] 唐洪彬．Word、Excel自动阅卷系统的设计与实现[j]．宿州教育学院学报．2004-7：
[16] 姚利国，姚晖．计算机基础考试中Office操作题自动阅卷的实现[j]．四川教育学院学报．2003-12：
[17] 宋江，谢深泉．考试系统中Word操作题自动阅卷的实现[j]．湘潭大学自然科学学报．2002-9：
[18] 齐智敏．一个考试系统的设计与实现[j]．辽宁工学院学报．2006-01：
[19] 王春霞．自动阅卷系统的开发[j]．盐城工学院学报(自然科学版)．2002-3：
[20] 中文Access 2000开发使用手册[M]．中国源码中心http://www.CnCode.Com
[21] PowerPoint VBA Section[j]．http://officeone.mvps.org/：
[22] 王余勤．VBA技术在Powerpoint中的应用研究[j]．《中国医学教育技术》2005年04期：
[23] 邵小兵，廖慧芬．Office实践操作自动评分的实现[j]．《计算机与现代化》2005年12期：
[24] 程涛远，董吉文，曲守宁．计算机基础考试系统中Office操作自动评阅的研究[j]．《济南大学学报(自然科学版) 》2001年03期：
[25] 王洁．在线考试系统的设计与开发[j]．山西师范大学学报(自然科学版)2006-06：
[26] 贾志娟，胡明生．计算机考试操作题自动阅卷的实现[j]．《天中学刊》2004年19卷5期 起止页码：46-48页：
[27] 李丁．计算机考试系统中自动评分策略的研究与实现[j]．《计算机与现代化》2002年09期：
[28] 廖恩扬．面向对象对Office文档操作自动评分[j]．《计算机应用》2002年08期：
[29] 赵丽琴．浅谈VBA在Excel2000中的应用[j]．《成都教育学院学报》2004年07期：
[30] 陈红柳．Excel 2000中VBA的应用实例[j]．《职业教育研究》2005年02期
[31] 骆懿玲．Office VBA在CAI系统中的应用[j]．《计算机应用与软件》2003年09期：
[32] 刘文浩，房培玉．Office宏在考试自动阅卷中的应用[j]．《烟台师范学院学报(自然科学版)》2005年03期：
[33] Writing Solid VBA Code. http://www. geekgirls.com/vba_techniques. htm:
[34] Dautenhahn k. The art of designing socially intelligent agents:science, fiction, and the human in the loop. Applied Artificial Intelligenc, 1998, 12:573-617.
[35] Juan Pablo Gonzalez, Cindy Meister, Suat Ozgur, Bill Dilworth (Author). Office VBA Macros You Can Use Today[M]. Material:
[36] Peter G. Aitken. Office XP Development with VBA[M]. Prentice Hall Microsoft Technologies Series:
[37] Robert Smith, Dave Sussman. Beginning Access 2000 VBA[M]:
[2] 白秋产，金春霞．计算机一级考试练习自测系统的设计与实现[J]．《兰州工业高等专科学校学报》．2002-03：
[3] 刘文浩，房培玉．Office宏在考试自动阅卷中的应用[j]．烟台师范学院学报(自然科学版)．2005-03：张海藩．
[4] 骆红波，李舟军，余炳尧，马永进．PowerPoint文档对象分析与自动阅卷的实现[j]．《计算机与现代化》．2006年第2期：
[5] Time工作室．AcceSS 2000[M]．人民邮电出版社．1999-7：
[6] 梁恩主．Visual BasiC 6.0编程与实例解析[M]．科学出版社．2000：
[7] 清汉计算机工作室．Visual Basic 6.0数据库开发实例[M]．机械工业出版社．2000-6：
[8] 何文俊．Visual BasiC 6.0编程实例精解[M]．北京希望电子出版社．2000：
[9] 清宏计算机工作室．Visual Basic编程技巧(多媒体与系统篇) [M]．机械工业出版社．2001-1：
[10] 李桂成，崔军．数据库操作题自动阅卷的设计与实现[J]．《计算机工程与设计》．2004-06：
[11] 王贺艳．《信息技术基础》无纸考试及自动阅卷系统的设计[j]．承德石油高等专科学校学报．2003-12：
[12] 软件工程导论[M]．清华大学出版社．2002-7：
[13] 门槛创作室．Visual Basic 6.0中文版[M]．科学出版社．2000：
[14] 詹国华，姚争为，张量．PowerPoint文档自动阅卷功能的实现[j]．计算机工程与应用．2002-06：
[15] 唐洪彬．Word、Excel自动阅卷系统的设计与实现[j]．宿州教育学院学报．2004-7：
[16] 姚利国，姚晖．计算机基础考试中Office操作题自动阅卷的实现[j]．四川教育学院学报．2003-12：
[17] 宋江，谢深泉．考试系统中Word操作题自动阅卷的实现[j]．湘潭大学自然科学学报．2002-9：
[18] 齐智敏．一个考试系统的设计与实现[j]．辽宁工学院学报．2006-01：
[19] 王春霞．自动阅卷系统的开发[j]．盐城工学院学报(自然科学版)．2002-3：
[20] 中文Access 2000开发使用手册[M]．中国源码中心http://www.CnCode.Com
[21] PowerPoint VBA Section[j]．http://officeone.mvps.org/：
[22] 王余勤．VBA技术在Powerpoint中的应用研究[j]．《中国医学教育技术》2005年04期：
[23] 邵小兵，廖慧芬．Office实践操作自动评分的实现[j]．《计算机与现代化》2005年12期：
[24] 程涛远，董吉文，曲守宁．计算机基础考试系统中Office操作自动评阅的研究[j]．《济南大学学报(自然科学版) 》2001年03期：
[25] 王洁．在线考试系统的设计与开发[j]．山西师范大学学报(自然科学版)2006-06：
[26] 贾志娟，胡明生．计算机考试操作题自动阅卷的实现[j]．《天中学刊》2004年19卷5期 起止页码：46-48页：
[27] 李丁．计算机考试系统中自动评分策略的研究与实现[j]．《计算机与现代化》2002年09期：
[28] 廖恩扬．面向对象对Office文档操作自动评分[j]．《计算机应用》2002年08期：
[29] 赵丽琴．浅谈VBA在Excel2000中的应用[j]．《成都教育学院学报》2004年07期：
[30] 陈红柳．Excel 2000中VBA的应用实例[j]．《职业教育研究》2005年02期
[31] 骆懿玲．Office VBA在CAI系统中的应用[j]．《计算机应用与软件》2003年09期：
[32] 刘文浩，房培玉．Office宏在考试自动阅卷中的应用[j]．《烟台师范学院学报(自然科学版)》2005年03期：
[33] Writing Solid VBA Code. http://www. geekgirls.com/vba_techniques. htm:
[34] Dautenhahn k. The art of designing socially intelligent agents:science, fiction, and the human in the loop. Applied Artificial Intelligenc, 1998, 12:573-617.
[35] Juan Pablo Gonzalez, Cindy Meister, Suat Ozgur, Bill Dilworth (Author). Office VBA Macros You Can Use Today[M]. Material:
[36] Peter G. Aitken. Office XP Development with VBA[M]. Prentice Hall Microsoft Technologies Series:
[37] Robert Smith, Dave Sussman. Beginning Access 2000 VBA[M]: