基于EXCEL LINK的试卷深度分析

In -Depth Analysis of Test Paper Based on EXCAL LINK

依据教育测量学讨论了试卷质量分析的定量指标,并提出一种基于MATLAB软件的试卷分析方法。EXCEL强于图文表处理而MATLAB则有着强大的数学计算能力。通过EXCEL LINK将EXCEL中的原始数据发送到MATLAB中完成试卷的深度分析与处理。借助MATLAB强大的数据处理能力可极大的减轻试卷分析的难度,从而为教师及教学管理人员进行试卷的自动统计分析带来极大的方便,并给出了具体的实例代码。

The quantitative indexes based on the principle and methods of educational measurement are discussed. A test paper analysis technique using MATLAB software is also proposed here. EXCEL software is adept in graph - text - table presentation and editing while MATLAB is good at mathematic calculation. With Excel Link, the primal data in EXCEL worksheets were sent to MATLAB workspace and operated there to accomplish the complicated analysis of the test paper. Relying on the powerful data process ability of MATLAB, the difficulty of test paper analysis was reduced largely. Thus, the teachers and teaching mangers could achieve the automatic statistic analysis of test paper easily. The example codes are also presented here.