KCSE 2012 Computer Studies Paper 2 with Marking Scheme

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)
      
   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"
      
      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