Spreadsheet replacement plan for admissions and enrollment

1. Understand the spreadsheet estate

Inventory files, tabs, formulas, filters, owners, copies, downloads, email attachments, linked documents, reports, temporary lists, and external integrations. Identify applicants, guardians, documents, decisions, offers, waitlists, enrollment, and messages in each location.

Record purpose, users, sensitivity, source of truth, update frequency, retention, correction route, and dependency. Do not assume the file with the clearest name is authoritative.

2. Define the replacement workflow

Map inquiry, application, document review, assessment, decision, offer, acceptance, waitlist, enrollment, withdrawal, and correction. Define owner, data, status, permission, approval, family message, exception, handoff, and outcome.

Decide what remains manual, what integrates, what is archived, what is excluded, and what must be held until evidence exists. A replacement should remove risk, not simply recreate the same tabs in a new interface.

3. Prepare and govern data

Profile duplicates, missing values, stale contacts, inconsistent statuses, unclear guardian relationships, rejected documents, and conflicting decisions. Create mapping, transformation, validation, duplicate, document, status, retention, and reconciliation rules.

GOV.UK procurement guidance recommends minimum necessary data, access control, security, supplier accountability, incident notification, and end-of-contract handling. The U.S. Department of Education checklist connects quality, access, security, lifecycle, sharing, disposal, and monitoring.

4. Configure roles and test

Define view, create, edit, approve, publish, export, correct, archive, and delete permissions for admissions, records, leadership, families, support, campuses, and suppliers. Test incomplete, duplicate, changed-guardian, waitlist, withdrawn, and accepted cases.

Record expected result, observed result, evidence, exception, owner, severity, support route, and release decision. Test the family view and student-record handoff separately from the admissions view.

5. Plan cutover and continuity

Set freeze, final extract, validation, acceptance, communication, training, support, incident, temporary-work, reconciliation, and hold decisions. Keep source evidence according to the approved lifecycle plan.

If the replacement is not ready, keep the old process narrow and controlled. Do not create a second uncontrolled data estate to bridge an unclear cutover.

6. Retire the old estate

After acceptance, restrict or retire obsolete files according to the school’s retention and legal decisions. Confirm what is archived, returned, deleted, or kept for a defined reason. Record remaining copies and owners.

Review duplicates, corrections, access exceptions, support demand, family experience, and the intended outcome at 30, 60, and 90 days. Expand only when the new workflow works in practice.

Turn the guidance into an admissions decision

Apply this guidance to one bounded part of spreadsheet replacement plan for school admissions software. Define the applicant or student journey, the people involved, the source of each value, the permission boundary, the evidence required, and the condition that pauses the next step.

Test a complete case and meaningful exceptions such as an incomplete application, changed guardian, duplicate student, withdrawn applicant, late document, waitlist movement, or transfer. Record what happened, who corrected it, and how the applicant received a clear status.

Keep vendor capability, school responsibility, legal advice, and measured outcome separate. If evidence is incomplete, narrow the claim and the rollout rather than treating an assumption as a promise.

Review the decision at 30, 60, and 90 days. Look at completion, data quality, response time, access exceptions, family experience, support demand, and the original outcome. Decide whether to expand, repair, consolidate, or hold.

Before approval, ask an accountable reviewer to challenge the strongest claim. Replace broad language with the exact evidence, population, date, and limitation the school can verify.

Make the final record readable to an admissions operator and a reviewer who was not in the project. State what passed, what remains manual, what is deferred, who owns the unresolved item, and how a family receives help without creating an uncontrolled copy of applicant data.

Keep the approved record beside its acceptance tests, support guidance, and change history. A new campus, role, field, calendar, supplier, or family-facing output can change the risk even when the original workflow appears unchanged.