840/2

COMPUTER STUDIES
PRACTICAL
Paper 2
Oct. / Nov. 2018
21/2 hours

UGANDA NATIONAL EXAMINATIONS BOARD

Uganda Certificate of Education
COMPUTER STUDIES
(PRACTICAL)
Paper 2
2 hours 30 minutes

INSTRUCTIONS TO CANDIDATES:

This paper consists of two sections, A, and B.

Section A contains one compulsory question.

Section B contains three questions. Attempt any two questions from this

section. Any additional questions(s) answered will not be marked.

Each candidate is provided with a new blank Compact Disc (CD)

Candidates should continuously save their work.

Each candidate must produce a hard copy for each of their work to
accompany the Compact Disc (CD)

Turn Over

1
 © 2018 Uganda National Examinations Board

SECTION A (40 MARKS)

This Sections is compulsory

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

Mathematics is a subject that is taught in schools at all level right from

pre-primary to institutions of higher learning. The subject is relevant in many in
fields of study. Given below are examples of an equation and a diagram in
Mathematics.

104ten = 142x (5+n) ⎯ 7

12 m
14 m

Such calculations and other related concepts make Mathematics a very

exciting subject!

(ii) Copy the document and paste it to a new page. (01 mark)

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

2
(iv) Drop Cap the first paragraph. (01 mark)

3
 (v) Italicize the last sentence. (01 mark)

(vi) Insert header of your name and personal number. (01 mark)

(vii) Add page numbers in the document. (01 mark)

(viii) Save and print all your work. (01 mark)

(b) The table below shows a quotation by JM Enterprises, dealers in

the foodstuff.

MS J M ENTERPRISES
DEALERS IN GENERAL FOODSTUFFS
QUOTATION
SERIAL ITEM QUANTITY UNIT TOTAL
NUMBER (Kgs) PRICE (Ugx) (Ugx)
1 Maize 2 2,400
2 Beans 5 3,000
3 Peas 10 1,500
4 Cassava 6 2,000
5 Lemon 3 1,200
6 Sugar 20 2,500
7 Matooke 4 15,000
8 Groundnuts 4 6,000
9 Passion Fruits 2 4,000
10 Meat 5 4,500
GRAND
TOTAL
VAT (17.5)

(i) Use a spreadsheet software to enter the given data as it is. Save it
as your name and personal number. (07
marks)
(ii) Insert formula to calculate the TOTAL and GRAND TOTAL.
(04 marks)
(iii) Calculate the Value Added Tax (VAT) at a rate of 17.5%.
(02 marks)
(iv) Sort your data by Item in ascending order. (02 marks)
(v) Apply all borders on your work. (02 marks)

4
 (vi) Represent the items and their prices on a Pie Chart. (03 marks)
(vii) Save and print your work. (01 mark)

Turn Over

SECTION B :( 60 MARKS)
Answer any two questions from this section

2. (a) Using any web designing software, design a website for a public
library with the following linked pages:
(i) HOMEPAGE including a marquee. (05 marks)
(ii) CONTACT US PAGE including the location, postal address,
telephone number and email address of the library. (05
marks)
(iii) LIST OF BOOKS available in the library. (05 marks)
(iv) BOARD OF GOVERNORS PAGE showing the management
committee of the library. (05
marks)
(v) FUTURE PLANS. (05 marks)

(b) The website should have a top banner. (02 marks)

(c) Use relevant images where possible. (01 mark)

(d) Save your website as Library and your name e.g Library-Musoke.
(01 mark)

(e) Print your work. (01 mark)

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 the reported cases of malaria and malaria related deaths

5
 in the area from January to June.

Month Reported cases Related deaths

January 80 04
February 100 05
March 98 01
April 87 03
May 70 02
June 60 01

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 presenters’ personal
website.
(06 marks)
(ii) SLIDE 2: Insert the given table. Include a slide title. (06 marks)
(iii) SLIDE 3: Use the information in the table to create a column
chart. (06
marks)
(iv) SLIDE 4: Should include ways of preventing malaria. (04 marks)
(v) SLIDE 5: Conclusion. (02 marks)

(b) Each slide should; (04 marks)

∙ Have your name and personal number as header.
∙ Run every after one minute
∙ Have minimal and appropriate graphics.
(c) Save the presentation as your name and personal number. (01 mark)
(d) Print your slides. (01mark)

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

Artist Real name Stage Sex Date of Music Best Hit Home St
6
 Number Name Birth Category Town w
M001 Musoke Miad Tiger Male 02/03/1980 Ragga Omukwano Kampala 1
M002 Ojok Big Boss Male 01/01/1975 Country Uganda my Gulu
homeland
M003 Namusoke Snake Girl Femal 01/06/1985 Dance Sleeping Pill Masaka 1
e Hall

M004 Magumba DJ Best Male 03/05/1988 RnB Disappointment Kampala 6

M005 Baguma Mr. right Male 03/01/1990 Ragga Good girl Jinja

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

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

Turn Over

(c) Create a form called Entry Form to enter the data. (08
marks)Create a query called Tax query to calculate the tax paid by the
artist. The Tax is 10% of the Stage Worth.
(03
marks)

(d) Create another query showing artists born before 1986 and whose home
town is Kampala. Name it Kampala Artists. (03
marks)

(e) Create a report using Kampala Artists query and name it Kampala Artists
report. (04
marks)

(f) Print all your work in landscape orientation. (02 marks)

7
 END

8
 840/2
COMPUTER STUDIES
PRACTICAL
Paper 2
Oct. / Nov. 2019
21/2 hours

UGANDA NATIONAL EXAMINATIONS BOARD

Uganda Certificate of Education
COMPUTER STUDIES
(PRACTICAL)
Paper 2
2 hours 30 minutes

INSTRUCTIONS TO CANDIDATES:

This paper consists of two sections, A, and B.

Section A contains one compulsory question.

Section B contains three questions. Attempt any two questions from this

section. Any additional questions(s) answered will not be marked.

Each candidate is provided with a new blank Compact Disc (CD)

Candidates should continuously save their work.

Each candidate must produce a hard copy for each of their work to
accompany the Compact Disc (CD)

Turn Over

1
 © 2019 Uganda National Examinations Board

SECTION A (40 MARKS)

This Sections is compulsory.

(a) (i) Using any word processing software, type the document below as
it is and save it as your name and personal number.
(06 marks)

THE EAST AFRICAN ACADEMY AWARDS

MOS Awards

The East African Academy awards, informally known as the MOS Awards®,
are a set of awards given annually for excellence in music, skits and cinematic
achievements. The academy statute is officially named the MOS Awards of
Merit and is a prestigious award of recognition given for excellent performance
in the music and film industry. The East African Academy Awards was set up
to recognize the upcoming artists and improve on young talents.

On the international scene, we have similar awards known as the Oscar Awards

Current Special Awards:

Academy Honorary awards: since 1929

Academy Scientific and Technical Awards: since 1931

Gordon E. Sawyer award: since 1981

Nobel Peace Prize: since 1960

2
(i) Copy and paste the document t the next page and use it to answer
the questions that follow. (01
mark)

(ii) Change the layout of the document to A4 (8.27” x 11.69) and

landscape. (02
marks)
(iii) Format the entire document as follows:

Font size 14 and Alignment justified. (02 marks)

(iv) Create a bulleted list on the Current Special Awards. (01 mark)
(v) Apply Word Art to the subheading MOS Awards. (02 marks)
(vi) Insert the following table that shows the upcoming events of MOS
3
Awards: (03
marks)

4
 Ceremony Date Category Venue
3 MOS Awards 20th July 2014
rd
Kadongo Kamu Kyadondo Rugby
Grounds
5th MOS Awards 20th Sept 2016 Best Drama Sheraton Grounds

(vii) Insert in the table the row below in an appropriate position:

4th MOS Awards 12th May 2015 Best Comedy Nabinoonya Beach
(02 marks)

(viii) Save and print your work.

(01 mark)

(b) The table below shows scores of computer trainees in group 1 at

Mutoro Community Computer Centre.

(i) Using a spreadsheet software application, enter the data in the table
above in a worksheet. Save it as your name and personal number. (05
marks)

(ii) Copy and paste the table to the next sheet. (01
mark) Use suitable formulas/functions to answer questions (iii) – (v)

Turn Over

5
 (iii) Compute the total mark for each student. (02
marks)Compute to 2 decimal places the average mark for each
student.
(03 marks)
(iv) Rank the students, using the average marks. (02 marks)

(v) Draw a column chart to represent the students’ index numbers and
their marks in Word Processing, Presentation and database.
Insert all chart titles. (05 marks)
(vi) Insert your name and personal number as footer. (01 mark)
(vii) Save and print your work. (01 mark)

SECTION B :( 60 MARKS)
Answer any two questions from this section

1. Using Presentation software of your choice, make a presentation

Community Sanitation Week to sensitize the community.
(a) Create four slides as follows:
(i) SLIDE I: Introduction and definition of Community
Sanitation. (04 marks)

(ii) SLIDE II: A bulleted list of components of a sanitary

sensitive home e.g Toilet, Bathroom, Dish rack
and Rubbish bin. (04
marks)

(iii) SLIDE III: Make a two column table to display at least four
good sanitation practices for adults and children.
(06 marks)

6
(iv) SLIDE IV: Display of Clip Art for sanitation tools.
(05 marks)

7
 (b) Insert animations in your slides. (02 marks)
(c) Set the background of your slides with different gradient. (02 marks)
(d) Apply slide transitions of your choice. (02 marks)
(e) Insert the current date and your name and personal number. (01 mark)
(f) Print your slides as handout. (02 marks)

2. The table below shows Jumata Housing Estate’s property for rent.

Housing _Ref Area Type of House Feature Rent per Month (Shs)
H002 South Detached Waterfall 150,000
H006 South Bungalow Pool 200,000
H008 West Bungalow Pond 350,000
H005 South Detached Pool 100,000
H003 North Semi-detached Courtyard 95,000
H004 West Bungalow Fishpond 190,000
H001 South Semi-detached Pool view 600,000
H007 North Terraced Pool view 500,000

(a) Create a database and save it as your name and personal number.
(02 marks)
(b) Design a table with appropriate data types to capture the given table. Set
the Housing_Ref as the primary key for the table. Name it Jumata
Table. (06
marks)

(c) Create a form from the Jumata table and name it as Jumata form. Use
the form form to enter the given data. (04
marks)
8
 (d) Include in the Jumata form a field for calculating a three month rent.
Name the field Total Rent. (04
marks)

(e) Insert your name and personal number as a footer in the Jumata form.
(02 marks)
(f) Design a query to display detached houses in the south. Save it as
Detached. (04 marks)

(g) Sort by Type of House the data in Jumata Table. Save it as Sorted Table.
(04 marks)

(h) Save and print your work. (02 marks)

Turn Over

3. A wild life society would like to create a website to publicize its activities.

(a) Using an appropriate web publishing software, design a website for

the wild life society with the following pages:

(i) Page I: A home page about the society with links to other
three pages. (06
marks)
(ii) Page II: Page title, contact, Vision and Mission. (05 marks)
(iii) Page III: Visitors’ information guide such as; activities,
accommodation, travel guide, photographs and
tariffs. (05
marks)

9
(iv) Page IV: A bulleted list of national parks in the country.
(05 marks)

1
0
(b) Use appropriate graphics to enhance the website. (03 marks)
(c) Insert logo of any animal. (02 marks)
(d) Add a link to email the wildlife society. (02 marks)
(e) Save the website as wildlife. (01 mark)
(f) Print the web pages. (01 mark)

END

1
1
 840/2
COMPUTER STUDIES
PRACTICAL
Paper 2
Oct. / Nov. 2020
21/2 hours

UGANDA NATIONAL EXAMINATIONS BOARD

Uganda Certificate of Education
COMPUTER STUDIES
(PRACTICAL)
Paper 2
2 hours 30 minutes

INSTRUCTIONS TO CANDIDATES:

This paper consists of two sections, A, and B.

Section A contains one compulsory question.

Section B contains three questions. Attempt any two questions from this

section. Any additional questions(s) answered will not be marked.

Each candidate is provided with a new blank Compact Disc (CD)

Candidates should continuously save their work.

Each candidate must produce a hard copy for each of their work to
accompany the Compact Disc (CD)

Turn Over

1
 © 2020 Uganda National Examinations Board

SECTION A (40 MARKS)

This Sections is compulsory.

1. (a) (i) Open a word processing program and typeset the given text
Save it as your name and personal number. (06 marks)

GPS TEXT

The Global Positioning System (GPS) is a space-based navigation system that

provides location and time information in all weather conditions, anywhere on
or near the Earth where there is an unobstructed line of sight to four or more
GPS satellites. The system provided critical capabilities to military, civil, and
commercial users around the world. The United States government created the
system, maintains it, and makes it freely accessible toany one with a GPS
receiver

The US began the GPS project in 1973 to overcome the limitations of previous
navigation systems, integrating ideas from several predecessors, including a
number of classified engineering design studies from the 1960s. The U.S
Department of Defense (DoD) developed the system, which originally used 24
satellites. It became fully operational in 1995. Roger L.Easton, Ivan A. Getting
and Bradford Parkinson are credited with inventing it.

Source: https:// en.wikipedia.org/wiki/Global_Positioning_System

(i) Insert two blank pages after the text. (01 mark)
(ii) Insert page numbers in the document. (01 mark)
(iii) Copy the text to page 3. (02 marks)

2
 (iv) Insert a watermark of your name in the document. (02 marks)
(v) Format each paragraph on page 3 to a hanging indent. (02 marks)
(vi) Add a border around the text excluding the heading and the source.
(02marks)
(vii) Use the font dialog box to increase character spacing of the
heading. (02
marks)
(viii) Add a footer of your name and personal number. (01 mark)
(ix) Save and print your work. (01 mark)

(b) A shop sells furniture to customers on credit. The table below shows
the names of the customers and the cost of the furniture bought.

Customer Cost of Deposit Balance Monthly

Name Furniture ($) Instalments
Kerai 8500
Nitesh 5500
Bongole 9000
Isaac 6300
Fundai 9500
Shingai 6500
Mary 7500

(i) Using any spreadsheet software, enter the given data and save it as
your name and personal number. (04
marks)

(ii) Add an appropriate title for the table. (02

marks) Use suitable formulas /functions in questions (iii) to (v) to calculate:

(iii) Deposit which is 25% of the cost of furniture. (02 marks)

(iv) Balance after deposit. (02 marks)

(v) Monthly instalments which are paid equally in a period of two

3
years. (02
marks)

4
 (vi) On a new sheet, create a fully labeled Pie-Chart using the
customer name and cost of furniture. Name the sheet
Customers. (05
marks)
(vii) Insert your name and personal number as footer. (02 marks)
(viii) Save and print all your work. (01 mark)

SECTION B :( 60 MARKS)
Answer any two questions from this section

(a) A proprietor of three restaurants would like to have a website to

advertise the business.Design a three-page website for the restaurant as
follows:
(i) Home Page: Should include:
- Introduction
- Links to other pages.
- A marquee
- Contact address. (08 marks)

(ii) Page II: should include: A food menu/prices in form of a

table. (08
marks)

(iii) Page III: should include: a four column table to display the
details of the three restaurants. (08
marks)
(b) Insert appropriate graphics in your pages (03 marks)
(c) Save your work as your name and personal number. (01 mark)
(d) Print your work. (01 mark)

5
2. The data below shows information about the sales of fuel to an organization
by a fuel company.

6
 CAR DATE OF COST PER TYPE OF NO OF
REG. NO COSUMPTION LITRE FUEL LITRES
UPX 001 1-JAN-2011 3000 DIESEL 15
UPK 256 5-FEB-2011 3000 DIESEL 17
UPN 111 3-FEB-2011 3500 PETROL 25
UPQ 332 1-JAN-2011 3000 DIESEL 10
UPP 456 3-JUNE-2011 3000 DIESEL 15
UPB 414 15-APRIL 2011 3500 PETROL 12
UPL 606 16-APRIL 2011 3500 PETROL 20

(a) Create a database called fuel_your name and personal number.

(02 marks)
(b) Design a table with the fields in the given table. Use appropriate data
types for each field. Name it Fuel Table. (05
marks)

(c) Enter the given data in the Fuel Table. (05 marks)
(d) Create a form that will be used to add new records. (03 marks)
(e) Insert a calculated field to determine the Total amount to be paid.
(04 marks)
(f) Make a query that will filter cars which consumed 15 or more litres of
diesel. Save it as Diesel. (03
marks)

(g) Sort the data in the Fuel Table according to Total amount in descending
order. (03
marks)

(h) Make a report based on the sorted Fuel Table and save it as
Consumption. (03 marks)

(i) Save and print all your work. (02 marks)

7
3. You are required to design a six-slide presentation on computer hardware.

8
(a) The slides include the following information:
(a) Slide I: The main topic for the lesson and a brief description.
(03 marks)
(i) Slide II: Input devices: Provide a bulleted list of at least
four examples of input devices and their functions.
(04 marks)
(ii) Slide III: Output devices: Give two device and their functions.
(04 marks)
(iii) Slide IV: Storage devices: Tabulate the examples using two
categories, Optical Storage and Non Optical storage
devices. (04
marks)

(iv) Slide V: Communication Hardware. Identify two examples

and briefly how they work. (04
marks)
(v) Slide VI: Revision questions. Outline three revision questions
about computer hardware devices. (03
marks)
(b) Apply a transition to all slides and set them to loop continuously till
escape. (02
marks)
(c) Insert the current date that updates automatically as a footer and your
name and personal number as a header. (03
marks)
(d) Save your work. (01 mark)

END

Print all the six slides on the same page. (02 mark)

9
 840/2
COMPUTER STUDIES
PRACTICAL
Paper 2
Oct. / Nov. 2022
21/2 hours

UGANDA NATIONAL EXAMINATIONS BOARD

Uganda Certificate of Education
COMPUTER STUDIES
(PRACTICAL)
Paper 2
2 hours 30 minutes

INSTRUCTIONS TO CANDIDATES:

This paper consists of two sections, A, and B.

Section A contains one compulsory question.

Section B contains three questions. Attempt any two questions from this

section. Any additional questions(s) answered will not be marked.

Each candidate is provided with a new blank Compact Disc (CD)

Candidates should continuously save their work.

Each candidate must produce a hard copy for each of their work to
accompany the Compact Disc (CD)

© 2022 Uganda National Examinations Board

1
Turn
Over
SECTION A: (40 MARKS)
This section is compulsory

(a) (i) Using a word processing software of your

choice, typeset the text
below and save it as your name and personal
number.

(05 marks)A computer is a device that simplifies work. It is a fast

machine, it stores data and can be used to perform many other
functions.

A desktop computer comes with a system unit , monitor, keyboard

and mouse. All these work together to help a user perform a task.

Today , computers can be used at home, schools, libraries, banks

and many other places.

A student can use a computer to store his work, create a time-table,

and communicate with other students from different campuses etc.

(i) Copy and paste the text to the next page. (01 mark)

(ii) Insert an appropriate heading and format it with any font style and
size. (03
marks)

(iii) Add page numbers in the form of “A, B,…” at the bottom Centre
of the page. (02
marks)

2
(iv) Apply a double line spacing and justify the whole text. (02 marks)

3
 (v) Insert a watermark as your name. (02 marks)
(vi) Set the page orientation to landscape. (01 mark)
(vii) Drop cap the first paragraph. (02 marks)
(viii) Include a header of your name and personal number. (01 mark)
(ix) Save and print your work. (01 mark)

(b) The data below shows the wages paid to casual workers by a
Non- Government Organization.( NGO)

Mukasa earned 700 Dollars and 500 Pounds; Omondi 200 Dollars and
150 Pounds; Bakwasizaki 250 Dollars and 160 Pounds; Mugulusi 500
Dollars and no Pounds; Otema 300 Dollars only; Matyansi 500 Pounds
only and Mudoola Dollars only.

(i) Organize the given data using a spreadsheet software. Save it as

your name and personal number. (05
marks)
(ii) The table below shows the exchange rates of a forex bureau.

MBOGO FOREX BUREAU

Foreign Currency Buying (UGX) Selling (UGX)
US.Dollar($) 3370 3380
POUND STERLING (£) 4375 4395

4
 Note: UGX is Uganda shilling.

Enter the table above on the same worksheet. (02

marks) Use appropriate formulas/functions for questions (iii) to (iv).

(iii) Convert each worker’s wage into Ugandan shillings. (06 marks)
(iv) Determine the highest wage paid. (02 marks)
(v) Draw a column chart showing the workers’ wage in UGX.
(04 marks)
(vi) Save and print your work. (01 mark)

1. The crime prevention department is in the process of sensitizing the

community about Drug Abuse.
(a) You are required to design a six-slide presentation about drug abuse
as follows:
(i) Slide I: Title and name of the presenter. (02 marks)
(ii) Slide II: Explanation of drug abuse. (03 marks)
(iii) Slide III: Causes and effects of drug abuse. (03 marks)

5
 (iv) Slide IV: The data below shows drug abusers in various villages:
Malire (25), Kanaga(40), Kigwa(10), Hawanda(56) and
Kauswa(45). Use a table to illustrate this data. (05
marks)

(v) Slide V: Draw a graph for the data in slide IV. (05 marks)
(vi) Slide VI: Solutions to drug abuse. (03 marks)

(b) Use appropriate graphics to enhance your presentation. (02 marks)

(c) Set your slide show to run automatically. (02 marks)
(d) Insert your name and personal number as footer. (02 marks)
(e) Include slide numbers in the presentation. (01 mark)
(f) Save the presentation as your name and personal number. (01 mark)
(g) Print your work. (01 mark)

2. The table below shows data for some senior one students in a certain school.

Student Last First Date of Nationality PLE

ID Name Name Birth aggregate

6
 101 Achieng Leticia 6/3/1997 Ugandan 6
102 Abassa Daphine 1/1/1998 Ugandan 5
103 Anayo Janet 8/24/1996 Kenyan 7
104 Igaba Joy 2/8/1998 Ugandan 5
105 Namanya Daisy 5/18/1999 Ugandan 6
106 Namigadde Ruth 1/10/1997 Tanzanian 4
107 Ibale Faith 3/26/1999 Kenyan 5
108 Parvin Agatha 2/18/1992 Ugandan 4

(a) Create a database and name it Students Records. (02 marks)

(b) Design a table using the information in the table above and name it
Students Data. (06 marks)

(c) Populate your table with the data given. (06 marks)

(d) Create a query to filter out students who first names start with “D” and
those whose last name start with “I”. Save it as Query 1. (04
marks)

(e) Create a query to retrieve all those students whose dates of birth are
between 1/1/1994 and 1/31/1999; sort the results first names in
ascending order. Save it as Query 2. (04
marks)

(f) Create a form called Student Form using the Student Data table.
Include all fields. (03
marks)

(g) Use the Student Form to enter your personal record with a Student ID
of 109. (02 marks)

7
8
 (h) Generate a report from Query 2 and save it as your name and personal
number. (02
marks)

(i) Save and print all your work. (01 mark)

3. (a) A company wishes to develop a website for its Hotel. Using a web
authoring software, design a website of four pages for the Hotel
as follows:

(i) HOME PAGE: Include the Hotel name, Hotel motto, contact
address and a bulleted list of the services offered by the
Hotel.
(05 marks)
(ii) EMPLOYEES: Include a table of Current Employees and their
contacts. (05
marks)

(iii) BOOKING: Include an online booking form for customers. The

form should include; Name, Address, and Gender. Room Type,
Type of payment (Cash, Credit Card or Mobile Money) and a
submit button. (07
marks)

(iv) BRANCHES: Include names of Hotel branches in other areas.

(04 marks)

9
(a) Create active links to the entire website. (02 marks)
(b) Apply a suitable back ground colour. (01 mark)
(c) Insert relevant graphics to your website. (02 marks)

1
0
(d) Add a Logo for the Hotel. (02 marks)
(e) Save the website as your name and personal number. (01 mark)
(f) Print all your web pages. (01mark)

END

1
1
 UGANDA NATIONAL EXAMINATIONS BOARD
UGANDA CERTIFICATE OF LOWER EDUCATION

INFORMATION AND COMMUNICATION TECHNOLOGY

SAMPLE THEORY PAPER

PAPER I

2 Hours 15 Minutes

Proposed Marking Guide

Section A

1. a) KIDOLE uses a computer to capture information about his business. Of late,

his computer started to slow down and hang during use. Explain an appropriate
solution that Kidole can use to solve the problem with his computer?
- Identification of the problem; The computer could be infected with viruses
with a the OS and a number of programs corrupted.
- Needs to back up all the work on the computer
- Re-install the OS and all other programs (3 scores, 1@)
b) In a school computer lab, learners directly access the files of their fellow
students. What appropriate measure can be used to improve security of the
computer files?

- Identify the various users and create user logins.

- Provide backup options where copies of deleted files can be retrieved. (2 scores, 1@).

2. i) Describe how each of the following devices can be used for delivering a lesson
in Biology.

A B C
 A. Printer: Prints documents to guide discussions.
B. Projector: Gives shared views while learning.
C. Speakers: Sound projection while watching a video or listening to an audio. (1 Score
each).

ii) Explain any two precautions that should be observed while using any of the devices in
i) above.

- Handle with care.

- Remove from power when not in use
- Use an UPS for protection against power surges (Any 2@ 1 score) (2 scores)
3. (a)

Statement Device
A device used to convert a hard copy into soft copy Scanner
file
A device used to output the contents of an MP3 file speaker
at a party
A device for producing coloured images for a plotter
billboard

(b) A LaserJet printer uses tonner to form images on the sheet of paper/print media. The
printer creates a beam of light in form of the image to be printed. The beam of light heats the tonner
and the particles melt forming an image on the print media/paper.
The inkjet printer sprays droplets of ink onto the print media to form the required image or text.

4. (a) A computer uses system software and application software. Explain the
difference between these two categories of software. (2 scores)
Systems software is a set of programs that manage the way a computer
operates whereas application software refers to programs that solve end users’
specific problems such as word processing, managing data, etc

(b) Jane tried to install a new programme on her computer. She got an error
message “you do not have sufficient storage space”. She has had this computer
for more than 5 years.
Share with Jane three different pieces of advice on how to address the challenge.
(3 scores)
- Try uninstalling unwanted programs on the computer to free some space.
- Run Disk Clean up. You can free disk space by deleting files that you do not need.
- Use disk compression utility. This helps you add more hard disk space.
 - Perform a clean boot. This reduces conflicts related to software that can bring up the
root causes of the insufficient disk space error as a result of apps and services that
start and run in the background when Windows starts normally.
- Boot in Safe Mode. Safe mode starts up your computer with limited files and drivers
but Windows will still run. (Any 3 points)

5. A User logs on to his laptop computer using a thumb print and password. He
does not connect it to open wireless networks. He always tells his colleagues that
“a
laptop is a personal device not for sharing”.
a) Share your personal views on why the User;
i) logs in with both a thumb print and a password. (1 score)

To provide double security.

ii) avoids open wireless networks.

Avoids intrusion into the user’s laptop through the network. (1 score)

(a) Give one importance of:

(i) Computer Authentication (1 score)
Authentication helps organisations to keep their networks secure by allowing only authorised
users (or processes) to access its protected resources, which may include computer systems,
networks, databases, websites and other network-based applications or services.
(ii) Data Confidentiality (1 score)
Data Confidentiality protects the disclosure of information by ensuring that the organisational
data is limited to those authorised individuals.

(iii) Data Integrity (1 score)

Data integrity also refers to the safety of data in regard to regulatory compliance and security.
The importance of data integrity is protecting data loss or a data leak. In order to keep your
data safe from outside forces with malicious intent, you must first ensure that internal users
are handling data correctly.

6. (a) Explain the key role for each of the following stakeholders in managing e-
waste in your community.
(i) Management authorities (1 score)
- Release of regulation
- Planning
- Operation of the system
- Environmental inspection

(ii) Collectors (1 score)

- Collection of the e-waste
- Submission to qualified recyclers
 (iii) Waste disposers (1 score)

- Incineration of hazardous material and waste

(b) Share any two societal challenges that are as a result of poor e-waste
management (2 scores)

- Water pollution
- Air pollution
- Electronic waste contains toxic components that are dangerous to human
health, such as mercury, lead, cadmium, barium and lithium

7. The school computers in the computer laboratory are having a problem of

limited storage space.
(a) Suggest three ways of solving this problem. (3 scores)

- Extend Drive with Unallocated Space

- Clean Junk Files
- Clean Large Files
- Transfer Large Files to an External
- Uninstall applications which are no longer in use
(b) The teacher of ICT in a school in Uganda stores his files on Drop Box and
Google Drive. Suggest any two challenges he is likely to face. (2 scores)
- Risk of data confidentiality
There is always a risk that user data can be accessed by third parties if data and cloud
protection systems are not good. Depends on internet connection. The internet is the
only way to cloud computing. When there is no internet connection in your place, or
the internet path to the cloud provider is in trouble, automatically access to your cloud
computing machine will be disconnected.
- The level of security
Not being in control of our own systems’security. Secrecy and security are among the
most doubtful things in cloud computing. By using a cloud computing system means
we have fully entrusted the security and confidentiality of data to companies that
provide cloud computing services.
- Vulnerable in the event of an attack
There are lots of arguments against cloud computing one of which is that because the
Cloud Computing services are online, they are exposed to a wide range of attacks
online which may be difficult to control. Technical problem
Managing cloud computing services depends on the efficiency of the service providers
and availability of customer support all of which is not in direct control of the user.

8. Two competing companies A and B produce similar products. Company A

reaches out to customers using printed flyers and billboards around the
community while company B has active Facebook and Titter platforms.
(a) What are the likely advantages of Company A over Company B? (2 scores)
 - Flyers and billboard advertising favour all categories of people whether
literate or illiterate unlike company B which favours only the elite
class.
- Accessing information using flyers and billboards on the side of the
population does not cost anything since flyers are given to them free of
charge unlike social media information access where the audience
needs internet services to access information.
- Advertising using billboards makes a huge and eye catching advert unlike
social media platforms.
- There is increased frequency of consumer exposure when using flyers
and billboards unlike social media platforms.

(b) What are the likely advantages of Company B over Company A? (2 scores)
- Editing in the final product can be done in a matter of seconds.
- There is worldwide coverage in terms of market.
- The costs of online advertising are fairly low compared to those of print.

(c) Which of the two approaches would be appropriate for SELLING company
products in your community and why? (1 score)
Advertising using flyers and billboards is the most appropriate approach in my area
because not all people are computer literate.

OR: The use of Facebook and Twitter is appropriate where the users are ICT literate
and have the appropriate ICT services.

9. Students of Senior One shared complaints of having backaches, headaches and

painful shoulders as a result of participating in a computer training workshop
that lasted one week.
(a) Explain the possible causes of
(i) backaches (1 score)
Caused by over bending and not using the right furniture while using
computers.
(ii) headaches (1 score)
- Using computers for long hours without breaks
- Too much light emitted by the screen/monitor
- Too much noise from the systems unit
(iii) painful shoulders (1 score)
Sitting at a desk with your arm in an outreached position in order to use your mouse
for long periods of time.
(b) Share your advice on how any two of the above challenges can be avoided by
the students. (2 scores)

How to avoid (any two @1 score):

 backache
- Use proper furniture when using computers (swivel chairs)
- Get breaks while using computers
headache
- Get breaks while using computers
- Reduce monitor light/antiglare screens
- Need to replace computer fans which make
noise. painful shoulders
- Use proper furniture (i.e. chair and table) while using computers
- Exercise your limbs regularly while using computers.
10. (a) Fill in the table below with the appropriate tool for each of the functions. (3
scores)

Function Tool
Reading thumb prints at the workplace Finger print scanner/biometric scanner
Measuring the temperature of a domestic Thermometer
animal
Reading prices of commodities at a point of Bar code reader
sales

(b) Imagine you have been assigned a task to prepare a presentation about
germination of a bean seed. Identify the ICT tools you would need to collect data
and what you would use each tool for. (2 scores)
- Camera/video recorder - For recording pictures of germination
- Web cam/camera – For recording data/pictures about germination
- Laptop/desktop – For capturing data and keeping data to use during
the presentation
- I-Pad – for capturing data and keeping data to use during the presentation
- Tablet – for capturing data and keeping data to use during the presentation

SECTION B

Answer any two questions from this section.

11. Imagine you were dropped in the middle of a forest. You are not able to identify
where you are. In your pocket, you have a functioning smartphone that has no sim
card in it. You realise that it can access an active hot spot for an abandoned camping
site nearby. Write down a detailed step by step account of the steps you would take
to get yourself out of the forest back to safety? (15
scores)
 - Connect my phone to the active hotspot
- This is meant to connect me to the internet
- Turn on the GPS on my phone
- Open Google maps on my phone
- Type the name of my residence or the nearest trading centre e.g. Kyambogo
University
- Specify that I am walking on the Google map
- Tap directions and choose start
- This facility will show me my current place and will provide directions I need
to take to my desired destination.

Any five logical steps @ 3 scores

12. Bruce works as a secretary at a law firm. His work requires him together with 20
other colleagues to work on a computer for more than 8 hours a day, six days a
week. Each of these employees can work for a maximum of 3 days a week and then
take a break. The office policy allows anyone in office to work on a case at hand
irrespective of who created its documents. At times they are forced to collaborate in
order to get the same understanding about the case. As a student of ICT,
(a) Guide Bruce and his colleagues on how they can store files in a way that allows
them to work effectively. (7 scores)
- Use removable storage devices like flash disk where one can save and
share the storage media with their colleagues.
- Use of well labelled folders on the office computer where all the
colleagues can access files.
- Use online collaborative means of creating, editing and saving files e.g.
using Google docs.
- Joint online storage of office files where all the workers have the online
account credentials for accessing and editing of office files e.g. using
Google drive

(b) Advise Bruce on how he can reduce chances of getting health related challenges
that may come as a result of his work environment. (8 scores)

Preventing computer-related overuse injuries

Tips to avoid overuse injuries of the hand or arm include:

 Have your mouse at the same height as your correctly positioned keyboard.
 Position the mouse as close as possible to the side of the keyboard.
 Use your whole arm, not just your wrist, when using the mouse.
  Type lightly and gently.
 Mix your tasks to avoid long, uninterrupted stretches of using the computer.
 Remove your hands from the keyboard when not actively typing, to let
your arms relax.

Preventing eyestrain from computer use

Tips to avoid eyestrain include:

 Make sure your main source of light (such as a window) is not shining
into your face or directly onto the computer screen.
 Tilt the screen slightly to avoid reflections or glare.
 Make sure the screen is not too close to your face.
 Put the screen either at eye level or slightly lower.
 Reduce the contrast and brightness of your screen by adjusting the controls.
 Frequently look away from the screen and focus on faraway objects.
 Have regular eye examinations to check that any blurring, headaches
and other associated problems are not caused by any underlying
disorders.

Preventing injury from laptop computers

Tips to reduce laptop dangers include:

 Use a correctly set-up desktop computer instead of a laptop as often as you can.
 Use peripheral equipment, such as a docking station, separate keyboard,
mouse and laptop stand.
 Take frequent breaks.
 Carry your laptop in a backpack or in wheel-along luggage.

13. Imagine you are at a camp site in a remote village and realise the many features
near the camp site are what was required for your Geography coursework. You
need to take a number of photos of these features because they will be helpful in
your coursework. You only have access to two devices with you. A new digital
camera that does not have a memory card in it but has internal storage that can
accommodate about 5 images and a laptop whose webcam is faulty. Both laptop and
camera support Bluetooth technology. You need to take not less than 30 photos for
the coursework to be fully covered.

Explain in detail how you can get all the necessary photos without leaving the
camp site? (15 scores)
- Turn on the phone’s Bluetooth and pair it with the laptop Bluetooth
- Take the first five photos using the camera by saving them on its
internal memory space.
- Using Bluetooth feature on the laptop, set it to receive a file.
- Send the files from the phone to the laptop.
- Delete the remaining copies on the phone to free space.
- Take new pictures using the camera.
- Repeat the procedure of sending files to the laptop from the phone
through Bluetooth technology until all the required pictures have been
taken and saved on the laptop.
Any five pts - @3pts = 15 scores
END
 UGANDA NATIONAL EXAMINATIONS BOARD
UGANDA CERTIFICATE OF LOWER EDUCATION

INFORMATION AND COMMUNICATION TECHNOLOGY

SAMPLE PRACTICAL PAPER

PAPER 2

PAPER 2 (PRACTICAL)

TIME: 2 HOURS AND 30 MINUTES

Instructions to Candidates

This paper is made up of two sections, Section A and Section B.

Section A is compulsory and takes 50 marks. You are required to attempt the two questions
in this Section.

Section B is made of three equally weighted questions. Each has a maximum score of 25
marks. Attempt any two questions.

Support files, where necessary, are provided.

Save your work on a CD for submission and also include printouts.

 Section A (50 Marks)
This section is compulsory.
Question 1: Word processing
i) A tree planting company wants to have their first issue of a tree planting
magazine. You are required to word process the available text based on the
following instructions to make the article readable.
ii) Using a suitable Word processing software package, load the file Tree planting.txt
iii) Set the page size to A4.
iv) Set the page orientation to landscape.
v) Format the entire document into three equally spaced columns, with a 4 mm
gap between the columns with a ‘Times New Roman’ font style.
vi) Set text to 1.5-line spacing
vii)Set the text to fully justified.
viii) Set the font size to 11 points
ix) Insert an appropriate image on the first page with text wrapping around its
right side only.
x) Format only the first page of the document as a single column
xi) Insert a centre aligned heading ‘Tree Planting Protects the Environment’ on
the first page with text font size 70 points and double underlined.
xii) Insert below the heading the words “Edited by <<Your full name>>” right aligned.
xiii) Locate the text “SUSTAINABLE PLANTATIONS” and ‘FORESTS ARE OUR
JEWELS’ and format them as headings. They should appear in upper case.
xiv) Create a footnote at your name. The information in the footnote
should contain your personal number.
xv) Place an automated page number
xvi) Insert a well visible page border around the entire document.
xvii) Save your work as ‘Tree Growing’ and print.

Question 2: Spreadsheets
MMM secondary school has just had their end of year examinations. The results for the
different subjects are in the document named results.docx. You are going to analyse these
results using a suitable spreadsheet software and answer the following questions.
i) Load the contents of the file Data.docx into a suitable spreadsheet application
ii) Insert your name and index number as the middle header.
iii) Determine the total score for every student.
iv) Determine the average score for each of the students and correct to two
decimal points.
v) Use the Rank Function to assign each student a position in class.
vi) Create a word document and save it with the file name Results.docx
 vii) Take a screen shot of your work and paste it in Word document Results.docx.
viii) Show the formulas used to calculate and take a screenshot and paste it
in Results.docx.
ix) Using any function of your choice, insert a comment column which automatically
assigns “Good performance” for the participants above Average 70, “Fair
performance” for the participants above average 50 and “Needs improvement” for
average 50 and below.
x) Create a column graph on a new sheet summarising the participants’
performance showing their average scores.
xi) Format the chat with the following:
a. appropriate chart title
b. data label on each column
c. horizontal axis
d. vertical axis
xii) Display the table of scores used in the graph below the graph for easy
interpretation by the management.
xiii) Determine the modal mark for the class in all subjects and indicate it in
the Results.docx.
xiv) Save your work as MDD (your name) and print your work on A4.

Submit the printouts for Results.docx, final excel sheet on A4, and soft copies of the
work done.
 SECTION B (50 marks)
Answer any two questions from this section.

Question 3: Database Management System

In this question you will design and create a database using the following information.
A community library has been opened in your area to promote the reading culture among
school going children. After one week of operation, the librarian realised that a number of
children share the same names and borrowed the same title of books. As a result, the
librarian is not able to track books borrowed. Part of the information on borrowed books is
shown in the table below.
First Last DOB Gender Book Title Author Date Return
Name Name borrowed date
Apio Susan 12/9/2004 F Introduction Patel D 20/7/2021 4/8/2021
to French
Book 2
Apio Susan 12/9/2004 F Vegetable Dhawal S 22/5/2021 6/6/2021
Growing
Apio Susan 12/9/2004 F Introduction Patel D 18/9/2021 2/10/2021
to French
Mbaine Moses 8/8/2005 M Introduction Patel D 10/4/2021 24/4/2021
to French
Mbaine Moses 13/6/2003 M Vegetable Dhawal S 20/11/2021 4/12/2021
Growing

i) Design and create a suitable database that will allow a single student to
borrow more than one book at a time. Your database should also have a
provision for:
a. STATUS attribute for the librarian that will hold that data “RETURNED”
or “NOT RETURNED”.
b. accept letters F or M for gender.
ii) Help them to create an interface in the program that can be used to enter more data.
iii) Generate a report that shows only the First Name, Last Name, Age in years,
Book title, Author and Status.
iv) Students born after 2005 are not supposed to vote. Generate a report of those
who were supposed to participate in voting.
v) Print all reports generated.
Question 4: Presentation
You are going to create a presentation on learners’ evaluation of ICT based on information
in the support file PRESDOC.DOCX. All slides of your presentation should have a
consistent
look (layout and formatting). The slides must display a title and bulleted list unless
otherwise stated.
i) Create a presentation of 6 slides using the file PRESDOC.DOCX
ii) Format slide 1 so that
a. its layout is for a title slide.
b. both the title and sub title are centred on the same slide
c. Your name appears after the text prepared by:
iii) Format the entire presentation so that the following features appear on all slides
to give the presentation a consistent look.
a. have a company logo saved as NCDC LOGO.PNG
b. your name, random number and index number
c. automatic slide number and date in the footer.
iv) Create a bar chart using data provided in the file DURATION.CSV
v) Format the chart with
a. appropriate labels for the horizontal axis and vertical axes.
b. chart title.
c. place the chart at an appropriate slide in the presentation.
vi) Insert a new slide between slide 4 and slide 5. Insert a column graph based on
the data below.
Level of Year of Assessment
proficiency in ICT 2019 2020 2021
Excellent 14 56 70
Very good 36 54 65
Basic 35 43 20

vii)Comment on the level of proficiency in ICT over the period 2019 to 2021 on
the same slide.
viii) Apply uniform animations and transitions in your presentation.
ix) Print a copy of your presentation showing 4 slides on each page.

Question 5: Web designing/Desktop Publication

In this question, you will design a website with four pages.
Healing hospital located on Plot 23 Kampala Road has approached you to design a website
for them. The hospital management wants a four-page website which will market its
services to the outside world. The hospital address is P.O Box 3454 Kampala, email is
healinghospital@gmail.com, Facebook page is www.facebook.com/healinghospital,
Telephone number is +256707665582.
 i. Using the support content in support folder, design their website showing the
staff page, how to contact them and the services they offer.
ii. A well designed banner should appear on the four pages
iii. The website should have well hyperlinked navigation buttons to take the
visitor back and forth.
iv. The links i.e. hospital email address and the Facebook address should be
well actively linked.
v. The telephone number for the hospital should keep moving from one side
to another.
vi. Save your website as Healing hospital website and print the pages.

END
Information and Communication Technology
Paper 2
Sample examination

⁄ Hours

UGANDA NATIONAL EXAMINATIONS BOARD

Uganda Certificate of Lower Secondary Education
Information and Communication Technology

Paper Two (Practical)

2 hours 30 minutes

Proposed Marking Guide

Section A
Marking Guide for Question 1: Word Processing
SKILL BEING TESTED SCORE
Ability to load the .txt file into a word processing software 1
Setting the page size to A4 1
Set page orientation to landscape 1
Setting the page to three columns 1
Adjusting columns to have a gap of 4mm 2
Changing font style to Times New Roman 1
Changing line spacing to 1.5 1
Text fully justified 1
Font size changed to 11 points 1
Inserting an image 1
Wrapping text to the right of the image 1
Inserting a section at end of page 1 (at the right place) 1
Changing the first page back to one column 1
Typing text “Tree Planting protects the Environment” in the right 1
place
Formatting the text to 70 points, centre aligned 1
Inserting a double underline 1
Inserting the words “edited by << students name>>, right aligned 1
Locating the text “sustainable plantations” and “Forests are our 2
jewels” and changing them to look different
Formatting the words “sustainable plantations” and “Forests are 1
our jewels” as headings.
Creating a Footnote on the name 1
Placing automated page numbers 1
Inserting a visible page border 1
Evidence of a printed copy of the work 1
TOTAL 25

Marking Guide for Question2: Spreadsheets

SKILL BEING TESTED SCORE
Ability to load data into a spreadsheet application 1
Name and Index number in the header 1
Formula used to determine total score 1
Correct total score filled for all students 1
Formula used to determine average score 1
Correct average score filled for all students 1
Rank function used correctly 1
Rank function used to get positions for whole class 1
Screenshot showing totals, average and position pasted in the word 1
document
Screenshot showing formulae used 1
Use of the any of the following functions, If Function, HLookup or 2
Vlookup correctly
Creating a column graph with the right values (Average scores) 2
Formatting the chart with appropriate chart title 1
Formatting the chart with data labels 1
Formatting the chart with label for horizontal axis 1
Formatting the chart with label for vertical axis 1
Table of scores displayed below the graph 1
Modal mark is stated and correct (1 for formula and 1 for correct 2
mark)
Soft copies submitted 1
Excel sheet printed 1
Excel sheet fits on A4 (scaling the document) 1
Results.docx document printed 1
TOTAL 25

Section B
Marking Guide for Question 3: Database Management Systems
SKILL BEING TESTED/ Maximum mark) Attribute SCORE
Designing an appropriate database (8 marks)
A relational database with two tables, each Two tables each with 4
record having a unique primary key, correct use appropriate attributes
of Foreign Key
Use of Primary keys in 2
each table
Proper use of a foreign 2
key in the books table
Application of knowledge on data types (2 Data types well used 2
marks) in the designed table
Data types not well 1
used but database can
work

Inserting given data into the database (3Marks) All data correctly 3
inserted into database
Data inserted with 1
errors
Data not inserted 0
Having a status attribute in the database (2 Status column with the 2
marks) appropriate data type
Status column with 1
inappropriate data
type
Data validation on the Gender attribute(2 Validation rule well 2
marks) used
Interface for data entry (4 marks) Form for entering 2
student data
Form for entering 2
books data

Report Report shows data 3

from the two tables
Report shows data 1
from only one form
Date calculations (1 mark) Report shows that age 1
of the student by use
of date calculation
formula
Generating the voters register (1 mark) Voters register 1
generated

Printing (2 marks) Print out for each of

the report
TOTAL 25
Question 4: Marking Guide for Presentation
SKILL BEING TESTED SCORE
Ability to load content from an external document 2
Changing layout of slide 1 to title slide 1
Centre align text on title slide 1
Adding text to a presentation 1
Giving the entire presentation a consistent look
- Evidence of using the master slide 2
- Consistent background achieved 1
- Consistent appearance of a logo on all slides achieved 1
- Consistent appearance of name of creator 1
- Adding appearance of a random number 1
- Appearance of an index number on all slides 1
- Appearance of automatic slide number on all slides 1
- Appearance of automatic date on all slides 1
Creating a bar chart based on information given 1
- Chart formatting with chart title 1
- Horizontal and vertical labels 2
- Placing the chart on the right slide to co-exist with the text 1
Ability to insert a new slide at the right position 1
Creating the right chart from the information given 1
Appropriate comment about the chart produced 1
Appropriate animations across the presentation 1
Evidence of slide transitions 1
Slides printed showing 4 slides on every page 1
TOTAL 25
Marking Guide for Question 5: Web design/Desktop publication
SKILL BEING TESTED SCORE
Creating four web pages 4
Creativity on the choice of content to use 2
Different designs used 2
Creation of navigation buttons 2
Hyperlinks in the navigations button 3
Use of images on different pages 2
Creation of a uniform banner 2
Hyperlinking email address and url i.e. Facebook 2
Insertion of the marquee 2
The contrast of the text with the background 2
Saving and printing 2
TOTAL 25

= = = = = = = = = = = END= = = = = = = = = =
 ELECTRONIC SPREADSHEET I & II (NLSC)

Item I

You are working as a data analyst for a retail company. You have been given a Microsoft Excel
workbook containing multiple worksheets. Each worksheet represents sales data from different
regions (North, South, East, and West) for the past year. Your manager asks you to summarize
the total sales for each region and present the data in a single consolidated worksheet within the
same workbook.

Questions:

1. Explain the process you would follow to summarize the total sales data from each
regional worksheet and consolidate it into one worksheet. How would you ensure that
the data is accurately represented?
2. In the process of consolidating the data, you decide to use a combination of formulas
and functions. Describe the difference between a formula and a function in Excel.
Provide examples of each that you might use in this task.

Item II

Your team needs to present the quarterly sales performance to the company’s executives. You
have prepared a worksheet with detailed sales figures, but you now need to create a visual
representation of the data and share it with your team.

Questions:

1. Describe the steps you would take to create a chart that shows the quarterly sales
performance for each region. Which type of chart would you choose and why?
Explain how labels, values, and cell references will be used in the creation of the
chart.
2. Once the chart is created, you need to share this information with your team. Discuss
the options available in Excel for sharing a workbook. What considerations should you
keep in mind regarding data integrity and access permissions when sharing the
workbook?

https://ictconnect.org @ictconnect|©2024 1|Page

 840/2
COMPUTER STUDIES
PRACTICAL
Paper 2
Oct. / Nov. 2006
22/4 hours

UGANDA NATIONAL EXAMINATIONS BOARD

Uganda Certificate of Education
COMPUTER STUDIES
PRACTICAL
Paper 2
2 hours 15 minutes

INSTRUCTIONS TO CANDIDATES:

This paper consists of two sections, A, and B.

Section A contains one compulsory question.

Section B contains four questions. Attempt any one question from this section.

Each candidate is provided with a new formatted 3.5” diskette of high

density.

Each candidate must produce a hard copy for each of their work to accompany
the diskette.

Self help wizards must not be used.

1
 Turn Over
© 2006 Uganda National Examinations Board

SECTION A (40 MARKS)

This section is compulsory.

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

TUBERCLOSIS (TB) IN AIDS.

The global war on AIDS could be lost if the world 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 wold has made defeating AIDS its top priority. This
is a blessing but TB remains ignored”, said Mandela. He steered clear
controversay to focus on the plight of millions suffering from HIV and TB

About 14 million pple are infected with HIV and T.B. 70% living in
Sub-Saharan Africa, the region hardest hit by HIV/AIDS, which has killed
20 million people worldwide. HIV, the virus which causes AIDS, destroys
the immune system and makes patients more vulnerable to diseases such as
TB, an infectious, 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
worfully 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 to page 2. (02 marks)

2
 (iii) Using the copy on page 2, centre, bold and underline the heading
and make it font size 24. (03
marks)

(iv) Centre align the third paragraph and make it all italics. (02 marks)

(v) Italicize the source of this document and make it font size 8.
(02 marks)

(vi) Spell check your document. (02 marks)

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

(viii) Save your work as my work. (01 mark)

(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. (03 marks)

(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. (05
marks)
(iii) Draw a bar chart to represent the sales of the companies.(05 marks)
(iv) Determine the total sales for each month. (04 marks)
(v) Insert your name and index number in (ii) and (iii) above.
(02 marks)
(vi) Save your work on floppy diskette as my spreadsheet. (01 mark)

SECTION (60 MARKS)

3
Attempt any one question from this section.

4
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. (10 marks)

Staff payroll

Staff No. Surname First Name Sex Department Salary

UTS652 Natukunda Emily 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 Turn
Over

540,000
(b) Create a form using staff table in (a) above and use it to input the records
above. Save the form as Staff form. (16
marks)

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

(d) Create a report using query 1 table. (10 marks)

(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.
(14 marks)

5
3. Gapro is a big time industrial firm dealing in the production of various
industrial goods such as iron sheets, angle and iron bars, metallic doors and
windows and many other related products. It sells its products in local markets
and in markets

6
 in some neighbouring countries. Local outlet branches are in Kampala, Jinja,
Mbale and Arua. Regional branches are in Nairobi, Dar –es-salaam and Kigali
and neighbouring countries. The firm is managed by four managers in addition
to the executive general manager. This include 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. (10
marks)
(ii) A page on the production and marketing of the various products of
the firm. (11
marks)
(iii) A page linking the local and regional markets for the firm’s
products. (11
marks)
(iv) Minimal graphics showing the functions and the products of the
firm. (11
marks)
N.B The website should:
(i) Have a link for the firm’s e-mail address. (03 marks)
(ii) Be well linked. (05 marks)
(iii) Be creatively designed. (06 marks)
(iv) Include your name and index number on the first and last pages as
footer. (02
marks)
(v) Save your work as Gapro. (01 mark)
4. As an educational 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 districts and Uganda. (09
7
 marks)
(ii) Slide II: Content (types of education) (09 marks)
(iii) Slide III: Benefits and achievements of education. (10 marks)
(iv) Slide IV: Short comings of education and conclusion. (09 marks)

8
 (v) Save your presentation as “Education”

N.B Insert a relevant graphic on each slide. (10 marks)

⎯ Set your slides to have suitable background. (04 marks)

⎯ Include your name and index number on each slide as header. (04 marks)
⎯ Set the slides to run automatically. (04 marks)
5. Using any available web publishing software, design a hotel’s homepage.
Make sure the homepage is very impressive but not too slow to download.

You are expected to include the following:

(a) A page title. (05 marks)

(b) Appropriate graphics. (10 marks)
(c) A 100-120 word text. (15 marks)
(d) A link (for the hotel’s email address). (03 marks)
(e) Table-showing at least four services offered by the hotel. (12 marks)
(f) Layout (06 marks)
(g) Creative designing. (08 marks)
(h) Save your work as Hotweb. (01mark)

END

9
 840/2
COMPUTER STUDIES
PRACTICAL
Paper 2
Oct. / Nov. 2009
21/4 hours

UGANDA NATIONAL EXAMINATIONS BOARD

Uganda Certificate of Education
COMPUTER STUDIES PRACTICAL
Paper 2
2 hours 15 minutes

INSTRUCTIONS TO CANDIDATES:

This paper consists of two sections, A, and B.

Section A contains one compulsory question.

Section B contains four questions. Attempt any one question from this section.

Each candidate is provided with a new formatted 3.5” diskette of high density
or a blank compact disc-rewritable

Each candidate must produce a hard copy for each of their work to
accompany the diskette or compact disc.

Self help wizards must not be used.

1
 Turn Over
© 2009 Uganda National Examinations Board

SECTION A: (40 MARKS)

This section is compulsory.

1. (a) (i) Type the following information as it is: (use font 14)

The time table below will be out by the beginning of next academic year. It
should be copied and filled with relevant subjects.

Senior Four Time Table 2010

8:00- 9:00- 10:3 11:3 2:00- 3:00-
9:00 10:0 BR 0-11: 0-12: LU 3:00 4:00
0 30 30
EA NC
K H
Mon
Tues
Wed FREE
Thur
Fri
Sat

(14 marks)

Note: The outer boarders are (3) triple lines.

(ii) Put a footer as your name and index number. (02 marks)

2
 (iii) Colour “Senior Four Time Table 2010”, “BREAK”, “LUNCH”
and “FREE” green (02 marks)

(iv) Save your work as your name and index number. (01 mark)

(v) Print your work. (01 mark)

(b) The following students sat for their term two examinations in
Mathematics (mat), Computer Studies (comp) and Commerce (com)
and obtained the following marks:

John got 49 in mat, 20 in comp and 50 in com, Mary got 90 in mat, 60 in

comp and 30 in com. Tania got 70 in mat, 65 in comp, and 90 in com.
Samuel got 55 in mat, 40 in comp and 80 in com. Paul got 50 in mat, 20
in comp and 55 in com. Albert got 50 in mat, 60 in comp and 50 in com.

(i) Enter the data given in spreadsheet. All names should be in column
A. (04 marks)
(ii) Use a formula to compute the total for each student and put in
column E. (02
marks)
(iii) Sort the data entered in column E in descending order. (02 marks)

(iv) Put the titles for column A, B, C, D and E in orientation 450.

(02 marks)
(v) Boarder your data and give it a professional look. (02 marks)
(vi) Draw a bar/column graph for the students’ marks in the three
subjects. (05
marks)
(vii) Save your work as your name and index number. (01 mark)
(viii) Print your work. (02 marks)

SECTION B: (60 MARKS)

Answer any two questions from this section.

2. (a) Create a table using design view with the following fields: NAME,
DATE OF BIRTH, SEX, RELIGION and FEES BALANCE. Set

3
the

4
 name field as the primary key and save the table as “Candidates Table”.
(06 marks)

(b) Create a form to enter the records below and save the form
as “Candidates Form”

NAME DATE OF BIRTH SEX RELIGION FEES BALANCE

Tina T Jan,02,90 F Catholic 40,000
Golfer J Feb,20,89 M Moslem 60,000
Bob Baller Mar,13,88 M Protestant 55,000
Alice Cricketer Apr,04,89 F Protestant 20,000
Sam Big. Jun,03,90 M Catholic 25,000
Janifer J Feb,04,87 F Adventist 90,000
Klez B Jul,05,98 M Catholic Turn Over

40, 000
(c) Create a query displaying all the students whose names begin with letters
‘B’ and ‘T’. Save it as “BT query”. (04
marks)

(d) Create another form in “Design View” with all the available records in
the given table in (b). Name it “ Design View Form” (06
marks)

(e) Generate a report for the above table with FEES BALANCE in
descending order. Use columnar layout and portrait as the report
orientation. Name this report “Columnar Report 1”. (06
marks)

(f) Save your database as your name an index number. (02 marks)

3. You are required to make a presentation to a group of web design students

about the following multimedia features, namely
(i) Video
(ii) Hyperlink
(iii) Sound

Include the following information about each of the components.

Video/Movie clips

Video clips are added to enhance your presentation. This can show authentic
5
movement or simulated movement, which makes the presentation more
interesting. Movement is either by click of mouse or automatic.

6
 Hyperlinks

A hyperlink is an element in an electronic document that links to another place

in the same document or to an entirely different document. Typically, you click
on the hyperlink to follow the link. Hyperlinks are the most essential
ingredients of all hypertext systems, including the World Wide Web.

Sound

Sound as with video or movie clips, is added to enhance your presentation. If

for example , your presentation is about weather, a sound clip of thunder can
be added. Clicking on the sound clip will activate the sound.

(a) Create a presentation in which each concept (i) (ii) and (iii) is on its own
slide. Enhance this with a graphic of your choice. (21
marks)

(b) The first slide should contain links through action buttons to each other
slide. (07
marks)
Note:
Each slide must contain a link to the first slide, through an action button.

(c) Include your name and index number on each slide and save your work.
(01 mark)
(d) Print your slides. (01 mark)
4. Using any available web publishing software, design a web site about
your personal information.
(a) Create a home page for your personal information with appropriate links
to other following pages. (05
marks)
(b) Create other pages with the following information.

Page I: Page title, Bio-data e.g. name, age, nationality, and religion.
(04 marks)

Page II: At table of schools attended, period of attendance and

qualification acquired. (04
7
marks)

8
 Page III: A bulleted list of activities and responsibilities held e.g head
prefect. (04 marks)

Page IV: Hobbies and special skills. (04 marks)

Note:

(i) Create a moving (marquee) page title. (02 marks)

(ii) Use appropriate graphics. (02 marks)
(iii) Insert a personal email address (email hyperlink) on the home
page. (02
marks)
(iv) Save your work as your name and index number. (01mark)
(v) Print your work. (02 marks)

END

9
 840/2
COMPUTER STUDIES
PRACTICAL
Paper 2
Oct. / Nov. 2011
21/4 hours

UGANDA NATIONAL EXAMINATIONS BOARD

Uganda Certificate of Education
COMPUTER STUDIES PRACTICAL
Paper 2
2 hours 15 minutes

INSTRUCTIONS TO CANDIDATES:

This paper consists of two sections, A, and B.

Section A contains one compulsory question.

Section B contains three questions. Attempt any one question from this section.

Each candidate is provided with a new formatted 3.5” diskette of high density
or a blank compact disc-rewritable

Each candidate must produce a hard copy for each of their work to
accompany the diskette or compact disc.

Self help wizards must not be used.

1
 Turn Over
© 2011 Uganda National Examinations Board

SECTION A: (40 MARKS)

This section is compulsory.

1. (a) (i) Using a word processor of your choice, typeset the following passage
as it is. (06
marks)

SAVOURY POTATO CAKES

Ingredients:

500g cooked and mashed potatoes

120g grated cheese

Salt and pepper

60g flour

Cooking oil

1 tablespoon Royco Mchuzi mix

Mix the mashed potatoes well with the Royco, flour, salt and pepper

Roll out onto a flour board and cut it into rounds using a biscuit cutter.
Heat the oil in a frying pan and fry the cakes until golden brown.

Remove from the fat and drain. Sprinkle cheese on top of each cake
and put under grill until golden brown too.

Serve hot. If you do not have a grill, put the cakes on a clean chopping
board or metal tray. Put large, hot coals on a wire rack or mesh and hold it
closely over the cakes until the cheese melts and turns golden brown.
2
 You can serve 6.

[Adapted from Maria Murore-Daily Monitor Saturday May 5th 2007,

Page 11, Col 5.]

(ii) Apply a 6 point shadow text board around the typeset document.
(02 marks)

(iii) Bullet the list of the ingredients. (01 mark)

(iv) Apply colour green on the heading, centre it and change front to
13.5”. (02 marks)

(v) Double space and justify and the body of the text. (02 marks)

(vi) Set page margins to 1.8” left, 1.5” right 1.5” up and 1.6” bottom.
(02 marks)

(vii) Create one other page of the same page without retyping. (01 mark)

(viii) Number the pages in upper case alphabet. (02 marks)

(ix) Save your work in your name and index number. (01 mark)

(x) Print your work. (01 mark)

(b) The table below shows examination results of senior four students.

STUDENT’S NAME CLASS BOT MID TERM EOT FINAL

(X/10) (X/20) (X/70) MARK
Mugaga B. S4B 06 14 41
Matovu K. S4A 07 17 49
Bwavu S S4C 05 10 35
Ayub Irene S4C 08 12 40
Rehema Paul S4B 04 15 44
Allen Bob S4A 08 16 48
Alex T. S4A 09 17 51
Timothy K S4B 08 18 55
Nakonkona M. S4C 06 16 50

3
 NB: - BOT= Beginning of term mark and EOT = End of term mark
- The final mark is a summation of BOT, MID-TERM and EOT.

(i) Enter the students’ data above in a spreadsheet program.

(06 marks)
(ii) Determine the final score for every student by use of a form.
(02 marks)
(iii) At the end of the table in the empty row after Nakonkona M, insert
a formula/function in the “FINAL MARK” column, to determine
the best student. (03
marks)

(iv) Insert a header “STUDENT PERFORMANCE” and center it.

(02 marks)
(v) Copy and paste your work to another worksheet. (01 mark)
(vi) Insert a blank row between Alex. T and Timothy K. (01 mark)
(vii) Plot a bar graph of the final mark against the student. (03 marks)
(viii) Save your work as your name and index number. (01 mark)
(ix) Print your work. (01 mark)

Turn Over

SECTION B: (60 MARKS)

Answer any two questions from this section.

2. The table below shows food items purchased at Kirinya S.S.S. create a
database to manage Kirinya Food Supply.

ID NAME FOOD CONTACTS QUANTITY UNIT TOTAL

ITEM IN STOCK PRICE COST
(Shs)

4
 U001 Okidi Matooke 0772-459890 03 7,000
U002 Jemba Lumonde 0772-999999 02 15,000
U003 Kizimula Flour 0752-928012 05 200,000
U004 Mukiibi Beans 0712-606063 05 120,000
U005 Mukalazi G.nuts 0782-777770 03 180,000
U006 Owinyi Oil 0712-404440 05 40,000
U007 Dembe Peas 0411-000020 03 40,000
U008 Mukankunsi Rice 0412-282780 02 70,000
U009 Mugenyi Soya 0782-215964 01 50,000
U010 Mukyala Sim-Sim 0752-215946 03 80,000

(a) Create the table above, enter the data and name it Kirinya S.S.
(10 marks)
(b) Make a form showing ID, name, quantity in stock, Unit price and it
“Suppliers Form” (06
marks)

(c) Use the form to compute each of supplier’s total cost. (03 marks)

(d) Design a query to filter suppliers whose contacts begin with “077” and
“078”. Name it “Suppliers’ query I.” (06
marks)

(e) Design another query to extract food items whose unit price is above
Shs120,000 and save it as “Suppliers query II.” (05
marks)

3. (a) Assuming that you are standing for the post of headboy/headgirl, make a
four-slide presentation with relevant data about the major areas you
would focus on while campaigning. (16
marks)

(b) In addition, show the following on all your slides.

5
(i) Uniform and pleasant text colours (02 marks)
(ii) Different text styles and sizes for different slides. (02 marks)
(iii) Footer as your name and index number on all sides. (02 marks)
(iv) Header as “ECHART OYEE” on all slides. (02 marks)

6
 (v) Clip art . (02 marks)
(vi) Automated animations and transition schemes. (01 mark)

(c) Save your presentation using your index number. (01 mark)

(d) Print your work. (02 marks)

4. (a) Using a web publishing application, publish a website for your

district with the following pages.
- Homepage. (05 marks)
- District administration page (04 marks)
- Education page giving schools in the district. (04 marks)
- Economic activities page for economic activities like farming,
fishing, manufacturing, trade, etc. (04
marks)
- Social activities page for leisure activities, family life in the district,
religion etc. (04
marks)
- District problems page to cater for things like, deforestation, food
shortage, pests, diseases etc. (04
marks)

NOTE:
You are expected to include the following on all your pages:

(i) Relevant graphics.

(ii) Appropriate background, font sizes and colour.
(iii) Attractive layout

(b) (i) Insert your email address (mail to hyperlink) on the homepage.
(02 marks)

END

(ii) Save your website using your name. (01 mark)

(iii) Print your work. (02 marks)

7
 840/2
COMPUTER STUDIES
PRACTICAL
Paper 2
Oct. / Nov. 2012
21/4 hours

UGANDA NATIONAL EXAMINATIONS BOARD

Uganda Certificate of Education
COMPUTER STUDIES PRACTICAL
Paper 2
2 hours 15 minutes

INSTRUCTIONS TO CANDIDATES:

This paper consists of two sections, A, and B.

Section A contains one compulsory question.

Section B contains three questions. Attempt any one question from this section.

Each candidate is provided with a new formatted 3.5” diskette of high density
or a blank compact disc-rewritable

Each candidate must produce a hard copy for each of their work to
accompany the diskette or compact disc.

Self help wizards must not be used.

1
 © 2012 Uganda National Examinations Board
Turn Over

SECTION A: (40 MARKS)

This section is compulsory.

1. (a) (i) Using a word processor, type the text below as it is. (04 marks)

Do not wish to be anything else, but what you are and try to be that
perfect.

No problem can stand the assault of sustained thinking.

The worst bankruptcy in the world is the person who has lost enthusiasm.

A man’s success is not how much money he has made, but what kind of
family he has brought up.

Luck is what happens when preparation meets opportunities.

The heart of learning is the will to try.

(ii) Copy the text you have typed and paste it below the first copy.
(02 marks)

(iii) Format the copied text with double line spacing. (02 marks)

(iv) Insert an auto shape object, fill it with a light colour and order it
behind text. (03 marks)

(v) Draw a thick 6pt line to separate the two copies. Colour the line
red. (03
marks)

2
 (vi) Insert bullets on the second copy. (02 marks)

(vii) Insert your name, index number and “©” symbol as footer.
(02 marks)

(viii) Save and print your work. (02 marks)

(b) The following workers of Dell Construction Company had their basic
salary as follows:

Name Age Basic Transport Lunch Gross pay Tax Net pay
(shs) allowance
Joy 35 120,000
Maria 23 150,000
Tricia 30 300,000
Lyton 25 150,000
Tania 19 450,000
Immy 33 250,000
Tom 41 250,000
Andrew 40 170,000
Michael 38 180,000
Gorreth 39 200,000
Martha 22 120,000
Angella 20 150,000
3
 Patrick 19 200,000

(i) Using a spreadsheet application, enter the above data in a

worksheet. (04
marks)

(ii) Using suitable formulae, compute the following:

- Transport allowance at 8% of Basic. (02 marks)
- Lunch at 12% of Basic. (02 marks)
- Gross pay as the total of Basic, Transport allowance and Lunch.
(02 marks)
- Tax at 15% of Gross pay. (02 marks)
- Net pay as the difference between Gross pay and Tax.
(02 marks)
(iii) Put all boarders on your data. (02 marks)
(iv) Sort the names alphabetically. (02 marks)
(v) Save your work as your name and print your work. (02 marks)

Turn Over

SECTION B: (60 MARKS)

Answer any two questions from this section

2. Your family has requested you to present a show about the services offered in
a supermarket called “Family Supermarket”
(a) Make a five-slide presentation to enhance your

show. SLIDE I- Opening slide to include the

▪ Title (name of the supermarket)

▪ Location and address. (04 marks)
▪ E –mail address.

SLIDE II- Goods offered. (04 marks)

4
 SLIDE III- Discount on imported fruits and foods. (04 marks)

SLIDE IV: Services offered

▪ Transportation of goods offered if they exceed Shs50,000

▪ Foreign exchange
▪ Telephone services. (04 marks)

SLIDE V-Make a new company logo and motto.

-A list of other branches and their addresses. (04 marks)

(b) Save your work as your name. (01 mark)

(c) Insert your index number and surname as footer. (02 marks)
(d) Link all your slides. (01 mark)
(e) Use appropriate clip art, word art graphics and colour. (04 marks)
(f) Print your slides. (02 marks)

3. There is an initiative to fight corruption in Uganda. You have been

approached to help design for an organization which fights corruption.

Using available software, design a website for the organization

- Make the website impressive

- Be creative
- Use appropriate graphics
- The website should be able to load faster.
- Each page should have a link to the author’s name.
(a) The homepage should have a short story on the definition of corruption
and the ways corruption is practiced. Include three links on your
homepage. (10
marks)

(b) The linked page in (a) should have the following information.
- Page II should include the list of causes of corruption. (06 marks)
- Page III should include the effects of corruption on the society.
(06 marks)
- Pages IV should include the list of solutions to corruption.
(06 marks)

5
 (c) Save your work as “Corruption” and print your work. (06 marks)

4. The table below is a record of employees in a school canteen.

First Surname Sex Date of birth Telephone Home number

name numbers
Margaret Bukirwa F 02/16/1967 079-427-878 P.O Box 2776
Kampala
Joel Bena F 12/17/1970 079-492-579 P.O Box 433 Masaka
Ronnie Ogwang M 07/28/1980 077-945-343 P.O Box 444 Kampala
Ethel Bogere F 10/03/1979 072-008-342 P.O Box 435 Jinja
Liz Wamusu F 02/25/1985 088-344-589 P.O Box 4345
Kampala
Juma Ali M 11/12/1977 088-345-342 P.O Box 455 Kampala

(a) Create a database and save it as ‘Canteen”. (02 marks)

(b) (i) Design a table using the fields names indicated above making the
“Telephone Number” field as the primary key. Save it as “Staff
record” (06
marks)

(ii) Create a data entry form, save it as “Data entry”. (04 marks)

(iii) Fill the form background with yellow colour. (02 marks)

(iv) Populate the table with the data given using the form created.
(06 marks)

(c) Sort the records in the table in descending order of the surnames.
(02 marks)
(d) Using all the fields, create a query showing the female employees and
name it “staff names” (05
marks)
(e) Create a report showing the “surname” and the “Telephone Number” of
the employees. (03
marks)

END
6
 840/2
COMPUTER STUDIES
PRACTICAL
Paper 2
Oct. / Nov. 2013
22/4 hours

UGANDA NATIONAL EXAMINATIONS BOARD

Uganda Certificate of Education
COMPUTER STUDIES PRACTICAL
Paper 2
2 hours 15 minutes

INSTRUCTIONS TO CANDIDATES:

This paper consists of two sections, A, and B.

Section A contains one compulsory question.

Section B contains three questions. Attempt any one question from this section.

Any additional questions(s) answered will not be marked.

Each candidate is provided with a new formatted 3.5” diskette of high density
or a blank compact disc-rewritable

Each candidate must produce a hard copy for each of their work to
accompany the diskette or compact disc.

Self help wizards must not be used

1
 © 2013 Uganda National Examinations Board
Turn Over

SECTION A: (40 MARKS)

compulsory Question

(a) (i) Using a word processor, create the table below as it is: (05 marks)
K

A
L
G

B
M
D
H

C J N
E
F

(ii) In part A insert: “Quality Chemicals” in bold, font size 16, font
style, Arial and centred. (02 marks)

(iii) In part B insert: “Acids” in bold italics, font size 14, font style,
Times New Roman. (02
marks)

(iv) In part D insert: “Alkalines” size 17, font style Arial, centred.
(02 marks)

(v) Fill parts. G, H, I, J with light blue, pale yellow, light green and red
respectively. (03
marks)

(vi) In part K insert: “Handle with care”; and part L insert ; “keep in a
2
safe place.” (02
marks)

3
 (vii) In parts M and N type: “Example of an acid: Sulphuric acid”;
and “Example of an acid pH: positive and negative” respectively.
(01 mark)

(viii) Save your work on the storage media given as ‘chemicals’

(01 mark)

(ix) Print your work. (02 marks)

(b) The table below represents prices of commodities in various markets in

a particular town.

A B C D E F
1 COMMODITY MARKET 1 MARKET 2 MARKET 3 MARKET 4
2 Rice 1,000 1,100 1,950 1,100
3 Sugar 1,700 1,650 1,710 1,800
4 Meat 2,500 2,200 2,700 2,800
5 Salt 400 450 500 410
6 Oats 1,200 1,100 1,150 1,210
7

(i) Enter the data as it is in a spreadsheet program. Use formula to

calculate the average price of each and insert your answer in
column F. Save your entries as “market prices”. (07
marks)

(ii) The prices of all commodities in markets 1 and 3 have been levied
a Value Added Tax (VAT) of 17%. Use a formula to calculate the
new price after VAT and put them in columns H and I. Label them
“Market 1 and VAT” and Market 3 with VAT” respectively. Save
changes. (05
marks)

(iii) Create a column graph representing the prices of sugar in the given
markets. Save it in the same spreadsheet. (04
marks)

4
 (iv) Put your name as the Header and the index number and date as
Footer on all copies of your work. (02
marks)

(v) Print your work. (02 marks)

Turn Over

SECTION B: (60 MARKS)

Answer any two questions from this section

1. (a) Create a database, “computer class” containing a table “students” with

the following database structure. Use a suitable field as the primary key
and print your structure. (08 marks)

Field Name Data Type Field Size

Student ID Text 4
Name Text 20
Class Text 2
Fees Paid Number Integer
Birthday Date/Time -
Address Text 30
Interests Text 50
CA member Yes/No -
Remarks Memo -

(b) Enter the data below into the student’s table, save and print your database.

5
 Student Names Form Fees Birthday Address Interests CA Remar
Id member
0123 Lule.S 4A 150,000 1986/04/23 Kabale Basket ball No ⎯
1034 Otto G. 4A 110,000 1986/07/11 Jinja Skipping Yes ⎯
1031 Oda L. 4B 40,000 1986/01/19 Mbale Hiking Yes Monito
0029 Namuli M. 4B 25,000 1986/12/13 Kampala Reading Yes ⎯
0366 Asiku P 4A 165,000 1986/10/08 Kampala Reading Yes Monito
0115 Matovu E 4B 200,000 1986/03/14 Kotido Cycling No ⎯
1002 Asiimwe 4A 80,000 1986/08/22 Mbale Eating Yes Prefect
0333 Kayanja. E 4B 50,000 1986/04/23 Mbale Skipping Yes ⎯
0246 Madada. F 4A 200,000 1986/10/29 Mbale Skipping Yes ⎯
Kasolo.E 4B 135,000 1986/03/23 Kasese Swimming Yes Prefect

(10 marks)

(c) Create a query which will display the names and class of the students
who are interested in reading. Print he results of the query. (06
marks)

(d) The total fees for form 4 is Shs.200,000/=. Create a query which will
display the names of students who have paid less than half of the fees.
Print the results of the query. (06
marks)

2. Quantichem is a chemical factory which manufactures agricultural chemicals.

It sells its products of a national and international levels. It has four
departments as follows:
▪ Administration: Has three managers, one administrator, one secretary
and two support staff.
▪ Accounts department: Has two accountants and one clerk.
▪ Production department: Has three managers and 20 workers.
▪ Marketing department: Has one marketing officer and four salesmen.

As a website designer you are requested to create and design a website for the
company.

Create a web page consisting of the following:

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

7
 (b) A page on the:
(i) Production department, detailing the variety of
chemicals produced.
(ii) Administration department detailing the different managers
and their roles. (04 marks)
(iii) Marketing department, detailing where the products are sold.
(04 marks)
(c) A products photo gallery showing the various products and objectives
of the company.
(Note: The pictures do not have to be the real ones but closely related)
(d) In the website:
(i) Include a feedback provision where a visitor to the page can send
an e-mail. (03
marks)
(ii) Write your name and index number at the end of the last page as a
header. (02
marks)
(iii) Save the file as “ chemical products” (02 marks)
(e) Print your work. (02 marks)
3. The Environment Management Association has commissioned you to
educate schools in the northern region of the country about the importance of
environment society.
(a) Use appropriate graphics/pictures in each slide as follows;
(i) Slide I should have the introduction of the topic. (08 marks)
(ii) Slide II should have the content of the topic. (08 marks)
(iii) Slide III should have the relevance of safeguarding our environment.
(08 marks)
(b) Include your name and index number as the bottom of each slide.
(02 marks)
(c) Save your presentation as ‘Environment”. (02 marks)

(d) Print your work. (02 marks)

8
 840/2
COMPUTER STUDIES
PRACTICAL
Paper 2
Oct. / Nov. 2014
21/2 hours

UGANDA NATIONAL EXAMINATIONS BOARD

Uganda Certificate of Education
COMPUTER STUDIES PRACTICAL
Paper 2
2 hours 30 minutes

INSTRUCTIONS TO CANDIDATES:

This paper consists of two sections, A, and B.

Section A contains one compulsory question.

Section B contains three questions. Attempt any two question from this section.

Any additional questions(s) answered will not be marked.

Each candidate is provided with a new flash disk or a blank

compact disc-rewritable

Candidates should continuously save their work.

Each candidate must produce a hard copy for each of their work to
accompany the flash disk or compact disc.

1
 Turn Over
© 2014 Uganda National Examinations Board

SECTION A: (40 MARKS)

This section is compulsory.

1. (a) (i) Type the following document using a word processing program.
(06 marks)

HOW TO EDIT A DOCUMENT IN WORD

Entering Text

Once you have a new document open in word, you can immediately
begin inputting text by clicking within the document window and typing.

The font, font colour, font style, font size and line spacing will vary
depending on any customization that have been made to the normal.dot
template.

However, if no customization have been made, the following will

apply to the text you type:

○ Times New Roman font.

○ 12 point.
○ Black font colour
○ Plain font style
○ Single line spacing

Text will appear at the location of the cursor and will wrap to the next line.
Pressing the return (or enter) key will end the paragraph and you begin typing
on a next line.

Editing Documents
Editing documents in word is just as simple as entering text in a blank
document. By clicking within the body of the document, you can add text. By

2
 default, overwriting is turned off, which means text to the right of the insertion
point will be moved to the right.

In the event that you accidentally delete part of your document, you can use the
Undo feature (Ctrl + Z) to undo up to 100 changes you have made to your
document.

(ii) Copy the document you have typed and paste it on page 2.
(02 marks)

(iii) Using the copy on page 2, change the heading to a font size 20 and
underline with a double line style. (02
marks)

(iv) Change the bulleted text in paragraph one to be numbered using

Roman Numerals. (02
marks)

(v) Move the paragraph which starts with the word Text to the end of
the document and make the background yellow. (02
marks)

(vi) Insert your name as header and your index number as a footer.
(02 marks)

(vii) Insert a print watermark with the text UNEB 2014. (02 marks)

(viii) Save and print your work. (02 marks)

1 (b) A school canteen has the data below as the sales records for the months
of May, June, July and August.

May Sales: Cakes-50 packets, Biscuits 2500 packets, Chocolates-

450 packets, Sweets-4500 packets.

June sales: Cakes-78 packets, Biscuits-2300 packets, Chocolates-

250 packets, Sweets-2500 packets.

July sales: Cakes-76 packets, Biscuits-2600 packets, Chocolates-

510 packets, Sweets-3000 packets.

August sales: Cakes-60 packets, Biscuits-2000 packets, Chocolates-500

3
packets, Sweets-2800 packets.

4
 (i) Enter the data given in a suitable spreadsheet program. Use months
as columns. (04
marks)
(ii) Using formulas find the:
- Total number of packets for each item sold in the four months.
Label this column “totals”. (04 marks)
- Average unit sales per month per item. Label this column
“averages” (04 marks)
(iii) Draw a pie-chart showing the monthly chocolate sales in
percentages. Include your index number below the pie
chart.
(05 marks)
(iv) Print your table and pie-chart. (02 marks)
(v) Save your work as ‘sales” (01 mark)

Turn Over

SECTION B: (60 MARKS)

Answer any two questions from this section.

2. You have been given a contract a four-page website for a school in your district.
(a) Design the pages as outlined below:

Page I: Name of the school, contact address and any Clip Art to
represent the school buildings. (06
marks)

Page II: Location:- this should include the district, division and a
simple autoshape drawing of a school map showing the
direction of the school. (06
marks)

Page III: A simple form for the interested parents to fill for their
children on-line. It should include Name, Class, Age,
Nationality, Religion, Parent’s name and Contact. (06
marks)

5
 Page IV: It should show the organisations that are friends to the school.
(06 marks)

(b) Use appropriate working links. (02 marks)

(c) Save your web pages as ‘school web” (02 marks)

6
(d) Print your work. (02 marks)

Table 1: House

The tables below show information about DOMINO HOUSING ESTATE. Use
the information to answer the questions that follow.

House House Price ($) Area Beds Garage comments

Reference Type
32140 DH6 124,950 Rich 4 2 Easy to reach
34612 AA3 93,000 Rich 2 1 Spacious rooms
35478 TH5 53,950 Brill 3 1 End Terrace
36725 DH7 127,950 Brill 5 2 Ground floor good
37865 DH7 149,950 Tile 4 2 Glazed
37896 DH7 125,000 Rich 5 0 3 Storeyed

Table Address House Comments

2: reference
Owner

Name
Sharma H 6, Rommer Groove Richton 32614 Urgent new job
Jarrat, P.T 18, Railes Richton 34614 New instruction
Eisen, H 23 Forest drive, Brillhurst 35478
Mailer, T.V 65, Wittering Lane, Tilemech 36725 Contract ends 18/04
Seale, M.J Old Chapel Tilemesch 37865
Miraz, J.Z 27, Compton Red, Richton 37896 Quick sale required

(a) Create database and name it “DOMINO HOUSING ESTATE.”

(02 marks)
(b) Design, using appropriate data types, two tables and enter the
given data. (09 marks)

7
 (c) Create a query that will return Name, House-Type, as DH7
address, a house with 2 garages, and the price and call it. Type.
(06 marks)
(d) Design a form for each of the two tables and name them “House
Form” and “Owner form” respectively. (08marks)
(e) Generate a report for the query Type in (c) and name it Report
Type. Print a copy of the report. (05
marks)

3. (a) Create a suitable four-slide show presentation about your home town.
Use the following four areas
(i) Name and location of your home town.
(ii) Economic activities
(iii) Education activities
(iv) Health services. (16 marks)
(b) Incorporate the following in your slide show presentation design:

(i) Appropriate colour schemes and background. (02 marks)

(ii) Appropriate animations and transitions for viewing your
presentation. (02
marks)
(iii) A loop to make your show continuous until you press esc on the
keyboard. (02
marks)
(iv) A footer as your name and index number on all your slides.
(03 marks)
(c) Save your presentation using your name and index number. (02 marks)

END

(d) Print your slides. (02marks)

8
840/2
COMPUTER STUDIES
PRACTICAL
Paper 2
Oct. / Nov. 2015
21/2 hours

UGANDA NATIONAL EXAMINATIONS BOARD

Uganda Certificate of Education
COMPUTER STUDIES PRACTICAL
Paper 2
2 hours 30 minutes

INSTRUCTIONS TO CANDIDATES:

This paper consists of two sections, A, and B.

Section A contains one compulsory question.

Section B contains three questions. Attempt any two question from this section.

Any additional questions(s) answered will not be marked.

Each candidate is provided with a new flash disk or a blank

compact disc-rewritable

Candidates should continuously save their work.

Each candidate must produce a hard copy for each of their work to
accompany the flash disk or compact disc.

1
 © 2015 Uganda National Examinations Board
Turn Over

SECTION A: (40 MARKS)

This section is compulsory.

1. (a) (i) Using the tab facility in a word processor, rearrange the data below
in three columns of ; NAME OF STUDENT, SCHOOL and
POINTS SCORED. (08
marks)

Namuleme Shanin of Kakoora Academy scored 128 points; Walakira

Ambrose from Lubanga memorial school got 234 points, Mivule Charles
from St.Anthony S.S S scored only 101 points; Nantongo Tanma from
Christ the King S.S S got 449 points; Luwalira Michael from Rise and
Shine college got 341 points; Mikolo Charles also from Rise and Shine
college got 128 points; Kimuli Faith also from Lubanga Memorial School
got 128 points,

(ii) Highlight the student with the highest score using any colour.
(02 marks)

(iii) On the next page, insert a three-column table to tabulate the same
given data. (02
marks)

(iv) Insert a row above your table and the type the heading
MUBENDE DISTRICTS SPORTS ACTIVITIES. (02
marks)

(v) Sort the data in the table in descending order according to the
POINTS SCORED. (02 marks)

(vi) Insert a header and footer as your name and personal number.
(02 marks)

2
 (vii) Save and print all your work. (02 marks)

(b) The following as a payroll of a school in Nangabo Sub County.

3
 TEACHER BASIC HOUSING GROSS TAX NET MODE OF
PAY ALLOWANCE PAY 30% PAY PAYMENT
PAULA 250,000
JANE 450,000
TIM 840,000
JAMWA 650,000
ALEX 880,000
PROSIE 150,000
DANIELA 120,000
OYITA 380,000

(i) Enter the data in a spreadsheet. (03 marks)

(ii) Study the information below and use it to complete the given table.
∙ HOUSING ALLOWANCE is 40% of BASIC PAY.
(02 marks)
∙ GROSS PAY is the summation of BASIC PAY and
HOUSING ALLOWANCE. (02 marks)
∙ TAX is got using absolute cell referencing, and it is 30% of
GROSS PAY. (02 marks)
∙ NET PAY is GROSS PAY minus TAX. (02 marks)
∙ Teachers whose NET PAY is less than 400, 00/= their mode
of payment is CASH otherwise CHEQUE.

Use the IF function to determine the MODE OF PAYMENT.

(03 marks)

(iii) Create a column chart representing TEACHERS and NET PAY.

(04 marks)
(iv) Save your work as your name and personal number. (01 mark)
(v) Print your work (01 mark)

SECTION B: (60 MARKS)

Answer any two questions from this section.

2. Exploration of oil Uganda has yet to take root. The Ministry of Energy and
Industry would like to have a website to enable it run its activities. Using
any

4
 web authoring software, design a website for the Ministry which includes the
following information.
(a) An index page with the name of the Ministry and logo of your choice,
appropriate to oil exploration. (06
marks)

(b) Design the following pages and add links from the index page.
(i) The oil resources areas. (04 marks)
(ii) The oil mining companies. (04 marks)
(iii) The oil refining areas. (04 marks)
(iv) Other mining ventures by the Ministry. (04 marks)

Turn Over

(c) The website should also include the following:

(i) Your name and personal number at the end of the first page.
(02 marks)
(ii) A marquee with the OIL EXPLORATION on the index page.
(02 marks)
(d) Save the website as EXPLORATION. (01 mark)
(e) Print your work. (02 marks)

3. The table below shows members of a Mathematics club.

CODE STUDENT NAME CLASS DATE MEMBERSHIP FEE

M001 MUSOKE D. S1 03-Feb-07 2500
M002 KAGWA V. S4 05-Feb-08 4500
M003 MAGALA P. S2 05-Mar-09 10000
M004 OPIO S. S6 06-Feb-03 2400
M005 CHEBET A. S5 06-May-05 1450
M006 BIKWASIZEHI F. S2 08-Jun-08 3500
M007 NAMAGULU D. S3 07-Jun-04 3000
M008 OKALEBO S. S1 03-Jan-07 4500
M009 AMOOTI M. S4 06-May-08 4600
M010 OYITA P. S6 09-Sep-08 8000
5
 M011 OSINDE D S1 07-May-08 6500
M012 MASABA P. S3 06-Feb-07 8500
M013 GUDDI H. S4 06-May-07 6500
M014 BAGOMBEKA S. S5 05-Jun-09 8500
M015 BEHANGANE D. S2 04-Mar-06 9500

(a) Create a database called Schools Math Club. (02 marks)

(b) In the database, create a table called Mathematic Table with the given
fields. Assign relevant data types. (06
marks)

(c) Populate your table with the given data. (10 marks)

(d) Create a form in design view to be used for entering new members in the
table in the following years. Name the form Math Form. (04
marks)

(e) Create a report with the names in ascending order, tabular layout and
casual style. Name it Mathematical Report. (04
marks)

(f) Create a query to filter out all those members from S1. Name it S1 Math
Query. (02
marks)

(g) Print all your work. (02 marks)

4. Farming is the most important activity in Uganda. Majority of Ugandans

rely heavily on farming to survive. As a concerned Ugandan, you are
6
required to make a presentation on farming.
(a) Create four slides with the following
(i) A title slide with the topic and definition of farming. (04 marks)

7
 (ii) A text slide with the problems faced by farmers in Uganda.
(04 marks)
(iii) A text with step taken by the government to solve farmer’s
problems. (04
marks)
(iv) A two column text slide showing a list of cash crops and a list of
food crops grown in Uganda. (05
marks)
(b) In your presentation:
(i) Use appropriate transitions. (02 marks)
(ii) Use appropriate animation scheme to view the show. (02 marks)
(iii) Set up the show to run automatically. (02 marks)
(iv) Apply clips and Word Art where necessary. (02 marks)
(c) Insert a footer as your name and personal number on each slide.
(02 marks)
(d) Save your presentation as Farming in Uganda. (01 mark)
(e) Print your slides. (02 marks)

END

8
 840/2
COMPUTER STUDIES
PRACTICAL
Paper 2
Oct. / Nov. 2016
21/2 hours

UGANDA NATIONAL EXAMINATIONS BOARD

Uganda Certificate of Education
COMPUTER STUDIES
(PRACTICAL)
Paper 2
2 hours 30 minutes

INSTRUCTIONS TO CANDIDATES:

This paper consists of two sections, A, and B.

Section A contains one compulsory question.

Section B contains three questions. Attempt any two questions from this

section. Any additional questions(s) answered will not be marked.

Each candidate is provided with a new blank Compact Disc (CD)

Candidates should continuously save their work.

Each candidate must produce a hard copy for each of their work to
accompany the Compact Disc(CD)

Turn Over
© 2016 Uganda National Examinations Board

1
 SECTION A (40 MARKS)
This Sections is compulsory

1. (a) Using a word processor, type the text below as it is. Save it as
Music(Your name and personal number) e.g. Music-Musoke 012.
(05 marks)

Music is an art form whose medium is sound and silence. Its common elements
are pitch (which governs the melody and harmony), rhythm and (and its
associated concepts tempo, meter, and articulation), dynamics, and the sonic
qualities of timbre and texture.

The creation, performance, significance, and even the definition of music vary
according to culture and social context. Music can be divided into genres are
often subtle, it is sometimes open to personal interpretations, and occasionally
controversial. Within the arts, music may be classified as a performing art, a
fine art and auditory art. It may also be divided among art music and folk
music.

(ii) Make a copy of the text to the next page. (01

mark) On the copy you have made perform the following tasks.

(iii) Copy the first word “Music” and paste it as a centered heading
with font size 48. (02 marks)

(iv) Format the text in three columns except the heading. (02 marks)

(v) Justify the text. (01 mark)

(vi) Put a 6pt border around the page. (02 marks)

(vii) Change the font size to 14pt. (02 marks)

2
 (viii) Insert a diagonal Watermark of your name. (02 marks)

(ix) Insert a centered page number s page X of Y e.g. Page 1 of 2.

(02 marks)

(x) Save and print your work. (01 mark)

(b) The table below shows results of some students of senior four in
Kibbe High School.

NAME ENGLISH PHYSICS COMPUTER MATH TOTAL AVERAG

Opio James 80 87 85 85
Alinda John 45 65 56 78
Kasumba Alex 78 32 25 12
Achieng Nice 15 88 98 12
Mukama Roy 42 81 65 45
Mukasa Fred 15 47 32 45

(i) Using an spreadsheet application of your choice, enter the above

data on sheet1 and rename the sheet as S4B. (04
marks)

(ii) Using formulas, determine the total and average mark for each
student. (04
marks)

(iii) Make a copy of the table to sheet 2 and name it S4B New.
(01 mark)
(iv) Insert BIOLOGY column ENGLISH and PHYSICS. Fill it with
the following marks;77, 42, 75, 12,39 and 12 respectively. (02
3
marks)

4
 (v) Sort your data in ascending order according to TOTAL. (01 mark)
(vi) Skip one row after the last student and enter the word HIGEST
MARK. Determine the highest mark for each subject. (02
marks)

(vii) Construct a Pie-chart using only the students’ names and

COMPUTER marks. (02
marks)

(viii) Insert your name and personal number as header and footer.
(02 marks)
(ix) Save your workbook as Results (your name) e.g. Result-Musoke.
(01 mark)

Turn Over

Print all your work. (01 mark)

SECTION B :( 60 MARKS)
Answer any two questions from this section

2. You have been selected to make a presentation about sports in Uganda.

(a) The presentation should have five slides as follows:
(i) Slide I: The topic presented and brief information about the
presenter. (04
marks)

5
 (ii) Slide II: Sports activities in the country. Use pictures and Clip
Art to make your slide attractive. (04
marks)

(iii) Slide III: Make three column table showing your favorite Sports
against your favorite Player and his/her country of
origin. (07
marks)

Sports Benefits in Uganda.

Nationalism hence Unity

Foreign exchange earning

Income for sportsmen

Revenue for the government

(iv) Slide IV: Use the organization chart and enter the chart
of benefits shown below. (07 marks)

Slide V: Problems and challenges of Sports in Uganda. Insert a

relevant clip art and send it behind text. (04
marks)

(b) Insert your name and personal number on each slide. (02marks)
6
(c) Save and print your work. (02 marks)

7
3. The General Manager for a newly established hotel called ROOT-TOP
has approached you to design a website for the hotel. You have been
guided to include the following:
∙ Location of the hotel
∙ Services provided
∙ Daily menu and other necessary information
(a) Design a five-page website with the following details:
(i) HOME PAGE: Containing the banner, introduction, location
and contacts for the hotel. (05 marks)

(ii) PAGE 2: showing the services provided by the hotel

including accommodation, entertainment,
meals, conference and seminar venues.
(05 marks)
(iii) PAGE 3: containing a sample of the menu served.
(04 marks)
(iv) PAGE 4: containing the advert for various vacancies in
the hotel. (04 marks)

(v) PAGE 5: showing daily news and a weekly program.

(05 marks)
(b) Use appropriate graphics and background colors. (02 marks)
(c) Put active links that can allow one to move through the website.
(02 marks)
(d) Save your website as your name and personal number. (02 marks)
(e) Print your work. (03 marks)

8
 Turn Over

4. TOPAZ is one of the secondary schools in Uganda with both local

and international students.
(a) Create a database called TOPAZ and your first name e.g. TOPAZ-JANE.
The database is to be used to manage student’s records. (02
marks)

TOPAZ STUDENTS TABLE

Using the details below, create a TOPAZ STUDENTS TABLE.

Field Name Data type and size

Student ID Auto Number (Primary Key)
First Name Text(15)
Last Name Text(15)
Country Text(24)
Home contact Text(30)
Status Text
Fees Balance (30)
Currency (currency)
(05 marks)

(b) Design a data entry form and use it to populate the TOPAZ STUDENTS
TABLE with the information in the table below. Name it STUDENTS’ DATA
ENTRY FORM. (10
marks)
STUDENTS FIRST LAST NAME COUNTRY HOME STATUS FEES
ID NAME CONTACT BALANC

9
 VICY WANGIRU KENYA 254743010 INTERNATIONAL 50,0
BOB OWUMO TANZANIA 253004102 INTERNATIONAL 600,0
SUSAN NANGI KENYA 256774132 INTERNATIONAL 450,0
ANITAH NANCY TANZANIA 0782382171 INTERNATIONAL 300,0
TAMU ONYANGO UGANDA 0752381444 LOCAL 100,0
TUSHAH MAHESHI INDIA 039617151 INTERNATIONAL 550,0
AYUB KARANJI KENYA 00025439612 INTERNATIONAL 300,0
FLAVIA MUSHOKA TANZANIA +252123456 INTERNATIONAL 200,0
GRIFFINS OMADI UGANDA 0392456798 LOCAL 600,0
GEORGE KAVUMA UGANDA 00267237456 LOCAL 10,0
KHALIF ALI SOMALIA +0039456745 INTERNATIONAL 480,0

(c) Create a query for all international students from Kenya. Name it
KENYA INTERNATIONAL. (04
marks)
(d) Design a query to filter out only international students with fees balance
greater than 400,000. Name the query GREATER THAN 400,000
QUERY. (04
marks)

(e) Design a report based on the GREATER THAN 400,000 QUERY to be

sent to the headteacher. Name it HEADTEACHERS LIST. (03
marks)

(f) Print all your work. (02 marks)

1
0
 END

1
1
 840/2
COMPUTER STUDIES
PRACTICAL
Paper 2
Oct. / Nov. 2017
21/2 hours

UGANDA NATIONAL EXAMINATIONS BOARD

Uganda Certificate of Education
COMPUTER STUDIES
(PRACTICAL)
Paper 2
2 hours 30 minutes

INSTRUCTIONS TO CANDIDATES:

This paper consists of two sections, A, and B.

Section A contains one compulsory question.

Section B contains three questions. Attempt any two questions from this

section. Any additional questions(s) answered will not be marked.

Each candidate is provided with a new blank Compact Disc (CD)

Candidates should continuously save their work.

Each candidate must produce a hard copy for each of their work to
accompany the Compact Disc (CD)

Turn Over

1
 © 2017 Uganda National Examinations Board

SECTION A (40 MARKS)

This Sections is compulsory

(a) (i) Using an appropriate word processing software, type the

passage below as it is. Save it as your name and personal
number.
(07
marks)‘The Internet is like a library.’ You will hear this kind of statement a lot
from people who know very little about either.

If the Internet is a library, it’s a strange one indeed. For starters, there is no
indexing system. At any rate, the books are not arranged on numbered
shelves but scattered on the floor. A lot of what is in the books is untrue, even
in the non-fictions ones. There is no librarian, and no information desk. Did
we mention also that the lights are turned off?

What’s more, you can make as much noise as you like when using the Internet,
while at the same time collecting facts and figures (and fiction and music and
video and sports results and weather reports and recipes) from all around the
world.

In fact, the principle use of the Internet is for e-mail; a way of sending messages
from your computer to someone else’s computer whether in the next room or in
a different hemisphere.

Think of this as your chance to borrow knowledge and skills, you won’t ever be
asked to return, and become part of an online electronic community.
Welcome to the Internet Age.

(ii) Insert a suitable heading for the passage. Bold and centre the
heading. (03
marks)
(iii) Copy and passage to another page. (01 mark)
(iv) Set the font size of the passage to 10 points. (01 mark)
(v) Set the page orientation to landscape and divide it into two
columns. (02
marks)
2
(vi) Copy the passage and paste it on the second column. (02 marks)

3
 (vii) The last paragraph is a statement made by Paul Holden. Set a
footnote to indicate the author. (02
marks)
(viii) Insert a footer of your name and personal number. (01 mark)
(ix) Save and print your work. (01 mark)

(b) The table below shows the wages of staff in Otuke Technical school,
in June 2014.

NAME BASIC BONUS RESPONSIBILIT GROSS PAYE NSSF NE

PAY PAY Y PAY PA
ALLOWANCE
OBOTH KENT 170,000 59,000 3,000 5,700
APIYO CHRISTINE 172,000 59,000 2,000 6,200
BIRABWA DAPHINE 170,000 59,000 2,000 2,000
KARIM HUSSEIN 160,000 59,000 2,000 3,000
MALE JACKIE 200,000 59,000 5,000 2,300
MUSYA DAVID 240,000 59,000 3,000 2,119
TOTAL PAYMENT

(i) Enter the above information into a spreadsheet application of your

choice and save it as your name and personal number. (05
marks)

(ii) Provide an appropriate title for your worksheet. (02

marks) Use appropriate formulae/function to calculate parts (iii)

to (v).

(iii) GROSS PAY which is BASIC PAY, BONUS PAY and

RESPONSIBILITY ALLOWANCE. (02
marks)

(iv) PAYE which is 10% of GROSS PAY. (02 marks)

(v) NETPAY which is GROSS PAY less PAYE and NSSF. (02 marks)
(vi) Determine the total for each type of payment. (02 marks)
(vii) Draw a bar chart to represent the NAME and NET PAY of the staff.

4
 (03 marks)
(viii) Insert your name and personal number as a footer. (01 mark)
(ix) Save and print your work. (01 mark)

5
 Turn Over

SECTION B (60 MARKS)

Answer any two questions from this section.

1. The two web pages below are for Makindye University website.

Homepage

6
 Page 2

(a) Using a web publishing software of your choice, create a website for
Makindye University with the above webpages. Save it as your name
and personal number.
(i) Homepage (05 marks)
(ii) Page 2 (07 marks)
(b) Create links to ease navigation within the pages. (04 marks)
(c) Apply a marquee on the page titles. (04 marks)
(d) Use different background color on each page. (02 marks)
(e) Insert appropriate graphics on each page. (02 marks)
(f) Add a suitable logo on the Homepage. (02 marks)
(g) Add a contact information on the Homepage . (02 marks)
(h) Save and print your pages. (02 marks)

2. A Revenue Authority (RA) is an organization that is responsible for the

collection of Taxes from eligible citizens. RA carries out sensitization
exercises before imposing Tax.
AREAS FOR SENSITIZATION
∙ Types of taxes
∙ Importances of taxes
∙ Eligible people to pay taxes
∙ RA departments.

The organization is made up of departments with departmental heads in the

following order; MANAGEMENT DIRECTOR, GENERAL MANAGER,
two ASSISTANT MANAGERS each with a BRANCH MANAGER.

7
 You have been approached by RA to prepare a presentation for one-day
sensitization workshop.

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

(i) SLIDE ONE: The name of the organization, a welcome
message and name of the presenter. (04 marks)
(ii) SLIDE TWO: Types of taxes charged. (04 marks)

Turn Over

(iii) SLIDE THREE: Reasons why people pay taxes. (04

marks)SLIDE FOUR: An organizational chart showing
the departmental
hierarchy. (06 marks)
(iv) SLIDE FIVE: A summary of the main points and an
encouragement message. (04 marks)
(b) Apply a slide master for uniformity. (02 marks)
(c) Apply appropriate animation and transition effect. (02 marks)
(d) Link all slides four to slide two using an action button. (02 marks)
(e) Save your work as your name and personal number. (01mark)
(f) Print your presentation as a handout. (01 mark)

3. The following information is for BANANA-ZIWE, a company that buys

bananas from local farmers, makes flour out of it and then sells the products
to local buyers.
(a) Open a database application and create a database. Save it as your name
and personal number. (02
marks)
FARMERS FARMERS REGION QUANTITIES FARMERS’ UNIT PER TOTA
ID NAME SOLD(Kg) CONTACTS Kg AMOU
R01 J. Oposa WESTERN 6000 075-21233333 UGX20,000
R02 K. Lasue WESTERN 4500 077-66633322 UGX20,000
R03 H.Maware SOUTHERN 8500 074-5424211 UGX20,000
R04 P.Kopolo NORTHERN 1400 083-24569821 UGX20,000
R05 T.Yujolo EASTERN 6500 077-44477712 UGX20,000

8
 R06 W.Wasedde WESTERN 3200 075-65665631 UGX20,000
R07 G.Tendy EASTERN 7000 022-55566641 UGX20,000
R08 E.Salilopo CENTRAL 4500 078-25632145 UGX20,000
R09 T.Fishic CENTRAL 7400 012-33366602 UGX20,000
R10 B.Sacoccol NORTHERN 200 077-85885862 UGX20,000
R11 N.Ribon EASTERN 1200 034-01245630 UGX20,000
R12 P.Elieto EASTERN 4000 085-23333225 UGX20,000

(b) Create a table in design view with appropriate field data types and enter
the given data. Save it as Farmers table. (06
marks)

(c) (i) Create a form that can be used to enter data in the table and save it
as Data entry form. (06
marks)

(ii) Include a formula in the form that will calculate the TOTAL
AMOUNT for each farmer. (03
marks)
(iii) Insert a header of your name on the form. (01 mark)

(d) Create a query that will select only farmers from eastern region who
sold quantities of less than 5500Kg and save it as Less than.
(03 marks)
(e) Create a query showing only field of FARMER’S NAME and REGION
for farmers who don’t come from NORTHERN region. Save it NOT
Northern. (04
marks)

(f) Create a report from the query Less than and save the report as
Quantities report. (03 marks)

(g) Print all your work. (02 marks)

9
 END

1
0