Bmgt 121:Computer Programming For Business Question Paper
Bmgt 121:Computer Programming For Business
Course:Bachelor Of Commerce
Institution: Kabarak University question papers
Exam Year:2013
KABARAK UNIVERSITY
UNIVERSITY EXAMINATIONS
2013/2014 ACADEMIC YEAR
FOR THE DEGREE OF BACHELOR OF COMMERCE
BMGT 121: COMPUTER PROGRAMMING FOR BUSINESS
STREAM: Y1S2
DAY: ................ DATE: .............. TIME:.......................
INSTRUCTIONS
1. Answer
Question One
and
any other TWO
questions.
2.
Failure to adhere to the instructions on the cover page o
f the answer booklet will be penalized
.
Question One (30 marks)
a)
Distinguish the following terms as applied in computer pro
gramming; (10 marks)
i.
Algorithm versus Flow chart
ii.
Object code versus source code
iii.
Compiler versus Assembler
iv.
Cell address versus range in Excel
v.
Form letter versus Data file for mail merge
b)
In view of Visual Basic explain the following terminol
ogies; high level language,
structured language, procedural language, object oriented, and I
ntegrated Development
Environment. (10 marks)
c)
Write an algorithm for Area of a Triangle and draw its
respective flowchart. (10 marks)
2
Question Two (20 marks)
a)
In relation to Ms Access explain the meaning of the fol
lowing terms forms, tables, reports
and queries. (10 marks)
b)
Define the term DBMS and distinguish records from fields
, with an illustration of a table
and a form for STOCK database file. (10 marks)
Question Three (20 marks)
Study the following program and then answer the questions tha
t follow
Option Explicit
''Written By T. Chepkorir
Sub Fare()
Dim Age as Integer
Dim Price as Single
Age = InputBox("Age?")
If (Age < 16) Then
Price = 7.00
ElseIf (Age > 65) Then
Price = 5.00
Else
Price = 10.00
End If
MsgBox("Fare is " & Price)
End Sub
a)
Explain the meaning of the terms keywords, user defined wor
ds, variables, constants
and remarks; and identify each such elements in the progra
m above. (10 marks)
b)
Draw the flowchart for this code structure. (5 marks)
c)
Draw a sample Form for the above program and label its
parts (5 marks)
3
Question Four
a)
Ms Excel is a powerful software for business applicatio
n such as Invoices, below is an
extract of an invoice. Enter the possible formula for
the cells F25, F26, F29, F31 and F32.
(10 marks)
b)
With a clear illustrated example explain the following
terminologies as used in
programming; syntax error, runtime error, pseudocode, sel
ection, and iteration.
(10 marks)
More Question Papers