考试题库管理系统的设计与实现.doc

考试题库管理系统的设计与实现
 
摘  要
在传统的试题管理工作中，主要采用人工方式，不利于现代教学的管理，主要表现在试题存储分散，试题归类麻烦和试卷生成不灵活等缺点，因此，以计算机管理的考试题库系统克服了传统人工的缺点。该系统利用ASP.NET技术，结合SQL Sever 2000数据库开发和设计，提供按用户角色方式实现试题的录入、修改和试题输出（生成试卷）的管理。该系统可以对用户所操作的模块和功能进行管理；可以对试题的输入和输出进行管理；可以添加系，并在系内添加专业和课程的分类管理；实现了教师添加试题，需教务科和系审批试题的操作。本系统的独特之处就在于试题审批模块。经过对本系统的测试后，功能基本可以满足教师日常试卷管理的需要。如果进一步详细设计系统后，可以作为一个更专业化的试题管理教学平台。
关键词：试题权限；审批；ASP.NET；SQL Server

 
Design and Implementation of Management System of Test Questions Base
Abstract
In the traditional management work of the exam paper, always take the way of handwork, which doesn’t benefit the modern teaching management because of its disadvantages, including the dispersive storage of test questions, fussy rank of test questions and the formalistic style of test questions. The test questions base system designs based on the computer theory makes up these disadvantages. The base makes the use of ASP.NET technique and integrates the exploitation and design of SQL Server 2000 to provide a procedure to form a paper. The procedure is corresponded to the each customer to input, edit and output the test questions. The system enables us to manage the module and the function operated by the clients. Additionally, we can add the department in the system and manage the different part according to the specialty and the course. Adopt the system, we can add the test questions by teachers and examine and approve the test questions by the educational administration branch and the department. The particular character of the system is the module of examine and approves the test questions.By Being tested, the system almost enables the teachers’ daily work of managing the exam paper. Given a further design, the system could be regarded as a much more professional teaching flat to manage the test question.

Key words: the Examination Permissions; Auditing; ASP.NET; SQL Server
 
目  录
论文总页数：22页

1 引言 1
1.1 选题背景 1
1.2 系统特点 1
2 考试题库管理系统功能分析 1
2.1 用户和用户角色管理 2
2.2 试题录入管理 2
2.3 试题输出管理 3
2.4 专业分类管理 3
2.5 课程分类管理 3
3 考试题库管理系统分析和设计 3
3.1 系统模块设计 3
3.2 用户登录模块 3
3.3 管理模块 4
3.4 自动组卷模块 4
3.5 审批模块 4
3.6 重新登录 4
4 考试题库管理系统数据库设计 4
4.1 用户表 5
4.2 角色表 5
4.3 课程表 5
4.4 单位表 5
4.5 试题表 5
4.6 审批表 6
5 系统详细设计 6
5.1 系统首页面 6
5.2 管理员登录后页面 8
5.3 教务科登录后页面 8
5.4 系管理员登录后页面 9
5.5 教师登录后页面 9
5.6 添加用户页面 10
5.7 添加课程和题型页面 11
5.8 试题添加页面 12
5.9 生成试卷 13
5.10 试题审批 15
6 系统测试分析 17
6.1 测试环境的搭建 17
6.2 测试方案设计 18
6.3 测试结果 19
结    论 19
参考文献 20
致    谢 21