Canvas Guides (English)Canvas GuidesCanvas Instructor Guide GradesHow do I filter columns and rows in the Gradebook?

How do I filter columns and rows in the Gradebook?

The Filter menu allows the Gradebook to be filtered by assignment group, section, modules, and grading period (if applicable).

When a filter option is selected, the filter menu displays at the top of the Gradebook. Multiple filters can be used at the same time.

Filter options will apply to either Gradebook rows or columns. The option to filter columns affects all assignments within the filter. The options to filter rows affects all students within the filter. You can also arrange columns within filter results.

Open Grades

Open Grades

In Course Navigation, click the Grades link.

Search Students

Search Students

By default, the Gradebook shows all active students. To search for students by name or SIS ID, enter your search query in the Search Students field.

The Search Students field allows multiple student names to be filtered at the same time. Selecting a student filters the Gradebook to display only that student's row. If multiple students are selected, rows display for all selected students. Likewise, deselecting a student removes the student's row from the Gradebook view.

The Search Students field also respects Concluded and Inactive Enrollment options. If the Concluded Enrollment or Inactive Enrollment options are selected as filters, no Concluded or Inactive enrollments display in the Gradebook.

Note: Student name search results displays secondary information if more than one student has the same name in the course.

Search Assignments

Search Assignments

By default, the Gradebook shows all assignments. To search for assignments, enter an assignment name in the Search Assignments field.

The Search Assignments field allows multiple assignment names to be filtered at the same time.

Selecting an assignment displays the assignment in a column closest to the student name. If multiple assignments are selected, the assignment columns display in the reverse order they are selected.

Filter Gradebook

Filter Gradebook

Click the View menu [1], then click the Filters link [2]. More than one filter can be applied at any time.

View Assignment Groups

View Assignment Groups

To filter by assignment group, click the Assignment Groups option.

View Assignment Group Menu

The Assignment Groups menu displays at the top of the Gradebook [1]. Click the menu to select the assignment group you want to view [2]. Assignment groups are sorted alphabetically in ascending order.

View Grading Periods

View Grading Periods

When Multiple Grading Periods are enabled in a course, you can filter the Gradebook by grading period. To filter by grading period, click the Grading Periods option.

View Grading Periods Menu

The Grading Periods menu displays at the top of the Gradebook [1]. Click the menu to select the grading period you want to view [2]. Grading periods are sorted by grading period date in ascending order.

View Modules

View Modules

To filter by modules, click the Modules option.

View Modules Menu

The Modules menu displays at the top of the Gradebook [1]. Click the menu to select the module you want to view [2]. Modules are sorted alphabetically in ascending order.

View Sections

View Sections

To filter by section, click the Sections option.

View Sections Menu

The Sections menu displays at the top of the Gradebook [1]. Click the menu to select the section you want to view [2]. When a section filter is applied in the Gradebook, SpeedGrader also displays assignment submissions for the same section. Sections are sorted alphabetically in ascending order.

View Student Groups

View Student Groups

To filter by student groups, click the Student Groups option.

View Student Groups Menu

The Student Groups menu displays at the top of the Gradebook [1]. Click the menu to select the student group you want to view [2]. Student groups are sorted alphabetically in ascending order.

Remove Filters

Remove Filters

To remove a filter, click the View menu [1] and click the Filters link [2]. Select the filter that you want to remove from the Gradebook [3]. When a filter is removed from the Gradebook, all menu option filters are also removed [4].