0% found this document useful (0 votes)
39 views5 pages

ICT Practical Exam Guidelines

The document is an examination paper for the Uganda Certificate of Education in Computer Studies, consisting of practical tasks divided into two sections. Section A is compulsory and includes tasks related to word processing and spreadsheet software, while Section B offers three questions on web design, database creation, and presentation design, from which candidates must choose two. Candidates are instructed to save their work on a Compact Disc and produce hard copies for submission.

Uploaded by

ronaldkazana0
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
39 views5 pages

ICT Practical Exam Guidelines

The document is an examination paper for the Uganda Certificate of Education in Computer Studies, consisting of practical tasks divided into two sections. Section A is compulsory and includes tasks related to word processing and spreadsheet software, while Section B offers three questions on web design, database creation, and presentation design, from which candidates must choose two. Candidates are instructed to save their work on a Compact Disc and produce hard copies for submission.

Uploaded by

ronaldkazana0
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

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

© 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 [Link], Ivan A. Getting and
Bradford Parkinson are credited with inventing it.

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)

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 Furniture ($) Deposit Balance Monthly Instalments


Name

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)

iii. Balance after deposit. (02 marks)

v. Monthly instalments which are paid equally in a period of two years.


(02 marks)

v. On a new sheet, create a fully labeled Pie-Chart using the customer name and cost of
furniture. Name the sheet Customers. (05 marks)

v. Insert your name and personal number as footer. (02 marks)

v. 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


[Link] 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)

b. Save your work as your name and personal number. (01 mark)
b. Print your work. (01 mark)

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

CAR REG. DATE OF COSUMPTION COST PER LITRE TYPE OF FUEL NO OF LITRES
NO

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)

c. Create a form that will be used to add new records. (03 marks)

c. Insert a calculated field to determine the Total amount to be paid.


(04 marks)

c. 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)

g. Make a report based on the sorted Fuel Table and save it as Consumption.
(03 marks)
g. Save and print all your work. (02 marks)

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

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)

iv. 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)

b. Insert the current date that updates automatically as a footer and your name and personal
number as a header. (03 marks)

b. Save your work. (01 mark)

END

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

Common questions

Powered by AI

Transition effects, when applied effectively, enhance the visual flow and engagement in a looping presentation. They help maintain viewer interest as slides progress seamlessly. To optimize their use, consistent and subtle transitions should be chosen to match presentation tone, ensuring they don't distract from content. Properly set, transitions in a looping setup allow for uninterrupted, cyclical viewing, making information conveyance fluid and continuous .

Enhancing a restaurant advertisement website can involve several elements: an engaging Marquee on the Home Page for announcements, clear and user-friendly navigation links, and a detailed contact section for communication purposes. Utilizing visually appealing graphics across pages can improve the aesthetic appeal and user experience. A well-organized food menu and restaurant information tables promote easy information access. Continuous improvements based on user feedback can further optimize functionality and satisfaction .

To calculate customer furniture payments using spreadsheet software, formulas should be used as follows: first, the deposit, which is 25% of the cost of the furniture, can be calculated by multiplying the cost by 0.25. The balance after deposit is determined by subtracting the deposit from the initial cost. For monthly instalments, as payments are made equally over two years, the balance should be divided by 24 (the number of months in two years) to find the monthly payment amount .

In a spreadsheet application, customer and furniture cost data can be visually represented using a fully labeled pie-chart. This chart should clearly label each customer with their associated furniture costs, providing an intuitive visual breakdown of the data for quick assessment. Additionally, naming the sheet appropriately, such as 'Customers', helps in maintaining clarity and organization. Saving and printing the finalized work ensures that the documented data can be shared or archived as needed .

Data sorting and querying operations enhance database management by allowing for efficient data retrieval and analysis. In the context of tracking fuel sales, sorting data by total amount in descending order helps quickly identify transactions with the highest costs. Queries can filter specific entries, such as those where cars consumed 15 or more litres of diesel, facilitating targeted reporting and decision-making. These operations streamline access to critical insights, improve data organization, and enhance decision support capabilities .

To create a database table for tracking fuel consumption details, one must start by designing the table to include fields such as car registration number, date of consumption, cost per litre, type of fuel, and number of litres, using appropriate data types for each field. After entering the given data, a form should be created to facilitate adding new records. Additionally, a calculated field should be added to determine the total amount to be paid. A query must be created to filter cars that consumed 15 or more litres of diesel and saved accordingly. Finally, data should be sorted by the total amount in descending order, and a report should be generated and saved .

The Global Positioning System (GPS) is made freely accessible by the United States government, which created, maintains, and provides it to anyone with a GPS receiver. The system offers critical capabilities to various users worldwide, including military, civil, and commercial sectors, by providing location and time information in all weather conditions, as long as there is an unobstructed line of sight to four or more GPS satellites .

To effectively showcase a restaurant business, the website can be designed with three pages each having specific features: the Home Page should include an introduction, links to other pages, a marquee, and a contact address. The second page should display a food menu with prices formatted in a table. The third page should feature a four-column table detailing information about the three restaurants. Appropriate graphics should be inserted on the pages to enhance visual appeal, and the work should be saved and printed .

To create a comprehensive presentation on computer hardware, the slides should include varied and informative content. The main topic and a brief introduction should be covered initially. Subsequent slides should list input and output devices along with their functions, storage devices should be categorized into optical and non-optical, and communication hardware should be identified with functionality explanations. The final slide should pose revision questions about hardware concepts. Transitions should be applied across slides, set to loop continuously, and ensuring the inclusion of the current date as a footer and personal identifiers as a header. All slides should be compiled and printed on the same page for review .

When formatting a document, several considerations should be made: page numbers should be inserted consistently, either at the top or bottom of the pages, with clear formatting preferences. Watermarks, such as a name, should be placed thoughtfully to avoid obscuring text, ensuring readability and professionalism. For paragraphs requiring hanging indents, only the first line should start at the margin while subsequent lines are indented, maintaining uniformity throughout the document. These decisions should align with document design objectives and enhance the overall readability .

You might also like