Jacksons+Creek

=Jackson's Creek Community Project Project, Term 2=

Task 1:
Download the following files and use the internet and the map to answer the questions.





Task 2: To what age do the people of Jackson's Creek live?
To answer this question we need to look at data about the age at death of people who lived in the area. A useful place to find this data is the cemetery. In this task you will collect and analyse data from the Gisborne cemetery.

You will be working with a partner. Together will need to collect 50 separate pieces of data (ages at death of individuals).
 * Part A: Collecting Data **
 * 1) At the cemetery choose a row of graves to begin at. One person will collect the data of __females__ and one person will collect the data of __males__.
 * 2) At each grave collect all of the data you can (name, sex, date of birth, date of death, age) and fill in the ‘Data Collection Sheet’.
 * Write your name on your **Data Collection Sheet** and hand it in to your teacher.


 * Part B: Collating Data**
 * 1) Complete the **Data Collection Sheet ** using the data you have collected. For example if you know the date of birth and death but not the persons age you can work this out using the information you have.
 * 2) Download the following **Excel Template** enter your and your partner’s data into a spreadsheet (50 in total). Only the **sex ** and **age at death ** needs to be recorded in the spreadsheet. Make sure you both have a copy.
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Save the Excel spreadsheet and place your completed work in the **dropbox.** This is on the main Project Page.

<span style="font-family: Calibri,sans-serif; font-size: 15px; line-height: 0px; overflow: hidden;">
 * Part C: Analysing Data**
 * 1) <span style="font-family: Calibri,sans-serif; font-size: 11pt; line-height: 1.5;">To help you analyse the data, we have inserted some instructions into the Excel template. Follow the instructions in the spreadsheet, typing the commands in exactly as written.
 * 2) <span style="font-family: Calibri,sans-serif; font-size: 15px;">Download the **<span style="font-family: Calibri,sans-serif; font-size: 15px; line-height: 1.5;">Questions Template Word document **<span style="font-family: Calibri,sans-serif; font-size: 15px;">from the wiki space Jackson’s Creek page, and complete the questions, using the calculations from your Excel template to help you.
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Save the Word document and place your completed work in the **dropbox.** This is on the main Project Page.