CAJ | 학술논문

为了解决考试质量分析过程中出现的工作效率低、操作难度高、质量分析不够科学等问题，基于Excel对象模型和VBA语言编制了一个考试质量分析模板，通过试题的难度和区分度、考试成绩的正态相关度等指标对考试质量进行分析评价，结合数据分析与问卷调查的方法，自动形成评价意见，并将处理和分析结果统一导出为Word格式的报表．该模板可协助高校教师进行考试成绩处理和质量分析．提高工作效率．
위료해결고시질량분석과정중출현적공작효솔저、조작난도고、질량분석불구과학등문제，기우Excel대상모형화VBA어언편제료일개고시질량분석모판，통과시제적난도화구분도、고시성적적정태상관도등지표대고시질량진행분석평개，결합수거분석여문권조사적방법，자동형성평개의견，병장처리화분석결과통일도출위Word격식적보표．해모판가협조고교교사진행고시성적처리화질량분석．제고공작효솔．
In order to solve the problems of low efficiency, difficult operation and less scientific in the exam quality analysis process, a template based on VBA programming in Excel is designed for exams quality analysis of college. The template analyze and evaluate the quality of the examination by the index of questions difficulty, differentiation index and normal distribution degree, combined with data analysis and survey methods to summarize a comment automatically, export all results to Word format document finally. It can assist university teachers to carry out the exams processing and quality analysis, and improve work efficiency.