Worked example · Design Technology · Year 7 · Beginner
DCF: Data and computational thinking → Problem solving and modelling
Also assessed, LNF: Numeracy → Geometry → Measurement
A complete model response and answer key for the Year 7 Design Technology cover lesson. Key answers: Part sizes in mm are 160 × 100, 160 × 90, 160 × 50, 100 × 85, and 100 × 85. The 3 CAD errors are: Phone slot 62 mm → 85 mm; Base divider slot 3 mm → 4 mm; Side cheek finger tabs 25 mm → 20 mm. Total area = 55,400 mm2; material cost = 277p (£2.77); usable laser bed = 290 mm × 190 mm; leftover sheet area = 4,600 mm2.
(a) Converted dimensions in millimetres:
| 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 | 160 mm | 90 mm |
| Part C | Front rail | 16 cm × 5 cm | 160 mm | 50 mm |
| Part D | Left side cheek | 10 cm × 8.5 cm | 100 mm | 85 mm |
| Part E | Right side cheek | 10 cm × 8.5 cm | 100 mm | 85 mm |
(b) Three CAD dimension errors identified and corrected:
| Error no. | Which part has the error? | Wrong dimension on CAD drawing | Corrected dimension (mm) & why |
|---|---|---|---|
| Error 1 | Part C: Front rail (phone slot) | Phone slot width is drawn as 62 mm. | Change to 85 mm wide so the 80 mm phone in its case fits with 5 mm clearance. |
| Error 2 | Part A: Base plate (divider slot) | Central divider slot width is drawn as 3 mm. | Change to 4 mm wide because the birch plywood sheet is 4 mm thick; a 3 mm slot is too narrow for the divider to slot in. |
| Error 3 | Parts D & E: Side cheek finger tabs | Projecting finger tabs are drawn as 25 mm wide. | Change to 20 mm wide so the tabs fit into the 20 mm slots on Part B (Back panel). |
Multiplies centimetre measurements by 10 accurately (including 8.5 cm = 85 mm) and checks both functional clearance (the phone slot) and mating joint tolerances (4 mm sheet thickness and 20 mm finger tabs). Evidences success criteria 1 and 2.
| 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 | =B3*C3 |
14,400 |
| 4 | Part C: Front rail | 160 | 50 | =B4*C4 |
8,000 |
| 5 | Part D: Left side cheek | 100 | 85 | =B5*C5 |
8,500 |
| 6 | Part E: Right side cheek | 100 | 85 | =B6*C6 |
8,500 |
| 7 | Total area of all 5 parts (mm2) | =SUM(D2:D6) |
55,400 | ||
| 8 | Material cost in pence (at 0.5p per 100 mm2) | =(D7/100)*0.5 |
277p (£2.77) | ||
Uses relative cell references for each row formula, =SUM(D2:D6) for the total area, and calculates both the area (55,400 mm2) and cost (277p = £2.77) accurately. Evidences criterion 3.
(a) Laser bed and waste calculations:
(b) Model nesting layout inside the 290 mm × 190 mm usable area:
+---------------------------------------+--------------------+--------------+ | | | | | PART A: BASE PLATE | PART D: LEFT | PART C: | | 160 mm x 100 mm | SIDE CHEEK | FRONT RAIL | | | 85 mm x 100 mm | (rotated) | | | (rotated) | 45/50 mm | +---------------------------------------+--------------------+ x 160 mm | | | | | | PART B: BACK PANEL | PART E: RIGHT | | | 160 mm x 90 mm | SIDE CHEEK +--------------+ | | 85 mm x 90/100 | Offcut zone | | | | | +---------------------------------------+--------------------+--------------+ <-- 160 mm --> <-- 85 mm --> <-- 45/50 mm -> Total width: 160 mm + 85 mm (rotated side cheeks) + 45 mm (or shared cut line) ≤ 290 mm Left column height: 100 mm (Part A) + 90 mm (Part B) = 190 mm (exact fit!)
Note for marking: Accept any clear rectangular layout where Parts A (160 × 100 mm) and B (160 × 90 mm) stack on the left to use 160 mm width by 190 mm height, and Parts C, D and E are placed in the remaining 130 mm × 190 mm space on the right (with rotation or shared cut lines noted).
Subtracts the 5 mm safety margin from both ends of each axis (subtracting 10 mm in total) and arranges the parts systematically by matching heights and widths. Evidences criterion 4.
If the pupil had sent the unedited CAD file straight to the laser cutter, the finished plywood pieces would have been unusable: the phone would not have fitted into the 62 mm slot, the 4 mm divider would have jammed against the 3 mm base slot, and the 25 mm finger tabs on the side cheeks would not have fitted into the 20 mm slots on the back panel, wasting £2.77 of birch plywood and laser time. Using spreadsheet formulas like =B4*C4 and =SUM(D2:D6) is much better than typing numbers by hand because if a designer changes one measurement in Column B or C, the spreadsheet automatically recalculates the part area, total area and cost without human arithmetic mistakes.
Links each of the three CAD errors to its physical assembly failure in the workshop and explains automatic recalculation in a spreadsheet model. Evidences criterion 5.
1. Percentage of sheet used and waste:
Percentage used = (55,400 ÷ 60,000) × 100 = 92.3% (to 1 d.p.).
Percentage waste/offcut = 100% − 92.3% = 7.7%.
2. Increasing Front Rail width (C4) from 50 mm to 60 mm:
Cells that automatically recalculate: D4 (Part C area), D7 (Total area) and D8 (Material cost).
New D4 = 160 × 60 = 9,600 mm2 (an increase of 1,600 mm2).
New D7 = 55,400 + 1,600 = 57,000 mm2.
New D8 = (57,000 ÷ 100) × 0.5p = 285p (£2.85).
= and uses =SUM(D2:D6) for the column total.