Y9 Computing‎ > ‎COM 9.3 Modelling‎ > ‎

COM 9.3.3 Charting sports results

Learning question(s)
  • What are the benefits of using a spreadsheet to calculate numbers?
  • How can a spreadsheet be used to make numbers easier to understand?
 Mins Activities Teacher Notes Resources
 1: Carry out tasks on projector screen.  Welcome
 2:Download the results for 13 March with formulas and fully update it with the results to 19 March. 

Follow the instructions at the top of the results table and add the screenshots to the Evidence Document PowerPoint you began last week.
 English Premier League results 13 March 2017 with formulas

 English Premier League results 13 to 19 March 2017
 3: Extension: 2017 Red Nose Day is raising money to beat malaria. Use the skills you have learned to make a report showing:
  • how much the rates of malaria have changes worldwide
  • which countries have had the greatest success in beating malaria
  • any other interesting statistics you can discover from the data.
  Worldwide malaria rates 2005-14
 4:   
 5:   
 6:   
 7:   
 8:   
  Review lesson