Computer Studies Paper 2 Questions and Answers - KCSE 2022 Mock Exams Set 1

Share via Whatsapp

INSTRUCTIONS TO CANDIDATES

  1. Indicate your name and index number at the right hand corner of each 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 in the answer sheet provided
  4. Answer all the questions, All questions carry equal marks
  5. Passwords should not be used while saving in the CD/removable storage Medium
  6. Marked printout of the answers on the sheet
  7. Hand in all the printouts and the CD/removable storage medium used

QUESTIONS

  1. The table below shows list of students admitted to Nyambaria High School under different sponsors.
    1. Open a database program and create a database named NHS.(1mark)
    2. Create three tables named Students, Sponsor and Fees. (3marks)
    3. Using database file created in (a) above use the following field properties. (6marks)
      Student_Table

      Field name

      Data types and properties

      School-Code

      Default value = 427

      AdmNo

      Text (Size = 4, Required = Yes )

      Student Name

      Text  (Size = 16)

      Date of Birth

      Date and time (Size = 10)

      Amount paid

      Text (Size = 4, Required = Yes )

      SponsorID

      LookUp -sponsor table

      BankID

      Text

      Sponsor_Table

      Field name

      Data types and properties

      SponsorID

      Text (Size = 4, Required = Yes )

      Sponsor Name

      Text  (Size = 16)

      Amount_Table

      Field name

      Data types and properties

      BankID

      Text

      BankName

      Text (Size = 10)

      Amount Per Student

      Number (Size = 8, Decimal Place = 2)

      Mode of payment

      Text (Size = 12)

      1. Create the relationship between the tables. (2marks)
      2. Enforce referential integrity between the tables. (1mark)
      3. Create the three forms StudentForm, SponsorForm and AmountForm. (3marks)
      4. Enter the following data in their respective tables using the respective forms. (8 marks)
        Table 1: SponsorTable

        SponsorID

        Sponsor Name

        S1

        Wings

        S2

        Majani

        S3

        Elimu

        Table 2: StudentTable

        Sch-Code

        AdmNo

        SponsorID

        StudName

        BankID

        DateOfBirth

        427

        444

        S1

        Lilian Mwende

        100

        12/03/2000

        427

        443

        S3

        Ruth Akinyi

        200

        23/01/1998

        427

        445

        S2

        Frida Omondi

        100

        11/07/2002

        427

        442

        S1

        Bianca Godana

        300

        12/05/2005

        427

        410

        S3

        Christine  Awuor  

        300

        28/05/1999

        427

        413

        S2

        Baraka kalala

        200

        30/09/1998

        427

        449

        S1

        Rael  Mokaya

        100

        18/02/2005

        427

        411

        S3

        Slivia  Odanga

        100

        17/04/2001

        427

        412

        S2

        Jane  Kawaswa

        200

        19/06/2004

        427

        415

        S2

        Jack Jake

        100

        22/03/2003

        Table 3: AmountTable

        BankID

        BankName

        Amount Per Student

        Mode of payment

        100

        COOP

        550,000

        EFT

        200

        KCB

        120,000

        M-banking

        300

        EQUITY

        420,000

        Cheque

    4. Create a query to display the fields:
      1. AdmNo, Sponsor name, age and Students whose first name start with letter “B” and whose payment Bank is “COOP” Save query as B-query. (5marks)
      2. StdName, Sponsor name, Mode of payment and Amount per student. Calculate the total amount received. Save query as AMount-query. (5marks)
      3. Create Amountreport from Amount query display all the records grouped by mode of payment and find the average per mode of payment (4 marks)
    5. Create a bar chart to display students and their respective amount received. Save chart as S-chart. (2 marks)
    6. Create S-report to display the fields as it appears in the figure below. (5marks)
      e adadad
    7. Print the following: (4 marks)
    8. The Student table
    9. The B- query
    10. The chart
    11. The S-report
  2. The following data was extracted from Applicants’ file for Maranda high school comp/Maths teacher recruitment
    1.                            
      1. Enter the data as it appears in a spreadsheet. And save it as INTERVIEW (13mks)

         

        A

        B

        C

        D

        E

        F

        G

        H

        I

        1

        NAME

        ADDRESS

        TOWN

        comp

        Math

        Eng

        MEAN

        APPLICANT’S POSITION

        REMARK

        2

        Willington

        400

        Nairobi

        40

        60

        60

             

        3

        Benjamin

        3201

        Kisumu

        55

        50

        40

             

        4

        Nyambane T.

        5600

        Kisii

        70

        60

        50

             

        5

        Grace

        1236

        Bungoma

        30

        80

        70

             

        6

        Rebbeca

        48

        Eldoret

        75

        70

        80

             

        7

        Fatuma A

        6032

        Mombasa

        40

        30

        50

             

        8

        Kamau J.

        8021

        Nyeri

        50

        40

        55

             

        9

        Achieng .

        209

        Siaya

        80

        50

        70

             
      2. Insert two blank rows at the top of the worksheet. (1 mark)
      3. Enter the following title and subtitle in the blank rows respectively; MARANDA HIGH SCHOOL RECUIRTMENT FILE and APPLICANTS DETAILS. (3marks)
      4. Centre the title and subtitle across the columns that contain data. (2marks)
    2. Using functions, compute:
      1. The mean for each Applicant and format it to 2 decimal places. (3marks)
      2. The position of each Applicant. (3marks)
      3. The highest and lowest score for Benjamin, enter the answers in L3 and M3 respectively (3marks)
    3. The school wishes to analyze the applicants’ data in order to find those applicants who qualify for recruitment. 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 Computer;
      3. Must have scored 50 marks and above in either Mathematics or English.
        Use the above criteria to remark If the applicants qualifies, the function should display ‘Successful’. Otherwise it should display ‘Unsuccessful’. (5marks)
    4. Using a function find the number of applicants who are successful. (2marks)
    5. Copy the entire worksheet to sheet 2 and rename it as Successful Applicants. (2marks)
    6. Filter the ‘Successful Applicants’ sheet to display the records of those applicants who are successful. (2marks)
    7. In a new worksheet Create a bar chart to compare the performance of mathematics and computer for all applicants (4marks)
      1. Insert SUBJECT PERFORMANCE as the heading of the chart (2 mark)
      2. Assign the appropriate LEGENDS to the chart (1 mars)
      3. Name the axis appropriately (2 marks)
    8. Print: (2 marks)
      1. INTERVIEW;
      2. Successful Applicants Sheet;

MARKING SCHEME

QUESTION 1

QUESTION 2

Item

Description

Max Score

Score

Item

Description

Max Score

Score

a

File Name

0.5

 

a

Workbook file

0.5

 
 

Correct Case

0.5

   

File case

0.5

 

b

3 tables correct name case

1.5

   

Colum titles

2

 
 

Name case

1.5

   

Name case

1

 

c

Field properties @1/2

6

   

Town Case

1

 

i

2links

2

   

Borders

2

 

ii

ERI @1/2

1

   

Entries

6

 

iii

3 Forms

1.5

 

ii

2blank rows

1

 
 

Correct Case

1.5

 

iii

Titles

2

 

iv

Each record @1/2

8

   

Correct Case

1

 

d i

B Query

1

 

iv

Center Each

2

 
 

age

1

 

b i

Mean

2

 
 

Criteria B

1

   

2decimal plcs

1

 
 

COOP

1

 

ii

Rank

3

 
 

Fields @ 1/2

1

   

Max score Benjamin

1

 

ii

Amount Query

1

   

Min score Benjamin

1

 
 

Total

1

   

Correct Cells

1

 
 

4 fields @1/2

2

 

c

If function

5

 

iii

Amount Report

1

 

d

Count if function

2

 
 

Grouping

1

 

e

Copy

1

 
 

Average

1

   

Rename

1

 
 

Fields

1

 

f

Filter

1

 

e

s chart

1

   

Correct

1

 
 

correct

1

 

g

Bar chart

1

 

f

s Report

1

   

correct data

2

 
 

Title

0.5

   

own sheet

1

 
 

Bold

0.5

 

i

chart title

1

 
 

Underline

0.5

   

Uppercase

0.5

 
 

Case

0.5

   

Bold

0.5

 
 

Fields

3

 

ii

Legend

1

 
 

Frame

1

 

iii

Axis label

2

 

g

Printing

4

 

h

print

2

 
               
   

50

     

50

 
Join our whatsapp group for latest updates

Download Computer Studies Paper 2 Questions and Answers - KCSE 2022 Mock Exams Set 1.


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?