CSE498, Collaborative Design, Spring 2013
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.

In order to manage such a large and complex organization, Spectrum Health leadership must be able to know how well they are meeting their business objectives and service-level agreements. Business metrics help leadership evaluate progress of business initiatives and assist in decision-making.

Our SLA Management and Metric Reporting System allows metric data to be managed easily and viewed by users. Leadership can quickly view data using succinct scorecards that display up to six months of metric data.

Designated users can define new metrics and scorecards. A metric creator can designate specific users to enter monthly data, choose the scorecards on which to display the metric data, and add detailed information about the metric, such as the method used to calculate the data.

Once the monthly data has been entered, leadership can review the completed scorecard. Information is presented in a color-coded format. Monthly values that hit their target are shaded green, while unsatisfactory values are shaded yellow or red, depending on the severity.

Our SLA Management and Metric Reporting System is written in HTML, CSS and jQuery. The data is stored in a MySQL server and the backend API is written in PHP.