用Excel的数据分析工具分析试卷

Analyze Examination Papers with Data Analysis Tool of Microsoft Excel

本文用Microsoft Excel提供的函数功能和统计分析工具对某科考试的总体试卷进行分析,既方便快捷,又易于操作,且可得到许多有用数据和相关信息,便于用数理统计理论推断考试总体情况,可供教师分析试卷时推广使用。

In this paper the author gives a general analysis for examination papers of a certain subject with the method of function and statistics analysis from Microsoft Excel. This is not only quick and easy to be applied but also convenient to be used to obtain a lot of data and information. And the theory of mathematical statistics can be easily used to infer the general aspects of any examination. This method can be popularized for teachers in analyzing any kinds of examination papers.