How Do I Import Grades from Canvas?

May 8, 2023

Introduction

A Canvas Import may be easier for large class sizes. Your course setting will need to be adjusted before exporting the gradebook. 

Learn how to access the Grade Roster. The Manual Update method may be helpful for smaller class sizes.

Note: More information about grading is available on the Office of the Registrar website.

Note: For information on how to set up your gradebook to make submitting grades easier, please see the Canvas Gradebook Checklist and the Gradebook Setup Overview

Instructions

General Steps to Upload Grades

In my.SDSU Portal:

  1. Add grades to the Grade Roster through a Canvas Import.
  2. Save to review work.
  3. Post grades.

Canvas Import

Watch Tutorial

View Time | 2:58 Mins

Watch this video to learn how to import grades from Canvas into my.SDSU. 

 

Read tutorial
step 1: 
In Canvas
  1. Enable the grading scheme in the course's Settings.
    Set grading scheme to "enable course grading scheme"
    Scroll down the page and select Update Course Details to save your changes.

    Update Course details button

  2. Verify that all grades are correct in Canvas. Ensure that each submission is graded and that any missing submissions have been graded as "0", incomplete, or excused. For more information, please reference How to Set 0's in Canvas Gradebook for Missing Assignments (access requires signing in to ServiceNow or Single Sign On).

  3. After verifying grades, download grades from your Canvas gradebook. Log in to your Canvas course and navigate to the Grades page. From grades, you will download the gradebook and save the .CSV file to your computer.

    Export Gradebook
    Note: If you are using the Final Grade Override feature in Canvas, once you download the .CSV file, you will need to delete the Override Status column on the far right of the file in order for grades to upload correctly in my.SDSU. Otherwise, you should not alter the.CSV file you download from Canvas. As always, the FIT Center support team is standing by to assist with any questions.
In my.SDSU
  1. Select Faculty Center Tile > My Schedule > Grade Roster icon for your desired class > Import Grades located at the bottom of the roster.

    Import Grades button
  2. In the Load Student Grades From a File window, select Import Grades.

    Select import Grades in "Load Student Grades From a File"
  3. Use the Choose File button to locate the Canvas gradebook .CSV file saved on your computer. Select Upload.

    Choose file then upload
 
Important Note About Correctly Setting Up Canvas Gradebook Export:
  • The gradebook file must remain a .CSV file in order to upload correctly. You may rename the file but it must be short. For example, you can name the file "Grades."

  • The gradebook export must be organized with the default settings where the "Total" column is at the far right-hand of the gradebook.

    Sometimes we will place "Total" on the far left-hand of the gradebook (AKA via "Move to Front.") 

    Total - move to front
    To move the total back to default settings, place your cursor over the "Total" column header to reveal the kabob, and select Move to End:

    Move to end

step 2: Save to review work
  1. Review the imported grades and select the Save button located at the bottom of the screen.

    Save after uploading
  2. A message will appear to inform you that your grades are saved, but not submitted to the registrar.

  3. Select OK.

Grade Roster Almost Done Message

step 3: post grades
Watch Tutorial

View Time | 1:29 Mins

Watch this video to learn how to post grades in my.SDSU.

Note: The video blurs student information. 

 

Note: When Post is selected, all of your student grades will be posted at once. It is not possible to submit individual grades one by one.

Read Tutorial

To post your grades, navigate to the Grade Roster Action section located above the class roster.

  1. In the drop-down menu, choose Approved and then select Save.

    Approved button
    Note: Once you have approved and saved your grades, you will receive the following message. Your grades have been saved in my.SDSU but have not been posted.Grade Roster Almost Done Message
  2. At the bottom of the page, select Post to submit your grades to the registrar.

    Post button
    Note: If you do not see the post button, please contact your Department or College Coordinator.
  3. When the grades are posted, the Status column to the right of the Grading Basis column will update to Posted.

    Posted Grades has new column called "Status"
  4. When you are finished, select Change Class at the top of the page to return to the Faculty Center.

I Have a Small Class Size!

If you have less than twenty students in your course, it may be easier to manually update grades. Please visit the resource below:

Manual update

I Need to Edit the Grades I Just Posted!

Have you posted grades? You can change the grades after they are posted only during the grading period. For additional information, please read How Do I Correct Grades Once They're Posted?

Categorized As