Nursery Staff Rota: Ratios, Breaks and Cover Built With AI

Build a nursery rota from three numbers: expected children per half-hour slot, the staff:child ratio for each age group (1:3 under twos, 1:5 for twos, 1:8 for threes and over without a qualified teacher, 1:13 with one), and who is on a break. An AI assistant can draft the grid, but the manager checks every slot.

The ratios above come from the statutory framework for the early years foundation stage for group and school-based providers, in force from 1 September 2026. Qualification conditions sit on top of them, and Ofsted may ask for a higher ratio than the minimum if safety requires it. Treat the maths as a floor. Here is how to turn it into a weekly rota with a spreadsheet and an assistant, how to handle breaks and absences, and where a human has to stay in charge.

Follow me on Instagram@sagnikteaches

The ratio rules, in one table you can build from

These are the minimums in the framework for groups and school-based providers. They apply to registered early years provision, not to every school arrangement, which has its own paragraphs.

Connect on LinkedInSagnik Bhattacharya

Three further points in the framework change how you read the table. First, the ratio applies to the total number of staff available to work directly with children across the whole provision, not just each room. Second, children must usually be within sight and hearing of staff and always within sight or hearing, and must be adequately supervised, especially while eating. Third, the manager must hold an approved level 3 or above, and there must be a named deputy capable of taking charge in the manager's absence. A rota that is mathematically correct but leaves the building with nobody who can take charge is not a good rota.

Subscribe on YouTube@sagnikteaches

Because the framework counts staff across the whole provision, many nurseries still plan room by room, since children need a familiar adult nearby and rooms are physically separate. That is good practice, but remember that it is your own rule on top of the legal minimum. Write both numbers into the sheet: the legal minimum and your planning target, so you can see how much slack you have on a given day.

Step one: expected attendance, by room and by half hour

A rota built from registered numbers wastes money and one built from the busiest day wastes it all week. Build from expected attendance. Pull a table from your booking system or register for each room, with columns for each half-hour slot from opening to closing and rows for each weekday, using an average of the last six comparable weeks plus known changes (settling-in children, leavers, term-time patterns).

If your system cannot export it, build it by hand once from the booking sheets. Here is an illustrative fragment for the toddler room of a 40-place nursery.

Every number here comes from the register, so no child's name is needed and none should go to an assistant. Monday, Wednesday and Thursday mornings all peak at 12 two-year-olds, which at 1:5 needs three staff (12 ÷ 5 = 2.4, rounded up). That is the number that sets your core cover for the room, while Friday's peak of 9 needs only two.

Step two: the staff list, as codes and conditions only

Create a second sheet for staff, using codes such as S1 to S14, never names. For each person record: room base, contracted hours and days, qualification level counted for ratios (level 2, level 3, or Qualified Teacher, Early Years Professional or Early Years Teacher Status), paediatric first aid valid until, under-twos suitable experience yes or no, and any fixed commitments. The first aid column matters twice over. At least one person with a current paediatric first aid certificate must be on the premises whenever children are present, and staff who gained a level 2 or level 3 qualification since 30 June 2016 must obtain a paediatric first aid qualification within three months of starting work to count in ratios at that level. Certificates must be renewed every three years, so put the expiry date in the sheet, not the issue date.

Do not include health reasons, personal circumstances or pay. If someone needs a fixed day off for a reason you know, write "unavailable Thu" and nothing more.

Step three: give the assistant the rules and ask for a draft

The prompt below carries the rules in plain words. A model works best with a short, explicit list, and when you tell it to flag problems instead of hiding them.

You are helping a nursery manager draft a weekly staff rota. Use only the data and rules below. Do not invent staff or hours.

Rules:
- Ratios: under 2 = 1:3; age 2 = 1:5; age 3+ = 1:8 (no qualified teacher in the room).
- Plan each room to its ratio plus one spare adult at the busiest slot.
- Every room needs at least one staff member with level 3 at all times.
- The baby room needs at least one S-code marked "under-2 experienced" at all times.
- Breaks (our contract terms; replace with yours): one unpaid 30-minute break, plus a paid 15-minute break for shifts over 6 hours. Only one person from a room on break at a time.
- Opening 07.30, closing 18.00. At least two staff in the building at opening and closing.
- Manager (S1) and deputy (S2) are never both off site.

Data: attendance table (pasted), staff table with codes (pasted).

Output: a table with half-hour slots down the side, rooms across, and the S-codes working in each cell. Then a second table showing, for each slot and room, children expected, staff needed at the ratio, staff scheduled, and a PASS or FAIL. List every FAIL and every place where you were unsure.

Make the model show its checking table. That table is the thing you read. If it only gives you the rota, you have to rebuild the maths to trust it.

What a realistic first draft looks like, and what you fix

Expect something close, with a handful of problems. A typical first output (illustrative) has four faults, and each one teaches you a rule to add to the prompt.

• Two people on break in the same room at 12.30. Add: "stagger breaks by 30 minutes between people in the same room".
• The only under-two-experienced person scheduled for a 08.00 to 14.00 shift, leaving the afternoon uncovered. Add a rule about continuous cover and name the codes allowed.
• A part-timer rostered on a day marked unavailable. Ask for a final check of every cell against availability.
• A correct ratio in the table but a wrong number in the header, because the model rounded 2.4 down. Tell it to always round up to the next whole person.

After two or three rounds the draft stabilises. Save the prompt with the added rules as your template; next week you only replace the data. If you use a spreadsheet tool with a built-in assistant, the same prompt works there, and the workforce planning in a sheet tutorial shows the scenario layout in more detail.

Break cover: the part that quietly breaks ratios

Ratios fail at 12.15, not at 10.00. Lunch breaks, handovers and nappy rounds are where a room drops below its minimum while everyone is technically on shift. Treat breaks as a second grid.

Take a baby room with 9 children at lunch. At 1:3 it needs three staff on the floor. If it has four on shift, only one can be on break at a time, and a second break cannot start until the first returns. A cover person from the toddler room can fill in only if that room can spare someone, and the framework counts staff across the whole provision, so the sum has to work for the building, not just the room.

Nap time makes this harder, because it often overlaps lunch breaks. The framework says sleeping children must always be within sight and hearing of staff and must be checked frequently, so if babies sleep in a separate room, that room needs its own adult in the break grid even when the main room looks well covered.

The last row of the table is the sort of fault an assistant can miss and a careful manager catches. Ask the assistant to run a separate pass that checks only the conditions (level 3 present, under-two experience present, deputy cover) for every half-hour slot. A narrow second check finds more than a long first one.

Absence cover and swaps without a Sunday-night scramble

Absence is the test of a rota. Plan for it before it happens by listing, in advance, who can move where. Create a "cover map" with a row per room and the S-codes who can cover it with their qualification conditions. When someone phones in sick, the deputy opens the map rather than starting from nothing.

1. Read the gap: room, slot, and the condition at risk (ratio, level 3, under-two experience).
2. Check in-house options first: a floater, a manager or deputy working directly with children, or a swap with someone who owes time.
3. Consider reducing the need: can another room merge for a quiet slot while still meeting ratios and supervision?
4. Use agency or bank staff last, and check them. Whoever counts in ratios must meet the framework's conditions for qualification, first aid and suitability. Do not count anyone you have not checked.

Staff member S7 is off sick tomorrow, 07.30 to 15.30, baby room. Here is the current rota for tomorrow and the cover map. List three ways to cover the gap in order of preference. For each, show the effect on every room's ratio by half-hour slot and whether any condition (level 3, under-2 experience, deputy cover) would fail. If none works without a risk, say so plainly.

A realistic reply gives two workable swaps and one risky one, with the tables. Pick one, then tell the affected staff yourself. Do not send an assistant's message straight to a person who has just been asked to change their day; a shift swap is a conversation.

A weekly rhythm that takes under an hour

With the template in place the routine is short. Illustrative timings for a 40-place nursery:

1. Thursday, 10 minutes: update expected attendance for next week from the booking system.
2. Thursday, 10 minutes: update staff availability and leave.
3. Thursday, 10 minutes: run the prompt and read the draft and the checking table.
4. Thursday, 20 minutes: fix faults, run the conditions-only pass, check the building cover at opening and closing.
5. Friday: publish to staff, with time for swaps before the weekend.

Compare this with the manager's current time. If building the rota takes two hours a week today, one hour is 50 hours saved a year, which is a useful number to weigh against the thinking you must still do. If you currently spend 45 minutes, the saving is smaller and the main benefit is consistency.

Closing shifts and late collections

The edge of the day shapes the rota more than the middle. At closing, two adults should be in the building, and a late collection can keep them past their paid hours. The nursery late collection policy tutorial prices that overtime and sets the charge, and a staggered closing shift is the rota's half of the same fix. If your log shows that lateness clusters on Thursdays, set one of the two closers to finish 30 minutes after the other and plan their start time accordingly.

Worked example: one Wednesday for a 40-place nursery

Illustrative figures only. The nursery has a baby room (8 children at the peak), a toddler room (12 two-year-olds) and a pre-school room (16 children aged three and four), none with a qualified teacher working directly in the room, so the 1:8 ratio applies to the oldest group.

The legal minimum at the peak is eight adults on the floor; the nursery's planning target is eleven, because it wants a floater per room to cover nappies, meals and breaks. Add the manager's and deputy's non-floor time and a cook or administrator who is not counted in ratios, and the contracted staff needed for a Wednesday is well above eight. Ask the assistant to compute the weekly hours by slot for each target, and read the difference: three spare adults at 12 to 1 is roughly the cost of the break cover you would otherwise buy as emergency agency time.

Now the same Wednesday at 07.30, when only 4 children are in the building. The ratio sum is small, but the framework also needs someone with level 3 present and, for under-twos, someone with suitable experience, so the opener pair must be chosen on qualifications, not on who lives nearest. That single constraint, written into the prompt, saves the most awkward phone call of the week.

Before and after: a vague instruction turned into a checkable rule

Vague rules produce vague drafts. Here are three pairs, each written the way managers really speak, then as an assistant needs them.

• Before: "Don't leave the baby room short at lunch." After: "From 11.45 to 13.15 the baby room needs at least three adults on the floor whenever more than six children are present."
• Before: "Make sure there's always a first aider." After: "In every half-hour slot at least one person with a current paediatric first aid certificate is in each room, and one outdoors when children are in the garden."
• Before: "Be fair with closing." After: "No staff code closes more than two evenings a week. Over four weeks the difference between the highest and lowest number of closes is at most two."

Each "after" is something you can verify in the checking table, which is the real test of a rule.

Fairness, working-time rules and the human side

A rota that meets ratios but gives the same person every late close will not last. Add fairness rules to the prompt: no more than two closes in a week unless requested, a minimum of 11 hours between shifts if your contracts or working-time rules require it, and an even spread of the less popular slots over a month. The AI rota planning tutorial gives a checklist of the working-time rules worth writing into the prompt; confirm the actual limits that apply to you with your employment adviser.

A quick sum shows why it matters. Say a nursery has 12 staff and 24 closing shifts a month. Even, that is two each; if a keen colleague has quietly taken eight, resentment builds long before anyone says so. Ask the assistant to print a count of opens, closes and weekend-adjacent shifts per staff code after every month and read it as a fairness check.

What goes wrong, and how it shows up

• Rota built on registered numbers. You staff Fridays for a room that is half empty. Spot it by comparing scheduled staff to actual attendance in the monthly review.
• Qualification conditions ignored. A ratio of 1:5 is met but nobody on the floor holds level 3. Spot it with the conditions-only pass.
• Counting people who cannot be counted. Under-17s are not included in ratios except apprentices from 16, and students and long-term volunteers count only at the level below their study, only if judged suitable and competent, and only with a current paediatric first aid qualification. Spot it by adding an "age 17+" and a "counts at level" column to the staff sheet.
• Trusting the assistant's PASS column. It can mark PASS on a row it miscounted. Spot-check three rows by hand every week.
• Personal data in the prompt. Names, health or reasons for absence. Use codes and the word "unavailable".

How to check the rota before anyone sees it

Print the checking table and do four things with a pen. Count the busiest slot of each room by hand. Pick the half-hour with the most breaks and recount who is on the floor. Check that the manager or the named deputy is present in every slot. Confirm that opening and closing have two adults. If all four pass, the rota is ready; if any fails, fix it and run the conditions-only prompt again. The manager's signature on the final version is the legal comfort. The assistant's role ended earlier.

Rota questions nursery managers ask

Can an AI assistant guarantee ratios are met?

No. It can build a draft and count heads against your rules, but it can miss a qualification condition or an unusual attendance pattern. A manager checks every half-hour slot against the framework and the real attendance before the rota goes out.

Should I give the assistant staff names?

Use initials or staff codes. Names are unnecessary for the logic, and staff contracts, leave reasons and health absences should never go into a general chatbot. Keep the real mapping of codes to people in your own file.

How do I plan for children arriving at different times?

Use expected attendance by half-hour slot from your booking system, not the number registered. Build the rota to the busiest slot in each room, then trim at the edges with early and late shifts that follow the real arrivals and departures.

Where do students and apprentices count?

The statutory framework allows eligible students, long-term volunteers and apprentices to count in ratios at the level below their level of study, with conditions. They must also be judged suitable, competent and responsible and hold a current paediatric first aid qualification. Nobody under 17 counts, except apprentices aged 16 or over. Check the exact paragraph before counting anyone.

Further reads

• How to Build a Restaurant Staff Rota With AI Demand Forecasts — Forecast-driven rota logic from another shift business.
• Retail Staff Scheduling: Build a Rota From Hourly Till Sales With AI — Building a rota from hourly demand figures.
• Hotel Staff Scheduling With AI: Front Desk, Housekeeping, Breakfast — Multi-department rota with fixed daily peaks.
• Urgent Care Staffing: Forecast Volume and Build Rotas With AI — A health-care take on matching staff to demand.
• Nursery Staff Training: A One-Hour AI Briefing on Children's Data — What staff must never paste into a prompt.
• Choosing Nursery Software With AI: What to Compare — Nursery systems that hold attendance and staffing together.
• Care Home Rota Template: Cover, Skill Mix and Gap Checks Using AI — A rota sheet with cover rules and a skill-mix check, plus AI prompts that find gaps and draft messages. The manager decides; nothing changes automatically.
• Daycare Staffing Ratios: Plan the Daily Schedule With AI — Turn your state's ratio table, a half-hourly headcount and a shift grid into a daycare rota that stays in ratio, with break cover and an absence list.
• Nursery Fees Policy: Deposits, Late Payment and Holidays With AI — A clause list for a nursery fees policy, a plain-English parent version drafted with AI, and a reminder ladder, checked by a solicitor.
• AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.

Sources: the statutory framework for the early years foundation stage, group and school-based providers, in force from 1 September 2026 (paragraphs 3.37 to 3.57 on paediatric first aid, staffing and ratios, and 3.86 on sleeping children), read on 4 November 2026. Ratios and qualification conditions change; check the current document before you build a rota from this tutorial.