Supply teacher deck · Design Technology · Year 7

Planning a CAD Desk Tidy with a Cutting List Spreadsheet

Slide 1 of 7
05:00

Slide 1 of 7 · Settling starter · Design Technology · Year 7

5 minutes

Planning 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?

DCF: Data and computational thinking → Problem solving and modelling · LNF: Numeracy → Measurement No computers or workshop tools needed · work on your sheet

Slide 2 of 7 · Today’s brief and key rules · Design Technology · Year 7

5 minutes

Units, 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
Why subtract 10 mm from length and width? 5 mm margin on left + 5 mm on right = 10 mm Check the stimulus sheet diagrams

Slide 3 of 7 · Step 1: Convert units & spot 3 CAD errors · Design Technology · Year 7

10 minutes

Step 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!
Find Error 2 (base slot width) and Error 3 (finger joint tab width) on the stimulus sheet 10 minutes

Slide 4 of 7 · Step 2: Cutting list spreadsheet · Design Technology · Year 7

10 minutes

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

Check every row carefully before adding up the total area in cell D7 10 minutes

Slide 5 of 7 · Step 3: Laser bed nesting layout · Design Technology · Year 7

12 minutes

Step 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!
Draw and label all 5 rectangles with their millimetre dimensions on the grid in Step 3 12 minutes

Slide 6 of 7 · Step 4: Pre-cut checklist & self-check · Design Technology · Year 7

5 minutes

Step 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 C4 automatically updates the total area and cost when formulas are used.
  • Tick the Success Criteria checkboxes at the bottom of your worksheet.
Check all units (mm and mm2) are written clearly 5 minutes

Slide 7 of 7 · Plenary quick check · Design Technology · Year 7

3 minutes

Quick 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
Make sure your name, class and date are on your worksheet Hand in your worksheet · leave the stimulus sheet on the desk