{"id":3135,"date":"2015-04-16T10:54:54","date_gmt":"2015-04-16T09:54:54","guid":{"rendered":"https:\/\/www.caspaonline.co.uk\/?p=3135"},"modified":"2015-05-20T13:35:58","modified_gmt":"2015-05-20T12:35:58","slug":"improving-your-reporting","status":"publish","type":"post","link":"https:\/\/www.caspaonline.co.uk\/managing-data\/improving-your-reporting\/","title":{"rendered":"Improving your reporting"},"content":{"rendered":"

When we’re asked to come and spend time in schools, one of the first things we do on arrival is take a quick tour of the school’s data. \u00a0It is quite common that, by the time we leave at the end of the visit, there are a few actions for the school to carry out, none of which are difficult, but all of which will make a massive difference to the school’s reporting.<\/p>\n

There is no reason why you shouldn’t do the same quick checks that we carry out. \u00a0It is astonishingly easy, won’t take long, and may well prove to be one of the most important things you can do in CASPA today!<\/p>\n

<\/p>\n

Let’s start with the detail<\/h2>\n

Reporting for the whole school, or for groups of pupils, is all based on an aggregation of each pupil’s detailed data. \u00a0So it makes sense to start here; if you have confidence in the detail, the higher level reporting begins to take care of itself.<\/p>\n

You cannot overuse the ‘Progress vs percentiles’ report<\/strong><\/p>\n

In the space of only a couple of minutes, this report can tell someone all they need to know about progress in your school. \u00a0Granted, external agencies\u00a0are generally steered towards the ‘Traffic light’ graph, but if you want to open the bonnet and really see what you’ve got, there is no better place than this report.<\/p>\n

The menu route is Data | CASPA assessment data<\/strong>, click the ‘Graphs and reports’ button at the top of the page, and select the right-hand tab ‘Progress vs percentiles’.<\/p>\n

\"10-04-2015<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

To begin with, leave the subject as the overall average. \u00a0You will see immediately whether the graph looks sensible, and whether it reflects what you might expect for the child. \u00a0Now select the next child, then the next, and so on. \u00a0As you scroll down the page, you probably need a matter of only a few seconds per child to spot anything that deserves further investigation. \u00a0What sort of things might you find, if there are any problems?<\/p>\n

In the first example below, we have a pupil whose earliest result looks, certainly with hindsight, on the high side. \u00a0Perhaps this result was provided by a previous school, or are the school’s own, but before the school had really got to know the child. \u00a0In the second, this would probably be a school that used B Squared and\u00a0didn’t set a baseline correctly, resulting in the lowest incomplete level being exported.<\/p>\n

\"10-04-2015<\/p>\n

Next, for a pupil, try selecting each subject in turn; once again, using the arrow key after selecting the subject dropdown to make it easier. \u00a0You might think this could be time-consuming, but you might give this task to each class teacher to do for their pupils, and\/or might focus on core subjects. \u00a0What this looks for is where assessments in one subject are suspect, but which might have been hidden amongst an overall average. \u00a0The example below is exactly the same child as the first image in this article (the one with the text box and arrows), which was an overall average. \u00a0So… what happened in in 2011?<\/p>\n

\"19-05-2015<\/p>\n

What would you do about these? \u00a0Once you have decided what the assessments should be, any that need changing are, if you use an assessment system, best corrected in that system and CASPA updated with a fresh export from that system. \u00a0Otherwise, you can always correct data in previous years via Data | Advanced tasks | CASPA historic data<\/strong>.<\/p>\n

So that is a quick way of checking that your data is of good quality. \u00a0What about other types of data that will enhance the types of reporting you can carry out in CASPA?<\/p>\n

How’s your Pupil Premium reporting looking?<\/strong><\/p>\n

Reporting by Free School Meals eligibility, etc is not the same as Pupil Premium because the measures are significantly, if perhaps subtly, different. \u00a0You have been able to\u00a0record each pupil’s eligibility in CASPA since September. \u00a0Do this and you instantly have extended Traffic light graphs and Key Stage reporting because one of the grouping options available is ‘Eligible for pupil premium’. \u00a0It really is that simple.<\/p>\n

\"10-04-2015<\/p>\n

 <\/p>\n

\"10-04-2015<\/p>\n

Do you have as much prior attainment as you need?<\/strong><\/p>\n

We’re often asked about how far back data should be recorded. \u00a0This depends upon your school and is often linked to key stage reporting and the expectation of three years of reporting. \u00a0For example, if your school is a Secondary school and you want three years of key stage reporting across the secondary phase, this generally means:<\/p>\n

    \n
  1. Last year’s Y11 for whom the start year (end of KS2) is 2009 and the end year is 2014<\/li>\n
  2. The previous year’s Y11\u00a0for whom the start year is 2008 and the end year is 2013<\/li>\n
  3. The Y11 cohort before the one above, for whom the start year is 2007 and the end year is 2012<\/li>\n<\/ol>\n

    This can seem a little daunting, but if you have been using CASPA a while, the data will already be there, whilst for newer users, you can make a decision about how far you go back based on the pupils you cater for and understanding what reporting you need.<\/p>\n

    Missing start and end levels<\/strong><\/p>\n

    In CASPA’s Traffic Light graph and Key Stage reporting, you will often have pupils who are missing start and\/or end levels. \u00a0This is likely since, for example, if you analyse progress from 2009 to 2014 you will almost certainly have pupils on roll now who were not on roll in summer 2009. \u00a0If they don’t have a 2009 result recorded in CASPA, those are ‘missing start levels’.<\/p>\n

    \"19-05-2015<\/p>\n

    When you hover over the summary mark, ask yourself two questions:<\/p>\n

      \n
    • Were any of these children on roll in the start year? \u00a0If yes, you must have their data somewhere. \u00a0If in an assessment system, transfer it to CASPA, or manually input via Data | Advanced tasks | CASPA historic data<\/strong><\/li>\n
    • If no, did any of the pupils arrive in the following September. \u00a0If so, most people would use the baseline recorded in the first weeks as reasonably close to where the pupil would have been at the end of the previous summer. \u00a0Record the baseline from September as the previous summer result via\u00a0via Data | Advanced tasks | CASPA historic data<\/strong><\/li>\n<\/ul>\n

      Doing this simple activity\u00a0is a one-off task, and plugs gaps in, especially, your Key Stage reporting very quickly.<\/p>\n

      Going forward, make sure all baselines for your September admissions are recorded in CASPA as their ‘current result’ during the autumn term and let CASPA automatically copy it back to the previous summer, thereby eradicating gaps in your data in the future.<\/p>\n","protected":false},"excerpt":{"rendered":"

      When we’re asked to come and spend time in schools, one of the first things we do on arrival is […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.caspaonline.co.uk\/wp-json\/wp\/v2\/posts\/3135"}],"collection":[{"href":"https:\/\/www.caspaonline.co.uk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.caspaonline.co.uk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.caspaonline.co.uk\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.caspaonline.co.uk\/wp-json\/wp\/v2\/comments?post=3135"}],"version-history":[{"count":0,"href":"https:\/\/www.caspaonline.co.uk\/wp-json\/wp\/v2\/posts\/3135\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.caspaonline.co.uk\/wp-json\/wp\/v2\/media?parent=3135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.caspaonline.co.uk\/wp-json\/wp\/v2\/categories?post=3135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.caspaonline.co.uk\/wp-json\/wp\/v2\/tags?post=3135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}