Computer Studies Paper 2 Questions and Answers - Sunrise 2 Evaluation Mock Exams 2022

Share via Whatsapp
INSTRUCTIONS TO CANDIDATES
  • Type your name and index number at the top right hand corner of each printout
  • Write your name and index number on the compact disks
  • Write the name and version of the software used for each question attempted in the answer sheet
  • Passwords should not be used while saving in the compact disks
  • Answer all the questions
  • All questions carry equal marks
  • All answers must be saved in your compact disks
  • Make a printout of the answers on the answer sheets provided
  • Hand in all the printouts and the compact disks

QUESTIONS

cmp 2
QUESTION 1
  1. Using a word processor, create the following table as it appears and save it as Table1 (25mks)
    1. Sort the table’s content by Stream in ascending order (1mk)
    2. Merge the cells containing identical streams (1mk) 
    3. Save the changes made to the table as Edited_Table1 (1mk)
    4. Using appropriate formula, determine: -
      • TOTAL MARK (4mks)
      • STUDENT MEAN (4mks)
      • TOTAL FOR STREAM H (4mks)
      • TOTAL FOR STREAM K (4mks)
        TOTAL FOR ALL STREAMS (4mks)
    5. Print: (2mks)
      • Table1
      • Edited_Table1 
Question 2
The following table contains details of Baharini Girls school (50MARKS)

ADMNO

Stud

name

DOB

KCPE

MARKS

RECEIPT

NO

Fees

Paid(kshs)

Fees

Bal(kshs)

House

No

House

Name

House

Capacity

1001

Alice K

7/4/1999

380

101

20000

5000

H20

simba

200

1050

Lilly O

2/3/2002

350

894

18000

7000

S08

chui

150

1202

Mary

8/10/2000

400

500

23000

2000

P30

Kifaru

180

1025

Juliet

4/4/2000

358

258

25000

0

H20

Simba

200

1200

Joan

5/1/2001

398

259

15000

10000

S08

chui

150

1278

Milly

3/4/1998

402

200

15000

10000

H20

simba

200

1201

Linet

2/7/1998

356

205

20000

5000

P30

kifaru

180

1203

Lisper

9/5/2001

403

209

25000

0

S08

chui

150

REQUIRED
  1. Create a database file that can be used to store the above data. Name the file Baharini school database. (2mks)
  2. Create Three tables, one for student details, Accounts table and dormitory table  (11mks)
  3. Create a relationship between the three tables (3mks)
  4. Using appropriate forms, Enter the information given into the three tables (15mks)
  5. Create a query for “all students housed in Chui” (3mks)
  6. Design a “current age query”to display current ages of all the students (5mks)
  7. Create a report “Hefty Balances” showing students with fees balances of more than 10000kshs (3mks)
  8. Create a report to show all students admitted in the school (3mks)
  9. Print, Thethreetables,Hefty balances reportand all students housed in Chuireport (5mks)

MARKING SCHEME

QN

SECTION

ACTIVITY

MAX MARK

MARKS AWARDED

1

a)

  • Creating Table
  • Shading of first Row
  • Text Direction and underline of Headings
  • Fully typed text
  • Correct use of line styles
  • Table border

10marks

4marks

2marks

5marks

2marks

2marks

 
 

b)

Sorting content (Ascending order)

1mark

 
 

c)

Merging cells of Same streams

1mark

 
 

d)

 

e)

 

f)

Saving Table to Edited_Table1
Computation of;

  1. TOTAL MARK
  2. STUDENT MEAN
  3. TOTAL FOR STREAM H
  4. TOTAL FOR STREAM K
  5.  TOTAL FOR ALL STREAMS

Printout of:

  • Table1
  • Edited_Table1

1mark

4marks

4marks

4marks

4marks

4marks

1mark

1mark

 
 
 

Total

 

50

 
 

2.

a

Database created

(2mks)

b

Created tables

(11 mks)

c

Created  relationships

(3mks)

d

appropriate forms, information entered

(15mks)

e

Query created

(3mks)

f

Correct Current ages featuring

(5mks)

g

Correct report

(3mks)

h

Correct Report

(3mks)

i

printing

(3mks)

TOTAL

 

50MARKS


Download Computer Studies Paper 2 Questions and Answers - Sunrise 2 Evaluation Mock Exams 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?