试题库平台的设计与实现毕业设计论文

试题库平台的设计与实现

——通用试卷生成系统

计算机科学与技术魏婧指导老师：符开耀

摘要：随着当今计算机技术的飞速发展，计算机辅助教育（CAI）正在受到整个教育领域越来越广泛的重视。其中利用计算机进行考试题库的管理作为计算机辅助教育的一个重要分支和重要环节，是实现教考分离，提高学校教学质量的有效方法，因而已成为院校教学改革的重要内容。正是在这样一个背景下，为实现我们湖南科技大学计算机学院课程的教学改革，我们着手开发了一套通用试题库系统软件。

本通用试题库系统是采用当今流行的Visual Basic语言开发而成。经过我们的多次测试，证明本套通用试题库系统软件具有界面友好，易于使用，通用性强的特点，其具有的录入系统，能录入可包含图形的各科目试题，从而生成不同科目的试题库系统，具有自动组卷方式的成卷系统，可以帮助非任课人员轻松地组成一套满意的试卷，还具有试卷编辑打印功能，能对生成的试卷进行再编辑，并可将编辑好的正式试卷打印出来。从而最终实现了考试出题的自动化。

本文主要对通用试题库系统的子系统——通用试卷生成系统的分析和设计进行了详细阐述。通用试卷生成系统采用的是当今最先进的遗传算法组卷，组成的试卷具有高智能性，试题重复度少，难度控制好等特点。

关键词：通用试卷生成系统；数据库；Visual Basic语言；遗传算法

The Design and Implementation on the General Test

Library System

——The General Paper Making System

Computer Science and Technology Wei Jing Tutor：Fu Kaiyao

ABSTRACT：With the development of the computer technique, the Computer Aided Instruction (CAI) is becoming more and more important in the education field .Among them using computer to manage the test library as an important branch of the Computer Aided Instruction is a way to separate the testing and the teaching,in the same time, it also can improve the teaching quality.So this has been an important content of the college reform in education. It is under this background,in order to realize our education reform in the Computer course, that we develop a general test library system.

This system is developed in Visual Basic language. This software has been tested by us and proved it has many characteristics, such as a friendship interface, convenience for using and general-utility. The system can copy all subjects test including graphics and automatically generate diferent test library system, It also has the function to make test paper manually or auto matically. This can help the teacher who doesn't teach the subject to make a satisfying paper. Furthermore the system can edit and print the test paper. It also can reorganize the test paper that has been generated and then print it. The software makes generating test paper automatically be true.

This paper elaborates on the design and analysis of the General Paper Making System which is the sub system of paper making system.The system adoptes one of the most advanced paper-making algorithms,the GA paper-making. So the papers are characteristic of high intellegent,low repetition,adviable difficulty and so on.

Keywords：The General paper making system;Database; VB Language; GA(Genetic Algorithms)

目录

摘要............................................................................................................................................. I ABSTRACT. ............................................................................................................................... II 1 引言 (1)

1.1 研究的背景及意义 (1)

1.1.1 研究试题库系统的背景 (1)

1.1.2 研究试题库系统的意义 (1)

1.2 现有题库系统状况及分析 (1)

1.2.1 现有题库系统状况 (1)

1.2.2 试题库系统实现分析 (2)

1.3 研究通用试题库组卷系统的可行性 (2)

2 开发工具简介 (3)

2.1 Visual Basic 6.0 简介 (3)

2.2 SQL Server 简介 (4)

2.2.1 SQL基础 (4)

2.2.2 SQL Server组件 (5)

2.2.3 SQL语句 (5)

2.2.4 DDL与DML (5)

2.2.5 复杂操作的实现 (6)

2.3 ADO (6)

2.3.1 ADO简介 (6)

2.3.2 部分ADO对象 (7)

2.3.3 ADO存取数据 (7)

3 需求分析 (9)

3.1 系统功能分析 (9)

3.2 系统数据分析 (9)

3.2.1 数据录入和处理的准确性和实时性 (9)

3.2.2 数据的一致性与完整性 (10)

3.2.3 数据的共享性与独立性 (10)

3.3 通用试卷生成系统分析 (10)

3.3.1 试卷生成系统功能分析 (10)

3.3.2 通用试卷生成系统业务流程图 (11)

3.4 通用试卷生成系统的功能特点 (11)

4 系统设计 (13)

4.1 概要设计 (13)

4.2 数据库设计 (13)

4.2.1 系统E-R图 (13)

4.2.2 系统数据表 (14)

4.3 系统主要模块设计 (14)

4.3.1 自动出题模块 (14)

4.3.2 试卷参数分析模块 (15)