Data Handling and Google Maps

Part 2 – The Hard Bit (Handling the Data)

In part 1 I very deliberately glossed over the work required to make sense of the data presented by the Google App and how it worked inside Excel.       

The value for handling the data from this app depends on the age group and ICT expectations of your pupils.       

If you’re looking at this as a GCSE IT project, then ask your pupils to code the sheet with a VB macro and please can I have a copy?       

If – more likely – you’re looking at this and saying ‘I don’t care how awkward the data is that you start with – please give it to me so I can easily use in a spreadsheet and make a graph without too much effort’ – then read on.       

What you should have at the end of this post is a working spreadsheet you can use again and again and (hopefully) an understanding of some of the powerful string manipulation tools in Excel. I’m using 2007 but I think most of the ideas shown work in Excel 2003 and probably OpenOffice.   

Read more of this post

Advertisements

Which is best – Google Maps or BING?

Or sit on the fence and use both? 

Here’s the scenario –  You’ve persuaded your daughter that yes – she can run a half marathon, and yes she can run the Rainbows Hospice Equinox* run in 7 weeks from now. You’ve even gone out for a 10.5 mile local run with her on a Sunday morning. 

So, how do you answer the question ‘How does that run compare with the actual run?’ That should be quite easy until you see the route notes supplied include descriptions like the following 

We’ll turn left out of the farm drive… up the dirt track and over Gravel Hill… might spot a trig point… turn left down a narrow lane… 

Read more of this post