Data-readiness guide for school management, ERP, and SIS

What data readiness means

Data readiness is not the ability to export a spreadsheet. It is the ability to explain what each record means, who owns it, which values are required, how errors are corrected, who may access it, and what the school needs to prove after migration.

The work should cover students, guardians, relationships, staff, classes, subjects, academic dates, fees, payments, attendance, assessments, documents, communications, and historical records in proportion to the chosen phase.

Step 1: create the data inventory

List every source, owner, purpose, field group, retention expectation, access group, export, and downstream report. Include local files and informal lists that are not treated as official systems but still influence decisions.

The U.S. Department of Education data governance checklist treats governance as a lifecycle from acquisition and use through access, quality, sharing, security, disposal, and monitoring. Use that lifecycle to find gaps beyond the main database.

Step 2: define the source of truth

For each important value, record one source of truth and the process for correcting it. If two teams legitimately need different values, name the distinction instead of allowing two unlabeled fields to drift. Decide how identity is matched when names, contacts, or class assignments change.

Write business rules in language that an owner can test. “Clean names” is not a rule. “A guardian relationship must have an identified student and an approved contact method before family access is issued” is closer to an operational test, subject to local policy.

Step 3: profile quality and exceptions

Sample records and measure duplicates, blanks, invalid values, stale contacts, conflicts, and unexpected formats. Separate fixable data errors from unresolved meaning. A missing value may require a conversation with the owner, not a default inserted by a script.

Keep an exception register with record category, issue, impact, owner, correction, due date, and validation result. Prioritize exceptions that affect identity, access, fees, attendance, assessment, reporting, or family visibility.

Step 4: prepare safe test data

Build a representative test set without exposing unnecessary live personal information. Include ordinary cases and edge cases such as duplicate applicants, missing guardians, changed classes, concessions, withdrawn students, role changes, unpublished results, and archived records.

Record which values were fictionalized and which relationships the sample is meant to test. A small but intentional dataset is more useful than a large extract that nobody can review.

Step 5: define validation and sign-off

Agree on reconciliation outputs before migration: counts, identity matches, class rosters, balances, reports, permissions, exports, and family views. Name the person who signs off each output and the condition that blocks the next step.

Data-quality guidance from the U.S. Department of Education highlights business rules, validation processes, infrastructure, and professional learning. Include training and ownership in the sign-off plan, not only technical comparison.

Step 6: review privacy and lifecycle controls

Map purposes, users, access, retention, transfers, subprocessors, incident handling, and deletion or return. GOV.UK procurement guidance recommends involving the data protection officer early and checking security, access control, breach notification, and end-of-contract handling. Local legal review remains necessary.

A readiness decision

A school is ready to proceed when it can name the source of truth, owners, critical exceptions, test data, acceptance outputs, permission boundaries, and hold rule. If one of those is unknown, narrow the phase and resolve the uncertainty before calling the migration ready.