COMPUTER STUDIES PAPER 2 - 2020 KCSE PREDICTION SET 1 (QUESTIONS AND ANSWERS)

Share via Whatsapp

INSTRUCTIONS TO CANDIDATES

  • Write your name and index number on the CD/Removable storage media provided
  • Write the name and version of software used for each question
  • Answer all questions
  • All questions carry equal marks
  • Passwords should not be used while saving in the CD/Removable storage medium
  • All answers must be saved in the CD/Removable storage medium
  • Make printout of the answers on the answer sheet
  • Arrange your printout and ties/staple them together
  • Hand in all printouts and the CD/Removable storage medium used
  • Candidates should answer the questions in English
  • ALL Data for currency data type should be formatted to Kenya Shillings
  • All the system Date and Time should be set to correct Kenya time and Date settings
  1. A school keeps its students details in a computer database. The information below contains details obtained from two tables of database. Study the tables and answer the following questions.
    DETAILS

    NAMES

    KCPE MARKS

    ADMNO

    Year Of KCPE

    DORMITORY

    Tom Jose

    250

    2030

    2011

    Ruvuma

    Okoth Rao

    356

    2031

    2012

    Zaire

    Ken Otieno

    412

    2032

    2012

    Tana

    Dan Muoso

    205

    2033

    2011

    Ruvuma

    Adan Hassan

    400

    2034

    2010

    Zaire

    Ahmed Kubasu

    185

    2035

    2011

    Tana

    Mutai Jemo

    289

    2036

    2012

    Ruvuma

    Mutua Sarafi

    300

    2037

    2012

    Zaire

    Muesh Linda

    426

    2038

    2011

    Tana

    Viena Oscar

    405

    2039

    2010

    Zaire

    Violet Kadija

    336

    2040

    2012

    Tana





    PERFORMANCE

    ADMNO

    ENGLISH

    MATHS

    KISWAHILI

    COMPUTER

    2030

    59

    48

    56

    83

    2031

    56

    36

    48

    76

    2032

    29

    25

    59

    80

    2033

    88

    79

    65

    67

    2034

    70

    29

    62

    91

    2035

    39

    46

    24

    68

    2036

    82

    78

    18

    84

    2037

    54

    75

    19

    46

    2038

    69

    54

    46

    87

    2039

    53

    96

    75

    24

    2040

    74

    20

    49

    50

    Create a new database called STUDENTS. (2marks)
    1. Design two tables: DETAILS and PERFORMANCE with the following properties in their fields:
      Validate the ADMNO entry to exactly four characters, three characters for KCPE MARKS and DORMITORY names each to start with capital letter.      (4marks)
    2. Using appropriate primary and foreign keys create a relationship between the two tables and enforce referential integrity. (4 marks)
    3. Create and use forms to enter data into tables. (12 marks)
    4. Create a query that would extract students whose name starts with letter “A” and save it as “Names”               (4marks)
    5. Create a query that would display ADMNO, NAME, ENGLISH, MATHS,KISWAHILI and COMPUTER and calculate the totals of the four subjects, sort the totals in descending order. Save it as “MARKS”                                                                                                                               (4marks)
    6. Create a query that would display only those students who sat their KCPE in 2012 and reside in Tana dormitory, save the query as “Tanas”                         (3marks)
    7. Using the performance table, compute the average for ENGLISH field, standard deviation for MATHS field and Variance for KISWAHILI field to be displayed on the same table. (3marks)
    8. Create a form to display all fields of details table with the following:                                        (7marks)
      • Layout:-tabular
      • Style:-opulent
      • Title:-Dform
      • Add two form controls to “print” and “close” the form.
    9. Create a report with the title “Excellent” using the query “MARKS” above.             (2marks)
    10. Print: Dform in portrait while the query “MARKS” in landscape             (2marks)
      • Performance table             (2marks)
      • Report excellent             (1mark)
  2. 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.             (2marks)


publication comp p2



MARKING SCHEME

QUESTION ONE

  1. Creating database named students 2mks
    With any other name                                 1mk
  2. Primary key validation                         @ 1mk
    KCPE validation                                  @ 1mk
    Dormitory names validation                @ 2mks
  3. Appropriate primary keys-ADMNO    @ 1mk per table= 2mks
    Correct creation of relationship ADM NO - ADM NO            @ 1mk
    Enforcing referential integrity              @ 1mk
  4. Creating forms                                     @ 2mks=4mks
    Complete entry of data @ 4mks per table×2=8mks
  5. - Query creation                                     1mk
    Criteria                                                 @ 2mks
    Correct name                                       @ 1mk
  6. Entry of all required fields                   @ 1mk
    Total calculations                                 @ 1mk
    Sorting                                                             @ 1mk
    Correct naming                                                @ 1mk
  7. Criteria @ 1mk×2=2mks
    Correct query name                                               @ 1mk
  8. Average                                               @ 1mk
    Standard deviation                               @ 1mk
    Variance                                              @ 1mk
  9. Creating form
    Layout                                                       @ 1mk
    Styles                                                         @ 1mk
    Title                                                           @ 1mk
    Print control                                               @ 1mk
    Close control                                             @ 2mks
  10. Report tittle                                                            @ 1mk
    Appropriate query                                     @ 1mk
  11. Printing
    Dform in portrate                                 @ 1mk
    Marks querye in landscape                  @ 1mk
    Performance table
    Use correct orientation                         @ 2mks
    Report                                                  @ 1mk

QUESTION TWO

  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

  1. 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 - 2020 KCSE PREDICTION SET 1 (QUESTIONS AND ANSWERS).


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