In this unit students investigate methods of travel to school, using a spreadsheet to produce data displays and investigate distributions.
In this unit students will use Excel to enter discrete numeric data from the results of the last three New Zealand censuses into spreadsheets and generate bar graphs and pie charts. Using Excel to generate the graphs removes the complications of working with large numbers. Students will then discuss features of their graphs. The unit also gives the students the opportunity to plan and conduct an investigation. The Spreadsheet Tutorial is intended to support teachers who are unfamiliar with the use of spreadsheets.
Computer(s) with Excel Spreadsheet and Internet access
census, discrete numeric data, continuous numeric data, category data, collate, valid, validity, bar graphs, compare, investigations, percentages, pie graphs, spreadsheets, surveys, tally charts