Maintain gradebook column order when exporting

Idea created by Knox Mallette on Apr 18, 2019
    Open for Voting
    Score11

    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.