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.