cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Maintain gradebook column order when exporting

Maintain gradebook column order when exporting

Existing behavior: When an instructor exports the gradebook, the order of the grade columns are ordered by the time when they were created.

Desired behavior: When an instructor exports the gradebook into a spreadsheet the order of the grade columns reflect the gradebook order in Canvas.

I was very surprised that the gradebook order isn't reflected in the exported file. One major concern is that there's no way to tell what the column order is going to be, since the order of the columns goes by Assignment ID, which isn't visible in the Canvas gradebook (and instructors won't remember what the order they created columns in a given course). For an instructor with 20+ grade columns, this becomes a problem when they download the gradebook to aggregate or analyze student information.

It's not a good practice to assume instructors will create their graded assignments in the order in which they would like to view the graded assignments in the gradebook export file. Rather, it makes much more sense for the gradebook export file to reflect the gradebook column order the instructor specifically chose in their Canvas course. 

5 Comments
Stefanie
Community Team
Community Team

Hi,  @kmallette ‌, here's a different but related idea for your consideration: Exported gradebook should match filters on the grade screen

kmallette
Community Participant

Thank you, stefaniesanders‌! Smiley Happy

Stefanie
Community Team
Community Team
Comments from Instructure

Instructors can now download a Gradebook csv file that matches the order of assignments on the Assignments tab. For more information, please read through the Canvas Release Notes (2020-03-21) 

vikki_bentz
Community Member

The release notes indicate that the export order of columns reflects the ASSIGNMENTS list; this is not the GRADEBOOK order of columns, which an instructor can sort by due date.  It would be more valuable to me and others to have the export reflect the gradebook columns.  Thank you.

Stefanie
Community Team
Community Team

You are correct,  @vikki_bentz ‌; the feature as developed and released does not fully address this request, so we've removed the On Beta designation.

About Idea Conversations
In the Instructure Community Ideas space, you can share, converse, and rate idea conversations related to software improvements to Instructure products.