Skip to main content

Grades: Features & Settings

You can arrange any column in the Gradebook according to your preference. You can use a preset arrangement by assignment name, due date, points, or module, or you can manually arrange columns. You can also manually increase and decrease the width of any column.

The option to arrange columns affects all the columns in the Gradebook. To only view specific columns, you can also filter columns by type.

Go to Grades
Click View
Hover on Arrange by...
Select how you would like the columns to be arranged by...

newGradebookViewArrange

Manual Arranging Columns

You can also manually arrange columns. To manually arrange an assignment column, click the column heading and drag the heading to your desired location. Manual placement is persistent in the Gradebook until the column is reordered.

Notes: When columns have been manually reordered, any new assignment added to the Gradebook displays at the end of the Gradebook. To place the assignment in its intended location, either manually arrange the new assignment, or reset your Gradebook order by arranging your columns with one of the options in the View menu.
If the Total column is visible in your course, you can also move the Total column to the front of the Gradebook. The Total column can be manually arranged among the Student Name and Notes column only.

newGradebookColumnManuallyArrange

Resizing Columns

You can manually increase or decrease the size of any individual assignment column in the Gradebook. Hover over the assignment header. When the cross-hairs icon appears, drag the assignment column to the desired width. Column width is persistent in the Gradebook until the column is resized.

newGradebookColumnResize

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.

The option to filter columns affects all assignments within the filter.

Go to Grades
Click View
Hover on Filter
Select how you would like the columns to be filtered.

To remove a filter, click the View menu and click the Filters. Select the filter that you want to remove from the Gradebook. When a filter is removed from the Gradebook, all menu option filters are also removed.

newGradebookColumnFilter

The filter menus display at the top of the Gradebook. Assignment Groups, Modules, and Student Groups are sorted alphabetically in ascending order.

You can filter these options individually and one at a time.

Assignment Groups

newGradebookColumnFilterAssignmentGroups

Modules

newGradebookColumnFilterModules

Student Groups

newGradebookColumnFilterStudentGroups

Or you see all the filters at once.

newGradebookColumnFilterAll

Total Column
You can customize the Total column in your Gradebook. The Total column can be moved to the front of the Gradebook or sorted to display grades in an ascending or descending order.

You can switch your students' total grades from a percentage to a point value in the Gradebook. By default, total grades are shown as a percentage with two decimal places.

Notes:

  • Viewing total grades as a point value is available only if you use unweighted assignment groups in your course. When assignment groups are weighted, points cannot be displayed for the total grade.
  • Viewing the Total Column in the Gradebook may be restricted when multiple grading periods are enabled. This feature also limits viewing the total grade in the student Grades page.
  • When Multiple Grading Periods are enabled in a course and grading periods are weighted, points cannot be displayed for the total grade.

Sort By…
newGradebookTotalSoryBy
You can sort the Gradebook by ascending or descending total grades.

Display as...
newGradebookTotalDisplayasPoints

newGradebookTotalDisplayasPercentage

Move to Front/End
newGradebookTotalMovetoFront

newGradebookTotalMovetoEnd

By default, total grades are shown as a percentage with two decimal places. You can choose to show the total as points. If your course uses unweighted assignment groups.

Canvas confirms you want to switch the total grade view

By default the Total column is at the end of the Gradebook. This option will allow you to move the Total column to the front and vise versa.

newGradebookTotalDisplayasPointsWarning

newGradebookTotalDisplayasPercentageWarning

Notes Column
You can use a Notes column in the Gradebook to keep track of extra information in your course, such as extra student information or general notes. The Notes column is not visible to students.

Notes:

  • Instructors can only show and hide the Notes column. Admins can use the API to create additional columns, but they cannot be hidden.
  • The Notes column is included in the gradebook export CSV file, and you can add notes via CSV import.

Show/Hide Notes

Go to Grades
Click View
Click Notes
Means Notes are unhidden 
No √
Means Notes are hidden

newGradebookViewNotes

Entering Notes into the column

To make a comment, click the note field for the appropriate student and enter your note in the text field. The note field allows up to 255 characters. To save your comment, click the Save button

newGradbookEnterNotes

Viewing Notes

View your comments in the Notes column. You can view the full comment by resizing the column or re-clicking the notes text field.

Note: When you navigate away from the Gradebook, any changes to the size of the columns will be lost.

newGradbookNotes

By default, you can view unpublished assignments in the Gradebook. This setting can be turned off at any time.

When unpublished assignments are visible in the Gradebook, unpublished assignments display with a gray background. Unpublished assignment columns do not include a dash indicating that grades cannot be entered. Additionally, assignment menu options are not available until the assignment is published.

Unpublished assignments are not visible to students.

To Hide and Unhide Unpublished Assignments:
Go to Grades
Click View
Click Unpublished Assignments
Means Unpublished Assignments are unhidden 
No √
Means Unpublished Assignments are hidden

newGradebookViewPublish-Unpublish





Unpublished and Published Assignments Visible
newGradebookViewUnpublish

Published Assignments Visible
newGradebookViewPublish

Exporting Canvas Grades CSV File

  • Log into the Canvas Course
  • Go to the Grades
  • Click Actions, top left next to View
  • Select Export
  • This will download the .CSV file and place it in the Download Folder on your computer

Implementing the Canvas CSV File

  • Open the .CSV file from your downloads, it will open in Excel
  • Grades can be entered in the excel sheet for the term (Note the students will not be able to see the grades in the excel spreadsheet) All grades entered in Canvas will be visible to students.
  • If using two spreadsheets, you combine them into one by copying and pasting data from one to the Canvas csv

Importing Modified Canvas CSV File

  • When it is time to import the grades into Canvas 
  • Click Actions, top left next to View
  • Select Import

newGradebookActions

    • This will open up the screen below
      uploadcsv
    • Click the Choose File button and locate the saved modified Canvas csv file
  • Click on “Upload Data” after you have selected your file
    • NOTE: the upload file must be a .csv

If you add a new column to the CSV file and then upload the file, Canvas will ask you what you want to do with the new column.

  • In the drop-down menu, choose A new assignment, provide point value if you did not do this in the csv file
    • Repeat for all new assignments
  • Click the Continue button
  • Note: When multiple grading periods is enabled, CSV file uploads cannot create new assignments.
  • Review the changes made to your Gradebook.
    • If you upload assignments with no grade changes, they will be hidden from the upload
  • Click the Save Changes button
selectnewassignment


showuploadgrades

Grades will now appear in your gradebook, update time may vary on how many assignment grades there were.