Thursday, December 12, 2013

What Am I Eating? Excel Final Project






 What Am I Eating?  Excel Final Project  

Ever wonder how much fat is contained in the food that you eat?  There are some pretty neat calculators that we can access online to help us track the nutrition and not so nutritious contents of a whole host of foods that we eat.  


WebMD.com Food-O-Meter

One, in particular is available at WebMD.com.  It's called the WebMD Food-O-Meter.  Another great nutritional site is FatSecret.com  You can use these sites to get the nutritional data that you will need to complete this project.

You can find a link with directions for the Excel part of this project on the online Google Drive at What Am I Eating_Excel Sample Just click on the link. 


Instructional Video Tutorials - click on the links below:

Final Project Intro - overview

Step 1 - How to select 10 foods for the final project

Step 2 - How to set up the Excel table 

Steps 3, 4 and 5 - How to sort a table and create a stacked bar chart
                           using Excel

Step 6 - How to convert calories to pounds; how to calculate your Daily Target Caloric Intake (DTCI) to maintain your current body weight level.


Step 7 - Getting to know Food Groups; create a list of 10 healthy foods.



Your grade for this project will be based on your answers to Steps 1 -7 in this  packet, the spreadsheet and the 1-page paper you will type.  You should save your spreadsheet as WhatAmIEating_FirstNameLastName.xls, and your typed answers, including the 1-page document as WhatAmIEating_FirstNameLastName.doc and send them to me via Gmail at rwiegs@gmail.com     This project will represent half your grade for the next marking period.



No comments:

Post a Comment