# Data tracking

# What are the spreadsheets for?

These are where you can record the scores students achieved on their diagnostics and assessments.

There are two types of trackers:

1) Class Assessment Data These record the scores an individual class is attaining in each of their diagnostic tests and assessments. You may use the first tab to copy your class data from your MIS (e.g. EPortal, Bromcom) They do this using question level analysis so teachers can quickly identify any areas of weakness throughout the whole class and for individual students. They are conditional formatted using red for scores below 50%, yellow for scores between 50% and up to 75%, and green for scores of 75% or above. 2) Whole Cohort Assessment Data These record the scores and determine whether a student is meeting expectations from year 7 to 11. This gives a big picture of how students have been achieving in various units and in different years and can be used for reports, to inform interventions, for progress meetings and parental communication. Start by filling in the cohort data in columns A-L. Teachers should enter their students percentages on each assessment (not diagnostic) into the correct unit and tier. They are conditional formatted using red for scores below 50%, yellow for scores between 50% and up to 75%, and green for scores of 75% or above. In KS3: You need to assign each student a starting point from 1 to 4. This is what will be used to decide if a student is meeting expectations or not. Starting point 1 is for the lowest attaining students from KS2 progressing up to starting point 4 for the highest attaining students. Students receive an "Average points per unit" which determines if they are below, meeting or exceeding expectations. Points for each unit are calculated using their scores in assessments and a multiplier according to which tier they completed. For example, a student completing support tier with a raw percentage score of 50% will score 50 x 1 = 50 points, whereas this on extension tier would be worth 50 x 4 = 200 points. You can fully customise the "point boundaries" for below, meeting and above expectations for each starting point on tab 2. You can also alter the multipliers for each tier on tab 3. Using the current set up, a student with a starting point 1, sitting support tier assessments and achieving 80%, will have an average points per unit of 80 and will be exceeding expectation. However a student with a starting point 4, sitting extension tier assessments and achieving 20%, will have an average points per unit of 80 and will be below expectation. This is because it corresponds to their KS2 scaled score and therefore their KS4 target grade, despite the fact that both students have the same points score. In KS4: Once students reach year 10, they will need to have a KS4 target grade inputted into column M. Students receive an "Average points per unit" which determines the grade they are currently working at. Their current grade will be red if it is below their target grade, yellow if they are meeting it and green if they are exceeding it. Points for each unit are calculated using their scores in assessments and a multiplier according to which tier they completed. For example, a student completing foundation tier with a raw percentage score of 50% will score 50 x 1 = 50 points, whereas this on higher tier would be worth 50 x 4 = 200 points. You can fully customise the "point boundaries" for each grade on tab 2. You can also alter the multipliers for each tier on tab 3. Across all 5 year groups, there are three progress check columns. This is so you can copy and paste what the progress judgement column calculated at three points throughout the year and these can be saved and unaltered by further data inputs throughout the year. N.B: These trackers are available for you to utilise however you wish. You may choose to edit them, not record QLA for diagnostics or at all, or just use the whole cohort trackers. It is complete your decision!