Importing Grades from Canvas

Pre-requisite: You must create assignments in Frontline SIS that match your assignment names in Canvas

 

Step 1: Export your gradebook from Canvas:

CanvasExport.png
 

From Canvas, go to Gradebook and then Actions >> Export

Step 2: Drag the file from the downloads bar into Frontline SIS

Click and drag the file from the downloads bar into a blank area on the Frontline SIS gradebook. Let go of the mouse and the file will automatically be detected.

Tip: Open Frontline SIS in a separate tab on the same Chrome window.


Alternatively, click “Choose File” and select an a different file on your computer

 

Step 3: Choose assignments to import

 

Teachertools will inform you if assignments were found in the file that were not in Frontline SIS.

Blank cells will be ignored by default so as to not overwrite any manually updated grades in Frontline SIS. Uncheck this box if you want blank grades in the file to overwrite existing grades in Frontline SIS.

Emojis in assignment names will be ignored. Learn more

 

Step 4: Watch and verify

progressbar2.png

The progress bar will update showing the current progress of the import.
Verify grades transferred correctly.

 

Step 5: Save

save.png

Save your updated grades and repeat for your other sections in Frontline SIS.

 

 Technical Details

 Deep Dive into the Canvas Export File

Canvas Exportfile.png

The Canvas export file has three main sections:

Student and Course Information

  • Teacher tools uses Columns A-E headers to detect a Canvas file. The headers must match:

    • Student

    • ID

    • SIS User ID (optional, sometimes Canvas does not include this)

    • SIS Login ID

    • Section

  • Teachertools uses the SIS Login ID column to match with the Frontline SIS Local ID

Grades

  • Columns F and onward hold the Assignment and Grades information

  • Assignment names are in Row 1

  • Assignment names have a Canvas Assignment ID appended in parentheses. These Assignment IDs are ignored by Teachertools. You do not need to remove them.

  • Numeric grade values are passed directly into Frontline SIS

  • Non-numeric grade values of “N/A” are passed to Frontline SIS as a blank

  • Non-numeric grade values of “EX” are passed to Frontline as “EXC” or “EXE” depending on school district.

Statistics

  • Canvas may add statical information based on assignment categories such as:

    • Current Points

    • Max Points

    • Current Score

    • Final Score

    • and more…

  • These “read only” columns are ignored by Teachertools. You do no need to delete them.

  • Teachertools reads Row 2. If it finds “(read only)” it knows to ignore the column.