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

Computer Applications Question Paper

Computer Applications

Course:Bachelor Of Science In Information Technology

Institution: Kca University question papers

Exam Year:2009

UNIVERSITY EXAMINATIONS: 2009/2010
FIRST YEAR EXAMINATION FOR THE DEGREE OF BACHELOR OF
SCIENCE IN INFORMATION TECHNOLOGY
BIT 1104: COMPUTER APPLICATIONS
DATE: DECEMBER 2009 TIME: 2 HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions
QUESTION ONE (30 Marks)
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) Outline four advantages of electronic spreadsheets over manual spreadsheets. [4 Marks]
c) Define the following terms and give examples of each
i). Attribute
ii). Entity
iii). Foreign Key
iv). Primary key
v). Legend
vi). Labels [6 Marks]
d) Discuss FOUR functions of the Operating System. [8 Marks]
e) Briefly explain FOUR uses of the internet. [4 Marks]
f) Differentiate between MS-Dos and Windows operating system. [2 Marks]
2
QUESTION TWO (20 Marks)
a) Describe how you would add a special symbol such as £ into a word document. [2 Marks]
b) Explain the feature one would use to change the word EXAM that appears twenty times in a
document, to CAT, and the process you would follow to accomplish this. [3 Marks]
c) Students of Kimemia school scored the following Marks in computer course in two consecutive
cats
Name CAT1 CAT2 Average
Sam 45 89
Peter 47 34
Lilian 46 34
Jack 76 23
comment
After you have entered these data in a manual worksheet, explain the steps you would take to:
(i) Set the labels to be aligned at 45o. [3 Marks]
(ii) Protect the worksheet using a password. [2 Marks]
d) Identify five symptoms of viruses when they attack your machine. [5 Marks]
e) Briefly explain the major classification of printers, giving an example of each. [5 Marks]
QUESTION THREE (20 Marks)
a). Define the term utility and State the function of the following utility programs
a. Sort Utility
b. Language utility
c. Copy Utility
d. Merge Utility
e. Text editor [6Marks]
b). Differentiate clearly between the following
a. Data and information.
b. System software and Application software. [4 Marks]
c). Explain the function of Office assistant as used in Ms Office. [3 Marks]
d). Define the term toolbar and state any three toolbars available in Ms word window. [4 Marks]
e). Describe the following types of computer memory
a. Flash Memory
3
b. ROM
c. RAM [3 Marks]
QUESTION FOUR (20 Marks)
a). Explain the meaning of “What if Analysis” as a feature of excel. [2 Marks]
b). Give the procedure you would use to rename a worksheet. [2 Marks]
c). What is the difference between formula Bar and name box components of excel application
window. [2 Marks]
d). There are three basic types of controls that can be included in a form in Ms Access list and define
then. [6 Marks]
e). What do you understand by the term “Formatting a worksheet” [2 Marks]
f). Describe the following automatic features of Ms Word use examples.
i). Auto format
ii). Autocorrect
iii). Auto Complete [6 Marks]
QUESTION FIVE (20 Marks)
a) Explain what you understand by the following terms as used in computer security
(i) Threats
(ii) Vulnerability
(iii) Attacks [6 Marks]
b) List four types of Personal computers. [4 Marks]
c) Describe any two ways of connecting to the internet. [4 Marks]
d) Describe the following Scanning technology used for input: [6 Marks]
(i) Optical Character Recognition (OCR)
(ii) Optical Bar Recognition (OBR)
(iii) Optical Mark Recognition (OMR)

Computer Applications Question Paper

More Question Papers

Popular Exams