UNEB UCE Computer Past Papers ( Paper 2 ) 2018/2019

By | October 29, 2019
Sponsored Links

UNEB UCE Computer Past Papers ( Paper 2 ) 2018/2019

SECTION A

1. a) Using a word processor, type the following document. Save it as your name and personal number.

Mathematics is a subject that is taught in schools at all levels right from pre-primary to institutions of higher learning. The subject is relevant in many fields of study. Given below are examples of an equation and a diagram in mathematics.

 


Such calculations and other related concepts make Mathematics a very exciting subject!

ii) Copy the document and paste it to a new page

iii) Insert a suitable heading for the document. Centre and underline the heading.

iv) Drop Cap the first paragraph.

v) Italicize the last sentence

vi) Insert a header of your name and personal number

vii) Add page numbers in the document

viii) Save and print all your work

 

b) The table below shows a quotation by Ms JM Enterprises, dealers in foodstuffs.

MS J M ENTERPRISES
DEALERS IN GENERAL FOOD STUFFS
QUOTATION
SERIAL NUMBERITEMQUANTITY (KGs)UNIT PRICE (UgX)TOTAL (Ugx)
1Maize22,400
2Beans53,000
3Peas101,500
4Cassava62,000
5Lemon31,200
6Sugar202,500
7Matooke415,000
8Groundnuts46,000
9Passion Fruits24,000
10Meat54,500
GRAND TOTAL
VAT (17.5%)

i) Use a spread sheet software to enter the given data as it is. Save it as your name and personal number.

ii) Insert formulas to calculate the TOTAL and GRAND TOTAL.

iii) Calculate the Value Added Tax (VAT) at a rate of 17.5%.

iv) Sort your data by ITEM in ascending order.

v) Apply All Borders on your work.

vi) Represent the items and their unit prices on a Pie Chart.

vii) Save and print your work.

 

SECTION B

2 a) Using any web designing software, design a website for a public library with the following linked pages:

i) HOME PAGE including a marquee

ii) CONTACT US PAGE including the location, postal address, telephone number and email address of the library

iii) LIST OF BOOKS available in the library

iv) BOARD OF GOVERNORS PAGE showing the management committee of the library.

v) FUTURE PLANS

 

b) The website should have a top banner.

c) Use relevant images where possible

d) Save your website as Library and your name e.g Library_Musoke

e) Print your work

 

3. The following table was extracted from a report to be delivered to the community by the district health officer in your area about malaria epidemic.

The table shows reported cases of malaria and malaria related deaths in the area from January to June.

MonthReported CasesRelated deaths
January8004
February10005
March9801
April8703
May7002
June6001

You have been entrusted with the task of preparing a five-slide presentation on the epidemic

a) Make a five-slide presentation for the workshop as follows;

i) SLIDE 1: Should include the title and name of the presenter. Insert a hyperlink to the presenter’s personal website.

ii) SLIDE 2: Insert the given table. Include a slide title.

iii) SLIDE 3: Use the information in the table to create a column chart.

iv) SLIDE 4: sShould include ways of preventing malaria.

v) SLIDE 5: Conclusion

 

b) Each slide should;

– Have your name and personal number as a header

– Run every after one minute

– Have minimal and appropriate graphics

c) Save the presentation as your name and personal number.

d) Print your slides

 

4. The table below shows the details of some musicians in Uganda.

Artist NumberReal nameStage NameSexDate of BirthMusic CategoryBest HitHome TownStage worth $
M001MusokeMiad TigerMale02/03/1980RaggaOmukwanoKampala100,000
M002OjokBig bossMale01/01/1975CountryUganda my homelandGulu50,000
M003NamusokeSnake GirlFemale01/06/1985Dance HallSleeping PillMasaka120,000
M004MagumbaDJ BestMale03/05/1988RnBDissappointmentKampala600,000
M005BagumaMr. RightMale03/01/1990RaggaGood girlJinja50,000

a) Using any database management software, create a database and save it as Musician your name e.g Musician Amooti.

b) Design a table to capture the given data using appropriate data types of the fields. Name it Musician Table

c) Create a form called Entry Form to enter the data

d) Create a query called Tax query to calculate the tax paid by the artists. The tax is 10% of the Stage Worth

e) Create another query showing artists born before 1986 and whose home town is Kampala. Name it Kampala Artists.

f) Create a report using the Kampala Artists query and name it Kampala Artists report.

Sponsored Links

g) Print all your work in landscape orientation.