Google Classroom - creates a spreadsheet for grades but doesn't automatically sync

381 Views Asked by At

So in Classroom I can create a spreadsheet of all my students, all the assignments, all the scores. That's great. However, it is a one shot deal. New grades and assignments don't automatically sync/populate to that spreadsheet. I am trying to create "packets" of multiple assignments and through the spreadsheet by totaling the scores of multiple assignments. =sum() makes that part easy enough. However, unlike using a google form, which automatically syncs and updates with new submissions, the spreadsheet created by classroom doesn't update that way. Any tricks I can do to make any new inputted grades in classroom be automatically added to teh spreadsheet?

1

There are 1 best solutions below

0
On

When you are in an assignment and you use the tool Copy all grades to Google Sheets it will create an snapshot of the grades on the assignments at that moment but it will not update the values if there are any changes or new data is added (such as new assignments).

Workaround

To solve this and get this data dynamically into your Spreadsheet, you could make use of the Apps Script service for Classroom and retrieve all your desired data. This makes use of Classroom API with all its functionallities. Once you get this data you could print it in your desired columns using SpreadsheetApp.