基于VBA的试卷分析系统研究

Research of Examination Paper Analysis System Based on VBA

针对目前高校试卷分析系统使用不便,可操作性差,文中提出在Excel中嵌入使用VBA编程的方法,配合高校教务管理系统,实现在Excel中自动进行试卷分析。结果表明,该系统能够对较通用的Excel格式成绩文件自动地进行综合分析,直观、形象地输出分析结果;通用性好,可操作性强。

At present, It is inconvenient and unfeasible of using examination paper analysis software in universities. To solve the problem, It is proposed in the article that We can design a examination paper analysis system by using VBA-programming in Excel, This system can accomplish test paper analysis in Excel automatically through using the data of educational administration management system. The experiment indicates that the VBA examination paper analysis system can analyse. xls-documents which include students' scores comprehensively and automatically, and output the result directly and vividly; It is good in Versatility and Feasibility.