Acc564 Week 5 Homewrk
10.3 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 DateMM/DD/YY | Plane Used | Takeoff time | Landing time | 1234 | 09/10/10 | G | 6:25 | 8:46 | 4111 | 09/01/10 | C | 8:49 | 10:23 | 1210 | 09/01/10 | P | 3:42 | 5:42 | 0023 | 09/01/10 | X | 1:59 | 12:43 | 012A | 09/01/10 | P | 12:29 | 15:32 | 0999 | 09/01/10 | L | 15:31 | 13:45 |
Valid plane codes (plane used column): C = Cessna, G = glider, L = Lear Jet, P = Piper Cub) a. Identify and describe any errors in the data.
Five of the six records contain errors as follows: 1st - Wrong date is used (September 10 instead of September 1). 2nd - Member number is outside range (4111 is greater than 1368). 4th - Plane code X is not valid. 5th - Member number contains a character (A). 6th - Plane landing time (13:45) is earlier than the take off time (15:31).
b. For each of the five data fields, suggest one or more input edit controls that could be used to detect input errors. Field 1 - Member number: * Range check to verify that the field contains only four digits within the range of 0001 to 1368. * Validity check on member number if a file of valid member numbers is maintained. Field 2 - Date of flight start: * Check that day, month, and year corresponds to the current date. * Field check that value is a date Field 3 - Plane used: * Validity check that character is one of the
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 DateMM/DD/YY | Plane Used | Takeoff time | Landing time | 1234 | 09/10/10 | G | 6:25 | 8:46 | 4111 | 09/01/10 | C | 8:49 | 10:23 | 1210 | 09/01/10 | P | 3:42 | 5:42 | 0023 | 09/01/10 | X | 1:59 | 12:43 | 012A | 09/01/10 | P | 12:29 | 15:32 | 0999 | 09/01/10 | L | 15:31 | 13:45 |
Valid plane codes (plane used column): C = Cessna, G = glider, L = Lear Jet, P = Piper Cub) a. Identify and describe any errors in the data.
Five of the six records contain errors as follows: 1st - Wrong date is used (September 10 instead of September 1). 2nd - Member number is outside range (4111 is greater than 1368). 4th - Plane code X is not valid. 5th - Member number contains a character (A). 6th - Plane landing time (13:45) is earlier than the take off time (15:31).
b. For each of the five data fields, suggest one or more input edit controls that could be used to detect input errors. Field 1 - Member number: * Range check to verify that the field contains only four digits within the range of 0001 to 1368. * Validity check on member number if a file of valid member numbers is maintained. Field 2 - Date of flight start: * Check that day, month, and year corresponds to the current date. * Field check that value is a date Field 3 - Plane used: * Validity check that character is one of the