What a student information system replaces, line by line

A student information system replaces seven things a school keeps by hand, and it is worth naming them one by one, because the list is what justifies the change: the admission form, the student file, the roll-number register, the class register, the mark sheet and report card, the promotion and leaving record, and the parent contact list. Each is a record with a name on it, each is kept by a different person today, and each fails in its own specific way when it lives in a file or a spreadsheet.

The temptation is to describe a student information system by its features. That is backwards. The way to judge one is to follow a single child from the first enquiry to the leaving certificate and ask, at every step, where the record lives and who retypes it. Every place the answer is the same information entered again is a place the school pays for its data twice.

That test also explains why so many schools run a student information system already without calling it one. The admission register, the attendance register, the mark sheet ledger and the class files are all records, and none of them talks to the others. The system worth buying is the one that keeps a single record and lets every register be a view of it, so that adding a child in one place is enough.

1. The admission form

On paper, the admission form is a sheet filled once and then filed. In a system it is a record with stages, so the school can see how many applications sit at each point, how they are spread across classes, and which documents are still missing for a given child. The value is not the form. It is that the same record carries into everything the school does with that child afterwards.

Two things follow from that. A withdrawn application is kept with its reason rather than deleted, so the year stays explainable when someone asks in March why two classes were never filled. And because the applications can be read by class before the year starts, the school can see where the intake is heavy and where it is thin while there is still time to do something about it.

2. The student file

When the applicant is admitted, the file becomes the record of the student: personal details, contacts, medical notes, the previous school, and the history that used to be scattered across a folder. Where a school keeps one folder per child, a student profile holds the same fields as a single record, so the office is not hunting through a cabinet to answer a question about one child.

The day-one problem is the records the school already has. Those usually sit in a spreadsheet, or several, with the details spread across columns that different people maintained. A system that can import them, rather than asking the office to retype every child into a new form, is the difference between a migration that happens in an afternoon and one that drags on until everyone has given up on it.

3. The roll-number register

The register of roll numbers is small, but it shows the pattern. Rolls change every year; assigning them by hand takes a week of office time and produces duplicates that take another week to find. A system that assigns roll numbers in a format the school chooses turns that week into a setting, and a record that assigns the number itself does not fall behind the way a handwritten register does.

It is a good test of a system, because it is the smallest task on the list. If a routine job like numbering a class still means a spreadsheet and a week of care, the larger jobs will not be easier. The small tasks are where the record either holds together or does not.

4. The class register

The class register is the record teachers touch every day, and the clearest case of paying for data twice. Marking attendance on paper and typing it up later is two entries for one fact, and by the time it is typed the fact is old. Marking it in the place it is taken means the attendance record answers the office question — who is absent today — without anyone waiting for a transcription.

Once the mark lands in the record from the classroom, the register stops being only a register. It becomes the thing the school acts on: a message to the family the same morning for an unexplained absence, and a list for the class teacher of the children who have missed more than a threshold this term. A paper register can produce both, slowly and only if someone chooses to compile them. A record produces them because it is asked.

5. The mark sheet and the report card

The next area is everything built from marks: the mark sheet, the report card, the transcript. When marks are recorded once, against the components the school actually assesses, the card and the transcript are the same record seen from two angles. When they are not, the transcript is retyped from the card, and the two can disagree. That is the worst outcome of all, because both look official.

The same record is what makes the useful reports possible at all. A transcript per child, a summary by class, a view of one subject across a year: each is a question asked of the marks, not a document compiled by hand. When the marks are one record, a new question next year does not mean a new register to maintain.

6. The promotion list and the leaving record

At the end of the year come the two operations a paper system handles worst. Promotion moves a whole class up a level, and a system does it against the criteria the school sets rather than by rewriting forty files by hand. Leaving, when a child departs, archives the record with its reason instead of deleting it, so the year stays explainable and a leaving certificate is produced from the same record rather than a fresh sheet.

7. The parent contact list

The last thing replaced is the one that matters most outside the office. Every absence message, circular and fee reminder in the school goes to the same guardian contacts, and those contacts live on the student record. When the list is a notebook, the message that matters is the one that does not arrive. When it is one list, the same channel carries everything the school needs to say, and the school can see what has already been sent.

A parent profile is the other half of this. Where the school once spoke only to a single contact number, a record of the family lets the right message reach the right adult and lets the school keep straight which child each contact belongs to, which matters most in a school where siblings share a household.

The measure of whether a contact list works is not how long it is but how current. Numbers change, guardians change, and a list updated only at admission drifts out of date within a term. Refreshing the details at the points where the family is already in touch, and correcting them against the record, is what keeps the messages arriving where they are meant to.

What it looks like when all of it is replaced

The test is not how many features a system lists. It is whether a single child can be followed through it without the information being entered twice. When the answer is yes, the office stops being a place where records are kept and becomes a place where records are used: a transcript is produced rather than assembled, a question about a child is answered from one screen, and a report for the trust is drawn from the data rather than compiled by hand from several registers.

There is a second effect, less obvious and more valuable. When the record is one record, a child who is falling behind becomes visible from the data itself, attendance and marks read together, rather than being noticed only when a teacher happens to mention it. The register is not the point. The things the register makes visible are the point, and those are the things a school acts on.

The metric to watch

Watch the number of times the details of a student are entered into a computer in the course of a year. In a paper-and-spreadsheet school the number is large — admission, roll number, attendance, marks, promotion, leaving — and each entry is a chance to introduce a difference. One record means one entry, and one entry means the figures on every document the school issues agree with each other.