Welcome to Ugfacts.net/ke. On this page you will find details on the following topics

KUCCPS Admission Letters KUCCPS Student Portal KUCCPS Admission Lists
FREE KNEC KCSE Past Papers FREE KNEC KCPE Past Papers List of All Past Papers 
Fees Structure for 2024-2025 KNEC KCPE KNEC KCSE
Intakes and Admissions 2024-2025 List of Courses Offered Latest Jobs in Kenya 2024-2025
TVET Applications 2024-2025 TSC KNUT
KDF Recruitment Kenya Police Recruitment Kenya Prisons Service Recruitment

Your Opinions and Questions Matter. Kindly leave your comments below and we shall attend to you promptly.

KNEC KCSE Computer Studies Paper 2 Question Paper – Bomet County Joint Examinations

KNEC KCSE Computer Studies Paper 2 Question Paper – Bomet County Joint Examinations

2015 KCSE Bomet County Joint Examinations

Computer Studies Paper 2

Answer all questions

(a). A hospital uses a database to maintain data about its employees. Create a database file named EMPLOYEE. (1mark)

(b). Create a table called EMPLOYEE1 with the following fields and hence enter data into it as shown in fig 1 below. NB: Choose an appropriate primary key. (14marks)


Fig 1.

Emp no Name Date of birth Department Gross pay
01 John Kirui 16/2/1972 Computer 28000
02 Margaret Wairimu 2/2/1960 Medical 30000
03 Jane Cherono 2/5/1970 management 15000
04 Victor Oduor 8/12/1981 Accounts 25000
05 Harry Wanyama 23/6/1983 Medical 30000
06 Jacob Kiprono 19/4/1973 Management 45000
07 Ali Mohammed 1/1/1969 Medical 30000
08 Daniel Omondi 3/5/1983 Accounts 25000
09 Everlyne Kitune 11/3/1971 Medical 20000
10 Nancy Kerubo 22/9/1980 Medical 20000


(i). Insert TWO new fields to hold the employee’s Profession and Deductions. (4marks)

(ii). Data for included fields is as follows;


Mohammed, Wanyama and Wairimu are Doctors. Oduor and Omondi are accountants. Kiprono is an Administartor, Kirui is a systems analyst and Cherono is a secretary.


Emp no Amount
07, 05, 02 8,000
04, 08 7,500
06 10,000
01 12,000
03 3,500
09, 10 4,000
Enter the above data into the respective fields. (6marks)
(iii). Sort the records in ascending order based on the name field and save as EMPLOYEE2 (3marks)


(i). From EMPLOYEE2, extract a list of employees who were born between 1960 and 1972 both years inclusive and are accountants, nurses or doctors. Write down on paper provided the query expression you used to extract the data. Save the extracted list as LIST1. (8marks)

(ii). Remove the date and occupation criteria on LIST1. Add a calculated field to calculate the Netpay of all employees as GrossPay – Deductions. Save as LIST2. (7marks)

(e). Generate a columnar report based on LIST2 with the following fields; Emp no, Name, Department and NetPay. Sum up the NetPay for all employees in the report. Save your report as REPORT. (8½marks)

(f). Print EMPLOYEE1, EMPLOYEE2, LIST1, LIST2 and REPORT. (2½ marks)

 54 marks


(a) Use DTP software to design the following receipt and save it as Design1. (34 marks)

Computer Studies Paper 2 Question Paper - 2015 KCSE Bomet County Joint Examinations


(i). Fit Four copies of the above design on a single page. (8marks)

(ii) Include a page footer with your name and index number and a page header with the words “Computer Designs” Save as Design2. (6marks)

(c) Print the Design1 and Design2. (2marks)

Leave a Comment