The D&T Repository
The D&T Repository
4.72413793103448380 reviews

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.

pdf, 534.44 KB
xlsx, 165.53 KB

Updated January 2021 with all the AQA theory mapped over 50 lessons with ongoing assessments. Supporting presentations that match the lessons which are now available!
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.
A PDF guide to using the tracker has now been added to the resource.

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.

Get this resource as part of a bundle and save up to 39%

A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.

Bundle

Ultimate D&T GCSE Teacher Toolkit

This is a collection of all my current AQA GCSE Design and Technology resources. It provides everything you need to teach, assess and track the theory content with compulsory units 3.1 and 3.3 and the 3.2 specialist materials covering timbers and woods, paper and boards, metals and alloys and polymers. There is also extensive support for the NEA through an exemplar folder (and 3D printing files), students guides and much more. It represents a saving of over 30% if buying all the resources separately. **Please note textiles will be added at a later date and the price will increase so only buy if you are happy to work without the textiles unit.**

£260.00
Bundle

AQA D&T GCSE teacher toolkit (timbers and wood)

This is a collection of all the current AQA GCSE Design and Technology resources. It provides everything you need to teach, assess and track the theory content but with the 3.2 specialist material focus on timber and wood, as well as extensive support for the NEA. It represents a saving of over 30% if buying all the resources separately.

£175.00
Bundle

AQA D&T GCSE teacher toolkit (paper and boards)

This is a collection of all the current AQA GCSE Design and Technology resources. It provides everything you need to teach, assess and track the theory content but with the 3.2 specialist material focus on paper and boards, as well as extensive support for the NEA. It represents a saving of over 30% if buying all the resource separately.

£175.00
Bundle

AQA D&T GCSE teacher toolkit (metals and alloys)

This is a collection of all the current AQA GCSE Design and Technology resources. It provides everything you need to teach, assess and track the theory content but with the 3.2 specialist material focus on metals and alloys, as well as extensive support for the NEA. It represents a saving of over 30% if buying all the resources separately.

£175.00
Bundle

AQA D&T GCSE teacher toolkit (polymers)

This is a collection of all the current AQA GCSE Design and Technology resources. It provides everything you need to teach, assess and track the theory content but with the 3.2 specialist material focus on polymers, as well as extensive support for the NEA. It represents a saving of over 30% if buying all the resources separately.

£175.00
Bundle

AQA GCSE CompulsoryTheory bundle

This bundle contains units 3.1: Core technical principles and unit 3.3: Designing and making principles. These cover all compulsory knowledge for the GCSE examination with past paper questions which match the sections of the GCSE tracking spreadsheet. Also included are 10 additional 'breakout' lessons should you wish to explore subject matter in more detail. A large format materials revision poster has also been added to the bundle. Lessons for 3.2: Specialist technical principleswill be available to purchase separately so you can choose just the material(s) you intend to focus on.

£115.00
Bundle

GCSE D&T Exemplar Complete Toolkit

Updated (November 2020): A 105 slide presentation has been added to the bundle. This Powerpoint Show presentation is self running but can be edited in Powerpoint. It provides support and visual feedback on the various stages of the NEA and will be a valuable classroom resource. 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.

£38.00

Reviews

5

finance0620

2 months ago
5

Brought as part of a bundle see below I was lucky enough to attend a training day run by Paul and it was obvious instantly that not only does he know his stuff but is also passionate about high quality D&T! If you've not seen Paul's work before - you are in for a treat - all the hard work is done for you, in fact in most cases all you will need to do is enter your kids names and data and away you go - If your experienced or new to teaching the subject or want to instantly improve the quality of resources being given to your students or even want to ensure you are covering the full specification then again the bundles have it covered - and at these prices its cheaper to buy everything than attend a single training day! Cant recommend these resources enough, buy the bundles would be my only advice as they are basically being given away!! Great work seriously the best things I've brought in ages!

mmilbank1984

3 months ago
5

This is the best resource I have ever paid for! Only one thing...the numbers from the 2019 paper (raw marks) don't automatically tansfer on to the summary sheet so I have had to enter them manually??

SARAHJAYNE1988

10 months ago
5

I cannot stress enough how utterly amazing this resource is. This has been the best resource I have ever brought/used for DT. As a HOD of DT it has enabled me to go so in-depth with my data analysis (I thought I was good with data before but this blew me away) and spot areas of concern so much quicker and then action areas for quick gains, which in turn has helped to improve the department results over the past 2 years. I know for a fact it would not have been possible without using this resource to support and track my learners. Even helped my non specialist line managers and SLT understand my thinking and student progress. Thank you!!!!

alec_laing

a year ago
5

Hi there, it looks wicked but its locked... I cannot edit. I don't want to unlock all the formulas etc, but may have to to get the kids names in there and data. Please advise. Al

K3ll5y

a year ago
5

Excellent resource, thank you.<br /> Is it possible to directly copy/paste the NEA comments?

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.

£10.00