摘要
通过对课程考核结果的分析,可以了解该课程的教学效果和学生掌握的程度。在Excel软件中,根据教育测量学和数理统计的原理,对考试结果进行定量研究,计算出试卷的难度、区分度、信度、效度等指标,设计出试卷质量深度分析平台。该平台可对考试的结果作出综合评价,对以后的教学具有指导意义。
The analysis of the course examination results can be used to know the teaching effects of course and the mastery degree of the students. The examination results are quantitatively studied according to the principles of educational measurement and mathematical statistics in Excel.The in-depth analysis platform for exam papers quality is designed to calculatethe difficulty,differentiation, reliability, validity and other indicators of the exam papers. The platform can make a comprehensive evaluation of the examination results, and haveguiding significance for the future teaching.
引文
[1]孟凡丽,于海波.课程实施研究二十年[J].西北师大学报:社会科学版,2003, 40(2):1-5.
[2]郑日昌,漆书清.考试的教育测量学基础[M].北京:高等教育出版社,1990.
[3]王岩.数理统计与Matlab工程数据分析[M].北京:清华大学出版社,2006.
[4]王小燕.MS EXCEL数据分析在成绩分析暨试卷质量评估的应用[J].现代教育技术, 2010, 20(10):135-137.
[5]魏雪萍,李岚.Excel应用大全[M].北京:人民邮电出版社,2008.