CAJ | 학술논문

为了减少试卷分析过程中的重复、繁琐、不规范等情况发生，利用VBA技术在Excel中开发了一种试卷成绩分析系统。该系统利用试题难度、区分度、班级平均分和标准差等参数对试卷进行分析，然后利用数值参数评价表将参数值转化成具体分析的文字表达，最终自动生成集数值、文字、图形为一体的试卷分析表。
위료감소시권분석과정중적중복、번쇄、불규범등정황발생，이용VBA기술재Excel중개발료일충시권성적분석계통。해계통이용시제난도、구분도、반급평균분화표준차등삼수대시권진행분석，연후이용수치삼수평개표장삼수치전화성구체분석적문자표체，최종자동생성집수치、문자、도형위일체적시권분석표。
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 on-Yancheng Teachers University examination paper analysis.The system analysis content includedifficulty, dis-crimination, 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.