A secondary school in Ogun State was tracking test and exam scores in a spreadsheet I had built for it. There was no full-time clerk, and results, fees and family details lived in different places.
The school wanted one system that teachers, the Director and, later, parents could each use without seeing what they should not.
What I built
The parts that matter.
A private login for every teacher
Each subject teacher enters scores for their own subjects only. Nobody can edit another teacher's work by accident.
The Director approves and locks
When a class is complete, the Director approves it and the scores lock. Missing work is flagged on the dashboard before approval.
Report cards in the school's own layout
Cards print or save as PDF in the layout the school already used, so nothing changes for families.
Fees matched to bank statements
Bills are set per class, part payments are recorded, and an uploaded bank statement is matched to students by the payer's remark.
Student profiles and bulk import
Admission forms are imported from a spreadsheet, and each child has one profile page with parents and contact details.
A parent portal, designed
Parents sign in with a phone number and see only their own child's report cards, fees and school notices.
Decisions behind it
A few rules came from the school, and I built them in. Student positions are never printed on report cards, because the school does not want learning framed as a competition. Fees and parents' phone numbers are visible only to the roles that need them. A student marked as left disappears from every live list but stays in the terms already approved.
The screens
Take a closer look.
Screens show a fictional school, Westbrook Model College, with invented names and scores. Select any image to enlarge it.
Fees: every child's bill and balanceScore entry for a subject teacherBank statement upload and payment matchingOne profile page for each childBulk import from admission formsThe parent portal on a phone
Built with
Under the hood.
FirebaseCloudflare PagesPlain HTML, CSS and JavaScript