DATA INTERPRETATION LESSON (Years 6 & 7)

An analysis of raw data using computers

A computer based lesson which gives students the skills to use Microsoft Excel to create graphs and interpret data which they have collected
Sample data sets can also be provided

BEFORE THE VISIT:
Revise the concept of a data table
Revise the concept of a column graph
Revise your school’s computer lab protocol

MATERIALS REQUIRED FOR THE VISIT:
1 computer for 2 or 3 students
Students will need a writing implement and a book to answer questions in.
Access to a whiteboard
Teachers are requested to divide the class into the pairs or groups which will work best together.

AVERAGE DURATION:
An hour and a half for students who have not used Excel before, less for more advanced or computer literate students

SUGGESTED FOLLOW-UP ACTIVITIES:
Answer all the data interpretation questions
Repeat the lesson with a different data set
Look at other graphs and interpret their meaning
Create a 3 or 4 page report showing raw data plus interpretation and conclusions