Skip to content

Education · Operations · Live product

From a fragile spreadsheet to a live rota board, with AI that always asks first.

A live product we build and run: support-staff rota software for schools. Staff plan duty and lesson cover on a live board. The system publishes to staff and produces a PDF the same morning.

The challenge

What needed solving.

When someone calls in sick before school starts, the rota person needs a board. That board must already know the duties, the teaching clashes and who can cover. Most schools do this in a spreadsheet only one person understands.

AI can help draft cover. A wrong change to a school rota has real consequences. A person must approve every change before the system applies it.

What we built

The product, piece by piece.

01

Live Today board

Break, lunch, duty cover and lesson cover on one board, confirmed without rewriting the spreadsheet.

02

Clash-aware cover

Imported teaching timetables stop cover being assigned into a lesson. The system suggests support staff first.

03

One-click publishing

Confirmation updates the staff portal and calendars, with a PDF or Word rota the same morning.

04

AI assistant with previews

Chat can record absences and draft cover. The system previews every change. A person approves it before it touches the board.

Next.jsTypeScriptPostgreSQLLLM tool callingPDF generationRegional hosting

What it taught us

Lessons we bring to client work.

AI should propose, people should approve

Preview-first AI made the assistant trustworthy enough to switch on.

One owner, many viewers

Designing around the single rota owner kept the product simple for everyone else.

More work

Want something similar for your organisation? Custom software development

Free 30-minute call

Tell us what is slowing the business down.

Thirty minutes with the engineer who would build it. No salesperson. No slides. You get a straight answer on whether AI is the right fix.