Five signs your school has outgrown its spreadsheets

Almost every school starts with a spreadsheet. It is free, everyone half-understands it, and for a school of two hundred learners it genuinely works. The trouble is that spreadsheets fail slowly, so the moment you have outgrown them is rarely obvious.

1. Two people disagree about the same number

The bursar's fee balance and the head teacher's fee balance differ, and both are working from a file they believe is current. When the answer to "how much is outstanding?" depends on who you ask, the data has stopped being a record and started being an opinion.

2. Term reports take a week of evenings

If marks are collected on paper, retyped into a workbook, and then copied into a report template by hand, the school is paying for the same information three times. Worse, each retyping is a chance to introduce an error that a parent will notice before you do.

3. Nobody can answer a question without opening a file

"How many learners in S3 have cleared fees?" should take seconds. If it takes a phone call and a laptop, the information is not really available to the people who need it.

4. The person who built it has left

Schools accumulate one heroic spreadsheet maintained by one person. When that person moves on, formulas break in ways nobody can trace, and the school quietly reverts to paper.

5. Parents ask for things you cannot produce

Payment histories, attendance summaries, term-on-term performance — parents increasingly expect these on request. A spreadsheet can hold the data but cannot deliver it.

What to do about it

None of this means spreadsheets were a mistake. They were the right tool for the size the school used to be. The signal to move is not a particular enrolment number; it is the moment the school starts spending more time maintaining its records than using them.