Student Result System with Marks Entry – Google Apps Script

R20 splits the job in two, which is how a result system actually gets used. Staff open one link to enter marks; students open a different link to check them. Same spreadsheet behind both, two separate deployments, and nobody's students are one URL guess away from the marks entry screen.

The entry side

Add Data opens a form for one student's result: the name, the class, the roll number, then the marks subject by subject, a grade and remarks. Existing records can be edited — change a mark and the totals recompute — or deleted. The total marks for each subject are set in a column of the sheet that the walkthrough tells you plainly not to touch, because everything else is calculated from it.

A dropdown, not a text box

The student's name is chosen from a list rather than typed, and the reason is worth repeating: typed names are where school databases go wrong. One record says Ahmed Ali, the next says Ahmad Ali, and a student now exists twice with half their marks in each. A dropdown makes that impossible.

Marking that works itself out

Each subject is judged against its own total: below forty percent fails, above passes. The overall totals update as marks are entered or corrected, so nobody is adding columns by hand at the end of term.

Splitting by class

If you would rather each class had its own sheet, the walkthrough shows using a QUERY formula to pull just that class's rows into a separate tab, then adding that class name to the dropdown in the student portal. The class name must match in both places.

Setting it up

Two copies, two deployments: the data sheet and the result script each get your spreadsheet ID pasted in, and each gives you a link — one for the office, one for students.