S850/2

Subsidiary ICT
PRACTICAL
Paper 2
July/Aug.2024
2 hours

PROVINCIAL COUHEIA EXAMINATION AGENCY SECONDARY

MOCK EXAMINATIONS 2024
Uganda Advanced Certificate of Education
SUBSIDIARY ICT
(PRACTICAL)
Paper 2
2 hours

INSTRUCTIONS TO CANDIDATES:

This paper is made up of five equally weighted questions.

Answer any three questions.

Any additional question(s) will not be marked

Each candidate is provided with support files in the folder S850_2 COUHEIA
Support Files on the Computer Desktop. Use the support files where applicable
to supplement the questions.
Each candidate is provided with a new blank Compact Disc (CD).

Use a permanent marker to write your name. random and personal numbers
on our CD.

Candidates should continuous save their work.

Each candidate must produce a hard copy for each question answered to
accompany the Compact Disc (CD).

Restoring the Church in Education1 Turn Over

Answer any three questions in this paper

1. (a) Using a word processing application, open the file Artificial Intelligence
and save is it as your name and personal number. (01mark)
(b) Copy the document to page two. (01mark)
Using the pasted work on page two perform the following tasks
(c) Add a suitable heading for the document. Double underlined, centered
and format it to title case. (03marks)
(d) Change the text appear in font style regular and Arial font type
(02marks)
(e) Insert a two-line Drop Cap on the first paragraph. (02marks)
(f) Convert paragraph four to two columns with a line separator. (02marks)
(g) Apply a paragraph broader on the last paragraph (01mark)
(h) Use a bulleted list for the various applications of AI in paragraph two.
(02marks)
(i) Insert page numbers in the format (page 1 of 2) at the bottom of the
pages. (01marks)
(j) Add an appropriate image as a Watermark. (02marks)
(k) Set all page margins to 1.4 inches. (01mark)
(l) Add a footer as the current date and time. (01marks)
(m) Save and print your work. (01mark)

2. (a) Using a spreadsheet application, open the file S6 ICT RESULTS and
save it as your name and personal number. (01marks)
(b) Wrap text the first row with Names (01mark)
(c) Align the label in cell A1 to 450. (01mark)
(d) Insert a suitable title for the data centered across the table (02mark)

For parts (e)-(h), use appropriate formulas to determine:

(e) Paper one marks out of 40 (P1/40) for every student (Make use of cell
A9) (02marks)
(f) Final mark of every student which is the sum of P1/40 and P2/60
(01mark)

2
(g) Position of every student (02marks)
(h) Number of students who got a point if a point is given to students with 50
and above. (Put it in cell A10) (02marks)
(i) Add All Borders to the cells containing the table. (01mark)
(j) Draw a well labeled Column-chart showing Students and their final
mark. Add a suitable heading for the chart. (03marks)
(k) Insert your name and personal number as a footer. (01 mark)
(l) Sort the Data by Name of students in descending order. (02marks)
(m) Save and print your work. (01 mark)

3. Using a presentation software, create a four-slide presentation as follows:

(a) On the title slide:
(i) Give title as Internet. (01mark)
(ii) Type your name as the presenter. (01mark)

Open the file called internet and use it for slides 2 and 3.

(b) On the second slide:

(i) Requirements of connecting to the internet (02marks)
(c) On the third slide:
(i) Advantages and disadvantages of using internet (03marks)

(d) On the fourth slide, make a conclusion of the presentation. (02marks)

(e) Insert the two pictures from the file Internet, align then at the top left and
top right corner of each slide given a scale of 50%widith and 50% height.
(03marks)
(f) Change all title to uppercase and center aligned. (02marks)
(g) Apply uniform, animations and transition (02marks)
(h) Apply a texture background to all slides (01mark)
(i) Insert your name as footer and current date and time (01mark)
(j) Save your presentation as your name and personal number. (01mark)
(k) Print all your slides on one page. (01mark)

3
4. (a) Using a publication software, design a card of appreciation to an
employee for special services rendered to an institution as follows:
(03marks)
(i) Create a blank page.
(ii) Change the page to landscape orientation.
(iii) Set the dimension to 8”by 8.5”
(b) Insert the relevant text in the card. (04marks)
(c) Format the name of the institution to Word Art (02marks)
(d) Apply Boarder Art of your choice around the card. (02marks)
(e) Enhance your card with appropriate background, color and text fonts
(03marks)
(f) Insert on the card a logo from image folder. (03marks)
(g) Type your name in a colored font as the person to be appreciated.
(01marks)
(h) Save your card as your name and personal number. (01mark)
(i) Print your card. (01 mark)

5. (a) Using suitable database management software, create a database and name
it Student’s Bio Data.
(01mark)

Student Surname Other Date of Place of Sex Class Termly

ID Name Birth Birth Fees
ST001 Kawa Fred 01/05/1990 Wakiso Male S5 515,000
ST002 Kaye Sharif 05/02/1995 Wakiso Male S1 650,000
ST003 Logose Mary 17/09/1994 Wakiso Female S5 800,000
ST004 Bata Bena 20/06/1997 Wakiso Female S3 950,000
ST005 Obote Bonny 13/04/2000 Kampala Male S2 790,000
ST006 Mane Abou 12/03/2002 Wakiso Male S1 900,000

(b) Create a table with appropriate data types and a primary Key .name it
Student’s Data Table. (03marks)
(c) Validate the termly fee field to allow only entries above 500000shs

4
(02marks)

(d) Use a column lookup on the field Sex. (01mark)

(e) Make Wakiso to be a default value in the district field (01marks)
(c) (i) Create a form and use it to enter the data in the table Save it data entry
Form. (03marks)
(ii) Insert your name and personal number in the form footer. (01mark)
(d) Create a query displaying the following fields: Student ID, Surname,
Other Name, Class, Termly Fees and Fees Balance. (Hint: School fees for
each class is Shs950,000). Save the query as Fees Balance Query. (02marks)

(e) Create a query to extract all students born after the year 1994 and before the
year 2000. Name it Birth Date Query. (02marks)

(f) (i) Create a report displaying the following fields: Student ID, Surname,
Other Name, Date of Birth, Termly fees and Yearly Fees, sorted in ascending
order. Give your report a title. (02marks)
(ii) Insert your name and personal number in the Report Footer. (01mark)

(g) Print all your work. (01 mark)

END