These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, December 11, 2014

Grocery Tracker

Author: Morgan Young

Description of Business

Buying groceries is a commonplace occurrence in everyday life. It’s even commonplace to shop at different stores to find the exact product or product price that you want. However, it’s not exactly easy to know which of all of the stores contains the cheapest product.

The Grocery Tracker project was created to help people keep track of their every-day grocery purchases. Grocery stores are largely apprehensive toward allowing people to monitor their prices due to the enormous variability of prices from store to store (even within the same chain). This project allows the user to enter in prices paid for different products. The program will keep track of all of the entries and then display the lowest price for a given product when prompted.

Overview of System

There are several functions within Grocery Tracker which allow a user to manage product prices from the different stores. Here is a list of them:

Add Items

In order to add items to the Grocery Tracker, simply click on the 'Grocery Tracker' tab, then select 'Add Product.' A form will then appear. Fill out the form, and press 'Save.'

Manage Items

Several options exist to customize the addition of products. Within the 'Add Product' form exist several buttons that allow a user to manage types, brands, metrics, stores, and cities. These come in handy when trying to identify which store has the cheapest product. Basic create, edit, and delete functions are supported. NOTE: though a management item may be deleted from the list, it will still appear within the list of products so as to preserve accuracy.

Find the Lowest Price

In order to find the lowest price of a product on Grocery Tracker, click on the 'Grocery Tracker' tab, then select 'Find Lowest Price.' A form will then appear. Two filter options exist: 'Product Name' and 'Product Type.' These filters work alone or together. As the filter is populated, results begin to show up in the 'Lowest Price Results' list. Click on one and see things like the location, store name, brand, metric, and whether the item was on sale! Further price comparison tools exist (see 'Compare all Prices for a Given Product')

Compare all Prices for a Given Product

 The user may also access the pricing for a whole product. This can be accomplished by pressing the 'Compare Other Options' button. This will take the user to a screen whereupon exists a graph displaying all of the different options for a given product. This screen also displays the same information in a list view. This allows the user maximum flexibility to choose the best option when price is not the only deciding factor.

Links

No comments:

Post a Comment

Blog Archive