基于Excel的无纸化自测系统的技术分析  

Technical Analysis of Paperless Self-testing System Based on Excel

作　　者：陈秀芳[1] CHEN Xiu-fang(Wuxi Machinery and Electron Higher Professional and Technical School,Wuxi 214028,Jiangsu)

机构地区：[1]无锡机电高等职业技术学校,江苏无锡214028

出　　处：《电脑与电信》2018年第10期22-24,共3页Computer & Telecommunication

摘　　要：基于Excel无纸化出题系统的设计任务主要源自具体的教学活动过程中的实际需求。在平常的学习过程中,学生要面对大量的练习才能达到对所学知识熟能生巧的地步,而这仅仅依靠课本和课堂是远远不够的。本文研究的课题主要采用的技术有Excel、VBA、Access数据库等,具有操作简单、易于维护、通用性和实用性较强的特点。本系统以小学五年级数学的教学内容为题库,主要实现以下功能:题库管理、用户权限管理、随机出题、计时、自动输出答案、阅卷评分。The paperless test system based on Excel is mainly derived from the specific task of teaching and learning activities in the process of actual demand In the normal learning process,students have to face a lot of practice to achieve the knowledge to the point where practice makes perfect,and it is not enough to solely rely on textbooks and classes.The main technologies used in this paper are Excel,VBA and Access database,which have the characteristics of simple operation,easy maintenance,versatility and practicability.This system takes the teaching content of mathematics in grade 5 as the question bank,and mainly realizes the following functions:question bank management,user authority management,random questions,timing,automatic output of answers and marking.

关 键 词：无纸化出题 Excel VBA ACCESS数据库 

分 类 号：G712[文化科学—职业技术教育学]