Embry Riddle AU Airport Airside Information Systems Dashboard Project

Need help with my Management question – I’m studying for my class.

Hello,

Here is all of the info:

OVERVIEW:

Please read through all sections before proceeding to the next page, and refer back whenever necessary.

In this module, you will continue in the same airport information
system project scenario that began in Module 1. To refresh your memory,
please review your submissions in Module 1 and Module 2.

Digital dashboards are dynamic Graphical User Interface (GUI) tools
that can present data and metrics in real-time to decision-making users
of information systems. Digital dashboards enable managers to view
disparate data simultaneously. An example of a digital dashboard that
might be utilized by an airport’s Operations Department personnel is a
digital screen that simultaneously presents one or more live video feeds
intermixed with spreadsheet or table data, charts, etc.

In this Module 3 activity, you will create a mockup of a
hypothetical, customized digital dashboard that the airport’s Operations
Department personnel could utilize for airport airside operations
decision-making and aircraft and vehicle ramp position monitoring
purposes. There are two purposes for engaging in this activity, the
first being to conduct research on and explore the different types of
digital dashboards that are presented in various vendors’ information
systems solutions. The second purpose is to ‘take a break’ from the
mundane composition-type of assignment activities and to engage in some
creative ‘fun.’

You will utilize Microsoft Excel and Microsoft Word
to construct your mockup of a digital dashboard. You will be required
to use your imagination and charting skillsets to organize a video feed
and sets of analytical data into one viewable screen as you craft your
digital dashboard deliverable.

To receive a high-level grade in this project assignment, you must
put forth a considerable amount of time and effort. You will be graded
on the quality of the digital dashboard and the fulfillment of the
requirements stated in the Requirements tab that follows.

INSTRUCTIONS:

Conduct further research on digital dashboards that are utilized in airport information systems. Follow these steps:

    • Survey the data presented on the Module 3 Readings and Resources page to collect your data. You may use the ERAU Hunt Library EAGLEsearch tool (Links to an external site.) and Subject Guides, (Links to an external site.)Links to an external site. as well as the Internet to obtain any additional material you might need.
    • Seek diagrams, pictures, and illustrations of digital dashboards
      that are utilized by airport management from vendors’ websites and other
      informational materials.
    • Construct a hypothetical mockup of a three-part digital dashboard similar to those that were observed in the research process.

REQUIREMENTS:

  • Construct the digital dashboard mockup using Microsoft Word and Microsoft Excel .
  • Open a new Microsoft Word document.
  • Select Layout / Orientation / Landscape on the Microsoft Word toolbar.
  • Present three (3) data sets on one (1) 8.5 x 11 page.
    • Select Columns / One in the dropdown list on the Microsoft Word toolbar.
  • For data set #1, embed a hypothetical “live” video feed (for the
    purposes of this assignment, you will use a static image) of an airport
    security area in the top half of the document page.

    • Search the Internet and find a JPEG image of an aircraft on an airport tarmac or at a gate.
    • Copy and paste the image on the top half of the Microsoft Word document.
    • Title the image as Airport South Terminal Tarmac.
  • For data set #2, embed a Microsoft Excel worksheet on a bottom quarter of the document page.
    • Create the worksheet as follows:
      • Title the worksheet as Airport Gate Assignments
      • Create the data in a size 12 font.
      • Center-justify the data in all cells.
      • Select All Borders for all cells.
      • Row 1: Merge cells A1, B1, and C1 and input the worksheet title.
      • Row 2: Label Columns 1, 2, and 3 as follows: Gate Number; Flight Number, Aircraft Number.
      • Rows 3 through 8: List data in the columns for six (6) different gate numbers, six (6) different flight numbers, and six (6) different aircraft side numbers,
  • For data set #3, embed a Column chart on the other bottom quarter of the document page.
    • Open a Microsoft Excel spreadsheet.
      • Delete Columns C and D.
      • Enter “Hour” in Column A, Row 1.
      • Format the cells in Column A, Rows 2-14 by selecting Custom in the dropdown list and setting “0000” as the Custom value.
      • Input “0600” – “1800” in the cells in Column A, Rows 2-14.
      • Enter “Projected Aircraft Arrivals Per Hour” in Column B, Row 1.
      • Format the cells in Column B, Rows 2-14 by selecting Number with no decimal places in the dropdown list.
      • Input random single-digit whole numbers ranging from“1” to “10” in Column B, Rows 2-14.
      • Highlight the cells in Columns A and B, Rows 1-14.
    • Select a Column chart type from the Chart selection area in the Insert tab on the Microsoft Word toolbar.
      • Replace the default Excel data (that opens up in addition to the
        chart) with the previously-highlighted Excel data by pasting the
        highlighted data over the default data.
      • Select the Plus (+) icon that pops up at the right side of the chart when you select (left-click) the chart.
        • Select Axes.
        • Select Axis Titles.
          • Label the X- Axis as Aircraft Arrivals.
          • Label the Y- Axis as Hour.
        • Select Data Labels.
        • Deselect Legend
      • Left-click anywhere outside of the chart to finish the chart.
      • Right-click on the top-left corner of the chart, select Copy, and then right-click on the Microsoft Word document and select Paste to paste the chart data in the remaining bottom quarter.
  • Be sure to adjust the height and width of each of the three data sets to fit evenly and completely fill up the document page.

MGMT 494 Assignment 3.3 Digital Dashboard Project Rubric

MGMT 494 Assignment 3.3 Digital Dashboard Project Rubric

Criteria

Ratings

Pts

This criterion is linked to a Learning Outcome
Data Sets Provision

50.0
pts
Excellent – ALL THREE data sets were provided.

35.0
pts
Satisfactory – TWO data sets were provided.

0.0
pts
Failing – A minimum of TWO data sets were NOT provided.

50.0 pts

This criterion is linked to a Learning Outcome
Style & Mechanics

25.0
pts
Excellent
– The dashboard was presented on ONE page AND in an 8.5 x 11 size
landscape orientation AND the data sets were presented in the proper
location.

22.0
pts
Very
Good – The dashboard was presented on ONE page AND in an 8.5 x 11 size
landscape orientation OR the data sets were presented in the proper
location.

19.0
pts
Satisfactory
– The dashboard was presented on ONE page OR in an 8.5 x 11 size
landscape orientation AND the data sets were presented in the proper
location.

16.0
pts
Near
Failing – The dashboard was presented on ONE page OR in an 8.5 x 11
size landscape orientation OR the data sets were presented in the proper
location.

0.0
pts
Failing
– The dashboard was NOT presented on ONE page OR in an 8.5 x 11 size
landscape orientation OR the data sets were presented in the proper
location.

25.0 pts

This criterion is linked to a Learning Outcome
Dashboard Format

25.0
pts
Excellent – The data in the data sets were formatted with NO errors.

22.0
pts
Very Good – The data in the data sets were formatted with 3 to 5 errors.

19.0
pts
Satisfactory – The data in the data sets were formatted with 6 to 8 errors.

16.0
pts
Near Failing – The data in the data sets were formatted with 9 errors.

0.0
pts
Failing – The data in the data sets were formatted with MORE THAN 9 errors.

25.0 pts

Total Points:
100.0

Prof. Angela

4.6/5

Calculate Price


Price (USD)
$
Need Help? Reach us here via Whatsapp.