Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i just need C and D detect, each of the errors in the data set 10.3 Excel Problem The Moose Wings Cooperative Flight Club owns

image text in transcribed
i just need C and D
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: TAKEOFF TIME 6:25 FUGHT DATE PLANE MEMBER MMDD/YY USED 1234 09/10/17 G 4111 09/01/17 1210 09/01/17 P 0023 09/01/17 012A 09/01/17 0999 09/01/17 "C - Cessna, G = Glider L-Lear Jet, P = Piper Cub 8:49 LANDING TIME 8:46 10:23 5:42 12:43 15:32 13:45 3:42 1:59 12:29 15:31 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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Markets And Institutions

Authors: Peter Howells, Keith Bain

5th Edition

0273709194, 9780273709190

More Books

Students also viewed these Accounting questions

Question

What is the cerebrum?

Answered: 1 week ago