A college that could not see who was drifting until it was too late
The problem
Retention decisions were being made from three separate spreadsheets, once a term. By the time a learner was identified as at risk, they had usually already stopped attending, and nobody could reconstruct why a particular student had been flagged.
What we did
- Read engagement signals directly from the systems the college already used, through Microsoft Graph, rather than asking staff to enter anything new.
- Built a ranked cohort view with the contributing signals shown next to each learner, so a flag arrives with its reasoning attached.
- Added a student-facing portal showing the same picture, so a learner can question a flag instead of receiving it as a verdict.
- Isolated every institution's data at row level across thirteen core tables, with role-based access and full audit logging.
The outcome
- Live in production as a paying subscription customer.
- Weekly cohort review replaces once-a-term spreadsheet reconciliation.
- Every flag carries the signals that produced it, so a tutor can act or dismiss on sight.