Unit 1 teaching is done. Today is a check-and-fix workshop: does your multi-sheet workbook actually show the Unit 1 skills, and can you name one technique that already changed how you handle numbers on your Something Real project?
SEC means the exam and course outcomes your teacher has on the board. In plain words, Unit 1 asks you to show: a multi-sheet file with clear jobs, clean data entry, formulas including at least one IF, and sensible file formats when you share work.
Your teacher will run a short outcome check on the class screen using one shared demo file, then you fix gaps in your own workbook and write a short Unit 1 reflection for your portfolio.
Look at the class screen: Aoife's phone-case workbook shows three tabs named {{code:data}}, {{code:summary}}, and {{code:charts}}. Thumbs up if your own file already has three clearly named tabs. Thumbs sideways if you still have {{code:Sheet1}} or only one sheet. No need to shout names out: this is a private self-check so we know who needs pair support before the audit.
Unit 1 is complete when your workbook shows these habits, not when you can only name them. Today you will mainly fix three things:
Use this short checklist while you work. Your teacher will point at the fuller board version during the demo.
| Concept | Why it matters | Example |
|---|---|---|
| Multi-sheet workbook — one file with several named worksheets, each with a clear job | Assessors find answers faster when raw numbers, totals, and visuals are not piled on one sheet | Tabs named {{code:data}}, {{code:summary}}, {{code:charts}} |
| Data input best practice — headings in row 1, no blank rows mid-table, one fact per row, consistent types per column | Sort, filter, charts, and formulas fail quietly when the table is messy | Euro prices in one column, whole-number quantities in the next |
| Standard functions on a summary sheet — SUM, AVERAGE, COUNT/COUNTA pulled from the data sheet | The spreadsheet stops being a list and starts answering your project question | {{formula:=SUM(data!C2:C6)}} for total stock |
| Logical formula (IF) — a formula that makes a decision from a condition | Unit 1 wants decisions, not totals alone | {{formula:=IF(B2>=40,"Stock healthy","Top up soon")}} on the summary sheet |
With your teacher, walk the shared sample multi-sheet workbook {{code:sm3_unit1_demo}} against the Unit 1 checklist. Stay on the class demo for this step: you will confirm sheet jobs, check data hygiene, test one logical formula, and jot one personal gap to fix on your own project file in Independent practice.
| Issue | Solution |
|---|---|
| My tabs are still called Sheet1, Sheet2, Sheet3 | Double-click each tab and rename it to the job it does ({{code:data}}, {{code:summary}}, {{code:charts}}). Vague names fail the multi-sheet outcome even if the numbers are fine. |
| Sort mixed up my prices and item names | You probably sorted one column only. Select the full data block including headings (all columns in the table), then sort again so whole rows move together. |
| My summary formula shows 0 or an error | Check the sheet name in the reference matches the real tab name, and that the range points at number cells. In Sheets and Excel for the web, {{code:data!C2:C6}} only works if a sheet is actually named {{code:data}}. |
| I cannot find {{code:sm3_from_template}} or the demo | Start at {{code:Project_Portfolio}} → {{code:09_specialism}} → {{code:sm3}}. Own project work uses your {{code:sm3_from_template}} file there. The class audit uses the teacher file {{code:sm3_unit1_demo}} only. |
| I have totals but no logical formula | Add one simple IF that answers a project question (stock low, hours over target, cost over budget). Unit 1 wants standard functions and logical formulas, not totals alone. |
| Which file format should I keep? | Keep the working workbook in Excel for the web or Google Sheets. Export {{code:.csv}} only when someone needs plain values, and {{code:.pdf}} when a supervisor or club treasurer needs a finished one-page share without editable formulas. |
You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.