From registers and spreadsheets to one school system

The situation: years of good records in the wrong shape

Most school offices are not short of records. They have admission registers going back years, a spreadsheet of students per class, fee ledgers, and a folder of report-card files. The records are usually good. They are just in the wrong shape: each one was built for a single job, so the same student appears in all of them with small differences in spelling, class or phone number.

The tension: double entry never stops by itself

As long as each job keeps its own list, every change has to be made several times. A student moves section, and the attendance register, the fee spreadsheet and the report-card file all need the same correction. Somebody misses one, and the office spends the next month reconciling.

The insight: one record per student, everything else hangs off it

The move to one system works when it is planned around a single idea: each student is entered once, and attendance, fees, marks and notices all read that same record. That changes the order of work. You do not start with fees or report cards; you start with the student list.

The decision: the order that works

1. Clean the student list first

Take your best list of current students and make it the master. Check, class by class:

• one row per student, with the same spelling everywhere;
• class and section as the school uses them today;
• the parent or guardian contacts the office actually uses;
• siblings marked, so a family is one family and not two.

2. Bring in staff and roles

List the people who will use the system and what each one does: principal, office, accounts, class teachers, academic head. In Campus One each person gets their own login, and each role sees only what it needs.

3. Import fees as a roster, payments as a statement

Fees are two different things: what each student should pay (the fee plan, with instalments and concessions) and what has been paid. Keep them apart. In Campus One, the fee roster and the payment statement each have an importer that checks every row and shows it to you before anything is saved; the rows that fail can be downloaded, fixed and imported again. The importers read CSV, so save Excel sheets as CSV first.

4. Start the day in the new system

Once the lists are in, the daily work moves: teachers mark attendance, accounts record payments and issue numbered receipts, the office works the admissions pipeline. Keep the old registers on the shelf for reference, but stop writing in them.

5. Check the first week

At the end of the first week, look at what needs attention: overdue fees, pending follow-ups, missing documents. If a number looks wrong, open it: in Campus One the dashboard numbers open the records behind them, so a wrong figure leads straight to the row that caused it.

The evidence: how Campus One sets up a school

Campus One's set-up has four steps, the same ones on our how it works page: the team imports students, staff and fees from your registers or spreadsheets; each person gets a login; the office runs the day from one place; dashboards show what needs attention. Set-up and data import are free with yearly prepayment, including configuration and online training.

Two honest limits apply today. Campus One runs with a made-up demo school, and real school data is loaded only after it moves to a server in India. An import wizard for merging old records is not built yet, so the first import is done with our team.

Common mistakes to avoid

• Importing everything at once. Bring in the current students first; old years can follow once the current year runs well.
• Importing before naming is agreed. Decide how classes and sections are written, for example "7" or "VII", "A" or "Section A", before the first import, or the system will hold both.
• Forgetting siblings. Two children of one family entered as two families means two sets of contacts to keep up to date.
• Running two systems for too long. Keep the paper registers for reference, but set a date after which nobody writes in them.

The outcome: fewer places to be wrong

The aim is not a perfect migration of every old page. It is a school office where a change is made once and seen everywhere, and where the record of who changed what is kept by the system rather than by memory.

The takeaway

Start with one clean student list, add people and roles, then fees, then the daily work. If you would like to see the order in practice, ask for a walkthrough of the Campus One demo school.