Bit 100 Cms 103Computer Applications Software- Distance Learning Question Paper
Bit 100 Cms 103Computer Applications Software- Distance Learning
Course:Bachelor Of Science In Information Technology
Institution: Kca University question papers
Exam Year:2014
UNIVERSITY EXAMINATIONS: 2013/2014
ORDINARY EXAMINATION FOR THE BACHELOR OF BUSINESS
INFORMATION TECHNOLOGY
BIT 100 CMS 103COMPUTER APPLICATIONS SOFTWARE-
DISTANCE LEARNING
DATE: AUGUST, 2014
TIME: 2 HOURS
INSTRUCTIONS: Answer Question ONE and any other TWO
QUESTION ONE [30 MARKS]
a) When creating a simple database in access, state a suitable data type for the following
attributes:
i) Customer’s first name [1 Mark]
ii) Amount paid [1 Mark]
iii) Age of a student [1 Mark]
iv) Employee’s gender [1 Mark]
b) You are creating a presentation about computer software using PowerPoint to a panel
of fifteen stakeholders form the ministry of education. Your slides must include:
Your name [Do not use your real name]
Title and date of presentation
Introduction
Definition of software
Classification of softwares
Uses of software
Sketch and write the contents in the sketched slides you will need for this presentation.
Your presentation must not exceed eight (8) slides.
[8 Marks]
c) You are creating a three hundred (300) page document using a word processor.
Discuss the following features and how they will help you in formatting this
document.
1
i) End note
ii) Table of contents
iii) Insert caption
iv) Page numbers
[8 Marks]
d) State and explain the use of the following keyboard shortcuts:
i) Ctrl+S [1 Mark]
ii) Ctrl+N [1 Mark]
iii) Ctrl+V [1 Mark]
iv) shift+F7 [1 Mark]
e) Differentiate between the following terminologies
i) Internet and network [1 Mark]
ii) Modem and server [1 Mark]
iii) Hard copy and soft copy [1 Mark]
iv) Backspacing and delete [1 Mark]
f) Describe the components of the following url: http://www.kca.ac.ke
[2 Marks]
QUESTION TWO [20 MARKS]
You are required to write an email and send it to twenty (20) recipients inviting them to
your graduation party on 20Th. November. 2014.
i)
Describe any five benefits of email
[5 Marks]
ii) Differentiate between the CC and BCC fields.
[2 Marks]
iii) Why is it a good practice to indicate recipients addresses in BCC and not CC?
[2 Marks]
iv) Discuss the role of MIME as used in email. [2 Marks]
v) Discuss the role of POP as used in email. [2 Marks]
vi)Suggest a suitable subject for your email. [1 Mark ]
vii) Why is it important for you to write subject for your email? [1 Marks]
viii) Describe any five email programs that you may use to send your email.
[5 Marks]
2
QUESTION THREE [20 MARKS]
You are required to create a simple database using access that will consist of two tables.
The database will be used to store information about meal and customer details. This
database will be used in a small restaurant that you own.
i) Define a database.
[1 Mark]
ii) Apart from access, state any three other database management programs.
[3 Marks]
iii) Describe any four reasons for you to create the database.
[4 Marks]
iv) Assuming that the database will only keep details about meals and customers, identify
any three fields for each table ( for meals and customers). [6 Marks]
v) State any suitable field that you will use to link the two tables. [1 Mark]
vi) For each table state one field that will be used to identify the records uniquely.
[2 Marks]
vii) Draw the sketch of the database you will create.
[3 Marks]
QUESTION FOUR [20 MARKS]
You are compiling your final year project report. The report consists of five chapters
presented in one hundred and fifty six(156) pages. The chapters are:
Chapter one: Introduction
Chapter one: Literature review
Chapter one: Research design
Chapter one: Data analysis
Chapter one: Discussion and conclusion
i) Define the term long document.
[1 Mark]
ii) Apart from a report state any three long documents you can create.
[3 Marks]
iii) State and explain any five features of a word processor you will need to edit this
report.
[5 Marks]
iv) State and explain any three software applications you may use to create this
document.
v) Describe the use of index in a document.
[3 Marks]
vi) When printing this report identify any three settings you will set before sending
the document to the printer.
[3 Marks]
3
vii) State a suitable line space and font size for this document.
viii)
[2 Marks]
Apart from New Times roman, state any other three font styles you can
use for this report.
[3 Marks]
QUESTION FIVE [20 MARKS]
You are required to work on a worksheet below presented by a foreman.
B C D G H
I
SN Name Task Hours worked Rate per hour Total paid
1 John K Cleaning 5 600
2 Jane. M Cooking 6 500
3 Faith M Cleaning 5 600
4 Kariuki .J Cultivation 4 700
5 Omondi F Digging 5 500
6 Litusi U Fencing 6 600
7 Debra M Cooking 7 500
8 Eunice P Cleaning 5 600
9 Ken P Cultivation 6 700
10 Faith Y Fencing 6 500
11 Jane E Digging 4 400
12 John T Cleaning 5 600
13 Diana T Cooking 6 500
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
a) Differentiate between a function and a formula
b) Define a fill handle and explain how you can use it in this worksheet.
[2 Marks]
[3 Marks]
c) State and explain a feature that can be used to display the employees whose task was
either digging or cultivation.
[4 Marks]
d) State and explain a feature that can be used to highlight in red employees whose
working hours were below 5 .
[4 Marks]
e) Write a function that can be used to calculate the mean hourly rate of pay for all the
employees.
[4 Marks]
f) Write a function that can be used to calculate the total paid for each employee
[3 Marks]
4
More Question Papers
Exams With Marking Schemes