1
NGURWEINI SECONDARY SCHOOL
NAME ______________________________________ADM NO. ______CLASS______DATE__________
FORM 3
COMPUTER STUDIES-PRACTICAL
451/2
PAPER TWO
2 ½ HOURS
INSTRUCTIONS TO CANDIDATES.
Write the version of software used for each question attempted
Answer all questions
Write your name and Class Adm number on the Question Paper and the printouts
Password should not be used while saving
All questions carry equal marks
Hand in all printouts and the removable storage media.
FOR OFFICIAL USE
Question Maximum score Student’s score
1 50
2 50
Total 100
1|Page
2
This paper consists of 3 printed pages. Candidates should check the question paper to ensure that all
pages are printed as indicated and no questions are missing
1. a) Joy millers company limited has given you the details below to be used in calculating expenses
incurred during two quarters of the year as indicated. Use a spreadsheet package to enter the
details, and save your work as Expenses 1. (10 marks)
A B C D E F G
1 JOY MILLERS COMPANY LIMITED
2 P.O BOX 253 KUTUS
3 First quarter Second quarter
4 January February March April May June
5 Production cost 15642 14687 18741 19457 15412 15441
6 Transportation 1564 1469 1874 1946 1541 1544
7 Warehousing 1125 1056 1347 1398 1107 1109
8 Promotion 2564 2407 3071 3188 2525 2530
9 Salary 4525 4248 5420 5626 4456 4465
b) i) Copy the details of Joy millers company limited to sheet 2 of your worksheet. (2marks)
ii) Add a column called “Total” and calculate the Total production cost of the two Quarters.
(4marks)
iii) Use relative referencing to calculate the total for the other expenses. (4marks)
c) i) Calculate the total expenses for each month so as to give the results as “Total expenses” on
row 10. (4marks)
ii) On the paper provided, write the formula used to calculate the expenses for the month of
April. (2marks)
d) i) Use absolute referencing to calculate the cumulative total expenses for the two quarters in cell
H10. (4marks)
ii) Write the formula used to get the cumulative total on the paper provided. (2marks)
iii) Calculate the percentage of total expenses of the respective months and display the results on
row 11 as “percentage of total expenses”. (4marks)
iv) Write the formulae used to get the percentage of May. (2marks)
v) Draw a line graph to illustrate the percentage of the total expenses for the six months
indicating the months. Save your work as Expenses 2. (10 marks)
2|Page
3
vi) Print Expenses 1 and Expenses 2. (2marks)
2. (a) Use a DTP software to design the following publication as it is with the following settings:
(i) paper size = A4
(ii) orientation = Landscape
(iii) page margins = 0.25 inches all around
(i) Guides: Column 1 Width = 5.2”
Space between Columns = 0.75”
Column 2 Width = 5.2”
(ii) File name = ExcellenceBook (6 marks)
(b) Design the publication as it appears on the following page on the page you have created and
fit all the items within the page. (38 marks)
(c) Insert your name and admission number as header, then your class and page number as
footer. (4 marks)
(d) Print the publication. (2 marks)
3|Page
4
4|Page