Pacific Growth Activity Sheet

Problem:

During which decade was growth the least in the Pacific Region and Why?

Computer Lab:

  1. Have students use the student sheet, Pacific Growth to make spreadsheets in the lab.
  2. Show students how to create a graph from their spreadsheet information. Help them decide which type of graph is best to display this data. (a line graph best shows how things change over time.)

Possible Spreadsheet Results:

Pacific Region Population Growth 1900-1985

Millions of People

1900

2

1910

4

1920

5

1930

8

1940

10

1950

15

1960

21

1970

27

1980

32

1985

35

Observations:

 

Notes on Making the Graph Above:


1. Highlight the information in the spreadsheet.
2. Pull down the
Options menu and choose Make chart.
3. In the
chart options dialog box click line graph.
4. On the left hand side under
Modify click each of the buttons below and do the following:

Axes

Series

Labels

General


Click OK and your graph will appear on the screen. You may need to stretch it in a certain direction to make it look accurate.

To change the shape of the graph:

To move your graph on the paper:


Created by Judy Lambert, Instructional Technology Specialist