SIS Grade Import

Faculty can import final grades from Canvas directly into SIS through the Faculty Dashboard.

Alternatively, if you are looking to manually import an excel file with your grades into SIS, view the Upload Grades via Excel Spreadsheet page.

Important

  • Enable a grading scheme: Within your Canvas course, you must enable a Grading Scheme for the appropriate SIS grade system, e.g., if you are applying Letter Grades (like A/A-/B+/B-/C+/C, P/F). Check with your division guidance before changing the scheme if one is already applied. If not, follow the Canvas guide on how to set a grading scheme.
  • Complete your grading: To ensure the correct grades are imported into SIS, double-check that all your grading is complete and any missing assignments are marked with a 0.
  • Check what grades will be imported:
    • SIS imports grades from a hidden column called “final grade,” not the “total column” that is visible.
    • It calculates unsubmitted and ungraded assignments as zero. It excludes hidden assignments
    • The best way to check this column is by exporting the Canvas Gradebook, finding the “final grade” column, and checking it.
  • Merged sections: If you have merged course sections in Canvas that are not “consecutive” sections (i.e. 478.340.91 merged with 482.455.02), the combined section cannot be imported into SIS from Canvas. Other merged courses that are “consecutive”, (i.e. 348.290.01 merged with 348.290.02, 348.290.03, 348.290.04, etc.) can be imported into SIS from Canvas.

How to use – Canvas instructions

  1. Confirm that your grading is complete. Double-check that you have entered a grade for all columns. SIS imports the hidden “final grade” column. It counts unsubmitted and ungraded assignments as zero. It excludes hidden assignments.
  2. Verify Grading Scheme is enabled.
    • Go to Course > Settings.
    • Check Grading Scheme to see that it is enabled.
      In course settings, under grading scheme, the enable course gradining scheme button is checked.
    • If a Grading Scheme has not been set, please discuss with your teaching and learning center, since these settings impact the functionality of your course and division policies.
  3. Check the appropriate Letter Grade appears in the Grades
    • Go to Course > Grades.
    • Check the Total column shows the Letter Grade you expect to import into SIS.
      In the gradebook, the total column shows both a percentage and a letter grade (e.g., 100% and A).
  4. Confirm your grade by exporting your grade book
    • Export your Canvas Gradebook.
    • Open the exported file
    • Check the “final grade” column to confirm that the grades are accurate.
      • The “final grade” column calculates unsubmitted and ungraded assignments as zero. It excludes hidden assignments.
      • If the grades are not accurate, go back to your Canvas Gradebook. Unhide columns and/or ensure that you are completely finished grading.

How to use – SIS Faculty Dashboard instructions

  1. Go to SIS Faculty Self-Service (https://sis.jhu.edu) and Sign In.
  2. From the Faculty Dashboard, choose the “Term” (e.g., Fall 2022)
    On the faculty dashboard in SIS, there is a dropdown that allows the user to choose the term, such as Fall 2022.
  3. In your list of courses, you will notice a Grade Import column, with Excel and Canvas links (only when the academic grading period is open).
  4. Select the Canvas link related to the course and section for which you are importing grades.
    On the list of courses, in the final column called grade import shows two options, excel and Canvas.
    Note: If your sections are merged in Canvas, you can select the Canvas link for the course’s (combined) roster.
    For merged courses, the second column under courses shows the name of the course with the note they are combined.
  1. SIS will then verify that the Grade Upload/Import Succeeded.
    When the grade import is verfied, it shows a message that Grade Upload/Import Succeeded - Your grades from Canvas have been imported to this screen only. You must use either the Save Work or Post to Registrars button to update these grades in the system.
  2. SIS will display the grades, and require you to verify that they are correct. You can make changes to the imported grades at this time. You can also re-import from Canvas as many times as needed until you press the ‘Post to Registrars’ button.
    The grades that have been imported fill into the drop downs and check mark is in the column next to them.
  3. Click Save Work if you want to log out and continue working at a later time. Click Clear Saved Grades to clear what has already been imported. Click Post to Registrars if you are ready to submit the final grades to the Registrar.
    There are three options to continue including save work, clear saved grades, or post to registrars.

Troubleshooting

MessageDescriptionResolution
Admin Only GradeFaculty cannot submit grades via self-service.
Contact your Divisional Registrar.

No Grade in CanvasStudent does not have any Final Grade in Canvas

For a student – In Canvas, check they have a Final Grade/Total.

For the entire course – In Canvas, check you have applied a Canvas Grading Scheme to match what SIS is expecting.

Need more help? Reach out to your Divisional Faculty Canvas Support.
(final grade) is Invalid GradeThe Final Grade in Canvas is not what SIS is expecting for the section or student. 

For instance, you send an A, but SIS is expecting a Pass (P)/Fail (F).		For a few students – In SIS, manually change grades using the Grade drop-box.

For the entire course –  In Canvas, check you have applied a Canvas Grading Scheme to match what SIS is expecting.

Need more help? Reach out to your Divisional Faculty Canvas Support.
Fs or low gradesGrades in SIS are all Fs or are lower than what shows in CanvasSIS imports grades from a hidden column called “final grade,” not the “total column” that is visible. It calculates unsubmitted and ungraded assignments as zero. It excludes hidden assignments.

The best way to check this column is by exporting the Canvas Gradebook, finding the “final grade” column, and checking it.

If the grades are not accurate, go back to your Canvas Gradebook. Unhide columns and/or ensure that you are completely finished grading.

Need more help? Reach out to your Divisional Faculty Canvas Support
Import Status errors