Wednesday, 20 November 2013

#7y6 Unit1 How Active Am I? Lesson 6



  • LO - To understand the key features of an effective graph
  • LO - To learn how to create an effective graph using Microsoft Excel
  • Outcome - You will have created a graph - print screened it - and then annotated it


  • Look at this graph
  • There are lots of things wrong with it - how many can you spot?




  • Task 1 - Create a graph showing the results from one of your events


  • Task 2 - Make sure that your graph has:
    • Title
    • Axis Labels
    • Suitable Fonts and Colours

  • Task 3 -Take 3 print screens of your spreadsheet and paste them into Microsoft Word
    • Your spreadsheet in normal view
    • Your spreadsheet in formula view
    • Your graph

  • Extension Task:
    • Can you use what you have learned to create some new graphs of different events



  • What have your learnt in today's lesson?
  • What can you do now that you couldn't do at the start of the lesson
  • Annotate your 3 print screens to explain how you made your spreadsheet and graph



  • Hand In Homestudy Book Task 2 for marking