Here’s a way to help your senior leadership team find out about some of the interesting things you can do in Excel. I used Office 2007 for this, but I’m sure you can achieve the same in Office 2003. I find these kind of training examples are sometimes tedious, unless there’s a real purpose. But this example has got a real purpose that your senior managers will like – understanding the relationship between spend and achievement. If you can get them to do this, then I bet you’ll see charts like this popping up at lots of meetings!
Last week, I read a breakdown of local authority education budgets per pupil. (From a parliamentary answer on TheyWorkForYou). It’s a list of all of the Direct School Grants, per pupil, for all of England’s local authorities. (Because you’ll ask: London authorities account for the top 16, with Tower Hamlets top. Leicestershire are bottom)
And I wondered what the link was between spend and league tables. And 5 minutes in Excel gave me the answer:
The chart above compares each individual local authority’s Contextual Value Added score (CVA) to their spend per pupil. The trend line shows that overall, the higher the budget, the greater the CVA score. But, there are a couple of odd outliers in this chart, but you’ll need to follow the instructions below to see who they are!
Although I did it at a national level, I bet your head or deputy head would want to do it for schools in your own local authority!
Here’s my step-by-step guide to how I created the chart above.
Here’s a challenge: Who can be first to add a comment to say which way the trend line goes when you compare “BUDGET” and “5 A*-C”? (And only then will I share the SkyDrive link to my version to download)
And, as a bonus, who can improve these instructions so that you can hover over a dot on the chart, and see the name of the local authority?