How to Create a KS2 to KS4 Transition Matrix (as per RAISEonline)

Earlier this week I was asked by a school if SIMS could create a transition matrices to show expected progress between KS2 and KS4. A lot of secondary schools have asked about this, which is also referred to as ‘three levels progress’. Here’s the video demonstration I created:

Notes:

1. The final tracking grid created in the demo can be refined by adding colours (red for pupils not making expectations, green for pupil who are exceeding expectations). Tracking grids can also show ‘summary columns’ giving the percentage of pupils above, on and below expectations.

2. Tracking grids are easily amended to show the more challenging ‘four levels of progress’.

3. The group filter on the grid allows schools to analyse their FSM, pupil premium, SEN pupils etc.

Six Ways to Measure Pupil Progress in Primary Schools

With Ofsted putting more emphasis on the progress pupils make between key stages it’s more import than ever that schools have easy access to raw progress data. In this article we’ll have a look at the different definitions of progress and I’ll demonstrate some marksheets that help you calculate this data.

Measuring Progress

1) Progress Between KS1 and KS2

The DfE minimum target for schools is that pupil should make 2 whole levels of progress between KS1 and KS2. Most schools interpret this as 6 sublevels progress, or 12 points progress (each sublevel counts as 2 points). This progress is often referred to as ‘national expectations’. But for an increasing number of schools (perhaps the majority) 12 points is no longer seen as enough. Hence 14 points of progress and, occasionally, even 16 points of progress (where KS1 results were seen as too low) are required by some schools.

2) Progress Since Last Year

This measure is used to show senior managers how much progress a group of pupils have made since the end of the previous academic year. Typically, this information will be used during staff performance management meetings.

3) Progress to Personal End of Key Stage Target

Some schools use 12, 14 or 16 points to set targets for their pupils. Other schools might use FFT estimates to inform a target. Some schools increase a target where the pupil starts to consistently exceed expectations. Hence it is useful to know how much more progress pupils need to make to attain their end if key stage target.

4) Progress over the last 12 months

For new senior managers it can be useful to highlight the autumn to autumn, and spring to spring or summer to summer 12 month progress.

5) Progress in English and Maths

One of the measurements a school is often asked to make is “how much progress is made in English and Maths combined?” – where the English grade is a straight average of reading and writing.

6) On Track to Make Required Progress

If you want 12 points of progress by the end of year 6 how much progress should you expect by the end of year 3. Or by the spring term of year 5? Most schools have expectations of progress by the end of each year and even by the end of each term. The expectations for each term or year can be compared with the actual progress made to create traffic light indicators.

Using Assessment Manager to Show Progress

Using a well designed Assessment Manager system should make all these progress measures easy to calculate. Here’s a screenshot from one of our School Analytics marksheets:

MeasuringProgress

  • Column A: Indicates the progress required to reach the pupil’s target (in this example, its an end of term target)
  • Column B: The progress the pupil has made since the previous keystage (in this case, since KS1)
  • Column C: How much progress the pupil has made since the end of the previous academic year
  • Column D: traffic lights to indicate is the pupil on track to attain their end of key stage target.

Note: Assessment manager lets right-click the column headings to get a full grade distribution so you can tell what percentage of pupils have made 2,3,4 or 5 points of progress.

Here’s an example of an ‘on track analysis‘ (click image to enlarge). This example is comparing KS1 results with the latest Year 5 autumn term teacher assessments.

On_Track_Analysis

  • Column A: Automatically calculates the KS1 English Grade
  • Column B: calculates the most recent term’s English grade
  • Columns C: Calculate the points progress made since KS1
  • Column D: The number ’2′ indicates pupils who are on track to make 12 points progress in English and Maths.
  • Column E: The number ’2′ indicates pupils on track for L4+
  • Column F: The number ’2′ indicates pupils on track for L5+

Note: As before, assessment manager lets right-click the column headings to get a full grade distribution so you can tell what percentage of pupils have made 2,3,4 or 5 points of progress.

 

Video: the new pupil teacher view in SIMS


Another new feature of the Spring 2013 release is the pupil teacher screen. Better use of the screen and the new attendance interventions graph are the stand-out features. By the way, the intervention graphs can also plot behaviour and attainment points, as well as attendance percentages – though not (yet) national curriculum points.

Video: New SIMS Discover Configuration Utility


Here’s a quick demo of the new Discover Administration utility (you might want to expand it to full screen). The re-vamped ‘configuration utility’ (as it was originally called) is more user friendly and adopts a step-by-step wizard approach to creating Discover graphs. A further refinement, allowing the bulk creation of graphs, it is slated for the summer release.

Using the New ‘Pupil Premium’ Filter

The New Pupil Premium Filter

The New Pupil Premium Filter

The Spring 2013 release of SIMS includes the new pupil premium filter. With each pupil attracting £600 of extra income for schools, Ofsted are keen that schools can prove that the money is being spent well. From Ofsted’s pupil premium guidance document:

“School leaders, including governing bodies, should ensure that Pupil Premium funding is not simply absorbed into mainstream budgets, but instead is carefully targeted at the designated children. They should be able to identify clearly how the money is being spent.”

The new filter is available not just in marksheets, but also in analysis grids and tracking grids. The pupil premium filter has simply been added to the list of existing filters – just tick the box and click ‘Apply’. Remember: it’s easy to see the children who don’t receive the pupil premium. Just click the ‘exclude’ button first, then tick the pupil premium option and click ‘apply’.

The majority of pupils receiving the pupil premium will be eligible because they have been deemed eligible for free school meals (FSM) at some point in the last 6 years. Because many schools won’t have this eligibility data (so-called ‘FSM Ever 6″) the DfE have published the information online as both a spreadsheets and as a SIMS import file (CTF). You’ll find more information from the DfE about this data and how to download it here.

Capita have also provided a SIMS report (Reports | Run Report) called ‘DFE FSM Ever 6′ – a different version for each school census. You can run this report to help you identify your premium pupils, and add to the list children who qualify for pupil premium for other reasons (eg looked after, children of service men/women etc)

PupilPremiumAdditionalInformationTo populate the pupil premium data field open up the pupil record and navigate to section 9 ‘Additional Information’ (see screenshot). Place a tick in the relevant box. Alternatively you can use the bulk update option (Routines | Pupil | Bulk Update).

Using the new ‘Median’ summary in marksheets

New Median Summary

New Median Summary

The Spring 2013 release of SIMS introduces a new ‘median’ and ‘median grade’ to each summary rows. To see the median, simply click the ‘Summary’ button at the top of any marksheet to display the summary rows towards the bottom of the marksheet. Any column that shows a number or a grade will now also show the median value, alongside the existing mean (or average) summary.

If you’re a non-mathematician (like me) you’ll probably need a bit of help with the definition of median. As I understand it, you can use the mean value when the data is evenly spread. But a few unusual results (outliers) can skew the mean, making it unreliable. The median is just the middle value of a set of results and is not skewed by exceptionally high or low results. The DfE have a good definition of the difference here.