Excel Final Project
This will be your final for Office Applications II. Be sure you take your time and do your best work. For this project you will be researching 5 fast food restaurants and comparing 3 different food items from each restaurant. The 5 different fast food restaurants are: McDonald's, Burger King, Carl’s Jr., Hardee’s and Wendy’s. The 3 food items are: Hamburgers, Chicken Sandwiches and Salads. Below I have given a list of information you need to find about each food item at each restaurant. You will make a spreadsheet with this information. There is also some information I would like you to figure out by creating a formula.
Your workbook should have a total of 4 tabs. 3 tabs for the food items: Hamburger, Chicken Sandwich and Salad. The fourth tab will be to compare the 3-food item's averages. You will have all of the information for the averages tab on the other three tabs. Below is an example of the basic layout of each tab. After finding all of the information and creating the correct formulas, I want you to format the spreadsheets to make them look professional. Be sure to use borders, merge and center, change font color and size. You may also want to change column width and row height.
Information Found on Website
|
Information Found by creating a formula
If you calculations are not working check to make sure you did not put letters in the numbers from the information you found on the websites. |
List of Fast Food Restaurants and their Websites
1. McDonald's - http://nutrition.mcdonalds.com/getnutrition/nutritionfacts.pdf
· Big Mac - (Serving Size is 211 grams)
· McChicken - (Serving Size is 144 grams)
· Premium Bacon Ranch Salad with Grilled Chicken - (Serving Size is 308 grams)
2. Burger King - http://www.bk.com/pdfs/nutrition.pdf
· Whopper (With Cheese)
· Original Chicken Sandwich
· Garden Grilled Chicken Salad with Tendergrill - No dressing
3. Carl's’ Jr - http://www.carlsjr.com/menu/nutritional_calculator_landing
· 1/3lb Original Six Dollar ThickBurger (Serving Size is 347 grams)
· The Big Chicken Fillet Sandwich (Serving Size is 250 grams)
· Charbroiled Chicken Salad (Serving Size is 280 grams)
4. Hardee’s - http://www.hardees.com/menu/nutritional_calculator_landing
· 1/3lb Original ThickBurger (Serving Size is 355 grams)
· Spicy Chicken Sandwich (Serving Size is 156 grams)
· Side Salad (Better for you options - VEG IT. - Side Salad) (Serving Size is 120 grams)
5. Wendy’s- https://menu.wendys.com/en_US/categories/
· Daves's Single (Serving Size is 247 grams)
· Homestyle Chicken (Serving Size is 247 grams)
· Apple Pecan Chicken Salad Full Size (Serving Size is 355 grams)
- Below each restaurant is the name of the three items you should compare.
1. McDonald's - http://nutrition.mcdonalds.com/getnutrition/nutritionfacts.pdf
· Big Mac - (Serving Size is 211 grams)
· McChicken - (Serving Size is 144 grams)
· Premium Bacon Ranch Salad with Grilled Chicken - (Serving Size is 308 grams)
2. Burger King - http://www.bk.com/pdfs/nutrition.pdf
· Whopper (With Cheese)
· Original Chicken Sandwich
· Garden Grilled Chicken Salad with Tendergrill - No dressing
3. Carl's’ Jr - http://www.carlsjr.com/menu/nutritional_calculator_landing
· 1/3lb Original Six Dollar ThickBurger (Serving Size is 347 grams)
· The Big Chicken Fillet Sandwich (Serving Size is 250 grams)
· Charbroiled Chicken Salad (Serving Size is 280 grams)
4. Hardee’s - http://www.hardees.com/menu/nutritional_calculator_landing
· 1/3lb Original ThickBurger (Serving Size is 355 grams)
· Spicy Chicken Sandwich (Serving Size is 156 grams)
· Side Salad (Better for you options - VEG IT. - Side Salad) (Serving Size is 120 grams)
5. Wendy’s- https://menu.wendys.com/en_US/categories/
· Daves's Single (Serving Size is 247 grams)
· Homestyle Chicken (Serving Size is 247 grams)
· Apple Pecan Chicken Salad Full Size (Serving Size is 355 grams)
Now that you have all of the information in your worksheets you need to make a couple charts for each of the tabs that will illustrate the information that you find interesting. I have given a few examples below.
Before you turn in your project make sure it looks professional. Be proud of your project.