Practice Lab Friday March 3
- In this lab you will continues to work with AirlineOperations
application.
- Open the SAME file you worked during Graded lab on Wed. Creat new sheet, call it, March3
- Create a Button:
- Enter Clear
Selections in the Text input field.
- On the Action Tab: Click the Add button, select the Clear All option
from the Action list on the
right, and click on OK
- Make a few selections and then click the Button you created above and
observe the Action
- Create a Gauge Chart to display the percentage of
occupied
seats compared to those that were available on each flight. Title the
chart: Load Factor %.
-
Expression: Sum ([# Transported Passengers]) / Sum ([# Available Seats])
- Label: Load Factor %
- At Presentation Tab: Min and Max values will be 0.5 and 1 respectively
- Add 2 more segments
- Segment 1:Lower Bound: 0.5, Color: Red
- Segment 2:Lower Bound: 0.625 Color: Orange
- Segment 3:Lower Bound: 0.75, Color: Yellow
- Segment 4:Lower Bound: 0.85, Color: Green
- On the Presentation tab, select: Show
Scale, Show Labels on Every Major Unit, Hide Segment Boundaries,
and
Hide Gauge Outlines.
- Set the value of Show Scale to 6 Major Units, set the value of
Show Labels
on Every to 1 Major Unit
- Number Format: Integer and
Show in
Percent (%).
- Make selection and compare results on the Gauge and other
charts that display Load Factor