Seeking Data Source/Report for "Last Date of Attendance" (aka Last Date of Submission)
Does anyone know where I can locate a data point (or report) for "last date of attendance" as reflected by last submission (assignment, discussion, assessment, quiz) to Canvas, per student, per course enrollment?
For context, I'm looking for these data points to be able to pull them into a macro-enabled excel sheet for daily tracking of students and participation--which will give us triggers in our daily trackers/dashboard of how many days it's been since each student's last participation/submission to Canvas. But before I can do much of any of that, I need to first figure out where to find this data and I'm having trouble finding exactly what I'm looking for and obtaining the data source. We've done this at a previous institution so I know it can be done, but I'm not sure what specific report to begin with.
Any help or guidance is appreciated. Thanks!