Interactive mining for learning analytics by automated generation of pivot table

Abstract

This paper describes a method to reproduce and visualize student course material page views chronologically as a basis for improving lessons and supporting learning analysis. Interactive mining was conducted on Moodle course logs downloaded in an Excel format. The method uses a time-series cross-section (TSCS) analysis framework; in the resulting TSCS table, the page view status of students can be represented numerically across multiple time intervals. The TSCS table, generated by an Excel macro that the author calls TSCS Monitor, makes it possible to switch from an overall, class-wide viewpoint to more narrowly-focused partial viewpoints. Using numerical values and graph, the approach enables a teacher to capture the course material page view status of students and observe student responses to the teacher’s instructions to open various teaching materials. It allows the teacher to identify students who fail to open particular materials during the lesson or who are late opening them.