To do this, you've decided to open your own business - a Lemonade Stand! You'll have complete control over almost every part of your business, including pricing, quality control, inventory control, and purchasing supplies. Hi, and welcome to Lemonade Stand! Your goal in this game will be to make as much money as you can within 7, 14 or 30 days. Open Internet Explorer and go to the website.Student Directions for Making Money from Lemons Students use a variety of media and formats to communicate information and ideas effectively to multiple audiences. Students use technology tools to enhance learning, increase productivity, and promote creativity. Use the information generated playing the Lemonade Stand to create an income statement using Excel to use in the Power Point presentation. To review all features of Microsoft Excel and Microsoft Power Point to create charts and graphs and use those charts and graphs to make a Power Point Presentation on your lemonade stand's profit/loss for the month. What does this graph mean about the way the amount of ingredient behaves in relation to the sizing factor? What kind of relationship is it? Extension - what about the slopes? Are they all the same? Discuss the logic of your findings.Ĭoncepts Taught: spreadsheet & power point What have you discovered? Has everyone discovered the same thing? Does it matter which ingredient you chose? Highlight the whole spreadsheet and make an x,y line graph. The = always goes in the cell where you want the answer to show Remember to Multiply in Excel you must start with an= Then, find the single, double and quadruple amounts from the correct row on your first spreadsheet and enter those in column B. In cell B1, write the unit and ingredient you have chosen (ounces of chocolate, cups of sugar, etc.). A sizing factor of 2 means doubling the recipe, 3 is tripling, etc. So, a sizing factor of 1 means you're not multiplying it at all.
The sizing factor means the amount by which you multiply the original recipe. Enter the data for column A as shown on the example. Next, let's take a look at the growth pattern of the ingredients. Now that you know how much of each ingredient it will take for all three options, you can decide which option to choose. To double the amount of chocolate =C2*2 then press enter. We DO NOT type in the numbers we are looking for we type in the equation Now, write formulas in cells D2, E2 and F2 that will double, triple and quadruple the numerical amounts in column C. Input the ingredients, units and amounts for one recipe's worth as shown on the example spreadsheet. Enter your labels as shown in the example spreadsheet. Using the format pulldown, make the row height of row 1 be 30 point. Format all the cells to have center, wrap alignment. Use a spreadsheet to figure out how much of each ingredient you will need for each of the possible scenarios. You have not decided whether you should double, triple or quadruple the recipe. Fold chocolate into cream and spoon into individual glasses or cups. If chocolate has thickened add 1 more tablespoon water. Melt water and sugar over low heat until sugar melts. The following recipe for chocolate mousse makes enough for six people. Everybody loves chocolate mousse - it's so rich and creamy and fluffy and delicious! You know the guests will eat a lot of it, so you'll make more than one serving per person. The dessert is going to be chocolate mousse. You are having a dinner party for six people, including you. You each need to play and record the data on the data collection sheetĬreatre a M&M Pictograph to represent the M&M's in your bagĬLASS POLL SPREADSHEET FAVORITE ICECREAM.xls 3/4 Grade Sprea 8th grade spreadsheet Unit
0 kommentar(er)
