试卷分析论文：试卷分析系统的设计与实现

试卷分析论文：试卷分析系统的设计与实现

【中文摘要】考试分析是教学评价的重要环节,是反映和评估教学效果的重要手段。借助计算机系统进行试卷分析,可方便、快速、准确的进行统计分析,为今后改进出题标准和教学方法提供依据。本文对现阶段的国内外试卷分析系统进行了概要的介绍和分析,根据实际研究提出本课题研究的与意义。借用高等教育试卷分析为例,根据软件工程中自上而下的研发思想,坚持理论与实践相结合,通过对教

育相关理论和软件工程理论的学习,确定了试卷分析的主要指标:平

均分、区分度、难度、信度、标准差等。建构了系统的整体数据流图。对用户管理、信息管理、试卷分析、试卷检验等主要功能模块进行了详细说明,完成了试卷分析系统在计算机中的实现,对试卷做出综合

性的评价。利用VB6.0和SQL Server 2000为工具,引入ADO技术和VBA技术,实现数据录入、数据处理、数据校验、质量分析、教学效果分析等多项功能。难点是利用龙贝格积分算法实现了试卷检验在计算机中实现,并且实现了VBA与excel集成的方式输出报表。本试卷分析系统力求界面直观,简洁,操作灵活方便易懂。本试卷分析系统的建立可以对比教师教学的效果、判断学生学习的情况、鉴定试卷出题的水平。帮教育工作者从繁杂重复性的计算中解脱出来,提高工作效率减轻教育工作者的工作负担。

【英文摘要】Test analysis is an important link of teaching evaluation on showing effects. It can be convenient, fast and

accurate statistical analysis of test paper with the help of the computer. Test analysis Provide the basis for improving test work standard and teaching method in the future.It put forward the research purpose and significance on this system after Studying on the domestic and foreign exam paper analysis system of a simple introduction and analysis in this Article. These are designed in the article that the main index establishment, needs analysis, outline design, detailed design, implementation and testing of such sections, according to the software engineering top-down development ideas and education theory and related knowledge. It Combines with theory and practice as an example of higher education test analysis. The test analysis system is achieved in computer after the construction of the system data flow diagram. The paper gives a comprehensive evaluation. They are described in detail that user management, information management, test paper analysis, test paper test the main function modules. ADO technology and VBA technology is introduced, that completed data entry, quality analysis, inspection, test paper teaching effect analysis and other functions with VB6.0 and SQL Server 2000. It is realized to the test paper test in computer with Romberg integration algorithm. And the realization of the VBA and excel

integrated mode output statements .We show the report to the

user based on the analysis of the test scores of students. It

is intuitive and simple easy to understand that we hope this system.The analysis system of paper can contrast teaching effect, judge the situation of students, and identify the level

test paper. It can save educators from the complicated

repetitive computation. It can improve the educator’s

efficiency and reduce their burden.

【关键词】试卷分析分析指标 VB6.0 SQLServer2000 ADO

【英文关键词】paper analysis analysis indicators VB6.0 SQLServer2000 ADO

【目录】试卷分析系统的设计与实现中文摘要3-4ABSTRACT4第

1章绪论8-121.1 背景分析81.2 现状分析8-91.3 目的和意义

9-101.4 本文主要工作10-111.5 本文的主要内容及结构11-12第2

章相关理论与核心技术的研究12-252.1 相关教育理论12-132.2

软件工程理论132.3 核心技术13-162.3.1 VBA 技术13-142.3.2 SQL SERVER 2000142.3.3 ADO 技术14-162.4 技术指标16-232.4.1 难度

16-172.4.2 区分度17-182.4.3 信度18-202.4.4 效度20-212.4.5

平均分212.4.6 标准差和标准差系数21-222.4.7 学生成绩的正态

分布22-232.5 本章小结23-25第3章需求分析与概要设计

25-403.1 系统需求分析25-323.2 系统概要设计32-353.3 系统数

据库设计35-393.4 本章小结39-40第4章系统详细设计40-494.1