Most Nigerian schools run on spreadsheets. There is a class list in one file, the fee ledger in another, scores in a third, and a phone list on the bursar’s laptop that nobody else can open. It works, until a file is lost, two versions disagree, or the one person who understands the formulas leaves.
Moving to a proper school management system sounds like a term’s work. It isn’t. With a plan, a school can move in a week, and the holiday is the best week to do it. Here is the plan.
Before you start: decide who leads
Pick one person to own the move: usually the vice principal, the head of ICT or an experienced administrator. They don’t need to be technical. They need to know the school, have the authority to ask teachers for information, and be free for an hour or two each day of the week.
Day 1: Gather what you already have
Don’t start typing. Start collecting. Ask for the files you already keep:
- Class lists for every class, with each student’s full name, date of birth and admission number.
- Guardians, with names, phone numbers and email addresses. Most schools have these in the admission files or the bursar’s list.
- Staff, with the subjects and classes each one teaches.
- Fee items for next term, by class, with any bus, hostel or other charges.
- Your grading scale and CA split for each section.
They don’t need to be perfect or in the same format. They need to be the most recent versions.
Day 2: Clean the lists
Spend a day on the class lists, because everything else hangs off them. Look for:
- The same student twice, often spelled two ways.
- Surnames and first names in the wrong columns. Decide once how names are written, such as surname first, and stick to it.
- Students who have left but are still on the list.
- Missing guardians, or a phone number shared by two unrelated families.
Ask class teachers to check their own class. They know their students better than any spreadsheet.
Day 3: Set up the school
Before any records come in, set up the shape of the school:
- The session and terms.
- Sections and classes, such as Nursery, Primary, JSS and SS, with arms like Gold and Blue.
- Subjects for each class.
- Grading and CA split, which may be different for each section.
- Who does what: class teachers, subject teachers, the bursar, the head.
This is the step people rush, and it is the one that makes everything else work. Take the whole day if you need to.
Day 4: Bring the records in
Now import the cleaned lists: students into their classes, guardians linked to their wards, and staff linked to their subjects. A good system shows you what it is about to import before it goes live, so you can catch problems: a class that doesn’t exist, a student with no guardian, a phone number in the wrong format.
Check the import with someone who knows the school. Better to fix ten small problems now than to discover them when parents start signing in.
Day 5: Set up fees
Enter next term’s fee items for each class, the bus and hostel charges, and any discounts, such as for siblings or staff’s wards. Carry over each family’s outstanding balance from your fee ledger, so nobody’s debt disappears and nobody is billed twice.
Then check a few bills by hand. Pick a family with three students, one who rides the bus and one in the hostel. If those bills are right, the rest probably are.
Day 6: Train your staff
Train in short sessions, by role, not one long meeting for everyone:
- Class teachers: taking the register on their phone. Fifteen minutes.
- Subject teachers: entering scores and setting a test. Thirty minutes.
- The bursar: recording payments, receipts and the debtors list. An hour.
- The head: the school at a glance, and approving report sheets. Thirty minutes.
Have each person do the real task during training, on their own phone, not watch someone else do it.
Day 7: Tell parents
Last, tell parents. A short message from the school, before resumption, with:
- What is changing: bills, receipts, report sheets and notices will come through the parent portal.
- How to sign in, with the phone number or email the school has for them.
- Who to call if their details are wrong.
Then send the first bill. Nothing gets parents to sign in faster.
After the week: keep the spreadsheets, stop using them
Don’t delete your old files. Keep them, read-only, for reference. But from the first day of term, everything new goes into one record. The moment two places are kept up to date, the problem you were trying to solve comes back.
A checklist for the week
- Pick one person to lead.
- Gather class lists, guardians, staff, fee items and grading.
- Clean the class lists with class teachers.
- Set up sessions, classes, subjects and grading.
- Import and check the records.
- Set up fees and carry over balances.
- Train staff by role, then tell parents.
How AnySchool helps
On AnySchool, Records and admissions brings every student and guardian across from your spreadsheets in one go, and we check the import with you before it goes live. Academic set-up handles your sessions, classes, subjects and grading, and Fees and receipts builds each student’s bill. We set your school up in a week and train your staff with you.
Start the new term on one record, with one term free.