Online Tutorial for Data Analysis and Automation
A page-by-page walkthrough of the Secondary Schools Dashboard in Google Sheets – five linked reporting pages, 18 charts, 15 slicers and a coded Student ID lookup over 500 sample rows, with an honest note on what the file does and does not hold about pupils.
A six-tab Google Sheets reporting template for primary schools: 16 KPI cards, 21 charts and gauges, 15 slicers, native pivot tables and a Record ID lookup. Class-level data only – no pupil names, dates of birth, contact details, SEN or safeguarding fields anywhere in the file.
A School Management System Web App built on Google Sheets and Apps Script with six modules, 12 live dashboard KPIs and role-based logins for Admin, Principal, Teacher and Accountant.
One Google Sheets dashboard for exam scores, attendance and fee collection, with Overview, Academics, Attendance and Finance pages and a Student Record Lookup.
A ready-to-use Education KPI Scorecard in Google Sheets that tracks 10 school KPIs, from Graduation Rate to Student Retention Rate, with MTD/YTD views, traffic lights and trend charts.