Classroom Roster Tool

Classroom Roster Tool

A simple spreadsheet-attached set of scripts for managing google classroom at the school level

I got sick of building spreadsheets, then exporting to CSV to use gam for various administrative tasks, so I just rolled my own simple tool.

This has grown to handle pretty much all of the classroom management tasks you'd need at a school level. Building it in a spreadsheet makes it very easy to just use spreadsheet functions to do other data massaging as needed to get what you need from your SIS into google.

Tasks it handles:

  • Creating courses
  • Adding teachers to courses
  • Adding students to courses
  • Inviting/Removing guardians
  • Listing courses, teachers, students and guardians.


Tech used in this project:
Google Apps Script JavaScript School Spreadsheet