基于Excel VBA的试卷质量分析与评价系统

Test paper quality analysis and evaluation system based on Excel VBA

在试卷评价中引入难度、区分度、信度和效度(四度)等数理统计指标,设计和开发能全面反映试卷质量的试卷分析系统。该系统一方面可以对试卷指标进行计算和客观分析,多维评价和发现试卷存在的问题,辅助提高试卷命题质量;另一方面可客观反映教师的教学水平与学生的学习效果,发现教学活动中存在的薄弱环节,促进教学方法的改革。目前该系统已有近600个班次的应用,已经在本单位各学院,各专业全面推广,取得了较好的应用效果。

In the evaluation of test papers,mathematical statistics such as difficulty,discrimination,reliability and validity(four degrees)are introduced,and the test paper analysis system which can fully reflect the quality of test papers is designed and developed.On the one hand,the system can calculate and objectively analyze the four degrees of the test paper,multi-dimensionally evaluate and discover the problems existing in the test paper to help improve the quality of the test paper proposition;on the other hand,it can objectively reflect the teaching level of the teacher and the learning effect of the students,discover the weak links in the teaching activities,promote the reform of teaching methods.At present,the system has nearly 600 shifts of application,and has been widely promoted in various colleges of the author's university and has achieved good application results.