Grocery Price Comparison Database

1
Grocery Price Comparison DatabaseCreated by
Tyler McDuffie

• March 9, 2010
• Riverview High School

2
Identifying Problem within a Social Context

• Difficulty finding cheapest grocery prices.
• Looking through flyers is time consuming.
• Economic issue
• End-User Daniel Hogan

3
Analyzing the Problem and the Feasibility Study

• Chosen IT solution Database accompanied by a
  website.
• A database can hold large amounts of data in an
  organized matter.

4
Software Used
Name of item Manufacturer Model Number Version number for software Where did you obtain the item
Microsoft Access Microsoft 11.8166.8172 2007 School computer, free trial
Weebly.com Weebly None Founded in 2006 Internet, free sign up
5
Planning and Developing the Chosen IT Solution

• Databases website http//mygrocerydatabase.weebl
  y.com/
• Go to link and read through the instructions and
  access the database.

6
Planning and Developing the Chosen IT Solution

• Fields included in database Publix price,
  Sweetbay price, description/size, and Walmart
  price.
• Prices are ranges, not updated weekly.
• 35 items

7
Completed Database
8
Testing and Evaluating the Solution

• 1st Test
• Tester Daniel Hogan
• Alpha model only had three fields.
• Updated weekly sales?

9
Testing and Evaluating the Solution

• 2nd Test
• Tester Daniel Hogan
• Revisions Price ranges, added Wal-Mart prices,
  and meats added to food list.

10
Testing and Evaluating the Solution

• 3rd Test
• Tester Mrs. Livesey
• She told me to add the sizes of food items.

11
Assessing the Social Significance within the
Product

• Database works and it is useful!
• My project as of now only targets the Sarasota
  community.

12
Assessing the Social Significance within the
Product

• It eliminates time consuming grocery price
  comparing techniques.
• I couldnt find a way to add sales because it
  would make price ranges inaccurate.

13
Quiz

1. What issue does the database target?
2. What form of IT solution did I choose?
3. What is the name of the website creator I used?
4. Name the fields that are included in the
   database.
5. Prices are displayed as _______

14
Quiz

• 6. What software is the database viewed through?
• What supermarkets does the database compare?
• How many items are in the database?
• Who was my end-user?
• Why do sales present a problem to the database?

15
Grocery Price Comparison DatabaseCreated by
Tyler McDuffie