{"id":1948,"date":"2017-11-17T09:29:21","date_gmt":"2017-11-17T07:29:21","guid":{"rendered":"https:\/\/tecnocentres.org\/?p=1948"},"modified":"2017-11-17T09:28:18","modified_gmt":"2017-11-17T07:28:18","slug":"imexclass-an-add-for-exporting-and-importing-gardes-between-classroom-and-spreadsheet","status":"publish","type":"post","link":"https:\/\/tecnocentres.org\/en\/blog\/2017\/11\/17\/imexclass-an-add-for-exporting-and-importing-gardes-between-classroom-and-spreadsheet\/","title":{"rendered":"ImExClass: an add-on for exporting and importing gardes between Classroom and a spreadsheet"},"content":{"rendered":"

Yesterday Google published in the Chrome store of spreadsheet add-ons a new add-on I created, ImExClass.<\/p>\n

It’s a simple add-on that solves a need I had and maybe others have as well. I use a spreadsheet (virtual teacher’s gradebook<\/a>) to keep track of the students. In addition, I use Google Classroom to support my classes.<\/p>\n

<\/p>\n

And of course, I enter the grades of some tasks in Classroom (because they are tasks that have been delivered in this way) and others I enter them in the spreadsheet because they have not delivered anything digital.<\/p>\n

I need all grades to be entered in the spreadsheet, which is where I calculate averages and do the complete monitoring of the students.<\/p>\n

Google has an option to export Classroom grades, but it creates a spreadsheet with all the notes disorderly. Until now I had chosen to enter all the grades in Classroom and, from time to time, export from Classroom, sort the grade in the order I have in the gradebook and finally copy and paste. It works, but it’s a bit of a cumbersome procedure.<\/p>\n

The ImExClass add-on makes this process easier, as it allows me to enter grades into either Classroom or spreadsheet.<\/p>\n

If I have entered them in the spreadsheet, the Export<\/em> option will create a new assigment in Classroom with the grades that were in the spreadsheet.<\/p>\n

If I have introduced them to Classroom, I open the spreadsheet and with the Import<\/em> option, each student in spreadsheet will have their grade copied,<\/p>\n

For detailed information on the operation, please refer to the following article.<\/p>\n

ImExClass: an add-on for exporting and importing grades between Classroom and a spreadsheet<\/a><\/p><\/blockquote>\n