用Excel进行试题质量分析

The Qualitity Analgsis on Testing Paper Using Excel

在没有考试质量分析软件的情况下,介绍如何使用办公软件Office Excel制作一个试题质量分析的文件,让试题质量分析自动完成,以期能为广大教师提供一个实用的教学辅助工具。

Under the no-corresponding-software circumanstance,this paper mainly uses the simpliest method and the most popular office software i.e Office Excel to let the test questions quality anaylisis finished by itself,this paper also introduces how to use excel file to analyze the test questions＇ quality and makes the teachers use it conveniently,easily and practically.