In this guide 6 sections
A learner typed into four registers will drift apart: names spelled two ways, a wrong batch, a different roll number. Find the drift by matching each list against the admission register on a single key, such as the admission number, then reading every row that fails to match.
Where one learner is typed four times
Admission staff write the first record. Accounts copies the name into the fee register. The class teacher writes it again on the attendance sheet, and the exam cell types it once more for hall tickets and mark lists.
Each copy is made by a different person from a different source, and a spelling slip in one list is rarely carried back to the other three. Nobody checks.
After a year the roll number on the hall ticket disagrees with the roll number on the fee receipt, and the office cannot say which one is right. Nobody can say without opening a cupboard.
The mismatches that show up first
Names cause most trouble. Initials come before the surname on the attendance sheet and after it on the hall ticket list, while the fee receipt’s middle name vanishes from the mark sheet. When the board or university asks for names exactly as on the birth certificate, every difference becomes a correction request.
Batch and section errors are quieter. Students move. A learner shifts from section B to section C and the teacher updates attendance that morning, yet the fee register keeps grouping that child under B all year.
Dates of birth deserve a second look. An entry of 04/05/2012 can mean April or May depending on who typed it, and a transfer certificate from the previous school may disagree with both. Pick the document that counts. Match everything to it.
- Name order, initials and middle names
- Date of birth entered in different formats
- Section or batch changed in one list only
- Roll number reused after a transfer
- Guardian phone number out of date
- Students on the fee list who are absent from attendance
Checks that expose the gaps
Export each register to a spreadsheet and add the admission number to every one, because a fee register that lacks the number is itself a finding. Then run a VLOOKUP against the admission list, mark every unmatched row in yellow and hand the sheet to the class teachers.
Next, compare counts. If the admission register holds 412 active students and the attendance sheet covers 405, seven learners are being taught without a recorded presence. Find them.
Last, sort each list by section and read the first five rows and the last five rows of every section, because typists tire at the edges. Odd spellings, stray spaces and half-typed surnames cluster at the edges, where a tired typist stops caring.
- Count of active students in each register
- Rows with no admission number
- Same student in two sections
- Fee payers absent from the attendance list
- Marks entered for a student not on the roll
Choose one master list
Treat the admission register as the source. The others are views of it. Names, dates of birth and guardians are changed there and nowhere else, and every other list picks the change up from that single place.
On paper this means one person owns corrections. The slip travels to that desk. In software it means one student record that the fee, attendance and exam screens all read, so a correction made once appears everywhere.
Name an owner and a deputy. The admission officer holds the master list. A request slip with the old value, the new value and the proof reaches that desk before any other register is touched.
Run the check every term
Put the matching exercise in the calendar before fee demands, before hall tickets and before result day, so that no printed document carries an error nobody looked for. Two hours is enough once the first clean-up is done. The first takes a full day. Book it.
Keep a short log of what you found. If the same mismatch returns, such as a transfer certificate entry that never reaches the exam cell, fix the step that causes it and not just the row.
Share the findings with staff in plain terms. A list of fifteen corrected names, sorted by section and pinned in the staff room, teaches more than a circular about data quality ever will.
Register match worksheet
One page, four columns, four lists. Rows hold the checks, from active count and rows without an admission number to name differences, batch differences and duplicate roll numbers. Each row has spaces for the count found, the person fixing it, the date cleared and any note on why the same error keeps returning.
Open a blank worksheet to printQuestions owners ask
Which register should be the master?
The admission register, because it is created first and holds the original documents that every later list merely copies. Every other list should read from it. If it is messy, clean it first against birth certificates or transfer certificates, because comparing four lists to a bad master only spreads the mistakes.
How do we handle two students with the same name?
Never match on name alone. Use the admission number with the date of birth as a second check, and keep the guardian phone number as a tiebreaker when two records still look alike.
Can a spreadsheet do this check?
Yes, for one school. A lookup on admission numbers finds most mismatches. It becomes tedious when lists change weekly. Software removes the retyping, though the first clean-up of old records still needs a person with the files in hand.