Bbit 101 Computer Applications Software Question Paper
Bbit 101 Computer Applications Software
Course:Bachelor Of Business Information Technology
Institution: Kca University question papers
Exam Year:2014
UNIVERSITY EXAMINATIONS: 2013/2014
ORDINARY EXAMINATION FOR THE BACHELOR OF BUSINESS
INFORMATION TECHNOLOGY
BBIT 101 COMPUTER APPLICATIONS SOFTWARE
DATE: AUGUST, 2014
TIME: 2 HOURS
INSTRUCTIONS: Answer Question ONE and any other TWO
QUESTION ONE
a)
Explain the following terms as used in spreadsheet application.
i) Cell
ii) Workbook
iii) Range
iv) Name box
v) Formula bar
[5 marks]
b) Differentiate Hard and soft copy [2 Marks]
c) Explain FOUR advantages of Office Automation Systems [4 Marks]
d) Explain FIVE reasons why computers are considered to be useful in business
organizations.
e)
[5 Marks]
Explain FIVE advantages of bespoke applications over off the shelves ones.
[10 Marks]
f)
Explain FOUR views that you normally use from time to time when one is
working with power point application
[4 Marks]
QUESTION TWO
a) List any FOUR database management application software.
[4 marks]
b) Explain FIVE types of charts that can be created in Ms excel application
[5 Marks]
c)
Explain SIX views in word processing application
1
[6 Marks]
d)
Explain FIVE use of power point presentation in the current times.
[5 Marks]
QUESTION THREE
a) Define the term text-box as used in word processing [2 Marks]
b) List SIX Characteristics of an integrated software [6 Marks]
c) From the sentences below, identify where Super & Script features have been
applied.
i) Kindly report on 22nd June 2001
ii) H2 + O2 = H2O
[2 Marks]
d) Explain FOUR methods used when launching applications.
e) Briefly, explain the following database terms, giving examples where appropriate
i. Primary Key
ii. Foreign Key
iii. Domain
iv. Data-type
v. Field
vi. Junction Table
[4 Marks]
[6 Marks]
QUESTION FOUR
a) Using examples differentiate between table and query as used in Ms Access
database application software.
[6 Marks]
b) Peter has bought a computer with the following software: Word Processing,
Spreadsheets, Database, Computerized Accounting and Graphics modules. State the
purpose of each module.
[5 Marks]
c) The computer had a CD-ROM drive. State clearly TWO differences between CD-
ROM and a Flash Disk.
[4 Marks]
d) Explain FIVE input devices the student can use to play games.
[5 Marks]
QUESTION FIVE
a) Explain how the following tasks can be executed in Ms-Excel
i) Adding numbers in a range
[1 Mark]
2
ii) Calculating the monthly loan repayment for a loan. Suggest the principal, time
and rate
iii)
[2 Marks]
Calculate for mean value of numbers
iv)Count occupied cell in a range
[1 Mark]
[1 Mark]
b) There are FIVE default folders in your computer windows program named below:
Explain the function of each.
i) My documents [1 Mark]
ii) My computer [1 Mark]
iii) My Network places [1 Mark]
iv) Recycle Bin [1 Mark]
v) Control Panel
[1 Mark]
c) Explain SIX data types you may use in a Microsoft Access table.
[6 Marks]
d) Explain the function of the following features/tools in word Processing
i) Replace
ii) Frames
iii) Show/hide icon
iv) Mailing
[4 Marks]
3
More Question Papers
Exams With Marking Schemes