UNIVERSITY EXAMINATIONS: 2014/2015
ORDINARY EXAMINATION FOR THE BACHELOR OF BUSINESS
INFORMATION TECHNOLOGY
BBIT 100 CMS 103 COMPUTER APPLICATIONS SOFTWARE –
DISTANCE LEARNING
DATE: DECEMBER, 2014 TIME: 2 HOURS
INSTRUCTIONS: Answer Question ONE and any other TWO
QUESTION ONE [30 MARKS]
a) Distinguish between data, information and knowledge. [3 Marks]
b) Define the term computer work station. [2 Marks]
c) Identify and explain five potential health hazards associated with computer use.
[5 Marks]
d) Apart from a mouse, state any other four pointing devices and where you are most
likely to use them. [8 Marks]
e) Briefly outline any four security issues associated with electronic mail. [4 Marks]
f) A computer aided drawing (CAD) is the use of computers to produce drawings that
would normally be prepared manually. With the advent of CAD packages, traditional
tools such as the compass, T-square, rule, pencils and erasers are being used less and
less. From this view point, discuss four advantages of CAD software applications.
[4 Marks]
g) Multimedia is a collection of different forms of media combined together to provide
good, effective communication. Multimedia can incorporate graphics, animation,
sound and video. State and explain the use of any two multimedia software applications you know. [4 Marks]
QUESTION TWO [20 MARKS]
a) Social networking platforms today can allow organizations, big and small alike, to
improve communication and productivity by disseminating information among different groups of employees in a more efficient manner. From this view point:
i). Describe two advantages and two disadvantages of social networking
[4 Marks]
ii). Identify any two social networking sites [2 Marks]
iii). Differentiate between social network and social media. [2 Marks]
b) A virus is a malicious program designed to spread and replicate from one computer
to another through telecommunication links or through sharing of removable storage
media and files.
i). Describe any four effects of a virus in a computer [4 Marks]
ii). Describe any four symptoms of a computer that has virus [4 Marks]
iii). Outline four parts of a computer that a virus can attack. [4 Marks]
QUESTION THREE [20 MARKS]
The table below needs to be created using DBMS software.
i). Identify one open source DBMS software that can be used to implement this
table. [1 Marks]
ii). Identify a possible primary key for this table. Give a reason for your choice.
[1 Marks]
iii). Describe any three reasons for keeping records in a database. [3 Marks]
iv). Identify a suitable data type for all the fields in the above table. [5 Marks]
v). State and explain any other three functions of a DMBS software part from creating tables and databases. [6 Marks]
vi). Data is one of the components of a database. State and explain any other three
components. [3 Marks]
vii). Explain why a table may need a foreign key. [1 Mark]
QUESTION FOUR [20 MARKS]
a) Identify and explain one feature in a word processor that can be used for each of the
following tasks in a 400 hundred page document:
i). Find and modify a phrase that appears severally in the document. [2 Marks]
ii). Insert some text at the end of each chapter [2 Marks]
iii). Insert the name of the author and page number at the bottom of each page
[2 Marks]
iv). Insert some transparent text behind the content of each page [2 Marks]
v). Insert table of contents that show the chapters and page numbers [2 Marks]
b) Explain the circumstances under which you will require the following spreadsheet
features.
i). Auto complete
ii). Format painter
iii). Function
iv). Define name
v). Background [10 Marks]
QUESTION FIVE [20 MARKS]
a) Presentation software is an application program used to create sequences of words
and pictures that tell a story or help support a speech or public presentation of information.
i). Identify any three open source presentation softwares [3 Marks]
ii). Identify and explain any six important features of a presentation software
[6 Marks]
iii). Briefly explain how you can prepare a presentation of not more than 5 slides.
[6 Marks]
b) The following page was captured as a draft email:
i). State the rationale for indicating the subject for this mail.
[1 Mark]
ii). Explain why it is not advisable in some circumstances to insert recipient addresses in a CC field. [1 Mark]
iii). Identify two netiquette rules that were violated in this mail. [2 Marks]
iv). State the largest size attachment send with this mail. [1 Mark]
