Understanding Population Pyramids

1
Understanding Population Pyramids

• In a Metropolitan Area

2
Day 1

• Reading and Constructing Population Pyramids

3
Population Pyramids
4
(No Transcript)
5
(No Transcript)
6
(No Transcript)
7
(No Transcript)
8
4
3
5
2
1
9
Analysis of the Italys Pyramid

• 1. Decline in Birth Rate
• 2. Baby Boom
• 3. Low Death Rate with increasing number of
  elderly.
• 4. More women due to a. longer life expectancy
  and World Wars (I and II)
• 5. More 75-79 yrs than 0-4 yrs. Signs of a future
  worker shortage and an overall declining
  population.

10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
How is this population pyramid different from
Italys?
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
Answers

• 1. B
• 2. A
• 3. E
• 4. C
• 5. G
• 6. H
• 7. F
• 8. D

19
(No Transcript)
20
(No Transcript)
21
Day 2

• Finding Age-Sex Statistics and Constructing
  Population Pyramids in Microsoft Excel

22
Directions for findingAge and Sex Statistics go
to www.census.gov
23
Go to www.census.gov and click on American
FactFinder
Click on PEOPLE and select Age
and Sex
24
Type in the name of the location and click GO.
25
Click on 2000
Click on Age Groups and Sex
26
Use the statistics for the columns Male and
Female
Use the Total Population
27
Age and Sex Statistics for Countries Around the
Worldgo to http//www.census.gov/ipc/www/idbpyr
.html
28
Select your country
Click Submit
29
Statistics for Males and Females
Scroll down to find the list of data and click on
Extract data from IDB Online Aggregation
Countrys Total Population
30
(No Transcript)
31
Directions for Constructing Population Pyramids
in Microsoft Excel go to www.prb.orgPopulatio
n Pyramids in Excel
32
Download the Pyramids (Excel) Print out this
Direction Page
33
Open up a Microsoft Excel Workbook and fill in
the following
Type in the statistics from the Census
Bureau for Males and Females
Type in the total population
34
Click in B2 and type in the formula
Move the mouse to the bottom right corner of B2
and when the box appears drag the box down to B19
The statistics for Males will all be negative
numbers.
35
Click in C2 and type in the formula
Move the mouse to the bottom right corner of C2
and when the box appears drag the box down to C19
36
Highlight
Go to Insert and select Chart...
37
Click on Custom Types User-defined Populati
on Pyramid Finish
38
Type in the location for the population pyramid.
39
Click on PDF Select Save as PDF
40
Day 3

• Researching a Population Pyramid Zip Code and
• Creating a PowerPoint Analyzing the Zip Code

41
(No Transcript)
42
Answers

• 1. E
• 2. D
• 3. B
• 4. A
• 5. F
• 6. C

43
city-data.com
44
Germantown, Tennessee
45
city-data.comGermantown, TN
46
city-data.comComparing Median Household Income
in Germantown, Bartlett, and Memphis
47
Screen Shot Directions

• Full Screen PDF
• Hold down Shift Apple 3.
• Select a specific part of the screen
• Hold down Shift Apple 4.

48
Yahoo or Google Maps
Find the location your wish to take a screen shot
in Yahoo or Google maps. The screen shot will be
saved as Picture1.pdf on the desktop. When you
are ready to insert the pdf into your PowerPoint,
drag the pdf from the desktop to your powerpoint
document.
49
Screen Shot for Houston High School
50
Analysis and Evaluation

• With the population pyramids displayed on the
  wall discuss the differences between the
  population pyramids in different areas of the
  county.
• Why are there differences?
• Where in the county is it wealthy? Poor?
• Where in the county is the population the
  youngest? Oldest?
• How do the suburbs differ from the inner city?

51
(No Transcript)
52
(No Transcript)
53
(No Transcript)