Maranda Computer studies past papers

Name…………………………………………………………………  Index No…………………………

School…………………………………………………………………Candidate’s signature………….




Paper 2


July / August 2012

Time 2 ½ HOURS


Kenya Certificate of Secondary Education (K.C.S.E)



Paper 2


July / August 2012

Time 2 ½ HOURS


1.         Type your name, school and index number at the top right hand corner of each printout

2.         Sign and write date of examination in the spaces provided above

3.         Write your name and index number on the removable storage medium

4.         Passwords should not be used while saving on the removable storage

5.         Answer ALL questions

6.         All questions carry equal marks

7.         ALL answers MUST be saved in the removable storage

8.         Make a printout of the answer sheets provided

9.         Hand in all the printout at the removable storage.

This paper consists of 8 printed pages.

Candidates should check the question paper to ensure that all

pages are printed as indicated and no questions are missing

1.         The following data is an extract of data obtained from Chai company records. Study the data and answer the questions that follow.

Area Producer id Name Quantity delivered (kg) Gross pay Transport cost Deduction Net pay
101B 115 John Kamau 4562        
79A 145 Mathew B 1254        
79A 012 Kanuga Symon 235        
79A 561 Ann Wangige 8954        
101B 016 Joseph Kaitano 9658        
20Z 123 Namachanja Esther 7895        
20Z 458 Kerobo Betty 456        
101B 654 Flo Ngina 421        
20Z 758 Mary Nguriareng’ 7895        

a)         Enter the data shown above into a spreadsheet giving it an appropriate title centre and bolded across the worksheet. Save the workbook as CHAT 001. And rename the worksheet as June records                                                                                                                   (10 marks)

b)         Copy the data to a new worksheet and add the details of producer James Kirega of area 1O1B, id 452 with quantity of produce of 2,700kg in an appropriate row.                               (1 mark)

c)         Insert borders after every cell and every row.                                                                        (2marks)

d)         Use a function to calculate the gross pay for the producer with id number 115 given that the price per KG of the produce is Sh.41 .00                                                                      (2 marks)

e)         Use the formula for gross pay obtained for producer John Kamau to calculate the gross pay for all the farmers                                                                                                            (2 marks)

f)         Use if function to Calculate transport cost for all the producers given that transport is charged per Kg is as follows                                                                                                    (5 marks)

AREA Price per kg
101B 5.00
20Z 3.50
 79A 4.00

g)         Insert the value 20% in cell E14. Using absolute cell referencing calculate Deductions given that the deduction is 20% of the cost.                                                                         (4 marks)

h)         Using a function calculate the net pay given that Net pay is Gross pay — deductions and transport cost                                                                                                                  (4marks)

i)          Format the columns containing currency values to currency with 2 decimal places and prefix Ksh. Rename the worksheet PRODUCE PAY and save it as CHAI 002                         (3marks)

j)          Arrange the records in ascending order of the producer id                                         (2 marks)

k)         By applying suitable filter condition, display records for all producers except those from area 79A. Save it as CHAT 003                                                                                      (4 marks)

1)         Use subtotals function to calculate subtotals for the quantity delivered, gross pay and net pay from each area.                                                                                                        (3 marks)

m)        Create an embedded pie chart showing the total quantity of produce delivered for each area the chart should have the following details.)

a.         Chart title Area Total produce delivered

b.         Legend Position Right

Save it as CHART 1                                                                                       (5marks)

n)         Print CHAT 001, CHAI 002, and CHART 1 in landscape orientation.                   (3 marks)

2.         TechBit Computer College and Consultancy centre have set up a special advertising campaign to market its course. As a DTP expert, you have been appointed to assist the marketing team in designing a brochure. The rear page of the brochure is given in the next sheet

The fonts, borders and graphics used should be relevant to the publication as may be available in your software

(a)        Prepare a publication with the following specifications:

i)          Paper size set to A, landscape                                                                                     (2 marks)

ii)         Set margins to 10mm (0.4”) all round                                                                         (2 marks)

iii)        Set the publication to be in three columns measuring 88mm, 84mm and 93mm respectively

 (2 marks)

iv)        Set the space between columns to 6mm                                                                     (2 marks)

(b)        Key in the text as shown in columns 1-3 in the sample provided. Save your work as

sample 1                                                                                                                      (8 marks)

(c)        In column (title pane), format the various items as follows:

i)          Set the transparency of the fill colour to 25%                                                (2 marks)

ii)         Bold and italicize the mission statement heading                                           (2 marks)

iii)        Italicize and centre the mission statement                                                     (2 marks)

iv)        Set the vertical alignment of the text box bearing the words The Best College for You to middle                                                                                                 (1 mark)

v)         Apply blue and green fill to stars on your left and right respectively as shown in the sample                                                                                                             (3 marks)

vi)        Place the clipart and word art appropriately as shown in column 3 of the sample.

 (4 marks)

vii)       Save your work as sample 2                                                                            (1 mark)

(d)       In column I (Liaison offices), format the text as follows;

i)          Apply shadow to the title Liaison Offices and set the font size to 20           (2 marks)

ii)         Apply double underline to each of the telephone numbers                            (2 marks)

iii)        Set the colour of the names of the buildings to blue                                      (2 marks)

iv)        Insert the footer: Registration and enquiries at our head office                      (1 mark)

v)         Apply blue outline to the textbox bearing the title Liaison Offices             (1 mark)

(e)        Create a mailing coupon as it appears in column 2                                                     (2 marks)

(f)        Format the mailing coupon as follows:

i)          Bolden and centre the address as shown in the sample                                  (2 marks)

ii)         Draw and enter Place stamp here caption at the top right corner                 (2 marks)

iii)        Save your work as sample 3                                                                            (1 mark)

(g)        Print Sample 1, Sample2 and Sample 3                                                                      (3 marks)