MS Excel Spreadsheet - Pyrmont Population by Age


Population Pyramid

A population pyramid is a double bar graph used to show the structure of the population, typically showing the age/sex structure of the population. They look something like:

pyramid.gif
Source: http://www.hewett.norfolk.sch.uk/curric/NEWGEOG/Africa/sud_pyra.gif

Open and EDIT the spreadsheet file

Open the MS Excel file ‘Pyrmont Population by Age’.

Edit the spreadsheet by inserting a duplicate copy of Column A ‘Age Labels’ between Columns B & C.

Your spreadsheet will now look like:

Age_Labels.jpg

Create Bar Charts

Select the data in the cell range A1:B86. You should have selected the ‘Age Labels’ and data for all the males in Pyrmont.

Then select the Chart icon Chart_Icon.jpg .


Select the Bar Chart option and then click Next.

Create_Chart.jpg

Click ‘Next’ again to get:

Chart_Options.jpg


Tailor the Chart Title and Axis as required.
Select ‘Next’ then ‘Finish’ to insert the chart into the worksheet:

Males.jpg


Repeat the exercise to produce a bar chart of the # Females in the population.

Females.jpg

Use MS Paint & MS Word to create Population Pyramid

Use MS Word to create a table where the Population Pyramid can be constructed.

Use MS Paint to modify the charts to create the Population Pyramid shown below:

Final_Pyramid.jpg

References


Pyrmont-Ultimo Chamber of Commerce

Resources for this activity include two detailed Community Profile master databases:

· 2001 Census data for the Sydney region
· 2001 Census data for the Pyrmont suburb

ICT Skills Addressed


5 Demonstrate basic spreadsheet skills as they create, work with and modify files


Indicators
a) Use cell addresses to locate cells
b) Insert and format text, numbers and formulae in cells
c) Select a range of cells
d) Use basic mathematical operations (+, -, *, /, ^) to construct simple formulae
e) Construct formulae using absolute and relative cell references
f) Use basic functions (Sum, Average, Max, Min, Count)
g) Sort information according to desired criteria
h) Fill cell contents using commands (Fill Down, Fill Right)
i) Create appropriate charts based on spreadsheet data
j) Set a print area of a spreadsheet

NOTE: This exercise can easily be expanded to cover all of the indicators if required.

8 Demonstrate basic graphics skills to create, work with and modify images

Indicators
a) Choose an appropriate image, file format and size for a given purpose
b) Create, move, resize, reshape and crop objects

c) Change the layer order of multiple objects, eg move to back
d) Align and group multiple objects
e) Include and edit text