1. Create three meals, one from each of your three favorite restaurants

Below will find a list of links to the nutritional information of the fast food restaurants you will be choosing a lunch from. Choose the three restaurants you prefer the most. From each, choose the following:

(Note that the suggestions in parenthesis are only examples. You can choose any item from a menu that fits into that catagory of item!)

For each of your three meals, you will create a worksheet tab with the name of the restaurant the meal comes from:

Screenshot of the spreadsheet tabs
Figure 1: Create a tab for the meal from each restaurant

For each of your three meals, get the Total Fat, Carbohydrates, Sodium, Protein, and calories. Record the information similar to the following:

Screenshot of meal layout
Figure 2: The five pieces of nutritional information needed for each meal item

Take note that the totals for each meal must be added (See Figure 2). (Do Not attempt to use the data from the screenshot! It is fake and there only as an example.)

(Technical Note: Many of the links below require the Adobe Acrobat Reader. Please ask your instructor if you are unsure if your machine has the Reader installed. If you have never used the Reader, you can click here to view a tutorial.

Very important: With any link below that has [PDF] beside of it, right-click (Windows) or Ctl-Click (Mac) on the link and choose "Save target as..." Save the PDF document to a folder of your choice and open it from there. Trying to open the PDF document within the browser may cause your system to lock up.

Fast Food Nutrition Links

2. Put the totals from each of your three meals in a comparison sheet

Copy and paste the totals for each restaurant's meal similar to the following:

Screenshot of comparison layout
Figure 3: The totals from the three meals plus the government RDA numbers

Getting the Recommended Daily Allowances (RDA) Data

To get the information for the RDA, first click here. This page will give you the RDA amounts for an entire day. Since you are wanting the RDA amounts for one meal, simply divide the RDA amounts on this page by three (because people generally eat three meals a day). Use the 9-13 male or female numbers, whichever one is higher. Use whatever the quotient is as the RDA number needed for comparison.

3. Create a column chart based on the comparison data (except for the Calories)

This should yield a chart with four catagories, with four bars per each catagory. Three of the bars will represent the meals you created, while the fourth will represent the government-prescribed RDA. Place the chart in the Comparison worksheet with the data, and format the Data Labels to Values. Label the X and Y Axis appropriately.

4. Make some sense of your numbers

Now you must decide what the numbers actually mean so that you can make a good recommendation to Jan. Visit the following links regarding different health topics related to nutrition. As you read, be sure to consider the data you collected about your lunches.

5. Recommend the best lunch to Jan

Write a business letter to Jan explaining which meal should be ordered for everyone. In the letter, try to answer the following questions:

When you write you letter, make sure to follow the 2012-2013 FBLA guidlines [PDF] for a Business Letter. Jan's address is:
Jan Jones
21 Woodchuck Cabin
Camp YeeHaw
Jackson, KY 41339
(Remember, you really want to make a good impression!)

You're almost done! Let's continue on to the evaluation page!