How to Make Student Result Portal in Google Sheets + Apps Script | Admin & Teacher Dashboard | D35

A student result portal with a working back office. Teachers log in and enter marks for their own classes; admins manage students and see everything; the result comes out as a printable report card. All of it on Google Sheets, with no server behind it.

Marks entry that does not fight you

The marks grid filters by teacher, class and subject, so a teacher lands on exactly the set of students they need and nothing else. Marks are edited inline — click the cell, type the number, move on. There is no separate edit form and no modal in the way, which is the difference between entering a class of forty in five minutes and in half an hour.

Permissions that match how a school works

Teachers see only the classes assigned to them, so one teacher cannot alter another's marks, deliberately or by accident. Admins get the full picture plus student CRUD — adding new students, editing details and removing leavers without touching the sheet directly.

Grades and report cards

Grades and the overall average calculate themselves from the marks as they are entered, so nobody is maintaining a parallel formula column. Each student has a per-subject breakdown, and the report card is print-ready — no export, reformat and reprint cycle.

Who it suits

Schools and colleges that need several teachers entering marks into one system, coaching centres tracking batch performance, and anyone who has outgrown passing a marks spreadsheet around by email. It is also a clear reference for building filtered, permission-aware CRUD in Apps Script.

Setup

Copy the sheet, deploy the script, add your teachers and classes. Google Sheets is the database and the layout works on a tablet, which is what most teachers will actually use. The video covers the whole build, and support is free if you get stuck.