基于QT的绩点计算器(学生成绩与课程学分计算)的设计

基于QT的绩点计算器(学生成绩与课程学分计算)的设计(任务书,开题报告,外文翻译,论文说明书14500字,程序代码,答辩记录)
摘  要
绩点是根据学生成绩与课程学分计算得出，用于衡量学生对课程掌握程度重要依据，是高校教务信息管理的重要环节。绩点在学生的毕业、学位获取、评优奖学、免试研究生等方面具有重要的指标意义。南京工业大学依据《南京工业大学本科生学分管理规定》对学生绩点进行计算，本文依据上述规定设计并制作一款基于Qt的绩点计算器。
本文首先对系统的功能与需求进行分析，根据用户要求确定了系统的三个主要模块：用户界面模块、文件导入/导出模块、成绩处理模块。其中，用户界面模块可实现用户的基本操作，如菜单、课程选择、成绩及绩点显示等；文件导入/导出模块可将存储学生成绩数据的Excel文件导入并将计算后的绩点以Excel文件格式导出；成绩处理模块负责具体的绩点计算工作。
本文详细介绍了程序设计过程，包括使用Qt的布局管理器设计界面，Qt的信号和槽的使用等。测试的结果表明，系统初步实现绩点计算功能，基本达到了课题设计要求。
关键词：Qt  绩点  Excel  布局

Development of Grade Point Calculator Using Qt
Abstract
The grade point is based on the student achievement and the course credit, which is used to measure the important degree of the students' mastery of the course, which is the important link of the educational information management in colleges and universities. Grade points in the student's graduation, degree acquisition, evaluation of outstanding scholarship, exemption from graduate students have important indicators. Nanjing Tech University based on “Nanjing Tech University undergraduate credit management requirements” to calculate the student points of view, according to the above provisions of the design and production of a Qt-based point of view calculator.
This paper first analyzes the function and requirements of the system, and determines the three main modules of the system according to the user's requirements: user interface module, file import / export module and grade processing module. Among them, the user interface module can achieve the basic operation of the user, such as menu, course selection, performance and grade display, etc .; file import / export module can store student performance data Excel file and the calculated point of view to Excel file Format export; performance processing module is responsible for the specific point of view calculation work.
This article describes in detail the programming process, including the use of Qt layout manager design interface, Qt signal and slot use. The results of the test show that the system initially achieves the performance of the point of view, which basically meets the requirements of the project design.
Key Words : Qt; score point; Excel; Layout
 

目  录
摘  要    I
ABSTRACT    II
第一章 绪 论    1
1.1 引言    1
1.2 需求分析    1
1.3 计算办法    2
1.4 方案分析    3
第二章 界面设计    5
2.1 开发平台    5
2.2 QT的获取    6
2.3 创建工程    6
2.4 布局    6
2.5 用户界面UI    7
2.5.1 放置部件    7
2.5.2 初始化窗口部件    8
2.5.3 窗口部件布局    9
第三章 自定义窗口部件    10
3.1 组合框中添加复选框    10
3.2 给组合框添加项    11
3.3 添加资源文件    12
3.4 实现状态改变    12
第四章 Excel文件的导入导出    14
4.1 Activex技术    14
4.2 Excel文件的读取    14
4.2.1 创建类    15
4.2.2 实现类    17
4.3 将成绩显示到Tableview中    18
4.4 将成绩保存到Excel中    20
第五章 绩点计算    21
5.1 课程筛选    21
5.2 获取绩点    23
5.3计算平均绩点    25
结   语    26
参考文献    27
致   谢    28