Get premium membership and access revision papers, questions with answers as well as video lessons.
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
2012/2013 ACADEMIC YEAR
FOR THE DEGREE OF BACHELOR OF COMMERCE
BMGT 121: COMPUTER PROGRAMMING FOR BUSINESS
DAY: THURSDAY
DATE: 15/08/2013
TIME: 2.00 – 5.00 P.M.
STREAM: Y1S2
INSTRUCTIONS:
1. Answer Question One and any other TWO questions.
2. Failure to adhere to the instructions on the cover page of the answer booklet will be penalized.
Question One
(30 marks)
a) Distinguish the following terms as applied in computer programming;
(10 marks)
i.
Low level language versus High level language
ii.
Object code versus source code
iii.
Compiler versus Interpreter
iv.
Re-calculation (in Ms Excel) versus Function or a formula (in Ms Excel)
v.
Record versus Field (in Ms Access)
b) Visual Basic is an Object Oriented Programming Language, and it is also a Structured
Programming Language, that is GUI based and provides an Integrated Development
Environment (IDE). Explain the meaning of the underlined terms.
(10 marks)
c) What is a flow chart? Draw a flow chart for obtaining NET PAY for 10 employees who
earn a BASIC PAY and HOUSE ALLOWANCE. The employees’ pay PAYE and some
take ADVANCE pay. Write some algorithm for the flowchart.
(10 marks)
Page 1 of 3
Question Two
(20 marks)
a) Mail merge is a powerful feature in Ms Word. Explain what is mail merge explaining the
procedure for using it and describe the terms form letter, data file and merged letter as
applied to the mail merge process.
(10 marks)
b) Use the extract of Ms Excel spreadsheet for a Cash-flow analysis below to answer the
following questions.
(10 marks)
i.
How would you use Autofill feature to the months April to November quickly
ii.
Write down the formula/functions that could be used in Cell C23, C30, C31 and
C33.
Question Three
(20 marks)
a) You have been hired as produce manager at Ronaldos Fresh Produce Limited. The
company has a farm that grows a number of fresh produce including French beans,
onions, cabbages, carrots, etc. When the items are taken from the gardens they are
weighed then entered in a produce record form. You are required to:
i.
Distinguish between Forms, Tables and Reports as used in Ms Access. (6 marks)
ii.
Identify FOUR fields necessary for creating above database table (N.B. use one
word for a field).
(2 marks)
iii.
Give examples of TWO queries that one can obtain from this table. (2 marks)
Page 2 of 3
Question Four
(20 marks)
a) Using examples or illustrations explain the meaning of the terms label, textbox, button,
operators and properties as used in Visual Basic
(10 marks)
b) Study the following program and then answer the questions that follow
Private Sub btnCalcGrossPay_Click(ByVal sender As System.Object, _
ByVal As System.EventArgs) Handles btnCalcGrossPay.Click
‘Define a variable to hold the gross pay.
Dim sngGrossPay As Single
‘Convert the values in the text boxes to numbers,
‘and calculate the gross pay.
sngGrossPay = CSng(txtHoursWorked.Text) * CSng(txtPayRate.Text)
‘Format the gross pay for currency display and
‘assign it to the Text property of a label.
lblGrossPay.Text = FormatCurrency(sngGrossPay)
End Sub
i.
Identify what the program is meant for
(2 marks)
ii.
Identify THREE objects and THREE keywords in the code
(3 marks)
iii.
Draw a well labeled sample Form for the above program code; make sure its
control objects are clearly identified.
(5 marks)
Page 3 of 3
More Question Papers