840/2
Computer Studies
Practical
2 Hrs 15 Min
2020
Uganda Certificate of Education
Computer Studies - 2020
Practical Examinations
2 Hours 15 Minutes
INSTRUCTIONS TO CANDIDATES
a) This paper is made up of two Sections A, and B respectively.
b) Section A contains one question. This question is compulsory.
c) Section B contains three questions. Answer any two questions from this section.
d) Each candidate is provided with a new blank compact disk or a flash disk.
e) Each candidate must produce a hardcopy for each of his/her work to accompany the
compact discs or flash discs.
f) Software help wizard must not be used.
Page 1 of 5
SECTION A: (40 MARKS)
1. (a). Using a word processing program of your choice, key in the following piece
of text and save it as thebrain. (04 marks)
What's it the most we can remember
Unlike digital cameras with full memory cards that cannot snap any more pictures, our
brains never seem to run out of room. Yet it defies logic that one adult human brain – a
"blood-soaked sponge," in writer Kurt Vonnegut's words – should be able to limitlessly
record new facts and experiences. Neuroscientists have long tried to measure our
maximum mental volume. However, what scrambles any simple reckoning of memory
capacity is the astounding cognitive feats achieved by dedicated individuals, and people
with atypical brains.
Many of us struggle to commit a phone number to memory. How about 67,980 digits?
That's how many digits of pi that Chao Lu of China, a 24-year-old graduate student at the
time, recited in 2005. Chao uttered the string of numbers during a 24-hour stretch without
so much as a bathroom break, breaking the world record.
Savants have pulled off arguably even more amazing performances, capable of astounding
feats of recall, from names and dates to the details of complex visual scenes. And in rare
instances, injuries to previously healthy people have seemingly triggered "acquired savant
syndrome." When Orlando Serrell was 10-years-old, for example, he was struck by a
baseball in the left side of his head. He suddenly found he could recall countless licence
plates and compute complex calendrical items, such as what day of the week a date from
decades ago fell.
Source: http://www.bbc.com/future/story/20150401-whats-the-most-we-can-remember
Instructions:
a). Copy this work to page three of your document. (02 marks)
b). Insert a water mark in page two only of this document containing a word THE
BRAIN in font size 52 and colour red. (02 marks)
c). In page 3 Convert the three paragraphs into three columns of your work. (02 marks)
d). Drop cap the first letter in each paragraph and change font colour to red. (03 marks)
e). Justify all the work in page three. (02 marks)
f). Insert a footnote on the work memory to contain "refers to a store of data during data
processing". (02 marks)
g). Insert header, your name; footer your class and stream, print one copy. (03 marks)
Page 2 of 5
(b). Using a spreadsheet application of your choice, key in the following details as they
appear and save the work as canteen. (02 marks)
Item Name Quantity Unit Price Commission Net Price
Daso 40 800
Chappu 60 500
doughnut 90 800
Milk 90 800
Pancake 100 250
Sumbi 32 250
Rolex 18 800
Stone cake 24 250
Half cake 40 250
Yorghut 90 160
Layo 90 150
Bogoya 78 250
Bagiya 63 20
Omondi 121 250
Musiba taayi 13 500
Instructions:
a). Add two row headings from cell A18 downwards for:
(i). Highest. (01 mark)
(ii). Lowest. (01 mark)
Hence, determine the values in respect to Quantity and Unit Price respectively.
b). Insert a new column between Unit Price and commission for gross sales; thence,
determine the gross sales for each item. (02 marks)
c). Using the values from (b) above, determine commission given the Commission is
10% of Gross Sales. (02 marks)
d). Net sales is given as a difference between gross sales and commission. determine net
sales for each item. (02 marks)
e). Add a new column for New Net Sales given that the discount is 15%. In this column,
determine the new net sales for each item. (02 marks)
f). Using data series for Item Name, Net Sales and Net New Sales, create a column
graph to represent this data. Remember to have columns for Net Sales Column graph
and New Net Sales as line graph as one graph as an object in sheet2. (04 marks)
g). Insert footer your name, and print your work. (04 marks)
Page 3 of 5
SECTION B: (60 MARKS)
2. Using a program of your choice, create a database saved as sales. (03 marks)
ProductID Product Name Quantity Unit Price Quantity Returned
KFM/001 Yoghurt 1,000 800 150
KFM/010 Afia 1,000 800 60
KFM/020 Safi 400 800 84
KFM/030 Wheat flour 600 4,000 100
KFM/002 Rwenzori 700 800 300
KFM/012 Exercise books 3,000 250 02
KFM/022 Pens 4,000 500 10
KFM/032 Pencils 2,000 50 21
KFM/003 Books 1,500 250 400
KFM/023 Rulers 60 500 01
KFM/033 Reams (photocopy) 200 18,000 07
KFM/004 Bulbs 800 1,000 03
KFM/014 Sweets 10,000 50 00
KFM/024 Ice - cream 250 500 00
Instructions:
a). Design a table to hold the above records and save it as sales2015. (05 marks)
b). Create a form you will use to populate the above records. On the form, add a form
title, DATA ENTRY. (05 marks)
c). Create two queries to return the following using all the field names:
(i). Items whose quantity is above 1000 and save it as above1000. (02 marks)
(ii). Items whose first letter is between O and T. Save the query as OandT.
(02 marks)
d). Add a field name Gross Sale in a query. Hence, determine the gross Sales for each
commodity. save the query as grossprice. (04 marks)
e). Using your answer in (d) above. Create a report saved as grosssalereport.
(03 marks)
f). Print all you work. (02 marks)
Page 4 of 5
3. Prepare an automatically running presentation to hold the following details. Save it as
environment.
Slide one: to include the heading, environment degradation. Add your name in the sub-
title area as the presenter. (04 marks)
Slide two: to include causes of environmental degradation. (04 marks)
Slide three: to include dangers of environmental degradation. (04 marks)
Slide four: to include solutions to environmental degradation. (04 marks)
Instructions:
a). Use presentation minimal speed. (02 marks)
b). Apply minimal animations. (02 marks)
c). Add relevant clip art. (02 marks)
d). Use word art for the title in the first slide. (02 marks)
e). Add speaker notes in the first slide reading: environment refers to man and his
surroundings. (02 marks)
f). Print your work. (02 marks)
END
Page 5 of 5
