| 基于Excel和VBA的试卷生成及评分系统 |
| |
| 引用本文： | 张芸,王继东. 基于Excel和VBA的试卷生成及评分系统[J]. 西昌学院学报(自然科学版), 2014, 0(3): 67-70 |
| |
| 作者姓名： | 张芸 王继东 |
| |
| 作者单位： | 滁州职业技术学院,安徽滁州239000 |
| |
| 基金项目： | 滁州学院教学研究项目（项目编号：2012jyy009）; 滁州职业技术学院院级教学质量与教学改革工程项目（项目编号：zlgc2014029） |
| |
| 摘 要： | 课程考核可以检验学习者的学习水平,检测其对知识或技能的掌握程度,是教学中的一项重要工作。纸质试卷考核需要教师出制试卷、批改试卷、统计分析成绩,对教师来说工作量较大。利用Microsoft Office软件中的Excel组件结合VBA程序设计创建试卷生成及评分系统,具有自动组卷、考试时间设置、评分、分析成绩等功能,可极大提高教师的工作效率。
|
| 关 键 词： | 试卷生成系统 评分系统 Excel VBA 函数 |
Generating and Scoring System of Exam Papers Based on Excel and VBA |
| |
| ZHANG Yun,WANG Ji-dong. Generating and Scoring System of Exam Papers Based on Excel and VBA[J]. Journal of Xichang College, 2014, 0(3): 67-70 |
| |
| Authors: | ZHANG Yun WANG Ji-dong |
| |
| Affiliation: | (Chuzhou Vocational and Technical College, Chuzhou, Anhui 239000) |
| |
| Abstract: | Course examination is an important task in teaching. It can test the learners＆#39; level and detect their mastery of knowledge or skills. Examination requires teachers to make and correct papers, analyze scores. It is a large workload for teachers. A generating and scoring system of exam papers is created by using Excelland VBA programming. The system can make papers automatically, set test times, calculate and analyze scores. It can greatly improve the efficiency of teachers. |
| |
| Keywords: | Excel VBA generating system of exam papers scoring system Excel VBA functions |
| 本文献已被 CNKI 维普 等数据库收录！ |
| 点击此处可从《西昌学院学报(自然科学版)》浏览原始摘要信息 |
|
点击此处可从《西昌学院学报(自然科学版)》下载全文 |
