Abstract:

This work presents the integration of a statistical dashboard in a Learning Management System (LMS). In order to analyze statistical data of the student's qualifications of the distance-learning Institute of the Balearic Islands (IEDIB), we have developed a web tool with a statistical panel. The data source of this statistical panel is extracted from the database of the deployed LMS, Moodle. The statistical panel shows graphs of the student's qualifications and their evolution, pass/dropout rates, etc. This tool allows generating comparative graphs between different levels, courses, and subjects, being useful for e-learning teachers. Additionally, all courses in IEDIB have a homogeneous distribution in terms of learning structure, evaluation activities, etc. All courses have approximately the same number of deliveries, exams, practices and final grade, with only small differences depending on the type of course. This homogeneity not only facilitates the comparison between courses, but also allows integrating future data mining or artificial intelligence algorithms to predict the result of the students, based on their previous and current behavior/results.

In this first phase, we have exhaustively analyzed the data that we can access through Moodle platform. First, we have developed a Moodle academic data import tool that transforms the Moodle data schema into a star schema. The star schema consists of one fact table referencing any number of dimension tables. The star schema is more effective for handling simpler queries. Subsequently, we have developed the web tool with the statistical panel that consults the extracted and transformed data to draw different graphs distributed by types of teaching, areas of knowledge and academic levels. Concluding, this web tool can be very useful to analyze the dropout rate, the progress, and the evolution of the pass and qualifications of each one of the subjects that are taught at the IEDIB.

Keywords:

Dashboards, e-learning, learning analytics.