The Aerospace Corporation

Abstract

The Job Order Analysis Tool (JOAT) project is a continuation of the 2011-2012 JOAT senior design project. The 2011-2012 senior design team was then assigned with JOAT and Dr. Abbott along with Denny Ly being the advisors. Now the project has been handed off to the 2013-2014 senior design team for improvements to the project.

The Job Order Analysis Tool is a web application tool written primarily in the Google Web Toolkit framework. It provides managers and staff with graphical information directly related to the job order numbers that are charged by employees in the Aerospace organization to provide support for a project/program. It is based on a modular designed framework that allows a developer to build a website that takes in large amounts of data (mostly point-based, graphical data) and allows for the plotting of this data on different types of charts for a visual look at the information that might not be suggestive of trends/outcomes otherwise.

The Job Order Analysis Tool (JOAT) gives Aerospace members and managers a simple and easy-to-use Web-based application interface to view various charts relating to JOs. The JOAT receives the JO data from managers and administrators via Excel spreadsheets (xlsx) and graphs that data for users to analyze trends and compare the progress of JOs. The primary charts in JOAT are financial charts. These chart consist series including Actual, Funding and Plan. Other data types available in JOAT are member of technical staff (MTS) and staff years of technical effort (STE).  The JOAT also provides different chart types, which include column, bar and line. This gives the user the flexibility to view the chart in the form that best fits their report.