Excel实现的试卷质量分析表  

A System of Quality Analysis Devised for Test Papers by the Use of Excel

作　　者：宣仲良[1] 

机构地区：[1]苏州教育学院信息技术系,江苏苏州215002

出　　处：《江苏大学学报（高教研究版）》2004年第3期88-92,共5页Journal of Jiangsu University:Higher Education Study Edition

摘　　要：试卷质量分析涉及到教育统计与测量方面的专门知识,往往借助于专门的程序设计语言编程来实现。本文介绍用Excel2000实现的试卷质量分析表,重点阐述公式计算、数据有效性验证、数据安全、界面设计等方面的技术细节。Quality analysis of test papers involves special knowledge on educational statistics and measurement and is often realized by computer programs. This paper introduces a system of quality analysis devised for test papers by the use of Excel 2000, and focuses on technologic details for formula operating, data validating, data security and interface designing.

关 键 词：试卷质量分析 Excel 电子表格 教育统计 教育测量 

分 类 号：G424.79[文化科学—课程与教学论] TP391.13[文化科学—教育学]