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:
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
The progress bar will update showing the current progress of the import.
Verify grades transferred correctly.
Step 5: Save
Save your updated grades and repeat for your other sections in Frontline SIS.
Technical Details
Deep Dive into the Canvas Export File
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.