A gap analysis tool that will work for any 1-9 assessment. It is an open spread sheet. No password so editing to your needs possible. Set to analysis a year run, but can be used for one class, of foundation and higher assessments by question. It calculates grades based on your assessment grade boundaries and progress based on a editable flight path model. Just state what year and term. It also completes a full analysis of grades and cohort analysis. such as gender and PP vs non PP It is linked to a mail merge template which then generates a feed back sheet per pupil to analyse their grades and gives feedback on progress and target.

This resource is mainly aimed at staff with responsibilities of staff and their own CPD. It includes a PowerPoint explaining the concept to staff which can be gone through in a faculty/department training session. There is then a questionnaire for staff to appraise themselves on their training needs and strengths. This is then collated into a spreadsheet to analyse the training needs and strengths of the faculty. It will highlight staff willing to complete training, which requires it and whether weaknesses are highlighted and outside agencies are needed. This analyse can then be printed A3 for the faculty to review. It also highlights who staff should talk to when they need support in certain areas. The main areas of the questionnaire are teaching and learning, ICT skills, subject knowledge and curriculum knowledge. This was originally set up for a science faculty but easily modified to cater for any subject and any areas. The spreadsheet is unlocked and editable.

Tired of spending time grouping your pupils by ability or for support. Want to group by literacy or numeracy. Feed up of the same pupils answering questions. Don't wont to waste time with the named lolly sticks random approach. Then this quick to set up, even quicker to use tool is for you. A whole school, non-subject specific tool designed to use a list of pupil names with linking subject, literacy and numeracy data as a teaching aid. Once the data is pasted in, which is a few minutes of work, then all tasks are completed for you by clicking built in buttons within the spreadsheet. The two main features are: Data related selection and grouping Random selection of single or grouped pupils. The main purpose of the use of random selection is to keep pupil focus as it removes choice from the teacher. Selecting which task you want is as easy as selecting the right tab at the bottom and then clicking the required buttons. It’s that simple. It will sort into differentiated groups of similar abilities based on either subject data, literacy data or numeracy data, with an included feature of randomly selecting these groups for feedback or other tasks. Refresh to arrange by a different choice. It will also arrange by groups with ranged abilities for peer support work, again on subject, literacy or numeracy with a random group selector option as well. It will randomly select a single pupil from a class list to keep pupils focussed and on task. It will also randomly group your class into groups from 2-10 based on your selection. It has a random number selector where you can select the min and max values if you wish to randomly select values to use. You may have numbered groups and then this will select which group answers. This is designed to be an all-round supportive teaching aid for you to be able to very easily and quickly differentiate, peer support and randomise your classes. Easily copied and pasted into PowerPoint to display groups to pupils with no raw data in view. Good for seating plans and ready to use instantly for your classes once data is in. Update your data termly to keep grouping relevant to your teaching needs. A set of MOCK data has been left in the document so that you can see how it should work upon download. Replace with your groups and off you go.

A set of documents for either a 3 year or 2 year GCSE course. This will generate large tracking labels that can be stuck to the front of a folder or book. All you have to do is paste in names, class, subject and target and the rest is done for you. This will work for 200+ pupils but can just be done for a single class. Each label is half an A4 so you get two to a sheet. It will present as a table that shows termly expected data leading to the pupils target over the full course. This can then be filled in each term to record their actual working at grade. From this progress can be calculated each term. This enables pupils to know where they should be and when they are slipping behind. It all requires is some pasting, mail merge and then print. Easy.

11 easy and quick to use templates that can be added to any PowerPoint to start a lesson. I have included examples of how they are used as well. The main focus is on literacy and numeracy through the use of key words which can be used as an intro into a lessons or a review of the last one.