年级人员管理系统
年级管理系统是针对年级有好多的班级,而任课教师不怎么多,管理上面也就只是设置一个年级组长并且年级组长还需要代课不是只作管理,在年级组长下的管理人员就是班主任了。所以管理起来很复杂而且难管理、管理负担特别重,所以就想设计一个年级管理系统方便管理而且简单又实用。学生的管理是学校管理工作的核心。每个学生的学习情况代表着以学校的形象,而每个年级的管理方法的好坏,直接影响学校教育的成败。所以年级管理方式的变化至关重要。系统是以Microsoft VB 6.0为开发平台,以VB为核心语言,结合SQLServer-2000采用ODBC技术开发的,主要是对年级信息的管理进行了研究,核心内容是查询功能。本系统共分为三个登录端:学生端、教师端、管理员端。其中学生端可由所有学生使用,教师端面向任课教师,管理员端可由辅导员或班长负责。
设计年级组信息管理系统中包含学生信息界面,教师信息界面,管理者界面和主界面。学生界面提供学生详细信息,包括他的优缺点、特长、从小的学习经历、家庭状况等。要初步拟定对于他的教育方法,将相似的学生标注出来划分组,做适合他们的的教学策略,尽量做到因材施教公平对待每一位学生,无论他们学习好坏。对于他们的学习情况相关人员比如班主任应及时做更新。学生自己也应该定期做自我评定与教育教学评定来对一段时间的学习做个人总结。教师界面提供教师的详细信息,其中应包括他的教学经验在哪方面突出、教学方式更适合于那种特色的学生使用、她的求学经历特殊爱好等。对此作分类,将化分好组的学生再次划分给适合的老师。这样下来既可以达到因材施教又可以最大限度地使用教学资源。教师也应该定时对学生的学习情况和自己的教学情况做总结。说明每一时期的学生对知识的吸收情况和自己教学方的可取与需要改进的地方。管理者界面中可以随时查找每个学生与每个教师的详细信息,以便于查看学生在每个时间段的学习情况和教师每个时间段的教学情况,来随时调整教育教学策略与管理办法。主界面包含所有界面的内容可以随时链接到每个界面的信息。当然管理者要用管理者的账号登陆管理者界面、教师要用教师的账号登陆管理者界面、学生要用管理者的账号登陆学生界面。
关键词:年级信息管理;数据库;查询
Grade management system
The grade management system is to have a lot of classes for the grade, and the teacher of the grade is not much, the management is only set up a grade group leader, and the grade group leader also needs to take the class instead of only for management, the management personnel under the grade group leader is the head teacher. So it's complicated and difficult to manage, and the management burden is especially heavy, so it is simple and practical to design a grade management system. The management of the students is the core of the school management. The study of each student represents the image of the school, and the management method of each grade directly affects the success or failure of the school education. So the way of grade management The change is critical. The system is developed with Microsoft VB 6.0 as the development platform, using VB as the core language, and combining SQL Server-2000 with the development of ODBC technology, mainly the management of grade information, the core content is the query function. The system is divided into three login terminals: the student end, the teacher end and the administrator end. in which the student's end can be used by all the students, the teacher's end faces the teacher, and the administrator's end can be the responsibility of the counselor or the monitor.
The design age group information management system includes the student information interface, the teacher information interface, the manager interface and the main interface. The student interface provides student details, including his/ her strengths and weaknesses, long-term, small learning experience, family status, and so on. To make a preliminary development of his method of education, the similar students can be labeled out to divide the group, do the teaching strategies suitable for them, and try to treat each student to the best of their aptitude, whether or not they are learning or not. For their study, such as the head teacher, should be updated in a timely manner. Students should also conduct self-assessment and education teaching evaluation on a regular basis to study for a period of time Personal summary. The teacher's interface provides the details of the teacher, which should include in which aspect his teaching experience is prominent, the teaching method is more suitable for the students of that kind of characteristic, her study experience special interest and so on. According to the classification, the students of the divided group are divided into the appropriate teachers again. In this way, the teaching resources can be used to the maximum extent due to the material teaching. The teacher should also regularly summarize the students' learning and their teaching situation. Explain the students' absorption of knowledge and the desirability and need of their own teaching party for every period of time. each student and each student can be found at any time in the manager interface In order to check the students' learning situation in each time period and the teacher's teaching situation in each time period, to adjust the teaching strategy and management method at any time. The main interface contains the contents of all interfaces that can be linked to information on each interface at any time. Of course, the manager should log into the manager's interface with the manager's account, the teacher's account should log on to the manager's interface, and the student should log on to the student's interface with the manager's account.
Keywords: grade information management; database; query
目 录
摘 要I
AbstractII
第一章 绪论1
1.1 课题研究背景1
1.2 课题研究目的和任务1
1.3 课题研究的意义2
1.4 论文的主要内容和章节安排2
第二章 运行环境开发工具3
2.1 运行环境3
2.2 开发工具简介3
2.2.1 VB6.0基础3
2.2.2 SQL Server2000数据库基础3
第三章 需求分析与概要设计6
3.1 系统分析6
3.1.1 用户需求分析6
3.1.2 系统结构图6
3.2 数据库设计9
3.2.1 数据库需求分析9
3.2.2 E-R模型9
3.3 系统基本功能15
第四章 系统详细设计16
4.1 具体的数据库逻辑结构设计16
4.2 系统实现20
4.2.1 管理员端的实现20
4.2.1.1系统管理员端登录模块的设计与实现20
4.2.1.2 添加学生界面的设计与实现22
4.2.1.3 添加授课教师界面的设计与实现24
4.2.1.4添加必修课程界面的设计与实现24
4.2.1.5添加选修课程界面的设计与实现26
4.2.1.6添加年级大事记界面的设计与实现27
4.2.1.7添加班干部名单界面的设计与实现28
4.2.2 教师端的实现29
4.2.2.1授课教师信息管理界面的设计与实现29
4.2.2.2教师修改密码界面的设计与实现30
4.2.2.3教师选择授课界面的设计与实现31
4.2.2.4删除已选课程界面的设计与实现32
4.2.2.5必修课信息查询界面的设计与实现34
4.2.2.6登记选修课成绩界面的设计与实现35
4.2.2.7登记必修课成绩界面的设计与实现36
4.2.2.8查询年级大事记界面的设计与实现36
4.2.2.9查询班干部名单界面的设计与实现38
4.2.2.10查询花名册界面的设计与实现39
4.2.3 学生端的实现39
4.2.3.1添加教育背景界面的设计与实现39
4.2.3.2选修课成绩界面的设计与实现40
4.2.3.3必修课成绩界面的设计与实现41
4.2.3.4查询教育背景界面的设计与实现42
4.2.3.5查询联系方式界面的设计与实现43
4.2.3.6按学号查询学生成绩界面的设计与实现43
4.2.3.7条件查询学生成绩界面的设计与实现44
结 论47
参考文献48
致 谢49