UNIVERSITY EXAMINATIONS: 2017/2018
EXAMINATION FOR THE DIPLOMA IN INFORMATION
TECHNOLOGY/DIPLOMA IN BUSINESS INFORMATION TECHNOLOGY
DCU201 COMPUTER APPLICATION SOFTWARE
DATE: AUGUST 2018 TIME: 1
1
/2 HOURS
INSTRUCTIONS: ATTEMPT QUESTION ONE AND ANY OTHER TWO QUESTIONS.
QUESTION ONE
a) Explain the following terms as applied in computer systems: [5 Marks]
(i) Computer
(ii) Computer Hardware
(iii)computer Software
(iv) Data
(v) Information
b) Using appropriate examples differentiate between Off-shelf software and Tailor-made software.
[10 Marks]
c) Explain the impact of computer systems and technology on the following industries. [5 Marks]
(i) Manufacturing.
(ii) Health care.
(iii) Education.
(iv) Research.
(v) Entertainment
e) Outline how you would perform the following [6 Marks]
(i) Italicize typed text.
(ii) Centre align your text.
(iii)Saving your word document for the first time.
f) Give FOUR short cut key combinations explaining the functions they perform. [4 Marks]
QUESTION TWO
a) Explain the following word-processor facilities. [5 Marks]
(i) Header
(ii) Footer
(iii) Text-wrap
(iv) Drop Cap
(v) Bullet
b) Utility/service programs enhance the working of a computer. Explain any FIVE. [5 Marks]
c) Explain any FIVE application software. [5 Marks]
d) Explain FIVE benefits of the Internet. [5 Marks]
QUESTION THREE
a) Explain how you would perform the following operations on a word document. [5 Marks]
(i) Changing margins
(ii) Set the page size
(iii) Use headers and footers
(iv) Insert page numbers, Column, Drop Cap &
(v) Apply Bulleted Lists
b) Explain the following terms as used in MS Excel. [5 Marks]
(i) Work book
(ii) Work sheet
(iii) Cell
(iv) Range
(v) Orientation
c) State and explain four PowerPoint views [4Marks]
d) Define the term operating system and state the functions of an operating system.
[6Marks]
QUESTION FOUR
a) Describe the components of the central processing unit [3Marks]
b) Computer memory can be divided into two broad categories: Explain [4Marks]
c) Explain any four characteristics of computers. [3 Marks]
d) Distinguish between Shareware and Freeware software and give examples of these type of
software and two ways in which one can obtain this software. [4 Marks]
e) 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]
QUESTION FIVE
a) Describe three types of graphs found in spreadsheets [6 Marks]
b) Outline four advantages of electronic spreadsheets over manual spreadsheets. [4 Marks]
c) Describe each of the following Ms. Word Features [10Marks]
i) Hyperlink
ii) Mail Merge
iii) Alignment
iv) Smart Art
v) Margin
