计算机课程教学系统的研究与实现
摘要
教学设计是一种高度创造性的活动，同时又是一种十分繁复的工作，需要花费较多的时间和精力。而且在教学设计中，包含着大量的重复性劳动一不同的教师在传授不同的教学内容时，可能有许多可以互相借鉴或直接使用的教学设计模式。随着信息技术和计算机及网络技术飞速的发展，传统教育面临挑战，以资源共享和双向交互为主要特点的计算机网络平台能突破时间、空间和地域的限制，迎合了广大学生的信息、时代的学习需求，教学辅助平台成为现代教育技术改革与发展的方向。本文阐述了该系统的设计思路和功能分析。根据研究的问题，对网络辅助课堂教学的优点、缺点、目前国内辅助教学平台设计中存在的问题进行研究。结合计算机课学科特点和我校非计算机专业学生的特点，应用多种教学理论、教学策略，设计并开发了计算机课程教学平台。包括系统需求分析和系统的功能设计，数据库设计以及主要ASP页面的设计。而在众多的网络编程技术中，ASP技术是普遍使用的，它是Microsoft提出的一种网络服务器端编程环境。使用它可以创建和运行动态、交互的Web服务器应用程序。开发网络应用程序必须了解两部分内容，即前台的开发工具和后台的数据库。采用了ASP作为开发工具和SQLServer作为后台的数据库，构建了一个能实现在线学习的教学系统。该系统针对计算机文化基础课程的教学而开发的。系统中包括：电子教案、实训作业、理论测试、排行榜、成绩查询、作业上传和数据维护等功能。该设计项目基本上体现了构建一个动态网站所需要的技术。

关键词：B/S，SQLServer，查询，ASP，教学系统

Abstract
Instructional design is a highly creative activity, while at the same time is a very complicated and takes more time and effort. Instructional design and includes a lot of repetitive work in a different teacher taught the content of different teaching, there may be many can learn from each other or direct the use of instructional design model. As information technology and computers and the rapid development of network technology, traditional educational challenges to resource-sharing and two-way interaction for the main features of the computer network platform to break through time, space and geographical constraints, the vast number of students to meet the information age learning needs, teaching aids of modern educational technology platform for reform and development. This paper describes the system design and functional analysis. Based on the problem of network-assisted classroom teaching advantages, disadvantages, the current design of the platform to support teaching of domestic problems in research. Combine the characteristics of the computer class and my school subjects of non-computer science students the characteristics of a variety of teaching the application of theory, teaching strategies, designed and developed a teaching platform for computer courses. Including system requirements analysis and system design, database design, as well as the design of the main ASP page. In a large number of network programming technology, ASP technology is widely used, it is Microsoft made a network server-side programming environment. Use it to create and run dynamic, interactive Web server applications. The development of Web applications need to understand the contents of two parts, namely, the future development tools and back-office database. ASP used as development tools and SQLServer database as a background to build an online learning to achieve the education system. The system is the basis for the computer literacy curriculum developed. Systems include: electronic lesson plans, practical training operations, theory test, list, query results, maintenance of operations and data upload functions. Basically, it reflects the design of the project to build a dynamic website technology needs.
Key words: B / S, SQLServer, inquiries, ASP, teaching system

目 录
摘要I
AbstractIII
第一章绪论1
1.1.研究现状1
1.2.课题研究的意义2
1.3.课题主要研究工作4
第二章教学系统的分析6
2.1.教学系统的优势6
2.2.教学系统的存在不足与分析10
第三章系统设计13
3.1.相关技术概述13
3.1.1.性能需求13
3.1.2.ASP简介14
3.1.3.开发工具Dreamweaver MX20
3.1.4.ActiveX数据对象ADO21
3.1.5.结构化查询语言(SQL)23
3.2.功能设计24
3.3.系统分析26
第四章系统实现28
4.1.数据库设计28
4.1.1.创建数据库28
4.1.2.配置与SQL Ser ver 2000的ODBC连接31
4.1.3.建立数据表结构.36
4.2.系统实现39
4.2.1.注册模块39
4.2.2.登陆模块40
4.2.3.浏览模块42
4.2.4.系统维护模块44
第五章研究工作总结46
5.1.本文总结46
5.2.进一步工作47
参考文献48
致 谢51