Get premium membership and access revision papers, questions with answers as well as video lessons.

Got a question or eager to learn? Discover limitless learning on WhatsApp now - Start Now!

Computer Applications Question Paper

Computer Applications

Course:Diploma In Information Technology

Institution: Kca University question papers

Exam Year:2010

UNIVERSITY EXAMINATIONS: 2008/2009
STAGE I EXAMINATION FOR DIPLOMA IN INFORMATION
TECHNOLOGY
DIT 103: COMPUTER APPLICATIONS
DATE: APRIL 2010 TIME: 1½HOURS
INSTRUCTIONS: Answer any THREE questions
Question One (20 Marks)
a) Briefly describe the role of BIOS and the kernel during the process of bootstrapping of a computer
system. [6 Marks]
b) Windows operating system is said to be a user friendly operating system. Explain. [4 Marks]
c) Briefly describe the following programs:
i. Trojan horse
ii. Antivirus
iii. Worms [6 Marks]
d) For each of the following application software identify the key application.
i. Presentation software
ii. Graphics software
iii. Database management system software
iv. Browser [4 Marks]
Question Two (20 Marks)
a) There are several reasons why many companies prefer electronic mails for internal
communication. Give any four apart from cost. [4 Marks]
2
b) An individual wishing to connect to internet may do so through internet service provider. One
however must be prepared to pay for the service. Apart from cost for explain any four factors
one would consider when choosing the internet service provider. [8 Marks]
c) Internet can be used in several ways describe any four of them, giving examples. [8 Marks]
Question Three (20 Marks)
a) In each of the following examples of operators identify the type and name of the calculation
operator used and explain its usage.
i. <>
ii. &
iii. * [6 Marks]
b) In each of the following examples of cell addressing methods, identify the type of the
addressing method used and its usage.
i. =$B$5+$G$5
ii. =$D$4+A4
iii. =A3+D3
iv. =SHEET2!B2+SHEET3!F3 [8 Marks]
c) Explain the importance of the following features in spreadsheets.
i. Cell
ii. Custom fill
iii. Filter [6 Marks]
Question Four (20 Marks)
a) Explain the role of the following advanced features in word processors:
i. Mail merge
ii. index
iii. Tables
iv. Table of contents. [8 Marks]
b) Explain the applications of the following types of charts.
i. Line chart
ii. Scatter chart
iii. Bar chart
iv. Pie chart [8 Marks]
c) Explain any four reasons for protecting a word document using a password. [4 Marks]
3
Question Four (20 Marks)
a) Outline any four reasons for formatting a document using a word processor. [4 Marks]
b) Describe how you can perform a search using a search engine. Use a specific example.
[6 Marks]
c) Outline any three uses of electronic spreadsheets. [3 Marks]
d) Explain any five components in a dialog box in windows. [5 Marks]
e) Define print preview and explain why you may use this view when creating a document.
[2 Marks]

Computer Applications Question Paper

More Question Papers

Popular Exams