AP Environmental Science Cemetery Demographics

There is a wonderful, large, old cemetery less than a five minute drive from my school. This year I decided that we'd take a trip to the Albany Rural Cemetery to gather data for APES Lab #5. Because the cemetery is so close, I think we can gather lots of data during one of our 80 minute classes.

I want students to be able to focus on the graphs made and what they mean in terms of demographic transition and mortality rates. I started with Kristi Schertz's spreadsheet, and then converted it to work with College Board's math to go with the Cemetery Lab. This way, students just need to enter their raw data and the sheet will do the calculations for them. Then they can focus on what all of the numbers mean, and I don't need to give quite as much class time to calculations since we're taking an entire block class to collect the data.

We haven't used the sheet yet, so there may need to be some corrections made to formulas, but I wanted to share what I have just in case it would be helpful to another class that's about to do this lab. If you are wondering, the initials in cells B1 to L1 are my students' initials so they each know where to enter their data. If you'd like, you could add rows for each of your students, or assign lab groups to each column instead.

Here's the spreadsheet.

I also made a data collection sheet for students to bring to the cemetery. My thought was that each student would collect 25 dates from pre-1900 and 25 from post-1900, which gives us a total of 550 pieces of data. I made a dashed line in the middle-ish of the paper so they could aim to get about half female and half male data as well.