Computer Studies Paper 2 Questions and Answers - KCSE 2022 Kapsabet Highschool Trial 1 Pre-Mock Examination

Share via Whatsapp

INSTRUCTIONS TO CANDIDATES

  1. Type your name and index number at the top right hand corner of each print out
  2. Write your name and index number on the diskette/CD-R provided
  3. Write the name and version of software used in each question on the answer sheet
  4. Answer ALL the questions
  5. Passwords should not be used while saving in the diskette/CD-R
  6. All answers MUST be saved in the diskette/CD-R
  7. Make print out of answers on the answer sheet provided


QUESTIONS

QUESTION ONE

  1.                      
    1. Assume you are the Director AMACO INSURANCE COMPANY LTD you want to update your customers on the current dues as per the insurance cover each client have. Use mail merge to write an official letter to FIVE CUSTOMERS informing them of this. Your letter must meet the following conditions.
      1. Must have the header at the top with the company's name as the letter head (2mks)
      2. Must have footer at the bottom indicating the current date and time, left aligned. (2mks)
      3. The insurance will cover the vehicles and each client due, car number will not be the same. (2mks)
      4. The address lines will include Title
        First name
        Last name
        Address
        Country
        Car no plate
        Amount due (14mks)
    2.                                
      1. Prepare the table below in Ms word and then apply formatting as follows and save as MSS (8 mks)

        MEYSA SYSTEMS AND SERVICES

        Technical information

        Action taken

        Machine description

        Problems found

        Diagnostic checks

        Solutions

        Compaq / evo

        hardware

        software

        Memory video

        1

        Replacing vga

        6522

           

        Faulty component VGA CARD

        2

        Installing drivers

        Desktop

        No display

        VGA CARD

        3

        Rebooting system

      2. Format the table with border line colour red and choose double line (5mks)
      3. Shade the table to tight green colour for the first two rows and light blue shading for therest of the table (5mks)
    3. Type the paragraph below, save it as computer and apply formatting as stated (4mks)
      Computer Program is a set of instructions that direct a computer to perform some processing function or combination of functions. For the instructions to be carried out a computer must execute a program, that is, the computer reads the program, and then follows the steps encoded in the program in a precise order until completion. A program can be executed many different times, with each execution yielding a potentially different result depending upon the options and data that the user gives the computer.
      1. The text "computer program" should be the title, change its case to upper case font TREBUCHET MS size 16, colour green (2mks)
      2. Find the word 'instructions' look for its meaning in the computer dictionary and finally replacethe word with new meaning from the dictionary (3mks)
      3. Format the whole paragraph to justified alignment shading colour light green (3mks)
  2.                                
    1.  

      NAME

      BASIC PAY

      DEPARTMENT

      AGE

      STATUS

      Peter

      15000

      Computer

      34

      Single

      John

      17000

      Computer

      44

      Married

      Kamau

      19000

      Finance

      33

      Divorced

      Charles

      21000

      Research

      33

      Single

      Johns

      23000

      Research

      25

      Single

      Thomas

      25000

      Computer

      26

      Married

      Ann

      27000

      Finance

      28

      Married

      Susan

      29000

      Finance

      29

      Divorced

      Tina

      31000

      Research

      24

      Divorced

      Andrew

      33000

      Computer

      40

      Single

      Hardy

      35000

      Finance

      20

      Married

      Njeri

      37000

      Finance

      43

      Single

      Kimani

      10000

      Research

      15

      Single

      Silamtoi

      15000

      Finance

      35

      Divorced

      Tina

      35000

      Computer

      25

      Married

      Moses

      59000

      Research

      33

      Single

      Miriam

      70000

      Finance

      56

      Divorced

      Maurice

      32876

      Computer

      70

      Divorced

      Alphie

      43876

      Research

      98

      Divorced

      Albert

      48098

      Research.

      32

      Single

      Langat

      6500

      Computer

      12

      Single

      Phenny

      29000

      Finance

      70

      Single

      Hilda

      32000

      Computer

      13

      Married

      Create data base called personnel and create a table named department (5 mks)
    2. Create queries to determine (save each query using the alphabet numbers below)
      1. Number of people with basic salary greater than 32,000= (5 mks)
      2. Number of people with basic salary less than 45,000= AND come from computerdepartment(5mks)
      3. Names of people who are either married or single. (4 mks)
      4. Those whose salary fall between 25,000/= and 50,000= (3mks)
      5. Those whose name begin with letter M or end in letter S (3 mks)
    3.                              
      1. Create a query to compute the new salary if there is an increment of basic pay by 50% (7mks)
      2. Filter using query those who earn above 33000/= and aged between 39 and 70 (5 mks)
    4.                        
      1. Create a form using form wizard using the Departmental table above. (3mks)
      2. Create a form in design view using the departmental table above on the form calculate the total basic salary for the whole table, add current date and time on the form header (5 mks)
      3. Create a report for THE ABOVE table using design view and print. (5mks)


MARKING SCHEME

  1.                                
    1.                          
      1. Header
        • Company's name as letter head 
        • Company's name  (1mk)
        • As letter head (1mk)
      2. Footer
        • Current date & time   (1 mk)
        • Left aligned    (1mk)
      3. Insurance will cover (explanation of)
        • vehicles and each client dire   (1mk) 
        • car number will not be the same
      4. Address line
        • litre (2mks)
        • First name  (2mks)
        • last name   (2mks)
        • Address (2mks)
        • country (2mks)
        • car no. plate    (2mks)
        • Amount          (2mks)
          Total=2x7=14mks) 
  2.                                
    1.                          
      • √database name (personnel)      (1mk)
      • √Table name (department) (1mk)
      • √ correct entry    (3mks)
    2.                                  
      1. Criteria > 32000/= (4mks).Saving (1mk)
      2. Criteria < 4500/= Am compare from computer department (4mks) saving   (1mk)
      3. Criteria: Married or single (3mks), saving (1mk)
      4. Criteria: Between 25000 and 50000 (2mks), saving (1mk)
      5. Criteria: name beginning with M or end with S (2mks). Saving (1mk)
    3.                                                      
      1. √ creating a new column called new salary(2mks)
        √Formula New salary: [Basic PAY] * + (BASIC PAY]    (4mks) saving (1mk) 
      2. Criteria: earning > 33000/= and eged between 39 and 70 (4mks), saving (1mk)
    4.                          
      1.                              
          1. Creation of a form using form wizard        (3mks)
          2. Creation of form in design view (2mks) calculating the total basic salary (2mks), adding current date and time on the form header (½mk), a\saving (½mk)
      2.                          
        1. Preparation of the table; √ merging of cell        (3 mks)
            • √ text formatting (2mks)
            • √ correct entry  (2mks)
            • √ saving as MSS (1mk)
        2. Format table √border line colour red (2mks)
          √double line      (3mks)
        3. Shading; √first two rows light green colour  (2 ½ mks)
          √Rest of the table light blue (2½ mks)
      3. √saving as computer (1mk) √ complete typing (3mks) 
        1. Formatting √title as computer program     (1/2mk)
          √change case to upper case
          √font style TREBUCHET MS & Size 16(1/2mk)
          √Font colour (1/2mk)
        2. Find and replace √finding instruction      (1mk)
          √replacing instruction with its synonym (2mks)
        3. √ justify paragraph         (2mks)
          √shading colour (light green) (1mk)

Download Computer Studies Paper 2 Questions and Answers - KCSE 2022 Kapsabet Highschool Trial 1 Pre-Mock Examination.


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?

Join our community on:

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