Unformatted Attachment Preview
Biology Lab
Human Demographics Lab
Lab Instructions
Welcome to your Human Demographics Lab! In this lab, you will be comparing two different
populations in a cemetery from a particular community. Specifically, you will be comparing
male and female populations over a set period. The data have been previously selected for
you from the Trinity United Church of Christ Cemetery in Telford, which is located in Bucks
County, Pennsylvania. You will be creating both a demographic table and a survivorship curve
from this selected data.
Time to get started!
Please make sure you read over the entire set of instructions BEFORE starting this
Laboratory Investigation.
This lab comprises several parts:
1) Organizing the birth years and death years and calculating the age of death statistics
2) Calculating the percentage of survivors for each age range for both females and males
in the given population
3) Constructing a graph with survivorship curves of the given female and male populations
by plotting age group versus percentage of survivors
4) Analyzing your data and survivorship curves to answer conclusion questions
HUMAN DEMOGRAPHICS LAB DATA WORKSHEET PART 1
Directions:
1) You will begin your lab by first creating your Demographics Data – Table 2. You will
begin this recording the death year and birth year of both male and female individuals in
the selected population. This information has been already provided for you in the
Demographics Data – Table 1. Using that information, you will calculate the age of
death for each individual. To complete this part of the lab, you must:
a. Print out the Human Demographics Lab Data Worksheet Part 1
(Biology_Human_Demographics_Lab_Support_Doc1_Lab1) document.
b. Follow the directions in the Data Worksheet Part 1 on how to complete your
Demographics Data – Table 2.
c. This portion of the lab will not be turned in, but you will be referring to this
document in order to complete your Survivorship Data Tables and Survivorship
Curve Chart.
HUMAN DEMOGRAPHICS LAB DATA WORKSHEET PART 2
In the second portion of your Human Demographics Lab, you will be using the data you
collected in your Data Worksheet Part 1 to create two Survivorship Data Tables and a
Survivorship Curve to represent the relationships between the percentage of surviving
individuals in the observed population of males and females.
Creating the Survivorship Data Tables
Directions:
1. To get started, make sure you have the data you collected in Demographics Data –
Table 2 of your Human Demographics Lab Data Worksheet Part 1 readily available.
2. Next, print out the supporting document Human Demographics Lab Data Worksheet
Part 2.
Data Report: Biology_pt2_Lab_Support_Doc2_Lab1
In this document, you will calculate data for a table for both males and females and
categorize by age group, number of deaths, number of survivors, and percentage of
deaths. These data tables must be uploaded into the Human Demographics Final
Lab Report, which will be turned in as a typed document in Microsoft Word.
a. Follow the directions in the Data Worksheet Part 2 regarding how to complete your
Survivorship Data Tables A and B.
b. Transfer the data from both Tables A and B directly into your Human
Demographics Final Lab Report. Handwritten data will not be accepted and will
earn zero credit. You will turn this in for credit once the lab is complete.
Creating the Survivorship Curve Chart
Directions:
1. Before you begin this portion of the lab, type a hypothesis on what you think the
survivorship curves for the females and males in your given population will look like and
how they will compare. You must support your hypothetical statement by explaining
why you think this. Type this directly into your Human Demographics Final Lab
Report.
2. In the next section of your Human Demographics Lab, take the information from your
Demography Tables A and Table B and create a Survivorship Curve for each on one
chart.
a. To do this, follow the detailed directions given in the second part of your Human
Demographics Lab Data Worksheet Part 2 document. A clickable chart has
already been set up for you in this document. This chart will allow you to insert your
pre-recorded information into an Excel document and create survivorship curves to
show the relationship between your male and female populations.
b. Transfer your completed Survivorship Curves Chart directly into your Human
Demographics Final Lab Report by copying and pasting the entire chart. You will
turn this in for credit once the lab is complete.
Answering the Conclusion Questions
Directions:
1) After you have created your survivorship curves for both your female and male
populations, please answer the conclusion questions posed in the Human
Demographics Final Lab Report.
a. Here you will come to some conclusions about what your data observations and
results represent. Analyze your survivorship curves to answer the questions.
Compare and explain the differences in the populations of both male and female
populations in your chart.
b. Type directly in the Human Demographics Final Lab Report underneath each
question provided. Handwritten answers will not be accepted and will earn zero
credit.
2) Once you have completed all three parts of the graded portion of your Human
Demographics Lab: Human Demographics Final Lab Report document, save this
document with your name included in the file (Ex: Biology_
_Human_Demographics_Final_Lab_Report _JohnDoe). Turn this in to receive
credit for this unit’s Biology Lab.
Biology Lab
Human Demographics Lab
Data Worksheet Part 1
(Complete this document first.)
For this Biology Lab, you are required to collect and calculate age data using the cemetery
information provided below. The “Survivorship Curves” Quick Lab on page 412 in your
textbook instructs you to use data from the obituary section of your newspaper. For this lab,
you will be using actual data from the Trinity United Church of Christ Cemetery of Telford,
which is located in Bucks County, Pennsylvania.
http://www.interment.net/data/us/pa/bucks/trinity_ucc/index.htm
Using the cemetery data provided below:
1) Print this document if you have not done so yet.
a. It will be easier to record and calculate the data on paper.
b. This document is not being turned in for credit, so everything may be
handwritten.
2) Taking the information from Table 1, enter the birth year and death year for each female
and each male in the appropriate columns in Table 2.
a. There are 20 females and 20 males for which you will be recording and
calculating data.
3) After you have inserted all the death and birth years, you will then need to calculate the
age of death.
a. To do this, simply subtract the birth year from the death year (Death Year – Birth
Year = Age of Death).
b. The first one is completed for you.
4) Once this table is completed, use this information to complete the following documents,
which will be turned in for credit in your Human Demographics Final Lab Report.
a. Survivorship Data Tables
b. Survivorship Curve Chart
Sex
Birth Year
Male
Female
Female
Male
Male
Female
Female
Male
Male
Male
Male
Female
Male
Male
Female
Male
Female
Female
Male
Female
1877
1890
1925
1859
1966
1860
1884
1934
1923
1920
1912
1907
1904
1938
1949
1925
1877
1975
1944
1900
Demographics Data – Table 1
Death Year
Sex
Birth Year
1964
1976
1930
1941
1967
1935
1975
1997
1991
1944
2003
1997
1936
1996
2004
1997
1941
1976
2000
1984
Male
Female
Female
Female
Male
Male
Male
Female
Male
Male
Female
Male
Male
Female
Female
Female
Male
Female
Female
Female
1893
1908
1926
1978
1916
1868
1921
1991
1940
1965
1889
1919
1953
1917
1930
1981
1913
1913
1879
1904
Death Year
1968
1968
1975
1994
1992
1960
1992
1991
1989
1998
1949
1989
1974
1997
1988
1988
1935
1977
1942
1987
Demographics Data – Table 2
FEMALES
FEMALES
MALES
MALES
Death year______
Death year______
Death year__1964__
Death year______
Birth year ______
Birth year ______
Birth year _1877__
Birth year ______
Age of death _____
Death year______
Age of death _____
Death year______
Age of death __87___
Death year______
Age of death _____
Death year______
Birth year ______
Birth year ______
Birth year ______
Birth year ______
Age of death _____
Death year______
Age of death _____
Death year______
Age of death _____
Death year______
Age of death _____
Death year______
Birth year ______
Birth year ______
Birth year ______
Birth year ______
Age of death _____
Death year______
Age of death _____
Death year______
Age of death _____
Death year______
Age of death _____
Death year______
Birth year ______
Birth year ______
Birth year ______
Birth year ______
Age of death _____
Death year______
Age of death _____
Death year______
Age of death _____
Death year______
Age of death _____
Death year______
Birth year ______
Birth year ______
Birth year ______
Birth year ______
Age of death _____
Death year______
Age of death _____
Death year______
Age of death _____
Death year______
Age of death _____
Death year______
Birth year ______
Birth year ______
Birth year ______
Birth year ______
Age of death _____
Death year______
Age of death _____
Death year______
Age of death _____
Death year______
Age of death _____
Death year______
Birth year ______
Birth year ______
Birth year ______
Birth year ______
Age of death _____
Death year______
Age of death _____
Death year______
Age of death _____
Death year______
Age of death _____
Death year______
Birth year ______
Birth year ______
Birth year ______
Birth year ______
Age of death _____
Age of death _____
Age of death _____
Age of death _____
Death year______
Death year______
Death year______
Death year______
Birth year ______
Birth year ______
Birth year ______
Birth year ______
Age of death _____
Age of death _____
Age of death _____
Age of death _____
Death year______
Death year______
Death year______
Death year______
Birth year ______
Birth year ______
Birth year ______
Birth year ______
Age of death _____
Age of death _____
Age of death _____
Age of death _____
Biology Part 2
Unit 2 Lesson 5 Lab
Human Demographics Lab
Data Worksheet Part 2
(Complete this document second.)
Using the information you calculated and organized in Table 2 of the Human Demographics
Data Worksheet Part 1, you will now need to calculate the survivorship data. This survivorship
data will allow you to later graph survivorship curves. The calculations you will be
performing will be similar to those from the Quick Lab on page 412 in your textbook. Use
that lab to model what to do below if you need extra help. The Quick Lab has an excellent
example of how you should model your calculations.
PROCEDURE Part 1 - Creating the Survivorship Data Tables
1. Print out this document if you have not done so yet
a. It will be easier to record and calculate the data on paper.
2. Make sure that you have completed Table 2 of your Human Demographics Data
Worksheet Part 1.
3. Tally the number of individuals that have died, according to their age, using the data
from your Demographics Data – Table 2. In your rough draft copy of this document, for
the 20 calculated ages of death of females in Table 2, place a tally mark in the Age
Group column of Table A in which the individual died. For example, if one female
died at age 28, you would place one tally mark in the age group of 21-30, in Table A
(FEMALES).
a. In your Human Demographics Final Lab Report, make sure you type in the actual
number for each age group and not the tally marks.
b. Make sure you are keeping the males and females separate and in their
appropriate tables.
4. For the 20 calculated ages of death of males in your Demographics Data – Table 2,
repeat Step 3 from above, but this time, use Table B (MALES).
5. For both tables, subtract the number of individuals that died from the number of
remaining survivors, and then record the answer in the third column of your data tables.
a. For each table, you will start with the first row (Age Group 0 - 10) and subtract
the number of individuals that died in that age group from the number 20, since
you started with 20 individuals for each sex (20 – number of deaths in
first age group = number of survivors)
b. Then, for the next row (Age Group 11 – 20), you will take the number of survivors
from the first row (Age Group 0 – 10) and subtract from it the number of deaths
in that present age group (Age Group 11 – 20).
c. Repeat this procedure for each row, making sure to subtract the number of
deaths in each age group from the number of survivors from the row before.
6. Next, calculate the percent of survivors in each age group
a. For each age group, divide the number of survivors (column 3) by 20, again
because we have a total of 20 individuals for each sex, and then multiply by 100
to calculate a percentage.
i. For example – If you have the total number of survivors for Age Group 2130 at 13, then you would divide 13/20 and multiply by 100 (13/20 * 100 =
65%)
b. Repeat for every age group in each table.
c. Once your Survivorship Data tables are completed, proceed to Procedure Part 2
to learn how to graph this data.
Transfer the data from both Tables A and B directly into your Human Demographics Final
Lab Report. Handwritten data will not be accepted and will earn zero credit. You will turn
this in for credit once the lab is complete.
Survivorship Data - FEMALES – Table A
Age Group
(years)
Number of Deaths
Number of Survivors
% Surviving
Survivorship Data - MALES – Table B
Number of Deaths
Number of Survivors
% Surviving
0 - 10
11 - 20
21 - 30
31 - 40
41 - 50
51 - 60
61 - 70
71 - 80
81 - 90
91 - 100
Age Group
(years)
0 - 10
11 - 20
21 - 30
31 - 40
41 - 50
51 - 60
61 - 70
71 - 80
81 - 90
91 - 100
PROCEDURE Part 2: Creating the Survivorship Curve Chart
1. You will now use the data that you have collected in both Table A and Table B, above, to
create your survivorship curve. The Chart has already been started for you below.
Follow these directions closely to construct your Survivorship Curve Chart.
a. Single click on the chart below. This will open up Microsoft Office for you.
b. In the menu, under the header Chart Tools, select the tab Design, and then select
the Edit Data option.
c.
This will bring up an Excel spreadsheet that has already been created for you. This
will enable you to input the appropriate data from the Table A and Table B above
into your chart. Thus allowing you to create survivorship curves for males and
females.
d. On the yx-axis, you will want to place the Age of Surviving Individuals. On the xyaxis, you will want to place the Percentage of Survivors for both males and female.
The percentage of males and females in the 1-10 age range has already been plotted
for you as an example.
e. When you have all information saved in your excel file, your chart should represent
the survivorship for both male and females in the data that you have collected.
Chart Title
100
90
80
Axis Title
70
Percentage
Surviving
Females
60
50
40
Percentage
Surviving
Males
30
20
10
0
0-10
11-20
21-30
31-40
41-50
51-60
61-70
71-80
81-90
91-100
Axis Title
Transfer your completed Survivorship Curves Chart directly into your Human
Demographics Final Lab Report by copying and pasting the entire chart. You will need to
right-click on the chart, outside the plot area and then select Copy. You will turn this in for
credit once the lab is complete.
Biology Part 2
Unit 2 Lesson 5 Lab
Human Demographics Lab
Data Worksheet Part 2
(Complete this document second.)
Using the information you calculated and organized in Table 2 of the Human Demographics
Data Worksheet Part 1, you will now need to calculate the survivorship data. This survivorship
data will allow you to later graph survivorship curves. The calculations you will be
performing will be similar to those from the Quick Lab on page 412 in your textbook. Use
that lab to model what to do below if you need extra help. The Quick Lab has an excellent
example of how you should model your calculations.
PROCEDURE Part 1 - Creating the Survivorship Data Tables
1. Print out this document if you have not done so yet
a. It will be easier to record and calculate the data on paper.
2. Make sure that you have completed Table 2 of your Human Demographics Data
Worksheet Part 1.
3. Tally the number of individuals that have died, according to their age, using the data
from your Demographics Data – Table 2. In your rough draft copy of this document, for
the 20 calculated ages of death of females in Table 2, place a tally mark in the Age
Group column of Table A in which the individual died. For example, if one female
died at age 28, you would place one tally mark in the age group of 21-30, in Table A
(FEMALES).
a. In your Human Demographics Final Lab Report, make sure you type in the actual
number for each age group and not the tally marks.
b. Make sure you are keeping the males and females separate and in their
appropriate tables.
4. For the 20 calculated ages of death of males in your Demographics Data – Table 2,
repeat Step 3 from above, but this time, use Table B (MALES).
5. For both tables, subtract the number of individuals that died from the number of
remaining survivors, and then record the answer in the third column of your data tables.
a. For each table, you will start with the first row (Age Group 0 - 10) and subtract
the number of individuals that died in that age group from the number 20, since
you started with 20 individuals for each sex (20 – number of deaths in
first age group = number of survivors)
b. Then, for the next row (Age Group 11 – 20), you will take the number of survivors
from the first row (Age Group 0 – 10) and subtract from it the number of deaths
in that present age group (Age Group 11 – 20).
c. Repeat this procedure for each row, making sure to subtract the number of
deaths in each age group from the number of survivors from the row before.
6. Next, calculate the percent of survivors in each age group
a. For each age group, divide the number of survivors (column 3) by 20, again
because we have a total of 20 individuals for each sex, and then multiply by 100
to calculate a percentage.
i. For example – If you have the total number of survivors for Age Group 2130 at 13, then you would divide 13/20 and multiply by 100 (13/20 * 100 =
65%)
b. Repeat for every age group in each table.
c. Once your Survivorship Data tables are completed, proceed to Procedure Part 2
to learn how to graph this data.
Transfer the data from both Tables A and B directly into your Human Demographics Final
Lab Report. Handwritten data will not be accepted and will earn zero credit. You will turn
this in for credit once the lab is complete.
Survivorship Data - FEMALES – Table A
Age Group
(years)
Number of Deaths
Number of Survivors
% Surviving
Survivorship Data - MALES – Table B
Number of Deaths
Number of Survivors
% Surviving
0 - 10
11 - 20
21 - 30
31 - 40
41 - 50
51 - 60
61 - 70
71 - 80
81 - 90
91 - 100
Age Group
(years)
0 - 10
11 - 20
21 - 30
31 - 40
41 - 50
51 - 60
61 - 70
71 - 80
81 - 90
91 - 100
PROCEDURE Part 2: Creating the Survivorship Curve Chart
1. You will now use the data that you have collected in both Table A and Table B, above, to
create your survivorship curve. The Chart has already been started for you below.
Follow these directions closely to construct your Survivorship Curve Chart.
a. Single click on the chart below. This will open up Microsoft Office for you.
b. In the menu, under the header Chart Tools, select the tab Design, and then select
the Edit Data option.
c.
This will bring up an Excel spreadsheet that has already been created for you. This
will enable you to input the appropriate data from the Table A and Table B above
into your chart. Thus allowing you to create survivorship curves for males and
females.
d. On the yx-axis, you will want to place the Age of Surviving Individuals. On the xyaxis, you will want to place the Percentage of Survivors for both males and female.
The percentage of males and females in the 1-10 age range has already been plotted
for you as an example.
e. When you have all information saved in your excel file, your chart should represent
the survivorship for both male and females in the data that you have collected.
Chart Title
100
90
80
Axis Title
70
Percentage
Surviving
Females
60
50
40
Percentage
Surviving
Males
30
20
10
0
0-10
11-20
21-30
31-40
41-50
51-60
61-70
71-80
81-90
91-100
Axis Title
Transfer your completed Survivorship Curves Chart directly into your Human
Demographics Final Lab Report by copying and pasting the entire chart. You will need to
right-click on the chart, outside the plot area and then select Copy. You will turn this in for
credit once the lab is complete.
Biology Lab
Human Demographics Lab
Final Lab Report
(Complete this document last.)
It is now time to submit a formal lab report for this Biology Lab. You will be typing and uploading directly in
this document, using the headers as your guide. This will be the only file uploaded for credit. You must:
• Part A - Insert your data for your Survivorship Data Tables A and B.
• Part B - Construct your hypothesis statement.
• Part C - Insert your Survivorship Curves Chart.
• Part D - Answer the conclusion questions.
Part A - Insert your data for your Survivorship Data Tables A and B.
Survivorship Data - FEMALES – Table A
Age Group
Number of Deaths
Number of Survivors
(years)
% Surviving
0 - 10
11 - 20
21 - 30
31 - 40
41 - 50
51 - 60
61 - 70
71 - 80
81 - 90
91 - 100
Survivorship Data - MALES – Table B
Age Group
(years)
Number of Deaths
Number of Survivors
% Surviving
0 - 10
11 - 20
21 - 30
31 - 40
41 - 50
51 - 60
61 - 70
71 - 80
81 - 90
91 - 100
Part B – Construct your hypothesis statement.
Part C - Insert your Survivorship Curves Chart.
Part D - Answer the conclusion questions.
1. Analyze the survivorship curve between males and females. Does the curve differ? If so, why do you
think that is?
2. Make future predictions about each of the following.
a. What might the curve look like if disease were to increase in the future?
b. What might the curve look like if science found more cures for disease?