UNIVERSITY EXAMINATIONS: 2018/2019
EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN SOFTWARE
DEVELOPMENT/ BACHELOR OF SCIENCE IN INFORMATION SECURITY &
FORENSICS
BSD1103 COMPUTER APPLICATION SOFTWARE
FULL TIME
DATE: DECEMBER, 2018 TIME: 2 HOURS
INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions.
QUESTION ONE [30 MARKS]
a) Distinguish between the following terms:
i. Function and formula (2 Marks)
ii. Superscript and subscript (2 Marks)
iii. Absolute referencing and relative referencing (2 Marks)
iv. Sorting and Filtering (2 Marks)
b) Elaborate on the default functions of the following control keys as used in spreadsheet program:
(6 Marks)
c) Explain each of the following types of computer software
i. Application software (2 Marks)
ii. Operating system (2 Marks)
iii. Utility program (2 Marks)
d) The computer had a CD-ROM drive. Explain THREE differences between CD-ROM and a Flash
Disk. (6 Marks)
e) Explain FOUR input devices the student can use to play games. (4 Marks)
QUESTION TWO [20 MARKS]
a) The following table is an extract from a supermarket sales record
i. Write a formula to calculate the cost of flour (2 Marks)
ii. Write a formula to display the number of cells with cost per unit equal to 200
(2 Marks)
iii. Write a formula to increase the price of sugar by 2% (2 Marks)
iv. Write a formula to display the lowest cost of all the items (2 Marks)
b) Identify the components of the following web address: (4 Marks)
http://www.kca.ac.ke/courses/fees.htm
c) Joseph has been working on his documents in office and saving them on his computer. His boss
has asked him to save the same documents with a different name. Explain the process of saving a
document in word with a new name. (5 Marks)
d) State the word processing formula that should be used in a table to computer each of the values
i. Total in a column (1 Mark)
ii. Total in a row (1 Mark)
iii. Mean score in a row of scores (1 Mark)
QUESTION THREE [20 MARKS]
a) Outline THREE benefits of using the mail merge feature in Microsoft word.
(3 Marks)
b) Explain THREE advantages of the electronic spreadsheet over the manual spreadsheet.
(6 Marks)
c) With the aid of a sketch, differentiate between portrait and landscape paper orientations as
applied in word processing programme. (4 Marks)
d) Differentiate between the following words:
i. Workbook and worksheet (2 Marks)
ii. Internet and search Engine (2 Marks)
e) Define the following words as used in word processing programme: (3 Marks)
i. Thesaurus
ii. Word wrap
iii. Indentation
QUESTION FOUR [20 MARKS]
a) Define the term text-box as used in word processing (2 Marks)
b) Explain SIX Characteristics of an integrated software (6 Marks)
c) Outline FIVE benefits of word processors. (5 Marks)
d) Using examples differentiate between table and query as used in Ms Access database application
software. (3 Marks)
e) Differentiate between High level language and low level language in computing world?
(4 Marks)
QUESTION FIVE [20 MARKS]
a)Peter has bought a computer with the following software: Word Processing, Spreadsheets, Database,
Computerized Accounting and Graphics modules. Explain the purpose of each module.
(5 Marks)
b) Explain how the following tasks can be executed in Ms-Excel
i. Adding numbers in a range (1 Mark)
ii. Calculating the monthly loan repayment for a loan. Suggest the principal, time and rate
(2 Marks)
iii. Calculate for mean value of numbers (1 Mark)
iv. Count occupied cell in a range ( 1 Mark)
b) Explain SIX data types you may use in a Microsoft Access table (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)
