Magic Class Tracker

Create a mark-book that will allow you to share a complete row of the worksheet with a Student or Parent or both! 

This add-on can be used to set up and create a brand new mark-book tracker or can be applied to an existing one you already have. Simply install the add-on to any Google Spreadsheet and an Example Class will be created for you.

Using the sidebar menu you can control the creation of more Worksheets (classes) and apply the Magic Class Tracker to existing sheets. Once ready you can share individual rows of the tracker with pupils and parents as you wish.

Magic Class Tracker will create a Google Drive folder for each worksheet (class) and then a new Google Sheet for each pupil listed in your tracker. These pupils sheets can then be shared with pupils, parents or both as you require. 

Please note - due to Google charging $500 to security assessment this addon it will provide a warning and may stop installations from the Google Workspace Marketplace. Due to this there is a direct install button above that will allow you to make a copy of the Google Sheet containing all of the code