Canvas Guides (English)Canvas GuidesCanvas Instructor GuideGradesHow 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 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 Apply Filters button [1]. Then you can either create and manage filter presets [2] or use the gradebook filters [3]. More than one filter can be applied at any time.

View Modules

View Modules

To filter by modules, click the Modules option [1]. Then you can select the module you want to display [2].

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 [1]. Then you can select the grading period you want to display [2].

View Assignment Groups

View Assignment Groups

To filter by assignment group, click the Assignment Groups option [1]. Then you can select the assignment group you want to display [2].

View Sections

View Sections

To filter by section, click the Sections option [1]. Then you can select the section you want to display [2]. Course sections are displayed alphabetically.

Note: When a section filter is applied in the Gradebook, SpeedGrader also displays assignment submissions for the same section.

View Student Groups

View Student Groups

To filter by student groups, click the Student Groups option [1]. Then you can select the student group you want to display [2].

Note: If your course does not include student groups, the Student Groups option is not displayed.

View Status

View Status

To filter by status, click the Status option [1]. Then you can select the status you want to display [2].

View Submissions

View Submissions

To filter by submissions, click the Submission option [1]. Then you can select the type of submission you want to display [2].

View Start and End Date

View Start and End Date

To filter by start and end date, click the Start & End Date option [1]. Then you can select the start and end date you want to display [2]. Click the Apply button [3].

View Filters

View Filters

View the selected filters [1].

You can manage selections directly from the filter option by clicking the filter option drop-down menu [2].

Remove Filters

Remove Filters

To remove a filter, click the filter option drop-down menu [1] and click the Remove Filter option [2].