THERE ARE OVER 6 BILLION PEOPLE alive today! In the next 50 years the number will rise to over 9 billion. But one fifth of the world's population does not have enough to eat.
This exercise is to help you understand how and why the worlds' population is changing. We will be looking at statistics for two countries, India and the UK.
Part one teaches you how to use a spreadsheet to discover how fast population is growing in two different countries, and in the whole world.
Part two introduces you to population pyramids.
Part three is a quiz to see how much you have learned.
Part four At the end of the exercise you will hand in a word-processed document containing a variety of graphical presentations and a written description of your findings.
Click
on the 
sign
if you require help!
HOW FAST IS THE WORLD'S POPULATION GROWING?
Step: 1 Draw a bar graph to show the changing population of India
1)
Start Excel by clicking on the Excel
icon on your computer desktop. You may need to reduce the size of your
Internet Explorer window first.
2) Copy the table below by clicking the mouse button and dragging across the table. Right click the mouse on the highlighted cells and choose "copy" to save all the data to the clipboard. This can take some practice!
India data* (figures in thousands)
|
1950
|
1960
|
1970 |
1980
|
1990
|
2000
|
2010
|
2020
|
2030
|
2040
|
2050
|
|
|
Population
of India
|
369,880
|
445,857
|
555,043 |
690,462
|
850,558
|
1,017,645
|
1,182,171
|
1,340,865
|
1,484,847
|
1,607,752
|
1,706,951
|
3)
Paste the selection into a new Excel sheet.
4) Draw
a chart to show India's population growth by highlighting all the data
cells and clicking the chart wizard button
5) Select a clustered column style bar chart and click "next"
6) Complete the boxes to add the labels for
the axes.
7) Click "next" and then "finish".
You
can change the size of the font used for the axes labels by clicking on
them and making changes in the format axis box. You can investigate other
options to change colours to the bars etc.
8) Finally, save your work and go on to step 2 below.
Step
2: Draw two more bar graphs to show the changing population of the UK
and the World
Now make two more bar graphs to show population change in the UK and the World using the figures below. Don't forget to save the finished graphs!
UK data* (figures in thousands)
| 1950 | 1960 | 1970 | 1980 | 1990 | 2000 | 2010 | 2020 | 2030 | 2040 | 2050 | |
| Population of UK | 50,127 | 52,372 | 55,632 | 56,314 | 57,507 | 59,247 | 59,956 | 60,177 | 59,430 | 57,251 | 54,116 |
World data* (figures in thousands)
| 1950 | 1960 | 1970 | 1980 | 1990 | 2000 | 2010 | 2020 | 2030 | 2040 | 2050 | |
| Population of the world | 2,556,000 | 3,039,451 | 3,706,561 | 4,453,778 | 5,276,991 | 6,073,105 | 6,831,731 | 7,562,050 | 8,214,713 | 8,810,692 | 9,298,542 |
*Source: US Census Bureau
Step
3: Copy your three bar graphs from Excel into a Word document
Cut
and paste each of your bar graphs into a new Word document. Save your
work and then go on to part two
