• Dave Foord
  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,641 other followers

  • Dave Foords Twitter

    • RT @greenfieldscc: after one loan player for our twos tomorrow @landrcl can anyone help? 5 days ago
    • Looking out the window and reminding my self that we are 3 days away from the ‘middle of summer’ 1 week ago
    • On my way to London, to look at potential of Moodle being used by a client to create a mobile friendly gamified sport development activity. 2 months ago
    • Heading up North, where I will be spending at least a week working on a huge Moodle migration project with a client. 3 months ago
    • RT @CharnwoodPE: 🏃🏻‍♂️🏃🏻‍♀️ - The 3 Charnwood medalist’s from the @dretsport Cross Country Cup! Harry Foord 1st 🥇, Colin Foord 2nd 🥈, and E… 3 months ago
  • Advertisements

Using Excel to Play Golf on the Moon

I am currently working on my ITQ in accessible practice and whilst planning a session for the Excel unit of this, it reminded me of a resource that I created many, many years ago and look back and realise that it is still a really good resource.

Screen Shot of the golf gravity resource

Golf Gravity

The resource came about because I was teaching biomechanics at level 3 and 4, and one of the criteria was for the learner to understand the impact that gravity had on the flight of an object (e.g. a ball). The problem with this is that I don’t have the ability to turn gravity off, and as the college wouldn’t pay for me to build a rocket and go to the moon, I created a simulation – which you can see below.

In essence you can alter the velocity (speed) that the ball is hit, the angle and the planet (or moon to be technically correct) that you are playing on (which thus alters the gravity). The beauty of this resource was that I could use this with different levels of learner, just by using different questions sheets.

This was created in Excel, using some simple (well simple for someone like me that likes biomechanics) and plotting a graph, and shows how Excel can be used to create effective teaching and learning resources.

Golf Gravity resource

Creative Commons License
Golf Gravity by Dave Foord is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 2.0 UK: England & Wales License.
Based on a work at http://www.a6training.co.uk/resources/golfgravity.xls.