Admissions
Kill spreadsheet chaos in school admissions
Apply, track, verify, offer, enroll - one pipeline from inquiry to live student record. Cut status phone calls and stop retyping accepted students.
Not reviewed by a named subject-matter expert. This piece passed our automated checks for dated evidence, working internal links, and claims that stay inside what the product does, see our editorial standards.
Why admissions breaks when it lives in spreadsheets
Most schools start with a shared workbook: one tab for inquiries, another for tests, a third for fee deposits. By March, version conflicts, missed follow-ups, and “which row is the source of truth?” meetings consume the front office. Families call daily for status because there is no self-service track page.
The fix is not a prettier spreadsheet - it is a pipeline where each stage writes to one record that becomes the student profile after enrollment.
Stage 1 - Families apply online
Online apply reduces walk-in queues and gives admissions a consistent data shape. Staff should not re-key names, dates of birth, or sibling links from paper forms.
- Public apply page with configurable forms per intake cycle
- Document uploads at submission (birth certificate, previous report card, photos)
- Automatic application ID families can reference immediately
- Guardian contact details validated before staff review begins
Stage 2 - Verification and committee review
Verification gates matter: enrolling a child with missing documents creates downstream problems for compliance and fee billing. Mark documents verified once, and every downstream team sees the same state.
- Document verification queue with staff notes before tests or interviews
- Status changes visible on a public track page (no login required for applicants)
- Committee views scoped to assigned applications - not the whole school database
- Interview and test scheduling tied to the same application record
Stage 3 - Offers and enrollment into roster
This handoff is where many “school CRM” tools fail: accepted applicants sit in an admissions module while registrars manually create SIS records. Schoolyi enrolls into roster records so finance and academic teams see the child on day one.
- Offer letters generated from accepted applications
- Accept/decline captured on track pages or by staff on behalf of families
- Enrollment creates live student records - class placement, fee structure, guardian links
- No duplicate student profiles when the child was already a sibling in the system
Metrics principals should track weekly
When admissions connects to fees and roster, leadership can answer “how full is Grade 1?” with live numbers - not a spreadsheet refresh.
- Inquiries → submitted applications conversion
- Average days in document verification
- Offer acceptance rate by grade or program
- Time from acceptance to first fee receipt
- Status calls deflected by public track pages
Roll out admissions first, expand later
Schools often go live with apply, track, and enrollment in term one, then add timetable and exams when registrars trust the data. See the admissions module on the platform and the admissions software guide for product specifics.
