Free Student Performance Dashboard with Login – Apps Script

A student performance dashboard that turns rows of marks into charts. Each student or teacher signs in with their own username and password and sees only their own records, drawn live from Google Sheets.

Four views of the same data

The dashboard opens on a class distribution chart showing how a student's records spread across their classes, a report summary totalling marks obtained against marks possible, and separate speaking and reading performance charts. Four chart types are used deliberately, so the same figures read differently depending on the question you are asking — a trend, a share, a total.

Login that actually gates the data

Credentials live in a Login sheet. Sign in and the app looks up that username in the Report sheet and builds the charts from the rows that belong to it; a username with no matching report comes back empty rather than showing someone else's marks, and a username that is not in the Login sheet is refused outright. Logging out asks for confirmation first.

Who it suits

Schools and academies publishing marks to students, and teachers who want a per-class read on speaking and reading scores without building a spreadsheet chart by hand each term. Colours, chart types and styling are all editable in the code if you want the dashboard to match your institute.