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.

Based on the AQA syllabus for GCSE Design and Technology for first teaching from 2017. The spreadsheet contains three sheets; one for the NEA, a mock exam assessment based on the existing theory paper and one based on the sample material supplied by the AQA. By entering assessment criteria for each objective, the spreadsheet will show on overall grade with a traffic light system (red C or below, amber, C to A and Green A or higher). The look up table will then present a grade or level from the overall score. This is based on an existing spreadsheet which has been successful in accurately predicting grades for over 15 years. The grade boundaries can be changed once the subject is live but you can be well prepared in advance with this resource. PLEASE NOTE: This has been replaced with an updated version that provides a more detailed breakdown of marks with comments banks and more assessment potential but this is left here at a reduced price should anyone want a simple spreadsheet to work with.