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

United Airlines is the world’s third largest airline with a fleet of over 850 aircraft that fly a total of 4,500 flights a day to more than 300 cities across five continents. To maintain this fleet of aircraft, United Airlines has 41 instructors helping to shape the students into capable aircraft technicians.

Nothing is more important to United Airlines than safety, so having a crew of well trained, professional technicians is essential. Technicians learn plane and airport maintenance through United Airlines training courses. To increase instructor quality and technician training, it is imperative that United Airlines has up-to-date statistics about courses and instructors.

Our system provides a way for United Airlines to ensure the content of the 737 SAR course is accurate, and that instructors are continuing to effectively train United Airlines aircraft technicians on the Boeing 737 aircraft and all its variations.

The system enables users to generate reports from course data. This report analyzes important factors such as whether course materials contain relevant information, student performance metrics, if questions are worded properly, and the performance of the instructors’ teaching.

The application takes the course content results along with the course preparation materials, and outputs a statistical breakdown for United Airlines to review. Each exam is assigned a score from 0 to 100, which helps instructors color code the exam performance with Traffic Light Protocol.

Our course analyzer is built within Python. For the front end, Tkinter is utilized along with Python packages like NumPy and Pandas. The course learning materials and exam results are hosted on Microsoft SharePoint. Data visualization and statistical analysis can also be viewed using Microsoft Power BI dashboards.