INSTRUCTIONS TO THE CANDIDATES
 Indicate your name and index number at the top right hand corner of the printout.
 Write your name and index number on the CD/removable storage medium provided.
 Write the name and version of the software used for each question attempted.
 This paper consists of two questions each having 50 marks.
 Answer all the questions Passwords should not be used while saving files.
 All files created must be saved in the provided CD/removable storage medium.
 Make printouts of your answers on the answer sheet provided.
 Hand in all the printouts and the Cd/Removable storage medium used.
 This paper consists of 7 printed pages.
 Students should check the question paper to ascertain that all the pages are printed as indicated and no question is missing.
 Candidates should answer the questions in English.
QUESTIONS
 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:
 Create a brochure named KUCCPS by creating a new master page with the following page layout.
 Paper size A4
 Orientation: Landscape.
 Margins guides 0.5inch or 1.3cm on top and bottom, 0.5 inch or 1.3cm inside and outside.
 Put 30% tint accent 3 background (7 marks)
 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)
 Save the publication as KUCCPS (1 mark)
 Print the publication (2 marks)
 Create a brochure named KUCCPS by creating a new master page with the following page layout.
 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

 Using a spreadsheet package, enter the above information and save it as SALES_TABLE. (9 marks)
 Format the worksheet to appear as it is. (4 marks)

 Type a formula:
 at cell B9 to compute the total sales for product P; (1 mark)
 at cell E2 to compute the total sales for Thomas (1 mark)
 Apply the formulae to the appropriate cells. (2 marks)
 Type a formula:
 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.
 Type a formula in cell F2 to compute total points earned by Thomas; (3 marks)
 Apply the formula in c(i) to the rest of the salespersons. (1 mark)
 A salesperson is categorized based on points earned as follows.
POINTS RANGE
CATEGORY
Over 1300
Gold
1101 – 1300
Silver
Up to 1100
Bronze
 Type a formula in G4 to determine Gabriel’s category. (5 marks)
 Apply the formula in d(i) to other appropriate cells. (1 mark)
 Type a formula at G10 to determine the number of salespersons who will earn a promotion. (4 marks)
 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)
 Create a bar chart showing Product P and Product R sales for each salesperson. Insert appropriate labels on the chart. (9 marks)
 Rename the worksheet containing the data as SalesData and the chart sheet as SalesChart (2 marks)
 Print the following: (3 marks)
 salesData
 SalesData showing the formulae;
 SalesChart.

MARKING SCHEME
QUESTION ONE
1. (a)  (i) Setting the paper size to A4.  1 mark 
(ii) Setting the orientation to Landscape.  1 mark  
(iii) Setting the top and bottom margin guides to 0.5 inches.  1 mark  
 Setting the inside and outside margin guides to 0.5 inches.  1 mark  
(iv)Putting the background to 30% tint accent 30 or equivalent colour.  3 marks  
7 marks  
(b)  Setting the main content text to font size 12.  2 marks 
Setting each of the heading text to Uppercase 2 x 4  8 marks  
Setting each of the heading text to font size 14.  2 marks  
Formatting each of the heading to bold. 1 x 4  4 marks  
 2 marks  
Inserting the wave banner for the main title.  3 marks  
 1 mark  
 4 marks  
 3 marks  
 7 marks  
 4 marks  
(c) 
 1 mark 
(d)  Print out.  2 marks 
QUESTION TWO
1.(a)  i) Each row ´ 1 mark  7 marks 
All labels  1 mark  
Saving  1 mark  

 9 marks 
ii) Format currency Bolding of labels header row and 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  1 mark  
= B2 + B3 + B4 +B5 + B6 + B7 + B8  
NB. Accept any other correct formulae from other spreadsheet packages  
II. Formula at E2  
= sum(B2:D2) OR  1 mark  
= B2 + C2 + D2  
(ii) application of formulae on row and column  2 marks  

 4 marks 
(c)  (i) Formula in cell F2  
= B2/50 +C2/65 * 2 + D2/40 * 3 OR  3 marks  
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  1 mark  

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

 10 marks 
(e)  Formula at H2  
= 20,000 + $B$12/100 * E2  4 marks  
Entering 2 and label (commission)  1 mark  

 5 marks 
(f)  Chart (Bar)  
Select the ranges ´ 1 mark per column 2 marks for product R  4 marks  
Invoke correct chart  1 mark  
Label x axis and yaxis  2 marks  
Legend  1 mark  
Title (chart)  1 mark  

 9 marks 
(g)  Renaming sheets  1 mark 1 mark 

 2 marks 
(h)  Printing  
 1 mark 1 mark 1 mark  

 3 marks 
Download Computer Studies Paper 2 Questions and Answers  Arise and Shine Mock Exams 2022.
Tap Here to Download for 50/
Get on WhatsApp 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