How to modernize school administration in one term
A week-by-week plan for one term: what to move first, how to bring staff along, and what can wait until next term.
Learner and student management
Digital student information management: one record from first inquiry to leaving
What a student record should hold at each stage, who should see which parts, and how to handle siblings, documents and sensitive details.
In most schools, a student's information is spread across places that were never meant to fit together. The admission form sits in a cabinet, the guardian's phone number is in the class teacher's notebook, the fee history is with the accountant and the medical note is in an envelope in the principal's office. When a child falls ill at school, or a parent asks for a leaving certificate five years after their child left, someone has to put the pieces together in a hurry.
Digital student information management means keeping one record per student, started at the first inquiry and kept after the child leaves, with each part visible only to the people who need it. As an example, take Westbrook International School, a fictional school with two campuses, Riverside and Hilltop, and about 1,450 students. Roughly a third of its families have more than one child enrolled. These numbers are illustrative.
The record, stage by stage
Inquiry
A parent calls about a place in Grade 2. At this point you need very little: the child's name, the grade and year they want, how to reach the parent and how they heard about the school. Keep inquiries apart from enrolled students. Most inquiries never become students, and a student list full of children who never attended spoils every register and every count. Our post on the difference between admissions and students explains this split.
Application
When the family applies, add the date of birth, the previous school, the guardians and the documents you ask for, such as a birth certificate and the last school report. Then track the application through your stages. At Westbrook those are submitted, in review, an entry test, an interview, and then an offer or a place on the waiting list.
Enrollment
Enrollment should turn the application into a student record without anyone typing the details again. The student gets an admission number and a place in a grade and section for the current academic year, and everything collected so far carries over.
Each new year
At the end of every academic year, record what happened to each student: promoted to the next grade, retained in the same grade, graduated or left. Over time the record builds a short history, such as Grade 2 in one year, Grade 3 the next, and a repeated year if there was one. You need that history when a parent or another school asks what the child studied and when.
Leaving
When a student leaves, mark them as left and issue the leaving certificate from the record. Keep the record itself. Families come back for copies of certificates, and younger brothers and sisters may still be at the school.
Who sees what
A full record holds information that different people need for different reasons. Decide who sees each part before you set up any software, and write it down. A starting point that suits many schools:
| Part of the record | Who needs it |
|---|---|
| Name, grade, section and guardian contacts | Class teacher, subject teachers, office staff |
| Attendance and marks | Teachers of that class, the principal, the student's parents |
| Fees and payments | Accountant, principal, the student's parents |
| Medical notes | Principal, school nurse, class teacher when the condition affects the school day |
| National ID or birth registration numbers | Admissions and office staff who need them for official forms |
Campus matters as well. A teacher at Westbrook's Riverside campus has no reason to browse the records of children at Hilltop, so limit access by campus as well as by role. When staff move between campuses, change their access on the day they move.
Siblings and families
Siblings are where paper and spreadsheet records fall apart. The same mother appears on three records with three different phone numbers, and a sibling concession is missed because nobody connected the files.
Store each guardian once and link them to each of their children. When a guardian's phone number changes, it then changes for every child at the same time. Decide which guardian is the primary contact for each child. In separated families the answer may differ from one child to the next, and the school needs to know who receives reports and messages.
At Westbrook, linking guardians removes hundreds of duplicate contact entries, for example, and lets one parent login cover all of a family's children. It also helps the fee office, because family discounts depend on knowing which students belong together.
Documents and sensitive details
Keep scanned documents on the student record. A shared folder of files named by surname soon holds three files called "birth certificate final", and nobody knows which child each one belongs to.
Some details need more protection than the rest. National ID numbers and birth registration numbers can be misused if they leak, and medical notes are private health information. Store them encrypted and show them only to people with a specific permission. Ask any software provider how they do this, and whether these details ever appear in logs or downloads.
Keep a history of changes too. If a guardian's phone number was changed last week and a message then went to the wrong person, you need to know who made the change and when.
How SkoolBro keeps the student record
In SkoolBro, the record starts in admissions. Inquiries move through new, contacted, follow up, converted and closed, and applications through submitted, in review, test, interview, waitlisted, offered and enrolled. Enrolling an accepted applicant creates the student record from the application, links the guardians and gives the next admission number. If a brother or sister already attends, the same guardians are linked, so the family shows up together.
Each student record holds guardians, siblings and documents. Medical notes are visible only to people you allow, and national ID and birth registration numbers are stored encrypted and shown only to staff with permission to see sensitive details. At the end of each year you record whether a student was promoted, retained, graduated or left. Leaving, character and enrollment certificates are issued from the record, each with a number that anyone can check online, and a certificate issued by mistake can be revoked.
Roles decide what each person can do, campus access decides where, and every change is written to the audit log. Students and staff can be imported from CSV or Excel files, which our plan for modernizing school administration suggests doing in the first weeks of a term. Our post on how SkoolBro keeps each school's data safe covers security in more depth, and the security section of our home page gives a short summary.
Questions
What should a student record include?
Personal details, guardians and their contacts, the grade and section for each year, documents collected at admission, and outcomes such as promotion or leaving. Medical notes and identity numbers belong in it too, behind tighter access.
Who should be able to see a student's medical notes?
Only the people who need them to keep the child safe, such as the principal, the school nurse and the class teacher when the condition affects the school day. Write the rule down, then set the software to match it.
What happens to a student record after the student leaves?
Keep it. Mark the student as left or graduated, keep the record for as long as your school policy and local law require, and issue certificates from it. Families often come back years later for a copy of a leaving certificate.