Hbc2122;Computer Applications In Business Question Paper
Hbc2122;Computer Applications In Business
Course:Bachelor Of Commerce
Institution: Meru University Of Science And Technology question papers
Exam Year:2014
QUESTION ONE – 30 MARKS
a) After thorough feasibility study, Korkiamaki Co. ltd invested n an automated Milking systems(AMS). The AMS reduced the farmer’s working time by 30% , and could help the company produce five (5) million liters of milk from the 600 cows at the firm. Another benefit for choosing AMS is income, when cows move freely in and around barn and go to milking station when it suits them best, they produce more. In the AMS barns, cows milk themselves or go to the milking station, in average of two to seven times a day. AMS is a robotic milking machine that does the job precisely and consistently. With the AMS the farmers have a competitive edge they need at the global agricultural business. Improved agricultural systems secure livelihood and boost country’s food production. (i) Using examples from the passage above outline any three important contributions of computer applications. (6 marks) (ii) State the category of Information systems the AMS falls under. Justify your answer. (4 marks)
(iii) Explain any four components of a system. Use AMS as an example. (4 marks)
b) Describe any three paragraph formatting features of a word processor. (3marks)
c) Distinguish between database and spreadsheet programs. (2 marks)
2
d) Table 1 shows certain fields in a database program.
FIELD NAME DATA TYPE Name Date _ Of _ Birth Fees Photograph
State the most appropriate data type for each field . (4 marks)
e) Define the following terms as used in Microsoft Office application. (i) Mail merging (1 mark) (ii) Word wrap (2 marks) (iii) Work book (2 marks) (iv) Slide (2 marks)
QUESTION TWO –20 MARKS
(a) Mr. Mango is creating an artistic communication of a class scenario and he wishes to include graphics in the word document. (i) Explain how the graphics can be inserted into the document. (4marks) (ii) Describe how you would protect your document with a password. (2 marks) (iii) Outline how you would insert footer on this document. (2 marks
(b) State any two advantages of word processor over manual typewriters. (3 marks)
(c) Explain the importance of the following in document creation. i. Bullets and numbering (2 marks) ii. Spelling and grammar checking (2 marks) iii. Find and replace (2 marks)
(d) Describe how you would create the following data source(Table)using MS Word.(4 marks)
Officer Typist Date printed John Culy 18/10/2011 Bancy Licia 23/11/2011
QUESTION THREE – 20MARKS
(a) Figure 1 is an extract of a worksheet showing details of tourists who visited Meru Game reserve in February,2014. Use it to answer the questions that follow
3
A B C D 1 TOURIST AT MERU GAME RESERVE 2 TYPE NUMBER UNIT FEE($) TOTAL AMOUNT COMMENT 3 Foreign Adults 1000 500 Good 4 Foreign children 900 100 Fair 5 Local Adults 4000 50 Good 6 Local Children 3700 10 Fair 7 8
Total Amount Comment More than $ 100,000 Good Less than $ 100,000 Fair
(i) Explain how you would compute the TOTAL AMOUNTs on column D, from row 3 to row 6 using an appropriate logical function. (4 marks)
(ii) Describe how you would generate the “COMMENTS” shown in the figure above using an IF logical function (4 marks)
(iii) Explain how you would add a row above “LOCAL ADULTS”. (2 marks)
b) Briefly describe the importance of Spreadsheet application software to the unique shuttle manager who intends to buy and implement the software in their office. (4 marks)
c) Differentiate between the following terms;’ i. Absolute cell referencing and Relative cell referencing (2 marks) ii. A Pie chart and Bar chart (2 marks) iii. A workbook and a Work sheet (2 marks)
QUESTION FOUR – 20MARKS (a) Nchiru manufacturers Ltd is a company that manufactures and distributes sisal products all over the country. They have manual management systems. The company’s transactions have increased immensely and this has made the manual system irrelevant. The directors plan to automate their systems. They then approached you for an expertise help in identifying suitable software that would solve their business problems. Kindly propose three software. Justify your advice. (6 marks)
(b) Briefly explain how you would open a presentation program. (2 marks)
(c) Study the powerpoint window below and answer the questions that follow.
4
i. Name and briefly give the function of the features identified by the numbers; 2,3,4,5,7, and 10 (6 marks) ii. Explain how you would add a slide at number 3 (2 marks) iii. Describe how you would create a customized animation of the slides , such as a flying entrance effect to slide 1 (3 marks) iv. Explain how you would create a slide show with a timing of five seconds per slide. (1 mark)
QUESTION FIVE -20 MARKS
(a) MUST has a student population of over 3000 students. They are planning to develop a database for all the students and thus soliciting expertise advice. Help the university understand the importance of databases. (6 marks)
(b) Database software is a system. If you agree with this proposition, mention any four major components of MS-Access software. (6 marks)
(c) Briefly explain the importance of primary key in creation of databases. (4 marks)
(d) Briefly discuss any three types of databases. (4marks)
More Question Papers