Worked example · Design Technology · Year 7 · Beginner

Planning a CAD desk tidy with a cutting list spreadsheet

DCF: Data and computational thinking → Problem solving and modelling

Also assessed, LNF: Numeracy → Geometry → Measurement

What this is

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.

Step 1: Convert units (cm to mm) and spot 3 CAD errors

(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.

Step 2: Complete the cutting list spreadsheet

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.

Step 3: Nest all 5 parts on the 300 mm × 200 mm laser bed

(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.

Step 4: Explain how digital modelling prevents waste

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.

If you finish early: answers

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).

Why this response is secure