From Students…

…to Professionals

The Capstone Experience

Project PlanTraining Scheduling and Optimization System III

Team United Airlines TrainingAmanda Hackbardt

Weiyu HuangGeorge Poliakov

Sam VituSean Wisely

Department of Computer Science and EngineeringMichigan State University

Spring 2020

Functional Specifications

• Update and Finalize the Learning Scheduling system from the 2 previous capstone teams

• Improve back end to reflect United Airlines standards

• Improve workflow in current application

• Allows the Tech Ops team to update information in the system as they need to

The Capstone Experience Team United Airlines Training Project Plan Presentation 2

Design Specifications

• Web application for scheduling for United Airlines

• Create optimal schedules based on pre-selected criteria

• This application needs to be integrated into production systems

• Develop a new scheduling workflow

The Capstone Experience Team United Airlines Training Project Plan Presentation 3

Screen Mockup: Landing Page

The Capstone Experience 4Team United Airlines Training Project Plan Presentation

Screen Mockup: Calendar

The Capstone Experience 5Team United Airlines Training Project Plan Presentation

Screen Mockup: Adding Classes

The Capstone Experience 6Team United Airlines Training Project Plan Presentation

Screen Mockup: Schedule Optimizer

The Capstone Experience 7Team United Airlines Training Project Plan Presentation

Screen Mockup: Optimizer Cont.

The Capstone Experience Team United Airlines Training Project Plan Presentation 8

Screen Mockup: Optimizer Cont.

The Capstone Experience Team United Airlines Training Project Plan Presentation 9

Screen Mockup: Conflict Overview

The Capstone Experience Team United Airlines Training Project Plan Presentation 10

Screen Mockup: Training Requests

The Capstone Experience Team United Airlines Training Project Plan Presentation 11

Screen Mockup: Course Catalog

The Capstone Experience Team United Airlines Training Project Plan Presentation 12

Screen Mockup: Exceptions

The Capstone Experience Team United Airlines Training Project Plan Presentation 13

Screen Mockup: Instructor Qualifications

The Capstone Experience Team United Airlines Training Project Plan Presentation 14

Screen Mockup: Attendance

The Capstone Experience Team United Airlines Training Project Plan Presentation 15

Screen Mockup: Admin

The Capstone Experience Team United Airlines Training Project Plan Presentation 16

Screen Mockup: Mobile Home

The Capstone Experience Team United Airlines Training Project Plan Presentation 17

Screen Mockup: Mobile Calendar

The Capstone Experience Team United Airlines Training Project Plan Presentation 18

Screen Mockup: Mobile Course Schedule

The Capstone Experience Team United Airlines Training Project Plan Presentation 19

Screen Mockup: Mobile Schedule Planner

The Capstone Experience Team United Airlines Training Project Plan Presentation 20

Screen Mockup: Mobile Add Class

The Capstone Experience Team United Airlines Training Project Plan Presentation 21

Screen Mockup: Mobile Optimizer

The Capstone Experience Team United Airlines Training Project Plan Presentation 22

Screen Mockup: Mobile Training Requests

The Capstone Experience Team United Airlines Training Project Plan Presentation 23

Screen Mockup: Mobile Course Catalog

The Capstone Experience Team United Airlines Training Project Plan Presentation 24

Screen Mockup: Mobile Exceptions

The Capstone Experience Team United Airlines Training Project Plan Presentation 25

Screen Mockup: Mobile Qualifications

The Capstone Experience Team United Airlines Training Project Plan Presentation 26

Screen Mockup: Mobile Admin

The Capstone Experience Team United Airlines Training Project Plan Presentation 27

Technical Specifications

• Microsoft SQL Server Database

• Azure Data Studio

• Node JS, Angular, Entity Framework, ASP .NetCore, C#

• Azure Cloud Server

The Capstone Experience Team United Airlines Training Project Plan Presentation 28

Front-End Design Specifications

• Angular

• HTML

• CSS

• Bootstrap

The Capstone Experience Team United Airlines Training Project Plan Presentation 29

System Architecture

The Capstone Experience Team United Airlines Training Project Plan Presentation 30

System Components

Hardware Platforms▪ Azure Server

▪ Personal laptops

▪ Virtual Machine and SQL database running on Azure

Software Platforms / Technologies▪ Visual Studio

▪ Azure Git

▪ Azure Data Studio

▪ Oracle Access Manager (OAM)

The Capstone Experience Team United Airlines Training Project Plan Presentation 31

Risks

• Updating from ASP .NET 2.2 to 3.1▪ There are several documented code breaks upon upgrade▪ Mitigate by researching/testing upgrade immediately

• Dealing with Historical Data▪ Unfamiliar with scope/format and how to clean the data▪ Mitigate by researching how to put data in a template

• Running Oracle Access▪ Previous team couldn't integrate OAM▪ Mitigate by researching OAM use in Azure App Service

• Optimizer Functionality▪ The optimizer is inefficient▪ Mitigate by studying the algorithm and improvements

The Capstone Experience Team United Airlines Training Project Plan Presentation 32

Questions?

The Capstone Experience Team United Airlines Training Project Plan Presentation 33

?

? ??

?

?

?

?

?