Computer Studies Paper 2 Questions and Answers - KCSE 2022 Prediction

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. Candidates should answer the questions in English.


Questions

  1. The following table contains data extracted from an employees’ payroll file maintained by a certain company

    EMPNO

    NAME

    BASIC PAY

    DEPARTMENT

    AGE

    STATUS

    E100

    Marren

    16000.00

    Computer

    34

    Single

    E101

    Wezo

    17000.00

    Computer

    44

    Married

    E102

    Dave

    19000.00

    Finance

    33

    Divorced

    E103

    Charles

    21000.00

    Research

    33

    Single

    E104

    Davy

    23000.00

    Research

    25

    Single

    E105

    Thomas

    25000.00

    Computer

    26

    Married

    E106

    Ann

    27000.00

    Finance

    28

    Married

    E107

    Susan

    29000.00

    Finance

    29

    Divorced

    E108

    Tina

    31000.00

    Research

    24

    Divorced

    E109

    Andrew

    33000.00

    Computer

    40

    Single

    E110

    Hardy

    35000.00

    Finance

    20

    Married

    E111

    Selly

    37000.00

    Finance

    43

    Single

    E112

    Kimani

    10000.00

    Research

    15

    Single

    E113

    Chep

    15000.00

    Finance

    35

    Divorced

    E114

    Eddie

    35000.00

    Computer

    25

    Married

    E115

    Moses

    59000.00

    Research

    33

    Single

    E116

    Miriam

    70000.00

    Finance

    56

    Divorced

    E117

    Maurice

    32876.00

    Computer

    70

    Divorced

    E118

    Alphine

    43876.00

    Research

    65

    Divorced

    E119

    Cazy

    48098.00

    Research

    32

    Single

    E120

    Langat

    6500.00

    Computer

    12

    Single

    E121

    Phenny

    29000.00

    Finance

    70

    Single

    E122

    Hilda

    32000.00

    Computer

    13

    Married

    1.                       
      1. Create a database file and save as Company. (2 mks)
      2. Create a table named Workers containing the fields shown in the table above. (5 mks)
      3. Choose and set an appropriate field as a primary key. (2 mks)
    2.            
      1. Create a form named WorkersForm to be used to enter the data above in the Workerstable to appear as shown below. (7 mks)
        worker details ouihaiud
      2. Use the WorkersForm to enter the data above into the Workerstable. (5 mks)
    3. Create queries to determine:
      1. number of people with basic salary greater than 32,000/= .Save the query as Basic (3mks)
      2. number of people with basic salary less than 45,000/= and come from computer department. Save the query as Computer. (5 mks)
      3. those whose name begin with letter ‘M’ or end in letter ‘S’. Save the query as Names (3 mks)
    4.                  
      1. Create a query to determine those employees who will earn more than 50,000/= if there is an increment of basic pay by 10%. Save the query as SalaryIncrement. (4marks)
      2. Create a query to determine the year of birth of each employee from the current year. Save as YearOfBirth. (3 mks)
    5.                
      1. Create a report from Workerstable to display all the data in the table. Save as WorkersReport. (3 mks)
      2. Modify the WorkersReport in (e)(i) above as follows:
        1. Add the “EMPLOYEE SALARY DETAILS”as the report title. Use font size 19 pts, bold, underline and centre it across the columns containing data. (3 mks)
        2. Display the employees records according to their department and show the total amount the company spend on each department as salary and the total amount spend on paying all the employees. Save as WorkersReport_2. (6 mks)
    6. Print: (3 mks)
      1. Workers table;
      2. YearOfBirth query;
      3. WorkersReport_2.






  2. The following data was extracted from Applicants’ file of KERICHO COMPUTER COLLEGE.
    1.                                          
      1. Enter the data as it appears in a spreadsheet. (12mks)

         

        A

        B

        C

        D

        E

        F

        G

        H

        I

        1

        NAME

        ADDRESS

        TOWN

        ENG

        KISW

        MATH

        MEAN

        POSITION

        REMARK

        2

        Wanjiku N.

        400

        Nairobi

        40

        60

        60

             

        3

        Otieno D.

        3201

        Kisumu

        55

        50

        40

             

        4

        Nyambane T.

        5600

        Kisii

        70

        60

        50

             

        5

        Simiyu S.

        1236

        Bungoma

        30

        80

        70

             

        6

        Chebet K.

        48

        Eldoret

        75

        70

        80

             

        7

        Fatuma A

        6032

        Mombasa

        40

        30

        50

             

        8

        Kamau J.

        8021

        Nyeri

        50

        40

        55

             

        9

        Amoit C.

        2

        Busia

        80

        50

        70

             
      2. Insert two blank rows at the top of the worksheet. (2 mks)
      3. Enter the following title and subtitle in the blank rows respectively; KERICHO COMPUTER COLLEGE and APPLICANTS FILE. (2 mks)
      4. Centre the title and subtitle across the columns that contain data. (2 mks)
    2. Using functions, compute:
      1. the mean for each student and format it to 2 decimal place. (3 mks)
      2. the position of each student. (2 mks)
      3. the highest score for each subject. (2 mks)
    3. The college wishes to analyze the applicants’ data in order to find those applicants who qualify for admission to pursue a course in IT. Successful candidates MUST meet the following minimum requirements;
      1. Must have scored a mean of 40 marks and above;
      2. Must have scored 60 marks and above in Mathematics;
      3. Must have scored 50 marks and above in either English or Kiswahili.
        Enter an appropriate function in cell I4 and copy it to other cells to determine whether the student qualifies for admission. If the student qualifies, the function should display ‘Successful’. Otherwise it should display ‘Unsuccessful’. (12 mks)
      4. Create a function to find the number of applicants who are successful. (3 mks)
      5. Copy the entire worksheet to sheet 2 and rename it as Successful Applicants. (4 mks)
      6. Filter the ‘Successful Applicants’ sheet to display the records of those applicants who are successful. (4 mks)
      7. Print: (2 mks)
        1. Sheet1;
        2. Successful Applicants Sheet;


 



Marking Scheme

  1. The following table contains data extracted from an employees’ payroll file maintained by a certain company.
    1.                  
      1. Create a database file and save as Company. (Award 1 mk)
      2. Create a table named Workers containing the fields in the table.
        (½ mk x 6 fields, and ½ mk for saving as Workers) (Award Max 3 mks)
      3. Choose and set an appropriate field as a primary key. (Award ½ mk)
    2.                              
      1. Create a form named WorkersForm.
        • Form title (award 1½ mk)
        • Controls (award 3 mks)
        • Layout (award 2½ mks)
      2. Use the WorkersForm to enter the data above into the Workerstable. (Award 5 mks)
    3.  Create queries to determine:
      1. number of people with basic salary greater than 32,000/= .Save the query as Basic
        (Query 1 mk, correct criteria 1 mk and saving as Basic 1 mk) (Award Max 3 mks)
      2. number of people with basic salary less than 45,000/= and come from computer
        department. Save the query as Computer.
        (Query 1 mks, criteria for salary 1½ mks, criteria for department 11/2mks and saving as Computer 1mk) (Award Max 5 mks)
      3. those whose name begin with letter ‘M’ or end in letter ‘S’. Save the query as Names
        (Query ½ mk, criteria 2mks and saving as Names ½ mk.)(Award max 3 mks)
    4.                  
      1. Create a query to determine those employees who will earn more than 50,000/= if there is an increment of basic pay by 10%. Save the query as SalaryIncrement.
        (Query ½ mk, calculated field 2 mks, criteria 1 mk and saving as SalaryIncrement ½ mk) (Award Max 4 mks)
      2. Create a query to determine the year of birth of each employee from the current year. Save as YearOfBirth.
        (Query ½ mk, calculated field for year of birth 2 mks and saving as YearOfBirth ½ mk) (Award Max 3 mks)
    5.                    
      1. Create a report from Workerstable to display all the data in the table. Save as WorkersReport. (Award 3 mks)
      2. Modify the WorkersReport in (e)(i) above as follows:
        1. Add the “EMPLOYEE SALARY DETAILS”as the report title. Use font size 19 pts, bold, underline and centre it across the columns containing data.
          (Correct report title 1 mk, font size ½ mk, bold ½ mk, underline ½ mk and centre alignment ½ mk) (Award max 3 mks)
        2. Display the employees records according to their department and show the total amount the company spend on each department as salary and the total amount spend on paying all the employees. Save as WorkersReport_2.
          (Displaying employees records according to departments –2mks
          Departmental salary subtotal – 2 mks
          Grand total on salaries – 1 ½ mks
          Saving as WorkersReport_2 – ½ mk) (award Max 6 mks)

    6. Print:
      1. Workers table; (award 1 mk)
      2. YearOfBirth query; (award 1 mk)
      3.  WorkersReport_2. (award 1 mk)
  2.                
    1.                        
      1. Enter marks to the spreadsheet ( award 12mks)
      2. Insert two blank rows at the top of the worksheet.
        (Award 1x 2 = 2 mks)
      3. Enter the following title and subtitle in the blank rows respectively; KERICHO COMPUTER COLLEGE and APPLICANTS FILE. (Award 1 x 2=2 mks)
      4. Centre the title and subtitle across the columns that contain data.(award 1 x 2=2 mks)
    2. Using functions, compute:
      1. the mean for each student and format it to zero decimal place.(award 3 mks)
      2. the position of each student. (Award 2 mks)
      3. the highest score for each subject. (Award 2 mks)
        (Deny marks if the candidate used a formula instead of a function)
    3. The college wishes to analyze the applicants’ data in order to find those applicants who qualify for admission to pursue a course in IT. Successful candidates MUST meet the following minimum requirements;
      • Must have scored a mean of 45 marks and above;
      • Must have scored 60 marks and above in Mathematics;
      • Must have scored 50 marks and above in either English or Kiswahili.
        Enter an appropriate function in cell I4 and copy it to other cells to determine whether the student qualifies for admission. If the student qualifies, the function should display ‘Successful’. Otherwise it should display ‘Unsuccessful’. (Award 12 mks)
    4. Create a function to find the number of applicants who are successful. (award 3 mks)
    5. Copy the entire worksheet to sheet 2 and rename it as Successful Applicants.
      (Copying entire worksheet to sheet 2 – (award 3 mks)
      Renaming sheet 2 as Successful Applicants – (award 1 mk)
    6. Filter the ‘Successful Applicants’ sheet to display the records of those applicants who are successful. (award 4 mks)
    7. Print:
      1. Sheet1;
      2. Successful Applicants Sheet;
        (1 x 2=(award 2 mks)
Join our whatsapp group for latest updates

Download Computer Studies Paper 2 Questions and Answers - KCSE 2022 Prediction.


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?

Join our community on:

  • easyelimu app
  • Telegram
  • facebook page
  • twitter page
  • Pinterest