Konomu Dobashi

Konomu Dobashi

Faculty, Modern Chinese Studies, Aichi University, Japan

KONOMU DOBASHI is a professor at Aichi University, Faculty of Modern Chinese Studies in Nagoya City, Japan, and is mainly in charge of information education. Dr. Dobashi was awarded his B.A. in Economics from Hosei University, Tokyo, 1979, and experience working as a university librarian. He was awarded his Master of Systems Management from the Graduate School of the University of Tsukuba in 1992. He earned a Ph.D. in Engineering from the Graduate School of Engineering, The University of Tokyo, in 1996. He is presently conducting research on educational data mining and learning analytics, with a focus on analyzing and visualizing the course materials browsing behavior of students in classes. His talk is all about Cross section Analysis and visualization of Moodle course log by automated generation of pivot table.


Utilizing the digital teaching materials uploaded on Moodle, face-to-face blended learning class was conducted with a large number of students participating and course material page view history was accumulated. Experiments on automatic generation of pivot table and cross section tables by the developed Excel macros were performed on the accumulated course material page view history and analyze student teaching material opening behavior. 

As a result, about the page views of the entire course material and the individual course materials, the view of the students as a whole and the individual students' opening behavior, it is possible to visualize it by listing not only from the global viewpoint but also from the partial viewpoint by pivot tables and cross section tables. Furthermore, the developed Excel macros can automatically generate time series cross section tables by integrating time data such as days, hours, minutes, etc., and can be utilized for time series analysis from various viewpoints. 

In the analysis of course material page views in class, it is clear from the pivot table generated by the developed system and the time series cross section tables that the student who does not open the course material or the student who opens the course material later than the teacher’s instruction can be clari ed. The analysis method of this paper reproduces the time ows of the lesson which teacher himself/herself and students carried out. Therefore, since teacher and students can review their own way of lesson and course material page views, they can be used for lesson analysis, and suggestions for improving their own lessons are obtained.