UNIVERSITY EXAMINATIONS: 2019/2020
EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN
SOFTWARE DEVELOPMENT/ INFORMATION SECURITY &
FORENSCIS
BSD 1103/ BISF 1106: COMPUTER APPLICATION SOFTWARE
FULL TIME/ PART TIME
DATE: MAY, 2020 TIME: 6 HOURS
INSTRUCTIONS: Answer ALL Questions
SECTION TWO: SHORT ANSWER QUESTIONS
1. An operating system may offer a variety of batch and on-line facilities. Describe batch
and online processing [4 Marks]
2. Speech recognition systems for personal computer are now popular in the market
i. State TWO advantages to a PC user of a speech recognition devices [(2 Mark]
ii. Give TWO different tasks for which a PC user could use using a speech recognition
device [2 Marks]
3. A company is replacing the personal computers used by its employee. The staff has been
offered the choice of a desktop personal computer, or a laptop computer. Describe TWO
advantages and TWO disadvantages to the staff on their choice. [4 Marks]
4. Differentiate between an operating system and an application software. [2 Marks]
5. Give the steps followed when creating headers and footers in Ms word. [3 Marks]
6. Explain three types of paragraph alignment are available in Microsoft Word.
[3 Marks]
SECTION THREE: OPEN BOOK
Consider the data below and use to answer the questions that follow:
Required:
a. In MS excel, create a workbook named “Employees” [2 Marks]
b. create a worksheet in the “Employee” workbook and name it “Employee salary”
[4 Marks]
c. calculate he average for “family members” column in cell E12 [2 Marks]
d. Compute the highest income in cell F13. [2 Marks]
e. using an appropriate formula, compute the annual income for each individual in
column
[3 Marks]
f. Calculate the house rent for the staff who have rented houses. Houser rent is 10%
of monthly income.
[3 Marks]
g. Insert a bar chart displaying staff name along the X axis and family members
along the Y axis. [4 Marks]
h. Place the legend on top of the chart area. [2 Marks]
i. Insert a hyperlink in cell A14c of “staff salary” worksheet with the text “Display
sheet2”. The user should automatically display sheet 2 after clicking on it.
[2 Marks]
j. On “sheet3” of your workbook, type the steps you could use to import data from
the table in a database application.
[4 Marks]
