UNIVERSITY EXAMINATIONS: 2018/2019
EXAMINATION FOR THE DIPLOMA IN INFORMATION
TECHNOLOGY/ DIPLOMA IN BUSINESS INFORMATION
TECHNOLOGY
DCU201 DIT206 COMPUTER APPLICATIONS SOFTWARE
DATE: AUGUST 2019 TIME: 2 HOURS
INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions.
QUESTION ONE
a) Explain how you will perform the following activities in MS WORD. [5 Marks]
i. Underline text
ii. Change Font size
iii. Remove bullets and numbering
iv. Insert a picture
v. Merge cells
a) Define the following terms. [3 Marks]
i. Computer
ii. Software
iii. Hardware
b) Describe the key features in the first, second and Third generation. [6 Marks]
c) Distinguish between relative and absolute cell references in a worksheet. Use examples
[4 Marks]
d) Alex needs to purchase an Application Software for his computer. Explain what application
software is giving THREE examples that he will find in Microsoft Office- suite.
[3 Marks]
e) Explain the following terms as used in spreadsheet application. [4 Marks]
i. Cell
ii. Workbook
iii. Worksheet
iv. Formula bar
f) ALL ANIMALZ ARE EQUAL
BUT SOME ANIMALZ ARE MORE EQUAL THAN OTHERZ.
➢ Four legs good, two legs better!
➢ Four legs good two legs better!
i. Explain how you would save your work as “Animal Farm” in MS Word. [1 Mark]
ii. Replace the word ANIMALZ with Folks. [1 Mark]
iii. Change the bullets to a numbered list. [1 Mark]
iv. Add a header to the document and write George Owell. [1 Mark]
v. Run the spell checker. [1 Mark]
QUESTION TWO
a) Explain FIVE advantages of using computers as compared to manual record Keeping.
[5 Marks]
b) Define Peripheral devices giving THREE examples. [4 Marks]
c) Discuss SIX advantages of Database approach over file based approach. [6 Marks]
d) Explain FIVE functions of the operating system. [5 Marks]
QUESTION THREE
a) Outline how you would perform the following in Ms Word. [4 Marks]
i. Save an existing file with a different name.
ii. Protect your file with a password
b) Outline how you would perform the following in Ms Excel [6 Marks]
i. Copy a formula to adjacent cells
ii. Re name a worksheet
iii. Set the row width to 2cm
c) “Shop smart” is a small retail shop in your neighborhood. The management want to automate
its activities. Give your expert opinion on why you think it will be better for them to settle on
buying off the shelf software compared to tailor made. [5 Marks]
d) Explain FIVE categories of computer hardware giving an example of each. [5 Marks]
QUESTION FOUR
a) State and briefly explain Four factors that influence the performance of the CPU. [4 Marks]
b) Differentiate the following: [4 Marks]
i. Format painter and Water Mark
ii. Toggle case and Sentence Case.
c) State and briefly explain at least four accessories that windows provide. [4 Marks]
d) Explain the process than one can use to quit a program that’s not responding. [4 Marks]
e) Discuss FOUR application areas of computers. [4 Marks]
QUESTION FIVE
a) 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, Math & Computers for each student and
display them in column F. [4 Marks]
ii. To calculate the average Marks for each student and display them in column G. [3 Marks]
iii. To calculate the highest Marks in Computers and display it in cell E7 [2 Marks]
b) Computer memories are classified into two categories. State and briefly describe them and give
two examples of each category. [6 Marks]
c) Explain FIVE advantages of custom made software. [5 Marks]
