Fast Food Fun
Objective:
Students will be able to create a spreadsheet and use formulas to solve problems.
METS
CI.2- Create an original project using a variety of media to present content information to an audience.
CT.1- Use Spreadsheets to make predictions, develop strategies, and evaluate decisions to assist with problem solving.
RI.1- Use a variety of resources to locate information.
Directions:
Step One:
Decide which 3 fast food restaurants you are going to visit. Click on that restaurant's web site below.
McDonald's: http://www.mcdonalds.com/app_controller.nutrition.index1.html
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.)
Once there, plan a meal with a sandwich, salad or other main dish, a side dish (french fries, etc), a drink, and a dessert. For each item on your menu, record the total grams of fat, calories and the calories from fat.
Entering Data and Formulas:
Create your spreadsheet similar to the one above. You will enter the grams of fat in column B, the calories in column C, the fat calories in column D, and the percentage of fat in column E.
Be sure to bold your titles and headings.
Also, Make sure you Merge your main title (the title of your restaurant)
To figure out total fat, calories, total calories from fat, and percentage from fat, you can use the AutoSum button
To figure out the total percentage of fat, divide total calories by total fat calories. HINT: =(D3/AC3)
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)
Be sure to format your cells so that it's nice and neat looking. You will need to increase the size of your cells and merge your restaurant title. Don't forget to Bold all of your headings.
Creating Charts:
You will now create three charts for each of the 3 fast food restaurants that you research.
Sample Charts
You'll be making a chart to go along with each spreadsheet. Save it as part of your spreadsheet.
Create this column chart by selecting the data in columns A, B, and C. I didn't include the total calories for my meal, but you can if you want. Don't forget to give it a title and to label your axes.
To Make Your Life Easier...
- Do NOT total Percentage of Fat
-To create your chart you will highlight EVERYTHING except the restaurant title.
- Click on Chart Wizard
-Click on the Series tab
-Remove all of the headings except for Fat and Calories From Fat
-The title is the restaurant name
-X Axis: Food
-Y Axis: Calories
Grading Rubric:
Fast Food Fun
4
3
2
1
Manipulate a spreadsheet: enter and format data and use formulas and functions.
Entered most data correctly, some incorrect formatting, attempted to use formulas and functions
Entered all data correctly, was able to format data, attempted to use formulas and functions
Entered all data correctly, completed required formatting, used formulas and functions correctly
Entered all data correctly, completed required formatting, used formulas and functions correctly, used advanced formatting techniques to design spreadsheet
Create a bar graph to analyze data
Created minimal charts lacking correct chart elements; incorrect data displayed
Created minimal charts lacking correct chart elements; correct data displayed
Created required charts with correct elements including title, names of axes, legend, and data labels; correct data displayed
Spreadsheet is not formatted very neatly. Many of the following is missing: Headings are bold and all information is centered. Titles are evident and spelled correctly
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
Spreadsheet is not at all formatted neatly. None of the following is evident: Headings are bold and all information is centered. Titles are evident and spelled correctly
.
Formatting of Spreadsheet
Spreadsheet is neatly formatted. Headings are bold and all information is centered. Titles are evident and spelled correctly
Spreadsheet is mostly formatted neatly. One of the following is missing: Headings are bold and all information is centered. Titles are evident and spelled correctly
.