| 试卷分析系统的Excel VBA实现 |
| |
| 引用本文： | 张祖芹,丁向民.试卷分析系统的Excel VBA实现[J].淮阴师范学院学报(自然科学版),2014(3):231-234. |
| |
| 作者姓名： | 张祖芹 丁向民 |
| |
| 作者单位： | 盐城师范学院信息科学与技术学院,江苏盐城,224002 |
| |
| 摘 要： | 为了减少试卷分析过程中的重复、繁琐、不规范等情况发生,利用VBA技术在Excel中开发了一种试卷成绩分析系统.该系统利用试题难度、区分度、班级平均分和标准差等参数对试卷进行分析,然后利用数值参数评价表将参数值转化成具体分析的文字表达,最终自动生成集数值、文字、图形为一体的试卷分析表.
|
| 关 键 词： | Excel VBA 试卷分析 成绩系统 |
Design and Implementation of the Test Results Analysis System of Based on Excel VBA |
| |
| ZHANG Zu-qin,DING Xiang-min.Design and Implementation of the Test Results Analysis System of Based on Excel VBA[J].Journal of Huaiyin Teachers College(Natrual Science Edition),2014(3):231-234. |
| |
| Authors: | ZHANG Zu-qin DING Xiang-min |
| |
| Institution: | ( School of Information Science and Technology, Yancheng Teachers University, Yancheng Jiangsu 224002 ) |
| |
| Abstract: | In order to solve the test paper analysis process of repetitive,tedious,non-standard situations,a test score analysis system is developed based on VBA technology in the Excel. The system is based onYancheng Teachers University examination paper analysis. The system analysis content includedifficulty,discrimination,class average and the standard deviation of parameters on the paper. The test paper analysis table is created byconvertingthe parameter value expressionto the analysis text usingnumerical parameters evaluation table,including a set of numerical,text,graphics. |
| |
| Keywords: | Excel VBA analysis of test paper score system |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
