Purpose

In this unit students investigate methods of travel to school, using a spreadsheet to produce data displays and investigate distributions.

Achievement Objectives

S4-1: Plan and conduct investigations using the statistical enquiry cycle: determining appropriate variables and data collection methods; gathering, sorting, and displaying multivariate category, measurement, and time-series data to detect patterns,...

Specific Learning Outcomes

- plan an investigation;
- use spreadsheets to display and analyse data
- discuss features of data display
- compare features of data distributions;

Description of Mathematics

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.

Required Resource Materials

Computer(s) with Excel Spreadsheet and Internet access

Tally sheet

Activity

#### Session 1: Getting our travel data

- Discuss what kind of data the class could collect about their daily travel to school.
- Identify variables that can be (i) counted (e.g.method of travel; number of passengers per vehicle) or (ii) measured (time to travel to school; distance travelled).
- Students help to select data to collect as a class. Collect countable data for the morning’s travel to school. Students use the tally sheet copymaster in groups to collect the data on how they travelled to school this morning.Discuss methods of collection of measured data (e.g.use of the car or bus odometer; watch to measure elapsed time, etc).
- Students collect measured data for use in the second unit.

#### Session 2: Organising our travel data

- Work on the method of travel.
- Discuss what is the best way to represent this data. Explain that we are going to use the computer to help us.
- Get small groups of students to use Excel or similar to generate a pie graph for the Travel to School data. Obviously the management of this is dependent on the numbers of computers that you have available for your class.

#### Session 3: How do we compare with other New Zealanders?

- Students from around New Zealand have also been asked how they travel to school. This data has been collected and is available on the CensusAtSchool site.
- Once the data has been collected from the site get the students to discuss how they might make a comparison with their own data.
- Once the students have decided on their approach they can be encouraged to type the data into Excel and use Excel to draw the graph(s) they need. They will need to consider the format they will enter the data in, whether they will need headings, etc. While the pie graph is the easiest to make the comparison with they may come up with other methods. One way is to convert the class numbers into percentages using Excel and then to draw bar graphs.

#### Session 4: How do we compare with the USA?

- Other students from around the world have also been asked how they travel to school. This data has been collected and is available on the CensusAtSchool USA site.
- Once the data has been collected from the site get the students to discuss how they might make a comparison with their own data. Consider questions such as:

Which of the columns of data should we take? - Once the students have decided on their approach they can be encouraged to type the data into Excel and use Excel to draw the graph(s) they need. They will need to consider the format they will enter the data in, whether they will need headings, etc. While the pie graph is the easiest to make the comparison with they may come up with other methods. One way is to convert the class numbers into percentages using Excel and then to draw bar graphs.
- Conclude with a reporting time where the students are given the chance to show their graphs and to discuss what they have found out. They will probably have compared each mode of travel between the three lots of data. Can they give reasons for any differences they have found?
- Get the students to ask their parents what was the most common form of travel to school when they were the same age ready for the next session.

#### Session 5: Has the method of travel to school changed?

- Get the students to collate their parents’ data as before.
- Students use Excel to enter the data and then compare it with the three sets used before.
- What conclusions have they reached? What factors mean that this may not be a totally valid comparison? (eg the differing ages of the parents, the fact that parents may not have lived in this area when they were young, etc).
- If you are going to go on and consider the second unit on travel immediately then you could raise questions at this point on whether the data on distance and time can be treated the same way. This leads to questions of the difference between category and continuous numeric data.

Attachments

Tallysheet.pdf35.36 KB