Computer Studies Paper 2 Questions and Answers - Arise and Shine Mock Exams 2022

Share via Whatsapp

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)
      comp studies
  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

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

 
  • Using Algerian font.
    1mk for any other font.

2 marks

 

Inserting the wave banner for the main title.

3 marks

 
  • The title banner red background.
  • Award full marks for the colour depicted in the question paper.

1 mark

 
  • Setting each heading to orange accent 6 background. 1 x 4 
  • Award full marks for the colour depicted in the question paper.

4 marks

 
  • Correct bullet 1 x 3.
  • The teacher to allow any equivalent bullet incase the one indicated is not possible in the application available.

3 marks

 
  • Accurately typed text.
  • Penalise ½ marks for any misspelt or missing word.

7 marks

 
  • Accurately drawn graduate hood 2 x2     

4 marks

(c)

  • Saving the publication with the correct file name “KUCCPS”.
  • No mark for any different or misspelt file name.

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 y-axis

2 marks

Legend

1 mark

Title (chart)

1 mark

 

 

9 marks

(g)

Renaming sheets
- Data sheet
-Chart sheet

1 mark

1 mark

 

 

2 marks

(h)

Printing

 
 
  1. Sales data
  2. Sales data showing formulae
  3. Sales chart

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/-




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?