基于大数据的高校学生行为分析可视化系统的设计与实现

Design and Implementation of University Student Behavior Analysis Visualization System based on Big Data

在大数据时代,建立基于大数据技术的学生管理分析系统是必然趋势,同时也是提升学生工作管理效率的重要途径。该文从学生管理工作实际出发,采集学生成绩、考勤、综合素质和图书借阅等信息,通过ETL工具(kettle)抽取、清洗、转换,装载到oracle数据库中储存与管理,通过各类规则库、各类算法进行数据分析和挖掘,将结果通过可视化工具(Echarts等),以图、表等形式呈现出来,以构建基于大数据的学生管理智能分析平台。实践证明,通过设计和开发基于大数据的高校学生行为分析可视化系统,可以对学情进行精准诊断,对学习进行个性化分析、对决策进行智能分析、对违规违纪等进行前置预警,大大提升了学生管理工作水平和教育品质,真正实现因材施教。

In the era of big data,it is an inevitable trend to establish a student management analysis system based on the application of big data technology,and it is also an important way to improve the efficiency of student work management.In this paper,starting from the reality of student management,the information of students’grades,attendance,comprehensive quality and book borrowing is collected,extracted,cleaned and converted by ETL tools,and loaded into oracle database for storage and management.Data analysis and mining are carried out by various algorithms such as rule bases,and the results are presented in graphical and graphical form by visual tools(Echarts,etc),thus realizing theconstruction of intelligent analysis platform for student management of big data application.Practice has proved that by designing and developing the university student behavior analysis and visualization system based on big data,we can accurately diagnose the learning situation,make personalized analysis on learning,make intelligent analysis on decision-making,and give advance warning to violations and disciplines,which greatly improves the management level and education quality of students,and truly realizes teaching students in accordance with their aptitude.