A record for every school in the country
The charity wanted to reach ten thousand schools with its gardening programme. To do that, the team needed one reliable answer to a simple question: which schools are there, and what do we know about each one?
Answering it turned out to be the interesting part. School data is published by three different governments — England and Wales, Scotland, Northern Ireland — and none of them structures it the same way. On top of that, the team knows things about a school that no government file contains, because a teacher has told them.
So we designed a system that holds both. The official data refreshes every month and is never lost; the knowledge the team has built up is protected and never quietly overwritten. When a teacher spots something wrong, they report it through their own portal, it reaches the right person automatically, and they hear back when it's fixed. The loop closes.
We designed, built and went live between April and July. The part I'm proudest of came after: the team took it on with a full design document, a test pack, seven runbooks and a working wiki. Nobody was left holding something they didn't understand.