Tag Archives: Data

Data Analysis Spreadsheet for Edexcel Higher Maths Nov 2010

30 Replies

Edexcel admirably give you access to detailed question by question data from their Maths exams with the use of Results+.  However I have always found that it does not come in a format that is particularly useful for teachers or individual pupils.

I have created a spreadsheet that analyses the data at a class and individual level and presents both in what I hope is a helpfully colourful manner.

To use the spreadsheet you need to download the paper analysis from Edexcel for Paper 3 & Paper 4.  Copy and past the raw data into the data entry sheet and watch the magic happen on the other sheets.  The individual sheet should be sized so that you can print the data for each child on 2 sides of A4 paper.

I hope this is of use to other Maths teachers / leaders.  Please feel free to adapt / share as you see fit.

Any questions, feel free to leave me a comment here.  File here: http://db.tt/xevYyYl (data included is anonymised version of my own so you can see what it should look like).

Data Entry Sheet

Class Analysis Sheet

Individual Analysis Sheet

#LWF11 – David McCandless, Author & Information Designer – Infographics & Data

1 Reply

David is the author of http://www.informationisbeautiful.net/.

Worked through some fantastic infographics from his site, go look at them now.  Better still see his TED talk:

Some interesting insights from using Google InSights to track search terms.  Great tool for use in the classroom.

Nice talk about needing to compare proportions rather than totals, in the concept of military spending.  Love the Maths of normalising figures for population.

Take data and use it as a lense to clarify your thinking.

Like Stephen Heppel’s learners David is self-taught in his technical skills using the likes of Youtube.

What happens when you make data beautiful?  Visualisation helps make the mind envisage scale and proportion far better.  Can condense a huge amount of info into a small amount of space.

Nice graphic of the difference between the Left & Right in American politics.  Helps you to see where someone else is coming from.

Information design is about solving information problems, something we have lots of now.

Fascinating and enlightening talk – a breath of fresh air after the intense debate from previous session.  And to top it off his book is on sale at Amazon!

Gapminder Updates – Great for Maths, Science, Geography, Social Studies, History & More!

Leave a reply

Scrolling through things I had starred for holiday reading, I noticed that Gapminder.org has been updated.  I have blogged previously about Gapminder and the fantastic Hans Rosling, it is a fantastic tool for visualising a wealth of World data on lovely scatter graphs that animate changes through the years.

Watch one of Hans Rosling’s classic TED talks to see what it’s capable of:

There have been a number of great updates which can be seen in this diagram I’ve borrowed from Gapminder.org:

You can see the blog post detailing these on Gapminder, but to summarise: Continue reading →

Data Collection & Questionnaires with Google Docs & Twitter

1 Reply

Interview Reflection: Part 2:

My interview lesson was rated as ‘good with outstanding features’ and as that was in part thanks to my network I thought it only fair I shared it with the World.

I chose to teach a lesson focusing on data collection using questionnaires. A tricky lesson to get right I finally nailed it!

I feel there were two keys to the success of the lesson:…. Continue reading →