Excel Problem
The Moose Wings Cooperative Flight Club owns a number of airplanes and gliders. It serves fewer than 2,000 members, who are numbered sequentially from the founder, Tom Eagle (0001), to the newest member, Jacques Noveau (1368). Members rent the flying machines by the hour, and all must be returned on the same day. The following six records were among those entered for the flights taken on September 1, 2010:
MEMBER # | FLIGHT DATE MM/DD/YY | PLANE USED* | TAKEOFF TIME | LANDING TIME |
1234 | 9/10/13 | G | 6:25 | 8:46 |
4111 | 9/01/13 | C | 8:49 | 10:23 |
1210 | 9/01/13 | P | 3:42 | 5:42 |
23 | 9/01/13 | X | 1.59 | 12:43 |
012A | 9/01/13 | P | 12:29 | 15:32 |
999 | 9/01/13 | L | 15:31 | 13:45 |
*C = Cessna, G = Glider, L = Lear Jet, P = Piper Cub
REQUIRED
a. Identify and describe any errors in the data.
b. For each of the five data fields, suggest one or more input edit controls that could be used to detect input errors.
c. Enter the data in a spreadsheet, and create appropriate controls to prevent or at least detect the input errors.
d. Suggest other controls to minimize the risk of input errors.
(SMAC adapted)
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.