Hero image

The D&T Repository

With almost 30 years leading and teaching Design and Technology with moderation and examining experience, these resources have been used to achieve very high pass rates and a wide range of innovative outcomes. The author has extensive experience as a DATA consultant, resource producer and presenter, and as a commercial 2D and 3D designer, visualiser and illustrator. He is also a prolific writer on the subject of D&T whose Subject Genius D&T blog was shortlisted in the TES 2016 awards.

37Uploads

29k+Views

7k+Downloads

With almost 30 years leading and teaching Design and Technology with moderation and examining experience, these resources have been used to achieve very high pass rates and a wide range of innovative outcomes. The author has extensive experience as a DATA consultant, resource producer and presenter, and as a commercial 2D and 3D designer, visualiser and illustrator. He is also a prolific writer on the subject of D&T whose Subject Genius D&T blog was shortlisted in the TES 2016 awards.
GCSE Design and Technology Digital Folder Checklist
splinterssplinters

GCSE Design and Technology Digital Folder Checklist

(0)
Designed to be used for the outgoing GCSE and the new 2017 syllabus, this checklist can be used to ensure that a complete folder of work is produced. It can also be used to produce the relevant sheets for a digital folder or as an assessment tool and progress tracker. Easy to edit to suit the needs of the centre, subject or students, this is based on the AQA NEA requirements.
AQA GCSE Design and Technology 9-1 Tracker (with comment banks) UPDATED May 2020!
splinterssplinters

AQA GCSE Design and Technology 9-1 Tracker (with comment banks) UPDATED May 2020!

(5)
This enhanced version of the AQA GCSE tracker has been updated to generate comments from the marks awarded. It has been updated to have the two AQA specimen papers for reference and the 2019 GCSE paper to use as a mock examination which will be added to the NEA assessment to give an accurate prediction based on the previous years’s grade boundaries. Updated May 2020 with all the AQA theory mapped over 65 lessons with ongoing assessments. Supporting presentations that match the lessons will be coming later this year. Please note the Grade Boundary sheet is up to date with the 2019 grade boundaries for both the paper and NEA as of 22/8/19. To use: Simply use the Context sheet to enter all student details including candidate number and attainment target. Use the Comment sheet to award marks for each Assessment Objective and comments will be provided in the boxes for use in CRF’s or reports. Use the Mock sheet to add the marks from the 2019 paper used as a mock exam. Use the Theory sheet to help plan out your weekly lessons to ensure all the theory is covered. You can also use this to keep a track of ongoing assessments and it will show an average. It will also allow you to compare a test paper to the final mock to see if the students have improved. Everything will then be transferred to the front Summary sheet, totals will be generated and levels awarded derived from the existing GCSE boundaries. Old type grades are also provided for reference. All the cells that do not need editing are locked to avoid making mistakes but the sheet can be unlocked with the password ‘gcse’. Updated May 2016 with room for 26 student names and added a pie chart to show percentage of students who were above/below target. More can be added if you are comfortable with editing Excel spreadsheets or simply make additional copies of the spreadsheet for the additional students. If you have less than 26, ensure that there is nothing entered into the A8 column on the context sheet and the pie chart will ignore these when calculating the percentage of students above/below target. Extra sheets for homework and assessments can be tailored to suit your needs and will not affect the Summary sheet or the predicted levels.
GCSE 9-1 Design and Technology NEA Student Guide (AQA
splinterssplinters

GCSE 9-1 Design and Technology NEA Student Guide (AQA

(0)
This PDF is intended as a guide for students to help them through their NEA in the new GCSE Design and Technology. It is a 32-page printable booklet which can be used digitally or is ideal for an A5 size pamplet (using just 8 sheet of A4). It has no worksheets or questions but describes each section of the NEA with illustrations taken from the accompanying exemplar folder which is available separately or as part of a bundle at a reduced price. Because this is a generic guide linked to a sample context, it does not constitute a writing frame so can be given to students to support them in their GCSE NEA. It is designed to support the AQA syllabus but can be used for other examination boards.
AQA Exemplar D&T Folder for the new GCSE [Updated March 2020]
splinterssplinters

AQA Exemplar D&T Folder for the new GCSE [Updated March 2020]

(2)
This is my own take on what I believe a level 9 folder could look like for the new AQA GCSE in Design and Technology and was produced when no examplar material was avalable from examination boards. It is appropriate for the ‘children’s learning and play’ sample context and covers exploring a context, iterative design, prototyping and client led brief along with investigations, analysis and evaluations. Supplied as both self-running Powerpoint Show and printable PDF file, there are 40 slides in the folder as per the AQA suggested limit, each with a commentary and a summary at the end of each A0 as well as extra slides at the end to support the process. In total there are now 68 slides here but the extra slides are for the benefit of the teacher, or to explain and justify the marks awarded. There is evidence in the folder of SketchUp, Solidworks, Photoshop and the use of CNC equipment and 3D printing. It is not endorsed by any examination board but can inspire you in your approach to teaching the new NEA in your school to a very high standard. I worked as an examiner and moderator for the AQA for 20 years with 27 years D&T teaching and leadership experience where many students achieved 100% for their coursework. This is based on that experience and a culmination of assessing thousands of folders coupled with industry design experience. Additionally, I have consulted for DATA, TES, V&A, Routledge, PGOnline, Doddle and the BBC. Recent additions (July 2018) include 16 extra slides to show a summary of modelling, drawing, CAD etc. and further development of the product beyond the GCSE prototype into AS/A Level territory with the outcome being a completely 3D printed prototype. August 2018 update simply adds some extra info. UPDATE: March 2020 additional pages added to support the use of the Braille Box to teach about branding, IP, patents, crowdfunding, ecological footprint and more.
The 7 Year A Level: Planning a D&T curriculum from Key Stage 2
splinterssplinters

The 7 Year A Level: Planning a D&T curriculum from Key Stage 2

(0)
This resource is intended to help you in planning out your D&T curriculum over 3, 5 or 7+ years and allows for work from the end of KS2 up to KS5. The resource contains a blank project/task mapping spreadsheet and one filled in with examples to help you get started. These cover the main areas in the national curriculum and examination level along with additional columns for maths, science and technical skills. Also included is a skills assessment spreadsheet to visualise how you have covered all the skills across Key Stages 3 and 4, and a comprehensive list of D&T skills to cover in editable Word format. Using this resource with the other KS3 resources available, you will have a comprehensive set of resources to help you plan and deliver an effective D&T curriculum. Also included is a breakdown of the AQA GCSE theory requirements with additional sections to be used with the skills/project mapping or curriculum planning.
AQA A Level tracking with ongoing assessment data (May 2020)
splinterssplinters

AQA A Level tracking with ongoing assessment data (May 2020)

(1)
UPDATE (May 2020): suitable past paper questions are now added to each section and will match the presentation slides that will be available in the near future. See product details for how to use these for ongoing assessment. This is a comprehensive tracker for AQA A Level Product Design although it could be adapted for other courses/exam boards. If you complete the Student information sheet, all the relevant data will be copied to the corresponding sheets. The same with the Grade boundary sheet which sets last year’s grade boundaries for every aspect of the course. There is an outline for delivering the course theory content spread over 60 lessons which will have supporting presentations at a later date. Teachers can choose the past papers to use for reinforcing learning and these are all mapped to the new content on the Content sheet. For ongoing assessments, put the total score for the question in the top of the column for each lesson or unit and as you complete the score for the student, it will give an average of their results over the year and compare these to their mock results. All this data is copied to the front page where the results from the NEA are added to give an accurate grade prediction based on the previous year’s grade boundaries. There is scope for teachers to tweak this resource to suit but for now, cells that have formula or references are locked to prevent any errors. Each worksheet can be unlocked with the password ‘advanced’.
AQA A Level theory: L1 Introduction
splinterssplinters

AQA A Level theory: L1 Introduction

(0)
This is a free unit to introduce the format of the A Level theory lessons which are Powerpoint presentations for each aspect of the A Level sylllabus with past paper questions for each topic supported in the A Level tracker which is also available. They cover 60 hour long lessons with three more for mock exams. This resource will make a comprehensive guide to the theory with ongoing assessment and tracking of the theory and NEA aspects of the course. Further units will be made available then bundled together into more cost effective units.
USB Lantern remote learning resource
splinterssplinters

USB Lantern remote learning resource

(13)
This is a resource designed specifically to support the teaching of Design and Technology at KS3 via remote learning. Rather than adapting an old classroom resource to try and teach remotely, this resource takes advantage of the situation to provide a unique learning experience. Students can learn many of the skills an industrial designer needs to work in industry often in a different location to manufacturing facilities. A wide range of skills and techniques can be incorporated into this project making it adaptable for a range of ages, abilities and environments. Several of these are suggested in the supporting documents. The resource currently consists of a 52 page self running Powerpoint Show (Office not required to view), a 34 page PDF SketchUp tutorial document and three files for cutting the components. A printable packaging net is also included as well as a template for a paper diffuser should students wish to take that option. We have also included a shortened version of the 40 page workbook that is designed to be used in Powerpoint so no need to print off paper copies. Hopefully this will inspire you to develop your own format and aid the move to a digital format in the future. The laser cutting files are in Adobe Illustrator format but the program is currently free to use for a few months so you can use it as it is or just to export to DXF or other format you may need during the trial period if you don’t already own and use this software.
GCSE D&T Exemplar Complete Toolkit
splinterssplinters

GCSE D&T Exemplar Complete Toolkit

7 Resources
This bundle includes all you need to inspire students and to help them aspire to achieving the highest possible marks in the D&T GCSE NEA. Also suitable for AS and A Level. It has tracking, checklists, student guides, an exemplar folder and even a 3D printable outcome to support it.
Cambridge iGCSE tracking and prediction (Updated May 2020)
splinterssplinters

Cambridge iGCSE tracking and prediction (Updated May 2020)

(1)
Update 2: Due to several requests, all the grade boundaries are now unlocked so the document is easier to edit. All relevant links have also been updated. Please re-download the new version. Important update May 2020: The two trackers have been updated to include a suggested time plan for delivering the theory content over 50 lessons and assessing after each unit of work. The specialist material choice could be covered in as little as 24 lessons This replaces the Prep page of the previous version and is far more useful. There is space for the teacher to choose a past paper question for each unit, add in the marks and keep an average of the students’ results. They can also take sample papers and compare these to the formal mock exam. these additions make it a more comprehensive document and all cells that don’t need editing are locked. Fill in the context page with details, use the sheets for Paper 1 and Paper 3 as well as the comments sheet and all will be copied to the Overall sheet for easy analysis and feedback. These two trackers cover the A-E grade based iGCSE and the new 9-1 level based iGCSE in Design and Technology. Simply update the context page and the grade boundaries each year to keep this up-to-date and comprehensive.
AQA AS and A Level Assessment tracker (discontinued)
splinterssplinters

AQA AS and A Level Assessment tracker (discontinued)

(2)
UPDATE 2: This tracker has been updated to support just A Level D&T and has new featres added. This version remains for those still running AS Level D&T or who want access to this particualr version of the tracker. You can still edit the grade boundaries as long as the AS exam is still available. UPDATE1 The May/June 2019 exams have been added so this is up to date and the grade boundaries have also been updated from the results on 15th August 2019. An 8 page spreadsheet which tracks NEA progress and allows for mock and real examination analysis based on the AQA syllabus 7551 and 7552 but it can be adapted for other AO’s. It has been used to successfully predict final grades for many years and is a useful interactive tool to use in the classroom or during progression meetings. It uses a traffic light system to show weaker areas in performance and a look up table to predict final grades and to compare against targets. A Level grade boundaries are not yet known but can be changed as needed. AS level boundaries from 2018 have been added to the AS tab. This currently uses the standard 2/4 module boundaries for grades. This is for the new GCE syllabus with first AS exam in 2018. It has been updated June 2019 to allow up to 26 students on one sheet and looks up student name and number from the information tabs. Cells not needed to be edited are locked off but the password to unlock each sheet is ‘advanced’.
Advanced Level D&T Teachers Kit
splinterssplinters

Advanced Level D&T Teachers Kit

7 Resources
A collection of material designed to help teachers of AQA D&T Product Design although it can be used with a variety of boards and subject specialisms.
Buy your team a coffee!
splinterssplinters

Buy your team a coffee!

(0)
When we all return to school why not celebrate being back with your colleagues by getting a ‘round in’…non-alcoholic of course. This is a slot together system made from 4mm laser ply. It is in Adobe Illustrator format but you can easily use the trial version (if you dont already own or use Illustrator) to get it into a DXF format for other programs such as 2D Design. The logo and text can be changed to suit your school or work. Enjoy a coffee!
Advanced Level Design and Technology Student Guide
splinterssplinters

Advanced Level Design and Technology Student Guide

(0)
This PDF is intended as a guide for Advanced Level students to help them through their NEA tasks in AQA Product Design but much of the guide could be used for other specialisms. While similar in format to the GCSE guide available here, it does have A Level specific material and addresses all the Assessment Objectives for AS and A Level. It is ideal for giving to students in a digital format or as a printed phamplet style booklet to provide an easy to use and understand overview of the NEA.
Wood Joint Practical Resource (build your own kit)
splinterssplinters

Wood Joint Practical Resource (build your own kit)

(0)
This consists of two SketchUp files; one an exploded version and the other a final model with supporting images for you to use as you need. It could be a practical lesson for students or a practical test for a technician or new teacher. Its makes a box of box joints which then fits into a frame of frame joints. It is also useful as an isometric drawing exercise. NOTE: This will only work with the latest version of SketchUp.
KS3 Desk Organiser additional Pages (for use with the Design Booklet Template)
splinterssplinters

KS3 Desk Organiser additional Pages (for use with the Design Booklet Template)

(0)
This is the first set of supporting resources for the Modular Desk Organiser project. Its is in itself a modular approach to teaching a wide range of skills for Design and Technology ay KS3 including aspects of 2D and 3D drawing, CAD modelling, CAM manufacture and rapid protoyping, orthographic projections, materials (Wood, Polymers, Paper and Card), processes, packaging, scales of production and much more. It could provide a whole year’s worth of work or aspects that you want to cover can be taken from it and added to the design booklet template which is available separately. This set also contains maths and science worksheets which can be used for class work or to set as prep/homework. Several approaches can be taken to using this scheme of work and a range of outcomes is possible. Images of real outcomes are provided for reference and a step by step guide to CAD modelling using SketchUp is also available.
SketchUp tutorial for the Modular Desk Organiser
splinterssplinters

SketchUp tutorial for the Modular Desk Organiser

(0)
This is a 52 page printable PDF booklet with a step by step guide to the SketchUp interface and tools with a tutorial for modelling an accurate full scale Modular Desk Organiser. It is intended to support the Design Booklet template and the additional pages for the Modular Desk Organiser but could also be used as a standalone guide to using the software effectively for staff and students. The tutorial covers the basic model but also offers various alternate versions as well as some advanced modelling and rendering tools. Additional supporting files include SketchUp 3D CAD models, texture maps, images and files for 3D printing a component.
KS3 Assessment and tracking based on 9-1 Updated June 2020
splinterssplinters

KS3 Assessment and tracking based on 9-1 Updated June 2020

(0)
UPDATE June 2020: Added additional columns for maths and science scores from the design booklets or your own assessments. All student data is now in a Class info. sheet and copied across to all the other sheets. This is a new Key Stage Assessment based on one, two or three projects per year. The assessment sections correspond to the National curriculum with additional sections for communication and technical skills. Use this with the available KS3 design booklet to assess, track and monitor student progress against their Attainment 8 target through KS3 as well as their knowledge of maths and science in those booklets. You can then use the GCSE tracker if you follow the AQA specification.