After School Activity Manager

This is a Google based resource that manages after school activities. It is a Google Sheet that has a Google Apps Script built in which allows a browser to interrogate and write to the spreadsheet. It requires users to be logged in to their school Google account.

• If they are a student then they are prompted to select their activity.
• If they are a parent then they can select activities on behalf of their children
• If they are a teacher then they can:
  1. Take a register of students who have signed up for an activity
  2. See all students in a particular class or form and change their activities.

The spreadsheet has a number of sheets:

• Activities: This is where the various activities, the teachers taking these activities, which day they take place on and the maximum capacity of the activity. The “cut off date” or deadline for students selecting their activity is also there.
• Staff. This is where teachers are listed, including their email addresses which define their Google identity.
• Students. This is where students are listed including their email addresses, their Form (Class) and their parents school email identity.
  Selections and AttendanceHistory. These sheets are used by the code to record data.
  The Google Spreadsheet:
  [https://docs.google.com/spreadsheets/d/1uVeiwgN_qrLe74dMmRXLqmjcHpRlkMEs1P5oF0r6ua8/edit?usp=sharing]

The URL of the App
https://script.google.com/macros/s/AKfycbzFpcpWKcdEPcGjBX5WuUOVsTZGqkAo8aw_II9dYSQr1AA-F9LofOA1QIjUMEkH8qF_MQ/exec

I coaxed Gemini into writing the code for this as our SIMS is not capable of managing our ASAs. I’m making it available to anyone but I can’t support anyone who gets into difficulty with it. You need to be passingly familiar with how Google Sheets and HTML work but Gemini wrote all the code snd can therefore be asked to rewrite it based on your needs. You’ll need the Google Apps Script Extension installed (it’s free). When you invoke that (Extensions --> Apps Script) there is an index.html file where you can change the logo (line 40) which must be a web based image, of course.