Help section

Click on the blue headings to reveal the text underneath; click the heading again to hide the text. Within texts, click on any blue highlighted phrases to reveal further details and click the phrase again to hide the details.

Getting started

Installing the toolkit

Run the installation file which you have received (e.g. Install 2010 toolkit for Your Schoolname.exe) following the installation instructions which came with it. These instructions also include the passwords which you need to enter the toolkit and to enter or edit data in the toolkit.

On completion of the installation you should get a page with instructions to check that Excel has Security set to medium. It is essential to do this before you run the toolkit. If this page does not load, start Excel and click the menu items Tools, then Macro, then Security and make sure that 'Medium' is selected. Exit Excel and then start the toolkit. When you start the toolkit, you must click 'Enable macros' for the toolkit to run.

Where can you use the toolkit?

You can install the toolkit on a network, but it must have access to the appropriate version of Excel (e.g. Excel 2003 or Excel 2007) and it must be on a drive or in a folder which has read/write privileges: only one user at a time can use the write facilities but multiple users can interrogate the data and print out results.

You control who can have access to the toolkit via the entry password and who can actually use the write privileges i.e. add or change the data, via the separate data password.

You can also install the toolkit on any computer which has access to the appropriate version of Excel and you can also run it from a USB memory stick as long as the host computer has access to the appropriate version of Excel.

You need to nominate one copy of the toolkit as the master version, which is the one which you keep up to date, then other copies can be made from that master version.

How do you make copies of the toolkit?

The best way to do this is to use this button on the main menu page:

1907

When you click on the copy your toolkit files button, you get this selection box:

copy files selection box

Using this selection box you can copy either the whole toolkit or just your own data file. If you have been working away from the master version, and you 1827 master version, but this needs to be carefully used because you will overwrite the existing data file with your new one.

Toolkit folders

When you run the installation file, it will create a folder called 'Primary Progress toolkit 2010' and you can control where this is created. You need to remember or make a note of where this folder is located, because you will need to access some of the sub-folders from time to time. This is the structure of sub-folders under the main toolkit folder.

Toolkit foòder structure

The two folders which you are most likely to need are:

'toolkit BACK-UPS' which is the folder in which Back-ups of your school's DATA file will be stored.

'toolkit UPDATES' which is the folder in which you need to save any Updates which we send you.

Getting help

In addition to this User's Guide, there are 'How to use' buttons on every page which provide help with that particular page.

On the main menu page, these two buttons give access to a short guide to navigating the toolkit and our email and telephone numbers so that you can email or phone if you are having problems and need help.

help buttons

Finding your way around the toolkit

Navigation

When you first start using the toolkit, click the 'How to use the toolkit' button on the main menu page

how to use toolkit button

and read through the brief guide to using the toolkit, which illustrates the key features and explains how to select the main options. Within the toolkit itself, specific help is available for each option via a 'How to use ?' button in the top right corner of each worksheet.

how to use page button

The main menu

 When you start the toolkit you need to enable macros and enter the password which came with your installation, then you will see the Main Menu, (your school name will replace Zoo Gardens):

The toolkit main menu

Hover the cursor over any of the solid colour options and when the cursor changes to a hand pointer you can click and select that option.

Using the menu - an example

Click the first item on the main menu,

Entering data

and you will see a sub-menu with all the main options for entering, editing or deleting data.

main data menu

Click on any of these options and you will be presented with a sub-menu containing all the facilities under that option.

For instance, if you click on Pupil details, you get this sub-menu:

pupil details sub-menu

The two bottom items allow you to go back either to the main menu or back to the data menu.

All the menu options work in the same way: try some of them out and you should quickly get a feel for the navigation.

Main menu buttons

On the main menu page, these buttons give quick access to various useful features:

help buttons

- these two buttons give access to a short guide to navigating the toolkit and our email and telephone numbers so that you can email or phone if you are having problems and need help.

what data button

- this provides access to an overview of all the data which is stored in your toolkit.

backup button

- use this button to backup or restore your school's data quickly and easily.

copy toolkit button

- use this button to copy either the whole toolkit or just your own data file to another computer or to a USB memory stick.

install updates button

- use this button to install any updates to the toolkit which we may have sent you.

Tracking pupil progress and attainment

Introduction

The options for tracking pupil progress and attainment are mainly organised by phase, EYFS, KS1 and KS2. There are also options to track reading and spelling ages and to view the school as a whole. You can track pupils' progress, yearly or termly, against either National Standards or the targets which you have set. You can also analyse pupils' FSP, KS1 and KS2 results and your school's performance against National summary results.

Pupil progress and attainment can be viewed by year group, class, set, or by sub-groups such as Gender, Ethnicity, FSM, SEN, birthdate, first language, time at school etc. On any display, where you see this button

select groups button

clicking on Select Group of pupils will display this box where you can make your selection:

group choices

Early Years Foundation Stage

This is the EYFS section of the main menu: you will see that there are two options for tracking pupils, by using FSP points or the Development matters grid.

EYFS main menu options

When you click on 'EYFS progress using FSP points' you get a further sub-menu with these options:

EYFS - FSP points option

Click this link Show attainment against expected progress for an explanation of this option (the How to use button on each page gives more detailed information):

Use this to review the FSP points scores from Nursery up to Reception FSP, for a year group/class and to track individual pupil's scores against the Early Learning Goals. You can use the 'GROUP' button to list only certain pupils, for example, those pupils starting in September or January. The FSP points can also be highlighted, in green, orange and red, to indicate results above/equal/below Early Learning Goals. The percentage of pupils achieving each of these goals is shown at the top of the table.

You can see a 'Pupil graph' display via the button at the top of the window. The Pupil graph plots a bar chart for a single pupil, against a line graph for the year, class or group and lets you plot a second (earlier) set of results on the graph to compare progress. By default, the results are plotted as a bar graph but you can change to a 'Radar chart' by clicking the button in the left-hand panel.

Click this link Tracker grid – show progress over time for an explanation of this option:

Use this to display an EYFS Tracking grid, which shows Nursery/Reception results and progress over time. The grid rows show the Level achieved (0-9) and the columns can display up to 6 sets of results (e.g. terms). There is an additional column, indicating overall progress, at the right-hand side of the grid.

Pupil progress is highlighted, in the default scheme, using green to show improvement in the level achieved, orange staying the same and red a decline. There is also a 'Highlight progress' button which allows you to define your own overall progress criteria, in which case the pupils are highlighted in bright yellow.

Click this link Calculate percentages at each level for an explanation of this option:

Use this to calculate the percentages of pupils achieving each level (0-9), for each term assessed, including the final FSP profile. The percentages of pupils at each level are shown in a table at the top of the screen, with a table of individual pupil results below. The last column of the pupil table displays the TOTAL score and the column heading also includes the percentage of pupils exceeding a given TOTAL which you can set. You can also set different ranges (the defaults are 0-3, 4-8, 9 and SIX or more) when summarising the points scores.

Click this link Calculate progress between periods for an explanation of this option:

Use this to calculate the numbers or percentages of pupils progressing from one result to another, for example, from Nursery September to Reception Summer (FSP), in any individual Foundation Stage subject or averages for PSE, CLL, PSRN, plus the average points gained. You can specify which two results to calculate the progress between.

Progress is displayed on a grid, with the grid ROWS showing the level achieved at the 'FROM' (earlier) result and the COLUMNS showing the 'TO' (later) result. So, for example, reading across from row '2' to column '5' will give the number of pupils progressing from Level 2 to 5.

By default, the grid shows the number of pupils, but you can use the display controls at the top of the grid to display percentages instead. You can also highlight progress, using green-orange-red to indicate progress or not or yellow to highlight progress by a given number of points.

A 'Pupil progress' button allows you to switch to a table displaying the individual pupils and their results & progress.

Click this link Compare school FSP percentages against National results for an explanation of this option:

Use the tables and graphs in this option to compare your school's Foundation Stage Profile with the national results for all schools. You can choose to compare the percentage of pupils achieving 6 points or above, and the percentage of pupils achieving Early Learning Goals.

When viewing a table, you can click on the 'Graph' button to switch to a graphical display, and likewise, when viewing a graph, you can click on the 'Table' button to return to that view.

When you click on 'EYFS progress using Development Matters grid' you get a further sub-menu with these options:

EYFS - Development matters option

Click this link Show attainment against chronological age for an explanation of this option (theHow to use button on each page gives more detailed information):

Use this to review the Development Matters Profiles from Nursery up toReception, for a year group/class and to track individual pupil's results (asmonth ranges) against their chronological ages. You can use the 'GROUP' button to list only certain pupils, for example, those pupils starting in September or January.

The month ranges can also be highlighted, in green, orange and red, to indicate results above/equal/below chronological ages. The percentage of pupils achieving these results is shown at the top of the table..

You can see a 'Pupil graph' display via the button at the top of the window.The Pupil graph plots a bar chart for a single pupil, against a line graph forthe year, class or group and lets you plot a second (earlier) set of results onthe graph to compare progress. By default, the results are plotted as a bargraph but you can change to a 'Radar chart' by clicking the button in theleft-hand panel.

Click this link Tracker grid– show progress over time for an explanation of this option:

Use this to display a Development Matters Tracking grid, which showsNursery/Reception results and progress over time. The grid rows show the Level achieved (in monthly age ranges) and the columns can display up to 6 sets of results (e.g. terms). There is an additional column, indicating overallprogress, at the right-hand side of the grid.

Pupil progress is calculated in months and is highlighted, in the default scheme, using green to show improvement in the level achieved, orange staying the same and red a decline. There is also a 'Highlight progress' button which allows you to define your own overall progress criteria, in which case the pupils are highlighted in bright yellow.

Click this link Calculate percentages at each level for an explanation of this option:

Use this to calculate the percentages of pupils achieving each level (using the monthly age ranges), for each term assessed. The percentages of pupils at each level are shown in a table at the top of the screen, with a table of individual pupil results below. The last column of the pupil table displays the percentage of pupils above (or below) a particular level, which you can set.

Click this link Calculate progress between periods for an explanation of this option:

Use this to calculate the numbers or percentages of pupils progressing from one result to another, for example, from Nursery September to Nursery Summer,in any individual Development Matters subject, plus the average change in months. You can specify which two results to calculate the progress between.

Progress is displayed on a grid, with the grid ROWS showing the level achieved at the 'FROM' (earlier) result and the COLUMNS showing the 'TO'(later) result. So, for example, reading across from row '16-26' to column'30-50' will give the number of pupils progressing from 16-26 months to 30-50months.

By default, the grid shows the number of pupils, but you can use the display controls at the top of the grid to display percentages instead. You can also highlight progress, using green-orange-red to indicate progress or not or yellow to highlight progress by a given number of months.

A 'Pupil progress' button allows you to switch to a table displaying the individual pupils and their results & progress.

KS1 and KS2

These are the KS1 and Ks2 sections of the main menu. You will see that both are organised in the same way, into three sections. The first compares progress against National Standards, which we call Standard Progress (for an explanation of this term see below), the second compares progress against the targets you set and the third allows you to predict or analyse Key Stage results.

•Standard Progress - at KS2 this is two levels or 12 points; from Reception to KS1 we convert FSP points, P scales and NC levels all to NC points and measure progress in NC points. If you would like to download a fuller explanation, click here.

KS1 and KS2 main menu

When you click the heading Progress against National Standards, at either KS1 or KS2 you get a sub-menu. The choices are almost the same at KS1 and KS2 and are listed together below. Differences between the two stages are highlighted in the text.

Click this link Pupil Progress – core subjects - yearly for an explanation of this option (the How to use button on each page gives more detailed information):

Use this option to display the attainment and yearly progress for an individual pupil across all the core subjects together. At KS1, attainment is shown at the top of the table in FSP points, P scales and NC levels, while progress is shown in NC points at the bottom of the screen. At KS2, attainment is shown in NC levels for both Tests and Teacher Assessments, while progress is calculated in NC points.

You can use the 'GROUP' button in the left-hand panel to list only certain pupils, for example, those pupils receiving Free School Meals (FSM). By default, the results are shown in table form, with colour-coding used to compare the pupil's attainment against the 'Expected level' and 'Standard Progress'.

In years 1 and 2, the expected progress is 6 points, in years 3 to 6 it is 3 points You can use the 'Progress measure' button in the left hand panel to specify a different rate of 'School Progress'.

Clicking on the 'Graph' button will switch to a graphical display. You can choose which subjects to display on the graph, and whether to include the 'Expected Level' line. Click on the 'Table' button to return to the table display.

Click this link Year/Class Progress – core subjects - yearly for an explanation of this option

Use this option to assess the performance of a year group or class. The display is the same as for an individual pupil (see above), except that, clicking on the 'Year/Class details' button provides an overview, such as the numbers of boys and girls, and their FSM and SEN status.

Note that the average progress, between years, may NOT equal the average points for one year minus those at the prior year. Progress is calculated only for pupils with both results, so will not include any leavers/joiners in the progress period. You can change the table display to show the percentages of pupils at or above the expected level.

Click this link Results by Subject – any subject – yearly or termly for an explanation of this option

Use this option to view and compare results against the 'Standard Progress' measure (expected level) for pupils over their school career. Data columns are provided in blocks from Rec Entry to FSP, FSP (or Year 1) to KS1, and KS1 to KS2. All blocks or just a single block can be shown, as well as Termly data if available. (Columns are hidden if there are no results.)

The table display shows Teacher Assessments, Test results and Standard Progress (as levels) for each pupil. You can also use the 'GROUP' button in the left-hand panel to list only certain pupils, for example, pupils receiving Free School Meals (FSM).

The table rows can be sorted by pupil name, or by any of the columns of data. (The '... Difference' options sort by the difference between the result achieved and expected progress, with pupils exceeding expectation sorted to the top of the list.)

When termly data is available you can choose to display columns for Autumn and Spring, in addition to Summer. Highlighting is also available to indicate pupil results above, equal to and below the expected progress measure.

The 'Graph' button at the top of the window provides both an individual Pupil graph, plots attainment on the left and annual progress on the right, while the Year/Class graph plots the average points for the whole class.

Click this link All results for one pupil – any subject – yearly or termly for an explanation of this option

Use this option to display the results in all subjects for an individual pupil. The pupil's Test Results and Teacher Assessments (controlled via the 'Test/TA' button in the left-hand panel) from Reception Entry to Year 6 (KS2) are shown (as Levels). Termly results are shown if available.

By default, the results are shown in table form, with colour-coding used to compare the pupil's results against their 'Subject Standard/School Progress measures'. (This measure is calculated separately for each subject, using Entry and FSP, Year 1 and KS1 Summer levels as baselines, then adding points to this score for each subsequent year at school.)

Clicking on the 'Graph' button will switch to a graphical display where you can choose which subjects to display on the graph.

Click this link Subject Tracker – Reception - progress over time (KS1 only) for an explanation of this option

Use this option to display an EYFS Tracking grid, which shows Nursery/Reception results and progress (as FS Levels). The grid rows show the Level achieved, with a separate column displayed for each set of Results. An additional column indicating overall progress is provided at the right-hand side of the grid.

By default, a 'PUPIL grid' is shown, with the individual pupil names displayed in the grid cells. Click on the 'TOTALs grid' button in the left-hand panel to switch the display to the number of pupils achieving each Level.

The 'GROUP' button in the panel lets you highlight certain pupils, for example, those pupils entering school in September or January.

Pupil progress can be highlighted, in the default scheme green is used to indicate an improvement in the level achieved, orange staying the same and red a decline. However, you can use the 'Highlight progress' button in the panel to define your own overall progress criteria, in which case the pupils are highlighted in bright yellow.

Click this link Termly or Yearly Subject Trackers - progress over time for an explanation of this option

Use this option to display Tracking grids, which show yearly or termly results (as Levels) and progress (NC Points). The grid rows show the Level achieved, with a separate column displayed for each set of termly Results. If end of year (Summer) results are known for both last year and this year then an additional column indicating overall progress in the year is shown at the right-hand side of the grid.

By default, a 'PUPIL grid' is shown, with the individual pupil names displayed in the grid cells. Click on the 'TOTALs grid' button in the left-hand panel to switch the display to the number of pupils achieving each Level.

The 'GROUP' button in the panel lets you highlight certain pupils, for example, those pupils receiving Free School Meals (FSM). The 'Test / TA' button specifies which results to use in the grid.

Pupil progress can be highlighted, in the default scheme green is used to indicate an improvement in the level achieved, orange staying the same and red a decline. However, you can use the 'Highlight progress' button in the panel to define your own overall progress criteria, in which case the pupils are highlighted in bright yellow.

Click this link Progress grid – any subject – between any two results for an explanation of this option

Use this option to calculate the numbers or percentages of pupils progressing from one result to another, for example, from Y3 to Y4, in a particular subject.

When you click the 'Calculate Progress' button, you can specify which two results to calculate the progress between. Progress is displayed on a grid, with the grid ROWS showing the level achieved at the 'FROM' (earlier) result and the COLUMNS showing the 'TO' (later) result.

By default, the grid shows the number of pupils, but you can use the display controls at the top of the grid to display percentages instead.

You can also colour-code the grid cells red-orange-green to indicate progress or not, or use the 'Highlight progress' button in the left-hand toolkit panel, to highlight progress by a given number of points.

The 'Pupil progress' button switches to a table displaying the individual pupils and their results & progress.

Click this link Graph Optional SATs marks against KS1 APS (KS2 only) for an explanation of this option

You need to have entered Optional SATs marks to use this option. This 'value added' line graph plots the performance of pupils at a given year (subject mark) against that at Key Stage 1 (average points score).

You can choose to plot for all pupils, or just boys or girls. You can also label the data points with the pupils' names and compare the pupils against national results by displaying lines for the national quartiles (lower, median and upper) and levels.

By default, the KS1 axis limits are set from 3 to 21 and the 'Year' axis limits from 0 to the maximum mark - you can fix different scales if you wish.

Clicking on the 'Pupils & Marks' button displays a list of the KS1 and Year results for the pupils plotted on the graph. The list can be arranged in alphabetic order, or by KS1 score, Year mark, or 'Group' membership (once a group has been selected).

The 'Group' option in the left-hand panel can be used to highlight a particular group of pupils on the graph, for example, those pupils receiving Free School Meals (FSM).

When you click the heading Progress against Target levels you have set, at either KS1 or KS2 you get a sub-menu. The choices are almost the same at KS1 and KS2 and are listed together below. Differences between the two stages are highlighted in the text.

Click this link Targets by subject – any subject – yearly or termly for an explanation of this option (theHow to use button on each page gives more detailedinformation):

Use this option to view and compare the Targets and Results for pupils over their school career. Data columns are provided for Years 1 to 6, and, if entered, for termly data. The table shows the Targets, Teacher Assessments and Test results (as levels) for each pupil.

You can also use the 'GROUP' button in the left-hand panel to list only certain pupils, for example, those pupils receiving Free School Meals (FSM).

The table rows can be sorted by pupil name, or by any of the columns of data. (The options 'TA / Target' and 'Test / Target' sort by the difference between the result achieved and target, with pupils above their target sorted to the top of the list).

When termly data is available you can choose to display columns for Autumn and Spring, in addition to Summer.

Highlighting is also available to compare results with targets and the '% at Level' button provides a summary of the levels in the data columns for a chosen date.

Use the 'Graph' button at the top of the window to show an individual Pupil graph, which plots the targets and assessments (TAs & Test results) for a single pupil, or a Year/Class graph, which plots the averages for the whole class.

Click this link All targets for one pupil – any subject – yearly or termly for an explanation of this option

Use this option to display the targets and results in all subjects for an individual pupil. The pupil's Targets and Test results/Teacher Assessments (controlled via the 'Test or TA?' button in the left-hand panel) from Year 1 to Year 6 (KS2) are shown (as Levels).

Termly results are shown if available. You can also use the 'GROUP' button in the left-hand panel to list only certain pupils, for example, those pupils receiving Free School Meals (FSM).

By default, the targets and results are shown in table form, with colour-coding used to compare the pupil's results against their corresponding target.

Clicking on the 'Graph' button will switch to a graphical display where you can choose which subjects to display on the graph.

Click this link Termly Target Tracker – any subject for an explanation of this option

Use this option to display Tracking grids, which show termly targets and results (as Levels). Where they differ, the difference between them is also shown (in NC Points). The grid rows show the Level achieved, with separate columns displayed for each set of termly Targets and Results.

The 'GROUP' button in the panel lets you highlight certain pupils, for example, those pupils receiving Free School Meals (FSM). The 'Test / TA' button specifies which results to use in the grid.

Pupil results can be highlighted: in the default scheme green is used to indicate a result above target, orange a result equal to target and red a result below target. However, you can use the 'Highlight' button in the panel to define your own result / target criteria, in which case the pupils are highlighted in bright yellow.

Click this link End of year Target Tracker – any subject for an explanation of this option

Use this option to display Tracking grids, which show end of year targets and results (as Levels). Where they differ, the difference between them is also shown (in NC Points). The grid rows show the Level achieved, with separate columns displayed for each set of Targets and Results.

The 'GROUP' button in the panel lets you highlight certain pupils, for example, those pupils receiving Free School Meals (FSM). The 'Test / TA' button specifies which results to use in the grid.

Pupil results can be highlighted: in the default scheme green is used to indicate a result above target, orange a result equal to target and red a result below target. However, you can use the 'Highlight' button in the panel to define your own result / target criteria, in which case the pupils are highlighted in bright yellow.

Click this link Target grid – any subject – progress towards any target for an explanation of this option

Use this option to calculate the numbers or percentages of pupils with results above, equal to or below their target in a particular subject.

Click the 'Calculate Result / Target' button, in order to specify which result and target to calculate the difference between. Note, the result and target need NOT be for the same date, for example, you can view Spring TAs against end of year (Summer) targets to see how pupils are progressing towards their target.

The difference, Result - Target, is displayed on a grid, with the grid ROWS showing the RESULT level and the COLUMNS showing the TARGET.

By default, the grid shows the number of pupils, but you can use the display controls at the top of the grid to display percentages instead.

You can also tick the 'Highlight Res / Targ' box to colour-code the grid cells red-orange-green to indicate meeting the target or not. Further highlighting options are available via the 'Highlight' button in the left-hand toolkit panel, which allow you to highlight the result / target difference by a given number of points.

The 'Test / TA' button in the panel specifies which results to use in the progress calculations and the 'Pupil targets' button switches to a table displaying the individual pupils and their result & target.

Click this link ISP style Tracker – on track for Levels 4 and 5 at KS2 for an explanation of this option

Use this option to display ISP Tracking grids, which use current performance to identify pupils who are on track for Level 4 and Level 5 at KS2, or could potentially reach Level 4, with help. The grid rows show the Level achieved, with a separate column displayed for each set of termly Targets and Results. The grid cells are colour-coded ~ green on Track for Level 5, orange on Track for Level 4 and red potential Level 4.

By default, a 'PUPIL grid' is shown, with the individual pupil names displayed in the grid cells. Click on the 'TOTALs grid' button in the left-hand panel to switch the display to the number of pupils achieving each Level.

The 'GROUP' button in the panel lets you highlight certain pupils, for example, those pupils receiving Free School Meals (FSM) while the 'ISP grid' button is used to construct your own grid, by defining the 'On Track' and 'Potential' Levels. The 'Test / TA' button specifies which results to use in the grid.

The summary rows at the top of the grid show the number of pupils followed by the percentage of the Year / Class / Group they represent. However, please note that the percentages on the 'Level 4' rows are the overall percentage of pupils at Level 4+ (Level 4 and above).

Click this link KS2 Targets, Forecasts, Results and 2-levels progress for an explanation of this option

Use this option to review the KS2 targets, forecasts and results for a year group / class (in Y3, Y4, Y5 or 6) and to check their progress towards the agreed School KS2 targets or Fischer Family Trust forecasts if available.

The table shows the targets, forecasts and results (as levels) for each pupil, for English, Mathematics and Science. You can use the buttons in the left-hand panel: 'GROUP' to list only certain pupils; 'CHANGE forecast' to specify which Fischer forecast (A B C D) to use; 'Level 4+ Level 5 / 2-Levels progress ' to switch between table displays. Level 4+/Level 5: The combined level for 'English & Maths' is obtained by taking the lower of the pupil's individual English and Mathematics levels.

The table rows can be sorted by pupil name, or by any of the columns of data. In addition, you can sort on the difference between two columns, for example, sorting by 'English ~ Result / target' will put the pupils whose English results exceed their target at the top.

Highlighting options use colour-coding to indicate column differences and pupils at a particular level. Note that targets and forecasts of the form Level 4A/4B/4C or 5A/5B/5C are taken as Level 4 or 5 for comparison with results. Also, Fischer Family Trust forecasts are rounded down for comparisons and calculations, for example, 4.8 = Level 4.

2-Levels progress: progress from KS1 to KS2 (in whole levels) for each subject is shown in the columns next to the KS2 targets, forecasts and results. The table rows can be sorted by pupil name, or by any of the columns of data.

Highlighting options use colour-coding to indicate pupils making < 2, 2 and>2 levels progress. Note that targets and forecasts of the form Level 4A/4B/4C or 5A/5B/5C are taken as Level 4 or 5 when calculating progress. Also, Fischer Family Trust forecasts are rounded down, for example, 4.8 = Level 4.

Click this link Compare School KS2 results with Targets & Forecasts for an explanation of this option

Use the tables and graphs in this option to compare your school's agreed KS2 targets with both your KS2 results (achieved over the last three years) and KS2 forecasts (for the next two years). You can choose to display all three targets (percentage of pupils achieving Level 4+, Level 5+, 2-Levels progress) for a single year or five-year trends for each target separately.

A range of KS2 forecasts are provided from RAISEonline and, if available, Fischer Family Trust forecasts too.

The tables are arranged by subject, with the result or forecast at the top, then the target immediately below, followed by the difference between them. You can choose to highlight these differences, using different colours.

The graphs for a single year are displayed as bar charts, while a line graph and combined line/bar chart are provided for the five-year trends.

When you click the heading Predict or analyse KS1 results, you get a further sub-menu with these options:

Click this link Predict KS1 Results using prior assessments or targets for an explanation of this option

Use this option to predict the percentages of pupils achieving each level and average points scores at KS1. You can use your own forecasts, existing targets or prior assessments, plus added points, as the raw data starting point.for your predictions.

The percentages of pupils with particular levels and points scores are shown in a table at the top of the screen, with the pupil table containing the data used below.

It is the subject levels in the three RIGHT-hand pupil columns that are used in the calculations. You CAN alter the levels in these columns if you wish, to see the effect on the calculated results or use the 'Include/exclude PUPILS' button to pick the pupils to be included in the calculations. Any changes you make are highlighted in yellow. Note that these changes are temporary, they are NOT saved and do NOT affect the original data held in the toolkit.

Click this link KS1 calculations – percentages – points – what-ifs for an explanation of this option

Use this option, with actual results, to calculate the percentages of pupils achieving each level and average points scores at KS1. The percentages of pupils with particular levels and points scores are shown in a table at the top of the screen, with the pupil table containing the data used below.

You can switch between showing the percentages at each level and the percentages at each level and above.

It is the subject levels in the three RIGHT-hand pupil columns that are used in the calculations. You CAN alter the levels in these columns if you wish, to see the effect on the calculated results or use the 'Include/exclude PUPILS' button to pick the pupils included in the calculations. Any changes you make are highlighted in yellow. Note that these changes are temporary, they are NOT saved and do NOT affect the original data held in the toolkit.

Click this link Compare pupil KS1 points with National averages for an explanation of this option

Use this option to review the prior attainment in terms of Key Stage 1 average points score (KS1 APS) of pupils in any subsequent year or class – useful if you need to demonstrate that a particular year/class is above or below average for your school.

By default, this will show a graph comparing the distribution of points scores for your pupils with the National average. Clicking the 'Table' ('Graph') button will switch between table and graph displays of this information. The table includes columns for the separate subjects making up the KS1 APS and can be sorted by any of the points scores.

Please note that this toolkit display differs slightly from the corresponding 'Prior attainment of pupils in Key Stage 2' graph in RAISEonline. The National averages used in the toolkit are for all pupils, not the matched pupil records used in RAISEonline. Note too, that these averages only provide a comparison with all pupils when using the toolkit GROUP facility.

Click this link Compare School KS1 %s and points with National results for an explanation of this option

Use the tables and graphs in this option to compare your school's KS1 results with the national results for all schools.

Select the required comparison from the drop-down list - you can choose to compare the percentage of pupils achieving level 2/2B/3 (KS1) and above, the percentages of pupils achieving each level and the trends over the last five years for percentages achieving level 2+ and Points Scores. An 'Attainment' table, showing KS1 APS for different pupil groups is also available.

When viewing a table, click on the 'Graph' button to switch to a graphical display, and likewise, when viewing a graph, click on the 'Table' button to return to that view.

The tables show the results by Key Stage subject, with the result for your school at the top, then the National average immediately below, followed by the difference between them. Care is needed when interpreting the differences - a negative difference, i.e. when the school result is below the national average, may not indicate a poor overall performance. For example, your school may have a below average % of pupils achieving Level 4 at KS2 because they are all achieving Level 5.

When you click the heading Predict or analyse KS2 results, you get a further sub-menu with these options:

Click this link Predict KS2 Results using prior Test/TAs, targets or forecasts for an explanation of this option

Use this option to predict the percentages of pupils achieving each level and average points scores at KS2.

You can use your own forecasts, existing targets or prior assessments, plus added points, as the raw data starting point.for your predictions.

The percentages of pupils with particular levels and points scores are shown in a table at the top of the screen, with the pupil table containing the data used below.

It is the subject levels in the three RIGHT-hand pupil columns that are used in the calculations. You CAN alter the levels in these columns if you wish, to see the effect on the calculated results or use the 'Include/exclude PUPILS' button to pick the pupils to be included in the calculations. Any changes you make are highlighted in yellow. Note that these changes are temporary, they are NOT saved and do NOT affect the original data held in the toolkit.

Click this link Predict pupils' 2-levels progress using targets or forecasts for an explanation of this option

Use this option to predict the number and percentages of pupils who will make 2 levels of progress based on their targets and forecasts. Fischer Family Trust forecasts may be displayed if available.

The progress from KS1 to KS2 (in whole levels) for each subject is shown in the columns next to the KS2 targets and forecasts. The table rows can be sorted by pupil name, or by any of the columns of data.

Highlighting options use colour-coding to indicate pupils making <2, 2 and >2-Levels progress. Note that targets and forecasts of the form Level 4A/4B/4C or 5A/5B/5C are taken as Level 4 or 5 when calculating progress. Also, Fischer Family Trust forecasts are rounded down, for example, 4.8 = Level 4.

Clicking on the 'Table summary' button will display the numbers of pupils making <2, 2 and >2 levels progress. The 'School targets' button calculates the percentages of pupils making 2-Levels progress (using either the targets or forecasts) and displays these alongside the agreed School KS2 targets.

Click this link Predict pupil CVA scores using Fischer forecasts for an explanation of this option

This is an experimental toolkit option which lets you forecast CVA scores by using Fischer Family Trust overall KS2 points pupil forecasts in place of the pupils' actual KS2 results.

Clearly it relies on a forecast for the KS2 pupil results but this CVA calculation also depends upon the quality of information in the toolkit, as it also uses prior performance at KS1 and pupil details, such as FSM, SEN and First Language. Last but not least, it is using last year’s CVA model (The government publishes a new model each year although there has been little change in the last few years.)

This 'Contextual Value Added' graph plots the Fischer KS2 points score (vertical axis) of pupils against the expected score (horizontal axis) using the overall CVA model. Pupils who appear above and to the left of the diagonal orange line (the Zero CVA line) have a predicted KS2 score above that expected after considering the contextual factors. These pupils have positive CVA scores. Pupils who lie below and to the right of this line have a predicted KS2 score less than expected, and have a negative CVA score.

You can choose to plot for all pupils, or just boys or girls. You can also label the data points with the pupils' names and compare the pupils against national results by displaying lines for the national percentile lines and KS2 Levels.

Details of the individual pupil CVA scores (and more information about the factors in the model) are available via the 'CVA Details' button in the left-hand panel.

Click this link KS2 calculations – percentages – points – what-ifs for an explanation of this option

Use this option, with actual results, to calculate the percentages of pupils achieving each level and average points scores at KS2.

The percentages of pupils with particular levels and points scores are shown in a table at the top of the screen, with the pupil table containing the data used below. You can switch between showing the percentages at each level and the percentages at each level and above.

It is the subject levels in the three RIGHT-hand pupil columns that are used in the calculations. You CAN alter the levels in these columns if you wish, to see the effect on the calculated results or use the 'Include / exclude PUPILS' button to pick the pupils included in the calculations. Any changes you make are highlighted in yellow. Note that these changes are temporary, they are NOT saved and do NOT affect the original data held in the toolkit.

Click this link Pupil KS2 Targets, Forecasts, Results and 2 levels progress for an explanation of this option

Use this option to analyse the KS2 targets, forecasts and results for a year group/class against the agreed School KS2 targets. Fischer Family Trust forecasts may be displayed if available.

The table shows the targets, forecasts and results (as levels) for each pupil, for English, Mathematics and Science. You can also use the buttons in the left-hand panel: 'GROUP' to list only certain pupils; 'CHANGE forecast' to specify which Fischer forecast (A B C D) to use; 'Level 4+ Level 5 / 2-Levels progress ' to switch between table displays. The combined level for 'English & Maths' is obtained by taking the lower of the pupil's individual English and Mathematics levels.

The table rows can be sorted by pupil name, or by any of the columns of data. In addition, you can sort on the difference between two columns. The progress from KS1 to KS2 (in whole levels) for each subject is shown in the columns next to the KS2 targets, forecasts and results.

Highlighting options use colour-coding to indicate column differences and pupils at a particular level as well as pupils making <2, 2 and >2-Levels progress.. Note that targets and forecasts of the form Level 4A/4B/4C or 5A/5B/5C are taken as Level 4 or 5 for comparison with results. Also, Fischer Family Trust forecasts are rounded down for comparisons and calculations, for example, 4.8 = Level 4.

Clicking on the 'Table summary' button will display the total number of pupils at each Level, and also how many are above their targets or forecasts.

The 'School targets' button calculates the percentages of pupils achieving Level 4+ and Level 5 and making 2-Levels progress and displays these alongside the agreed School KS2 targets.

Click this link Pupil Contextual Value Added measures [CVA] for an explanation of this option

This 'Contextual Value Added' graph plots the actual KS2 points score (vertical axis) against the expected score (horizontal axis) using the overall CVA model. Pupils who appear above and to the left of the diagonal orange line (the Zero CVA line) have achieved a KS2 score above that expected after considering the contextual factors. These pupils have positive CVA scores. Pupils who lie below and to the right of this line have achieved a KS2 score less than expected, and have a negative CVA score.

You can choose to plot for all pupils, or just boys or girls. You can also label the data points with the pupils' names and compare the pupils against national results by displaying lines for the national percentile lines and KS2 Levels.

By default, the axis limits are set from 10 to 40 - you can fix different scales if you wish. Clicking on the 'Pupils & Points' button displays a list of the Expected KS2 scores calculated by the CVA model from prior KS1 performance and pupil and school factors) and actual KS2 points scores (shown as fine grade points, which are derived from KS2 test marks) and the difference between them equals the Pupil CVA .

Details of the individual pupil CVA scores (and more information about the factors in the model) are available via the 'CVA Details' button in the left-hand panel.

Click this link Graph KS2 test marks against KS1 APS for an explanation of this option

This 'value added' line graph plots the performance of pupils at a given year (subject mark) against that at Key Stage 1 (average points score).

You can choose to plot for all pupils, or just boys or girls. You can also label the data points with the pupils' names and compare the pupils against national results by displaying lines for the national quartiles (lower, median and upper) and levels.

By default, the KS1 axis limits are set from 3 to 21 and the 'Year' axis limits from 0 to the maximum mark - you can fix different scales if you wish.

Click this link Compare School KS2 %s & pts with National results for an explanation of this option

Use the tables and graphs in this option to compare your school's KS1 and KS2 results with the national results for all schools.

Select the required Key Stage and comparison from the drop-down lists - you can choose to compare the percentage of pupils achieving level 2/2B/3 (KS1) or level 4/5 (KS2) and above, the percentages of pupils achieving each level and making 2-levels progress from KS1 to KS2, and the trends over the last five years for percentages achieving level 2+/4+ and 2-Levels progress and Points Scores.

An 'Attainment' table, showing KS1/KS2 APS for different pupil groups is also available.

Click this link Compare School KS2 Results with Targets & Forecasts for an explanation of this option

Use the tables and graphs in this option to compare your school's agreed KS2 targets with both your KS2 results (achieved over the last three years) and KS2 forecasts (for the next two years).

You can choose to display all three targets (percentage of pupils achieving Level 4+, Level 5+, 2-Levels progress) for a single year or five-year trends for each target separately. Note that the five years consist of three 'results years' and two 'forecast years'. A range of KS2 forecasts are provided from RAISEonline and, if available, Fischer Family Trust forecasts too.

Click this link School Progress ~ Contextual Value Added [CVA] for an explanation of this option

Use the tables and graphs in this option to explore your school's progress, as measured by CVA Value Added scores.

Use the drop-down menu to select the results you require ~ either a 3 Year Summary of Value Added Measures (with values and percentile ranks for AAT & CVA measures) or Value Added Measures grouped by Pupil Characteristics (for example, CVA scores for boys and girls).

Note that the percentile rank is a comparison with schools nationally, for example, a rank of 30 means that your school is in the top 30% of schools nationally.

When viewing a table, click on the 'Graph' button to switch to a graphical display, and likewise, when viewing a graph, click on the 'Table' button to return to that view. Several graphs are provided, so clicking 'Graph' brings up a menu of graph choices.

Highlighting options are provided in both the table and graph displays. These indicate whether your school's progress (VA score) is significantly higher or lower than average, and highlight significant changes from one year to the next.

Click this link Comparing School at KS2 with other (local) schools for an explanation of this option

Use the tables and graphs in this option to compare your school's performance with other (local) schools. Data is available on school size, absences, Special Educational Needs and a range of information is provided for KS2 test results. The latter includes the percentage of pupils achieving Level 4+, Level 5+, KS2 APS scores and CVA measures.

For convenience, your school is displayed separately at the top of the table - it is also in the main table below, along with the other schools.

The 'Compare' button offers direct comparison with another school or with the quartiles. (Note that these quartiles are calculated from the schools in the table, they are NOT National values.) The comparative data is shown below your school at the top of the table, and you can highlight (colour code) any differences.

The 'Bar chart' option can be used to plot a chart of any variable (column of data) in the table, while the 'Scatter graph' option will plot any two variables in an X-Y graph, one against the other. The 'KS2 graphs' option provides more detailed graphs, which display combinations of some of the KS2 variables.

Reading/spelling ages

This is the Reading and Spelling ages section of the main menu.

Reading and spelling ages menu

Click this link Reading ages – yearly or termly (Years 1 to 6) for an explanation of this option

Use this option to view the Reading age assessments for pupils over their school career and to compare these Reading ages with their chronological ages.

The table displays the Age, Reading age and Difference (Reading age - Age) in months for each pupil. You can also use the 'GROUP' button in the left-hand panel to list only certain pupils, for example, those pupils receiving Free School Meals (FSM).

The table rows can be sorted by pupil name, or by any of the columns of data. Additional data (assessment date and Standardised Reading score) can be displayed by clicking on the 'Extra columns' button. This button also lets you display only the latest set of results in the table.

This table forms one part of a trio of Reading Age displays. The other two, 'Scatter graph' and 'Pupil graph' are accessed via the buttons at the top of the window. The scatter graph plots Reading age against Age for all pupils for a single assessment, while the (individual) Pupil graph plots all the assessments for a single pupil

Click this link Spelling ages – yearly or termly (Years 1 to 6) for an explanation of this option

Use this option to view the Spelling age assessments for pupils over their school career and to compare these Spelling ages with their chronological ages.

The table displays the Age, Spelling age and difference ( Spelling age - Age ) in months for each pupil. You can also use the 'GROUP' button in the left-hand panel to list only certain pupils, for example, those pupils receiving Free School Meals (FSM).

The table rows can be sorted by pupil name, or by any of the columns of data. Additional data (assessment date and Standardised Spelling score) can be displayed by clicking on the 'Extra columns' button. This button also lets you display only the latest set of results in the table.

This table forms one part of a trio of Spelling Age displays. The other two, 'Scatter graph' and 'Pupil graph' are accessed via the buttons at the top of the window. The scatter graph plots Spelling age against Age for all pupils for a single assessment, while the (individual) Pupil graph plots all the assessments for a single pupil

Click this link Other standardised scores for an explanation of this option

Text to follow

Whole school view

This is the Whole school view section of the main menu.

Whole school view menu

Click this link Pupil details – totals & %s of FSM, Language, SEN etc for an explanation of this option

Use this option to display the pupil details for a particular Year/Class or your entire school.

Select either the required Year/Class from the drop-down list or the 'All current pupils' button. The numbers and percentages of pupils with particular characteristics are shown in a table. You can also use the 'GROUP' button in the left-hand panel to show the details for a particular group of pupils, for example, those pupils receiving Free School Meals (FSM).

Any extra pupil details (for example, Gifted and Talented) you have added to the toolkit are shown at the bottom of the table.

Click this link Reading, Writing & Maths overview for an explanation of this option

This option provides an overview of attainment and progress in Reading, Writing and Mathematics for all the pupils (NC Years 1 to 6) in a School Year (e.g. academic year 2009/2010).

Select the required School Year from the drop-down list in the top-left corner of the window. You will then be asked to choose which type of calculation you require. There are three main choices: Pupil results (NC level); Pupil progress in NC points; Pupil results compared against their own individual targets. Yearly or termly data can be chosen for the calculations.

An identical table layout is used to display all the calculations, with the Years 1 to 6 along the top and the percentages of pupils for each subject down the side. These are split into three categories, 'above', 'equal' and 'below' your School (or National) expectations. A simple highlighting option is provided to flag up successes or problems for a year, by indicating 'Above' , 'Equal' and 'Below' percentages in the table. You can set your own values for these percentages at the top of the toolkit screen, where you will also find a 'Detailed view' button to switch to a year list of the individual pupil results.

The 'Test/TA' button in the left-hand panel specifies which results to use in the calculations for Years 3 4 & 5. You can also use the 'GROUP' button to carry out these calculations for only certain pupils, for example, to carry out separate calculations for boys and girls.

Click this link Overview of Subject Attainment/Progress for an explanation of this option

This option provides an overview of attainment and progress in a single SUBJECT for all the pupils (NC Years 1 to 6) in a School Year (e.g. academic year 2009/2010).

Start by selecting the required School Year from the drop-down list in the top-left corner of the window and then the Subject from the list underneath. After a short delay, while the data is collected, you will need to click the 'Subject overview' button to choose the period, yearly or termly, and which groups of pupils to include in the calculation.

In the results table, the Years 1 to 6 are displayed in the columns along the top and the groups of pupils in the rows down the side.

Attainment is shown as both an average NC points score and equivalent NC level with the percentages of pupils achieving both the 'Expected' level and, if available, your own school set pupil target levels.

Progress, termly and overall progress in the year, is shown in NC points with the percentage of pupils achieving the expected progress alongside.

A simple highlighting option is provided which may help to flag up successes or problems for a year, by indicating percentages in the table which are more than 75% or less than 25%. You can set your own values for these percentages at the top of the toolkit screen.

The 'PUPIL Results' button in the left-hand panel switches to a year list of the individual pupil results. The 'Test / TA' button specifies which results to use in the Summer calculations for Years 3 4 & 5 and the 'Expected Levels & Progress' button lets you set the 'Expected' values to be used for comparison.

Click this link Subject results for School Year e.g. all pupils in 2009/10 for an explanation of this option

Use this option to calculate the numbers and percentages of pupils achieving each level or making progress (in points and levels) for all the pupils (NC Years 1 to 6) in a School Year (e.g. academic year 2000/2010) in any subject for which you have entered data.

Having selected the School Year and subject, you will be asked to choose which type of calculation you require. There are three main choices: Pupils achieving each Level; Yearly and termly Pupil progress; Pupil progress from KS1. Each calculation is displayed in a table, with results shown from Year 1 at the left to Year 6 at the right.

Once the table is displayed, the 'SUBJECT display' button in the left-hand toolkit panel lets you switch between these different calculations You can also use the 'GROUP' button in the left-hand panel to carry out these calculations for only certain pupils, for example, those pupils who entered at Year 2 or earlier, so took their KS1 tests/TAs at your school.

Click this link Subject results for a Year/Class over their school career for an explanation of this option

Use this option to calculate the numbers and percentages of pupils achieving each level or making progress (in points and levels) over their school career in any subject for which you have entered data.

Having selected the School Year and subject, you will be asked to choose which type of calculation you require. There are three main choices: Pupils achieving each Level; Yearly and termly Pupil progress; Pupil progress from KS1. Each calculation is displayed in a table, with results shown from Year 1 at the left to Year 6 at the right.

Once the table is displayed, the 'SUBJECT display' button in the left-hand toolkit panel lets you switch between these different calculations. You can also use the 'GROUP' button in the left-hand panel to carry out these calculations for only certain pupils, for example, those pupils who entered at Year 2 or earlier, so took their KS1 tests/TAs at your school.

Click this link Compare FSP with National results for an explanation of this option

Use the tables and graphs in this option to compare your school's Foundation Stage Profile with the national results for all schools. You can choose to compare the percentage of pupils achieving 6 points or above, and the percentage of pupils achieving Early Learning Goals.

The tables show the results by FSP subject, with the result for your school at the top, then the National average immediately below, followed by the difference between them. You can choose to highlight these differences using different colours.

When viewing a table, click on the 'Graph' button to switch to a graphical display; click on the 'Table' button to return to the 'Graph'. Each graph lets you choose whether or not to display the National results alongside those for your school.

Click this link Compare KS1 and KS2 with National results for an explanation of this option

Use the tables and graphs in this option to compare your school's KS1 and KS2 results with the National results for all schools.

You can choose to compare the percentage of pupils achieving levels 2/2B/3 (KS1) or levels 4/5 (KS2) and above, the percentages of pupils achieving each level and making 2-Levels progress from KS1 to KS2, and the trends over the last five.

An 'Attainment' table, showing KS1/KS2 APS for different pupil groups is also available. When viewing a table, click on the 'Graph' button to switch to a graphical display; click on the 'Table' button to return to the table..

The tables show the results by Key Stage subject, with the result for your school at the top, then the National average immediately below, followed by the difference between them. You can choose to highlight these differences using different colours and the 'Trends' tables lets you select the results for 'All pupils', 'Boys' or 'Girls'.

Care is needed when interpreting the differences - a negative difference, i.e. when the school result is below the national average, may not indicate a poor overall performance. For example, your school may have a below average % of pupils achieving Level 4 at KS2 because they are all achieving Level 5.

Each graph lets you select the subjects to plot, and whether or not to display the National results alongside those for your school. The graphs for the percentages of pupils attaining particular key stage levels are displayed as bar charts, while a line graph and a bar chart are provided for the '% achieving Level 2+/Level 4+' and '2-Levels progress' and 'Points Scores trends over the last five years'.

Click this link Compare KS2 Results with your Targets/Forecasts for an explanation of this option

Use the tables and graphs in this option to compare your school's agreed KS2 targets with both your KS2 results (achieved over the last three years) and KS2 forecasts (for the next two years).

You can choose to display all three targets (percentage of pupils achieving Level 4+, Level 5+, 2-Levels progress) for a single year or five-year trends for each target separately. Note that the five years consist of three 'results years' and two 'forecast years', so you will be asked to specify which forecast you want to use. A range of KS2 forecasts is provided from RAISEonline and, if available, Fischer Family Trust.

The tables are arranged by subject, with the result or forecast at the top, then the target immediately below, followed by the difference between them. You can choose to highlight these differences using different colours.

The graphs for a single year are displayed as bar charts, while a line graph and combined line/bar chart are provided for the five-year trends.

Click this link KS1 to KS2 - Contextual Value Added [CVA] for an explanation of this option

Use the tables and graphs in this option to explore your school's progress, as measured by KS1 to KS2 CVA scores.

Use the drop-down menu to select the results you require ~ either a 3 Year Summary of Value Added Measures or Value Added Measures grouped by Pupil Characteristics (for example, CVA scores for boys and girls).

Note that the percentile rank is a comparison with schools nationally, for example, a rank of 30 means that your school is in the top 30% of schools nationally.

When viewing a table, click on the 'Graph' button to switch to a graphical display; click on the 'Table' button to return to the 'Graph'. Several graphs are provided, so clicking 'Graph' brings up a menu of graph choices.

Highlighting options are provided in both the table and graph displays. These indicate whether your school's progress (VA score) is significantly higher or lower than average, and highlight significant changes from one year to the next.

Click this link Compare your KS2 results with other (local) schools for an explanation of this option

Use the tables and graphs in this option to compare your school's performance with other (local) schools. Data is available on school size, absences, SEN and a range of KS2 information. (percentage of pupils achieving Level 4+/Level 5+, KS2 APS scores and CVA measures.

When viewing a table, click on the 'Graph' button to switch to a graphical display; click on the 'Table' button to return to the 'Graph'. Note that the school names may have been shortened to fit into the table and graph displays. You can see the full school names by moving the mouse over the short names in the table.

The list box in the top left-hand corner of the table display controls which results are shown. A second list box underneath this allows you to sort the data, either by school name or by the values in one of the columns.

For convenience, your school is displayed separately at the top of the table - it is also in the main table below, along with the other schools. Note that you may need to scroll down the page to see all the schools, and if viewing 'ALL RESULTS', you will also need to scroll to the right.

The 'Compare' button offers direct comparison with another school or with the quartiles. Note that these quartiles are calculated from the schools in the table, they are NOT National values.

The 'Bar chart' option can be used to plot a chart of any variable (column of data) in the table, while the 'Scatter graph' option will plot any two variables in an X-Y graph, one against the other. The 'KS2 graphs' option provides more detailed graphs, which display combinations of some of the KS2 variables.

All the charts and graphs display your school on the graph, and they also provide a facility to highlight another school. The bar chart displays can be sorted by school name or value, and options are provided to fix the graph scales and show the quartiles.

Entering/editing data

Introduction

Access to this section of the toolkit is controlled by a separate password, so that you can limit the number of people who can add/change data in the toolkit.

This is the main Data menu: clicking on any of these headings will reveal a more detailed sub-menu (see below).

Data entry main menu

You can enter data directly into the toolkit via any of the blue headings in these sub-menus (marked keyboard entry) but you can also enter data via Data Capture sheets which you create using the headings in black on these sub-menus. Data capture sheets are external Excel spreadsheets which have just the same facilities as the sheets in the toolkit itself and, once completed, they can be imported directly into the toolkit.

We strongly recommend that you use these Data Capture sheets, particularly for entering pupil results, because teachers find them very quick and easy to use, it saves time, spreads the input load and limits the number who have direct access to the data facilities in the toolkit.

To create a Data Capture sheet

When you click on any of the Data Capture sheet headings in the following sub-menus, you will see this box which allows you to choose year/class, the type of data to be collected, for which year or term and the type of form to use.

Data capture sheet

Using a tick list

There are three types of Data Capture sheet; a pupil entry form which allows you to enter data for each individual pupil in turn, a worksheet, which is an Excel spreadsheet with columns of data for the whole year/class and a tick list which is probably the simplest way to enter level data and preferred by most teachers. Here is how it works:

 tick list example

Start by choosing the subject from the drop-down subject list at the top. Note that a tick list can only be used to enter results for one subject at a time, but you can choose and enter results for different subjects in turn. The pupil names (and any existing results) are displayed in a 'tickable' list. Set the level you want to assign at the top of the list box, then simply tick the pupils. You will probably find it easiest to assign the levels in descending order, i.e. start with the HIGHEST level and work your way down to the LOWEST.

If you need to make any changes, set the new level required, then click to un-tick the pupil (to delete their existing level) and click to tick them again (to assign the new level). The list is re-sorted automatically each time you choose a level to assign. However, you can sort the list at any time by clicking on the 'Sort' button to the right of the list. A count of the data entries is also displayed next to the list, in the top right-hand corner. You can print out the results via the 'PRINT' button in the panel at the left-hand edge of the toolkit window. You can save the results via either the 'SAVE' button in the toolkit panel or the standard Excel 'File menu | Save' procedure.

On finishing a data entry session, either click on the 'CLOSE' button in the toolkit panel or use the standard Excel 'File menu | Close' procedure. Once all the data has been entered and saved, take this file (e.g. on a floppy disk or memory stick) back to the school computer containing the 'master version' of the Progress toolkit, for IMPORTing into the toolkit.

Pupil details

This is the Pupil details section of the data menu.

Pupil details sub-menu

All three pupil details options for keyboard entry, provide two input methods, an 'entry form', which displays the details for each student in turn, or an (Excel) worksheet, which displays the details for the whole year group/class.

In the form, the 'Enter/Next' button at the bottom will automatically move to the next pupil in the year group, or you can select a particular pupil from the drop-down list.

If you use the worksheet display, you will need to scroll through the spreadsheet cells yourself to find a particular pupil. You can enter, edit and delete values from the spreadsheet cells using standard Excel procedures. Pressing the < Tab>key will move the entry cursor one column to the right while < Enter>moves the cursor down one row. Note that, pressing < Tab>in the right-most column will move the cursor down one row and back to the first column (at the left-hand edge).

Click this link Add/delete Pupils and enter Basic Details for an explanation of this option

Use this option to enter or edit Pupil for a whole year group/class or an individual pupil. You can also add new pupils to a year group or delete existing pupils by clicking on the 'Add Pupils' and 'Delete Pupils' buttons at the top of the window. The 'Change' button allows you to change a pupil's name or UPN, move them to another class or Year, or to reinstate pupils you have deleted previously.

(The toolkit lets you add two details of your own - use the 'EXTRA DETAILS' option in the panel at the left- hand side of the window or use the next option below.)

Click this link Extra Details for Pupils or Notes for Pupils for an explanation of these options

Use these options to enter or edit 'Pupil Notes' (a brief comment about a pupil) or 'Extra Pupil Details' (for example, Gifted & Talented) for a whole year group/class or an individual pupil. The toolkit lets you add two details of your own – click on the 'EXTRA DETAILS' button in the panel at the left-hand side of the window and follow the on-screen instructions.

Note that these extra fields are restricted to a 'Yes/No' input and they are shown at the bottom of the entry form (or the right-hand-side of the entry worksheet). Once entered, the data in these fields can be used to group pupils when listing them in toolkit REPORTS and when displaying tables and graphs in the PUPIL section of the toolkit.

By default, these extra fields are initially left blank. However, you may prefer to set all the initial entries to 'Yes', and then you will need only to input the 'No' pupils (or vice-versa). If you no longer require an existing extra data field then simply rub out the heading to remove it, or enter a new heading if you wish to replace it.

Click this link Import full or new pupil list from a computer file for an explanation of this option

Text to follow

Click this link Import pupil attendance data from a computer file for an explanation of this option

Text to follow

Click this link Data Capture sheets – for filling in extra details or notes for an explanation of this option

Please refer to the general section on Data capture sheets above.

Click this link Import extra details or notes from a capture sheet for an explanation of this option

Please refer to the general section on importing a Data capture sheet above.

Pupil Interventions

You can use this option to enter or edit 'Pupil Interventions' for individual pupils. Start by selecting the required Year/Class from the drop-down list in the top left-hand corner of the window. An 'entry form' is provided which displays the interventions for each student in turn. In the form, the 'Enter/Next' button at the bottom will automatically move to the next pupil in the year group. You can also select a particular pupil from the drop-down list. Note that pupils with existing interventions are marked with an asterisk * in the pupil list.

Click the 'Add Intervention' button at the top of the screen to create a new intervention (up to a maximum of 20) for a pupil.

Add intervention

You will be asked for subject details and can also specify a particular intervention strategy if you wish. Then for each intervention you can enter a start date & level, end date & level and brief notes. A choice of four types of assessment 'level' is provided: NC level ( 2B 2A etc), Number scale (0-999), Letter scale (A to Z) or Age (for example 06/11).

Once you have set up the interventions, a range of toolkit REPORTS (go back to the MAIN MENU and choose the 'Extract data from the toolkit [ REPORTS ]' section) are available to list and analyse their effects.

Targets and Forecasts for Pupils

This is the Targets and Forecasts for pupils section of the main data menu.

Targets & forecasts sub-menu

Click this link Termly or Yearly Pupil Targets for an explanation of these options

Use these options to enter or edit Targets for a year group/class or an individual pupil in Years 1 to 6. The targets can be for the end of the year or termly - Autumn - Spring - Summer. Select the required 'Year/Class' and 'Targets Year' from the drop-down lists in the top left-hand corner of the window, then choose which of the fourteen National Curriculum subjects to enter targets for. Three input methods are provided. An 'entry form', which displays the targets for each student in turn, a 'Tick list' (see above) and an Excel worksheet, which both display the targets for the whole year group/class.

In the form, the 'Enter/Next' button in the bottom right corner will automatically move to the next pupil in the year group, or you can select a particular pupil from the drop-down list. The tick list can only be used to enter targets for one subject at a time. Set the level you want to assign (above the tick list), then simply tick the pupils in the list below. 'Un-ticking' a pupil will remove their level, and you can then re-assign them a different level as required.

If you use the worksheet display you will need to scroll through the spreadsheet cells to find a particular pupil. You can enter, edit and delete values from the spreadsheet cells using standard Excel procedures. Pressing the < Tab>key will move the entry cursor one column to the right while < Enter>moves the cursor down one row. Note that, pressing < Tab>in the right-most column will move the cursor down one row and back to the first column (at the left-hand edge).

Note that all the targets are entered as levels, with a drop-down entry list providing both NC and P-levels.

Click this link Pupil KS2 Targets – set agreed individual pupil targets for an explanation of this option

Use this option to enter targets for pupils' KS2 levels in English, Mathematics and Science. Targets can be set for current Y3, Y4, Y5 and Y6 pupils.

To help you set the targets, the pupil's test results at KS1, Year 3, Year 4 and Year 5 are shown. Note that teacher assessments (marked *) are shown where test marks are not available. The pupil targets are entered (as levels) in the boxes in the middle of the screen. When complete, click on the 'Enter/Next' button, which will store these targets and automatically move to the next pupil.

To help you set a target, you can choose to 'Show KS2 predictions', based on the pupil's KS1 Average Points Score or, if your school uses this data, the Fischer Family Trust forecasts for that pupil. The KS1 APS predictions are based on national results, and indicate the distribution of KS2 levels for a given KS1 score. For pupils with NO KS1 APS there is the option to set a (temporary) score for them, to be able to make use of these predictions.

There are four Fischer Family Trust forecasts, A, B C and D, and a small drop down list is provided to select the required letter. Each forecast gives a predicted level and the probability of the pupil achieving Level 4+ and Level 5. Forecast A is based on a pupil's progress (tests and assessments) and gender, while Forecast B is adjusted to reflect the performance of 'similar' schools (with similar FSM entitlement). Forecast C includes your school's ability to contribute to overall improvement (which depends upon the distribution of pupil ability and prior attainment) and Forecast D provides an indication of achievement that would be consistent with the progress made by pupils in schools with the highest value-added (Y2 to Y6).

You can switch to the School KS2 targets, by clicking on the button in the blue panel, at the left-hand edge of the window. Switch back to the Pupil targets by clicking on the button in the left hand blue panel. Use this option to enter targets for your school at Key Stage 2 for English, Mathematics and Science. The targets are set in terms of the percentage of pupils who will achieve Level 4 and above (Level 4+), Level 5 and make 2-Levels progress from Key Stage 1.

To help you set the targets, the school's previous targets and actual performance, along with the national averages, are displayed for the last five years. Also, if you have already set individual pupil KS2 targets, then overall school targets can be calculated from these. The calculations appear in the middle of the screen. Lastly, if available, KS2 forecasts using Fischer Family Trust data and RAISEonline Indicative Targets are shown.

Click this link Pupil KS2 Forecasts – enter/update your own forecasts for an explanation of this option

Use this option to enter forecasts for pupils' KS2 level for English, Mathematics and Science. Forecasts can be set for current Y3, Y4, Y5 and Y6 pupils. The pupil forecasts are entered (as levels) in the boxes in the middle of the screen. When complete, click on the 'Enter/Next' button, which will store these forecasts and automatically move to the next pupil. You can also enter a date for your forecasts if you wish. By default, the forecast date is set to today's date. A quick summary of the numbers of pupils with forecasts above, equal to and below their targets is provided at the bottom of the screen.

Click this link Create pupil targets from prior results and expected progress for an explanation of this option

The toolkit also provides two quick ways of setting pupil targets automatically, either by working forwards from the latest assessment and specifying the expected points progress or by working backwards from the Fischer Family Trust forecast for KS2 and working out where the pupil needs to get to in order to reach that target.

When you click on this heading, you get this opening explanation of the procedure. You can set the expected points progress using the ‘Progress measure’ button.

Automatic target setting from prior results 1

When you click continue, you can choose the subject you want to create targets for and the toolkit will show which years have prior year data and which you can therefore set targets for set targets for. Tick in the appropriate box if you want to set termly targets as well.

Automatic target setting from prior results 2

Click this link Create pupil targets from Key Stage 2 Fischer Forecasts for an explanation of this option

This option works in a very similar way to the prior results option except here you choose which Fischer forecast to use for the KS2 target and the toolkit uses the difference between this target and the pupils latest result to calculate end of year targets for the intervening years. Tick in the appropriate box if you want to set termly targets as well.

Automatic target setting from Fischer forecasts

Once you have created the targets automatically you can use the other target setting options to review them or, better still, create Data Capture sheets of the automatic targets and get your class teachers to review them. You can then make any individual amendments and import the targets back into the toolkit.

Automatic target setting Data capture sheet

Results for Pupils (Teacher assessments and tests)

When you click on the Results for Pupils (Teacher assessments and tests) heading in the DATA menu, you get this sub-menu:

Results for pupils sub-menu

In all the following options, three input methods are provided. An 'entry form', which displays the results for each student in turn, a 'Tick list' and and (Excel) worksheet, which both display the results for the whole year group/class.

In the form, the 'Enter/Next' button in the bottom right corner will automatically move to the next pupil in the year group. The tick list can only be used to enter results for one subject at a time. Set the level you want to assign (above the tick list), then simply tick the pupils in the list below. 'Un-ticking' a pupil will remove their level, and you can then re-assign them a different level as required.

If you use the worksheet display, you will need to scroll through the spreadsheet cells to find a particular pupil. You can enter, edit and delete values from the spreadsheet cells using standard Excel procedures. Pressing the < Tab>key will move the entry cursor one column to the right while < Enter>moves the cursor down one row. Note that, pressing < Tab>in the right-most column will move the cursor down one row and back to the first column at the left-hand edge.

Click this link EYFS assessments using FSP points for an explanation of this option

Use this option to enter or edit Reception or Nursery results from entry up to Foundation Stage Profile (FSP) for a year group/class or an individual pupil.

Note that the results are for the thirteen Foundation subjects, (Dispositions & Attitudes to Creative Development) and are all entered as FS levels, from 0 to 9.

Click this link EYFS assessments using Development Matters grid for an explanation of this option

Use this option to enter or edit Development Matters results for Nursery or Reception for a year group/class or an individual pupil.

Note that the results are all entered as the 'standard' month ranges ~ 0-11, 8-20, 16-26, 22-36, 30-50, 40-60 months & ELG. You can also split these into three sub-ranges a b c. For example, 16-26c 16-26b 16-26a could be used to represent Early [c] Secure [b] and Complete [a] progress within the overall range 16-26 months. To use this feature, please tick the box ‘Use sub-ranges a b c in the assessments’.

Click this link Teacher Assessments – yearly or termly assessments for Years 1 to 6 for an explanation of this option

Use this option to enter or edit Teacher Assessments for a year group/class or an individual pupil in Years 1 to 6. The results can be for the end of the year or termly - Autumn - Spring - Summer.

Note that all the results are entered as levels, with a drop-down entry list providing both NC and P-levels.

Click this link Optional SATs for Years 3, 4 or 5 for an explanation of this option

Use this option to enter or edit Optional SATs Test results (marks and levels) for a year group/class or an individual pupil in Years 3, 4 or 5.

Using this window, you can select the subjects and have the toolkit calculate the levels automatically from the marks which you enter. The test marks are entered as numbers. You can over-ride the test levels using the drop-down entry list, which provides both NC and P-levels.

Enter marks or levels for Optional SATs

Click this link Key Stage Two Test Results for Year 6 for an explanation of this option

Use this option to enter or edit Key Stage 2 Test results (marks and levels) for a year group/class or an individual pupil in Year 6.

Using this window, you can select the subjects and have the toolkit calculate the levels automatically from the marks which you enter. The test marks are entered as numbers. You can over-ride the test levels using the drop-down entry list, which provides both NC and P-levels.

Enter marks or levels for KS2

Click this link Reading ages and Spelling ages for Years 1 to 6 for an explanation of this option

When you click on this heading, you must first select Reading or spelling ages. You are then presented with this dialogue box. Use it to select the date format, frequency and style of entry form which you want to use.

Rreading ages selection box

Use this option to enter or edit Reading ages for a whole year group/class or an individual pupil.

If you selected spelling ages at the first Option, you will be presented with an identical dialogue box for Spelling ages.

Select the required year group from the drop-down list in the top left-hand corner of the window, and then choose which assessments to work with from the results list below. The results are listed by calendar year, then by term if applicable, with the most recent at the top of the list.

You are then presented with this dialogue box: using it, you can enter an assessment date and the toolkit will then calculate the pupils’ chronological ages for you. You can also opt to enter a standardised score if you want.

Reading ages entry details

Click this link Other Standardised test score for Years 1 to 6 for an explanation of this option

Text to follow

Click this link Pupil results Data Capture sheets for an explanation of this option

You can create Data Capture sheets for all the options listed above and, once complete, import the results straight into the toolkit.

Pupil results data capture sheets

Overall School Targets & Results

When you click on the Overall School Targets & Results heading in the DATA menu, you get this sub-menu:

School targets & results sub-menu

Click this link Set agreed School KS2 Targets for an explanation of this option

Use this option to enter targets for your school at Key Stage 2 for English, Mathematics and Science. The targets are set in terms of the percentage of pupils who will achieve Level 4 and above (Level 4+), Level 5 and make 2-Levels progress from Key Stage 1.

Select the required year group from the drop-down list. Targets can be set for current years Y3, Y4, Y5 and Y6. To help you set the targets, the school's previous targets and actual performance, along with the national averages, are displayed for the last five years. Also, if you have already set individual pupil KS2 targets, then overall school targets, calculated from these, appear in the middle of the screen.

You can switch to the Pupil KS2 targets at any time by clicking on the button in the blue panel, at the left-hand edge of the window. Lastly, if available, KS2 forecasts using Fischer Family Trust data and RAISEonline Indicative Targets are shown.

Click this link Enter School Results at FSP/KS1/KS2 for an explanation of this option

Use this option to enter or edit your school results for the current school year. You can enter the percentages of pupils achieving each FSP, KS1 & KS2 Level; the KS1 & KS2 Average Points Scores (APS) and the KS2 Contextual Value Added (CVA) scores.

Click this link Calculate School Results from pupil results in toolkit for an explanation of this option

You can use this Data Capture sheet to calculate school results for the current year from the pupil results once you have entered these into the toolkit. This will enable you to get unvalidated results long before the Government publishes them.

You can calculate Foundation Stage Profile %s, KS1 and KS2 %s and points, plus the school CVA measure, provided that you have entered the necessary pupil results into the toolkit.

Once complete, these school results can then be imported into the toolkit.

Setup toolkit preferences

When you click on the Setup toolkit preferences heading in the DATA menu, you get this sub-menu:

Setup toolkit preferences sub-menu

Use these options to select:

1.whether you want to use the Standard system of NC sub-levels (with a minimum step of 2 points) or to use the single point system which involves adding a sub-level plus between each standard sub-level (e.g. 2C = 13 points, 2C+ = 14 points, 2B = 15 points, 2B+ = 16 points etc)

2.whether you want to give priority in Years 3, 4 and 5 to Test results or Teacher Assessments

3.whether you want to use termly or half-termly assessments.

Creating reports

Extract data from the toolkit [REPORTS]

When you click the heading Extract data from the toolkit [REPORTS] on the main menu, you get this sub-menu:

Reports sub-menu

Click this link Year/Class list – pupil names & details – add own columns for an explanation of this option

Use this option to view, print or save to disk a Year or Class list, created from the columns of pupil data held in the toolkit.

Select the Year/Class from the drop-down list, then click on the 'ceate REPORT' button. You are then asked to specify which pupil details to include in the report, and you can also add blank columns for your own use. The report can be printed or saved, using the buttons in the toolkit panel at the left-hand edge of the window. The SAVE option copies the report to a separate Excel file, which you can then save as an Excel workbook (or in another form, e.g. just as text).

You can also sort the report on a particular column, and use the 'Group' option to report on particular pupils, for example, to display only girls, or only those pupils receiving Free School Meals. Note that the 'Query' option is NOT available for this report type.

Click this link Pupil report – details, results & targets – add own text for an explanation of this option

This report shows a pupil's termly targets and assessments for the current school year in the core subjects: Speaking & Listening, Reading, Writing, English, Mathematics and Science.

Start by selecting the Year/Class you require, then you can choose to create the report for ALL pupils (the default) or pick an individual pupil from the list. If required, Use the report options to add the teacher's name and up to three of your own 'boxes' to the report to enter more information or longer comments. Use the 'Preview' button to check that the report layout is as you wish, then when ready, click the 'Create report(s)' button.

The report(s) will be 'written' to a new Excel workbook (with a page for each pupil) which you can then save as a separate file. If you have added your own report boxes, information can either be typed directly into this workbook using standard Excel commands, or the reports printed out and the information added by hand.

Click this link Standard Progress report for a Year/class for an explanation of this option

Use this option to view, print or save to disk a Progress report, created from the columns of pupil data held in the toolkit. The report compares the pupils' levels in English, Mathematics and Science against their expected levels, calculated from the Standard Progress measures: + 6 NC points in Year 1 & Year 2; + 3 NC points in Years 3, 4, 5 & 6. Your own School Progress measures are used instead if you have set these up as the default measures in the PUPILS section of the toolkit.

Select the Year/Class from the drop-down list, then click on the 'ceate Progress REPORT' button. The report can be printed or saved, using the buttons in the toolkit panel at the left-hand edge of the window. The SAVE option copies the report to a separate Excel file, which you can then save as an Excel workbook (or in another form, e.g. just as text).

You can also sort the report on a particular column, and use the 'Group' option to report on particular pupils, for example, to display only girls, or only those pupils receiving Free School Meals. A simple 'Query' option is also available. Querying the report lets you display only pupils who achieve the expected progress in one or more chosen subject(s).

Click this link Subject Progress report for a Year/class for an explanation of this option

Use this option to view, print or save to disk a Subject report, created from the columns of pupil data held in the toolkit.

Select the Year/Class and Subject from the drop-down lists, then click on the 'ceate REPORT' button, which brings up the report options box. By default, the report displays Test and Teacher Assessment levels from Foundation Year up to KS2, but you can choose to display only results for the current or previous year. Also, if available, subject targets and forecasts can be added to the report.

The report can be printed or saved, using the buttons in the toolkit panel at the left-hand edge of the window. The SAVE option copies the report to a separate Excel file, which you can then save as an Excel workbook (or in another form, e.g. just as text).

You can also sort the report on a particular column, and use the 'Group' option to report on particular pupils, for example, to display only girls, or only those pupils receiving Free School Meals. A simple 'Query' option is also available. Querying the report lets you display only pupils who achieve a particular level or test mark in the chosen subject.

Click this link Intervention Report – details of individual pupil interventions for an explanation of this option

You can use this option to view, print or save to disk the details of pupil interventions held in the toolkit.

Select either the Year/Class from the drop-down list or 'All current pupils', then click on the 'ceate REPORT' button.

Intervention report

You can specify which interventions to include in the report, with options to view on-going or completed interventions and those for a particular subject. The report can be printed or saved, using the buttons in the toolkit panel at the left-hand edge of the window. The SAVE option copies the report to a separate Excel file, which you can then save as an Excel workbook (or in another form, e.g. just as text). You can also sort the report on particular columns, and use the 'Group' option to report on particular pupils, for example, to display only girls, or only those pupils receiving Free School Meals. Note that the 'Query' option is NOT available for this report type.

The 'Extra columns' button lets you add Year/Class, Intervention Frequency & time and Notes/Next steps columns to the report and highlighting is available for the Progress column. Pupil progress is calculated as the difference between start and end 'levels' and is labelled according to the type of assessment, (NC) points, num(ber), let(ter) or months for Reading age type assessments.

Note that progress in months also takes account of the length of the intervention period. For example, a change from 06/00 to 06/01 (= 1 month) over a 4 week period (= 1 month) is shown as zero progress. The pupil is one month older by the end, so the difference between the pupil's chronological age and assessment has not changed over the intervention period.

Click this link Create your own report using any of the toolkit data for an explanation of this option

You can use this option to view, print or save to disk your own report, created from the columns of pupil data held in the toolkit.

Select the Year/Class from the drop-down list, then click on the 'ceate REPORT' button. This brings up the report option box, where you select the required columns of pupil details, teacher assessment levels, test marks and levels, targets and KS2 forecasts. You can also add blank columns for your own use.

The report can be printed or saved, using the buttons in the toolkit panel at the left-hand edge of the window. The SAVE option copies the report to a separate Excel file, which you can then save as an Excel workbook (or in another form, e.g. just as text).

You can also sort the report on a particular column, and use the 'Group' option to report on particular pupils, for example, to display only girls, or only those pupils receiving Free School Meals.

A simple 'Query' option is also available. Querying the report lets you display only pupils who, for example, achieve a particular level or test mark in a subject.

Note that 'your own report' is made by adding columns (max 100), with the choice restricted to columns that contain data (for some pupils in the school).

Click this link List ALL toolkit data columns for an explanation of this option

This 'report' takes a different form to the others as listing ALL the toolkit data columns can produce over one hundred columns of pupil data ... which may take some time.

You can create this report for the pupils in a particular Year/Class, for all current pupils, or all pupils past and present. By default, the pupils are sorted by name and blank columns are omitted. For example, results columns relating to Years 4, 5 & 6 will be omitted for Year 3 pupils. However, if you wish to include every column, then tick the 'include columns' box.

When you click the 'create REPORT' button the report will be 'written' to a new Excel workbook which you can then save as a separate file.

Click this link Run a Special Report from the toolkit team for an explanation of this option

Special reports, tailor-made for your school can be supplied on request, so please let us know what you would like. A report could contain pupil details, results, targets or forecasts and include highlighting if you wish.