S850/2

Subsidiary Information
and Communication
Technology ICT
2023
2 hours

Uganda Advanced Certificate of Education

EXAMINATIONS

Subsidiary ICT S850/2

PRACTICAL PAPER
Time: 2 hours

INSTRUCTIONS TO CANDIDATES:
You are provided with a folder saved as 850-2 UACE SUPPORT FILES 2023 where you
will find your work and other graphics for use during this examination.
Question 5 has no support file. If you are to answer it, read the instructions carefully.
Each candidate is provided with a new Compact Disc where all the work shall be stored.
Each candidate has a printer connected to his / her computer.
Each candidate is provided with blank printing papers of A4 size.
Attempt only three questions in this paper.
Use of self help wizard and templates are not allowed.

Turn Over

1
1. Open a word processing file saved as EDITING and carry out the
following tasks.

(a) Edit the work with correct spell check and grammar. (04 mark)
(b) Adjust the line spacing to double. (01 mark)
(c) Set margins to: top and bottom, 1.5 cm; left and right to 2.1 cm. (01 mark)
(d) Insert a suitable toggle case heading and centre align it. (01 mark)
(e) On the table, highlight cells with colour with there corresponding (01 mark)
colours e.g. highlight cell with RED with red colour.
(f) Covert text before the table to two columns with line in-between. (01 marks)
(g) Insert a watermark of your Name. (01 mark)
(h) Double strike through the word EDITING. (01 mark)
(i) Remove the boldness in the word EDITING. (01 mark)
(j) Insert a footnote on the word “grammatical” to mean rules of (02 marks)
writing a language.
(k) Insert any Art page border of 10 points (01 mark)
(l) The pasted table should have all dotted brown border of 3 points (02 marks)
(m) Add a footer of your name and a header of your personal number. (01 mark)
(n) Save your work as edited text- your name (01 mark)
(o) Provide a print out for your work. (01 mark)

2. A group of Disc Jockeys have a DJ Contest in Rubirizi district each having a list of
musical flavours they play. Use a spreadsheet named as DJ DATA.xls from the
support files to perform the following tasks.

(a) Use suitable formula to count the number of times “YES” appears for
every DJ in column F (02 marks)
(b) Use suitable formula to count the number of times “NO” appears for
every DJ in column G (01 mark)

(c) Use formulas to find Mode of TOTAL YES and TOTAL NO in cell
F7 and G7 respectively. (02 marks)

(d) Use formulas to find Total of TOTAL YES and TOTAL NO in cell
F8 and G8 respectively.
2
 (01 mark)
(e) Use formulas to find Average of TOTAL YES and TOTAL NO in
cell F9 and G9 respectively. (02 marks)

(f) Insert a pie-chart showing DJ’s Name and TOTAL YES data. (02 mark)

(g) The pie chart should be in black and white colours only. (01 mark)

(h) Move the chart to sheet 3 and rename it ANALYSIS GRAPH (01 mark)
(i) Change alignment of column heading to -570 (01 mark)
(j) Apply a thick box boarder to your data (01 mark)
(k) Apply a suitable title in Chiller font face, font size 15.5 (01 mark)
(l) Remove the underlining on DJ MOPHIA (01 mark)

(m) Insert a right header of your name and personal number (01 mark)
(n) Apply a comment on DJ BLACK to say “ Best DJ in Busia” (01 mark)
(o) Change the orientation of your spreadsheet to landscape (01 mark)
(p) Print your work. (01 mark)

3. As a senior database administrator you have been approached have been approached
by Mr Gitta a Barber from Buvuma Island to help him improve on his database
management system which was developed by an S4 vacist. The database file has been
provided in the support files with the name SALOON. Use it to perform the following
tasks.
(a) Rename the database as HAIRSTYLES. (01 mark)

(b) Make the following changes in design view of your table:

CLIENT ID – Field size is 80
(01 mark)
BOOKING DATE – Description is Date when customer booked
(01 mark)
for a given hair style

(c) Make the following changes on the DATA ENTRY FORM.

(i) Suitable logo from image folder of support files (01 mark)
3
 (ii) Title: DATA ENTRY FORM. (01 mark)
(iii) Red background colour. (01 mark)
(iv) Footer of your name, today's date. (01 mark)

(d) Design four queries that should return data:

(i). Client names that end with letter O and E. Save the query as (01 mark)
OE

(ii). Booking No between 500 and 900, save the query as MAX (02 marks)

(iii). Client who paid for NAILCUT via MOBILE MONEY. Save
the query as Nail Mobile. (02 mark)
(iv) Total of cash collected by the saloon. Save query as Total
cash. (01 mark)

(e) Make the following changes on the SALOON REPORT.

(i) Logo of hair3.jpg image from support files (01 mark)

(02 marks)
(ii) Sum of all amount paid by clients
(01 mark)
(iii) Add a title: REPORT FOR GITTA’S SALOON.
(01 mark)
(iv) Include a footer as your name.
(01 mark)

(f) Print your report only. (01 mark)

4. .Using a presentation software, design a four-slide presentation about smoking

(a). Do the following tasks in the slides

(i) Slide one : A suitable title and name (02 marks)

(ii) Slide two: Definition of smoking (02 marks)
(iii) Slide three: Dangers of smoking (02 marks)
(iv) Slide four: Conclusion (02 marks)

(b). Apply uniform transitions and animations in all slides (01 mark)
(c). All slides should have a blue colour background colour (01 mark)
4
 (d). Insert action buttons to link your slides to and from. (01 mark)

(e). Insert a header of your name and footer of current date and time (01 mark)

(f). Apply slide numbers to all your slides. (01 mark)

(g). Insert speaker notes on slide four saying. “Smoking is harmful to (01 mark)
your health”.
(h). Insert an a sound in your presentation from audio folder called smoke (02 marks)
coughing.mp3

(i). Let all your slides be in portrait orientation (01 mark)

(j). Apply a page setup of your slides to be width:7.3 inches, height:11.1 (01 mark)
inches
(k). Save your work as smoking-your name (01 mark)
(l). Print all your work on one A4 paper size. (01 mark)

5. Using a publication program of your choice, create a Certificate of Merit for

the Computer Club of your school using the following details. (02 marks)

Instructions:

(a) Use paper size A4 with a landscape orientation. (04 marks)

(b) Use nice looking but varying fonts. (04 marks)
(c) Include the following details: ( 04 marks)
i. Name of awardees.
ii. Post recognised.
iii. Two signatories i.e. the Headmaster and Patron.
iv. Indicate the names for the headmaster and the patron. (These need not to be the
actual names).

(d) Add your name as footer. (01 mark)

(e) Balance your publication on the page size provided. (01 mark)
(f) Using the mail - merge facility, populate and print the following certificates.
(02 marks)

Name of awardee Post

5
 Mulindwa Moses Chairman
Kalinaki Joseph Mobiliser
Nakato Agnes Chief whip
Ajambo Rose Secretary

(g) Save your work as certificate (01 mark)

(h) Print a copy of your work. (01 mark)
END