UNIVERSITY EXAMINATIONS: 2016/2017
EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY
DIT104 COMPUTER ORGANIZATION AND APPLICATION
SPECIAL/SUPPLEMENTARY EXAMINATION
DATE: JULY, 2017 TIME: 2 HOURS
INSTRUCTIONS: Answer any THREE questions.
QUESTION ONE
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]
QUESTION TWO
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 THREE
a) Define the term text-box as used in word processing. [2 Marks]
b) List SIX Characteristics of an integrated software. [6 Marks]
c) Differentiate between High level language and low level language in computing world?
[4 Marks]
d) Explain any FOUR different types of computer software. [4 Marks]
e) Differentiate between input and output devices giving examples in each scenarios. [4 Marks]
QUESTION FOUR
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 FIVE
a) Explain FOUR types of computer classifications giving examples in each scenarios. [8 Marks]
b) Differentiate Hard and soft copy. [2 Marks]
c) Explain FOUR advantages of Office Automation Systems. [4 Marks]
d) Explain TWO reasons why computers are considered to be useful in business organizations.
[2 Marks]
e) Explain FOUR views that you normally use from time to time when one is working with power
point application. [4 Marks]
