Example (the Orders table used in this course)
A small catering business tracks orders. Prices are in your currency.
| OrderID | Date | Customer | Item | Qty | Price | Amount | Status | Paid | Owner |
|---|
| ORD-001 | 2026-11-02 | Cruz | Pancit tray | 2 | 45 | 90 | Done | Yes | Ana |
| ORD-002 | 2026-11-03 | Lee | Lumpia box | 3 | 20 | 60 | Done | No | Ben |
| ORD-003 | 2026-11-05 | Patel | Adobo tray | 1 | 55 | 55 | In progress | No | Ana |
| ORD-004 | 2026-11-06 | Kim | Lumpia box | 5 | 20 | 100 | New | No | Cy |
| ORD-005 | 2026-11-09 | Cruz | Adobo tray | 2 | 55 | 110 | Done | Yes | Ben |
| ORD-006 | 2026-11-10 | Ito | Pancit tray | 1 | 45 | 45 | New | No | Cy |
Amount is Qty x Price. =SUM(Orders[Amount]) gives 460.
Try it now
Draw the tab plan for a system you need (a team task list, a club membership list or a shop's orders). For each tab write its job and who edits it. Then build the main data tab as a table with column types and a unique ID column.
ClaudeStuck? Copy a ready-made prompt for Claude
Copy this, open Claude, paste it, and Claude will walk you through the lesson step by step.
For a grown-up: Claude is for adults (18+). Copy this, paste it into Claude, and use the answer to explain the lesson to your child.
I'm learning "Sheets Systems: connected tools and dashboards" on The Future Market. Lesson 1: "Design a Sheets system".
What the lesson teaches:
- Plan your system in layers. Each tab has one job:
- Tab - Job - Who edits it
- Input (a Google Form or an entry tab) - New records come in - Team members
- Orders (a table) - The single source of truth: one row per record - Team, only the input columns
- Lists - Allowed values for drop-downs (items, staff, statuses) - Owner
- Dashboard - Pivot tables, charts, slicers, key numbers - Nobody (formulas only)
- Read me and Log - How the system works, what changed - Owner
The exercise I'm working on:
Draw the tab plan for a system you need (a team task list, a club membership list or a shop's orders). For each tab write its job and who edits it. Then build the main data tab as a table with column types and a unique ID column.
I'm stuck. Please:
1. Explain the main idea in plain, simple words with one everyday example.
2. Walk me through the exercise one small step at a time. Ask me what I've done so far before giving the next step.
3. Don't just give me the final answer. Help me do it myself, and check my work when I share it.
I'm a parent helping my child (about 8 years old) with a lesson called "Design a Sheets system" from the course "Sheets Systems: connected tools and dashboards".
Here's what the lesson says:
A restaurant kitchen has stations: one person takes orders, one cooks, one plates, and the manager watches the screen. Nobody cooks at the order desk. A good Sheets system also has stations, called tabs, and each tab has one job.
The activity:
Draw the tab plan for a system you need (a team task list, a club membership list or a shop's orders). For each tab write its job and who edits it. Then build the main data tab as a table with column types and a unique ID column.
Please explain this so an 8-year-old understands: short sentences, a fun everyday example, and no hard words.
Then give me 3 simple questions I can ask my child to check they understood, and a way to do the activity together, one tiny step at a time.