|
Storytelling using
Real Data
Spreadsheets
OLYMPIC GOLD
- Read the story
of the Olympic Gold data set http://exploringdata.cqu.edu.au/oly_gold.htm
- Look at the data
in a spreadsheet (see INSTRUCTIONS
). What patterns do you notice in the data?
- Create graphs to
analyze each of the three events: long jump, high jump, and shotput.
(See INSTRUCTIONS
).
- Think about: What
do these graphs tell you? Do all three graphs tell similar stories?
- More Olympic data
plus several other interesting data sets are available at: the Web site
of the Center for Innovative Mathematics Teaching in Exeter, England.
http://www.ex.ac.uk/cimt/data/datalist.htm
b.
OSCARS
- Read the story
of the Oscars data set at: http://exploringdata.cqu.edu.au/ws_oscr.htm
- Look at the data
in a spreadsheet (see INSTRUCTIONS
). What patterns do you see?
- Perform spreadsheet
calculations to find out the mean and median of the ages of the actresses.
Find the oldest and youngest actresses either by sorting them by age
or by using the MAX and MIN functions in your spreadsheet. (see INSTRUCTIONS
).
- Create a graph
to investigate whether prize-winning actresses are getting older over
the years.
- Think about: Did
your graph help you answer the question? What other questions do you
have? What additional information would you need to answer these questions?
- Extension: Students
could find data on the Web for the years after those in the data set
and see if trends are continuing or not.
Projects Built
by Teachers
Accessing Real
Data
©
2000 Education Development Center, Inc. (EDC)
Site updated
January 20, 2004
© M.A.S.S.,
MESPA, EDC, HARVARD, MNEP, TERC, 2000-2004
Web site developed by EDC, Center for Online Professional Development (COPE)
.
|
