Kids Sports Schedule Coordinator
Last reviewed
BeginnerWhat you'll learn
~35 min- Ask an AI tool, in plan mode, for a small program that merges several activity schedules into one week sheet you can print
- Read its plan for what it will mark, and check that it uses your drive times as yours and guesses none
- Check the sheet against the schedules: every event once, nothing outside its season, every overlap marked, no drive time made up
- Treat a marked clash as a decision for you and the other grown-ups, never as something a note on the sheet can settle
The story, and what you will end up with
This lesson is about home, not the office. It is Sunday 15 November 2026, a little after 8 p.m. You have two children, Theo, who is 11, and Lila, who is 8, and four activities between them: Theo plays futsal and outdoor soccer, Lila plays soccer and takes a gymnastics class. Each activity has its own schedule from its own team or studio, and none of them talk to each other. Every Sunday evening you lay them side by side in your head before you text the other parents, and hope you did not miss an overlap. Sometimes you do, and Saturday morning becomes a scramble.
This week needs more care than most. Theo’s futsal games start on Saturday 21 November, the same morning as his last soccer game of the season.
By the end of this lesson you will have a small program on your own computer, the week-sheet program, that reads the schedules and makes one sheet for the week that you can print, with every clash marked. It sends nothing, shares nothing and puts nothing into a phone calendar or a team app. You build it by asking your AI tool in plain English, and you check it by reading the sheet.
🔍Words used in this lessonclick to expand
- Futsal: soccer played on a hard court, usually indoors.
- U9, U12: age groups, “under 9” and “under 12”.
- Arrive by: the time a team asks players to be there, before the game starts. The schedules in this lesson give one for each Saturday game.
- Clash: two things on the sheet whose times overlap, or a child due somewhere before they can leave somewhere else.
- Drive time: your own estimate of the drive between two places, in minutes. Nobody else’s number goes in.
Before you start
First, if your AI tool is still open, leave it: type /exit and press Enter (if you use Antigravity, press Ctrl+D with nothing typed instead), and wait until you see the $ or % prompt. The next line goes there, in the terminal, not in the AI tool. It makes a new folder for this lesson inside property-ops, next to the earlier lessons’ folders, and goes into it:
mkdir -p ~/property-ops/07-family-calendar && cd ~/property-ops/07-family-calendarStart your AI tool with the start line you kept from the setup lesson, the one with approval prompts off. Then ask it to set the folder up:
Set this folder up so we can undo any change you make, download https://learn.intellimetrics.net/starters/property-mgmt/07/family-schedules.zip and unpack it into a data folder, and save a checkpoint.Look for it saying three things: the folder is set up with Git (the program that saves snapshots, from setup), five files are in the data folder (theo-futsal.csv, theo-soccer.json, lila-soccer.csv, lila-gymnastics.json and drive-times.csv; a .csv file is a spreadsheet file, and a .json file is plain text that some apps save schedules in), and a first snapshot, your checkpoint, is saved. Later you can ask whether the files have changed since then. If it does not mention one of them, ask: “Did you save a checkpoint with the files in it?” If it says it kept the zip file somewhere outside this folder, ask it to delete that copy. If the download does not work, download family-schedules.zip in your browser, check where it went (the browser’s list of downloads shows the folder), and tell your AI tool, for example: “family-schedules.zip is in my Downloads folder. Unpack that one file into a data folder here, and save a checkpoint.” In Windows PowerShell or a desktop app, “my Downloads folder” works as is; only say “my Windows Downloads folder” if you use Ubuntu (WSL) on Windows, which keeps its own Downloads folder apart from Windows.
The children, teams, places and times in the files are made up for this course. No real child’s schedule is in them, and none should go into this folder.
The box below says what is in the practice files; later steps refer to them.
ℹWhat is in family-schedules.zipclick to expand
Four schedules, each written the way its own source writes it, and your own drive times. Two are spreadsheet files (.csv, they open in Excel) and two are JSON, a plain text format that some apps save schedules in. Times are written three ways (5:30 PM, 4:00pm, 17:00) and days two ways (Tue, Tuesday). Each schedule has season dates; an event happens only between them.
| File | Child | Activity | When | Where | Season |
|---|---|---|---|---|---|
theo-futsal.csv | Theo | Red Foxes U12 Futsal, practice | Tue and Thu, 5:30 to 6:30 p.m. | Northside Sports Hall | 2 Nov 2026 to 27 Feb 2027 |
| game | Sat, 10:00 to 11:00 a.m., arrive by 9:45 | Westfield Community Center | from 21 Nov 2026 (“First game”) | ||
theo-soccer.json | Theo | Comets U12 soccer, practice | Mon and Wed, 4:30 to 5:30 p.m. | Riverside Park Field 2 | 7 Sep to 21 Nov 2026 |
| game | Sat, 9:00 to 10:15 a.m., arrive by 8:40 | Hilltop Park | (“Last game of the season”) | ||
lila-soccer.csv | Lila | Minnows U9 soccer, practice | Tue and Thu, 4:00 to 5:00 p.m. | Eastwood Park Field 1 | 7 Sep to 21 Nov 2026 |
| game | Sat, 9:00 to 10:00 a.m., arrive by 8:40 | Eastwood Park Field 3 | |||
lila-gymnastics.json | Lila | Junior Gymnastics, class | Mon and Wed, 5:00 to 6:00 p.m. | Maple Street Gymnastics | 8 Sep 2026 to 12 Jun 2027 |
| rehearsal | Fri, 4:30 to 6:00 p.m. | Cedar Middle School auditorium | 4 Dec 2026 to 15 Jan 2027 |
drive-times.csv is your own list of how long you think each drive takes, one way:
| Between | And | Your estimate |
|---|---|---|
| Eastwood Park | Northside Sports Hall | 15 min |
| Hilltop Park | Westfield Community Center | 10 min |
| Hilltop Park | Eastwood Park | 20 min |
| Riverside Park | Maple Street Gymnastics | 10 min |
There is no estimate for any drive to or from Cedar Middle School or between Eastwood Park and Westfield Community Center.
This lesson’s practice files are their own made-up week and do not continue from any other lesson’s.
Switch to plan mode
Your AI tool is already open. Switch to plan mode now: Shift+Tab until it says plan, or /plan (the keys for each tool). In plan mode it usually reads your files, asks its questions and shows you a plan before it builds anything; the order can vary.
The conversation
Each message below is an example. Say it your own way.
Say what you want
Say who you are, which files to use, which week, and what you want from them:
I'm a parent of two. Help me build a small tool that merges the schedules in data into one week sheet for the week of 16 November 2026, with clashes marked. Ask me what you need first.The week matters: without it, your AI tool may make the sheet for the coming week, and the practice files would give a different picture. Your AI tool usually reads the files and comes back with questions. It may also point out what it noticed, such as Saturday’s games or the rehearsals that have not started yet.
Answer its questions
Answer each in a sentence. These are questions the tools often ask, with one way to answer each. Yours may ask them in a different order or show a list of choices:
| If it asks | You might say |
|---|---|
| What counts as a clash: one child booked twice, any overlap, or too little time to drive as well? | Any overlap, plus too little time to drive, using my drive times. |
| How many grown-ups can drive? Must someone stay, or can the children be dropped off? | Leave drivers off the sheet; I work out who drives. |
| Should a clash count from the arrive-by time or the start time? | From the arrive-by time where there is one, and show it. |
| A printable page, a spreadsheet, or both? | A page I can print, saved here. Nothing online, nothing into a calendar app. |
| Should I add extra time beyond your drive times? | No extra time. Show the time between beside my drive time; I’ll judge it. |
| Just this week, or any week? | Any week; I’ll say which. |
| Do a season’s first and last days count? | Yes, both count. |
| Some drives aren’t in your file. Mark them unknown, or will you add them? | Mark them unknown; don’t guess. |
If it asks several questions at once, answer the ones about what counts as a clash and about drivers in a sentence, and for the rest say that its suggestions are fine. If it asks something not listed here, answer it the same way, in a sentence.
Read the plan
Next it usually shows you a plan: what it will build and how it will check it. Read it for five things:
- Every event that week appears once, with the child, the place and the time as in the files, and nothing outside its season.
- The arrive-by times count. A child who must arrive somewhere by 9:45 is marked if still somewhere else at 9:45, not only once the game starts.
- Any two events that overlap are marked, whether they are one child’s or both children’s.
- Where a child’s day moves from one place to another, the sheet shows the time between beside your own drive time, marked as your estimate and good both ways. A drive that is not in your file is shown as unknown, never guessed.
- The sheet names no driver and settles nothing. Nothing is sent or shared, nothing goes into a calendar app, and your files are read and left as they are.
A first plan often leaves one of these out, most often the drive times in item 4. Say so in a sentence, in your own words, for example:
My drive times are my own guesses and they work both ways. Show them as my estimates.When the plan has all five, approve it: if your AI tool offers a choice to go ahead, pick it; otherwise say “Yes, go ahead and build it.” In Codex, press Shift+Tab first to leave plan mode. In Copilot, saying it brings up a choice to go ahead; pick that. Let it build. It may run what it built and tell you how to run it yourself; either way, the next step asks it to. When it has finished, ask it: “Did you install anything, and where?” Nothing, or something inside this lesson’s folder, is fine for these lessons. If it names anywhere else on your computer, ask it what that is for, and to remove it if you do not want it there.
Look at what it built
Ask it to run what it built:
Run it and show me the week sheet and the clashes.To see the sheet the way it will print, ask your AI tool: “Open the week sheet in my browser.” If your AI tool does not take a message after opening the page, wait a minute. If it still does not, close the terminal window, open a new one, type the line at the top of this page that begins with mkdir again, start your tool, and say: “Start the page again so it keeps running while we talk.” The page and your saved work are files in the folder, so nothing is lost. Your sheet will be worded and laid out in its own way. Check it for these:
- There are eleven events: two each on Monday, Tuesday, Wednesday and Thursday, and three on Saturday. Friday and Sunday are empty; Lila’s rehearsals do not start until 4 December.
- Monday and Wednesday: Theo’s practice (4:30 to 5:30 at Riverside Park Field 2) and Lila’s gymnastics class (5:00 to 6:00 at Maple Street Gymnastics) are marked as overlapping from 5:00 to 5:30.
- Saturday: both games are marked as overlapping, Lila’s at Eastwood Park Field 3 and Theo’s at Hilltop Park, each with “arrive by 8:40” shown. Counted from the arrive-by times, the overlap runs from 8:40 to 10:00; a sheet that counts from kick-off shows it from 9:00 to 10:00. Either is fine. If you want 8:40, say: “Count each game from its arrive-by time.”
- Saturday: Theo is marked as booked twice. He must arrive at Westfield by 9:45 for futsal, and his soccer game at Hilltop runs to 10:15. Some sheets also show the game times overlapping from 10:00 to 10:15.
- Saturday: Lila’s game, which runs to 10:00, is marked against Theo’s 9:45 futsal arrival.
- Tuesday and Thursday show no clash, but the sheet shows the 30 minutes between Lila’s practice ending at Eastwood and Theo’s futsal starting at Northside, beside your 15-minute drive estimate.
- When you ask “Have my schedule files changed since the checkpoint?”, it compares them with the checkpoint and says no.
Your sheet may count or group these in its own way, for example all of Saturday together; what matters is that each one is there.
If something on the list is not true, tell your AI tool in a sentence what you see and what you expected, for example: “Nothing is marked for Theo on Saturday, but he must be at futsal by 9:45 while his soccer runs to 10:15. Use the arrive-by times.”
Read the two kinds of mark differently. One child in two places at once, like Theo on Saturday, means someone has to choose which he goes to first. Two children in two places at once, like Monday, Wednesday and Saturday morning, means checking who is with each child and how each one gets there: sometimes one grown-up can manage both, sometimes it takes a second driver or a ride. The sheet cannot know how many drivers the evening has; you do.
Notice what the sheet cannot arrange
Saturday is the problem the week turned on. Suppose a teammate’s family has mentioned they might take Lila to her game. Try this:
Make a copy of lila-soccer.csv in this folder. In the copy only, add 'ride sorted' to the notes for Saturday's game. Then make a separate week sheet from the copy, and tell me what it says about Saturday morning.Look at what the sheet made from the copy says about Saturday. Before you read on: who is taking Lila to her game?
Nobody has said so. “Ride sorted” is a sentence you typed into a file. The sheet may still mark all three Saturday clashes with your note beside Lila’s game, or, if your sheet reads notes, it may now show her game as handled. Either way, it only compares the times and places in its files. It cannot know whether another family has agreed, whether they know she must be there by 8:40, or who brings her home. Your AI tool may offer to treat “ride sorted” as settling the clash; that would hide a clash behind a sentence, not arrange a ride.
The sheet shows where the times collide; a child has a ride only when a named grown-up has said yes to that time and place.
So the decisions on Saturday are yours, worked from your own numbers. To be at Westfield by 9:45, with your 10-minute estimate from Hilltop Park, Theo would leave his last soccer game by 9:35, and that leaves no minutes to load up, park and walk him in; those minutes come before 9:35. So he misses part of one game or the other. Which comes first is a family choice: each club may have its own expectation about missed games, which you can ask the coach about, and Theo has a say. Both coaches should hear the answer from you before Saturday. Lila needs a second grown-up from your house, or a ride from a family who has agreed to the 8:40 arrival, the place, and the trip home. On Monday and Wednesday, your 10-minute estimate between Riverside Park and Maple Street Gymnastics might let one grown-up do both drop-offs, at 4:30 and 5:00, and both pickups, at 5:30 and 6:00, if practice lets out on time; whether to count on that is yours. On Tuesday and Thursday, 30 minutes with a 15-minute drive leaves about 15 minutes to collect Lila, load up, park and walk Theo in, counted to his 5:30 start; the files give no arrive-by time for practices.
When you have looked, remove the copy: “Delete the copy and the sheet you made from it; I’m done with them.” If your AI tool says it made the sheet from the copy somewhere outside this folder, check that it removed that too.
One real run
Here is part of what one AI tool said after the experiment above, with Claude Code on 11 November 2026. Yours will word it differently; check your sheet against the list above, not against this.
The clash summary still lists all three Saturday overlaps. That's howit's built: you asked me to leave drivers out, so it doesn't use notesto decide clashes. If you'd like, I can make the tool treat "ridesorted" as resolving that event's clashes, or show them as "handled"rather than in red.The family, the children, the teams and the places in this answer are made up for this course. The offer at the end is the one to turn down: keep the clashes marked, and keep who takes whom on paper, settled with the people doing the driving.
How real schedules differ
The children, teams, places and times here are made up. This practice week leaves out away games, times that change from week to week, tournaments, byes, picture day and weeks off. So your sheet is retyped or corrected each week from what each coach last sent, and a line on the sheet is only as current as that.
Real schedules differ in other ways too:
- They can change at short notice. Games may be moved or called off for weather or a closed field, sometimes on the morning itself, so check each team’s or studio’s latest message before you trust the sheet, and remake it when something moves.
- Teams often set their own arrive-by times, and a practice can let out late. Use your team’s own instructions, not a guess.
- Drive times can depend on the hour. Your estimate for a weekday at 5 p.m. may not be your estimate for a Saturday morning.
- Before another family drives your child, check what car seat or booster your child needs in their car, and whether your club or league has rules about who may drive players. The team manager may be able to tell you where those rules are.
- A sheet on the fridge shows where your children will be, and when, to anyone who comes into the kitchen. Decide where it goes.
Keep going
Small changes do not need plan mode. Say each in a sentence, then run it again.
Start with the drivers. The sheet names no driver on purpose, because only a grown-up’s yes puts one there. So the next step is a place to write that yes down:
- “Under each event, leave a blank line where I can write who takes each child.” Once a grown-up has agreed to that time and place, write their name in with a pen.
- “Add what each child needs to bring each day, from the notes in the schedules.” Kit only: nothing medical about a child goes into these files or into your AI tool. Lists of gear are yours to add to.
- “At the top of the sheet, show when each schedule file was last changed.” A stale file is easier to spot.
- “Save a checkpoint.” Your AI tool saves a snapshot you can return to.
Your own family’s week
Your league may not hand you a file. Schedules often arrive as screens in a team app, emails, PDFs and group texts. So you type your own week into one blank sheet and run the finished program on it by itself, with your AI tool closed, so your AI tool never sees your children’s details. The practice schedules come in two formats because schedules come from different places; yours will all be in the one sheet.
Do these steps in order. The first five happen now, while your AI tool is open and this folder still holds only the practice files:
-
Go through the data check, the questions in setup about what the data is, who decides how it is used, and which AI tool would see it. Your children’s schedules say where they will be and when; that is for you and the other parents involved to decide on. Other families’ names, phone numbers, team rosters and carpool lists belong to those families: they do not go into this folder, into a chat, or into the files the program reads. For a real child, use a first name only; a surname, a photo, and anything about their health, such as an allergy or an inhaler, stay out of these files and out of your AI tool.
-
Decide on a folder of its own for your real schedules, outside this course folder, for example
~/family-schedules. Nothing has to be in it yet. -
Ask your AI tool for a blank sheet to type into, and for the program to read it, for example:
Make one blank sheet my spreadsheet program can open, for every activity, and a copy of drive-times.csv, both in ~/family-schedules. Change the program to read only those two. Show it working on one made-up row, then clear the row.Look at where it says it saved the two files, and ask what any heading means if you are not sure. Check that it says the made-up row showed on a week sheet and that the sheet is blank again. The copy of
drive-times.csvstill holds the practice places; you will replace them with your own places and minutes. If it offers to copy the practice children’s activities into the new sheet, say no. If it says the program no longer reads this lesson’s data folder, that is fine: the practice week is done. Then say “Save a checkpoint.” so the changed program is kept. -
Ask your AI tool for the exact line, for example: “Write me the exact line to run this myself on the sheet in ~/family-schedules for a week I choose, saving the week sheet there.” Use your own folder’s name, written out in full from your home folder as above. If it offers to copy your real schedules into this folder instead, say no.
-
Copy the line it gives you into a note, and ask your AI tool what each part of it does. It will usually start with
python3, which starts Python, the program that runs what you built; then where the program is in this lesson’s folder, for exampletools/week_sheet.py; then the parts that say which folder to read, where to save the sheet and which week, for example--weekfollowed by a date written year, month, day.~means your home folder. Do not close your AI tool while any part of the line is still unexplained. -
Leave your AI tool the way you did at the start of this lesson.
-
With your AI tool closed, open the blank sheet in your spreadsheet program and type your own next week into it from the team app, the email or the text each coach sent, and put your own places and minutes into the copy of
drive-times.csv. Use first names only, and put kit only in the notes. Save it as the same file type the blank sheet came as, in the same folder. Then paste the line from your note at the$or%prompt and press Enter. The week sheet is saved in that folder, not in the course folder. To come back to the lesson folder later, type the line at the top of this page that begins withmkdir.
Try another case
Before the quiz, write two or three sentences for yourself. In early December the gymnastics studio writes that rehearsals move from Fridays to Thursdays, 4:30 to 6:00, at the same school. Your sheet for that week still shows Friday. What would the sheet show once the file is changed, and what is still yours to do?
A good answer sees three things. The sheet only knows its files, so the gymnastics file has to change before the sheet does. Once it does, Thursday has a clash: Lila’s rehearsal runs to 6:00 and Theo’s futsal practice starts at 5:30 at another place. And there is no drive time for Cedar Middle School in your file, so the sheet should show that drive as unknown until you add your own estimate; who takes whom on Thursdays is then for you and the other grown-ups to settle.
Key takeaways
- Ask briefly, and let your AI tool ask back. Say who you are, which files to use, which week, and what you want; its questions fill in the rest.
- Read the plan before you approve it. It should mark what you would mark and guess nothing you did not give it.
- The sheet is only as current as what you typed into it. Correct it from each coach’s latest message, and remake it when something moves.
- A marked clash is a decision, not a fact to file away. One child in two places means a choice; two children in two places means working out who is with each and how each gets there, and only a grown-up’s yes provides a ride.
- Practice data stays practice data: your family’s week goes into the blank sheet, typed with your AI tool closed, after the data check, with first names, kit only and no other family’s details.
On Saturday Theo's soccer game runs 9:00 to 10:15 at Hilltop Park, and he must arrive by 9:45 for his futsal game at Westfield Community Center. Your drive estimate between them is 10 minutes. What is true?
What’s next
In the next lesson you build the Coaching Playbook Builder, which turns your practice plan, your plays and your roster into a one-page practice sheet for a children’s futsal team.