Slide 1 of 7 · Settling starter · Design Technology · Year 7
5 minutesPlanning a CAD Desk Tidy with a Cutting List Spreadsheet
Before a 2D CAD drawing is sent to the workshop laser cutter, every dimension must be checked in millimetres and nested neatly onto the birch plywood sheet. Today you will spot 3 CAD errors, complete the cutting list spreadsheet, and lay out all 5 parts.
While the register is called: write your name, class and date on your worksheet, then read Section 1 of the stimulus sheet and answer the starter question in rough.
Starter question: In Design Technology, all CAD drawings use millimetres (mm). If a base plate measures 16 cm by 10 cm, what are its length and width in millimetres?
Slide 2 of 7 · Today’s brief and key rules · Design Technology · Year 7
5 minutesUnits, CAD tolerances and spreadsheet formulas
A single wrong number in a CAD model means the laser-cut parts will not slot together. Use these rules across Steps 1 to 4.
| Topic | Workshop and CAD rule |
|---|---|
| Metric conversion | 1 cm = 10 mm (multiply cm by 10 to get mm) · 1 cm2 = 100 mm2 |
| Matching joints | A finger tab on one part and its matching slot on the joining part must have the exact same width and thickness (4 mm plywood = 4 mm slot) |
| Spreadsheet formulas | Every formula starts with = · Multiply with * (e.g. =B2*C2) · Add a column with =SUM(D2:D6) |
| Laser bed margin | A 300 mm × 200 mm sheet with a 5 mm safety margin on all 4 edges leaves a 290 mm × 190 mm usable area |
Slide 3 of 7 · Step 1: Convert units & spot 3 CAD errors · Design Technology · Year 7
10 minutesStep 1: Convert cm to mm and spot 3 CAD errors
Convert the 5 part sizes from centimetres to millimetres in Step 1(a), then inspect the draft CAD drawing on the stimulus sheet to find the 3 dimension errors in Step 1(b).
Worked first row & Error 1 hint:
- Part A (Base plate): 16 cm × 10 cm = 160 mm × 100 mm
- Part D & Part E (Side cheeks): 10 cm × 8.5 cm = 100 mm × 85 mm
- Error 1 (Phone slot): The brief says the phone with its case is 80 mm wide and needs a 85 mm slot, but the CAD drawing shows only 62 mm!
Slide 4 of 7 · Step 2: Cutting list spreadsheet · Design Technology · Year 7
10 minutesStep 2: Complete the cutting list spreadsheet
Fill in the missing cell values and spreadsheet formulas in Step 2. In a spreadsheet, =B2*C2 multiplies the length in column B by the width in column C.
Row 2 (Base plate): Length B2 = 160, Width C2 = 100 · Formula in D2: =B2*C2 · Area = 16,000 mm2
Row 7 (Total area of all 5 parts): Formula in D7: =SUM(D2:D6)
Row 8 (Material cost at 0.5p per 100 mm2): Formula in D8: =(D7/100)*0.5 (or divide by 200)
Slide 5 of 7 · Step 3: Laser bed nesting layout · Design Technology · Year 7
12 minutesStep 3: Nest all 5 parts on the 300 mm × 200 mm sheet
Nesting means arranging parts tightly near the edges of the sheet so they all fit and leave a large reusable offcut. Remember the 5 mm safety margin around all 4 edges!
How to check your layout fits inside 290 mm × 190 mm:
- Left column (160 mm wide): Stack Part A Base (160 × 100 mm) and Part B Back panel (160 × 90 mm) → total height = 100 + 90 = 190 mm (fits the 190 mm usable height!).
- Right column (remaining width = 290 − 160 = 130 mm): Place Part D (100 × 85 mm), Part E (100 × 85 mm) and Part C (50 × 160 mm rotated, or alongside). Check that every row and column stays within 290 mm × 190 mm!
Slide 6 of 7 · Step 4: Pre-cut checklist & self-check · Design Technology · Year 7
5 minutesStep 4: Why we model in CAD before laser cutting
Complete Step 4 on your worksheet to explain how digital modelling and spreadsheets prevent wasted timber and money in the workshop.
- State what would have happened if the 3 CAD errors had not been spotted before cutting.
- Explain why changing one number in cell
C4automatically updates the total area and cost when formulas are used. - Tick the Success Criteria checkboxes at the bottom of your worksheet.
Slide 7 of 7 · Plenary quick check · Design Technology · Year 7
3 minutesQuick check before you hand in your sheet
Check your working against the key answers below before passing your worksheet to the front.
| Question | Correct answer |
|---|---|
| 3 CAD errors spotted | 1. Phone slot 62 mm → 85 mm · 2. Divider slot 3 mm → 4 mm · 3. Side tabs 25 mm → 20 mm |
Total area of all 5 parts (D7) |
16,000 + 14,400 + 8,000 + 8,500 + 8,500 = 55,400 mm2 |
Material cost of parts (D8) |
(55,400 ÷ 100) × 0.5p = 277p (£2.77) |
| Usable laser bed & leftover sheet area | Usable bed: 290 mm × 190 mm · Leftover offcut from 60,000 mm2 sheet: 4,600 mm2 |