Biology Unit 6..........

zbbacbby
timer Asked: Jul 6th, 2015

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?
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Content

Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors