毕业设计-题库与试卷生成系统的设计与开发.doc

题库与试卷生成系统的设计与开发 摘 要：教学效果评价是教学工作的一个重要环节，通常的教学评价方式多为通过试卷进行考试，因而试卷的质量将直接影响到教学评价的结果。一般情况下，教师出试卷时要么到庞大的题库里一道一道的把题目挑选出来，或是从几本相关的书里把题挑选出来组成一份试卷，这样既费时又费力，而且很难保证试题的覆盖面和把握试卷的难度。为了将老师从繁重的命题工作中解放出来，为了提高命题的质量和管理的现代化、科学化、规范化，本文开发一个试卷生成系统。 本文在充分的需求分析基础上，设计和实现了一个试卷生成系统，主要完成了手动生成试卷、自动生成试卷、抽取现有试卷和用户管理等功能。通过测试，系统在Windows 2000／XP/Vista平台下能稳定运行，且基本达到了预期的设计目标，有一定的实用价值。 关键词：试题库；试卷生成；Visual C#；算法 Test Labrary and Paper Generation System Design and Development Abstract ：Value of teaching is an important tathe for teaching,usually a value of teaching is from a exam ,so a quality paper straight touches the value of teaching. The general situation ,teacher thinks out a paper，reach huge exam pool each finds out the question, or shoulder the question together out from several relevant books. Time-consuming and also strenuous like this, and very difficult to guarantee coverage rate and paper degree of difficulty of examination question. Helping the teacher disengages from the burdensome proposition about exam, In order to improve the quality and management proposition of the modern, scientific, standardized, the paper developed a test generation system. Paper Generation System is designed and implemented based on the sufficient needs analysis in this paper,It mainly implements some functions include in manually and automatically generating papers,extrating some of existing papers,maintaining user information and so on ,the system can operate stably in Windows2000/XP/Vista platform ,reach the expected goal and have some practical value. Keywords: test library;paper generation;visual C#；algorithmic 目 录 1 绪论 1 1.1 开发背景与研究现状 1 1.2论文组织 1 2 开发工具简介 2 2.1 Visual C# 2 2.1.1 数据库连接方式 2 2.2 SQL Server2005 4 2.3 SQL 语言 4 3 需求与可行性分析 6 3.1用户需求 6 3.2功能需求 6 3.3 业务流程图 7 3.4 性能需求 7 3.4.1 加载数据效率要求 7 3.4.2 界面风格要求 7 3.5 可行性分析 8 3.5.1 管理可行性 8 3.5.2 经济可行性 8 3.5.3 技术可行性 8 3.6 数据流程分析 8 3.6.1数据流程图 9 3.6.2 数据字典 9 3.7 开发环境 15 3.7.1 软件环境 15 3.7.2 硬件环境 15 4 系统设计 16 4.1 系统功能模块图 16 4.2 数据库设计 18 4.2.1实体E-R图 18