End of term in many private schools means late nights adding scores by hand, mistakes in positions, and parents arguing about fees balances. Simple, consistent templates fix most of it: one admission form, one result sheet that calculates itself, one fees tracker that shows who owes what.
Quick answer: use a standard admission form with health and pick-up details, a result computation sheet that totals CA and exam scores, assigns grades, remarks and positions automatically, a report card linked to it, and a fees tracker that shows each pupil’s balance and status. Send standard letters for resumption, fees reminders, PTA meetings and excursions.
Get the School Admin Pack
Admission form, result computation sheet with automatic totals, grades, remarks and positions, report card template, school fees schedule and tracker for 100 students, and school letters and consent forms.
Get the template pack for ₦5,000 See what is inside (usually ₦8,000)
Result computation that calculates itself
- Use one sheet per subject per class and enter each pupil’s CA 1, CA 2 and exam scores (20/20/60 by default, adjustable).
- The sheet totals the scores, applies your grading scale (A to F by default; edit it to match your school, for example A1 to F9) and adds remarks.
- Each pupil’s position in the subject is calculated automatically; equal scores share a position.
- The class summary shows the number of pupils, class average, highest and lowest score and number of credits.
- Copy results into the report card and print.
Tracking school fees without arguments
| Column | Why it helps |
|---|---|
| Fees due by class | One schedule for tuition, uniform, books and levies |
| Payments with dates and receipt numbers | Evidence when parents query |
| Balance and status | See who has paid, part-paid or owes at a glance |
Send fees reminders to all parents at once with bulk SMS.
Admissions and letters
A complete admission form collects parents’ contacts, medical information, allergies and authorised pick-up persons. Keep standard letters for resumption, fees reminders, PTA meetings and excursion consent so every class teacher sends the same, correct information. Staff payroll for teachers? Use the Excel payroll and PAYE calculator.
Templates or school software?
Templates suit schools with a few hundred pupils and one administrator. As you grow, school management software adds parent portals, online fees payment and result checking.
Finish result computation in hours, not days
Type scores once; totals, grades, remarks and subject positions are done for you. Fees balances update as you record payments. Works in Excel and Google Sheets.
Get the template pack for ₦5,000 See what is inside (usually ₦8,000)
Frequently Asked Questions
How do I compute positions in Excel?
Use a total score per pupil and a RANK formula over the class. The School Admin Pack does this automatically for each subject.
Can I change the grading scale?
Yes. Edit the grade boundaries and remarks to match your school’s scale.
How many pupils does the fees tracker handle?
100 students out of the box; copy rows down to add more.
Does it work for primary and secondary schools?
Yes. Rename subjects and adjust the scale for nursery, primary or secondary.
Is there a school admin template pack for Nigeria?
Yes. The Lifehampers School Admin Pack includes admission form, result computation, report card, fees tracker and letters.
General information, not legal, tax or financial advice. Have a professional review documents for important matters.



Related guides
Need help with Business Templates & Guides?
Book a free consultation and get clear, practical next steps for your business.