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

Technical Analysis of Paperless Self-testing System Based on Excel

基于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.