运用SPSS、Excel进行试卷质量分析初探

On Analyzing Test Paper's Quality Using SPSS and Excel

本文从高等学校教学水平评估工作的实际需要出发,利用常用的统计分析软件SPSS和电子表格软件Execl对试卷质量进行科学分析。详细介绍试卷质量分析中原始数据录入方法、统计数据方法和分析数据方法,并将所有数据合成得到一份图、数结合的课程试卷分析质量表,为促进教学质量评价提供科学依据,充实高等学校教学水平评估工作的支撑材料。

To meet the need on assessment on teaching level and quality in higher universities and colleges, the writer is engaged in analyzing test paper's quality using SPSS and Excel that we use often.This article gives a detailed introduction about the inputting method of analyzing data in the process of analyzing test paper's quality.the method of counting up data and the method of analyzing data in the process of analyzing test paper's quality.The method is to merge all the data and then get a chart of test paper's quality with a combination of picture and data.