Information Technology Processing - Fast Food Spreadsheet Project



Objective:
Use the Internet and spreadsheets to find calories and fat in a typical fast food meal.



Project Rubric: Information on how this project will be graded. Procedure:

Step One:
Decide which fast food restaurant you would like to visit. Click on that restaurant's web site below.
McDonald's
Burger King
Wendy's
Other Restaurants (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 calories and the calories from fat.

Step Two:
Enter your data into a spreadsheet. Repeat this process for three other restaurants of your choice. Be sure to select a complete meal from each restaurant and record the total calories and the calories from fat. Create a chart summarizing your data. Be sure to share your spreadsheet.

Step Three:
Visit the United States Department of Agriculture to find out more about healthy eating guidelines.

Step Four:
Using Google Docs, type a four paragraph report about your findings.

Paragraph #1: Introduction including which restaurants you chose and the items on your menus.
Paragraph #2: Summarize your findings about your meals including number of calories, percentage of fat, etc. Insert your chart into your document as supporting evidence.
Paragraph #3: Compare and contrast your meals. Use the information you recorded in step 2.
Paragraph #4: Use the information from the Department of Agriculture to evaluate your meals. How does your percentage of fat compare to the percentage recommended? What about other guidelines like eating fruits and vegetables. Have you planned a healthy meal? What changes might you make in your meal to make it healthier? When you finish the report, share it with me.



Grade Rubric

Fast Food Fun To earn a D you must complete the following: To earn a C you must complete the following: To earn a B you must complete the following: To earn an A you must complete the following:
Target Objective 1
Manipulate a spreadsheet: enter and format data and use formulas and functions.
Level 1 Indicator
Entered most data correctly, some incorrect formatting, attempted to use formulas and functions
Level 2 Indicator
Entered all data correctly, was able to format data, attempted to use formulas and functions
Level 3 Indicator
Entered all data correctly, completed required formatting, used formulas and functions correctly
Level 4 Indicator
Entered all data correctly, completed required formatting, used formulas and functions correctly, used advanced formatting techniques to design spreadsheet
Target Objective 2
Create charts to analyze data
.
Level 1 Indicator
Created minimal charts lacking correct chart elements; incorrect data displayed
Level 2 Indicator
Created minimal charts lacking correct chart elements; correct data displayed
Level 3 Indicator
Created required charts swith correct elements including title, names of axes, legend, and data labels; correct data displayed
Level 4 Indicator
Created required charts swith correct elements including title, names of axes, legend, and data labels; correct data displayed; used advanced charting techniques to design charts beyond requirements
Target Objective 3
Summarize findings using a word processor and incorporating data and charts from spreadsheet
.
Level 1 Indicator
Able to copy chart from spreadsheet; brief summary with few details; no attempt to draw conclusions about data; did not meet requirements for length; did not used correct format
Level 2 Indicator
Able to copy chart from spreadsheet; brief summary with few details; some attempt to draw conclusions about data; made some attempt to meet length and format requirements
Level 3 Indicator
Able to copy chart from spreadsheet; summary included required details; was able to meet length and format requirements
Level 4 Indicator
Able to copy chart from spreadsheet; detailed summary with additional information beyond required elements; met or exceeded length and format requirements

 

Adapted from Web Weavers Education Page Copyright ©2000. Karen Work Richardson.



Home