Dbit 105 Computer Applications Software Question Paper
Dbit 105 Computer Applications Software
Course:Diploma In Business Information Technology
Institution: Kca University question papers
Exam Year:2012
UNIVERSITY EXAMINATIONS: 2011/2012
EXAMINATION FOR THE DIPLOMA IN BUSINESS INFORMATION
TECHNOLOGY
DBIT 105 COMPUTER APPLICATIONS SOFTWARE
DATE: MARCH, 2012 TIME: 1½ HOURS
INSTRUCTIONS: Answer Any Three Questions
QUESTION ONE
a) Distinguish between Share ware, Freeware and public domain software. Give examples of these
type of software and two ways in which one can obtain this software. [6 Marks]
b) Explain the following functions as used in Microsoft Excel. Give examples of each
i. TODAY() [2 Marks]
ii. SUMIF [2 Marks]
iii. COUNTIF [2 Marks]
c) Outline four advantages of electronic spreadsheets over manual spreadsheets. [4Marks]
d) Briefly explain FOUR uses of the internet. [4 Marks]
QUESTION TWO
a) State and explain four PowerPoint views [4 Marks]
b) Discuss FOUR functions of the Operating System. [8 Marks]
c) Explain four types of paragraph alignment are available in Microsoft Word [6 Marks]
d) Differentiate between TPS and PSS information systems [2 Marks]
2
QUESTION THREE
a) Briefly explain the following terms [6 Marks]
i. Database management system
ii. Database system
iii. Database administrator
b) Explain giving example six categorization of computer software according to the tasks performed.
[12 Marks]
c) List any two word processors other than MS Word [2 Marks]
QUESTION FOUR
a) State the components of a database management system [5 Marks]
b) Explain the following cell addressing methods and give example for each case [8 Marks]
i. Relative cell addressing method
ii. Absolute cell addressing method
iii. Mixed cell addressing method
iv. 3D cell addressing
c) Explain ANY five document views used in Microsoft word. [5Marks]
d) Explain the meaning of bespoke software and give an example [2 Marks]
QUESTION FIVE
a) Define the term URL. Explain each component of the following URL. [5 Marks]
http://www.kca.ac.ke
b) Explain the following protocols [8 Marks]
i. SMTP
ii. FTP
iii. HTTP
iv. TCP
c) Outline any four uses of internet today [4 Marks]
d) Describe three types of graphs found in spreadsheets [3 Marks]
More Question Papers
Exams With Marking Schemes