Transcript File

Directions for Constructing
Population Pyramids in
Microsoft Excel
go to:
www.prb.org
Population Pyramids in Excel
Download the Pyramids (Excel)
Print out this Direction Page
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
Click in B2 and type in the formula
Move the mouse to the bottom right corner of
B2 and when the + appears drag the box down
to B19
***The statistics for
Males will all be negative
numbers.
Click in C2 and type in the formula
Move the mouse to the bottom right corner of
C2 and when the + appears drag the box down
to C19
Highlight
Go to Insert and select
“Chart...”
Click on:
“Custom Types” “User-defined”
“Population Pyramid”
“Finish”
Type in the location for the
population pyramid.
Click on PDF
Select Save as PDF
Population Pyramids
in a Metropolitan Area
Memphis / Shelby Co. Tennessee
Helpful Hints…
A. Germantown - wealthy suburban area
B. Bartlett - older middle class suburban area
C. East Memphis - one of the older wealthiest residential areas
D. Downtown Memphis - few families, correctional center
E. University of Memphis - residential area with large numbers of
university students
F. South Memphis - one of the poorest areas in Memphis
Germantown - wealthy suburban area: There are very few people in their 20’s living in this region. The
reason for this is that this zip code has very high residential housing costs. The people who live here
usually move into the zip code so that their children (ages 5-18) can attend the public schools in
Germantown. The reason there are so few people over the age of 60-65 is that people will move out of
this area and retire in other more desirable areas.
Bartlett - older suburban area: This area is a well established zip code where many people have raised
their families and plan on retiring in the area as well. As a result the schools were much larger in the
1980’s and 90’s. In fact the schools in the area have had to surplus some of their teachers to areas in the
county where growth is higher.
East Memphis - one of the older wealthiest residential areas: This is one of the most sought-after areas
in Memphis in which to live. It is also an area with retirement facilities, which usually have more women
than men (since women do have a higher life expectancy than men).
Downtown Memphis - few families, correctional center: The downtown zip code is not the most
desirable area in which to raise a family. There are few schools, parks, or facilities that cater to children,
and the overall environment is not “child friendly.” It is an area that is better suited for young
professionals. This area also has a prison at 201 Poplar Avenue. Most people in Memphis would know
that if you say “201 Poplar” you are talking about the jail in downtown.
University of Memphis - residential area with large numbers of university students: The University of
Memphis has many students who commute to campus and do not live near the university. However, there
are enough student living on and near campus for it to show up on the population pyramid.
South Memphis - one of the poorest areas in Memphis: This zip code in Memphis has a per capita
income (1999 dollars) of $13,798. The median values of a home is only $68,900. Only 10.5% of the
population has a Bachelors degree or higher. As a result of the poverty and lack of education, the life
expectancy is lower and the birth rate is higher.
Answers
• 1. E
• 2. D
• 3. B
• 4. A
• 5. F
• 6. C
Zip Code Assignment
• Each student will be given three zip codes for a
specific Metropolitan Area.
• A population pyramid will be created in Excel for
each of the three zip codes.
• A PowerPoint Analysis Presentation will be created
for one the three zip codes.
Analysis and Evaluation for the
Metropolitan Area
• 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?
Exampl
e for
Shelby
County,
TN
Student Handout
with Questions
Population Pyramids Analysis
1.
2.
3.
4.
5.
6.
Is Arlington and Bolton: Increasing or Decreasing? Why?
Is Bartlett : Increasing or Decreasing? Why?
Sketch a Suburban Population Pyramid, e.g., Houston High, Cordova, Collierville)
Nashville : Increasing or Decreasing? Why?
Memphis compared to Nashville: What is the biggest difference?
Compare and contrast the regions of Memphis:
a. North Memphis
b. South Memphis
c. North Memphis and Shelby County
d. East Memphis
e. East Memphis (University of Memphis area)
7. Which region of Memphis is probably the wealthiest? the poorest?
8. Why does Knoxville look different from Nashville and Chattanooga?
9. Why does downtown Memphis have so many more men?
10. Why does downtown Memphis have so few children?
11. Why are birthrates so high in Cordova? so low in Eads / East Shelby County?
12. Why are birthrates so low in East Memphis?
13. Compare the following graphs:
a. Millington and Bartlett
b. West Memphis and Olive Branch, MS
c. Southwind and Bartlett
14. Explain the Townsend population pyramid.
15. Explain the Loretto, TN population pyramid
PowerPoint Analysis
Handout, Web Sites, & Example
Student Created PowerPoint for a
specific Zip Code
• Information for each slide…
•
•
•
•
•
1- Introduction slide
2- Map
3- Population Pyramid
4- Table Showing Statistics
5-8- Pictures and Maps of the area (This is the minimum,
more slides can be used.)
• 9- Conclusion slide
• 10- Source slide
www.usnaviguide.com
www.brainyzip.com
www.brainyzip.com
Census
Bureau
Median
Household
Income
In
1999
city-data.com
Germantown, Tennessee
city-data.com
Germantown, TN
city-data.com
Occupations in Germantown, TN
city-data.com
Comparing Median Household Income in
Germantown, Bartlett, and Memphis
Using Google Earth or Yahoo Maps
Yahoo Maps or Google Earth
Find the location you wish to take a screen shot in
Yahoo Maps or Google Earth.
•Screen Shot Directions:
•Full Screen PDF:
•Hold down: Shift + Apple + 3.
•Select a specific part of the screen:
•Hold down: Shift + Apple + 4.
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.
Screen Shot for Houston High School
Example PowerPoint
1
2
3
4
5
6
7
8
9
Sources
The Census Bureau Web Site
City-Data.Com Web Site
Google Earth
Population Reference Bureau
USPS Zip Codewww.usnaviguide.com
10