Agenda: Monday, 12/5/16

Today

1. Turn in Half-Life Analysis if you haven't done so already
2. Finish and submit shopping spreadsheet (see below). Turn in both the original spreadsheet and the requested JPEG.

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.