UNIVERSITY EXAMINATIONS: 2017/2018
EXAMINATION FOR THE DIPLOMA IN BUSINESS INFORMATION
TECHNOLOGY
DCU 201: COMPUTER APPLICATION SOFTWARE
DATE: NOVEMBER, 2017 TIME: 1 ½ HOURS
INSTRUCTIONS: Answer Question One and Any Other Two Questions.
QUESTION ONE
a) Differentiate between the following set of terms:
i. ROM and RAM. [2 Marks]
ii. Bit and Byte. [2 Marks]
iii. Application Software and System Software. [2 Marks]
iv. Hardcopy and Softcopy. [2 Marks]
b) Give three major functions of an operating system. [3 Marks]
c) State three examples of Operating systems you know. [3 Marks]
d) Stating examples and explain two main classification of computer software. [4 Marks]
e) Differentiate between
i. Folder and a file.
ii. Data and information. [2 Marks]
f) Explain two methods of performing each of the following functions:
i) Copy and paste
ii) Cut and paste
[4 Marks]
g) In your own words, explain the advantages and disadvantages of using the internet.
[6 Marks]
QUESTION TWO
a) An organization can acquire software either by developing in-house or purchasing off the
shelf. List down the advantages and disadvantages of each. [10 Marks]
b) State four data manipulation operations which are performed by a database management
system[DBMS] [4 Marks]
c) List SIX types of Information systems [6 Marks]
QUESTION THREE
a) Identify FIVE advantages of using electronic spreadsheets [4 Marks]
b) Briefly explain Three views found in MS word document [6 Marks]
c) Give any FOUR sources of viruses [4 Marks]
d) Describe any THREE pointing input devices used in computers [6 Marks]
QUESTION FOUR
a) Briefly explain three forms in which data entered in a cell in Ms excel [6 Marks]
b) Outline the steps followed when copying text using drag and drop method as used in MS
Word using a mouse. [5 Marks]
c) Identify Six symptoms of viruses when they attack your machine. [3 Marks]
d) Give the steps followed when creating headers and footers in Ms word. [3 Marks]
e) Explain three types of paragraph alignment are available in Microsoft Word. [3 Marks]
QUESTION FIVE
a) Describe how you would add a special symbol such as £ into a word document. [2 Marks]
b) Explain the feature one would use to change the word EXAM that appears twenty times in a
Document, to CAT, and the process you would follow to accomplish this. [3 Marks]
f) Identify five symptoms of viruses when they attack your machine. [5 Marks]
g) Briefly explain the major classification of printers, giving an example of each. [5 Marks]
h) Differentiate clearly between the following
i. Data and information.
ii. System software and Application software. [5 Marks]