Computer Studies Paper 2 Questions and Answers - Chogoria Murugi Zone Pre Mock Exams 2023

Share via Whatsapp

INSTRUCTIONS TO CANDIDATES.

  • Type your name and index number at the top right hand corner of each printout
  • Sign and write the date of the examination below the name and index number on each printout
  • Write your name and Admission number on the compact disks
  • Write the name and version of the software used for each question attempted in the answer sheet.
  • Passwords should not be used while saving in the compact disks.
  • Answer all the questions
  • All questions carry equal marks
  • All answers must be saved in your compact disks
  • Make a printout of the answers on the answer sheets provided.
  • Hand in all the printouts and the compact disks.

Question 1

  1. Create a folder on the desktop called MAVUNO COMPANY LIMITED.     (50 marks)
    1. Using spreads sheet program enter the following data and Save the file as mavuno payroll inside the folder created above.(10 marks)
    2. Insert printable borders(2 marks)
    3. Arrange  the department from A to Z (2 marks)
    4. Rename sheet one as original.(1 mark)
      Screenshot 2023 05 30 at 10.20.24
    5. Copy original sheet to sheet two and rename it as payroll, calculate the following ;(12 marks)
      1. Basic pay
      2. Gross pay
      3. Tax deductions
      4. Nssf contributions
      5. Allowances
      6. Net pay
        Nb: Use the formula below
        BASIC PAY =HOURS WORKED *HOURLY RATE
        ALLOWANCE ARE ALLOCATED AS 10% 0F BASIC PAY
        Gross pay =BASIC PAY + ALLOWANCE
        TAX DEDUCTION is calculates as 20% of the GROSS PAY
        NET PAY=GROSS PAY-DEDUCTIONS
    6. Copy names and basic pay to sheet three rename sheet three as chart.(2 marks)
      1. Create column chart using employee’s names, basic pay and allowances.(3 marks)
      2. Set the chart title as payroll at the top 2022(2 marks)
      3. Insert legend at the bottom(1 mark)
      4. Add data labels at the top(1 mark)
      5. Format chart border as; solid line, solid color-red, transparency-50%.(3 marks)
    7. Copy pno, name,gender,department and netpay from payroll sheet to calculate the following ;
      (2 marks)
      1. Calculate the subtotals of each department  and grand total, save the sheet as subtotals (4 marks)
      2. Freeze the header(1 mark)
    8. Print the following;                                                                    (4 marks)
      1. Original worksheet
      2. Payroll worksheet
      3. Chart worksheet
      4. Subtotals  worksheet

Question 2

Design a publication to appear exactly as shown in the next page using the following instructions. (20marks)

  1.  
    1. Launch the DPT package and set measurements to centimeters and the margins 2cm all round
    2. Paper size A4 portrait.
  2. Save your work as “Modern computers”                                                                                 (2marks)
  3. The heading “Introduction to computers The Basics” to have the following styles.              (5marks)
    • Centered across the page
    • Font face
    • Font size: 18
    • Background Texture: Granite
    • Format the drop cap in the first line as it appears
  4. The heading “Hardware” in the publication to have the styles.                                                       (5marks)
    • Font face: Arial Narrow
    • Font size: 16
    • Text weight: Bold
    • Character spacing: 180%
    • Alignment: Centered
  5. The text under the heading “Hardware” to be in two columns and having the following styles.                                                                                                                                                                  (3marks)
    • Font size: 12
    • Dashed outline on the first column
    • First character of the first column to be dropped by 4 lines as shown.
  6. Insert the banner bearing the text auxiliary as it appears.                                                    (3marks)
  7.  
    • Enter the text below the banner in three columns as shown                (4marks)
    • Insert lines between the three columns                  (3marks)
    • Type and format the text below the three columns exactly as it appears            (3marks)
  8. Print the publication.            

CompChoF42023PrMP2Q2     

 MARKING SCHEME

Q1. (50 marks)

 NO  CRITERIA 
 (i) Entering correct figures(4 marks)
Merge and centre heading (2 marks)
Wrap text heading (2 marks)
Align top and centre heading (2 marks)
 (ii)  Printable borders inserted (2 marks)
 (iii)  Sorting A-Z (2 marks)
 (iv)  Renaming sheet(1 mark)
 (v)

Correct formulas and figures each 2 marks total(12 marks)

  1. Basic pay
  2. Gross pay
  3. Tax deductions
  4. Nssf contributions
  5. Allowances
  6. Net pay
 (vi)

Copy + rename 2 marks)

  1. Column chart (3 marks)
  2. Title top (2 marks)
  3. Legend bottom (1 mark)
  4. Data labels(1 mark)
  5. Chart border;solid line,color red transparency 50% each 1 mark(3 marks)
 (vii)

Copy content (2 marks)
Subtotals (2 marks)
Grand totals (2 marks)
Freeze header(1 mark) 

 (viii)

Printing (each 1mark)

  1. Original worksheet
  2. Payroll worksheet
  3. Chart worksheet
  4. Subtotals worksheet

 

Question 2 (50 MKS)

  1.  
    • Correct software @ 2mks
    • Measurements to centimeters @ 2mks
    • Setting correct margins @ 2mks
    • Setting A4 portrait paper @ 2mks
    • All round borders as it appears @ 1mk
    • Dotted background @ 1mk
    • Inserting computer images in correct size and positions @2mks

      Typing
    • First paragraph “many people…” @ 1mk
    • Section “computer hardware…” column @ 1mk
    • Use of bullets @ 1mk
    • Typing second column @2mks
    • Use of underline and italics @ 1mk
    • Typing and rotating “floppy disk…” @ 2mks
  2. Saving with correct name @2mks
    With any other name @ 1mk
  3. Formatting heading and drop capping 1mk per style×5=5mks
  4. Heading “Hardware” formatting @ 1mk per format×5=5mks
  5. Text under “Hardware” formatting @ 1mk per format×3=3mks
  6. Correct banner 2mks
    Correct text formatting @ 1mk
  7.  
    • Entering the text 2mks
    • 3 columns 1mk
    • Drop cap 1mk
    • Inserting lines between @3mks
    • Typing the text below as it appears @3mks
  8. Printing @ 2mks
Join our whatsapp group for latest updates

Download Computer Studies Paper 2 Questions and Answers - Chogoria Murugi Zone Pre Mock Exams 2023.


Tap Here to Download for 50/-




Why download?

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


Get on WhatsApp Download as PDF
.
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?