1. A medical centre wishes to computerize all its patients’ records.

a) Create a database for the centre and save it as your name and personal number,
b) In Design View, create a Table with the following properties and save it as a Patient Bio Table.

c) Create a form for Patient Bio Table and enter the records below, save it as Patient Bio Form.

d) In Design View, create another table with the following properties and save it as Patient billing Table.

*Medical is a calculated field which is Consult_fee+ Treat_fee

e) Populate the Patient Billing Table with the following data;

f) Create a one-to-one relationship between the Patient Bio Table and the Patient Billing Table.
g) Create a query which extracts fro Patient Bio Table only those patients who were not diagnosed with Malaria. Save it as Anti-Malaria.
h) i) Create a report showing Name, Residence, Prescription and Medical Bill. Save it as Clinic Report.
   ii) Include a report footer of your name and personal number.
   iii) Print all your work.

2. As a peer educator, you have been told to prepare for a workshop where ypu will address the youth about a topic “Adolescence”. A folder called Images has been provided to help you get all the related pictures.
a) Prepare a presentation with six slides about adolescence as follows:
     i. Slide one: Introduction about the topic
    ii. Slide two: Characteristics of male adolescents
   iii. Slide three: Characteristics of female adolescents
   iv. Slide four: Effects of uncontrolled adolescene
   v. slide five: Advice to adolescents
  vi. Slide six: Telephone contact is +256-56418545, website address is www.youthclub.org and email is This email address is being protected from spambots. You need JavaScript enabled to view it.

b) Select any four pictures and insert them on appropriate slides.
c) The presentation should run automatically without stopping.
d) Insert your name and automatic date as a footer.
e) Save your presentation as your name and personal number
f) Print all your slides on one page.

3. a) Using an appropriate spreadsheet application, load the file Exam results and save it as your name and personal number.
b) Rotate the titles to an angle of 60 degrees.
c) Copy the table to sheet 2 and rename the sheet modified.
d) Using appropriate functions, compute;
     i. total marks obtained by each student to be placed in column P.
     ii. average marks to one decimal place obtained in the compulsory subjects (English, Mathematics, Geography, History, Biology and Chemistry). Place the           average marks in column Q.
      iii. the number of students who sat for Computer as one of their optional subjects. Place the result in cell C25.
     iv. the highest score obtained in Chemistry. Place the result in cell C26.
e) Sort the students’ records in descending order according to their total mark.
f) Insert a footer of your name and personal number.
g) Include all borders on the table
h) Save and print the work.

4. a) Using a word processing software, open the file document xy and save it as your name and personal number.
b) Underline the heading with a dotted line.
c) Drop cap by three lines the first paragraph.
d) Convert paragraph two into two columns with a line in between.
e) Insert page numbers, centre aligned in the A, B, C format.
f) Insert an appropriate watermark of size 38.
g) Insert a page break after the first paragraph.
h) Insert the image100.jpg on the first page.
i) Apply a page boarder on the first page only.
j) Insert your name as the header and today’s date as the footer.
k) Set paper sizw to A5 for the whole document and print your work.

5. As an ICT student, you are required to use a suitable publication software and design a four cover for the magazine called Agriculture for Better as follows:
a) Use appropriate layout, paper balance, font variation and relevant pictures. Save it as your name and personal number.
b) Insert a clip to represent the writer at the bottom of the cover.
c) Use your name as the author of the magazine.
d) Insert automatic current date to appear as the date of publication.
e) Apply suitable background for the cover.
f) Insert your name and personal number as a header.
g) Save and print your work.