Bbt2102:Application Programming Ii Question Paper
Bbt2102:Application Programming Ii
Course:Bachelor Of Business Information Technology
Institution: Meru University Of Science And Technology question papers
Exam Year:2011
1
a) Explain the following terms as applied to Office application programming
i. Object browser (3 Marks)
ii. Procedure (2 Marks)
iii. Sub procedure (1 Mark)
b) Explain the purpose of each of the following:
i. Sub ShowTime() (2 Marks)
Range(“ci”)=Now()
End Sub
ii. Function sumNo=(x,y) (2 Marks)
sumNo=x+y
End Function
c) Distinguish between a public and private procedure. (4 Marks)
d) Describe the action taken by each of the following buttons in Microsoft Excel;
i. Trace dependents (2 Marks)
ii. Trace Precedents (2 Marks)
iii. Chart type (2 Marks)
iv. Line/Column Chart AutoFormat (2 Marks)
v. AutoFilter (2 Marks)
2
e) Command Buttons in VBA for Excel are usually placed at the bottom of the form and
serve to complete the transaction for which the form has been created. The caption of
these buttons are usually “GO”, “Run”, “Submit, “Cancel, etc.
Explain three properties of a command button. (6 Marks)
QUESTION TWO (20 MARKS)
a) Write the macro Visual Basic Code that will display the following Microsoft Excel
Worksheet. (Figure 1) (14 Marks)
Figure 1: CAT 1 Spreadsheet.
b) Explain the following types of errors in Visual Basic Application programming.
i. Language errors (2 Marks)
ii. Run-time errors (2 Marks)
iii. Logic errors. (2 Marks)
QUESTION THREE (20 MARKS)
a) Design three tables: SUPPLIER, CUSTOMER and PRODUCT, clearly identifying the
key and foreign fields – each Table should have five fields. (15 Marks)
b) Show diagrammatically how the three tables are linked (5 Marks)
3
QUESTION FOUR (20 MARKS)
a) Describe briefly what the procedure shown below does (3 Marks)
Sub pro Test()
Sheets(“Sheet 1”).Select
Range(“CI”).Select
Do Until Selection.Offset(0,-2). Value=””
Selection.Value=Selection.Offset(0,-2).Value&” “&Selection.Offset(0,-1)
Selection.Offset(1,0).Select
Loop
Range(“AI”).Select
End Sub
b) i) Explain what an Excel spin button is. (3 Marks)
ii) Outline four properties of a spin button. (4 Marks)
c) discuss the process of mail merge in MS Word
QUESTION FIVE (20 MARKS)
a) The Visual Basic Editor allows you to print the current module, all modules, a UserForm,
or the entire project.
Outline four steps of printing a current module. (8 Marks)
b) Table 1 shows the University Examination Grading System used by many universities
worldwide:
Range of score Grade Comments
0<=Score<40 E Fail
40<=Score<50 D Weak Pass
50<=Score<60 C Pass
60<=Score<70 B Credit
70<=Score<=100 A Distinction
Table 1: University Examination Grading System
Figure 2 shows the performance of BIT candidates in a certain University
4
i. Write a formula in cell E7 that will compute the Total Internal score (Max.30)
(2 Marks)
ii. Write a formula in a cell G 7 that will compute the Grand Total (Max.100)
(2 Marks)
iii. Write the IF function in cell H7 that will be used to determine the candidate’s
Grade based on the information given in Table 1. (5 Marks)
iv. Write the IF function in cell 1 7 that will be used to determine the comments for
the candidate based on the information given in Table 1
More Question Papers