Disclaimer: This news item was originally posted on Wednesday, Aug 21, 2019. Its content may no longer be timely or accurate.

Canvas - New Report - Student Activity and Performance

Posted: 06:37:04, Wednesday, Aug 21, 2019   Expiration: 06:37:04, Wednesday, Aug 28, 2019

The "Student Activity and Performance" report has been enabled. This report shows student activity and performance per enrollment

The Student Activity and Performance report has been enabled in our Canvas instance.  Below table shows example of the output.  The report can be run from account settings.

account_name user_id first_name last_name course_name section_name teachers user_start user_finish assignment_submissions discussion_submissions quiz_submissions module_completion percent_completed expected_percent_completed course_participation_metric completion_status score score_status last_access
Account 1 sis_student_1 John Doe All about arthropods AAA Section 1 Edna Krabappel,Elizabeth Hoover 2014-09-25 14:01:34 2015-03-25 14:01:51 2014-12-25 13:56:33,2014-12-25 18:56:48 2014-12-27 13:57:13 2014-12-27 16:57:30 2014-12-27 16:57:30 65% 70% 0.92 On Track 85% Passing 2015-01-25T13:59:40Z

There are some hard coded business rules in this report.  Below is explanation of each of the columns which contain business logic.

% Complete

Calculation of % of context modules complete from the total modules that are available and active.
Expected % Complete

Calculation of expected progress.  This is based on the weekdays(M-F) that have occurred up to the current date from User Start divided by the weekdays(M-F) available from User Start - User Finish
Course Participation Metric

The result of “% Complete” divided by “Expected % Complete” 
Completion Status

Based on the “Course Participation Metric” a text value is displayed according the chart.
>= 1.0 - Ahead
>=0.8 - On Track
>=0.6 - Behind
<0.6 - Serious Concern
On Track
The user’s current score in the course
Score Status

Based on the “Score” a text value is displayed according the chart.
Nil - N/A
>=70 - Passing
>= 60 In Danger of Failing
<60 - Failing

-- UWSA DLE: Dale Johnson

Created: 20:45:39, Tuesday, Aug 20, 2019 (by Dale J.)
Updated: 07:20:59, Wednesday, Aug 21, 2019 (by Karla C.)