主 办:北 京 中 医 药 大 学
ISSN 1003-305X CN 11-1349/R

中医教育 ›› 2021, Vol. 40 ›› Issue (3): 63-67.doi: 10.3969/j.issn.1003-305X.2021.03.699

• 教学园地 • 上一篇    下一篇

基于数据库和机器学习技术的高校学生成绩预警系统设计*

张冰珠, 李浩, 侯贺祥, 于海涛, 马星光#   

  1. 北京中医药大学管理学院 北京 100029
  • 收稿日期:2020-09-25 出版日期:2021-05-30 发布日期:2021-06-08
  • 通讯作者: #马星光,男,硕士,副教授
  • 作者简介:张冰珠,女,在读硕士生
  • 基金资助:
    *北京中医药大学教育科学研究专项课题(No.XJZX2020)

Design of early warning system of academic performance at colleges and universities based on database and machine learning technology*

Zhang Bingzhu, Li Hao, Hou Hexiang, Yu Haitao, Ma Xingguang#   

  1. School of Management, Beijing University of Chinese Medicine, Beijing 100029
  • Received:2020-09-25 Online:2021-05-30 Published:2021-06-08

摘要: 运用信息化的手段进行成绩预警,能够减少高校传统成绩预警所带来的巨大工作量,大幅度提高教学管理效率。探讨高校成绩预警的现状,并结合北京中医药大学成绩预警指标,设计高校学生成绩预警数据库系统,提出一种基于机器学习算法的高校学生成绩预警模型。利用北京中医药大学部分学生的成绩数据为总训练集,应用关联规则挖掘课程之间的潜在关联,对存在异常的学生及时进行预警。通过实际数据检验了预警方案的可行性,该预警机制是对现有成绩预警机制的有效改进,使预警能够提前产生,为尽早介入学生不良学业提供了技术支撑,有利于提高学生的学习质量和效果,对教学管理方法的改进和教学质量的提高有着积极的指导意义。

关键词: 成绩预警, 数据库, Access, 机器学习, Apriori算法

Abstract: The application of information-based early warning system of academic performance at colleges and universities can reduce the huge workload of the traditional early warning one thus greatly improve the efficiency of teaching management. This paper discusses the status quo of academic performance early warning system at colleges and universities, designs the early warning system of academic performance based on database for Beijing University of Chinese Medicine (BUCM), and proposes a model of early warning of academic performance based on machine learning algorithm. The system has timely warned the abnormal academic performances and identified the association rules among the potential correlation among courses. The feasibility of the early warning system is tested via data. The system is significant in guiding the improvement of teaching management method and teaching quality.

Key words: early warning of academic performance, database, Access, machine learning, Apriori algorithm

中图分类号: 

  • G642.0