dcf.cymru stimulus sheet · Design Technology · Year 7
Please share this sheet between two and do not write on it. Use the client brief, CAD inspection table and spreadsheet layout below to complete your worksheet.
Year 7 pupils are using 2D Computer-Aided Design (CAD) software to model a flat-pack desk tidy cut from 4 mm birch plywood on the workshop laser cutter. Before any plywood is cut, you must check that the CAD drawing matches the brief and fits onto one standard laser sheet.
Design specification (what the finished desk tidy must have):
A pupil wrote the outside rectangle sizes of the 5 parts in centimetres (cm) in their sketchbook. Remember that CAD software and workshop cutting lists always use millimetres (mm), where 1 cm = 10 mm.
| Part ID | Part name | Quantity | Sketchbook length (cm) | Sketchbook width (cm) |
|---|---|---|---|---|
| Part A | Base plate | 1 | 16 cm | 10 cm |
| Part B | Back panel | 1 | 16 cm | 9 cm |
| Part C | Front rail (with phone slot) | 1 | 16 cm | 5 cm |
| Part D | Left side cheek | 1 | 10 cm | 8.5 cm |
| Part E | Right side cheek | 1 | 10 cm | 8.5 cm |
Before exporting the file to the laser cutter, the teacher ran a dimension check on the pupil’s 2D CAD drawing. Compare the CAD dimensions below against the specification in Section 1 to find the 3 errors.
+--------------------------------------------------------------------------+ | PART A: BASE PLATE (160 mm x 100 mm) | | * Central slot for vertical plywood divider: | | Length = 80 mm, Slot width = 3 mm [Check against 4 mm plywood!] | +--------------------------------------------------------------------------+ | PART B: BACK PANEL (160 mm x 90 mm) | | * Left and right vertical slots to receive Side Cheek finger tabs: | | Slot width = 20 mm, Slot thickness = 4 mm | +--------------------------------------------------------------------------+ | PART C: FRONT RAIL (160 mm x 50 mm) | | * Rectangular phone slot cut-out in top edge: | | Cut-out width = 62 mm, Cut-out depth = 15 mm [Check phone width!] | +--------------------------------------------------------------------------+ | PARTS D & E: LEFT AND RIGHT SIDE CHEEKS (100 mm x 85 mm each) | | * Projecting finger tabs on back edge to slot into Part B: | | Tab width = 25 mm, Tab thickness = 4 mm [Check against Part B!] | +--------------------------------------------------------------------------+
The Design Technology department uses a spreadsheet to calculate the rectangular surface area and timber cost of every pupil’s design. Birch plywood costs 0.5 pence for every 100 mm2 of timber used.
| Row / Col | Column A: Part name | Column B: Length (mm) | Column C: Width (mm) | Column D: Area (mm2) |
|---|---|---|---|---|
| Row 1 | Part description | Length_mm | Width_mm | Area_mm2 |
| Row 2 | Part A: Base plate | 160 | 100 | =B2*C2 → 16,000 |
| Row 3 | Part B: Back panel | 160 | 90 | (Complete on worksheet) |
| Row 4 | Part C: Front rail | 160 | 50 | (Complete on worksheet) |
| Row 5 | Part D: Left side cheek | 100 | 85 | (Complete on worksheet) |
| Row 6 | Part E: Right side cheek | 100 | 85 | (Complete on worksheet) |
| Row 7 | Total area of all 5 parts (mm2) | Formula: =SUM(D2:D6) |
||
| Row 8 | Total material cost in pence (at 0.5p per 100 mm2) | Formula: =(D7/100)*0.5 |
||
When you subtract the 5 mm safety margin from both ends of the 300 mm length (300 − 5 − 5 = 290 mm) and from both sides of the 200 mm width (200 − 5 − 5 = 190 mm), the usable cutting rectangle is 290 mm wide by 190 mm high. Remember that a rectangle on a laser bed can be rotated by 90 degrees (for example, a 160 mm × 50 mm rail can stand vertically as 50 mm wide × 160 mm high) if that helps all 5 parts fit neatly.