Dms 103 Computer Application Software Question Paper
Dms 103 Computer Application Software
Course:Diploma In Business Management
Institution: Kca University question papers
Exam Year:2014
UNIVERSITY EXAMINATIONS: 2013/2014
STAGE III ORDINARY EXAMINATION FOR THE DIPLOMA IN
BUSINESS MANAGEMENT
DMS 103 COMPUTER APPLICATION SOFTWARE
DATE: AUGUST 2014
TIME: 1 1/2 Hours
INSTRUCTION: Answer any THREE questions
QUESTION ONE: (20 MARKS)
a) Differentiate between an input and output device giving example of each.
[4 Marks]
b) The following shows various age limits for a given population census. Using the Nested
IF statement compare their ages against the values alongside and show the formula
[6 Marks]
Age Groups
>= 60 Old Man
>= 35 Middle Aged
>= 20 Youth
>= 13 Teenager
>= 7 Toddler
< 7 Infant
c) What do you understand by the term Application Software
d)
[2 Marks]
Explain the following terms as used in spreadsheet application.
i. Cell
ii. Workbook
iii. Worksheet
iv. Formula bar
[8 Marks]
1
QUESTION TWO: (20 MARKS)
a)
What do you understand by the term mail merging as used in Microsoft word
application?
b)
[2 Marks]
Maina was a secretary for a company called WOW Technologies, He was mandated with
the task to send invitation letters to 2000 members in different towns showing them their
statements balances and invitation to their annual general meeting.
Discuss steps and procedures Maina would apply to arrive to his intention using MS word
application software. [10 Marks]
c) State any THREE Databases Management Applications Software? [3 Marks]
d) Explain what you understand by the following DBMS and word processing Terms;
i. Foreign Key
ii. Data Type.
iii. Field.
iv. Primary Key.
v. Text Box.
[5 Marks]
QUESTION THREE: (20 MARKS)
a)
Discuss FIVE factors to consider before selecting a database for a given organization.
[10 Marks]
b)
The following are some of the options on the start menu discuss their functions.
i. Run
ii. My recent Document.
iii. Settings
iv. Programs
v. Search
[10 Marks]
QUESTION FOUR: (20 MARKS)
a)
Explain FIVE reasons why computers are considered to be useful in business
organizations.
[10 Marks]
2
b)
Outline FIVE factors you would use to differentiate between off the shelf and bespoke
software
[10 Marks]
QUESTION FIVE: (20 MARKS)
a)
Briefly explain the steps involved in creating a new Company in Quick Books
application. [10 Marks]
b) How do you go about backing up data in QuickBooks applications [4 Marks]
c) Highlight SIX reasons for backing up data especial in accounting packages. [6 Marks]
3
More Question Papers
Exams With Marking Schemes