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

United Airlines is a Fortune 500 airline company that flies over 850 aircraft and has flights to hundreds of destinations. In 2019, over 160 million passengers flew on United Airlines flights, an all-time-high for the company.

When it comes to air travel, safety is of the utmost importance. That is why at United Airlines, various safety and compliance metrics are used to keep track of safety at each of their seven hubs in the continental United States. These metrics, however, are currently created and managed manually, which takes a significant amount of time for United Airlines employees.

Our Performance Scorecard Automation quickly generates attractive safety metric scorecards, which eliminate human error and the tedium of manually selecting and entering data.

The Performance Scorecard Automation tool automatically reads data from several Excel files that contain the raw safety and compliance data for various airports. The tool then automatically generates a PowerPoint containing pertinent data based on a specified PowerPoint template.

Users can specify any combination of raw Excel data, template PowerPoints, and our own proprietary design files. These design files easily generate associations between raw Excel data and the finalized PowerPoint presentations and maintain the desired look and feel of a manually created PowerPoint.

Our tool enables users to easily create future scorecards without manual adjustment, while also making the program customizable in case the data needs to be changed.

The Performance Scorecard Automation saves time for United Airlines’ employees and improves the safety of United Airlines.

The Performance Scorecard Automation is written using C# with the .NET Framework. It uses Microsoft’s Office Interop Libraries for interfacing with Excel and PowerPoint.