CSE498, Collaborative Design, Spring 2014
Computer Science and Engineering
Michigan State University

Spectrum Health Systems, located in Grand Rapids, Michigan, provides high quality, high value healthcare through its nine hospitals in West Michigan, which are maintained by 19,000 employees, 1,500 physicians, and 2,600 active volunteers.

Spectrum Health hospitals carry thousands of medications in various dosages. Having the right medication in the correct dosage at the right time is critical to providing high quality health care. One of Spectrum’s many important day-to-day concerns is that of potential medication shortages.

Our Medication Shortages Dashboard provides Spectrum medical personnel with an at-a-glance overview of current national drug shortages. The dashboard displays a concise color-coded synopsis that is easy to process and easy to use.

Dashboard users add the medications that they care about most to their personal watch list, which is displayed at the top of their view of the dashboard.

Our dashboard includes a details page about every medication carried by Spectrum Health’s hospitals, thereby allowing medical personnel to track the history of a drug’s shortage status and to display basic information about it.

Information about medication shortages is pulled in real time from the Food and Drug Administration (FDA) and the American Society of Hospital Pharmacists (ASHP).

Our Medication Shortages Dashboard is built on a Model-View-Controller architecture, using ASP.NET 4.5 with C#. Microsoft SQL server is used to store all shortage information.