Hero image

The D&T Repository

With over 26 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.

33Uploads

23k+Views

3k+Downloads

With over 26 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.
AQA Design and Technology GCSE 9-1 Assessment and Tracker (with comment banks) UPDATED for 2020!
splinterssplinters

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

(4)
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. 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. 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 2019 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.
AQA A Level tracking with lesson plans and ongoing assessment data
splinterssplinters

AQA A Level tracking with lesson plans and ongoing assessment data

(0)
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 tab, all the relevant data will be copied to the corresponding tabs. 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 content spread over 50 weeks 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 tab. 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’.
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.
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 August 2018]
splinterssplinters

AQA Exemplar D&T Folder for the new GCSE [Updated August 2018]

(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. 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. This is a PDF file and there are 40 slides in the folder, 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 60 slides here but the extra slides are the 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 have worked for the AQA for 20 years with 25 years D&T teaching and leadership experience where many students achieved 100% for their coursework so 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 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.
Advanced DT Teachers Kit
splinterssplinters

Advanced DT Teachers Kit

6 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.
KS3 Assessment and tracking based on 9-1
splinterssplinters

KS3 Assessment and tracking based on 9-1

(0)
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 forthcoming KS3 design booklet to assess, track and monitor student progress against their Attainment 8 target through KS3. You can then use the GCSE tracker if you follow the AQA specification (other exam boards will be added at a later date)
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.
AQA AS and A Level Assessment tracker with predictions 2019 onwards
splinterssplinters

AQA AS and A Level Assessment tracker with predictions 2019 onwards

(1)
UPDATE 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’.
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.
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.
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.
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.
KS3 Modular Desk Organiser Bundle
splinterssplinters

KS3 Modular Desk Organiser Bundle

3 Resources
This bundle includes the basic design booklet template, the tracking spreadsheet and the additional sheets to support the modular desk organiser project which covers a wide range of skills, techniques and processes.
KS2/3 design booklet template
splinterssplinters

KS2/3 design booklet template

(0)
This booklet is supplied in Powerpoint format and contains a range of generic sheets which can be used to produce unique design booklets for students rather than providing them with numerous blank paper or worksheet. The advantage of using booklets, aside from keeping the worksheets together, is that students take responsibility for their work and can personalise the projects. Use this with the Key Stage 3 tracking spreadsheet available separately as a way of planning and monitoring progress throughout Key Stage 3 and the booklets will form a record of learning at the end of the Key Stage. This is a generic booklet but many of the text areas are editable so you can customise it to suit your needs. A range of more specific sheets will be made available in packs so you can have a ready made scheme of work or mix and match the sheets to make a scheme of work unique to your department. PLEASE NOTE: this version is just the design booklet template and does not have the assessment tracking sheet bundled with it.
Cambridge iGCSE tracking and prediction
splinterssplinters

Cambridge iGCSE tracking and prediction

(0)
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.
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.
GCSE Feedback Sheet
splinterssplinters

GCSE Feedback Sheet

(1)
A free resource for adding feedback to students for practical work/controlled assessment/NEA. It is in a digital format so it can be added to a VLE or online storage for access by student and teacher. The teacher completes the blue and green sections while the student completes the pink section.
Design and Technology New A level AO comparison poster
splinterssplinters

Design and Technology New A level AO comparison poster

(1)
Two large format sheets comparing the requirements of the new A Levels in Design and Technology (Product Design). Additionally a large SWOT sheet to aid discussions regarding which route to take. These were produced for a DATA presentation in 2016