![[click here to go to www.learnontheinternet.co.uk]](../images/loti/lotibasic.gif){kind=small}
![[internet geography logo]](../images/logos/eyesmaller.gif) |
 |
Home Premium Activities KS3 GCSE Teachers Links Search GeoTopics Maps Ask a Geographer |
| Related links [Related links]: n Web sites related to this topic |
|
6 Billion Human Beings |
|
| GeoTopics [Geo Topics]: n factual information about geographical topics - often supported by case studies |
|
| Population |
To be able to use a spread sheet to present data
To be able to describe and explain world population growth
World population is rapidly increasing. In 1999 it reached 6 billion people. It is predicted to reach 9 billion by 2050. In this exercise you are going to produce a line graph to show world population growth. You are then going to add annotations to the graph. Finally, you will describe and explain the growth of world population.
Stage 1
To begin with you are going to produce a line graph to show population growth.
World Population Data (figures in millions - 2000 million = 2 billion)
1800 |
1850 |
1900 |
1930 |
1950 |
1960 |
1970 |
1980 |
1990 |
2000 |
2010 |
2020 |
2030 |
2040 |
2050 |
|
World Population (Millions) |
900 |
1200 |
1600 |
2000 |
2556 |
3040 |
3707 |
4454 |
5277 |
6073 |
6832 |
7562 |
8215 |
8811 |
9299 |
1) Open Excel by clicking on the Excel icon on your computer desktop. You should minimise this window first.
2) Highlight the table above by clicking the left mouse button and dragging it across the table. Then right click the mouse on the highlighted cells and choose "copy" to save all the data to the clipboard.
3) Go to Excel and paste the table into a spread sheet. You should now save this document. Save it is "population" . Click here to see an example.
4) Next create a line graph using the chart wizard:
-
Make sure the data is highlighted
-
Click
![[image - chart wizard logo]](../images/activities/population/chartwiz.gif)
( chart wizard) -
Select Line graph from the Chart Type
-
Select a chart sub type. Click "Press and Hold to View Sample" to make sure your graph displays properly
-
Click "Next" twice
-
Under the title menu - give the X and Y axis a title
-
Click the legend tab - then deselect "show legend"
-
Click "finish" - your work should look like this
- Save your work
5. Copy your graph then paste it into Word.
6. Describe your graph - If you need help highlight the line below to find out how to do this.
7. Explain the patterns on your graph - If you need help highlight the line below to find out how to do this..
Extension
How can countries attempt to control population growth?
What will be the impact of uncontrolled world population growth?