Connection
Paste the deployed Apps Script Web App URL here. This connects the dashboard to your Google Sheet (your database for everything: attendance, quizzes, assignments, exams, timetable, notes, resources, students & the academic calendar).
Data & Calendar
"Export to Google Calendar" creates (or reuses) a calendar called "UTM Diploma Accounting" in your Google account, then adds:
• All academic calendar dates (lectures, breaks, exams, holidays) as events
• Your weekly timetable as recurring class events for Semester I (29 Jun - 22 Nov 2026)
Re-running it will create duplicates - delete the calendar in Google Calendar first if you want a clean re-export.
How it works
1. Create a Google Sheet.
2. Extensions → Apps Script → paste the provided Code.gs.
3. Run setup() once to create tabs, preload your subjects & academic calendar.
4. Deploy as Web App (Anyone can access) and paste the URL above.
5. All data you add here is saved straight into your Google Sheet.