Cover lesson · Design Technology · Year 7 · Beginner
DCF: Data and computational thinking → Problem solving and modelling
Also assessed, LNF: Numeracy → Geometry → Measurement
Name: Class: Date:
What this practises: digital modelling and spreadsheet problem-solving in Design Technology, alongside metric measurement conversion (cm to mm), area and nesting. Pupils convert 5 birch plywood part dimensions from cm to mm, spot 3 dimension errors in a 2D CAD drawing, complete a cutting list spreadsheet with formulas, and nest all 5 parts inside a 300 mm by 200 mm laser bed with a 5 mm safety margin.
Board: open the supply teacher presentation for board slides, timers and script: /cover-lesson-resources/presentations/planning-a-cad-desk-tidy-with-a-cutting-list-spreadsheet.html
Print: this worksheet (one per pupil) and the stimulus sheet “Plywood desk tidy: 2D CAD drawing, brief and sheet sizes” (one between two). Pupils need a pen, pencil and ruler.
Run: 5 min settling starter · 5 min units and CAD brief · 10 min Step 1 unit conversion and 3 CAD errors · 10 min Step 2 cutting list spreadsheet · 12 min Step 3 laser bed nesting · 5 min Step 4 modelling review · 3 min plenary check. Total 50 minutes.
Collect: this worksheet at the end of the lesson. Keep the stimulus sheets for the next class.
Quick checks: the 3 CAD errors are: (1) phone slot is 62 mm instead of 85 mm, (2) base divider slot is 3 mm instead of 4 mm, (3) side cheek finger tabs are 25 mm instead of 20 mm. Total area of the 5 parts = 55,400 mm2; cost = 277p (£2.77); usable laser bed = 290 mm × 190 mm.
In Design Technology, checking a 2D Computer-Aided Design (CAD) drawing and a cutting list spreadsheet on screen is much cheaper than miscutting sheets of birch plywood on the laser cutter. Today you will convert sketchbook measurements from centimetres into millimetres, find 3 dimension mistakes on a pupil’s draft CAD file, write the spreadsheet formulas to calculate the total area and cost, and arrange all 5 parts inside the laser cutter bed.
(a) Convert the 5 part dimensions from centimetres (cm) into millimetres (mm) by multiplying by 10. Part A is done for you.
| Part ID | Part name | Sketchbook size (cm) | CAD length (mm) | CAD width (mm) |
|---|---|---|---|---|
| Part A | Base plate | 16 cm × 10 cm | 160 mm | 100 mm |
| Part B | Back panel | 16 cm × 9 cm | ||
| Part C | Front rail | 16 cm × 5 cm | ||
| Part D | Left side cheek | 10 cm × 8.5 cm | ||
| Part E | Right side cheek | 10 cm × 8.5 cm |
(b) Compare Section 3 of the stimulus sheet (the draft CAD drawing) with Section 1 (the design specification). Identify the 3 dimension errors and state the corrected measurement in millimetres.
| Error no. | Which part has the error? | Wrong dimension on CAD drawing | Corrected dimension (mm) & why |
|---|---|---|---|
| Error 1 | Part C: Front rail (phone slot) | ||
| Error 2 | Part A: Base plate (divider slot) | ||
| Error 3 | Parts D & E: Side cheek finger tabs |
Complete the missing formulas and calculated values in the spreadsheet table below. Remember that every spreadsheet formula must start with =.
| Row | Column A: Part name | Column B: Length (mm) | Column C: Width (mm) | Column D: Formula | Column D: Value (mm2) |
|---|---|---|---|---|---|
| 2 | Part A: Base plate | 160 | 100 | =B2*C2 |
16,000 |
| 3 | Part B: Back panel | 160 | 90 | ||
| 4 | Part C: Front rail | 160 | 50 | ||
| 5 | Part D: Left side cheek | 100 | 85 | ||
| 6 | Part E: Right side cheek | 100 | 85 | ||
| 7 | Total area of all 5 parts (mm2) | ||||
| 8 | Material cost in pence (at 0.5p per 100 mm2) | =(D7/100)*0.5 |
|||
(a) The birch plywood sheet measures 300 mm by 200 mm, with a 5 mm safety margin on all 4 edges (left, right, top and bottom). Calculate:
D7) = ____________ mm2(b) In the box below (representing the 290 mm wide × 190 mm high usable cutting zone inside the 5 mm safety margin), draw and label all 5 rectangular parts (A, B, C, D and E) with their millimetre dimensions so that none overlap and the total width and height stay within 290 mm by 190 mm.
Usable laser bed: 290 mm wide (horizontal) × 190 mm high (vertical). Sketch and label Parts A, B, C, D and E with their dimensions in mm:
Write 3 or 4 sentences explaining: (1) what would have happened in the workshop if the pupil had laser-cut the desk tidy without checking the 3 CAD dimensions first, and (2) why using formulas like =B4*C4 and =SUM(D2:D6) in a cutting list spreadsheet is better than typing the answers in by hand.
=B3*C3, =SUM(D2:D6)) and calculate areas in mm2 and material cost.55,400 ÷ 60,000 × 100, rounded to 1 decimal place), and the percentage that is waste/offcut.D7 and new cost in D8 be?