post

Data Analysis Spreadsheet for Edexcel Higher Maths Nov 2010

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

Amplify

post

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

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!

Amplify
post

Slumdog Pythagoras – Minimally Invasive Education

Inspired by Sugata Mitra at the SSAT National Conference I decided to try and ape his ‘minimally invasive education‘ within my own Maths classroom.

In a really tough December week this two hours shone out as a great teaching and learning experience.

Before going any further, please head over to my previous post to read about the inspiration for this lesson.

In a nutshell, Sugata discovered that children can teach themselves with the aid of the Internet.  His hole-in-the-wall experiment inspired the book that inspired the film Slumdog Millionaire.  He has since been investigating how to apply these findings in Western school systems.

I followed some basic rules that Sugata has developed.  I split the students into groups, each with a computer and then gave them a problem to solve.

The rules are simple:

  • Students were told to get into groups of their choice of around 4 children.
  • They had one laptop per group.
  • They could walk around and cheat, looking at what the other groups were doing.
  • They could move groups if they wanted to.
  • No input from me other than some encouragement and praise.

My Year 7 class (11-12 year olds) are an able group who I have done a little group work earlier this year.  I gave them a simple question:

Who was Pythagoras?

And with it, the text (but not diagram) of a typical GCSE question:

A ladder is leaning against a wall.  It is 5 meters long, the base of the ladder is 3.5 meters away from the wall.  How far up the wall does it reach? [Read more...]

Amplify
post

Air Sketch – iPad to Projector – Wirelessly

I’ve been trying to use my iPad in the classroom as much as possible, as a device for use in schools it is close to being perfect.  One of the drawbacks has been working out how to get what’s on the iPad to be projected onto my classroom wall.  You can connect it with the iPad VGA connector to a computer and project that way, but only a handful of apps support this.  This can apparently be expanded somewhat by jail-breaking , but I don’t really want to go there.

Then last week Wes Frier alerted me to an App called Air Sketch.  Air Sketch is a fairly simple drawing application with a killer feature, it will broadcast whatever is on the screen across your network to a webpage.  If you open that webpage in a HTML 5 browser from any machine attached to the same network you will see the iPad screen.  Any updates made on the iPad appear almost instantly on your PC or Mac.  Air Sketch was £1.79 but there is also a free option to try.

[Read more...]

Amplify
post

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

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: [Read more...]

Amplify
post

eLearning Newsletter Issue 3 – Google Maps & Earth Special

I have just completed the second edition of the SHS E-Learning Newsletter.  This issue’s focus was:

  1. Google Maps/Earth Special!
  2. MFL – Street View
  3. History – Historical Imagery
  4. Science – Tours of the World
  5. Maths – Collaborative Maps
  6. Further Reading / Ideas

Check it out here, or sign up for the next edition over on the right in the sidebar :)

Reblog this post [with Zemanta]
Amplify