GOAL: After today’s lesson you will be able to ……..

- Apply comparison-shopping methods, such as gathering price and quality information, comparing spending & non-spending alternatives, and comparing unit price information to follow a

budget. - Analyze whether information from sources are accurate and reliable when comparing products and services

RIGHT NOW:

- You are hosting a celebration. In your Word Online file answer the following:
- What costs and plans might be associated with preparing for an event for a group of people?
- What types of expenses should you consider when planning for the party? Remember there are costs associated with groceries, a place to host the party, decorations, invitations, paper goods, etc.
- In order to ensure you can afford the costs listed, you’ll need to determine a budget. What do you think of when you hear the word budget?
- How long could a budget last? Some budgets are on going to accommodate for needs, like housing.

- Today you will be shopping within your budget for the class End of Year celebration. You have set a budget for
**$120**, and outlined are a few options for you to make choices with that budget.- You will need to calculate the costs of the items by unit price.
- Unit rate is often a useful means for comparing ratios and their associated rates when

measured in different units. - The unit rate allows us to compare varying sizes of quantities by examining the number of units of one quantity per one unit of the second quantity. This value of the ratio is the unit rate.
- Here is an example of unit rate:
- For the birthday party, I’d like to buy enough cake for 18 people.
- Cupcakes are $12 for 9 cupcakes.
- A sheet cake with 20 slices is $22.
- The unit price for each cupcake is $1.33, and the unit price for each cake slice is $1.10.
- Even though I’m buying two extra slices, the total cost for the cake is 22, whereas the cupcakes are $24.

- Unit rate is often a useful means for comparing ratios and their associated rates when

- You will need to calculate the costs of the items by unit price.
- Make an Excel spreadsheet for the Celebration Activity
- Log in to your Office 365 account online
- Choose Excel
- Create a new file from scratch
- Click the file menu–choose SAVE AS–click SAVE AS again–Name the file My Party Budget–Choose your 8th Grade Documentary folder
- In cell A1 type “My Party Budget”
- In A2 type “Item”
- In B2 type “Number Per Package”
- In C2 type “Price Per Package”
- In D2 type “Unit Price”
- Select cells A2 to D2 (point at the middle of A2, click and drag to D2 to select the cells) and choose WRAP TEXT from the HOME tab, ALIGNMENT section
- In A3 type Water
- In B3 type 18
- In C3 type 6
- In D3 enter a formula to calculate the unit price (remember to start every formula with the equal sign and use cell addresses (not actual numbers) in the calculation)
- Copy the formula in D3 down to D20 by clicking on cell D3, pointing at the notch in the lower right corner of the cell and when the pointer turns into a solid black plus sign click and drag to cell D20
- Format the numbers in columns C and D to dollar amounts by selecting cells C3 to D20 (point in the middle of cell C3, click and drag to D20) and then click the $ button on the HOME tab in the NUMBER section. Choose English
- Enter the information for the remaining budget items for ALL drinks, snacks, fruit, and extras
- You will need to make column A wider
- Make each of the 4 categories easier to identify by selecting all the items for one category and changing the color of the font–for instance, select from A3 to D5 to select all the drink items and change the color to Blue. Do the same by changing the font color to Green for the Snacks, Orange for the Fruit items, and Purple for the Extras
- Now you have $120 to spend. Pick the items for each category you want while not exceeding $120. To do this, follow these steps:
- In cell E2 type “Number of Packages” (you will need to wrap the text)
- In cell F2 type “Total Price”
- In cell A21 type Total Cost”
- In cell F21 use the SUM function to add cells F3 to F20 (even though there are no amounts there yet)–make it be in currency or dollar amount format
- In the beverages section choose which beverage you want by typing in the number of packages for that item and then use a formula to calculate the total price for that item. For instance, I choose juice by typing a 2 in cell E4 (because I want and can afford 2 packages of juice for my 24 guests). In cell F5 I will enter a formula to calculate the total price by multiplying the number of packages by the price per package. (Remember to start the formula with an equal sign and use cell addresses (not actual numbers) to make the calculation).
- Repeat the above instructions for the snacks, fruit, and extras sections.

- Merge & center the title over columns A to F (select cells A1 to F1 and click the merge & center button on the HOME tab, in the ALIGNMENT section) and Bold the title
- Center and bold the column headings
- Your finished spreadsheet should resemble the following:
- Print the spreadsheet
- Raise your hand to show your teacher your formulas

- In your Word Online file for this class respond to the following:
- Caitlin is at the grocery store, and she’s trying to find the unit price on a 6-pack of drinks on sale for $2.99. Her younger brother says that at that price, each drink would cost just over $1.00. Is he correct, and how do you know? If he were incorrect, how would Caitlin’s brother find the correct price?