Half-Life Analysis
Goal:
Use a spreadsheet to analyze half-lives to answer the following questions:- The Fermi nuclear power plant melts down. What generation of your descendants will be able to move back to Detroit? Prove it with data from a spreadsheet?
- You're building a sand castle on the shores of Lake Michigan. Digging in the sand, you find the charred wood left from a campfire. Analysis shows that the charring is 93.75% Carbon 12. Approximately how long ago was the campfire made? Who made it?
Steps:
- Create a spreadsheet to calculate half-lives. WE WILL HELP!
- What categories of data do you have?
- What question(s) do you need to be able to answer?
- What math will you need to perform?
- relative cell references
- absolute cell references
- Create a slideshow to present your results. Embed your data from your spreadsheet.
- Include the following slides:
- Title slide (include the names of the people who worked on this)
- The question
- Your data
- Your analysis
- Your conclusion (the answer to the question)
- Each question should be answered in its own slideshow
(5th and 6th hour) Turn in a spreadsheet that acts as a checkbook
- Include columns for
- the item (paycheck, eating out, etc)
- income
- expenses
- total in account; don't forget to include the starting amount
- The "total" column should update automagically whenever you add income or subtract an expense. Create a formula that will do either so you can copy it down the "totals" column.
- Submit via Google Classroom
