Updated August 2023 with the official summer 2023 grade boundaries. The 2023 paper is now transferred to the summary sheet as the mock examination results. The 2022 paper is now used for the end of theory assessments.
Slight changes to the colour schemes to match the theory pre
Updated August 2022 with the official summer 2022 grade boundaries. The 2021 paper is now transferred to the summary sheet as the mock examination results.
Update December 2021 with the 2020 and 2021 exam papers. The 2020 paper is now used as the mock and the 2019 is used to test the end of all the 50 individual theory lessons.
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 the two AQA specimen papers for reference and the 2019 GCSE paper to use as a final test after the theory lessons. The 2020 examination paper is used as a mock exam 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 2021.
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 2020 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 45%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Bundle
AQA D&T GCSE teacher toolkit (textiles)
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 textiles, as well as extensive support for the NEA. It represents a saving of over 30% if buying all the resources separately.
£175.00
Bundle
Ultimate D&T GCSE Teacher Toolkit
This is a collection of all 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, polymers and textiles. There is also extensive support for the NEA through an exemplar folder (and 3D printing files), students guides and much more. The full set of of digital/printable workbooks have recently been added to the bundle at no extra cost. It represents a saving of almost 40% if buying all the resources separately.
£270.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 (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 (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 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 GCSE CompulsoryTheory bundle
UPDATE: Workbooks are now added to the 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.
£120.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
Something went wrong, please try again later.
Bargain! An amazing resource. Loads of content that you can easily edit to suit your needs. Good and good quality images. Perfect for either teaching or revision . This resource has saved me so much time. Much better that resources from the big providers I have purchased from.
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!
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??
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!!!!
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
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.
£12.00