INSTRUCTIONS TO THE CANDIDATES

1. Indicate your name and index number at the top right hand corner of the printout.
2. Write your name and index number on the CD/removable storage medium provided.
3. Write the name and version of the software used for each question attempted.
4. This paper consists of two questions each having 50 marks.
5. Answer all the questions Passwords should not be used while saving files.
6. All files created must be saved in the provided CD/removable storage medium.
7. Make printouts of your answers on the answer sheet provided.
8. Hand in all the printouts and the Cd/Removable storage medium used.
9. This paper consists of 7 printed pages.
10. Students should check the question paper to ascertain that all the pages are printed as indicated and no question is missing.
11. Candidates should answer the questions in English.

QUESTIONS

1. The document below is a brochure of KENYA UNIVERSITY AND COLLEGES CENTRAL PLACEMENT SERVICE (KUCCPS). Use a desktop publishing package to design it exactly the way it appears with the following specifications:
   1. Create a brochure named KUCCPS by creating a new master page with the following page layout.
      1. Paper size A4
      2. Orientation: Landscape.
      3. Margins guides 0.5inch or 1.3cm on top and bottom, 0.5 inch or 1.3cm inside and outside.
      4. Put 30% tint accent 3 background (7 marks)
   2. Enter the text and objects and format them as they appear. Use Font size 12 for the text and font size 14 for the titles. (40 marks)
   3. Save the publication as KUCCPS (1 mark)
   4. Print the publication (2 marks)
      
2. Company XYZ sells products P, Q and R. Figure 1 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	7005.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 1
   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 marks)
   3. A salesperson earns 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 total points earned by Thomas; (3 marks)
        2. Apply the formula in c(i) 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 2 is entered in cell B12. (5 marks)
   6. Create a bar chart showing Product P and Product R sales for each salesperson. Insert appropriate labels on the chart. (9 marks)
   7. Rename the worksheet containing the data as SalesData and the chart sheet as SalesChart (2 marks)
   8. Print the following: (3 marks)
      1. salesData
      2. SalesData showing the formulae;
      3. SalesChart.

MARKING SCHEME

QUESTION ONE

QUESTION TWO