Hi there,
I have the same interest on this topics. I propose we classify the student's activities first. Here is a first cut:
- Students’ use of learning materials, such as study guides and video chunks, in terms of (a) frequency of use (in terms of view/participation) and (b) duration of each usage (and est. total time spent)
- Students’ use and content of collaborative tools, such as discussion forum, wiki, and chats, in terms of (c) frequency of use, (d) duration of each usage and (e) the content of collaboration.
- Students’ use and results of assessments, such as PCQ and QUIZ, in terms of (f) frequency of usage, (g) duration of each usage, and (h) the results obtained.
The duration of activity (b), (d), and (g) would need to require requests table, as there seems to be the only place where time stamps are captured.
On the other hand, there has been a tool to extract statistics of student activities https://community.canvaslms.com/docs/DOC-6061-obtaining-and-using-access-report-data-for-an-entire-c... It certainly captured many of the usage data of learning materials, collaborative tools and assessments.
Look forward to exchange of ideas.
Regards,
Paul