The problem
Result time is when a school can least afford to wait on a network. Scores arrive from many teachers, positions and averages have to be worked out correctly — including ties — and every student needs a printed sheet, often on a deadline and in a building where the internet is unreliable or absent.
What we built
A self-contained program that keeps everything on the school's computer. The admin sets up classes, subjects and teacher accounts; each teacher sees only the subjects assigned to them and types CA 1, CA 2 and exam scores into a grid that works out totals and grades as they type. Class teachers add attendance and comments, the head adds the principal's comment, and the school prints one A4 sheet per student, a whole class to PDF, or a class broadsheet.
Key features
Works fully offline
No internet connection is needed to enter scores, compute results or print.
Windows and Linux
Packaged as an ordinary program; the target PC does not need Python installed.
Student records
Passport photo, class, guardian details, state and LGA; promote, move, or mark as graduated or left.
Teacher accounts
Each teacher sees only the subjects assigned to them.
Fast score entry
CA 1, CA 2 and exam in a grid, with totals and grades as you type — or paste a column straight from Excel.
Positions and averages
Subject and class positions with ties sharing a place, class averages, and highest and lowest per subject.
Cumulative results
Second and third term sheets carry earlier term totals and a cumulative average.
Printing and PDF
One A4 sheet per student, selected students or a whole class, a class PDF, or a broadsheet.
Configurable grading
School details and logo, score maximums, and editable grading scales for primary and secondary.
Backup and restore
Copy the whole database to a flash drive from the File menu, and restore it when needed.
Engineering challenges
Positions that treat ties fairly
Students with the same score share a position and the next position is skipped — 1st, 2nd, 2nd, 4th — as schools expect on a result sheet.
Backups that are safe while the program is running
Backups use SQLite's own backup mechanism rather than copying the file, and a restore checks that the file really is a School Result Manager database before replacing anything.
Result
Delivered to a school and used to produce its term result sheets offline.