Today we will begin by looking at the Excel screen. We will also look at how to write a basic math formula. Remember that all formulas must begin with an equal sign =.
Lunch Budget
Why are we doing this? I would like you to get a feeling for what it might cost to eat out every day for a week. You are to pretend that you are attending a five day, Monday through Friday, business conference in Boise. Each day you will go out to lunch at a different restaurant. You will find the exact price of each lunch and the total price for the week from each restaurant listed below. You do not need to figure/include tax.
Key terms/concepts: widening columns, formatting money, cell reference/addresses, formulas, formulas with cell addresses, word art, clip art, header, link
Internet research:
You must search the internet and find the menu prices of each meal listed below, Your Google search is underlined. When you do these searches remember you are looking for the actual business. Know that the web site you are looking for will most likely have the business name in the web address. When you get to the correct web site find the area you are looking for, don’t be afraid to click things, that is how you increase your ability in web site navigation. If you feel like you have gone in the wrong direction click the back arrow, or reenter your search. Write down the price of each meal as you find them. When you have found the price of each meal then begin you spreadsheet.
1. Olive Garden, Boise Town Square- Pronto lunch menu- Grilled Chicken Flatbread
2. El Gallo Giro- Boise- #1 combination
3. Mongolian BBQ Boise - Barbarian Khan, all you can eat, lunch price.
4. Old Chicago down town Boise- must select location- Sandwich, Chicken Pesto Panini.
5. RAM Boise- Fire Grilled Burgers- The All American
Once you have completed your research create a spreadsheet named Lunch Budget that details the price of your lunches:
1. Create A header with your first and last name.
2. A Title on your spreadsheet (Lunch Budget) using word art. Title should not go below row 4 or 5 and not past column G.
3. Put the names of the restaurants in cells A6-A10 starting with Olive Garden, use Times New Roman size 12 font. You must widen column A so the names of the restaurants will fit. Click on boarder of the column heading and with the double line you can widen the cell. In Cells C6–C10 put the price of each lunch. In cell A11 put the title Total Cost, and in cell C11 create a formula that calculates the cost of your lunches for a week. Use cell addresses for your formula, and remember all formulas must begin with an equal (=) sign. Format your prices as Accounting or currency, click the arrow above number on the ribbon to open the drop down menu.
4. Add a clip art to go with your theme of lunch. (Clip art must be similar in size to your lunch spreadsheet, no more than 6/7 rows.)
5. Finally attach the document to the edmodo assignment, "Lunch Budget and turn it in.
Objective: SWBAT Create an original work as a means of expression
Language Objective: SWBAT Use content vocabulary correctly
Lunch Budget
Why are we doing this? I would like you to get a feeling for what it might cost to eat out every day for a week. You are to pretend that you are attending a five day, Monday through Friday, business conference in Boise. Each day you will go out to lunch at a different restaurant. You will find the exact price of each lunch and the total price for the week from each restaurant listed below. You do not need to figure/include tax.
Key terms/concepts: widening columns, formatting money, cell reference/addresses, formulas, formulas with cell addresses, word art, clip art, header, link
Internet research:
You must search the internet and find the menu prices of each meal listed below, Your Google search is underlined. When you do these searches remember you are looking for the actual business. Know that the web site you are looking for will most likely have the business name in the web address. When you get to the correct web site find the area you are looking for, don’t be afraid to click things, that is how you increase your ability in web site navigation. If you feel like you have gone in the wrong direction click the back arrow, or reenter your search. Write down the price of each meal as you find them. When you have found the price of each meal then begin you spreadsheet.
1. Olive Garden, Boise Town Square- Pronto lunch menu- Grilled Chicken Flatbread
2. El Gallo Giro- Boise- #1 combination
3. Mongolian BBQ Boise - Barbarian Khan, all you can eat, lunch price.
4. Old Chicago down town Boise- must select location- Sandwich, Chicken Pesto Panini.
5. RAM Boise- Fire Grilled Burgers- The All American
Once you have completed your research create a spreadsheet named Lunch Budget that details the price of your lunches:
1. Create A header with your first and last name.
2. A Title on your spreadsheet (Lunch Budget) using word art. Title should not go below row 4 or 5 and not past column G.
3. Put the names of the restaurants in cells A6-A10 starting with Olive Garden, use Times New Roman size 12 font. You must widen column A so the names of the restaurants will fit. Click on boarder of the column heading and with the double line you can widen the cell. In Cells C6–C10 put the price of each lunch. In cell A11 put the title Total Cost, and in cell C11 create a formula that calculates the cost of your lunches for a week. Use cell addresses for your formula, and remember all formulas must begin with an equal (=) sign. Format your prices as Accounting or currency, click the arrow above number on the ribbon to open the drop down menu.
4. Add a clip art to go with your theme of lunch. (Clip art must be similar in size to your lunch spreadsheet, no more than 6/7 rows.)
5. Finally attach the document to the edmodo assignment, "Lunch Budget and turn it in.
Objective: SWBAT Create an original work as a means of expression
Language Objective: SWBAT Use content vocabulary correctly