Importing Grades from Google Classroom
Pre-requisite 1: You must create assignments in Frontline SIS that match your assignment names in Google Classroom.
Pre-requisite 2: Student Google Email Addresses must contain their Frontline SIS User ID, such as “S1234567@school.edu”. Teachertools is not compatible with Google Classroom if student email addresses are not in this format.
Step 1: Export your gradebook from Google Classroom. You can choose either to export grades for a single assignment or for all assignments.
From Google Classroom, select your class and then go to the Grades tab.
Click on an Assignment Name to view the Student work tab.
From the Student work tab select the Gear on the right and choose Download all grades to csv (recommended) or Download these grades as CSV.
Note: If you choose to download only ‘these grades’ then your assignment name may not contain the following characters: _ / \ [ ] { } ( ) < > `~!@#$%^&*|=+,.;:? Including any of those characters will cause the assignment name to not detect correctly when your file is imported. If you choose to download “all grades” this is not an issue and the assignment name can contain any of those characters except < or >. See the Technical Details section at the bottom of this page for a detailed explanation.
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 within the same Chrome window.
Alternatively, click “Choose File” and select the 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
The Google Classroom All Grades Export File
When you choose to “Download all grades to csv” you will see a file like this:
The Google Classroom All Grades export file is named based on the Google Classroom Class name. The file has two main sections:
Student Information
Teacher tools uses Columns A-C headers to detect a Google Classroom All Grades export file. The headers must match:
Last Name
First Name
Email Address (Must contain student ID number).
Teachertools uses the Email Address column to match with the Frontline SIS Local ID.
It will usually include an “S” in front of the student ID. Teachertools will automatically remove the “S” if present.
Grades
Columns D and onward hold the Assignment and Grades information
Assignment names are in Row 1
Grade values are passed directly into Frontline SIS
The Google Classroom These Grades Export File
When you choose to “Download these grades to csv” you will see a file like this:
The Google Classroom “these grades” export file is named based on the Assignment Name. There are two main sections in the file:
Student Information
Teacher tools uses Columns A-C headers to detect a Google Classroom These Grades export file. The headers must match:
Last Name
First Name
Email Address (Must contain student ID number)
Grades
Teachertools uses the Email Address column to match with the Frontline SIS Local ID.
It will usually include an “S” in front of the student ID. Teachertools will automatically remove the “S” if present.
Grades
Columns D contains the Grades information for this assignment
Grade values are passed directly into Frontline SIS
The Assignment Name is extracted from the file name. However, any spaces in the Assignment Name will be replaced with underscores “_” when Google Classroom downloads the file. Teachertools infers that all underscores in the filename were originally spaces. All special characters: _ / \ [ ] { } ( ) < > `~!@#$%^&*|=+,.;:? will also be exported by Google Classroom as either underscores or be ignored. This will cause Teachertools to not correctly match Assignment Names with Frontline SIS. If your assignment names do contain those characters you can still import them using the “download all grades” method.