You are not a member of this wiki.
Pages and Files
MS Excel Spreadsheet -
Pyrmont Population by Age
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:
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:
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
Select the Bar Chart option and then click
ext’ again to get:
Tailor the Chart Title and Axis as required.
ext’ then ‘
inish’ to insert the chart into the worksheet:
Repeat the exercise to produce a bar chart of the # Females in the population.
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:
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
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
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
help on how to format text
Turn off "Getting Started"