SECTION A

1. (a) (i) Using a suitable word processing software, type this document as it is.

TUBER CULOSIS(TB)IN AIDS

The global war on AIDS could lost if the ignores tuberculosis, often a death sentence for people infected with HIV , former south African president Nelson Mandela warned at a global AIDS conference recently held in Bangkok. The world has made defeating AIDS its top priority.This is a blessing, but TB remains ignored ,said Mandela.He steered clear the controversay to focus on the plight of millions suffering from HIV and TB.

About 14 million people are infected with HIV and TB ,70% living in sub-saharan Africa,the region hardest hit by HIV/AIDS,which has killed 20 million peopleworldwide.HIV, the virus whichcauses AIDS,destroys the immune system and makes patients more vulnerable to diseases such as TB,an infectios illness that accounts for up to one-third of all HIV/AIDS deaths.

"We cannot win the battle against AIDS if we do not also fight TB.TB is too often a death sentence for people with AIDS.it does not have to be this way".mandela said.He said resources for detecting and treating TB were woefukky short despite the world having had a cure for it more than 50 years ago.

(Adapted from: The New Vision,Monday,July 19,2004.)

(ii) copy and paste the document topage 2.

(iii)using the copy on page 2,centr,bold and underline the heading and make it font size 24.

(iv)Cetre align the third paragraph and make it all italics.

(v)Italicise the source of this document and make it font size 8.

(vi)Spell check your document.

(vii)Insert your name and index number as a footer.

(viii) Save your work as my work.

(b) The table below shows the average sales (in millions of litres of liquid soap of four companies in a certain city during the first quarter of the year 2003

 

	Patro	Coltexn	Hellen	Pove
January	23.9	40.0	65.5	18.7
February	15.0	54.8	69.0	22.6
March	20.4	67.0	78.9	24.4

(i) Enter the above information in a spreadsheet.

(ii)Create a pie chart that includes a title and labels to represent the sales of the four companies in the first quarter of 2003.

(iii)Draw a bar chart to represent the sales of the companies.

(iv)Determine the totals sales of each month.

(v)Insert your name and index number in (i) and (iii) above.

(vi)save your work on a floppy diskette as my spreadsheet.

 

SECTION B:

2. (a) Create a database structure (table) using appropriate data types in relation to the table given below. Set staff No. as the primary key. Save the table as staff table.

Staff pay roll

Staff no.	Surname	First Name	Sex	Department	salary
UTS652	Natukunda	Emilly	F	Physics	275,000
UTS441	Oloka	John	M	Chemistry	265,000
UTS102	Abaho	Benedict	M	Economics	500,000
UTS333	Among	Joyce	F	Physics	275,000
UTS459	Biriggwa	Joshua	M	Economics	490,000
UTS245	Namagembe	Hawa	F	Chemistry	310,000
UTS134	Nokrach	James	M	Economics	850,000
UTS101	Mwesigwa	Johnan	M	Physics	290,000
UTS376	Kakaire	Peter	M	Chemistry	540,000

(b)Create a form using the staff table in (a) above and use it to input the records above. Save the form as staff form.

(c)Create a query showing staff no, surname and department to filter out only staff in the physics department. Save it as query 1.

(d)Create a report using query1 table.

(e)Create another report which will produce a list of staff who are in economics department earning a salary of less than shs.600,000.

3. Gapro is abig industrial firmdealing in the production of various industrial goods such as iron sheets =,angle and iron bars,metallicdoors and windows and many other related products.It sells its products in local markets and in markets in some neighbouring countries.Local outlet branches are in kampala,Jinja,Mbale and Arua.Regional branches are in Nairobi,Dar-es-salam and Kigaliin neighbouring countries.The firm is managed by four managers in addition to the executive generalmanager .This includes the manager responsible for the department of production,Finance and Accounts,Marketing and Sales,and personnel and welfare.

The firm has approached you to design a website.You are expected to create a website consisting of

(i) a page with a suitable company logo linking all the departments of the firm.

(ii)a page on the production and marketing of the various products.

(iii)a page linking the local and regional markets for the firm's products.

(iv)minimal graphics showing the functions and products of the firm.

N.B. The website should:

(i)have a link for the firm's e-mail address.

(ii)be well linked.

(iii)be creatively designed.

(iv)include your name and index number on the first and last pages as a footer.

(v)Save your work as Gapro.

4. as an education official in your district, you have been assigned a project to sensitize people in your locality about the importance of education.

You are required to design four slides.

(i)Slide I: Introduction (include definition of education,history of education in district and Uganda).

(ii)Slide II: Content(types of education)

(iii)Slide III: Benefits and achievements of education.

(iv)Slide IV: Short comings of education and conclusion.

(v)Save your presentations as 'education'.

N.B. Insert a relevant graphic on each slide.

_ set your slides to have suitable background.

_ Include your name and index number on each slide as a header.

_ Set the slides to run automatically.

5. Using any available web publishing software, design a hotel's home page. Make sure the home page is very impressive but not too slow to down load.

You are expected to include the following:

(a) A page title.

(b) Appropriate graphics.

( c) a 100-120 word text.

(d) 1 link (for the hotel's email address).

(e) Table-showing at least four services offered by hotel.

(f) Layout.

(g) Creative designing

(h) Save your work as Hotweb.