毕业设计(论文)说明书
课 题:试卷生成系统设计与开发
院 (系):
专 业:
学生姓名:
学 号:
指导教师单位:
姓 名:
职 称:
题目类型:
理论研究 实验研究 工程设计 工程技术研究 软件开发
2009 年 1 月 8 日
�
摘 要
运用可视化 Delphi 开发出试题自动生成系统.利用其提供的各种面向对象的
开发工具, 建立系统应用原型,然后进行需求迭代,不断修正和改进,直到形成
满意的可行系统。该系统结构良好、使用方便,题库数据输入简单,系统能够实现
人工选题和随机抽题两大功能. 包括后台数据库的建立、维护以及前端应用程序
的开发两个方面。该系统有安全的用户登录模块、方便快捷的浏览界面、易于操
作的功能模块。本文的分析基于知识点的试题库结构基础上,阐述以知识点难度
系数和题型为主要控制参数的组卷算法的建立与实现方法。该系统的运用不仅提
高了教师的工作效率,而且可以实现真正意义上通用性。
关键词:通用试卷;知识点;自动组卷; Delphi; SQL Server;
Summary
This paper describes the design of the structure of the test question
database and the method of the foundation realization of arithmetic of
organizing examination paper with the main controls parameters of content
of exam and coefficient of difficulty and the structure of test question
the examination base is developed by the use of visual tool DELPHI7.0 and
can be used in wide range of applications.
This program adopts the Client/Server model including backstage
supporter foundation and maintain and front two respects of development
of application program of data base mainly. Through so analyse the
situationing, I use DELPHI 6.0 developing instruments and utilize its
various kinds of developing instruments which face the target offered,
it set up and use by prototype systematically within short time at first,
then, Carry on demand change and take the place of, revise and improve
constantly, until forming the user satisfied feasible system to initial
prototype system.This system has secure user entry, convenient scanning
and easy using query 、append and so on. I believe it will meet the
corporation’s satisfaction.
Keyword: examination paper;Delphi;SQL Server
目 录
第一章 概述......................................................................................................................................5
第二章 数据库理论基础和开发工具..............................................................................................6
2.1 数据库理论基础.................................................................................................................6
2.1.1 数据库管系统..........................................................................................................6
2.1.2 数据库系统设计......................................................................................................7
2.1.3 数据库设计范式分析..............................................................................................7
2.2 数据库开发工具.................................................................................................................9
2.2.1 Delphi 7.0 具体特点.................................................................................................9
2.2.2 基本数据库组件......................................................................................................9
2.3 在 Delphi 中通过 BDE 连接数据库................................................................................11
2.4 SQL 语言在 Delphi 中的运用 .........................................................................................12
2.5 本章小节...........................................................................................................................14
第三章 通用试卷生成系统的定义................................................................................................15
3.1 问题的定义.......................................................................................................................15
3.2 可行性分析.......................................................................................................................15
3.3 需求分析...........................................................................................................................18
3.3.1 题库管理................................................................................................................18
3.3.2 试卷管理................................................................................................................18
3.3.3 权限管理................................................................................................................20
第四章 系统的框架分析和设计....................................................................................................21
4.1 系统总体结构设计............................................................................................................21
4.2 试题设计流程....................................................................................................................22
4.3 数据模块窗体及 BDE 的设置..........................................................................................22
4.4 前台用户部分模块设计....................................................................................................22
4.4.1 登陆模块设计.........................................................................................................22
4.4.2 主界面设计.............................................................................................................22
4.5 数据库后台设计................................................................................................................23
4.5.1 数据库表的设计思路 ...........................................................................................23
4.5.2 数据库部分表的列举............................................................................................23
4.6 试卷生成...........................................................................................................................24
4.7 算法概要...........................................................................................................................24
4.7.1 随机策略 ...............................................................................................................26
4.7.2 补偿策略................................................................................................................26
4.7.3 算法描述流程........................................................................................................26
4.8 本章小结............................................................................................................................27
第五章 总结....................................................................................................................................29
参考文献..........................................................................................................................................30
致 谢..............................................................................................................................................31