Jump to content

Recommended Posts

Posted

Ahh yes, silly thing is that's the column I've been paying more attention to in the summary then the % change! >.<

 

Point still stands though, I don't trust the contents of the % change column because it shows skewed figures for new arrivals.

Posted
Ahh yes, silly thing is that's the column I've been paying more attention to in the summary then the % change! >.<

 

Point still stands though, I don't trust the contents of the % change column because it shows skewed figures for new arrivals.

 

Agreed. Although I suspect it is the interpretation on the column, the figures are not skewed... ironically the issue is they SHOULD be!

Posted

The way you'd do it is to group them together, so Capita vs the rest of the market - then the rest of the market split up - then you might compare the new entries separately with each other - ie in the first year, how many did they get vs other providers.

 

The problem is your now putting your own spin on the data and your making it user specific - the key to remember is Graham has put the raw data forward. That's step one, step two will be getting a good method of adding your spin on the data and something that is accessible. It's no good me building something in BI tool if the only people who can use it are suppliers!

Posted (edited)
The problem is your now putting your own spin on the data and your making it user specific .....

errm... stats IS​ spin ;) they'd be useless data without it :p

 

As for the new entrants, i also don't agree with high % - it is undefined, so needs to be asterisked with a footnote added as it would be in accounting documents.

I'd rather see just the absolute number shown with an asterisk or highlight to indicate it's total current numbers, and the next stat to be % of total market, so it at least has some thing to compare to.

 

A good stat to monitor over time would be total schools with a new entrant, if there are more than one, and see this figure over time, assuming the supplier base keeps increasing.

 

Side note: Links to challenge detail and analysis added to First Post for quick reference.

Edited by vikpaw
painfully embarrassing typo
Posted

FYI I have taken the page down temporarily while I go back through all the steps... again...

 

There are notes plastered all over this that says this is info from the DfE, as well as the extreme difficulty in marrying up 21000 records 4 times (those darn schools open and close doesn't help!). I did say this was to be used as a rough guide, so I must admit I'm a little ticked off to see all this moaning about it.

 

I'll go back through the process from the raw data tonight/tomorrow (i'm know the process isn't perfect to date, but i'm buggered if I am gonna marry 84000 records manually... the new process should be a little more accurate ;))

 

So apologies chaps, will be back available again tomorrow for you to moan at some more ;)

Posted

Thanks @CAM (although I beg to differ, perhaps the difference between picking holes and moaning is a different in my book! ;))

 

Anyways, I have gone back through all the information and gone through the merging steps again, a huge task I might add! I have found that the process isn't flawless given that the data from all four years, plus the information in Edubase (where school details are kept) is not all there, which is what was throwing off the calculations when merging. If i had one difinitive source of information on all of the schools, this would have been easier (plus, schools have closed/opened since 2010! And will continue to close and open).

 

Upshot, the figures are much more accurate, and by comparison are aligned with other references. One my say why bother, and just used the other sources... feel free to, it is all the same data! I guess it depends on how details you actually want the data... LA and School historical level...

 

The website page will be back live again in the next 20 mins.

Posted (edited)

Update: this week I have had 3 more suppliers contact me with intent to supply responses, really great news! Big thanks to all who do who take time out to support the community with this project.

 

In other news, the survey is now available for download from the website for any school or LA who may wish to use some or all of it in their own procurements... Why reinvent the wheel! Completely free and unrestricted to use, although out of courtesy it might be nice to acknowledge it's use, but more importantly get in touch to let us know if it wad useful and how you got on with your procurement!

 

There is also a resources section for any and all free resources we discover out there surrounding data and information management.

Edited by GREED
Posted

@GREED - quick question/piece of feedback on one of the questions on the survey:

 

"Assuming you follow all Data Protection policies, where is the UK is the data stored?"

 

My understanding is that the data protection act says the data should stay in the European Economic Area, rather than the UK. For example Amazon don't have any UK data centres, but they do have them in Ireland. For reference: Sending personal data outside the European Economic Area (Principle 8) - ICO

 

The way that question is phrased definitely implies that in order for a supplier to comply with the data protection act the data should be stored in the UK.

 

Thanks,

 

Nick

Posted

Nick

 

Thanks for your feedback. I will edit this later, although the meaning will be the same. Note for suppliers, please answer this question in your own survey as appropriate (if any of you read this!!).

Posted
Might be having a couple of issues with the site after moving from 1 and 1... The buggers. Can anyone let me know if you cannot get to it in the morning... grrrrrr
Posted (edited)

Website was back that night... After a fashion... bloody 1 and 1...

 

Anyway on lighter news, I now have 2 responses from suppliers. Thank you to Rich at @scholarpack and also the guys at @schoolpod

 

I'm also expecting in the next few days responses from @JamesWeatherill at Arbor and the chaps at Schoolbase, and possibly also Advanced Learning @ProgressoGeek

Edited by GREED
  • 4 weeks later...
Posted (edited)

Update: I will begin publishing responses now. I will publish them as quickly as I can get through each response. Publications will be done based on when they were returned to me, so the superstars at ScholarPack who responded quickly and without much fuss will be first!

 

Available tomorrow at 9am (Friday 23 May) will be @scholarpack

 

This will be followed by SchoolPod, SchoolBase and Plus4Schools (a new entry!).

 

---

 

Update

@schoolpod will also be available, at 10am. ( @schoolpod I need a decent logo to use!)

Edited by GREED
Posted

Further update:

 

4 surveys will be available tomorrow. Now SchoolBase will be live at 11am and Plus4Schools at 12pm.

Posted (edited)

Ta will check that out.

 

Edit:

 

Bloody Wordpress set to GMT, not BST! All live as planned now. Cheers Ian.

Edited by GREED
  • 2 weeks later...
  • 3 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



×
×
  • Create New...