Computer Studies Paper 2 Questions and Answers - KCSE Prediction Papers 2022

Share via Whatsapp

Instructions to Candidates

  1. Type your name and index number at the top right hand corner of each printout.
  2. Sign and write the date of the examination below the name and index number on each printout.
  3. Write your name and index number on the compact disks.
  4. Write the name and version of the software used for each question attempted in the answer sheet.
  5. Passwords should not be used while saving in the compact disks.
  6. Answer all the questions.
  7. All questions carry equal marks.
  8. All answers must be saved in your compact disks.
  9. Make a printout of the answers on the answer sheets provided.
  10. Hand in all the printouts and the compact disks.
  11. This paper consists of 4 printed pages.
  12. Candidates should check the question paper to ascertain that all pages are printed as indicated and that no questions are missing.


Questions

  1.                                            
    1. Create a folder and name it using the last three digits of your index number. Type the document below exactly as it appears using a word processing package and save it as MOCKING_BIRD in the folder created. (8mks)
      TO KILL A MOCKINGBIRD
                   To Kill a Mockingbird is primarily a novel about growing up under extraordinary circumstances in the 1930s in the Soutern United States. In To Kill a Mockingbird, author Harper Lee uses memorable characters to explore civil rights and racism in the segregated Southern United States of the 1930s.
                   Told through the eyes of Scout Finch, you learn about her father Atticus Finch, an attorney who hopelessly strives to prove the innocence of a black man unjustly accused of rape; and about Boo Radley, a mysterious neighbor who saves Scout and her brother Jem from being killed.
      The Three Most Important Aspects Of To Kill A Mockingbird:
                   The title of To Kill a Mockingbird refers to the local belief, introduced early in the novel and referred to again later, that it is a sin to kill a mockingbird. Harper Lee implies that it’s unjust and immoral.
                   The events of To Kill a Mockingbird take place while Scout Finch, the novel’s narrator, is a young child. But the sophisticated vocabulary and sentence structure of the story indicate that Scout tells the story many years after the events described, when she has grown to adulthood.
                   To Kill a Mockingbird is unusual because it is both an examination of racism and a bildungsroman. Lee examines a very serious social problem. Lee seamlessly blends these two very different kinds of stories.
      to kill a mockingbiord khagda
    2. Save a copy of the document created above as “MOCKING_BIRD 2” in the folder created in (a) above and use to answer parts (c) to (e). (1mrk)
    3.                            
      1. Insert a drop cap to the first letter of the first paragraph, dropping it by two lines. (2mks)
      2. Apply bullets to the paragraphs under the second heading. (3mks)
      3. Change the first paragraph under the first heading to three columns. (3mks)
      4. Format the heading “TO KILL A MOCKINGBIRD” as follows: (4mks)
        • Alignment: Right
        • Font type: Arial black
        • Font size: 18
        • Font style: Underline
      5. Proofread the document to correct spelling mistakes (1mrk)
      6. Set the page to A4 size, with the following margin specifications: (3mks)
        • Top: 0.63”
        • Bottom: 0.6”
        • Left: 0.6”
        • Right: 0.63”
      7. Set the line spacing of the last two paragraphs starting with “To Kill a Mockingbird is unusual...” to 2.0. (2mks)
      8. Insert a header bearing your name and admission number. (2mks)
      9. Move the 1st paragraph under the second heading to come below the drawing. (2mks)
      10. Set a hanging indent to the 2nd paragraph which starts with “To Kill a Mockingbird is unusual…” (2mks)
      11. Replace all words written “racism” with “racial discrimination” (2mks)
      12. Set the 1st paragraph which starts with “To Kill a Mockingbird is primarily a…” so as the text is aligned to the right. (1mk)
    4.                              
    5. Automatically paginate the document using the format “page x of y” (1mk)
    6. Apply a page border to the whole document with the following formats: (3mks)
      • Style: Double line
      • Border color: Blue
      • Border width: 2¼pt
    7.                        
      1. Create a table at the end of the document created in (b) above and enter the following data (3mks)
        BOOK _NO BOOK_TITTLE AUTHOR PRICE
        B0-02 In Cold Blood Truman capote 875.00
        B0-09 Roman Holiday Gregory Peck 955.00
        B0-03 The catcher in the Rye J. D. Salinger 650.00
      2. Insert the title “RELATED BOOK NOVELS” as the first row of the table. Align the title to the center (2mks)
      3. Apply borders to the whole table (1mk)
      4. Using a formula, calculate the average cost of books in the table. (2mks)
    8. Print the documents; MOCKING_BIRD and MOCKING_BIRD 2 (2mks)
  2. The tables below, STUDENT, SUPERVISOR and SUPERVISIONS are extracts of records kept in a certain university for project supervisions.

    Student Number

    Name

    Gender

    Project  Fee Paid

    C001

    Ken

    M

    32000

    C002

    Joy

    F

    27800

    C003

    Lero

    M

    18900

    C004

    Moth

    F

    42700

    C005

    Ben

    M

    45000

    Table 1 STUDENTS TABLE

    Supervisor Number

    Name

    Department

    L220

    Alex

    Mechanical

    L230

    Sakaja

    ICT

    L240

    Roy

    Electronics

    L250

    Mati

    Education

    L260

    Joy

    Human Resource

    Table 2 SUPERVISOR S’ TABLE

    Supervision Number

    Supervision Date

    Student Number

    Supervisor Number

    Project

    Title

    100

    12/03/2015

    C001

    L220

    Java

    200

    22/03/2015

    C003

    L230

    Website

    300

    17/03/2015

    C004

    L240

    Robotics

    400

    02/03/2015

    C001

    L220

    Java

    500

    18/03/2015

    C002

    L240

    Robotics

    600

    12/03/2015

    C004

    L230

    Java

    700

    11/03/2015

    C002

    L250

    Database

    800

    12/03/2015

    C003

    L220

    Java

    900

    12/04/2015

    C005

    L250

    Database

    1100

    12/04/2015

    C002

    L250

    Database

    Table 3 SUPERVISIONS TABLE
    1. Using a database application software, create a database file named PROJECT (1mk)
    2. Create three tables named STUDENT, SUPERVISOR and SUPERVISIONS as shown above. (9mks)
    3. Set the primary key for each table. (3mks)
    4. Create relationships among the tables. (2mks)
    5. Enter the data in the table STUDENT, SUPERVISOR and SUPERVISIONS as shown above. (9mks)
    6. Create a form for each table above. (3mks)
    7. Create a query named BALANCE to display student name, Gender, project fee balance per student, given that the total project fee is Ksh.50000. (4mks)
    8. Create a query named BALANCE2 to display students’ Names, project title whose fee balance is above Ksh.20000.(4mks)
    9. Create a bar chart based on question (h) to display students Name and balance. Save as BALANCE CHART. (3mks)
    10. Create a report named SUPERVISION to display Students Names, Project Title, names of supervisor, and supervision Dates. The records in the report should be grouped by students’ Name and the number of supervisions by each student should be displayed. (5mks)
    11. Title the report as supervision per lecturer. (2mks)
    12. Print the following:
      • Tables: STUDENT, SUPERVISOR and SUPERVISIONS (2mks)
      • Queries: BALANCE and BALANCE2 (2mks)
      • REPORT: SUPERVISIONS (1mk)


 



Marking Scheme

QN

SEC

ACTIVITY

MAX MARK

 

1

a

Creating folder and assigning the last three digits of an index number.½mk
Correct filename “MOCKING_BIRD”                          ½mk

8mks

 

 

 

Fully typed text

  • The two headings @ ½mk
  • 5 paragraphs @ ½mk

 

Drawing using auto shapes

  • Each correct autoshape type@½ mk x 3shapes
  • Shadow effect on flowchart document symbol  - ½mk
  • Text inside autoshape @½mk
  • Word art accompanying diagram -  1mk

b

Creating a copy and renaming it to “MOCKING_BIRD 2”

1mk

 

c

 

(i)Drop cap

  • Inserting  - 1mk
  • Dropping by two lines – 1mk

2mks

 

(ii) Bulleting - 3 bullets @1mk

3mks

 

(iii) Converting the first paragraph three columns @1mk

3mks

 

(iv) FORMATTING the heading “TO KILL A MOCKINBIRD”

  • Right alignment - 1mk
  • Arial black, - 1mk
  • font size 18, - 1mk
  • Underlined - 1mk

4mks

 

(v)Proofreading

  • Check if the misspelled word “rasism” is changed to “racism” – 1mk

1mk

 

(vi) PAPER SIZE & MARGIN SPECIFICATIONS

3mks

 
  • Correct paper size A4- 1mk
  • Margins (Top, Bottom, Right, Left) @½mk x 4

(vii) LINE SPECIFICATION

  • The last two paragraphs @1mk

2mks

 

(viii) HEADER

  • Inserting admission number and name @1mk

2mk

 

(ix) MOVING 1st paragraph below drawing

  • Moving & correct placement – 1mk

2mks

 

(x) HANGING INDENT

  • To the paragraph which starts with “To Kill a Mockingbird is unusual…”     

2mks

 

(xi) FIND & REPLACE - “racism” with “racial discrimination”

2mks

 

(xii) RIGHT ALIGNMENT

  • 1st paragraph which starts with “To Kill a Mockingbird is unusual…” aligned to right - ½mk

1mk

 

e

PAGINATION

  • Inserting with correct format “page x of y” - 1mk
  • Inserting page without format - 1mk

2mks

 

f

PAGE BORDER – WHOLE DOCUMENT

  • Double line border style -1mk, incorrect style award - ½mk
  • Blue border color –1mk
  • Border width 2¼pt – 1mk

3mks

 

 

SEC

ACTIVITY

MAX MARK

MARKS AWARDED

Q 2

(a)

Creating database named PROJECT

1mk

1

 
 

(b)

STUDENTS TABLE

  • Creating and naming the table
  • Creating and naming fields
  • Correct field data types

1mk

1mk

1mk

3

 
   

SUPERVISORS TABLE

  • Creating and naming the table (SUPERVISORS TABLE)
  • Creating and naming fields
  • Correct field data types

1mk

1mk

1mk

3

 
   

SUPERVISION TABLE

  • Creating and naming the table (SUPERVISION TABLE)
  • Creating and naming fields
  • Correct field data types

1mk

1mk

1mk

3

 
 

(c)

Primary keys

  • STUDENTS TABLE
  • SUPERVISORS TABLE
  • SUPERVISION TABLE

1mk

1mk

1mk

3

 
 

(d)

Two relationships(correct fields)

2mks

2

 
 

(e)

Entering data in the three tables

  • STUDENTS TABLE
  • SUPERVISORS TABLE
  • SUPERVISION TABLE

3mks

3mks

3mks

9

 
 

(f)

Creating  forms  (Forms with all fields)

  • STUDENTS
  • SUPERVISORS
  • SUPERVISION

1mk

1mk

1mk

3

 
 

(g)

  • Creating query name Balance
  • Display students details (Name, gender, fee balance)
  • Computation  balances for each  student

1mk

1mks

2mks

4

 
 

(h)

  • Creating query name Balance2
  • Display students details  - Name, project title and fee balance above 20 000

1mk

3mks

4

 
 

(i)

Creating a chart

  • Title
  • Axes
  • bars

1mk

1mk

1mk

3

 
 

(j)

Creating a report SUPERVISION

  • Selection of fields to display students’ names, project title, names of supervisors and supervision dates

1mk

4mks

5

 
 

(k)

Report title as “SUPERVISION PER LECTURER”

2mks

2

 
 

(l)

Printing :

  • Tables : STUDENTS TABLE, SUPERVISORS TABLE, SUPERVISION TABLE
  • Query: BALANCE and BALANCE2
  • Report: SUPERVISION

2mks

2mks

1mk

5

 
   

TOTAL

50mks

 


Download Computer Studies Paper 2 Questions and Answers - KCSE Prediction Papers 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?

Join our community on:

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