What’s new in version 6?

Version 6.1 (October 2010)

Half-termly assessment
Version 6 now supports half-termly assessments through all years. We have added input options to the data menu and there are half-termly displays available for the subject tracker and results by subject displays (the latter only appear when there is half-termly data).

Interventions
There is a new module for tracking interventions, which has a new ‘Pupil interventions’ heading on the data menu, where you can enter details and you will also find a new heading ‘Intervention report’ on the ‘Extract data from the toolkit [REPORTS]‘ section of the main menu, where you will find various options for displaying the data. We will be interested to hear how you get on with this new feature: does it need tweaking or adding to?

Overview of subject attainment/progress
You should also look at the new section under ‘Whole school view’ called ‘Overview of subject attainment/progress’ which I think is very powerful and potentially useful, but you probably need to control how much data you want to display at a time or it is a bit mind-blowing!

Other new features to note are:
-      the tracker grids now show + sub-levels when you have opted for the single point progress option
-      the addition of ‘non white’ and ‘non white British’ to the ethnicity group options
-      when you use the backup your data button, you now get a further option to upload a copy to our data transfer site, which includes a reminder of your username and password. We would like to know if this works OK because we can’t really test this ourselves.

Online toolkit manual
the button ‘View online toolkit manual’ on the main menu page, takes you to the manual on our website, which is now complete, though you can always use the ‘How to use’ buttons on each page.

Version 6.2 (March 2011)

ADDITIONS to the toolkit program
Four new program modules have been added to the toolkit.
(They were already listed on the menu but nothing happened if you tried to select them previously.)

From the MAIN MENU
> Enter DATA into the toolkit – Enter / Edit / Delete
> PUPIL details
1. IMPORT full or new PUPIL list from a computer file
2. IMPORT PUPIL ATTENDANCE data from a computer file

The two import routines (1 & 2) let you update your toolkit pupil list and attendance figures by importing the latest data from your school Management Information System. You need first to create up-to-date versions of your pupil and/or attendance files (the sort of files that you send to Roger in September for setting up your new toolkit) by exporting this information from your MIS. Importing the attendance data is straightforward but importing a new pupil list involves several different steps and can take half an hour to complete ~ there are more details about this option at the very end of this sheet.

> Enter DATA into the toolkit – Enter / Edit / Delete
> RESULTS for PUPILS  ( Teacher Assessments & Tests )
3. Phonic Phases and Other test scores for Nursery to Year 6

> READING & SPELLING AGES, PHONIC PHASES and other scores
4a. >Phonic Phases  ( Nursery to Year 2 )
4b. >Other standardised scores  ( Nursery to Year 6 )

You can now enter (3) and display (4a) Phonic Phases in the toolkit. Phases [0 to 6] may be entered either termly (plus a September starting phase) or half-termly, and the display option provides a Year/Class pupil list showing all the scores plus an individual pupil graph.

You can also create (3) two ‘other [standardised] test scores’ of your own, e.g. NFER English or Maths tests ~ you’ll need to enter a name for each score and can also specify a score range between 0 and 200. These scores can be entered termly or half-termly and are displayed (4b) in a similar way to the Phonic Phases above.

CHANGES to the toolkit program

For all those who asked for a way of recording how they created a particular display:
Toolkit print-outs now include a ‘print trail’ footer (text printed at the bottom of each page) to record the option(s) used from the MAIN MENU to create the particular display, for example,
> KS1 to KS2 Progress against National Standards  > Pupil Progress – core subjects – yearly

5. IMPORT PUPIL results from a capture sheet or computer file
The range of import files has been extended, so, as well as importing from toolkit capture sheets as before, you can import FSP scores from eProfile, KS2 results from the Key to Success website and KS1 pupil results plus overall school results from the RAISEonline website.

6. Entering PUPIL INTERVENTIONS
There is now a ‘Delete’ button if you want to rub out any of the interventions !

7. All toolkit TRACKER GRIDS
All the tracker grid displays, except the ISP Tracker, have a new highlighting feature, which uses ‘shades’ of red and green to highlight pupils in the grid according to the number of points progress they have made.

To try this out, use the ‘Highlight’ button in the left-hand toolkit panel in the tracker display.

8. All toolkit PUPIL and SCHOOL displays
The extra pupil groups ‘Non WHITE’ and ‘Non White British’ introduced in the previous version are now available in all the toolkit displays ~ use the ‘GROUP’ button in the left-hand toolkit panel and select from the ‘Ethnicity’ criteria.

Two new SPECIAL REPORTS

You’ll find these reports via MAIN MENU
> Extract data from the toolkit  [REPORTS]
> Run a special REPORT from the toolkit team   …  then open one of the files listed below

Both reports offer a quick(er) way to extract information from the toolkit with the ability to select multiple classes/subjects and then generate the report for all these at one go.

9. toolkit SPECIAL REPORT 03 – Pupil progress
Compare a Year/Class set of pupil results against an expected / target / forecast level.

For example, you can use the sort and highlight options in this report to identify all pupils with results below their target level.

10. toolkit SPECIAL REPORT 04 – Y3456 POINTS summary
Year/Class averages for KS1 to KS2 Attainment and Progress in NC Points, with results broken down by pupil groups (such as FSM, SEN) and ethnic groups (>= 5% of pupils). End of year results are displayed for previous school years and termly results shown for the current school year.

IMPORT full or new PUPIL list from a computer file (more details)
The import procedure is broken down into six separate steps, with the option to stop the import and quit after each one.

Step 1        Import the Pupil list from your file
Step 2        Check for any new classes
Step 3        Check for duplicate UPNs; Check for identical Pupil names
Step 4        Confirm NEW JOINERS and LEAVERS
Step 5        Assemble the new toolkit data file
Step 6        Save the new toolkit data file

Care and attention are needed throughout to ensure the import is successful. After identifying the file to import at Step 1 you may be asked additional questions at Step 2 if new classes are found. Beware, an existing class may be wrongly identified as ‘new’ because the class name used in the import file (e.g. 1BH) differs from the name set up in the toolkit, (e.g. Y1 Beech). If this happens you are able to override the toolkit’s attempts to match the class names automatically and will be asked to specify the names yourself.

At Step 3 it is very unlikely that duplicate UPNs will be found but you may need to deal with identical pupil names. Each pupil must have a unique name in the toolkit, so you will be asked to modify the pupil names if two or more pupils have the same one. It is your choice how you do this, for example, by adding the pupil’s middle initial, date of birth or school year, such as

AARDVARK Arthur [Y1]  and  AARDVARK Arthur [Y5].

Step 4 is the key step where you will be asked to check and confirm which (if any) pupils are new joiners and which leavers. The toolkit attempts to do this automatically, by matching the pupils in your new pupil list in the import file against those in the existing (old) toolkit data file. However, this automatic process isn’t foolproof, as a pupil’s UPN and/or name may change between the old and new files, causing the toolkit to mistakenly identify a pupil as a new joiner or as a leaver when in fact they are at school all the time!  So it is important that you double-check the toolkit lists of new joiners and leavers at this step, and you can if necessary override the toolkit and match the pupil names yourself.

Assembling the new toolkit data file at Step 5 can take a long time but it doesn’t involve any more questions, so you can take a break from the computer screen at this point if you wish. (You can get a good idea of how long from the counter showing the number of pupils ‘assembled’ on the screen.)

The final Step 6, saving the new toolkit data file is relatively quick and it is ready for use immediately. Note that a back-up of your existing toolkit data file (i.e. your data file prior to importing the new pupil list) is made automatically. So if any problems emerge with the new data file, you can use the toolkit ‘Restore’ option to go back to the earlier pre-import file.

Posted in Reference | Leave a comment

Educational consultants who are experienced toolkit users

I know there are now some Educational Consultants around with considerable experience of using the toolkit. This page is intended to give them an opportunity to outline their experience with the toolkit and the services which they offer. Any consultant who has toolkit related services to offer can use this page to add their details – just click on ‘Leave a comment’ below, then type in your notes and click the ‘Post a comment’ button. Alternatively you can email me and I will add your comment.

Posted in Reference | 2 Comments

How did you use the toolkit when Ofsted came?

I thought it would be useful if users could share some of their experiences when using the toolkit during an Ofsted inspection. I know that post inspection is not the best time to ask anyone to write up their experiences, but even brief notes (which displays did you find most useful? Ofsted’s reaction? etc) would, I’m sure, help others…

You can add any notes by clicking on ‘Leave a comment’ below, then type in your notes and click the ‘Post a comment’ button. Alternatively you can email me and I will add your comment.. Who will start us off?

Posted in Reference | 3 Comments

How to back-up your toolkit data file in version 6

Version 6 of the toolkit now includes a facility to post the backup of your school’s DATA file to our data transfer site. Here is how it works (the first part is unchanged from the previous version):
1. Run the toolkit as usual and bring up the MAIN MENU.
2. In the buttons at the right-hand side, click ‘Back-up/restore your data’.
3. Choose the default option ‘Back-up your data’ by clicking ‘OK’.
4. You will then see a standard Excel file save box, which will save a back-up copy of your data file, called toolkit DATA 2011 for ‘Your school’s name’ & ‘today’s date’. By default, the file is saved in the ‘toolkit BACKUPs’ sub-folder of the main Primary Progress toolkit 2011 folder, but you can save the file anywhere, e.g. on the desktop or in My documents, the important thing is to remember where you saved it, as you will need to be able to find it to upload it.
5. After saving, you get this dialogue box:
Backup data to web dialogue box
6. You now need to click on the button ‘Go to the file transfer site’ which should load your browser and take you to the log-in page where you need to enter your Username and Password, which are listed in this dialogue box to save you searching for them.
If your browser does not load, it will most likely be because your security system is interfering, in which case you need to get this unblocked by your IT support, because we use this site all the time.

You can log directly into the data transfer site at https://www.primaryprogresstoolkit.co.uk/login.htm. Once logged in, you need to follow the procedures for adding a document. See the post “Using the PPT data transfer site”.

Posted in Procedures | Leave a comment

How do I update a colleague’s toolkit with the data from mine?

If your colleague’s toolkit is on a laptop or another desktop computer you will probably find it easiest to use a USB memory stick to make the transfer. Here is the procedure to follow:

1. start the version of the toolkit from which you want to copy the DATA file

2. click the ‘copy your toolkit files’ button on the main menu page

3. make sure that ‘DATA file only’ is selected and then click the ’copy files’ button

4. in the dialogue box which opens, navigate to the USB stick

5. check that the name of the USB stick appears in the ‘Save in’ box at the top of the dialogue box and the name of your school’s DATA file is in the ‘File name’ box at the bottom then click Save

6. an information box appears, which sets out the name of the file, where it is being copied from and to and warns that if there is a DATA file there already it will be replaced by the file which you are copying: if this all looks in order, click OK and wait for the copy completed box to appear, then click Finish.

7. now all you have to do is copy your school’s DATA file to the ‘toolkit DATA files’ sub-folder of the main ‘Primary Progress toolkit 2011′ folder on your colleague’s laptop or desktop computer

8. if your colleague’s toolkit is on a USB stick you can copy the DATA file directly into the toolkit – at step 4 navigate to the ‘Primary Progress toolkit 2011′ folder on the USB stick and double click on the ‘toolkit DATA files’ sub-folder, then check that ‘toolkit DATA files’ appears in the ‘Save in’ box at the top of the dialogue box and the name of your school’s DATA file is in the ‘File name’ box at the bottom and click Save

Posted in Procedures | Leave a comment

Let Excel do your counting for you

While helping a school complete a return for their LA, I found that I needed to work out the numbers involved as well as the percentages. The toolkit will usually be able to calculate the percentages for you, but sometimes you need to work out the numbers yourself. This is where Excel’s built-in counter comes into its own but not everyone seems to know about it!

This is how it works:

- look at the bottom right hand corner of your Excel screen, which looks like this, if you have number lock on "Excel right hand corner"

- now right click in one of the boxes to the left of NUM and you should get this pop-up menu "Pop-up menu"

- as you can see, you can set this to do various things, but here you need to select count.

Now lets try it in action with the toolkit. Suppose you need to report on the number of pupils who gained two levels of progress in last year’s KS2 tests, out of the possible number, as well as the percentage.

From the toolkit main menu, select >Predict or analyse KS2 results, then >Pupil KS2 Targets, Forecasts, Results & 2-Levels Progress,  select last year’s Y6 and then click the button ‘switch to 2-Levels Progress’, in the blue left hand margin.

If you are good at mental arithmetic, you can work out the numbers quite quickly from the summary box which pops up, but lets see how Excel can help. Look at the English columns: you can read the percentage from the top of the column but to count the numbers easily, you first need to sort the table: click the ‘sort table by’ drop down menu at the top left and select ‘Eng ~ Result progress’.

Your table should now be sorted by levels of progress in English, with 3 or more at the top and any pupils who don’t have a progress calculation (no KS1 result?) at the bottom.

To count the total number of pupils who do have a calculation, click in the first progress cell at the top, hold down the mouse button, and drag to the last cell which shows a progress calculation – now look in the box in the bottom right hand corner of your spreadsheet and you should see ‘count = whatever the total is’.

Then, to get the number who gained two levels of progress, repeat but only drag to the last cell which shows 2 and read off the number from the box in the bottom right hand corner of the spreadsheet.

Once you have got the hang of this Excel feature, you will find that it is very useful in all sorts of situations – for counting, totaling, working out averages etc – and you can drag sideways as well as down.

Posted in Procedures | Leave a comment

Progress toolkit POINTS and LEVELS

Alan has created a neat little table (see below) which summarises the default way in which the toolkit links NC points with NC levels, P scales and FSP points. I thought that many of you might find this useful as a concise aide-memoire. Our fuller rationale for this system is available for download from the Documents page on this blog or from the ‘toolkit useful documents’ folder on our data transfer site.

Progress toolkit POINTS & LEVELS

Posted in Reference | 4 Comments

How do I create a data capture sheet for point of entry to Reception?

Here’s what you need to do:

- from the Data menu, click Results for pupils, then Data capture sheets

- on the form which opens, choose 1) Reception, year or class; 2) Foundation Stage points (or Development matters); 3) Reception Autumn A i.e. the start of the autumn term, Autumn B being the end of the autumn term; 4) worksheet (or ticklist)

- once you have saved the data capture sheet and left it open, you can click the button ‘Foundation subjects’ at the top to modify your selection, if you don’t want to enter data for all columns,

Posted in Procedures | Leave a comment

How can I get the APS progress for each class in Reading Writing and Maths for last year?

One customer sent me this question recently and I am posting my reply here because I think others may find the answer helpful.

I think you will find the Progress Grid most useful for this. You can access the Progress grid from the ‘Progress against National Standards’ sub-menu of either the KS1 or KS2 sections of the Main Menu.

You can choose either year groups or classes and any subject for which there is data. Once you have selected these, click on the ‘Calculate progress’ button, which will open a dialogue box in which you can choose the start and end points for the calculation (say last summer
and this summer). From the resulting table you will be able to see the overall progress, in points, for the class/year group at the top, but also the progress for each band by level, so you can see how your level 3s have progressed against level 2s etc.

At the top, you have options to highlight progress and switch from numbers of pupils to percentages.

In the left hand blue panel, you have other options; to change the highlighting to a particular level of progress, switch between TAs and tests, calculate progress for groups (e.g. SEN) and produce a list of pupils so that you can check individual levels of progress. These pupil lists can also be sorted in various ways.

Posted in Procedures | Leave a comment

To create and use a data capture sheet

    1. Run the toolkit as usual and bring up the MAIN MENU.

    2. Choose the top section ‘Enter data into the toolkit’
    You will be asked for the data entry password, enter it and click OK.

    3. You can create Data Capture sheets for any of the top 3 items, Pupil details, Targets and Forecasts, or Results for pupils. Clicking on any of these options will produce a sub-menu with two options, highlighted in black, in the TOOLS section at the bottom: DATA CAPTURE SHEETS and IMPORT…

    4. The procedures are the same for each type of data capture sheet: in this section, I assume you have chosen the DATA CAPTURE SHEETS option in ‘Results for pupils’ to create a blank sheet to enter assessments in.

    5. You now need to specify the data capture requirements:

  • the Year or Class
  • TAs (or Targets/Tests etc)
  • When – the assessment date (e.g Year 1 Autumn);
  • and finally how to enter the data – we recommend ‘Tick list’ which is much the quickest and easiest for teachers but some prefer ‘Worksheet’.
    6. Click the button to ‘Create DATA CAPTURE sheet’ and then, if OK, save the capture sheet. (By default it shows only Reading, Writing & Maths but you can choose more or less subjects to enter data for, when you use it.)

    7. Remember where you save it, as it is this capture sheet which you give to your
    colleagues for them to enter their pupils’ data. For example, you could save it
    directly on a USB memory stick for them to take away, or on a shared network area (e.g. Autumn assessments).

    8. After creating one sheet, you are given the opportunity to create more or finish.

To use a DATA CAPTURE sheet

  1. Simply open it (on its own) in Excel (it works completely separately from the toolkit).
  2. Enter the data, click the SAVE button in the left-hand panel to save the data and when you’re done close it.

To get the information from a CAPTURE sheet into the toolkit

  1. Run the toolkit as usual and bring up the MAIN MENU.
  2. Choose the top section ‘Enter data into the toolkit’. You will be asked for the data entry password, enter it and click OK.
  3. Choose the appropriate section e.g. ‘Results for pupils’ and select the option ‘IMPORT pupil results..’, highlighted in black, in the TOOLS section at the bottom.
  4. You then need to tell the toolkit what sort of file to import and its name. So choose the first item in the drop-down list, ‘toolkit DATA CAPTURE file’ and click the IMPORT data button. A standard Excel File/Open box appears and you’ll need to locate and open the capture file you want to import.
  5. You are asked to confirm that you want to import this data before going ahead, check that the entries look OK and if so click ‘Import’, otherwise you can click ‘Cancel’ and abort the import.
  6. On completion are asked if you wish to import data from more files or finish.
  7. That’s it !
Posted in Procedures | Leave a comment