ASC454 5 
CONFIDENTIAL
CS/JAN 2012/ASC454
UNIVERSITI TEKNOLOGI MARA
FINAL EXAMINATION
COURSE
ACTUARIAL PROGRAMMING
COURSE CODE
ASC454
EXAMINATION
JANUARY 2012
TIME
3 HOURS
INSTRUCTIONS TO CANDIDATES
1.
This question paper consists of six (6) questions.
2.
Answer ALL questions in the Answer Booklet. Start each answer on a new page.
3.
Do not bring any material into the examination room unless permission is given by the invigilator. Please check to make sure that this examination pack consists of:
i)
ii)
the Question Paper an Answer Booklet - provided by the Faculty
DO NOT TURN THIS PAGE UNTIL YOU ARE TOLD TO DO SO
This examination paper consists of 5 printed pages
© Hak Cipta Universiti Teknologi MARA
CONFIDENTIAL
CS/JAN 2012/ASC454
CONFIDENTIAL
QUESTION 1
Variable
X
y i n
Cell
A4
A5
B4
B5
By referring to the above table, write the equivalent formula in a formula bar of Microsoft
Excel worksheet for each of the following expression:
i) a = (yx)a W |.+y(l + 0~ n ii) a = n ( 7 ( l + i) - 1) iii) a = ctei.
• \
1 . 1
iv) a = -—- + '
(l+i)
d
v) a = x ln(l + 0 + y On (1 + i)
(10 marks)
QUESTION 2
a) Write a For...Next loop code that computes the sum of 1/2 + 2/3 + 3/4 + 4/5 + ... +
99/100.
(5 marks)
b) By using a command button in a Microsoft Excel worksheet, create a Visual Basic program that asks the user to enter a month by number and then displays the name of the month. For example, if the user inputs 2, the program should display "February".
Your program should use an array of 12 strings and assign the appropriate string to each of the elements according to each month.
(5 marks)
© Hak Cipta Universiti Teknologi MARA
CONFIDENTIAL
CONFIDENTIAL
3
CS/JAN 2012/ASC454
QUESTION 3
An instructor needs a system that calculates the average mark for each student taking
ASC454 course. Assume that Testl, Test2 and the Final Examination marks are stored in an
Excel worksheet as below:
,_A_
.k. Name
_B jTest 1
c
Test 2
1
;P
1
JL
i
Final
CS/JAN 2012/ASC454
UNIVERSITI TEKNOLOGI MARA
FINAL EXAMINATION
COURSE
ACTUARIAL PROGRAMMING
COURSE CODE
ASC454
EXAMINATION
JANUARY 2012
TIME
3 HOURS
INSTRUCTIONS TO CANDIDATES
1.
This question paper consists of six (6) questions.
2.
Answer ALL questions in the Answer Booklet. Start each answer on a new page.
3.
Do not bring any material into the examination room unless permission is given by the invigilator. Please check to make sure that this examination pack consists of:
i)
ii)
the Question Paper an Answer Booklet - provided by the Faculty
DO NOT TURN THIS PAGE UNTIL YOU ARE TOLD TO DO SO
This examination paper consists of 5 printed pages
© Hak Cipta Universiti Teknologi MARA
CONFIDENTIAL
CS/JAN 2012/ASC454
CONFIDENTIAL
QUESTION 1
Variable
X
y i n
Cell
A4
A5
B4
B5
By referring to the above table, write the equivalent formula in a formula bar of Microsoft
Excel worksheet for each of the following expression:
i) a = (yx)a W |.+y(l + 0~ n ii) a = n ( 7 ( l + i) - 1) iii) a = ctei.
• \
1 . 1
iv) a = -—- + '
(l+i)
d
v) a = x ln(l + 0 + y On (1 + i)
(10 marks)
QUESTION 2
a) Write a For...Next loop code that computes the sum of 1/2 + 2/3 + 3/4 + 4/5 + ... +
99/100.
(5 marks)
b) By using a command button in a Microsoft Excel worksheet, create a Visual Basic program that asks the user to enter a month by number and then displays the name of the month. For example, if the user inputs 2, the program should display "February".
Your program should use an array of 12 strings and assign the appropriate string to each of the elements according to each month.
(5 marks)
© Hak Cipta Universiti Teknologi MARA
CONFIDENTIAL
CONFIDENTIAL
3
CS/JAN 2012/ASC454
QUESTION 3
An instructor needs a system that calculates the average mark for each student taking
ASC454 course. Assume that Testl, Test2 and the Final Examination marks are stored in an
Excel worksheet as below:
,_A_
.k. Name
_B jTest 1
c
Test 2
1
;P
1
JL
i
Final