Hello All,
I am trying to create an Activity completion report in PowerBi similar to the Activity completion report you can generate within a class. What database file(s) store activities and the corresponding completion status?
Cheer!,
Peter
Hello,
After further research, I have found the course id and the id of the activity. The course id is in the mdl_course and the activity is in mdl_url as I am tracking a URL activity. Do I now have to search the log file for the 'viewed' action in the event list for the course id and component = mod_url?
Cheers,
Peter
After further research, I have found the course id and the id of the activity. The course id is in the mdl_course and the activity is in mdl_url as I am tracking a URL activity. Do I now have to search the log file for the 'viewed' action in the event list for the course id and component = mod_url?
Cheers,
Peter
It's much, much more complicated than that.
This might help.... https://docs.moodle.org/dev/Database_Schema
This might help.... https://docs.moodle.org/dev/Database_Schema
Hello Howard,
Thank you for the quick reply and link. My activity completion criteria, is that the link be viewed. It is for this reason i was searching for the viewed action in the log (however if they look at it multiple times it throws my count off.). When an activity is marked as completed how is that represented in the Moodle DB or is it a dynamically determined values based on recorded events?
Sincerely,
Peter
Thank you for the quick reply and link. My activity completion criteria, is that the link be viewed. It is for this reason i was searching for the viewed action in the log (however if they look at it multiple times it throws my count off.). When an activity is marked as completed how is that represented in the Moodle DB or is it a dynamically determined values based on recorded events?
Sincerely,
Peter
Completion events are recorded in the table course_completion_crit_compl
Thank you. My table is blank, yet the Activity completion report shows activities as being completed. Looking at your schema link above, I see the URL table (Where I found the URL for my URL Activity) is linked to the course table; but that is as far as I get. Is there a flowchart that identifies the steps that are followed to determine if an Activity is completed?
I appreciate your assistance,
Peter
I appreciate your assistance,
Peter
Hello,
Here is my ERD thus far:
I do not know how to link the URL to the Course_Module_Completion table. I believe the the activity completion is in there. Am I close?
Cheers,
Peter
Hello,
Since my Activity Completion criteria is set to 'Complete when student views link': Should I just monitor for the event in the log file, rather then determine activity completion?
Sincerely,
Peter
Since my Activity Completion criteria is set to 'Complete when student views link': Should I just monitor for the event in the log file, rather then determine activity completion?
Sincerely,
Peter