Moodle for Learning Analytics and Institutional Research: Exporting Data via SQLs and Plugins
Abstract
Nowadays, an increasing number of institutions have begun using learning management systems (LMSs) for online learning, due in particular to the COVID-19 pandemic. Moodle is one of the major open-source LMSs, and is used in many institutions. Although Moodle is able to produce and store robust learning logs, the reporting feature is somewhat deficient. In this study, SQL database queries are used with plugins to gather data directly from the Moodle database. As a result, five SQLs were designed for learning analytics, and four for institutional research. Each report generated from SQL cannot be produced by the standard Moodle report features. Furthermore, SQL plugins have certain specific features for reporting, such as filtering usernames and access restrictions. Although there remains some room for improvement, such as the visualization of reports and enhancement of performance, this SQL-based reporting would be useful for Moodle-based learning analytics and institutional research.
References
G. Siemens and R. S. J. d. Baker, “Learning Analytics and Educational Data Mining:Towards Communication and Collaboration,” in Proceedings of the 2nd International Conference on Learning Analytics and Knowledge, pp. 252–254, 2012.
J. P. Campbell and D. G. Oblinger, “Academic Analytics,” EDUCAUSE Review, 2007.
S. M. Jayaprakash, E. W. Moody, E. J. M. Lauria, J. R. Regan, and J. D. Baron, “Early Alert of Academically At-Risk Students: An Open Source Analytics Initiative,” Journal of Learning Analytics, Vol. 1, No. 1, pp.6–47, 2014.
M. Saqr, U. Fors, M. Tedre, “How Learning Analytics Can Early Predict Under-achieving Students in a Blended Medical Education Course,” Medical Teacher, Vol. 39, No. 7, 2017, pp. 757-767.
M. Yagi, R. Murakami, S. Tsuzuku, M. Suzuki, H. Nakano. K. Suzuki, “Distance Learning for Nurses: Using Learning Analytics to Build a Learning Support Program,” Information and Systems in Education, Vol.19, No.1, 2020, pp.1-8.
S. Yassine, S. Kadry, M. Sicilia, “A Framework for Learning Analytics in Moodle for Assessing Course Outcomes,” 2016 IEEE Global Engineering Education Conference (EDUCON), 2016, pp.261-266.
Y. Asada, M. S. Yagi, “Application of Moodle with Configurable Reports plugin for Learning Analytics and Institutional Research for Education,” Japan Journal of Educational Technology, Vol. 42, Suppl., 2018, pp.121-124 (in Japanese).
Ad-hoc database queries, https://moodle.org/plugins/report_customsql (accessed Oct. 14, 2020)
Custom SQL queries report, Moodle Docs, https://docs.moodle.org/39/en/Custom_SQL_queries_report (accessed Oct. 14, 2020)
Configurable Reports, https://moodle.org/plugins/block_configurable_reports (accessed Oct. 14, 2020)
Configurable reports, Moodle Docs, https://docs.moodle.org/39/en/Configurable_reports (accessed Oct. 14, 2020)
Moodle Docs: ad-hoc contributed reports, Moodle Docs, https://docs.moodle.org/39/en/ad-hoc_contributed_reports (accessed Oct. 14, 2020)
Moodle LMS 3.9 Database, Zoola Analytics, https://moodleschema.zoola.io/ (accessed Oct. 14, 2020)
H5P, https://h5p.org/ (accessed Oct. 14, 2020)
Database activity, https://docs.moodle.org/39/en/Database_activity (accessed Oct. 14, 2020)
B. Nielsen, “Competency-based education features in Moodle,” Proceedings of MoodleMoot Japan 2019 Annual Conference, pp. 6-18.
Model Core Curriculum for Medical Education in Japan, AY 2016 Revision (in English), http://www.mext.go.jp/component/a_menu/education/detail/__icsFiles/afieldfile/2018/06/18/1325989_30.pdf. (accessed Oct. 14, 2020)
Feedback FAQ, Moodle Docs, https://docs.moodle.org/39/en/Feedback_FAQ (accessed Oct. 14, 2020)
Metabase, https://www.metabase.com/ (accessed Oct 14, 2020)
Apache Superset, https://superset.apache.org/ (accessed Oct 14, 2020)
