Agenda: Friday, 12/2/16

Finish Half-Life Analysis

Goal:

Use a spreadsheet to analyze half-lives to answer the following questions:

1. 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?
2. 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:

1. Create a spreadsheet to calculate half-lives. WE WILL HELP!
1. What categories of data do you have?
2. What question(s) do you need to be able to answer?
3. What math will you need to perform?
1. relative cell references
2. absolute cell references
2. Create a slideshow to present your results. Embed your data from your spreadsheet.
1. Include the following slides:
1. Title slide (include the names of the people who worked on this)
2. The question
3. Your data
4. Your analysis
5. Your conclusion (the answer to the question)
2. Each question should be answered in its own slideshow

Example sheet

Example slideshow

Assignment 2: Shopping!

Pretend you have been given $300 to spend with only two conditions: you must purchase at least 5 items and you lose any money you don’t spend (so spend as much as possible without going over!). Working by yourself or with a partner, plan how to spend it by creating a spreadsheet that allows you add up the purchase prices and quantities so that you can use as much of your money as possible. Your spreadsheet must:

• Have a place to list:
• each item
• where it will be purchased
• the quantity
• sales tax
• the total cost per item
• the amount spent on all items
• Use formulas and functions to figure out all your data. Use cell references!!!! Do not use the actual numbers as part of your formulas.

Hint #1: set up your table(s) and formulas first and then go shopping; it will be easier to stay within your price range.

Hint #2: use colors, borders, and formatting to make it easier to see how your table is organized.

To turn it in:

1. Go to View>All Formulas
2. Take a screenshot (Part of a page: Crtl + Shift + Switch window
3. Import into a Google Slide
4. In Google, use shapes and lines to identify a formula, a function, and a range on the screenshot of your spreadsheet.
5. Name the slide with your name(s)
6. Download as a JPEG.
7.  Submit the JPEG and your original spreadsheet to Google Classroom.