Get premium membership and access revision papers, questions with answers as well as video lessons.

Borabu Masaba District Mock-Computer Studies Pp2 Question Paper

Borabu Masaba District Mock-Computer Studies Pp2

Course:Secondary Level

Exam Year:2012

NAME……………………………………………………………….DATE ……………………………
INDEX NO………………………………………………CANDIDATE’S SIGNATURE……………

451/2
COMPUTER STUDIES
PAPER 2
(PRACTICAL)
JULY/AUGUST 2012
TIME: 2 ½ HOURS

BORABU-MASABA DISTRICTS JOINT EVALUATION TEST– 2012
Kenya Certificate of Secondary Education (K.C.S.E)

451/2
COMPUTER STUDIES
PAPER 2
(PRACTICAL)
JULY/AUGUST 2012
TIME: 2 ½ HOURS

INSTRUCTIONS TO CANDIDATES
Type your name and index number in the spaces provides above
Sign and write the date of examination in the spaces provided in the answer sheet
Password should not be used while saving in the Compact disk.
Answer all questions.
Make a print of the answer sheet provided
Hand all the print out and the Compact disk.

This paper consists of 8 printed pages. Candidates should check the question paper to ensure that all the papers are printed as indicated and no questions are missing.

QUESTION ONE (50 MKS)
(a) Create a database in the floppy disk named BORA UNIVERSITY COLLEGE. (2mks)
(b) Create a table with the following fields using appropriate data types: Adm No, First Name, Last Name, Course, Date of Admission and Completed. Set Adm No as a Primary key .Save it as
STUDENTS DETAILS (6mks)
(c) Create a Columnar form that would be used to enter data into STUDENTS DETAILS and save it as STUDENTS DATA ENTRY. (2mks)
(d) Use the above form to enter the following data into the database. (6mks)

(e) Create a table named ‘FEE PAYMENT’ in the same database to contain Adm No, Fee Paid and Receipt No. (5mks)
(f) Link STUDENTS DETAILS table to FEE PAYMENT table. (2mks)
(g) Enter the following details directly into the FEE PAYMENT table. (2mks)

(h) Create a query to display the following details: Adm no, First name, Last name, Fee paid.
Save as FEE PAID. (5mks)
(i) Display a list showing the Last name and the Fee balance for all students who owe the college over 10,000/= given that the total fees for each course is 30,000. Save as SEND HOME. (5mks)
(j) Certificates are to be given only those who have completed their course and have paid the full amount. Create a query, having the Adm No, First name, Last name and course for all students to be awarded the certificates. Save as GRADUANTS. (5mks)
(k) Prepare reports for STUDENTS DETAILS, FEE PAYMENT, FEE PAID, SEND HOME,
GRADUANTS. (5mks)
(I) Print the reports in (I) above. (5mks)
QUESTION 2(50MKS)
PK is new transportation company. The managing director would like to produce an advert to enable him to reach out to local towns.
a). Prepare a publication layout with the following specification:
(i) Paper size A4
(ii) Orientation Portrait
(iii) Number of pages 1
(iv) Margins 0.5 inches all round
(v) Create column guides to subdivide the page into two columns
(vi) Space between columns 0.3 inches (6mks)
b). Produce the publication as shown in the sample. All the text are in Times New Roman size 12 except.
(a) PK in the logo Size 28
(b) Unbeatable Size 20
(c) You can’t compare Size 14
(d) Working hours Size 22
(e) Passenger Ticket shading is Accent 4
(f) Fill pattern for working hours is 5% (44mks)

Borabu Masaba District Mock-Computer Studies Pp2 Question Paper

More Question Papers

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams