教师教学工作量计算系统开发

论文字数:19797,页数:54 

摘  要
  “教师教学工作量计算系统”是根据教师教学工作量核算办法设计出的一套软件，该软件可以根据提供的源数据计算出教师相应的工作量。目前，各高校为进一步深化教育教学改革，加强教学管理，切实保证教学任务完成，提高教学质量和办学效益，每年都要对教师教学工作量进行，由于计算繁琐，完全由人工完成很容易由于疲劳、疏忽等原因出现错误。该软件不仅能够简化计算，而且节省了很多不必要的重复操作时间，大大便利了实际操作，实用性强。本软件以VB为开发平台，涉及到VB用户界面设计，VB菜单设计，VB自动按要求完成相关计算，VB语言与excel之间的接口问题等。此软件能够从Excel读取数据并将其显示在VB界面的表格中，能让其按要求自动完成计算，同时使用户随时能看到数据的变化，并可以随时保存表格为excel文档。相当实用，具有普遍的现实意义。

关键词：VB用户界面设计、VB菜单设计、VB与excel、教师教学工作量计算系统

Abstract
 Currently, in order to further deepen the educational and teaching reform, strengthen teaching management, ensure the completion of the teaching task, and improve teaching quality and teaching efficiency, colleges and universities have to account teachers’ teaching workload every year. As the calculation is complicated, it will be likely to make mistakes because of fatigue, negligence and so on if it is entirely completed by hand.
 In this thesis, a program, calculating system of teachers’ teaching workload is designed in terms of the accounting approach to teachers’ teaching workload. This software can calculate teachers’ teaching workload basing on the provided data source. The software can not only simplifies calculation process, but also saves a lot of repeated operation time. The software is convenient to operate and has strong practicability. The software is developed using Visual Basic programming language, involving VB user interface design, VB menu design, automatic calculation design, automation server technology of Excel, and so on. The software can import data from Excel sheet and display them on the VB interface, and automatically complete the calculation in terms to the designed algorithm. At the same time, the users can real-time see the changed results when the data sources change, and save form as Excel sheet whenever they want. The software is very practicable and common for application.
 
Keywords： VB user interface design、VB menu design、automation server、 the computing system of teachers' teaching workload.

目 录
摘要 …………………………………………………………………………………………………………… Ⅱ
1  引言 1
1.1  软件概况 1
1.2  论文各章简介 2
2  Visual Basic 3
2.1  VB概述 3
2.1.1  计算机程序设计语言简介 4
2.1.2  程序设计语言的发展 4
2.2  VB语言特点的概括 5
3  相关学习 7
3.1  VB常用工具的学习 7
3.1.1  属性 7
3.1.2  响应的事件 7
3.2  菜单编辑器的学习 8
3.2.1  属性设置区 8
3.2.2  编辑区 9
3.2.3  菜单项显示区 10
3.3  CommonDialog控件的学习 10
3.3.1  控件功能 10
3.3.2  控件使用说明 10
3.3.3  ShowOpen“打开”对话框功能 11
3.4  MSFlexGrid控件的学习 11
3.4.1  MSFlexGrid控件功能 11
3.4.2  MSFlexGrid控件使用说明 11
3.5  For…Next语句的学习 12
4  我校教学工作量核算方法 14
4.1  教学工作量核算原则 14
4.2  教学工作量分类核算依据 14
4.2.1  理论教学 14
4.2.2  实践教学 16
4.2.3  其它工作量 19
4.3  教学研究与教学建设工作量 19
4.4  附  则 24
5  设计程序分析 25
5.1  界面设计分析 25
5.1.1  “帮助”按钮 25
5.1.2  “文件”按钮 27
5.1.2.1  “打开”按钮 27
5.1.2.2  “保存”按钮 31
5.1.2.3  “另存为”按钮 32
5.1.2.4  “退出”按钮 34
5.2  计算方法分析 34
5.2.1  理论人数系数计算 35
5.2.2  理论教学工作量计算 36
5.2.3  实践/实验人数系数计算 38
5.2.4  实践/实验教学工作量计算 40
5.2.5  课程总工作量计算 42
5.2.6  个人总工作量计算 44
6  结论 48
致谢 49
参考文献 50