How to Export Grades from Google Classroom

One of the major drawbacks to Google Classroom is that it does not export to grading programs such as eSchool or Sapphire however you can export your Google Classroom Grades to Google sheets or as a CSV file which should help with transferring grades. To accomplish this follow the steps below:

Export grades to Google Sheets

Screen Shot 2016-04-14 at 12.53.14 PM
Exporting Options

1.     Sign in to Classroom 

2.     Click the class and then click on any assignment in the class stream.

3.     Click the setting gear and choose: Copy all grades to Google Sheets.

A spreadsheet with all the grades for the course is created in your Classroom Google Drive folder.

 

Export grades to a CSV file

1.     Sign in to Classroom at classroom.google.com.

2.     Click the class and then click on any assignment in the class stream.

3.     Click on the settings gear and select one of the following options:    

  • Download these grades as CSV.
  •  To download all assignment and question grades, select Download all grades as CSV.

The grades are downloaded to a CSV file.

 

Screen Shot 2016-04-14 at 1.00.18 PM.png
Example of Exported Grades in Google Sheets

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s