COMPUTER STUDIES PAPER 2 - KCSE 2019 MOKASA PRE MOCK EXAMINATION

Question One
The following data is an extract of data obtained from Kahawa company records. Study the data and answer the questions that follow.

1. Enter the data shown above into a spreadsheet giving it an appropriate title, center and bold across the worksheet. Save the workbook as CHAT 001. Rename the worksheet as June records                                                                                                 (10 Marks)
2. Copy the data to a new worksheet and add the details of producer James Kirega of area 101B, ID 452 with quantity of produce of 2,700kg in an appropriate row.                         (1 Mark)
3. Insert double borders around every cell and every row.                         (2 Marks)
4. Use a function to calculate the Total cost for the producer with ID number 115 given that the price per KG of the produce is Sh.41 .00                         (2 Marks)
5. Use the formula for Total cost obtained for producer John Kamau and use it to calculate the gross cost for all the farmers                         (2 Marks)
6. 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

7. Insert the value 20% in cell E14. Using absolute cell referencing calculate deductions, given that the deduction is 20% of the Total cost.                         (4 Marks)
8. Using a function calculate the Net cost, given that Net cost is Gross cost minus deductions and gross cost is Total cost plus Transport cost                         (4 Marks)
9. Format the columns containing currency values to currency with 2 decimal places and prefix Ksh. Rename the worksheet PRODUCE PAY.                       (3 Marks)
10. Arrange the records in ascending order of the producer ID. (2 Marks)
11. Copy the contents of worksheet June records to a new worksheet and rename it as Filtered. By applying suitable filter condition, display records for all producers except those from area 79A.                            (4 Marks)
12. Use subtotals function to calculate subtotals for the quantity delivered, gross pay and net pay from each area.                                                                                                             (3 Marks)
13. Create an embedded pie chart showing the total quantity of produce delivered for each area .The chart should have the following details.
    1. Chart title: Area Total produce delivered
    2. Legend Position: Right
       Save it as CHART 1                                                                                         (5 Marks)
14. Print June records, Produce Pay and Filtered in landscape orientation.             (3 Marks)

Question 2

You are part of a wedding committee of your friend and you have a vast knowledge of using a computer; you are tasked to be in charge of the wedding cards. Using a desktop publishing software, design the wedding card as it appears. Name the file as W_Card.                                  (24marks)

1. Prepare the page layout specifications as follows:
   • Paper size: A4 portrait (2mks)
   • Grid guides (3mks)
   • Column guides: 1
   • Row guides: 2
   • Spacing: 3”
   • Margins guides (2mks)
   • Left and right: 24”
   • Top and bottom: 25”
     
     
2. Format the Outer heart shape in the middle part of the design to the following specifications:          (4marks)
   1. Color: Red
   2. Outline: Light blue
   3. Height: 2.64”
   4. Width: 2.84”
3. Perform the following formatting on the rectangle of the first part of the design.
   1. Apply an outline shadow.                                                                                                                           (1mark)
   2. Background Texture fill - Newsprint.            (2Marks)                                                                                                
   3. Add a glow (Accent 1, 18pt glow), glow size 25pts, and 57% transparency.                     (4marks)  
4. Change the paragraph text starting from “Request the blessings…” to color cold with line spacing of 75sp.               (2marks)
5. Format the names of the bride and bridegroom to have a strikethrough and a dotted underline.                     (2marks)
6. Group all objects in the design.      (2marks)
7. Insert a page header “LOVE IS A GOOD THING”.                              (1mark)
8. Print the publication.                                                                                                                              (1mark)