Using Excel to present Data

Third class worked in pairs and collected data from all pupils from 1st to 6th class. Theses were the chosen topics for the survey:

  • Our Favourite Sweets
  • Our Favourite Sports
  • Our Roald Dahl Books
Excel 17 DSC06110

Once they collected all the data, each group used Excel to record the data and then used the chart wizard to create bar charts

Excel 17 DSC06112     Excel 17 DSC06119
Excel 17 DSC06113      Excel 17 DSC06116

Each group then customised their charts by selecting different colours from the custom palette of colours and made some formatting changes to the text by increasing the size of the text and changing the font.

 

Excel 17 DSC06114     Excel 17 DSC06118
 

Comments are closed.