Category Archives: Data

Digital good?

Interesting publications on design, technology and change for ‘good’
“I’m pulling together a list of interesting, thought-provoking reading on how design, technology and change (the three things that, for me, define ‘digital’) can help organisations that work in the community, voluntary, charity, non-profit, social enterprise type space.”

There are some interesting people in the non-profit and public sectors, with some great ideas about how technology and a more digital outlook can improve organisations and help people. Hopefully Dave’s reading list is a growing resource.

Recreating Ofsted’s Inspection dashboards

Thoughts on managing variability: School’s own data in the Ofsted inspection data dashboard
“To try to overcome some of these issues while still presenting the data in a format very similar to the official dashboard I have thrown together a spreadsheet that emulates the Ofsted layout as much as I can (given Excel’s limitations).”

This looks like a really useful resource, but I think I’ll need a fair amount of time to get my head round it all.

Visualising Wikipedia

See also – a collection of our favorite visualizations built on Wikipedia data
This is a collection of our favorite visualizations, infographics, and other projects built on open data from Wikipedia and other Wikimedia projects, curated by Stephen LaPorte and Mahmoud Hashemi.

I don’t know a great deal about the Wikipedia open data projects, but there are some great data visualisation examples here. One of them even mentions Borges, what more do you want?

So, what did you have for tea last night?

Felton Annual Report – a eulogy​
Nicholas Felton is able to sell 3,000 of his reports that show his favorite beer and quirks for $30.00 a piece. We couldn’t give away an education report–one of the most important topics–for free to the public. Clearly, we needed a new approach.

Yep, I’ve bought some of those $30 reports and regularly refer back to them. A shame there won’t be any more, but who’s to say what’s next for him.

Here’s another article on his reports, and the changes that have taken place over the 10 years he’s been doing them.

10 years in the making, Nicholas Felton files his final Feltron Report
Over this span, Felton’s commitment to his own data collection resembled an exercise in self-torture. He’s worn noisy pedometers that clicked every time he took a step, built his own iPhone app to bug him through the day to ask what he was up to, spent a year documenting every single conversation he had, and even, at one point, found himself weighing a three-year-old’s birthday cake to track his eating habits.​

Data Manager priorities?

A half day in the Life of a Data Manager
“What I wanted to ask was if you were in my situation, where should I concentrate my precious few spare hours here and there in order to get to grips with SIMs, what more it can do for me/the school, and what more my role as a Data Manager should include in your experience?”​

The responses so far seem to boil down to moving away from us analysing the data to encouraging teachers and leaders to analyse the data for themselves, by providing better tools and training. Teach a guy to fish, and all that.

More data visualisation inspiration

10 best data visualization projects of 2015
“Fine visualization work was alive and well in 2015, and I’m sure we’re in for good stuff next year too. Projects sprouted up across many topics and applications, but if I had to choose one theme for the year, it’d have to be teaching, whether it be through explaining, simulations, or depth. At times it felt like visualization creators dared readers to understand data and statistics beyond what they were used to. I liked it. These are my picks for the best of 2015.​”

Clever lists in Excel

Another Excel solution in search of a problem. I must be able to try this out on something…

Create dependent drop down lists in Excel
“Limit the choices in an Excel drop down list, by using named ranges and the INDIRECT function, to create dependent data validation lists. For example, select Fruit in column A, and only Fruit items appear in the drop down list in column B.”​

Re-mark remarks

More than 90,000 exam grades changed
“As data published today by Ofqual shows, each year over 8 million GCSE and A level grades are awarded to a high level of accuracy. Although the number of enquiries about results increased in 2015, the proportion of all grades changed was 1.1%,” said the JCQ’s director general Michael Turner.​

It may well be only 1%, but a considerable amount of time and expense goes into re-marks. Another consequence of league tables?