Okay, so you’ve got a class of pupils who have completed the 2018 Key Stage 2 paper, and you’ve thought about trying out our RAG system with video support.  You might even have shared this with parents and told them about the single entry system.  But what you really want is to take the data for a class, generate personalised feedback, summarise strengths alongside areas for development AND inform the actions that you are going to take next.

Welcome to our Question Level Analysis tool!

Open the spreadsheet and look along the bottom: there are 7 tabs.  The first tab is for paper 1 data entry.  Pupil numbers are across the top row, and question numbers are in the first column.  You will need to enter pupil names in the second row, directly under the student reference number.  Then, enter the question scores for each pupil into each cell.  Repeat for paper 2 and paper 3.

These three individual sheets allow an ‘at a glance’ overview of the performance of the whole class or whole cohort.  Reading across each line gives a picture of the class performance in each question and can inform actions you might wish to take with the class as a whole; for example, if ‘find a fraction of a quantity’ was not answered strongly overall you could use lesson time to carry out further teaching on this skill.  Once these sheets are complete the content can also be copied and pasted for use in the multiple upload to produce RAG papers for pupils.

Before progressing to the next stage of using the tool you will probably want to check that the same reference number has been used for each pupil across the three papers.  The fourth tab (CHECK Student Refs are the same) allows you to do this with a quick visual check.

The fifth tab is the SINGLE Student Analysis sheet.  The default is that pupil #1 has their results summarised in three printable tables.  This displays their individual strengths and areas for development.  Entering another pupil’s reference number into cell D1 will automatically pull their scores onto the sheet.

In our experience pupils, parents and teachers find this information incredibly helpful and informative.  Alongside the fact that it allows the RAG multiple entry to be carried out and alternative papers provided, we think it is well worth the time invested.

The sixth tab provides a blank analysis sheet, and the seventh provides the scaled score conversion table – just in case you need either.