My mother works for a local non-profit agency called Parents And Children Together. They provide family and child services for those who are in need. On occasion, the agency hosts a silent auction where they auction donated items and services. These items are donated from various sources and are sold to the attendees of the silent auction.
Currently, the agency uses multiple spreadsheets to track donated items and services as well as those who donated them. During the auction, bids are placed manually for each item with the bidder writing their bid down on a piece of paper. Once the auctioning closes, all papers are gathered and the winners are input into another spreadsheet which is then posted on the wall.
While the current system in place is functional, I believe that much of this can tracked much more efficiently. Creating a database to store donors, bidders, items, prices, and payments will give the agency a way to better access this information in a way that is helpful to all stakeholders. In addition, adding a front end system that would make data entry and reporting quicker and easier would greatly benefit the organization. If possible, creating an interface where bidders can easily enter their bids into a computer system would make the process much more streamlined and accurate.
Most of this project is fairly "easy" in terms of creating the database to store the data. The challenge is creating an application that is easy for the agency to operate. The most difficult part of this system will be to create an efficient and non-intrusive/non-technical interface for bidders to enter their bids.