How do I sort columns in the Gradebook?

Once you have filtered student enrollments or sections in your Gradebook, you can sort the Gradebook columns by student name, secondary id, total grade, individual assignment, assignment group (if you have assignment groups set up), and assignment due date. You can also resize and rearrange the columns in the Gradebook.

Note: Gradebook columns are persistent, meaning the columns will stay in the order they are arranged.

Open Grades

Open Grades

In Course Navigation, click the Grades link.

Sort by Student Name

Sort by Student Name

To sort students in ascending or descending order by last name, click the Student Name column title. The column shows student names (first name, last name) but is sorted by last name.

Note: To view and sort your Gradebook via sortable name (last name, first name), you can enable the Sortable Name Feature Option in Course Settings.

Sort by Secondary ID

Sort by Secondary ID

To sort students in ascending or descending order by the student's secondary ID, click the Secondary ID column title.

Sort by Total Grade

Sort by Total Grade

To sort students in ascending or descending order by grade percentages, click the Total grade percentage column title.

Note: Viewing the Total column in the Gradebook may be restricted when multiple grading periods are enabled.

Sort by Individual Assignment

Sort by Individual Assignment

To sort within an individual assignment, click any space within the assignment column title. To sort assignment scores in ascending or descending order, click the black arrow [1]. Students with incomplete submissions (no submission or no assigned score) will always sort to the bottom [2].

Sort by Assignment Group

Sort by Assignment Group

To sort assignment group percentages in ascending or descending order, click the Assignment Group Name column title. You can only sort by assignment groups if you have added assignment groups to the assignments page.

Note: Viewing Assignment Groups in the Gradebook may be restricted when multiple grading periods are enabled.

Arrange Columns by Assignment Group

Arrange Columns by Assignment Group

To arrange the columns in the Gradebook by assignment group, click the Settings icon [1] and click the Arrange columns by assignment group link [2].

Arrange Columns by Due Date

Arrange Columns by Due Date

To arrange the columns in the Gradebook by due dates, click the Arrange columns by due date link.

When using differentiated assignments, dates are ordered according to the latest assignment due date.

Resize Columns

Resize Columns

To change the size of the columns, hover your cursor between columns until you see the resize cursor [1]. You can hide a column by dragging the cursor so that the column becomes smaller and disappears [2]. You can make a column reappear by dragging the cursor back out.

Reorder Columns

Reorder Columns

To reorder columns, hover your cursor over the column header you want to move until you see the hand cursor. Then drag and drop the column where you want it.