This document shows some of the reports and graphs, that you may find it useful to prepare, to show data for cohorts and also for specific groups of children that may be an issue in your school. A quote heard recently from an Ofsted inspector was "it is useful to have prepared your retaliation first!"

Reporting on Progress

To be able to show progress towards targets when only part way through a year, it is useful to create a filtered set of columns from the Tracking Data sheet. You should choose the columns that contain the current assessment, this will be the latest assessment that has fed back from Termly Tracker, and the current year Target column. Do this by clicking the required column headers whilst keeping the ctrl key on the keyboard held down, then go to Filter – Column Filters – Selected Columns. This should leave you with 10 columns of data e.g. Tgt Y2 and TAY2 for 5 subjects - on a year 2 file.

What data does this show?

The Averages in the top row displays an average of the data in the column beneath.

The % at Upper, Middle or Lower level cells show you both the end of year target percentage at each level and the current percentage at each level. Hover the mouse over the cells to see the actual levels represented.

This process allows you to see progress towards targets for the cohort. The information is based on the children on the screen, so it may be useful to filter the children by key groups to compare their progress e.g. boys versus girls, core group versus new arrivals etc. Use the Filter menu - Pupil Filters to use the in-built filter options or use the Filter Wizard, also in the Filter menu, to view the data for any of your own Stored Groups of pupils.

For help creating Stored groups please use the Support Article - Creating Stored Groups of pupils in Primary Target Tracker.

Identifying children at risk of not meeting targets

It is also possible to use this set of filtered columns to identify children most at risk of missing their end of year targets. Click on any of the Teacher Assessment columns and then click on Sort -Range Above/Below target. This will re order the children and provide infomation in column 4 as to who has not met, met or exceeded their end of year target. The child at the top of the list is missing their end of year target by the most sub levels, the child at the bottom has exceeded their target by the most sub levels. For more help with identifying children not making expected progress please use the Support Article - Using Primary Target Tracker to identify children not making expected progress.

Viewing the data in points instead of levels

Ofsted may ask you for data in Average Points rather than levels. To show this first filter the Tracking Data screen to just the columns required as explained above, then click the Points Viewer button. The data from the Tracking Data sheet will be converted to Average Points. it is useful to view this data alongside a print out of the Conversion table which is in the Help - Tables menu of PTT.

For showing progress between KS1 and KS2 the Average Points scale should be used. But for showing progress between other time periods it is useful to switch from Average Points to the 2 Point Scale, using the Toggle Scale button in the Points Viewer. This will then show progress using 2 points for every third of a level. This is not shown using Average Points except for sub levels within Level 2.

Creating Progress Graphs

Another way to show that children are making progress is to prepare Progress Graphs. These can be run to compare the progress of key groups of children. Some examples are Boys versus Girls, the children you have had in school from the beginning versus later arrivals, Non SEN versus SEN, First language = English versus EAL children, children receiving extra support in a subject versus those who are not.

It is useful to give some thought in advance to the types of children Ofsted may ask you about and plan what to graph to show the data to its best advantage.

Please use the Support Article - Using the Graph Wizard in Primary Target Tracker for more help with this process.

Making Good Progress reports

These reports, accessed from the Reports menu in Primary Target Tracker, show the progress children are making from FSP to end of Y1 or Y2 for KS1 children, or progress from KS1 to present for KS2 children.

They are based on Teacher Assessment for Yr 1 to Yr 5 but on Test results for the end of Y6.

The report can be run using data for the end of the previous year or data for the current year. Choosing the Show Current Year option requires there to be teacher assessment data in the current year TA column, this data will probably be feeding back from the Termly Tracker program. If the file is a Y6 file choosing the Current Year option requires there to be Y6 SAT data entered on the tracking data sheet.

The children's names are highlighted according to if they are making slow, expected or good progress, or stuck or regressing. The number or levels progress expected varies according to year group so a colour key is provided in each report. From V11.8 the report also allows the number of sub levels above or below expected progress to be shown.

The report can be expanded to show sub levels by clicking on the Show ABC levels button. When viewing in sub levels the Age Related Expectation colours are also displayed at the top of the columns.

Any children appearing under the Missing Data column will be missing either FSP or KS1 data depending on if they are KS1 or KS2 children.