PYRAMID

=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:

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:



//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 __N__ext.



Click ‘__N__ext’ again to get:



Tailor the Chart Title and Axis as required. Select ‘__N__ext’ then ‘__F__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:

=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// b) Insert and format text, numbers and formulae in 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) j) Set a print area of a spreadsheet
 * a) Use cell addresses to locate cells**
 * c) Select a range of cells**
 * i) Create appropriate charts based on spreadsheet data**

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

//Indicators// 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
 * ===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