Today you will work in Excel Online. Help each!! YOU CAN DO THIS!! Today is also a great opportunity to use your resources (the instructions in this lesson & your teammates) to solve problems ON YOUR OWN!!! Use your resources!! GOAL: By the end of class today you will know how to use a spreadsheet to budget a party.

  1. Make an Excel spreadsheet for the Celebration Activity
    1. Get your Celebration Budget Worksheet that you completed last class
    2. Log in to your Office 365 account online
    3. Choose Excel
    4. Create a new file from scratch
    5. Click the file menu–choose SAVE AS–click SAVE AS again–Name the file My Party Budget–Choose your 8th Grade Documentary folder
    6. In cell A1 type My Party Budget
    7. In A2 type Item
    8. In B2 type Number Per Package
    9. In C2 type Price Per Package
    10. In D2 type Unit Price
    11. 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
    12. In A3 type Water
    13. In B3 type 18
    14. In C3 type 6
    15. 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) (for example: =B3/C3). After you type the formula HIT ENTER–the formula should still appear in the formula bar above, but the answer should appear in the cell.
    16. 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
    17. 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
    18. Enter the information for the remaining budget items for ALL drinks, snacks, fruit, and extras
    19. You will need to make column A wider
    20. 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
    21. Now you have $120 to spend. Pick the items for each category you want while not exceeding $120. To do this, follow these steps:
      1. In cell E2 type “Number of Packages” (you will need to wrap the text)
      2. In cell F2 type “Total Price”
      3. In cell A21 type Total Cost”
      4. 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
      5. 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).
      6. Repeat the above instructions for the snacks, fruit, and extras sections.
    22. 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
    23. Center and bold the column headings
    24. Your finished spreadsheet should resemble the following: 
    25. Print the spreadsheet
    26. Raise your hand to show your teacher your formulas
  2. In your Word Online file for this class respond to the following:
    1. 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?
  3. Get ready for the next Pay Day, Bill Day, Auction Day which is next class–look at the lesson plan for next class–think about how class went last time. What can YOU do to make the next pay day go better? Personally and for your job?
  4. Get a savings plan ready for yourself. Save to: pay off your desk? buy a high priced auction item? save the most in the class?
  5. Run a Coffee Shop
  1. Complete the Team Work Form for you and for all of your teammates–this is anonymous–only Mrs. Weber will know what you put in this form
  2. Complete the Citizenship/Employability Form FOR YOU! Be honest in your self-evaluation!
  3. Make Up–Check JMC

FINISH:

Today you will work in Excel Online. Help each!! YOU CAN DO THIS!! Today is also a great opportunity to use your resources (the instructions in this lesson & your teammates) to solve problems ON YOUR OWN!!! Use your resources!! GOAL: By the end of class today you will know how to use a spreadsheet to budget a party.

  1. Make an Excel spreadsheet for the Celebration Activity
    1. Get your Celebration Budget Worksheet that you completed last class
    2. Log in to your Office 365 account online
    3. Choose Excel
    4. Create a new file from scratch
    5. Click the file menu–choose SAVE AS–click SAVE AS again–Name the file My Party Budget–Choose your 8th Grade Documentary folder
    6. In cell A1 type My Party Budget
    7. In A2 type Item
    8. In B2 type Number Per Package
    9. In C2 type Price Per Package
    10. In D2 type Unit Price
    11. 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
    12. In A3 type Water
    13. In B3 type 18
    14. In C3 type 6
    15. 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) (for example: =B3/C3). After you type the formula HIT ENTER–the formula should still appear in the formula bar above, but the answer should appear in the cell.
    16. 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
    17. 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
    18. Enter the information for the remaining budget items for ALL drinks, snacks, fruit, and extras
    19. You will need to make column A wider
    20. 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
    21. Now you have $120 to spend. Pick the items for each category you want while not exceeding $120. To do this, follow these steps:
      1. In cell E2 type “Number of Packages” (you will need to wrap the text)
      2. In cell F2 type “Total Price”
      3. In cell A21 type Total Cost”
      4. 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
      5. 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).
      6. Repeat the above instructions for the snacks, fruit, and extras sections.
    22. 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
    23. Center and bold the column headings
    24. Your finished spreadsheet should resemble the following: 
    25. Print the spreadsheet
    26. Raise your hand to show your teacher your formulas
  2. In your Word Online file for this class respond to the following:
    1. 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?
  3. Get ready for the next Pay Day, Bill Day, Auction Day which is next class–look at the lesson plan for next class–think about how class went last time. What can YOU do to make the next pay day go better? Personally and for your job?
  4. Get a savings plan ready for yourself. Save to: pay off your desk? buy a high priced auction item? save the most in the class?
  5. Run a Coffee Shop
  1. Complete the Team Work Form for you and for all of your teammates–this is anonymous–only Mrs. Weber will know what you put in this form
  2. Complete the Citizenship/Employability Form FOR YOU! Be honest in your self-evaluation!
  3. Make Up–Check JMC

57 Comments to “Day 18 (8)”

    1. i think it was good with lots of info

    2. i think it was good and liked the picture examples.

    3. I really liked this one. I liked the facts and the general idea

    4. Very helpful on knowing what todo when an intruder comes

    5. I think this was pretty good. Nice Job!

    6. I thought it was cool.

    7. Your video was informative, it was easy to read the words on the screen, and the slides were long enough to read the words written. The video was great.

    1. I think this is good but i think some more pictures.. Good Job though.

    2. It was well made but 4 and 5 were the same.

    3. It was good but not very interesting.

    4. i think it was really good the colors were really bright and caught my attention

      1. It was good

      2. I liked how you put the ways to protect yourself from intruders.

    5. I really like yours because you have very good information and steps on how to get ready for intruders.

    6. i thought your video was overall good. I think it needs to have som epictures and have the same overall color.

    7. I liked how your powtoon was on topic and in steps.

    8. I thought it was pretty good.

    1. i think this video was good nice job.

    2. I liked the video it was very informing and I liked the song the most it matched the video.

    3. I think this is the best one because they had sound and it was really intertaining

    4. I think it was good but the info should be more specific.

    5. I think it was very informational on the natural disasters

    6. Your video was very well done, especially the transitions. They made the video interesting.

    7. I thought it was pretty good.

    8. I like your video because you have really good pictures and information. You could probably have less time on your slides.

    9. i liked how much information you put on the powtoon but maybe you could put more pictures.

    1. good job but needed music

    2. I think it was good.

    3. I think that they gave very infomation on were to go in shelter from a storm or something like that.

    4. The video was informative, interesting, and I liked how there was a sort of story when the kids went into the locker room during a natural disaster.

    5. I really like your video because you had good animations, information, and good idea.

    6. I really liked your video. I liked how it was animated and you had a really good overall idea.

    1. I liked how it grabbed my attention.

    2. good music but needed more info

    3. I liked the attention grabbing beginning.

    4. The video looked very nice, but it could use more information on how to prepare. Using different fonts to put emphasis on important words was a good idea.

    5. I like yours, but you could use some pictures. Also good information and idea

    1. It was very good. I liked how it caught my attention.

    2. it was really good it really caught my attention

      1. I liked how you put what to do during a natural disaster.

    3. Short it was only was 30sec but good

    4. good but more info

    5. The beginning part with Lucy was very interesting and it did a good job of keeping attention. Try adding more information on how to prepare for natural disasters. Other than that, well done.

    6. Short it was only was 30sec but good.

    7. i liked your powtoon because it was well put together and you could understamd what you want people to understand.

    1. I liked how you put what to do during a natural disaster.

    2. It was good and i liked it but it could have been a little less but other then that i liked it good job.

    1. I liked how you put what to do during a natural disaster.

Leave a Reply

Your email address will not be published. Required fields are marked *