Parents' Evening Booking System: Slots, Reminders and Clashes With AI

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Parents' Evening Booking System: Slots, Reminders and Clashes With AI.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Parents' Evening Booking System: Slots, Reminders and Clashes With AI.

Give every teacher a fixed grid of slots, let families pick their own from one booking page, and use a tool that locks a slot the instant it is taken. For a small school that means a booking tool or a carefully built sheet, plus a rule that families with siblings book first.

Double bookings rarely come from the booking tool itself. They come from three habits: a paper list kept alongside the online one, slots that overlap because a teacher's break was never subtracted, and brothers and sisters in different classes whose two appointments land at the same minute. The maths and the checks below deal with each of those.

Follow me on Instagram@sagnikteaches

Why small schools double-book, and where AI actually helps

A school of sixty pupils feels simple, which is exactly why it goes wrong. Nobody has a system, so the evening is built from a class list, a clipboard and goodwill. Then a teacher is pulled into a corridor conversation, a parent turns up early, and the neat list is out by twenty minutes before the second slot.

Connect on LinkedInSagnik Bhattacharya

AI will not run the evening. What it does well is the unglamorous prep: turning your constraints into a slot grid, spotting families who appear twice, drafting reminders in three tones, and reading a booking export for clashes in a minute rather than an hour. I would use it for those four jobs and keep a person in charge of the live evening.

Subscribe on YouTube@sagnikteaches

One rule before you paste anything: give the AI pupil numbers or initials, never full names, and keep the key in your own file. The tool only needs the structure of the problem. It does not need to know who anyone is. If you want the wider picture of how to judge any scheduling tool, the booking-system checklist covers it.

The Complete Excel Course with AI Integration thumbnail

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

The slot maths for a school of sixty pupils

Here is a worked illustration for a small independent primary: 60 pupils, 52 families (some have two children), four class teachers and two specialists, say music and art. Every family sees their class teacher. About 60% also want a specialist. You want eight-minute meetings.

Step 1: Turn a meeting into a slot

An eight-minute meeting needs a two-minute changeover, so the slot is ten minutes. Never sell the meeting length as the slot length: the changeover is where lateness is absorbed.

Step 2: Subtract the teacher's breaks

Teachers cannot talk for three hours without stopping. A sensible rule is a ten-minute break after every six slots. That means a 4pm to 7pm window (180 minutes) holds two full cycles of 70 minutes (six slots plus the break), which is 12 slots and 140 minutes, plus four more slots in the last 40 minutes. The total is 16 slots, not the 18 you get by dividing 180 by 10.

Step 3: Compare demand with supply

  • Class teachers: 52 families split across four classes gives about 13 families each. Supply is 16 slots, so three are spare. Hold two back as a late-request reserve.
  • Specialists: 60% of 52 is roughly 31 families each. One 4pm to 7pm evening gives 16 slots, so they need a second evening.
  • Second evening: if it runs 4pm to 7.30pm (210 minutes), two full cycles give 12 slots in 140 minutes and the remaining 70 minutes gives six slots and a ten-minute gap, so 18 in total. Across both evenings that is 16 + 18 = 34 slots against 31 expected bookings.

That leaves only three spare per specialist, which is thin. The usual fix is to cap each family at one specialist slot until a set date, then open the remainder. This is the sort of rule you only discover when you do the sum before the booking page goes live.

Step 4: Give the sum to an AI to check

Arithmetic mistakes in a grid are easy to make and boring to find. A prompt like the one below lets an AI rebuild the grid and show its working, and you compare it with yours.

I run a parents' evening for a small school. Build a slot grid and show your arithmetic.
- Meeting: 8 minutes plus 2 minutes changeover = 10-minute slot
- Break: 10 minutes after every 6 slots
- Evening 1: 16:00-19:00. Evening 2: 16:00-19:30
- Teachers: 4 class teachers (13 families each), 2 specialists (about 31 families each)
- Hold back 2 slots per teacher for late requests
Output: a table of slot start times per evening, the count of slots per teacher, and any teacher whose demand exceeds supply.

An illustrative reply gives you the start times (16:00, 16:10 and so on through 16:50, then a break to 17:10) and a line such as "Specialist demand 31, supply 34, spare 3". What you would fix: AIs sometimes forget the break after the final full cycle, or count the break as a slot. Check the start time of slot seven. It should be 17:10, not 17:00.

Booking tool options, and what to verify before you pay

There are three routes. Which one fits depends on how many teachers share a family and how much admin you want to own.

RouteSuitsWhat to check
Sheet plus formUnder about 40 families, one or two teachers per familyDuplicate slots, no automatic sibling check, manual reminders
General appointment tool such as CalendlyA tutoring centre where each family books one tutorOne calendar per teacher, nothing links a family across teachers
Parents' evening system such as SchoolCloud or Parents BookingSeveral teachers per family, siblings, video callsPer-pupil yearly price or a quote, set-up from your pupil data, parent log-in

Dedicated parents' evening systems are built around the problem you have. SchoolCloud's parents' evening product, which Tes now also sells as Tes Parents' Meetings, describes an automatic gap between appointments so parents reach the next one on time, enforced travel time between appointments, an automatic booking mode that finds an efficient schedule for a parent seeing several teachers, a waiting list for busy teachers, and video appointments that run in the browser. It syncs teachers, pupils and classes from common school management systems, and Tes asks schools to request a quote.

Parents Booking also imports class data from the school's management system, lets parents sign in with single sign-on or a magic link instead of registering, sends schedules and reminders automatically, and has a wizard that finds an efficient schedule for each parent. Unusually, it publishes its price: a yearly subscription charged per pupil with a minimum annual charge, plus a per-pupil add-on for video meetings. At the published per-pupil rate, a school of 60 pupils, or even 250, sits below the minimum, so a small school pays the floor price whatever its size. Check the current figures and the cost calculator on its pricing page, and from any vendor get a written quote that says whether the price is per pupil, per evening or per year, and whether video calls are included.

A general tool still works for a tutoring centre where a family sees one tutor. Calendly's Standard plan is $10 a seat a month and Teams $16 on yearly billing (as of November 2026), but a seat is a teacher, so six teachers means six seats. That adds up quickly and it will not warn you when a sibling's two bookings collide. If you are weighing cost against hours saved, the tutoring-centre cost question frames the sum.

Building the sheet version properly

If a sheet is your choice, build it so a slot cannot be taken twice. One row per slot, with columns for teacher, evening, start time, family number and a status. Families book by sending the office a slot code, or through a form where the slot question lists only codes that are still free. Plain forms cannot remove options as they fill unless you add a script, so for a sheet the safer pattern is the office as the single entry point.

Two formulas stop most disasters. The first flags a double-booked slot. Put this in a helper column, assuming the slot code is in column A and the family number in column D:

=IF(COUNTIFS($A$2:$A$200, A2, $D$2:$D$200, "<>")>1, "CLASH", "")

The second flags a family who is in two places at once. If column E holds the combined evening-plus-start-time, for example "Tue 16:10", then this one catches a family number appearing twice at the same time. The first test inside it stops empty, unbooked slots that share a start time from being flagged:

=IF(AND(D2<>"", COUNTIFS($D$2:$D$200, D2, $E$2:$E$200, E2)>1), "FAMILY CLASH", "")

If formulas are not your thing, ChatGPT can write these from a plain description; the Google Sheets prompts tutorial shows how to ask. Test on a copy with three deliberate clashes before you trust it.

Sibling clashes: the problem every grid breaks on

Take a family (illustrative) with one child in the youngest class and one in the oldest. Two teachers, two slots. A parent books the first teacher at 17:10 and, forgetting, the second teacher at 17:10 too. On paper, both slots are fine. For the family, it is impossible.

Three practical rules fix this, in order of effort:

  1. Link siblings at set-up. Give every family a single family number and attach all children to it. Tools that import from a school management system do this for you; in a sheet it is a column you maintain.
  2. Insist on a real walking gap. If the two teachers are in different buildings, the gap must be at least the walk, not the changeover. Put the real figure in the grid.
  3. Let siblings book first, with a cap. Open the booking page to families with more than one child a day earlier. They have the hardest constraint, so they get first pick. Cap them at one slot per teacher so they cannot hoard.

Here is a before and after. Before: Teacher A, 17:10, family 31; Teacher B, 17:10, family 31. After the clash check flags it, the office offers family 31 Teacher B at 17:30, and the sheet now shows 17:10 and 17:30, which leaves ten clear minutes between the end of one meeting and the start of the next, enough for the walk. The AI's contribution is the flag and the draft message offering the new time. Your contribution is the decision.

Reminder wording that cuts no-shows

Reminders do two jobs: they cut absences and they tell people what to do if they cannot come. A schedule of three messages is enough for most small schools: a booking confirmation, a reminder 48 hours ahead and a short note on the day.

Ask an AI for the drafts, but give it the facts and the tone. A prompt that works:

Write three short messages for a parents' evening at a small school. Facts: Tuesday 12 May, appointments are 8 minutes, please arrive 5 minutes early, the front office is open from 3.45pm, to cancel or change reply to this message or ring the office. Tone: warm, brief, no exclamation marks. Use [first name] and [teacher] as placeholders. 1) confirmation 2) 48-hour reminder 3) day-of note with a placeholder for parking instructions.

A sample confirmation (illustrative) reads: "Hello [first name], you're booked with [teacher] on Tuesday 12 May at [time]. Meetings last eight minutes, so please arrive five minutes early. If you can't make it, reply here and we'll offer the slot to another family." Fix what the AI cannot know: the parking wording, the room name, and the real cancellation route. Never let a tool send before you have read it.

Wording matters for cancellations. "Reply to cancel" produces a usable slot back; "let us know if there's a problem" produces silence. A cancelled slot is worth filling, so keep a waiting list of two or three families who asked for more time and message them when a slot opens. The appointment scheduling tutorial covers booking tools and set-up in more depth.

Using AI to read the booking export

Forty-eight hours before the evening, export the bookings and look for the problems a human skims past. Strip names, keep family numbers, and paste the export into an AI with this request.

Here is a CSV of parents' evening bookings: family_no, teacher, date, start. Find: (1) any teacher with two families at the same start time; (2) any family with two bookings at the same start time or less than 10 minutes apart on different teachers; (3) any family with no booking at all; (4) any teacher with more than 6 consecutive slots without a gap. List each issue with the row.

An illustrative result reports one teacher clash, two sibling overlaps and four families with no booking at all. Verify each with a filter in the sheet before acting, because a language model reading a long table can miss a row or invent one. If the export has more than about 150 rows, run the check in sections or use the sheet formulas as the primary check and the AI as the second pair of eyes.

The families with no booking are the real prize. Message them with the free slots left, by name, from a plain mail merge. Chasing them before the evening is worth the prep time on its own. A family who has already read a written progress report also arrives with better questions, which is why parent progress reports are worth sending a few days ahead.

A run-sheet for the evening itself

One sheet printed for each teacher, one for the office, and one on the door. Each teacher's sheet shows start time, family number and child's first name, and a space for a two-line note. The office sheet shows who is expected in the next half hour. The door sheet is a simple map: which teacher sits where.

Keep a "late arrivals" rule in writing. If a family is more than five minutes late, the teacher takes the next family on time and the late family goes to the end of the list or to a phone call the following day. Without a stated rule, every lateness snowballs, which is the main reason evenings overrun. A tutoring centre with open-ended sessions can use the same rule, with the break moved to the end of each hour.

Four small-school scenarios, worked through

A tutoring centre with six tutors and 90 students

Each family sees only the tutor for that subject, so family clashes are rare. A general booking tool with one calendar per tutor is enough. The risk is that a parent with three children books three tutors in one evening; the fix is a rule that one visit covers all children with the same tutor, which the tutor notes on the booking.

A one-class school with 18 pupils

One teacher, 18 families. At ten minutes a slot, that is 180 minutes, so about 16 slots once breaks are taken out, plus two families by phone call. Use a sheet, hand out the slot list in the first week, and skip the tool.

A school on two sites

Teachers on two sites with a ten-minute drive between them. Add a 20-minute gap for any family booking across sites, and put the gap in the clash formula rather than relying on parents to notice.

A school offering video appointments for parents who travel

Keep the video slots in one block, such as the first hour, so a teacher is not switching between a screen and a room. Send the link in the reminder and a fallback phone number, because a family on a poor connection will ring the office, not retry the link.

What to ask a vendor about family data

A booking system holds names, phone numbers, children's classes and sometimes notes about learning needs. Before you sign, ask five questions and get the answers in writing: where the data is stored, who at the vendor can see it, how long they keep it after the contract ends, whether you can export and delete everything yourself, and whether any of it is used to train AI models. If a vendor cannot answer the last one in a sentence, treat that as an answer.

Inside your own walls, the same care applies. Keep teacher notes about a pupil out of the booking tool and out of any AI prompt. The booking record needs a family number, a teacher and a time; it does not need a comment about a child's behaviour. A sheet shared with every teacher should be set to view-only for everyone except the office, otherwise a well-meaning edit during the evening will undo your clash checks. If you are choosing where family contact details should live more generally, the school CRM comparison goes through the options.

How to check it worked

Measure three things after the evening, in a plain sheet: slots offered versus slots used, families with no meeting, and minutes by which the last meeting overran. A good first evening has more than 90% of slots filled, fewer than three families unseen and an overrun of under fifteen minutes. If the overrun is large, shorten the meeting by a minute before you lengthen the evening.

Keep the sheet. Next term you will start from a grid that already holds your break rule, your reserve slots and your sibling rule, and the first prompt in this tutorial takes two minutes instead of two hours.

If you would rather map the whole booking flow with someone, that is what my AI implementation consultation covers, and the contact page is the way in. Either way, do the slot sum before you pick the tool: the number of teachers each family sees will tell you which of the three routes you need.

Questions schools ask before the first evening

Can I run a parents' evening from a Google Form?

Yes, for a very small school, but a form cannot stop two families taking the same slot unless you close each option as it fills. Use a sheet that shows remaining slots, or a booking tool that locks a slot the moment it is taken. Check the form after the first ten replies for duplicates.

How long should each parents' evening slot be?

Eight to ten minutes including changeover suits most small schools. Five minutes feels rushed for anything beyond a routine update. If a family needs longer, offer a separate call rather than stretching one slot and delaying everyone behind them.

Should I paste pupil names into ChatGPT to build the schedule?

Avoid it. Use pupil numbers or initials in anything you give an AI tool, and keep the key that links them to names in your own file. The AI only needs the shape of the problem: classes, teachers, slot lengths and which families share siblings.

What if a parent cannot use an online booking page?

Keep a small block of slots, usually two or three per teacher, that the office books by phone or at the school gate. Enter those into the same system so nothing lives on paper, otherwise the paper list and the online list will clash.

Further reads

Sources: SchoolCloud Parents Evening feature and pricing pages, Tes Parents' Meetings page, Parents Booking parents' evenings and pricing pages, Calendly pricing page (all checked November 2026).

Want your next parents' evening to run itself?

On a 1:1 call we can map your current booking steps, decide whether a sheet or a booking tool fits your numbers, and set up the reminders and clash checks.

Book a 1:1 call with me