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.
In Course Navigation, click the Grades link.
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. If Student View has been activated, the Test Student will be shown at the end of the student list.
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
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 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 . Students with incomplete submissions (no submission or no assigned score) will always sort to the bottom .
Sort by Assignment Group
To sort an assignment group by percentage in ascending or descending order, click the name of the assignment group. 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.
You can arrange columns by assignment group or by due date in the Gradebook Settings menu.
Note: The first time you open the Settings menu, the menu displays both arrangement options, and you can select which option you want to use to arrange your columns. However, after you have selected an option, you can always switch between them.
Arrange Columns by Assignment Group
To arrange the columns in the Gradebook by assignment group, click the Arrange columns by assignment group link.
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 student assignments. If an assignment is assigned to everyone, dates are ordered by latest assignment due date. If an assignment is not assigned to everyone (differentiated by section, group, or individual), dates are ordered by the assignment creation order.
To change the size of the columns, hover your cursor between columns until you see the resize cursor. You can hide a column by dragging the cursor so that the column becomes smaller and disappears. You can make a column reappear by dragging the cursor back out.
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.