Shopping List

Here is an exercise involving a Shopping List.

  • Create a Word document.
  • Create a table in the document.
  • Put the following columns in the table.
    1. Item,
    2. Brief Description,
    3. Quanity,
    4. estimated cost,
    5. Corresponding Meal (e.g. Breakfast, Lunch, Dinner) for the food item. (Consider that simple case that you will have the item for only one meal)
    6. Importance,
    7. Expected Store of Purchase
  • Enter 5 items into the table and make an entry in each column.
  • Sort the items in alphabetic order by Item

Additional Questions:

Word is great to display information in a report. To analyze data in a table (or work with it) it is better to use Excel (unless the analysis is very simple). 

  1. What could be a suitable layout for a table to show which food items are eaten at several meals, and what are those meals.

  2. What could be a suitable layout for a table to keep track of how much you enjoyed each food item, so that you would buy it again.

  3. What could be a suitable layout for a table to document if you bought the item at a different store?