(a) Create a new workbook and name it as Top Achievers Computer Exams (1 mark)

AdmNo. Name Form Two CAT 1 CAT 2 CAT 3 Total Average

4567 Mutuma Kathurima N 78 82 56

5238 Benson Githae W 75 55 65

2245 Jimmy Kitonga N 42 45 87

3126 Annette Wafula W 80 93 70

4323 Victoria Njoki N 76 75 80

5400 Josephine Zuma W 38 48 25

5321 Christine Ayieta N 37 51 29

3421 Paul Nyundo N 41 86 56

2890 Wesley Makau N 48 76 89

3654 Joy Aoko N 93 67 35

b)
i. Enter the following data in sheet 1 as follows:

ii. Font type Times New Roman, Font Size 12.

iii. Centre the text in the columns Form Two, CAT 1, CAT 2, CAT 3, Total and Average. (24 marks)

c) Rename the sheet as Term One Results (1 mark)

d) Find:
i. Totals (2 marks)

ii. Average (2 marks)

e) Copy sheet 1 to sheet 2 and rename it Term One Results 2. (3 marks)

ii) Below the last row enter formulas to count students from all the classes (2 marks)

f) Sort the students list by Adm No in ascending order (2 marks)

g)i) Add a column titled Remarks. (1 mark)

ii) Use the IF function to award remarks as follows (4 marks)

 If the average is greater than or equals to 75 the remark is “excellent”

 An average between 50 and 59 award the remark “average”

 An average of 49 and below award the remark “below average”

i) Insert a column chart to display the following information. (3marks)

 The marks for the three CATs to appear on the Y axis

 The names to appear on the X axis

 Title as “COMPUTER EXAMS RESULTS”

i) Place the legend at the bottom of the graph (1 mark)

ii) Save the chart on a new sheet and name it Results Analysis (1 mark)

j) Print
i) The chart in landscape orientation (1 mark)

ii) Term one results and Term one results 2 in landscape orientation (2 marks)

QUESTION TWO

Table 1, table 2 and table 3 are extracts of records kept in a health centre for patients, doctors
and consultations respectively.
Table 1

Doctors numbers Names

520 Charles

521 Beatrice

522 James

523 Isaac
Table 2

Consultation Consultation Patient Doctor Ailment

Number Date Number Number

101 07/09/2012 0120 520 flu

202 09/09/2012 0123 521 malaria

303 13/09/2012 0121 522 cough

405 14/09/2012 0120 520 flu

507 15/09/2012 0121 522 cough

608 16/09/2012 0122 521 malaria

704 16/09/2012 0123 523 measles

808 17/09/2012 0121 522 cough

901 30/09/2012 0122 521 malaria

1021 01/10/2012 0123 523 measles

a. i)Using a database application package, create a database file named PATIENTSINFO (1mk)

ii)Create three tables named PATIENTS, DOCTORS and CONSULTATIONS that will be used to store the data in table 1, table 2 and table 3 respectively.

(14mks)

iii)Set the primary key for each table. (3 marks)

b. (i)Create a data entry form for each table. (3 marks)

(ii)Enter the data in table 1, table 2 and table 3 into the Patients, Doctors and

Consultations tables respectively. (9 marks)

c. (i)Create a query named PatientAge to display Patients’ Names, Gender and Age on the year of visit. (4 marks)

(ii)Create a query named Beatricedetails to display Patients’ Names, Ailment and

Consultation Dates for patients treated by Doctor Beatrice. (3 marks)

d. (i)Create a report to display the Patients’ Names, Consultation Dates, Ailments

and the Names of the Doctors consulted. The records in the report should be

grouped by Patients’ Names and the number of consultations by each patient

should be displayed. (5 marks)

(ii)Title the report as “Consultations Per Patient” and save it as Consultations. (2 marks)

e. Print the following:

(i) Tables: Patients, doctors and consultations; (1 mark)

(ii) Queries: PatientAge and Beatricedetails; (1 mark)

(iii) Report: Consultations; (1 mark)

(iv) Form: Consultations. (1 mark)