SECTION A.

1. (a ) Type the document below as it is, and save it under the name "My work 1"

Comper expert calls for IT course in schools.

Uganda's youg generation neds to be taught to apreciae the rise of Information Technology (IT) in their day-to-day lives, Sultan Awan , the managing director, silicon compuer series said.

The website www.Uganda schools.org, for a fe of shillings 30, 000, school wil publish information abut themselves on the site. There is a separate pge for every school.

By John Ricks Kayizzi

(Monitor Publications).

You are required to:

(i) Change the heading to uppercase, bold and underline it

(ii) Correct any misspelled word(s) in the document.

(iii) Replace the fee of shillings 30,000 by shillings 40,000.

(iv) Add your name and index number as a footer.

(v) Save the document a "My work 2"

(b)The following rates were quoted by some forex bureau in Kampala, for some currencies sold in Uganda shillings. Enter this table into spreadsheets.

 

Bureaux.	Dollars.	Pounds.	Euros.	DM.
A	1808	2600	1560	800
B	1808	2605	1605	_
C	1805	2600	1600	_
D	1803	2650	1645	_
E.	1807	2600	1600	_

 

You are required to:

(i)Create a pie-chart representing Forex Bureau A entries in percentages. Put the legend at the bottom.

(ii)Add a title to the pie-chart in (b)(i).Place the chart as an object below the table.

(iii)Add your name and index number below the pie-chart.

(iv)Save the work sheet as "My chart."

 

SECTION B

2. (a)Students of computer studies in a certain secondary school are to design their database with the following fields.

Surname of the student, first name,age,district of origin ,sex,index number, whether the student is an orphan or not, marks scored in a mathematics test.

(i)Use the above information to design a structure using the following format:

Table name . . . . . . . . . . . . 9state it)

Field name	Data type	Size/Length

(ii)Create a table of five records

_Name the appropriate key field (primary key).

(iii)Save the database as "My file".

(b)A recent survey showed the following data. Enter the information below in the table called "survey".

Reg.No.	Surname	First Name	Sex	Age	District
0006	Okello	Rose	F	15	Tororo
0010	Opio	John	M	62	Tororo
0007	Masaba	Patrick	M	40	Mbale
0127	Mukasa	Alex	M	20	Masaka
0053	Lwanga	Lydia	F	34	Masaka
0080	Abaho	Kate	F	52	Bushenyi
0008	Mugisha	Joseph	M	6	Kabale
0021	Akot	Aisha	F	22	Lira
0458	Uwimana	Jane	F	45	Kisoro
0500	Namubiru	Grace	F	31	Masaka

(i)Create a query to show people from Masaka.

(ii)Given that all the males and females above 18 and below 60years of age pay graduated tax, write a query which will display only tax payers.

(iii)Create a report for all females showing their names and their districts.

Save as "My report."

3. Using a web design software of your choice, design a website for your former primary school which includes:

(a) An index page with the name of the school and picture of an important feature in the school. .(The picture does not have to be the actual one but should be closely related).

(b) One page on the

(i) Different subjects offered.

(ii) School administration.

(iii) Sports and co-curricular activities,

(iv)neighboring community.

(c)In the website

(i) Write your name and index number at the end of the last page.

(ii) The pages should be well linked.

(iii)Save as 'My preschool"

4. The ministry of Health has appointed you as a Health Educator. You are required to give a talk on "The role of sex Education in schools".

You are required to:

(a) Design 3 slides as follows:

(i)Slide I should have the introduction of the topic.

(ii)Slide II should have the content of the topic.

(iii)Slide III should have the relevancy of sex education in schools.

(b) Include your name and index number at the end of each slide.

( c)Save your presentation as "My slide".

(d)Use minimal graphical effects.

5. Dynamic Roses, a flower farm which produces red and white roses, red and purple carnations, sells its products both locally and abroad. It has 4 managers namely;

General Manager _ in charge of overall management

Personnel Manager _in charge of human resources and is responsible for welfare of the employees.

Production Manager _responsible for growing and packing flowers.

Marketing Manager _responsible for selling, transportation and collection of revenue.

Imagine you have been approached to design a website for the company.

Create a website consisting of:

(a) An index page with links to all departments with a company logo.

(b)a page on the ;

(i) Production department detailing the varieties of flowers produced.

(ii)Marketing detailing the different managers and their roles.

(iii) Marketing detailing where the products are sold.

(c)A photo gallery showing pictures of different products and functions of the company.(use only three pictures)

(Note: The pictures do not have to be real ones but must be closely related)

(d)In the website;

(i) Include a feedback provision where a visitor to the page can send an e-mail.

(ii) Write your name and index number at the end of the last page as a footer.

(iii)Save the file as "Rose farm".