UNIVERSITY EXAMINATIONS: 2016/2017
EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY/
DIPLOMA IN BUSINESS INFORMATION TECHNOLOGY
DIT0200 DCU 201 COMPUTER APPLICATION SOFTWARE
DATE: AUGUST, 2017 TIME: 2 HOURS
INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions.
QUESTION ONE [30 MARKS] – COMPULSORY
a) Explain the following terms as used in spreadsheet application.
i. Cell
ii. Workbook
iii. Range
iv. Name box
v. Formula bar [5 Marks]
b) Differentiate Hard and soft copy. [2 Marks]
c) Explain FOUR advantages of Office Automation Systems [4 Marks]
d) Explain FIVE reasons why computers are considered to be useful in business organizations.
[5 Marks]
e) Explain FOUR views that you normally use from time to time when one is working with power point
application [4 Marks]
f) Explain FIVE computer Application areas. [10 Marks]
QUESTION TWO [20 MARKS]
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 [20 MARKS]
a) Define the term text-box as used in word processing [2 Marks]
b) List SIX Characteristics of an integrated software [6 Marks]
c) Explain FOUR features of the fourth computer programming languages [6 Marks]
d) Briefly, explain the following database terms, giving examples where appropriate
i. Primary Key
ii. Foreign Key
iii. Domain
iv. Data-type
v. Field
vi. Junction Table [6 Marks]
QUESTION FOUR [20 MARKS]
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 [20 MARKS]
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 FOUR benefits of computer network to the organization. [4 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]
