Free Essay

Submitted By melored
Words 860
Pages 4
ACC564; Excel Problem 8.3
NAME
22-Feb-11

Member # "Flight Date
DDMMYY" Plane Used Takeoff Time Landing Time
1234 311109 G 0625 0846
4111 011109 C 0849 1023
1210 011109 P 0342 0542
0023 011109 X 0159 1243
012A 011109 P 1229 1532
0999 011109 L 1551 1387
*G = Glider; C = Cessna; P = Piper Cub; L = Lear Jet

a. The following describes one or more input edit controls that could be included in the program for detecting possible errors for each of the five data fields:
1) Member #: The facts state that the Member numbers are numbered sequentially and that there are less than 2000 members total.
a) Field check - to determine that the proper type of character is entered in the field. In this case, only numeric characters allowed.
b) Limit check - to determine that the numeric amount entered does not exceed a predetermined numeric value, e.g. 2000 in this case.
c) Range check - to determine that upper and lower limits are valid, otherwise similar to the limit check, e.g. 0001 - 2399 in this case.
d) Size check - to ensure that input data will fit into the assigned field, e.g. no more than 4 characters in this case. 2) Flight date: The facts state that the format is DDMMYY
a) Field check - to determine that the proper type of character is entered in the field. In this case, only numeric characters allowed.
b) Size check - to ensure that input data will fit into the assigned field, e.g. no more than 6 characters in this case.
c) Check digit verification - There are only so many valid combinations of days and months in the year, for example, November has 30 days, so a day higher than 30 would be invalid 3) Plane used: The facts show that there are only 4 planes presently used, identified by the, at this time, unique first letter of the type of plane.
a) Field check - to determine that the proper type of character is entered in the field. In this case, only alphanumeric characters are valid.
b) Size check - to ensure that input data will fit into the assigned field, e.g. no more than 1 character in this case. 4) Takeoff Time: The facts state that the planes are rented by the hour and all must be returned the same day.
Per review of the input, it appears that the time is tracked by military time, which uses a 24 hour clock beginning at 0000 at midnight to 2399 at 11:59pm.
a) Field check - to determine that the proper type of character is entered in the field. In this case, only numeric characters allowed.
b) Limit check - to determine that the numeric amount entered does not exceed a predetermined numeric value, e.g. 2359 in this case.
c) Range check - to determine that upper and lower limits are valid, otherwise similar to the limit check, e.g. 0001 - 2359 in this case.
d) Size check - to ensure that input data will fit into the assigned field, e.g. no more than 4 characters in this case. 5)Landing Time: Same as Takeoff Time discussed above, in addition to the following: a - d as show above for the Takeoff time
e) Reasonableness test - to determine the correctness of the logical relationship between two data items. In this case the relationship between the takeoff time and the landing time, and the flight date. The entire flight should occur on the same date within the hours eligible for one day, or 0001 to 2399.

b. Identify and describe any errors in the records - The fields with errors are highlighted in orange above
1) There is a member number with an alpha character when the facts state that the member number should be between 0001 and 1999
2) The first line indicates 311109 in the flight date field which has a format of DDMMYY. There are only 30 days in November, so this appears to be an input error.
3) The fourth line of data indicates a plane that is not in the key. The input for type of plane is "X" when the only valid entries are "G, C, P and L."
4) The last line shows a landing time that appears to be invalid. Assuming they are using military time, there would be no such time as "1387". In addition if the landing time is in the 1:00 hour, then the flight would have landed prior to the stated takeoff time, which suggests 3:51 pm.

c. After the data was entered as shown in the problem, the following controls were added to prevent the input of erroneous data:
1) Click on fields in the Member#, Flight Date and Plane Used fields to see input messages
2) The only valid numbers for the Member# is set at between 0001 and 1999, in accordance with the number of possible members.
3) There is a validity check on the Landing time field to check that it is prior to the corresponding entry in the Takeoff Time field
4) Only numeric numbers are valid in the Takeoff Time and Landing Time fields

### Similar Documents

...Social Networks and Media Conquer B2B Social Networks are a flourishing phenomenon in today’s generation. It has already entered and affected the B2C network. In B2C network the social networks have become a concerning factor and plays a major role in marketing and communications. As we are all familiar with the B2B network and what does it actually implies, the question arises whether the social networks can play an important role in B2B network and for B2B companies. Social networks are not another passing phenomenon; they have matured and have registered themselves highly in the minds of the customers. B2B network also gets conquered by the social networks the business houses that trade with each other are actually the customers of each other and they also engage themselves in social networking. Some useful statistics from the social networking world states that the total time spent on social media has increased from 6% in 2007 to 20% in 2011. The registered users will almost reach 2 billion people by 2014. These figures show relentless growth and usage of social media. Already 91% of the B2B companies are active on Facebook, 53% on Twitter and 47% on LinkedIn. These statistics reveal that social media has conquered B2B network and has entered in that chain as means of effective communication and presentation. B2B companies deal with people and not robots. So the influence of emotions before purchasing a product is applicable to them also as they are not immune to......

Words: 798 - Pages: 4

Words: 905 - Pages: 4

Free Essay

...to this issue. The latest issue can be found on the Edexcel website: www.edexcel.com References to third-party material made in this specification are made in good faith. Edexcel does not endorse, approve or accept responsibility for the content of materials, which may be subject to change, or any opinions expressed therein. (Material may include textbooks, journals, magazines and other publications and websites.) Authorised by Roger Beard Prepared by Susan Hoxley Publications Code BH029073 All the material in this publication is copyright © Edexcel Limited 2011 Edexcel BTEC Level 4 HNC Diploma in Business Edexcel BTEC Level 5 HND Diploma in Business Edexcel BTEC Level 5 HND Diploma in Business (Accounting) Edexcel BTEC Level 5 HND Diploma in Business (Management) Edexcel BTEC Level 5 HND Diploma in Business (Marketing) Edexcel BTEC Level 5 HND Diploma in Business (Human...

Words: 15079 - Pages: 61

Free Essay

Words: 799 - Pages: 4

...Unit Title: The Business Environment Guided Learning Hours: 160 Level: Level 5 Number of Credits: 18 Learning Outcome 1 The learner will: Understand the significance of the environment on business activity. Assessment Criteria The learner can: 1.1 Explain the features of business activity. Indicative Content 1.1.1 Explain the business organisation as a transformation process. 1.1.2 Describe the different ways in which a business may structure its activities. 1.2 Discuss the complex interactions that operate between a business and its environment. 1.2.1 Discuss the complexity, volatility and uniqueness of an organisation's environment. 1.2.2 Explain the influence of shareholders on the internal environment of an organisation. 1.2.3 Outline the nature of the external environment (PEST). 1.3 Explain the need for change and its management within an individual business. 1.3.1 Discuss the need to monitor changes in the external environment. 1.3.2 Discuss the implications of environmental change for a business, its stakeholders and society. 1.3.3 Explain reasons for resistance to change by firms, managers and employees. 1.3.4 Describe ways in which resistance to change may be overcome. Learning Outcome 2 The learner will: Understand the structure and organisation of business. Assessment Criteria The learner can: 2.1 Discuss the impact of industrial and legal structure and size on organisational behaviour. Indicative Content 2.1.1 Classify......

Words: 1138 - Pages: 5

Words: 1147 - Pages: 5

Words: 908 - Pages: 4

Words: 1383 - Pages: 6

Words: 763 - Pages: 4

...ecutive Summary The New Australian Company is a new red wine brand that will be introduced in Singapore. The brand is a unique and high quality red wine brand that meets the growing preference of consumers. It will be distributed to several hotels, restaurants, supermarkets, and wine boutiques/shops that are located in the commercial business districts of the city-state. The brand is managed and owned by a group of wine-lover businessmen who have tremendous experienced in business administration, marketing and sales management and customer service. The owners are now looking for additional investments in order to capitalize the project well. The company has already made several negotiations with successful business distributors in Singapore. The company is confident to compete with many large distributors because it is closely working with top-notch suppliers and manufacturers who are known as wine experts or cellar masters. The target market is the Generation Y or the millennial because it is 77 percent of the population. This group also consumes wines at a faster and higher rate. The sales forecasts for the New Australian Company begin with \$700,000 for the first year, and this will increase to 50 percent (\$1, 050,000) in the second year, and 60 percent (\$1,680,000) in the third year of operation. The company will be expecting a profit margin of 30-40 percent, and at least 25 percent return of investment in the first operational year. The company wants to change...

Words: 1216 - Pages: 5

Words: 778 - Pages: 4

Free Essay

Words: 1532 - Pages: 7

Words: 9175 - Pages: 37