Tech Assignment #7 - AM I FAT!!!!

Objective: Students will go on the http://broward.atomiclearning.com and learn how to use MS Excel. They must listen to all the tutorials. They must follow the same steps as they did to listen to MS Word. Students with Desktops must listen to 2007 Microsoft Excel Intro. If students are using the laptops, they must listen to 2003 Microsoft Excel Intro.

1. Step 1: Decide which fast food restaurant you would like to visit. Go to that restaurant’s website. Here is a list of some of those restaurants:
• McDonald’s – http://www.mcdonalds.com/app_controller.nutrition.index1.html

• Burger King – http://www.bk.com
• Wendy’s
• Arby’s

If you need to find other restaurants you can go to http://nutriondata.com/

2. Step 2: 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.
3. Step 3: Enter your data in a Excel Spreadsheet. It is similar like you did in MS Word but a little different. Make sure you listen to the tutorials. Make sure your spreadsheet has columns and rows set up.
4. Step 4: Go MS Word and type and 3 paragraph report about your findings.
• Paragraph 1: Introduction includes which restaurant you chose, the website and the items on your menu.
• Paragraph 2: Summarize your findings on your meal, including number of calories, percentage of fat, etc…
• Paragraph 3: Go to the following site: http://www.nal.usda.gov/fnic/dga/dguide95.html Use the information from the Dept. Of Agriculture to evaluate your meal. 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?
• Go to tools on your tool bar and do spellcheck. Make sure everything is right.

5. Step 5 : You have 3 class periods to finish this assignment. When you are done, you are to email me 2 attached documents; 1 Word document with your 3 paragraphs and 1 Excel spreadsheet with your columns, rows and data. Make sure you have your first and last name and period in the subject box. IF WORK IS TURNED IN WITHOUT A NAME OR HEADING, IT WILL BEDELETED AND A 0 WILL BE GIVEN, NO EXCEPTIONS.

6. SEE EXAMPLE OF SPREADSHEET:

FOOD CALORIES FAT CALORIES NON-FAT CALORIES PERCENTAGE OF FAT
CHEESEBURGER
LARGE FRIES




JUST KEEP ADDING YOUR FOOD TO THE COLUMN AND THE REST OF THE DATA.

TO GET THE NON FAT CALORIES, USING THE CALCULATOR ON THE COMPUTER, SUBTRACT FAT CALORIES FROM REGULAR CALORIES AND THE REMAINING IS THE NON FAT CALORIES.

TO FIGURE OUT TOTAL CALORIES FROM FAT, DIVIDE FAT CALORIES BY REGULAR CALORIES.

TO FIGURE OUT TOTAL CALORIES, TOTAL FAT CALORIES, AND TOTAL NON-FAT CALORIES, YOU CAN USE THE AUTO SUM BUTTON. TO FIGURE OUT THE TOTAL PERCENTAGE OF FAT, DIVIDE TOTAL CALORIES BY TOTAL FAT CALORIES.

IF YOU HAVE ANY QUESTIONS, GO BACK TO ATOMIC LEARNING AND LISTEN TO THE TUTORIALS, THEY WILL HELP YOU.

IT’S OK TO MAKE MISTAKES, THAT IS HOW YOU LEARN TO DO THINGS ON YOUR OWN. GOOD LUCK.