preview

Acc564 Week 5 Homewrk

Decent Essays

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 | …show more content…

In this case, it checks the cell containing the plane code to verify that it is only 1 letter. If the test is true, no error message is displayed (the second argument of the IF statement has two double-quotes). If the test is false, it displays the error message in the third argument of the IF function.

Field 4 - Time of take off: * Field check to verify that the field contains valid time format.

Field 5 - Time of landing: * Field check to verify that the field contains valid time format. Same as for field 4 * Reasonableness test that field 5 is greater than field 4.

a. Suggest other controls to minimize the risk of input errors. * prompting to request each required input item. * preformatting to display an input form including all required input items. * completeness check on each input record to ensure all item have been entered. * default values such as today’s date for the flight date. * closed-loop verification (member name would appear immediately after the member number)

10.10 Excel Problem

Creating and testing check digits.

a. Create a spreadsheet that will take as input a

Get Access