Cover lesson · 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

Name: Class: Date:

Cover teacher: you need no subject knowledge

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.

What you are doing

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.

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

(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

Step 2: Complete the cutting list spreadsheet

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

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

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

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

Step 4: Explain how digital modelling prevents waste

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.

Step by step

  1. 5 min Write your name, class and date, read Section 1 of the stimulus sheet, and answer the starter question.
  2. 5 min Review the metric conversion, joint tolerance and spreadsheet formula rules on the board.
  3. 10 min Complete Step 1 to convert the 5 part dimensions from cm to mm and record the 3 CAD drawing errors.
  4. 10 min Complete Step 2 to write the spreadsheet formulas and calculate each part’s area, total area and cost.
  5. 12 min Complete Step 3 to calculate the usable bed size and sketch a valid nesting layout for all 5 parts.
  6. 5 min Complete Step 4 to explain how CAD checks and spreadsheet formulas prevent wasted plywood.
  7. 3 min Check your numbers against the board and tick the success criteria below.

Success criteria

If you finish early