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:2010

UNIVERSITY EXAMINATIONS: 2009/2010
FIRST YEAR EXAMINATION FOR THE DEGREE OF BACHELOR OF
SCIENCE IN INFORMATION TECHNOLOGY
BIT 1104: COMPUTER APPLICATIONS
DATE: APRIL 2010 TIME: 2 HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions
Question One
a) Differentiate between the following set of terms:
i.ROM and RAM [2 Marks]
ii.Bit and Byte [2 Marks]
iii.Application Software and System Software [2 Marks]
iv.Hardcopy and Softcopy [2 Marks]
b) Outline the functions of the following icons:
i.My Computer [1 Mark]
ii.My Documents [1 Mark]
iii.Recycle Bin [1 Mark]
iv.My Network places [1 Mark]
c) (i) What is a wallpaper and what is its purpose? [1 Mark]
(ii) Give three major functions of any operating system. [3 Marks]
(iii) State three examples of Operating systems you know. [3 Marks]
d) Describe the process of installing new MODEM in your computer. [4 Marks]
2
e) What do you understand by the term ‘system concept’? Give three items which makes a system.
[3 Marks]
f)Describe four methods that can be used to load Ms-word [4 Marks]
Question Two
a) The following is a toolbar used often in Word processing
i.Identify its name [2 Marks]
ii.Outline the name and function of the labeled icons [6 Marks]
b) List the steps you would follow to perform the following tasks: -
i. Creating a document for the first time
ii. Saving a document file in a new directory without changing the filename
iii. Opening a document that has been saves in My Documents folder [6 Marks]
c) Explain the function of the following features/tools in word Processing
i. Replace
ii. Frames
iii. Show/hide icon
iv.Mailing [4 Marks]
d) List any two word processors other than MS Word [2 Marks]
Question Three
a) Explain the four calculation operators as used in Microsoft Excel. Where applicable, give an example to illustrate. [8 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]
(iv) COUNTA [2 Marks]
c) Explain the following cell addressing methods as used in Microsoft Excel
(i) Mixed cell addressing method [1 Mark]
(ii) Absolute cell addressing method [1 Mark]
(iii) Relative cell addressing method [1 Mark]
(iv) 3-D cell addressing method [1 Mark]
Question Four
a) Explain the use of any database system. Give examples of any two database programs you know.
[3 Marks]
b) Explain three ways of creating a table using Microsoft Access [6 Marks]
c) Outline five components of access database. [5 Marks]
d) Explain any six data types you may use in a Microsoft Access table. [6 Marks]
Question Five
There are five computer generations. All along they describe technological advancement in both
hardware and software. In respect to the above describe:
a)First Generation [4 Marks]
b) Second Generation [4 Marks]
c) Third Generation [4 Marks]
d) Fourth Generation [4 Marks]
e) Fifth Generation [4 Marks]

Computer Applications Question Paper

More Question Papers

Popular Exams