In Canvas, how do I submit final grades via a file upload?

UITS has developed a custom tool that exports a .csv file compatible with the SIS Grade Roster file upload option. To export grades from Canvas and upload them to your midterm or final grade roster, follow the instructions below.

Notes:
  • While it is possible to submit final grades via a file upload, it is much easier to transfer grades directly from Canvas to the SIS Grade Roster. For details and instructions, see Loading final grades from Canvas into the SIS Grade Roster.
  • You can't submit final grades until the final grade roster is available for each term; the Office of the Registrar will email instructors when rosters are available. For questions about roster availability, grade submission deadlines, or submitting final grades after the deadline, contact your campus Office of the Registrar.

On this page:


Export calculated grades from Canvas

To export final grades from Canvas:

  1. In Canvas, missing or empty grades do not count toward the calculated final grade. If you want to penalize a student for not completing a graded activity, you must enter a grade of 0 for that activity. To excuse a student from a graded activity, leave the grade blank. Review all empty grades in your gradebook and zero out missing grades if necessary.
  2. If you haven't already done so, confirm or edit the grading scheme for your course gradebook. See How do I create a grading scheme for my course? and How do I enable a grading scheme for my course? from the Canvas Help Center.
  3. From the course navigation menu, click Grades.
  4. In the Canvas Gradebook, click the gear icon and select Export Grades for SIS.
  5. You will be prompted to open or save the file. Save the file to your local storage device.
    Note:
    Do not open and save the file in Microsoft Excel. Excel removes the leading zeroes from student ID numbers, which will prevent the SIS import from working.

Import final grades into SIS

To import final grades into SIS:

  1. In Canvas, navigate to your course. From the course navigation menu, click SIS Grade Roster. This tool is visible only to instructors.

    The Faculty Center will initially display information for the current term and campus. To select a different term or campus, click Change Term or Campus and select the appropriate term or campus.

  2. If your course only has one section, a new tab will open displaying the SIS grade roster for that section.

    If your course contains cross-listed sections:

    1. The SIS Faculty Center will open in a new tab. In the "Class" column, locate the course section for which you would like to enter grades.
    2. To open the grade roster for that section, click Grade Roster in the course section's row.
  3. On the "Grade Roster" screen, click Load Grades from File to Roster.
  4. Click Browse to locate and select your final grades file.
  5. Once the filename displays in the text box, click Upload. The system will attempt to load the file. You should see the following message, where "Y" is the number of records in the file and "X" is the number of records loaded:

    Loading X Records out of Y Read. Would you like to continue?

    Click OK.
  6. Verify that all grades loaded, and click Save.
  7. In the "Grade Input" column, review the grades and adjust the values as necessary. You can assign special grades such as FN (for students who stopped attending), FNN (for students who never attended), I (for incomplete), R (for deferred), and so on. Click Save periodically to save your changes.
    Note:
    If you assign a grade of FN, you must also provide the date of last attendance. The "Last Date Attended" field will appear when you click Save.
  8. If your grade roster has a "Requirement Designation (RD) Grade" column (for RISE designations, intensive writing requirements, etc.), set the RD grade for each student. Click Save periodically to save your changes.
  9. When all required fields are completed and you are satisfied that all grades are correct, click Approve and Submit to Registrar.

If your Canvas course has cross-listed sections, click Return to go back to the Faculty Center. Repeat steps 2 through 9 for each section.

This is document beui in the Knowledge Base.
Last modified on 2017-06-07 13:28:50.

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.