NFER Tests Suite 2 autumn and summer
Tests for monitoring pupil progress
Helpful new tools to help you with marking and formative next steps
Totalling a child’s score and the scores for the whole class, working out average performance of the class for each assessment focus or attainment target, distinguishing where the gaps in learning are and deciding on next steps in learning can be onerous tasks when faced with a pile of answer booklets.
For both reading and mathematics, NFER has created two sets of free spreadsheets to make the business of marking and collating results easier:
1. Question Grid
This spreadsheet allows you to input the names of all the children who have taken the test and enter the number of marks each child got for each question. The spreadsheet then automatically calculates
Total score per child
Percentage of total marks gained per child
Average mark of the class per question
Difference of the average mark of the class per question compared to the average mark of the sample of children used at standardisation. (This means you can compare how your class performs on each question compared to the ‘national sample’.)
Average mark of the class for each assessment focus in reading or each attainment target in mathematics. (You can use this information to focus activities in class to improve children’s abilities in an area - eg if the class has a low average for AF2 in reading you could do more retrieval exercises in lessons.)
2. Score Converter
Very simply input the names of all the children who have taken the test and enter their date of birth and total score. Input the date of the test and the score converter automatically converts the total marks gained per child into an age standardised score and a national curriculum level. This can be used to compare the child’s performance to other children in the same year group.
How to access the spreadsheets
These spreadsheets can be accessed from our School Portal (/portal) using Login details provided to you along with your ordered tests.
What elements make for an effective and reliable assessment?