Computer Studies Paper 2 Questions and Answers - Cekenas Pre Mocks 2022

Share via Whatsapp

INSTRUCTIONS TO CANDIDATES

  • Type your name and index number at the top hand corner of each printout.
  • Write your name and index number of the CD-RW
  • Write the name and version of the software used for each question attempted in the answer sheet
  • Passwords should not be used while saving the CDs
  • Answer all questions
  • All questions carry equal marks
  • All answers must be saved in your CD
  • Make printouts of the answers on the answer sheets provided
  • Hand in all the printouts and the CDs
  • Arrange your printouts and stable them together
  • Candidates may be penalized for not following instructions given in this paper

FOR EXAMINERS USE ONLY

QUESTION

MAX. MARKS

CANDIDATE’ S SCORE

1

50

 

2

50

 

TOTAL SCORE

 


QUESTIONS

  1.                              
    1. Using a word processor type the passage below as it appears and save it as Society. (40 marks)
      1 asdadad

      2 adadad
    2. Copy the Society to a new document and save it as Society 2 (2marks)
    3. Change the paragraph starting with “For instance……….“ to bold italic (2 marks)
    4. Look for the word alarming and replace it with the word surprising (3marks)
    5. Using the word count feature count the number of characters with spaces in the passage (2marks)
    6. Insert alphabetical capital letter page numbers at the top left side of the document Society 2 and update all the changes. (2 marks)
    7. Print the two documents Society and Society 2 (2 marks)
  2. The tables below, STUDENT, SUPERVISOR and SUPERVISIONS are extracts of records kept in MOKASA UNIVERSIRY 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 (1mark)
    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. (3mks)
    5. Enter the data in the table STUDENT, SUPERVISOR and SUPERVISIONS as shown above. (10mks)
    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. . (5mks)
    9. 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)
    10. Title the report as supervision per lecturer. (2mks)
    11. Print the following:
      • Tables: STUDENT, SUPERVISOR and SUPERVISIONS (2mks)
      • Queries: BALANCE and BALANCE2 (2mks)
      • REPORT: SUPERVISIONS (1mk)


 MARKING SCHEME

1 adadad


Download Computer Studies Paper 2 Questions and Answers - Cekenas Pre Mocks 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
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