UNIVERSITY EXAMINATIONS: 2018/2019
EXAMINATION FOR THE DIPLOMA IN INFORMATION
TECHNOLOGY AND DIPLOMA IN BUSINESS INFORMATION
TECHNOLOGY
DCU201 DIT206 COMPUTER APPLICATION SOFTWARE
DATE: NOVEMBER, 2018 TIME: 2 HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions.
QUESTION ONE COMPULSORY (30 MARKS)
a) Define the following terms. [3 Marks]
i. Computer
ii. Software
iii. Hardware
b) Describe the key features in the first, second and Third generation. [3 Marks]
c) Distinguish between relative and absolute cell references in a worksheet. Use examples
[4 Marks]
d) Describe THREE purposes of networks in an organization. [3 Marks]
e) Describe the term Application Software [3 Marks]
f) Identify the labeled parts of Ms excel window and give a brief explanation for each.
[6 Marks]
g) Explain FIVE advantages of using accounting program as compared to manual record
Keeping. [4 Marks]
h) Define a Peripheral device giving THREE examples. [4 Marks]
QUESTION TWO (20 MARKS)
a) Explain FIVE reasons why computers are considered to be useful in business organizations.
[5 Marks]
b) Outline FIVE factors you would use to differentiate between off the shelf and bespoke
software. [5 Marks]
c) Outline how you would perform the following in Ms Word. [4 Marks]
i. Save an existing file with a different name.
ii. Protect your file with a password
d) Outline how you would perform the following in Ms Excel. [3 Marks]
i. Copy a formula to adjacent cells
ii. Re name a worksheet
iii. Delete a row
e) State THREE examples of operating systems in the market today. [3 Marks]
QUESTION THREE (MARKS)
a) State and briefly explain the parts that make up the CPU. [4 Marks]
b) Differentiate the following: [4 Marks]
i. Format painter and Water Mark
ii. Toggle case and Sentence Case.
c) State and briefly explain at least four accessories that windows provide. [4 Marks]
d) Explain the process one can use to quit a program that’s not responding. [4Marks]
e) Discuss three database users [4 Marks]
QUESTION FOUR
a) Write formulas for the operations (i) – (iv) based on the spreadsheet given below along with
the relevant cell address:
i. To calculate the Total Marks as sum of Science, Maths & Computers for each student and
display them in column F. [4 Marks]
ii. To calculate the average marks for each student and display them in column G [3 Marks]
iii. To calculate the highest marks in Computers and display it in cell E7 [2 Marks]
b) Computer memories are classified into two categories. State and briefly describe them and
give two examples of each category. [6 Marks]
c) Discuss the disadvantages of using computers. [5 Marks]
QUESTION FIVE
a) Give THREE advantages of a graphical user interface (GUI) [3 Marks]
b) State FOUR components of Information structure of a file. [4 Marks]
c) Explain the following features of Ms Word. [4 Marks]
i. Spell check
ii. Autocorrect
iii. Macros
iv. Mail Merge
d) Explain the following terms as used in Ms excel. [4Marks]
i. Spreadsheet
ii. Formula
iii. Function
iv. Print area
e) Explain FIVE features you would look out for when purchasing computer software.
[5 Marks]
