1. The table below gives information about some students in XY Secondary School.

Reg. No.	Names	Class	Age	Sex	House
001	Gadibe G.	S5	18	M	Nasser
002	Nabakiibi J.	S1	13	F	Kenyatta
003	Bbaale B.	S2	15	M	Mandela
004	Dungu W.	S3	16	M	Lubega
005	Agwang F.	S1	14	F	Mwanga
006	Opeta T.	S3	16	M	Mandela
007	Kapere R.	S5	19	M	Mwanga
008	Cossy K.	S5	20	M	Kenyatta
009	Mpuuta V.	S3	18	M	Kenyatta
010	Nampa T.	S1	12	F	Lubega

a) Create a database and save it as your name

b) Design a table with appropriate data types and enter the given data. Name it as Registration Table

c) Design a query to extract all male students above 18years of age and name it Mature.

d) Create a form which will display records in the table. Name it Registration Form

e) Create a report to display students’ details with the names arranged in alphabetical order. Name it Registration Report.

f) Print all your work

2. a) Prepare a four-slide presentation about a hotel business as follows:

i) Slide One:	Hotel name in Word Art format, the hotel address and an image.
ii) Slide Two:	Use bullets to outline the services offered
iii) Slide Three:	Use a table to show the hotel menu fo Breakfast and Lunch
iv) Slide Four:	Use images or test to represent various drinks and stars or banners to display prices of the drinks

b) Add your name and personal number as a header to all slides

c) Save your work as your name and personal number

d) Print all the slides on one page

3. a) Using a publishing software, design a certificate of merit to be awarded to participants in a debating competition. The motion of the debate is The Teaching of ICT has brought more positive effects than negative effects. Save your work as you name and personal number.

b) Set the dimensions of the certificate to width 11 inches and height 8.5 inches

c) Provide an appropriate title and apply Word Art in the title

d) i) Use relevant content of a certificate and also include the motion of the debate.

ii) Include your name as the recipient of the certificate

e) Insert any logo from the folder Images

f) Use a suitable background for your certificate

g) Apply a border to enclose your certificate

h) Save and print your certificate as your name.

 

4. a) Using a word processor application, load the file mercedes.rtf

b) Save the file as your name and personal number.

c) Cut the last sentence of the text and paste it as a centered heading

d) Double underline the heading

e) Arrange your work in three columns except the heading

f) Insert at the beginning of the first column the image Mercedes.jpg and apply a tight text wrapping

g) Resize the picture to 1.12” height and 2.0” width

h) Apply double line space and a justify alignment to your work

i) Insert a suitable word of your choice as a watermark

j) Apply a 6pt page border of any color around your work.

k) Insert your name, personal number and an automatic date as a footer

l) Save and print your work

 

5. a) Using spreadsheet software of your choice, open the file overtime.xls and save it as your name and personal number.

b) Format the DATE column to display the date in this format 3-feb-2015

c) i) Insert in cell E2 the column name REGULAR WAGE

ii) Compute in column E the wages earned for regular hours at a rate of Sh. 3100 per hour

d) i) Insert in cell F2 the column name OVERTIME WAGE

ii) Compute in column F the wages earned for overtime hours at a rate of Sh.3300 per hour.

e) Compute in column G the total wage earned by the laborers. Name the column GROSS

f) In column H, compute the income tax that is 17% of gross. Name the column TAX

g) Compute the net pay of each laborer

h) Revise the title to include the computed information.

i) Use a column chart to illustrate each laborer’s regular and overtime wages.

j) Apply all borders to your data

k) Save and print your work