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:2014

KABARAK
UNIVERSITY
UNIVERSITY EXAMINATIONS
2013/2014 ACADEMIC YEAR
FOR THE DEGREE OF BACHELOR OF COMMERCE

BMGT 121: COMPUTER PROGRAMMING FOR BUSINESS
DAY: WEDNESDAY

DATE: 16/04/2014
TIME: 11.00 – 1.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.Machine Language versus 4GLs
ii.Object code versus source code
iii.Compiler versus Interpreter
iv.Relative Cell Reference versus Absolute Cell Reference (in Ms Excel)
v.Form versus Table (in Ms Access)
b) Explain what is mail merge hence define form letter, data file and merged letter.
Demonstrate how you can use this feature to create student transcripts in an academic
institution – with proper illustrations.(10 marks)
c) Explain what is flow charting and draw a flow chart for obtaining Adding Marks for 40
and obtain their Average Mark. Write some algorithm for this flowchart. (10 marks)

QUESTION TWO(20 marks)
Ms Excel has a lot of uses in Business. These include creating financial reports such as cash-flow
analysis, balance sheets, profit and loss accounts, etc. Demonstrate how you would create a one
year cash-flow analysis (month by month) for a young entrepreneur who wishes to take a loan of
Kshs 100,000 and is required by the lender to demonstrate ability to pay. Use a spreadsheet
illustration showing your revenue, expenses and various balances and the formula or
spreadsheets functions used. Specify/Explain any Ms Excel features used.

QUESTION THREE(20 marks)
a) Distinguish between a query and a report in Ms Access.(5 marks)
b) Micos Limited is a Dry Cleaning based in Nakuru town.
i.Design its database table with at least 10 fields and 10 records.(5 marks)
ii.Design an input form for capturing data into the database table and explain each
of the elements included.(5 marks)
iii.Design and illustrate 3 queries that you could perform using an output screen that
you would obtain for those queries.(5 marks)
QUESTION FOUR(20 marks)
a) Explain the meaning of Integrated Development Environment (IDE) and explain these
features with examples from Visual Basic.(5 marks)
b) Below is an extract of Visual Basic Code. Use it to answer the questions that follow:
Do While numitems <= maxnumitems
item = InputBox("item name:", "make receipt")
If item = "" Then GoTo totalit
thecost = Val(InputBox("item cost:", "make receipt"))
outputrange.Cells(numitems, 1).Formula = item
outputrange.Cells(numitems, 2).Formula = Str(thecost)
numitems = numitems + 1 ''increment the number of items.
Loop
i.Explain what are control structures in Visual Basic and explain THREE
examples of such structures.(5 marks)
ii.Explain what you think the program is doing, i.e. its purpose and the
meaning of each line of instruction.(5 marks)
iii. Draw a flowchart of the above program.(5 marks)

b) Study the following program and then answer the questions that 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

i.Identify what the program is meant for(2 marks)
ii.Identify THREE objects in the code(3 marks)
iii.Explain the purpose of the Dim and InputBox functions(2 marks)
iv.Write an algorithm for the above program(3 marks)
v.With flowchart, syntax and sample code, explain the SELECT CASE control
structure.(5 marks)

Bmgt 121: Computer Programming For Business Question Paper

More Question Papers

Popular Exams