Data Model

For our prototype for team assignment 3,
we developed a Google Form to collect data for the bookstore.
The major problem with the bookstore is that its ordering system is very
outdated and it takes the user a long time to find an order
number because it is a spreadsheet with every order since the bookstore
first opened. This makes finding and sorting through the orders
as well as figuring out which orders are highest priority very difficult.
This problem often leads to orders being unfulfilled or late which creates
a very unhappy customer.

Because the bookstore did not state any problems with communicating
with Bookstore Co. or the other bookstores, this area of data collection was the
only aspect of the system process that needed to be fixed. Our team believes that
one of the simplest and most effective ways to eliminate the clutter and disorganization
with the bookstore’s data collection is to simply create a Google Form. Our Google Form
prototype asks many different questions such as name and student idea number, book form
and ownership, book details, as well as the urgency of acquiring the book. It is very easy
to fill out and took team members under 3 minutes to answer the questions during a sample run through.

This form also splits off to a section for professors where they are able to order different sizes of class sets from the bookstore. All of this data is then collected and can be easily downloaded as a spreadsheet which records the date and time submitted which helps establish priority with orders. However, the bookstore
can avoid the same clutter it has now by creating an identical copy of the form each semester, breaking up the bulk. Information would then be organized and easy to go through.
The Google Form can also help the bookstore develop statistics of how often
certain books are ordered, whether it is more popular to rent or buy, and so on and so forth,
using the charts and graphs the form provides users.



Link to our Google Form:

Comments