least detect, each of the errors in the data set.
+-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, 2017:
FLIGHT DATE
PLANE
TAKEOFF
LANDING
MEMBER #
MM/DD/YY
USED*
TIME
TIME
1234
09/10/17
G
6:25
8:46
4111
09/01/17
C
8:49
10:23
1210
09/01/17
P
3:42
5:42
0023
09/01/17
X
1:59
12:43
012A
09/01/17
L
12:29
15:32
0999
09/01/17
P
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)