KCSE Past Papers 2018 Computer Studies Paper 2 (451/2)

  • 2018 Computer Studies – Paper1

    1 (a)(i) Creating the database file @ 1 ½

    (ii) Creating of tables (at least 3) @1 ½

    Student table

    ✔ 4 Fields each @ ½ =2

    Patron table

    ✔ 2 Fields each @ ½ =1

    Dormitory table

    ✔ 3 Fields each @ ½ =1½

    Games table

    ✔ 2 Fields each @ ½ =1

    (iii) Relationship at least 3 each @ 1 =

    (b) (i) 4 forms for each table each @½ =2 = 2

    (ii) Entering data into the tables

    Student table

    ✔ 8 records each @ ½ =4

    Patron table

    ✔ 3 records each @ ½ = 1½

    Dormitory table

    ✔ 3 records each @½ = 1½

    Games table

    ✔ 4 records each @ ½ =2

    (c) (i) Creating the orangeq query

     

  • Invoking the use of query@ 1
  • selecting the fields @ 1 
  • Criteria applied to the fields @ 2✔ Saving the query @ 1

    (ii) Creating the j query query

     

  • Invoking the use of query@ 1 
  • Criteria (letter j) @✔ 1 Saving the query @ 1

    (d) (i) Creating the report

     

  • Using the report feature @ 1 
  • selecting the report fields @ 1 
  • selecting the 4 fields each @ 1=4
  • Grouping @ 1 
  • Saving the query @ 1(ii) I. Replacing the report title @l

    ✔ H. Entering name and index as report footer

    ✔Name and index @ l

    ✔Position the items in the footer @ 1

    HI. Bolding the text

    ✔Selecting the text @ 1

    ✔ applying bold format @l

    (e) Printing

    (i) 4 Tables each @ 1

    (ii) 2 queris each @ 1 =2

    (iii) The report @ 1

    2 (a) (i) Typing the story

     

  • Title @½
  • Centering the title @½
  • First paragraph @ 2
  • Paragraph under advantages @ 2
  • Paragraph under disadvantages @ 2
  • Last paragraph @ 2
  • Bullets used in the advantages @ ½
  • Bullets used in the disadvantages @ ‘½
  • Saving @ 1(ii) I Formatting the title,p>
  • Font size 18 @l
  • Font colored @l
  • Font typemahoma @lH Double underline

     

  • Selection of text under advantages @l
  • Applying double space @lIH Drop cap

     

  • Selection the first letter @l
  • Using drop cap feature @l
  • Dropping through 4 lines @ 1IV Two columns

     

  • Selection of text @l
  • Using the column feature @l
  • Applying a line between the columns @ 1
  • Advantages to the left @ /z 4
  • Formats applied on subtitles
  • Bold@1
  • Italics @l
  • Underline @ 1(iii) I Water marks

     

  • Using the watermark feature @ 1
  • Typing the text social media in the watermark field @l
  • Font size=20 @l
  • Direction (Diagonal left to right) @lH Page numbering

     

  • Using page numbering feature @½
  • Inserting page numbers @ 1
  • Centering the pages horizontally @/ 2III Header

     

  • Using the header field @ /
  • Typing the text in the header field @ 1
  • Alignment at the right @½
  • Applying italics @ 1(b)(i) Main document

     

  • Typing text @l
  • Applying formats ½
  • Saving the document @ 1(ii) Main document

     

  • Creation of datasource @3
  • Saving the datasource @l
  • Using the mail merge feature @½ 
  • Inserting the 2 fields at each @l =2
  • Generating the merged document 2
  • Saving the merged document @ 1(c) Printing the word documents

     

  • Social network@I
  • mail merge @l
  • counsel letter @l
(Visited 188 times, 1 visits today)
Share this:

Written by