Admin export of Current Score for All Students in All Courses for a given term?

Jump to solution
MattatBA
Community Member

Hello, 

I am new to this forum and relatively new to Canvas. As an admin with responsibilities for overall student performance in all classes, I am hoping for a way to export the "current score" column for all students enrolled in all courses for a given term. Essentially, a snapshot for any given moment in a trimester so I can share with advisors, etc.

I think I understand how to export grades for a single course, but I am hoping for an automated way to export "current score" into a .csv that includes columns for course name and current score, with rows for student name. If individual grades are also included that is fine. 

Thank you for any help, and I apologize for any incorrect or unclear phrasing.

0 Likes
1 Solution
James
Community Champion

@MattatBA 

There's not a built-in report to do this. However, it can be done through the Canvas REST API, but you need to iterate through every course to do it. You'll then need to compile your own CSV file.

The current_score (numeric) or current_grade (might be a string) is contained within the enrollments object.

View solution in original post