UNIVERSITY EXAMINATIONS: 2017/2018
EXAMINATION FOR THE DIPLOMA IN INFORMATION
TECHNOLOGY/DIPLOMA IN BUSINESS INFORMATION TECHNOLOGY
DCU201 COMPUTER APPLICATION SOFTWARE
FULLTIME/PARTTIME
DATE: MARCH/APRIL 2018 TIME: 2 HOURS
INSTRUCTIONS: ATTEMPT QUESTION ONE AND ANY OTHER TWO QUESTIONS.
QUESTION ONE
a) Using a well labeled diagram explain computer parts [6 Marks]
b) Differentiate between the following terms
i. System and application software [2 Marks]
ii. Data and information [2 Marks]
iii. RAM and ROM [2 Marks]
c) Explain FOUR types of computer classifications giving examples in each scenario.
[8 Marks]
d) Explain FOUR advantages of Office Automation Systems. [4 Marks]
e) Explain TWO reasons why computers are considered to be useful in business organizations.
[2 Marks]
f) Explain FOUR views that you normally use from time to time when one is working with power
point application [4 Marks]
QUESTION TWO
a) List any FOUR database management application software [4 Marks]
b) Explain FIVE types of charts that can be created in Ms excel application [5 Marks]
c) Explain any THREE computer networking devices [6 Marks]
d) Explain FIVE use of power point presentation in the current times. [5 Marks]
QUESTION THREE
a) Define the term text-box as used in word processing [2 Marks]
b) List SIX Characteristics of a computer. [6 Marks]
c) Explain FOUR categories of computer hardware. [4 Marks]
d) List FOUR operating systems in the market today. [4 Marks]
e) List four functions of the operating system. [4 Marks]
QUESTION FOUR
a) Using examples differentiate between table and query as used in Ms Access database application
software. [6 Marks]
b) Peter has bought a computer with the following software: Word Processing, Spreadsheets,
Database, Computerized Accounting and Graphics modules. State the purpose of each module.
[5 Marks]
c) The computer had a CD-ROM drive. State clearly TWO differences between CD-ROM and a
Flash Disk. [4 Marks]
d) Explain FIVE input devices the student can use to play games. [5 Marks]
QUESTION FIVE
a) Explain how the following tasks can be executed in Ms-Excel
i. Adding numbers in a range [1 Mark]
ii. Calculating the monthly loan repayment for a loan. Suggest the principal, time and rate
[2 Marks]
iii. Calculate for mean value of numbers [1 Mark]
iv. Count occupied cell in a range [1 Mark]
b) Outline FIVE benefits of computer network to the organization. [5 Marks]
c) Explain SIX data types you may use in a Microsoft Access table [6 Marks]
d) Explain the function of the following features/tools in word Processing
i. Replace
ii. Frames
iii. Show/hide icon
iv. Mailing [4 Marks]
