KCSE 2012 Computer Studies Paper 2 with Marking Scheme

Share via Whatsapp
  1. Tip Top consultants has shortlisted candidates for an interview for various positions in their organization. The following is a standard letter for cach of the candidates to be interviewed. The information enclosed in <<>> represents details about recipients, positions, dates and time of the interview.
    1. Using a word processor, type the document as it appears and save it as Letter Main   (16 marks)
      KCSE 2012 CS PP2 Q1a
    2. Insert the following as a footer:
      Vision: "To be a leader in the provision of quality Human Resource for development"   (2 marks)
    3. Create the logo in Figure 1 and position it below the statement "Top Human Resources Consultants"
      KCSE 2012 CS PP2 Q1c
      Figure 1         (6 marks)
    4. Table I shows details about shortlisted candidates. Create a data source to store information in the table and save it as ListFile.  (11 mks)
       Title   First Name   Second Name   Address   Town   Position   Date    Time 
       Miss  Anyango   Wafula   365675   Kisumu   ICT Assistant    6th Dec   11.30am 
       Ms.  Caroline   Kandai   3456   Kajiado  Accountant  6th Dec  12:30pm
       Mr.  Zachary   Esokon    123   Lodwar   ICT Assistant   7th Dec  1:30pm
       Mrs.  Susan  Chemutai  721  Eldoret   Accountant   7th Dec  2:30pm
       Mr.  Jilo  Buya   222   Mombasa   Accountant  8th Dec  12:00pm
       Mr.  Sospeter  Kamau   912  Kiambu  Accountant  9th Dec  12;30pm
      Table 1
    5. Using mail Merge feature, merge the files Letter Main and List File and save the document as Merged Document     (5 marks)
    6. Insert page numbers at the top right hand side in the merged document saved in (e) above.
      (2 marks)
    7. Using List File as a data source, create a list of addresses to be printed on envelopes as shown in Figure 2 and save it as envelopes.  (4 marks)
      <<Title> <First Name>> <<Second Name>>,
           P.O. Box <<Address>>,
      <<Town>>.
                        Figure 2
    8. Print the following;    (4 marks)
      1. LetterMain;
      2. ListFile;
      3. Page 5 of the Merged document;
      4. Address to be printed on the first envelope.
  2. Company XYZ sells products P, Q and R. Figure 3 shows an extract of a spreadsheet for the company's salespersons and their respective sales in shillings for each product.
       A   B   C   D   E   F   G   H 
     1   SALES PERSON  PRODUCT P  PRODUCT  Q  PRODUCT R  TOTAL SALES   POINTS   CATEGORY   TOTAL   PAY
     2  Thomas  4,000.00  6,230.00  7,500.00        
     3  Jane  4,500.00  6,700.00  8,000.00        
     4  Gabriel  5,678.00  10,000.00  7,800.00        
     5  Kipkorir  3,200.00  4,000.00  9,600.00        
     6  Anyango  8,000.00  7,005.00  8,900.00        
     7  Nekesa  9,800.00  9,670.00  10,000.00        
     8  Kinuthia  2,700.00  3,400.00  2,300.00        
     9  TOTAL              
    Figure 3
    1.  
      1. Using a spreadsheet package, enter the above information and save it as
        SALES_TABLE.   (9 marks)
      2. Format the worksheet to appear as it is.  (4 marks)
    2.  
      1. Type a formula:
        1. at cell B9 to compute the total sales for product P,   (1 mark)
        2. at cell E2 to compute the total sales for Thomas.    (1 mark)
      2. Apply the formulae to the appropriate cells.   (2 mark)
    3. A salesperson carns points for the sales of each product based on the following criteria;
      • 1 point for every shs 50 for product P,
      • 2 points for every shs 65 for product Q.
      • 3 points for every shs 40 for product R.
        1. Type a formula in cell F2 to compute the total points earned by Thomas  (3 marks)
        2. Apply the formula in (c) to the rest of the salespersons. (1 mark)
    4. A salesperson is categorized based on points earned as follows.
       POINTS RANGE   CATEGORY 
       over 1300  Gold 
       1101-1300   Silver 
       Up to 1100   Bronze 
      Those salespersons attaining a Gold category earn a promotion
      1. Type a formula in G4 to determine Gabriel's category.   (5 marks)
      2. Apply the formula in (d)(i) to other appropriate cells.   (1 mark)
      3. Type a formula at G10 to determine the number of salespersons who will earn a promotion
        (4 marks)
    5. Each salesperson earns a total pay of Shs 20,000 plus 2% commission of their total sales. Using absolute referencing, determine the total pay for each salesperson if the value is entered in cell B12     (5 marks)
    6. Create a bar chart showing Product P and product R sales for each sales person. Insert appropriate labels on the chart.    (9 marks)
    7. Rename the worksheet containing the data as Sales Data and the chart sheet as SalesChart  
      (2 marks)
    8. Print the following:    (3 marks)
      1. Sales Data;
      2. Sales Data showing the formulae;
      3. SalesChart.


MARKING SCHEME

 1. (a) 
  • Title: TIP TOP CONSULTANTS 
  • Subtitle 
  • addresses
    Date (Monday, 11 April 2009)
  • recipient address block 
  • reference (typing) 
    double underline
    bolding
  • justification 
  • bullets 
  • salutation 
  • body text (3 sections @ 1 mark each) 
  • saving (letter main)

  2marks
  1 mark
  2marks 
  1 mark
  1 mark 
  ½ mark
  1 mark
  ½ mark
  1 mark
  1 mark
  1 mark
  3 marks 
  1 mark 

     16 marks 
    (b) Footer
text
position in the footer area)
 
 1 mark
 1 mark
     2 marks
   (c)

Logo 

  • 3 objects x 1 
  • text
  • line weight
  • positioning
 
 
 3 marks
 1 mark
 1 mark
 1 mark
     6 marks
  (d)

Data source

  • creating 8 fields x ½
  • each record 6 x 1
  • saving (List file)

 

 4 marks
 6 marks
 1 marks

     11 marks
  (e)

Merging

  • positioning 9 fields correctly 
  • saving (merged document)

 

4½ marks
  ½ mark

     5 marks
  (f)  Page numbering  2 marks
  (g)

Producing envelopes

  • Fields (@ ½ mark per field)
  • Layout (@  ½ mark per line)

 

 2½ marks
 1½ marks

     4 marks
  (h)

Printing

  • main letter 
  • data source 
  • merged document page 5 
  • print the first envelope
 

 1 mark
 1 mark
 1 mark
 1 mark
      4 marks
 2 (a)  (i) Each row x 1 mark
     All other labels
     Saving
 7 marks 
 1 mark
 1 mark
     9marks
   (ii) Format currency
       Bolding of labels - header row & total
       Double border/Text wrap
       All other borders
1 mark
1 mark
1 mark
1 mark
    4 marks
 (b)  (i) I. Formula at B9
        = Sum (B2:B8) OR
          = B2 + B3 +34 + B5 + B6 ÷ B+ BS
       NB: Accept any other correct formulae from other
       spreadsheet packages
    II. Formula at E2
          = Sum (B2:D2) OR
          = B2+ C2 + D2
(ii) Application of formulae on row and column
 1 mark
 




1 mark

2 marks
     4 marks
 (c) (i) Formula in cell F2
    = B2/50 + C2/65 * 2 + D2/40 * 3 or
    = int(B2/50) + int (C2/65) * 2 + int (d2/40) *3 or
     = int(B2/50 + C2/65 * 2 + D2/40 *3
(ii) Formula application/copying

3 marks
 

1 mark

     4 marks
 (d) (i)Formula in G4
   = IF(F4 >= 1300, "Gold", IF(F4 >= 1100, "Silver", "Bronze"))
(ii) Formula application
(iii) Formula at G9
      = COUNTIF(G2:G8, "GOLD")
     Label (those to be promoted)
5 marks

1 mark

3 marks
1 mark
    10  marks
 (e) Formula at H2
= 20,000+ $B$12/100 * E2
Entering 2 and label (commission)
 4 marks
 1 mark
     5 marks
 (f) Chart (Bar)
Select the ranges x 1 mark per column 2 marks for product R
Invoke correct chart
Label x-axis and y-axis
Legend
Title (chart)


4 marks
1 mark
2 marks
1 mark
1 mark

    9 marks
 (g)

Renaming sheets 

  • Data sheet
  • Chart sheet


1 mark
1 mark
    2 marks
 (h)  Printing (i) Sales data
             (ii) Sales data showing formulae
             (iii) Sales chart
1 mark
1 mark
1 mark
    3 marks

 


Download KCSE 2012 Computer Studies Paper 2 with Marking Scheme.


Tap Here to Download for 50/-




Why download?

  • ✔ To read offline at any time.
  • ✔ To Print at your convenience
  • ✔ Share Easily with Friends / Students


Join our whatsapp group for latest updates
.
Subscribe now

access all the content at an affordable rate
or
Buy any individual paper or notes as a pdf via MPESA
and get it sent to you via WhatsApp

 

What does our community say about us?

Join our community on:

  • easyelimu app
  • Telegram
  • facebook page
  • twitter page
  • Pinterest