Care Home Activities Calendar: Plan a Month With AI and Resident Input

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Care Home Activities Calendar: Plan a Month With AI and Resident Input.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Care Home Activities Calendar: Plan a Month With AI and Resident Input.

Collect each resident's interests on a one-page sheet, code the names, and give AI the coded sheets plus your fixed constraints: staff, rooms, times and rules. Ask for a four-week calendar with group sessions, small-group slots and named one-to-one visits, then check every session for risk and capacity before it goes on the wall.

The aim is a calendar that reflects who actually lives in the home, not a generic list of bingo, music and "armchair exercise". AI is good at fitting many interests into a limited timetable and at spotting that nobody has had a one-to-one slot in three weeks. It is poor at knowing that R7 will not come to a room with the television on. That is what you and your team add.

Follow me on Instagram@sagnikteaches

Start with the residents, not the template

A calendar built from a template reflects the template. A calendar built from interests reflects people. So the first job is a short interest sheet, filled in with each resident or, where they cannot do it themselves, with a relative or key worker. One side of A4 is enough.

Connect on LinkedInSagnik Bhattacharya

Include these headings:

Subscribe on YouTube@sagnikteaches
  • Likes (music, gardening, football, baking, cards, crosswords, faith, animals, old films).
  • Past work and roles that shape what feels meaningful (a bus driver, a teacher, a market stallholder).
  • Best time of day and any times to avoid (after lunch, before medication rounds).
  • Group or alone? Prefers small groups, large groups, one to one, or in their own room.
  • Support needed in practical terms (needs a staff member beside them, uses a hearing loop, tires after 30 minutes).
  • Things to avoid (loud noise, certain topics, certain foods at food-based activities).

The sheet is a record of preferences, so keep it positive and practical. Avoid copying medical notes onto it. A column such as "tires after 30 minutes" is a planning fact; a diagnosis is not needed for the calendar and does not belong in an AI prompt.

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

Code the data before it goes anywhere

Create a master list in your own records with real names and a code (R1, R2 and so on). Everything you give an AI tool uses only the code. Keep that master list in a secured location with access limited to staff who need it. If you ever need to re-identify a calendar entry, you can do it from the key.

Business plans of ChatGPT and Claude, Gemini in Google Workspace and the work version of Microsoft Copilot (formerly Microsoft 365 Copilot) do not train on your content by default, and consumer ChatGPT and Claude plans let you switch training off in privacy settings. Even so, follow your home's own policy: a staff policy for AI in care homes sets out what staff may and may not enter, and the broader 90-day AI plan for care homes shows where this fits.

Here is an illustrative coded summary, eight residents from a 24-bed home:

CodeLikesBest timeGroup sizeSupport
R1Gardening, tomatoes, radio quizzesMorningsSmall groupRaised bed, seated
R2Hymns, choir singingLate morningLarge groupHearing loop
R3Old black-and-white filmsAfternoonsSmall groupStaff beside her
R4Football, newspaper readingMorningsOne to oneLarge-print paper
R5Baking, anything with pastryMid-morningSmall groupAdapted utensils
R6Dogs, visiting animalsAfternoonsAnySeated, near the door
R7Quiet crafts, knittingAfter 2pmOwn room, one to oneAvoids noise
R8Cards, dominoesEarly eveningSmall groupLarge-print cards

With 12 to 30 residents, the table is the working core. If you have 40, split it into units or floors and plan each one separately.

Fix the constraints before you ask for ideas

Many AI calendars fail because nobody told the tool how much can actually happen. List your real limits, and give them to the model as hard rules.

  • Staff for activities: one coordinator on weekdays, 9 to 4; a care assistant spared for one hour each afternoon; none at weekends except a volunteer on Saturday.
  • Rooms: lounge (up to 12 seated), conservatory (6), garden (weather permitting), residents' rooms.
  • Fixed events: meals at set times, medication rounds, a visiting hairdresser on Tuesdays and Thursdays, the church service on the first Sunday.
  • Budget: say $60 a month for consumables, nothing for outside entertainers unless approved.
  • Sessions per day: for example one group in the morning, one in the afternoon, and a one-to-one block of 60 minutes.

A prompt that fits interests into a four-week grid

This prompt gives the model the sheet, the limits and the output format, and asks it to flag anything uncertain.

You are helping a care home activities coordinator plan a four-week
calendar. Use ONLY the coded resident summaries and constraints below.
Do not invent residents, medical facts or resources we have not listed.

RULES
- Maximum two group sessions a day, Monday to Saturday, never during
  the fixed events listed.
- Group sessions must fit the room capacity.
- Every resident coded as "one to one" or "avoids noise" must have at
  least one named one-to-one visit each week (20 to 30 minutes).
- Every resident must appear in at least two sessions in the month
  that match a stated interest.
- Mix: at least 3 sessions per week that are physical, 3 social, 2
  creative, 1 reminiscence, 1 outdoor or garden (weather alternative).
- Mark risky sessions (food, sharp tools, outdoors, animals, trips)
  with [RISK CHECK].
- Note staff needed for each session.

OUTPUT
A table with columns: Date, Time, Activity, Room, Staff, Who it suits
(codes), Notes. Then a short list of residents who appear fewer than
twice, and any rule you could not meet.

RESIDENTS: [paste coded table]
FIXED EVENTS AND LIMITS: [paste constraints]

The last instruction, to list rules it could not meet, is the useful one. A model will often try to satisfy everything and quietly fail one; asking it to report failures makes the gaps visible.

What comes back, and how to read it

Here is a trimmed, illustrative week from the output:

Day and timeActivityRoomStaffSuitsNotes
Mon 10:30Seed sowing and tomato careConservatoryCoordinatorR1, R5, R6[RISK CHECK] compost, handwashing
Mon 14:30One-to-one: knitting and radioR7's roomCare assistantR7Quiet; no group noise
Tue 11:00Hymn singingLoungeCoordinatorR2 plus 8 othersHearing loop on
Wed 14:00Black-and-white film afternoonLoungeCare assistantR3, R8Subtitles on; tea served
Thu 10:00Pastry and bakingKitchenetteCoordinator plus kitchenR5, R1[RISK CHECK] hot oven, allergens
Fri 15:00Visiting dog (volunteer)Garden or loungeCare assistantR6 and anyone who asks[RISK CHECK] animal, allergies
Sat 14:00Cards and dominoesLoungeVolunteerR8Large-print cards

Now read it as a coordinator. Will three residents, their walking frames and the seed trays fit in a conservatory that seats six? Do Tuesday's hymns and Thursday's baking clash with the hairdresser, who visits on those days and may have the same residents booked? Where is the kitchenette? It was never on the room list, so the model broke its own rule against inventing resources; confirm you have one or move the session. And did the model give R4 a one-to-one slot? Here, it did not: R4 (football and newspaper) is missing from the week, which the "fewer than twice" list should have caught. Fix this by asking, "Add a one-to-one on Wednesday morning for R4, reading the sports pages, 25 minutes, with the coordinator." The morning matters, because the care assistant is only free in the afternoons.

The staff check for risk and capacity

This is the step that cannot be delegated. Before the calendar goes on a wall, sit down with the manager or a senior carer and go through every row. Take twenty minutes for a week, an hour for a month.

  1. Staffing. Is the person named on that day, and are they free, trained and not on a break?
  2. Room capacity and access. Can wheelchairs and walking frames reach the seats? Is the room free?
  3. Risk. Anything with food, heat, sharp tools, outdoors, animals or trips needs a quick assessment under your own procedures. The [RISK CHECK] flags tell you where to look, but they are not a replacement for your risk assessment.
  4. Individual fit. Would each named resident be comfortable? A film can distress someone with certain memories. Ask the key worker.
  5. Dietary and allergy checks. Any baking or tasting session must match the catering team's allergen information.
  6. Weather and backup. Every outdoor session has an indoor alternative named in the notes.

Where you change a session, note why in a margin. Over a few months, this record shows what you routinely correct, and you can add it to the prompt as a rule, for example "never schedule baking on the day of a kitchen deep clean".

Small-group and one-to-one slots deserve protection

Large group activities are easy to fill the calendar with, and they leave the quietest residents out. Two to four residents with a shared interest often engage more than a lounge of fifteen, and a protected one-to-one slot is sometimes the only chance a resident has to talk about their own life.

Set a rule: each week, every resident who prefers one-to-one or avoids groups gets at least one 20 to 30 minute named visit. Put those slots in the calendar before you add anything else, then fill the groups around them. Say a home has 24 residents and 6 of them are one-to-one only. Six slots of 25 minutes a week is two and a half hours, about 150 minutes. If your carer can spare an hour a day, that fits with time to spare, and you will see it in black and white rather than hoping it happens.

Ask the model for a "no visit this week" list: residents who did not appear in any session. Anyone on that list on two weeks running should be raised with their key worker. It is a useful second use of the same calendar, and it connects to the wider checking you may do each month, such as the monthly care home audit checklist.

Print a version residents can actually read

A calendar for staff and a calendar for residents are different documents. Ask AI to produce a simple weekly view, one page per week, with large text and plain words. For example: "Create a one-page weekly timetable for residents with times, activity names of three words or fewer, and room names. Output as a table with seven columns, Monday to Sunday." Paste it into a word processor and set the font between 16 and 18 points, high contrast, with no light-grey text.

Try the print on three or four residents before copying it. Ask which parts are hard to read. Poor eyesight and low contrast are common, and a calendar that cannot be read is a staff-only document. Also place a copy at the height of a seated person, not at standing eye level. For families, a short summary can go into the home's newsletter, with consent for any photos; care home newsletter ideas with AI-drafted family updates covers that.

Resident input comes back round every month

The calendar is not finished when it is pinned up. Each month, ask residents what they enjoyed and what they would change. This can be as simple as a conversation at the residents' meeting or a tick chart after each session with a smiling, neutral and sad face. Note attendance counts, too: "Hymn singing: 9 attended" tells you more than "popular".

Feed these results back into the next prompt. Say last month's tomatoes drew 4 regulars and the film afternoon drew only 2; tell the model, "Increase gardening to twice a week, reduce films to fortnightly, and suggest a new quiet afternoon activity for R3 and R8." The monthly cycle becomes: collect feedback, update the sheets, prompt, check, print. The residents' meeting minutes and you-said-we-did tutorial shows how to record what residents asked for and what you changed.

The baking slot that missed an 'avoids sugar' note

Picture a coordinator who accepts a calendar with a Friday baking session for a group that included a resident whose sheet said "avoids sugar" in the support column. The AI, given only the codes, would match baking to "likes baking". It was not told that sugar was a problem for that person, if the note sat in the support field and the instruction did not link it to food sessions. The senior carer would catch it at the risk check, if the check happens.

The fix is in the prompt, not just the calendar: "For any session involving food, check each suited resident's 'things to avoid' and 'support' fields and flag conflicts." The lesson is that the model only uses what you give it, in the way you tell it to, and the staff check exists for the gaps in both.

A weekly rhythm that fits in a short working week

For a coordinator with other duties, here is a realistic split of the time.

  • Once a quarter, 2 hours: refresh interest sheets with residents and families; update codes for new arrivals.
  • Monthly, 1 hour: run the prompt, adjust the output, hold the staff risk check.
  • Monthly, 30 minutes: prepare the printable version and the family summary.
  • Weekly, 15 minutes: tick attendance, note changes, and spot anyone who has had no session.

That is about three hours a month on top of the sessions. The menu planner in a four-week care home menu cycle follows the same monthly rhythm, so the two can share one planning morning, and the baking sessions can be checked against the menu at the same time.

Ideas by interest, with what to prepare

An interest list turns into a calendar faster if you have a few proven formats in your head, so you can tell the model what you can really run. Here are six, each with a simple preparation note. They are illustrations, not a prescription.

  • Reminiscence with objects. Bring a box of everyday things from a decade the residents knew: a tin of tea, an old radio, a ration-book-style card. Ask open questions and let silence do some work. Needs one staff member and 30 minutes, and suits small groups of four to six.
  • Chair-based movement to music. Choose tracks from the residents' own era. Seated stretches for 20 minutes, water afterwards. Check the physiotherapist's or senior carer's guidance on who should not take part.
  • Container gardening. Raised pots on a table, so nobody has to bend. Seeds in spring, bulbs in autumn, herbs on the windowsill all year. Weekly watering gives R1-type residents a role.
  • Quiz and trivia. Use topics tied to their working lives or to a place they knew. Ask the AI to write ten large-print questions at two difficulty levels, then check every answer yourself, because quiz errors are embarrassing and AI sometimes invents them.
  • Hand care and pampering. Hand cream or nail care, only where your own policy and training allow it, and with consent. Keep it as a one-to-one option and not a group activity.
  • Intergenerational visits. A nursery or school group for singing or craft. This needs advance notice, consent, a staff plan and a clear end time, and works best monthly rather than weekly.

Tell the model which of these you can really run. A calendar full of ideas you cannot deliver is worse than a smaller one, because empty slots on a wall are noticed by residents and families.

A quick sum on capacity and coverage

Before you accept any month, do one piece of arithmetic that the AI will not do reliably for you. Say your home has 24 residents, and you run 8 group sessions a week. If each session holds an average of 6 residents, that is 48 resident-places a week, or two per resident. Add the six one-to-one slots and you have 54 contacts, an average of 2.25 per resident.

That average hides a lot. Count actual appearances per resident in the calendar: if 10 residents appear 4 times, 8 appear once and 6 not at all, the total is still 48, but the calendar has missed a quarter of the home. Ask the model for a table of appearances per resident code, then look at the bottom five. Anyone with fewer than two appearances in a week needs a reason, such as being away or choosing to stay in their room, or a new slot. Share the count with the manager at the monthly review, since it is the kind of evidence that shows activities are reaching everyone.

What not to hand over

Do not ask AI to decide which residents are suitable for an activity on health grounds. Do not paste care plans or notes into any chatbot. Do not let the calendar replace conversation: the best activities often come from sitting with someone and asking what they used to do. And do not treat a clean, full calendar as proof that residents are well occupied; attendance and enjoyment are the measures. The calendar is a plan, and the plan works when the team checks it against the people it is for.

Questions coordinators ask about AI-planned calendars

Should I put residents' names into the AI?

Not real names. Use a code such as R1 to R24 and keep the key in your own records. Interests, abilities and preferred times can go in as codes with short notes. Practical needs an activity depends on, such as 'uses a wheelchair', can go in; diagnoses and care-plan detail should stay out.

How many activities should a calendar hold?

Enough for choice without overloading staff. A common pattern is one or two group sessions a day, a quieter afternoon slot, and a few protected one-to-one visits for residents who rarely join groups. Set the number from your staffing, not from the AI's enthusiasm.

Can AI plan activities for residents with dementia?

It can suggest ideas and a gentle structure, but a person who knows the residents must choose and adapt them. Ask for activities that can be paused or simplified without failing, and let your team decide who attends and how.

How do I make the calendar printable for residents?

Ask AI to output a plain table, then paste it into a word processor with a 16 to 18 point font, high contrast and one week to a page. Add pictures only if you have the right to use them, and check the print with a few residents before copying it.

Further reads

Sources: general activities coordination practice; OpenAI, Anthropic, Microsoft Learn and Google Workspace privacy pages (checked 4 November 2026). Activity ideas are suggestions, not clinical advice, and every plan needs a staff risk and capacity check.

Want your activities planning to take an hour, not a day?

On a 1:1 call we can look at how you gather resident interests now, set up a coded interest sheet and calendar routine, and agree the human checks that stay.

Book a 1:1 call with me