Task Two: Graveyard Demography Survivorship Tables
***Before you start this task you will be required to complete the Practice activity below.  Once completed type your name in the bottom left hand cell (right below your activity)  of the Excel worksheet, print worksheet, & turn it in to your instructor
Part A:
Practice Activity One: Parts of an Excel worksheet: Complete Activity One Alphabetize to Learn the Basics before stating graveyard demography Task Two Click on link below

http://www.forsyth.k12.ga.us/kadkins/alpha.htm

Introduction to Task Two:
The individuals will need to be divided into two groups based on the century in which they lived.  You will test your hypothesis by comparing the survivorship curves of the two groups.  The analysis is complicated by the fact that the survivorship curves for males and females are not the same (human females tend to love longer than males), so you must analyze the data for males and females separately.  The age at death (in years) of each individual must be calculated by subtracting the year of birth from the the year of death.  It may be helpful to sort the data by increasing age.  You will construct survivorship curves for a total of four groups.
Part B
Survivorship Tables: Create four survivorship tables with the information collected in Part I by using the spreadsheet program Microsoft Excel. Remember to save your data about every 5 minutes!

1. Open the your data collection Excel file from Part I. 
2. Organize your data: Sort individuals from youngest to oldest. 
3. Use the Data Menu & the Sort Function to complete this task.
4. In each of the tables change the font color in the Age at Death cell (column E) ONLY for as follows:

   Color Font	Age Interval (Age at death)
   Red	0 to 10
   Blue	11-20
   Orange	21-30
   Green	31-40
   Pink	41-50
   Purple	51-60
   Brown	61-70
   Teal	71-80
   Yellow	81-90
   Black	91-100
   Lt. Green	101-110

5. Type your First & Last Name in Cell A 29 and Print off the entire workbook when completed
6. Minimize window and begin Part C.

Part C:
Survivorship Graphs:  Remember to save your data about every 5 minutes!
    Create four survivorship rate tables by using the data collected in Part B  to fill out the survivorship rate tables located on the link below.  (Hint: your color system might help you here! After Completing the tables create four survivorship curves using the Chart Wizard Function.

Excel Graveyard Worksheet Survivorship

1. Create four survivorship curves By plotting the age intervals on the x (horizontal) axis against the survivorship rates on the y (vertical) axis.

2. Highlight your Survivorship Rate column starting with Cell F8 & click on the Chart Wizard icon.

3. Choose a Line Graph and click Next. Chart Source Data will open up. The survivorship rate data should appear as a line graph.  However, the data for the x-axis has not been identified.  Make sure the "Series" button is selected at the top of the Chart Wizard box.  Find the "Category x axis labels" title in the Chart Wizard.

4. Click on the small red arrow to the right in the Category x axis label box.  This will take you back to your graph.

5. Highlight the cells in the Age Interval Column B (But Not the Title).

6.  Click on the small read arrow again to get back to your graph.  The age intervals should now appear as labels on the x-axis. Click Next to: Chart Options. Make sure the "Title" is selected.

7. Type a descriptive title for your curve and label your x & y axis's. Click on Next when you are finished.

8.  In the final step the chart location is chosen,  Click on " New Sheet", then click Next to create your graph.

9. Drag your graph directly below your Survivorship table.  To make any adjustments to your graph, right click on the graph and choose the option you need to adjust.

10. Follow these steps to complete worksheets 19th Males, 20th Females, & 20th Males.

11. Print off the entire work book.

After Completing Parts A, B, & C Click on the DAD Activity III.