Using Excel sheet for ESL Fast food restaurant Objective: excel sheet in listening and speaking class
Level: high beginner -intermediate Aim: be able to talk about the graphs using the vocabulary learned in class Analyze data and compare findings Sills needed: computer skills excel & computer search via internet Time: 2 hours Procedure 1- Step One: a- In pairs decide which fast food restaurant you would like to visit. b- Click on that restaurant's web site below. McDonald's: http://www.mcdonalds.com/app_controller.nutrition.index1.html Burger King: http://www.bk.com/ Wendy's: http://www.wendys.com/the_menu/nut_frame.html Other Restaurants: http://www.nutritiondata.com/ (This site allows you to search many fast food restaurant sites.) c- Once there, plan a meal with a sandwich, salad or other main dish, a side dish (french fries, etc), a drink, and a dessert. d- For each item on your menu, record the total calories and the calories from fat. Step Two: Enter your data in an Excel spreadsheet. Follow the following directions to entering data and formulas: a- Set up your Excel spreadsheet like the one above. You will enter the calories in column B and fat calories in column C. b- To figure out non-fat calories, write a formula to subtract the fat calories from the total calories. (HINT: =B2-C2) c- To figure out the percentage of calories from fat, divide fat calories by calories. Format the cells in column E for percentage. (HINT: =C2/B2)
d- To figure out total calories, total fat calories, and total non-fat calories, you can use the AutoSum button or write a formula. To figure out the total percentage of fat, divide total calories.
e- Your spreadsheet should answer the following questions 1. 2. 3. 4. 5. 6. 7. Total calories for meal Total fat calories for meal Total non-fat calories for meal Percentage of fat in meal Item with most calories and number of calories Item with least calories and number of calories Item besides the beverage with the highest percentage of fat
When finished your spreadsheet create a chart to illustrate your findings. Compare your answers to at least one pair. In your notebook, record information about which restaurant they visited, what food they ate, and the nutritional content of that food.
Grade Rubric
Fast Food Fun
To earn a D you must complete the following: Entered most data correctly, some incorrect formatting, attempted to use formulas and functions Created minimal charts lacking correct chart elements; incorrect data displayed
To earn a C you must complete the following: Entered all data correctly, was able to format data, attempted to use formulas and functions
To earn a B you must complete the following: Entered all data correctly, completed required formatting, used formulas and functions correctly Created required charts with correct elements including title, names of axes, legend, and data labels; correct data displayed Created required charts with correct elements including title, legend, and data labels; correct data displayed
To earn an A you must complete the following:
Manipulate a spreadsheet: enter and format data and use formulas and functions.
Entered all data correctly, completed required formatting, used formulas and functions correctly, used advanced formatting techniques to design spreadsheet Created required charts with correct elements including title, names of axes, legend, and data labels; correct data displayed; used advanced charting techniques to design charts beyond requirements Created required charts with correct elements including title, legend, and data labels; correct data displayed; used advanced charting techniques to design charts beyond requirements
Create bar charts to analyze data .
Created minimal charts lacking correct chart elements; correct data displayed
Create pie charts to analyze data .
Created minimal charts lacking correct chart elements; incorrect data displayed
Created minimal charts lacking correct chart elements; correct data displayed
