UNIVERSITY EXAMINATIONS: 2020/2021
EXAMINATION FOR THE DEGREES OF BACHELOR OF SCIENCE IN
INFORMATION TECHNOLOGY/BACHELOR OF BUSINESS INFORMATON
TECHNOLOGY BACHELOR OF SCIENCE IN SOFTWARE
DEVELOPMENT/BACHELOR OF SCIENCE IN INFORMATION SECURITY AND
FORENSICS
BIT 01105/BBIT 01105/BSD 1103/BISF 1105: COMPUTER APPLICATIONS
FULLTIME/ PART TIME/DISTANCE LEARNING
DATE: DECEMBER, 2021 TIME: 2 HOURS
INSTRUCTIONS: ANSWER QUESTION ONE( COMPULSORY)AND ANY OTHER TWO
QUESTION ONE (20 marks)
a) Below is an extract from a spreadsheet program.
Using cell addresses only, write a formula that would be used to compute:
i. VAT for Rice (2
Marks)
ii. Total cost for sugar (2
Marks)
Total VAT for all items
(2Marks)
b) By giving an example in each case, explain each of the following types of computer software:
i. Application software
ii. System software
iii. Programming software (3
marks)
c) XYZ company has been advised by the IT manager to purchase a tailor made software. Give
FIVE reasons that could have necessitated such a move. (6
Marks)
d) Identify the various components of each of the following email address, explain the function
of each (3
Marks)
kmutua@kca.ac.ke
c) Oliver has bought a computer with the following software: Word Processing and
Spreadsheets, With examples explain the purpose of each module.
(2 Marks)
QUESTION TWO (15 marks)
a) Differentiate between DOS and Windows operating system. (4
Marks)
b) Apart from being reasonably descriptive, there are a few rules governing the choice of a
filename: explain THREE rules governing file names. (3
Marks)
9. 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)
QUESTION THREE (15 marks)
a) 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)
b) What is PowerPoint? (2
Marks) c) Discuss the following features in PowerPoint presentations:
i. Animation
ii. Transition (2
Marks)
d) Give the function of each of the following keyboard keys: (4
Marks)
i. END
ii. ESC
iii. DELETE
iv. Backspace
e) List THREE tab settings found in a word processing package. (3
Marks)
QUESTION THREE (15 marks)
a) The ICT manager at KCA University purchased a computer with the following specifications:
➢ Pentium IV 2.2 Ghz duocore
➢ 4 GB RAM
➢ 500 GB HDD
Explain the meaning of each of the above specifications. (3 Marks)
b) A software engineer requires a range of software utilities. Explain the usefulness of any FIVE
such utilities. (5
Marks) c) Explain five input devices the student can use to play games.
(5 Marks)
f) Explain the function of the following features/tools found in word processing software
i) Hyphenation
ii) Hyperlink
iii) Drop Cap
iv) Mailings (2Marks)
QUESTION FOUR (15 marks)
a) Distinguish between the following word features:
i. Header and footer (2
Marks)
ii. End-notes and footnotes (2
Marks)
iii. Indentation and alignment (2
Marks)
b) An employee was trying to open an email but had forgotten the password. Outline the process
of regaining access to the email. (3
Marks)
c) Write formulas for the operations (i) – (iv) based on the spreadsheet given below along with
the relevant cell address:
i. To calculate the Total Marks as sum of Science, Maths & Computers for each student and
display them in column F.
(2Mark)
ii. To calculate the average marks for each student and display them in column G (1
Mark)
iii. To calculate the highest marks in Computers and display it in cell E7
(1Mark)
iv. To calculate the total number of students appearing for the Science test and display it in cell
C8.
(2Marks)
