Automatic data integration from Moodle course logs to pivot tables for time series cross section analysis

This paper describes a data integration method for Moodle course logs and pivot table functions to analyze the behavior of students material page views in face-to-face blended learning using Moodle course materials. The developed method integrates the data with a pivot table by preprocessing Moodle course logs and generates a time series cross section (TSCS) table that visualizes the students course material page views. Experiments conducted on Moodle page views of actual materials collected during actual lessons found that the table visualizes both overall and individual viewpoints. Reactions to teacher instructions on course materials during class can also be visualized by the generated TSCS table. Moreover, because students who open course items late or do not open them can be identified clearly, the method can be used as a reference for improving future classes.

[1]  Pierre Dillenbourg,et al.  Translating Head Motion into Attention - Towards Processing of Student's Body-Language , 2015, EDM.

[2]  Steven Robbins,et al.  Beyond clickers: using ClassQue for multidimensional electronic classroom interaction , 2011, SIGCSE.

[3]  Vania Dimitrova,et al.  CourseVis: Externalising Student Information to Facilitate Instructors in Distance Learning , 2003 .

[4]  Ryan S. Baker,et al.  The State of Educational Data Mining in 2009: A Review and Future Visions. , 2009, EDM 2009.

[5]  R. A. Fisher,et al.  Statistical methods and scientific inference. , 1957 .

[6]  Sebastián Ventura,et al.  Data mining in education , 2013, WIREs Data Mining Knowl. Discov..

[7]  Vania Dimitrova,et al.  CourseVis: A graphical student monitoring tool for supporting instructors in web-based distance courses , 2007, Int. J. Hum. Comput. Stud..

[8]  Erik Duval,et al.  Learning dashboards: an overview and future research opportunities , 2013, Personal and Ubiquitous Computing.

[9]  Arun Sen,et al.  Current trends in web data analysis , 2006, CACM.

[10]  Riccardo Mazza,et al.  GISMO: a Graphical Interactive Student Monitoring Tool for Course Management Systems , 2004 .

[11]  Sebastián Ventura,et al.  Educational Data Mining: A Review of the State of the Art , 2010, IEEE Transactions on Systems, Man, and Cybernetics, Part C (Applications and Reviews).

[12]  Erik Duval,et al.  The student activity meter for awareness and self-reflection , 2012, CHI Extended Abstracts.

[13]  Riccardo Mazza,et al.  Monitoring an Online Course With the GISMO Tool: A Case Study , 2007 .

[14]  Vania Dimitrova,et al.  Visualising student tracking data to support instructors in web-based distance education , 2004, WWW Alt. '04.

[15]  Sebastián Ventura,et al.  Educational data mining: A survey from 1995 to 2005 , 2007, Expert Syst. Appl..

[16]  Nathaniel Beck,et al.  Time‐Series Cross‐Section Methods , 2008 .

[17]  Sebastián Ventura,et al.  Data mining in course management systems: Moodle case study and tutorial , 2008, Comput. Educ..

[18]  Konomu Dobashi.  Time Series Analysis of the in class Page View History of Digital Teaching Materials using Cross Table , 2015, KES.

[19]  Boudewijn F. van Dongen,et al.  The ProM Framework: A New Era in Process Mining Tool Support , 2005, ICATPN.

[20]  Konomu Dobashi,et al.  Development and Trial of Excel Macros for Time Series Cross Section Monitoring of Student Engagement: Analyzing Students' Page Views of Course Materials , 2016, KES.

[21]  Cristóbal Romero,et al.  EDUCATIONAL PROCESS MINING , 2016 .

[22]  Milton Chen.  Visualizing the pulse of a classroom , 2003, MULTIMEDIA '03.

[23]  Agathe Merceron,et al.  Learning Analytics with Excel Pivot Tables , 2012 .