840/2
COMPUTER STUDIES
(Practical)
Paper 2
July/Aug. 2022
2 ½ hours
AITEL JOINT MOCK EXAMINATIONS
Uganda Certificate of Education
COMPUTER STUDIES
(PRACTICAL)
Paper 2
2 hours 30 minutes
INSTRUCTIONS TO CANDIDATES:
The paper consists of two sections, A and B
Section A contains one compulsory question that takes 40 marks.
Section B contains three questions. Answer any two questions from this section.
Any additional question(s) answered will not be marked
Each candidate is provided with 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 compact disc.
Software wizards must not be used.
Create a folder on the desktop with all your names and save your work there
© 2022 AITEL Mocks Turn Over
SECTION A (40 MARKS)
This section is compulsory
1. (a) Type the following statements. (02 marks)
Dear brother/sister
Ramathan for body and soul
This article provides useful advice on how to avoid some common problems
encountered in Ramathan. If followed, it would enable one to fast comfortably and
enjoy the spiritual benefits of Ramathan. Come Ramathan our diet is radically altered.
Our meals get condensed in morning and evenings with no intake in between for an
extended period of time. For some of us, the intake of oily food skyrockets. These
changes in diet are not well received by everyone.
Yours in Allah
Shake Hubei
Required:
(i) Change the case of title to UPPER CASE and bold it and change the font of all
the text size 12. (02 marks)
(ii) Instead of word sister/brother put both your names. (01 mark)
(iii) Apply a header as your company name. (Use word art where necessary).
(02 marks)
(iv) Justify the two paragraphs. (01 mark)
(v) Copy your two paragraphs to page two, duplicate them to form eight paragraphs.
(02 marks)
(vi) Put your eight paragraphs into three columns with a line between them.
(03 marks)
(vii) Insert today’s date and time in the left footer section and update it automatically
and an Auto text Page X of Y to the right. (02 marks)
(viii) Apply a three lines 3point page border around your document (01 mark)
(ix) Apply a footnote as Ramathan tips. (03 marks)
xii) Number your Pages in Lowercase Alphabet. (01 mark)
(x) Save your work as your name and print a copy of your work. (01 mark)
2
(b) The information below is driven from MUFTI Limited from some few selected staff.
The staff include JACKIE, KENT, PAULINE, UNICE, XAVIER, LEONALD,
SONNY, CHRISTINE, PHILIPER and INNOCENT. They earn the following amount
as basic salary respectively: 660000, 760000, 870000, 580000, 600000,610000, 630000,
640000, 650000 and 555000.
(i) Enter the above information using Microsoft Excel with columns Employees Name,
Basic Salary, Lunch Allowances, Housing Allowances, Transport Allowances, Gross
Pay, PAYE and Net Pay (Two words should be wrapped)
(03 marks)
(ii) Lunch allowances for all employees is 22% of their basic pay. (01 marks)
(iii) Housing allowances are 62% of lunch allowances. (01 mark)
(iv) All employees are paid transport allowances of 59,000 (01 mark)
(v) Compute the employees‟ gross pay. (01 mark)
(vi) PAYE is 4.5% of basic salary (01 mark)
(vii) Compute the employees‟ net pay. (01 mark)
(viii) Plot a line graph of Employees names against Net Pay and save it as My Graph.
(03 marks)
(ix) Use the COUNTIF function to get how many employees earn 600000 and above of
their Basic Salary (02 marks)
(x) Insert a thick boarder outside your work with grids inside. (01 mark)
(xi) Insert your full names and registration number to the left and right header section of
the worksheet. (01 mark)
(xii) Print your worksheet in landscape orientation and graph. (01 mark)
(xiii) Save your work as Original Work in a folder on the desktop. (01 mark)
(xiv) Use the auto filter function to get employees who earn less than 600000 and save it
as Less than 600000 in your folder and print it out. (02 marks)
3 Turn Over
SECTION B (60 MARKS)
Attempt any two questions from this section
2. The table below gives information on some students in a certain Secondary School
about their Registration numbers, names, class, age, sex and names of houses where
they reside.
Load a database program of your choice and name it REGISTRATION EXERCISE in a
folder bearing your names on the Desktop. (01 Mark)
Table 1: Register
Table 2: Details
4
You are required to:
(i) Create a table called Register with fields; reg no. names, class, age, sex, house
having appropriate data types. Note (for sex use the look up wizard).
(04 marks)
(ii) Create another table called Details with fields; Reg no., date of birth, city,
village, address. (04 marks)
(iii) Create a One to One Relationship between Register and Details (01 mark)
(iv) Create a query for Bikunya and Winyi. Save it as Hardliners with fields Reg
No, Names, Class, Age, Sex, House, Date of Birth and Address. (02 marks)
(v) Create a query from Register Table to return all Houses Excluding Bikunya.
Save it as Exclusion Query. (02 marks)
(vi) Create another query with fields; Reg No, Names, Date of Birth, Sex and
House that will display all Females born in 1996. Save it as 1996 Females.
(02 marks)
(vii) Create a parameter Query based on House that will display student
information when the User types in a House. Name it Parameter Query
(02 marks)
(viii) Use your Query above to create a form and save it as Form Two.
(02 marks)
(ix) Use the Form above to find out how old each of the students is!
(02 marks)
(x) Provide a formatted header REGISTRATION FORM (color-Blue; size 24;
font- Comic Sans Ms and Bold it. (02 marks)
(xi) Add two command buttons of your choice and lock your Form. (01 mark)
(xii) Interrogate your table and get out those members born between February 1996
and September 1996. Save it as Young (02 marks)
(xiii) Create a report using Table1 (Register Table) save it as My Report.
(02 marks)
5 Turn Over
(xiv) Insert a footer of Your Name and Personal Number in Your Report.(01 mark)
3. There will be “Orange Uganda Expo” at UMA Show grounds between the 15th and
18th November, 2015. As the Public relations at ORANGE, the CEO has asked you to
organize a team and suitable material which you will use to market your PRODUCT
at this Exhibition. Using presentation software of your; design a 4-Slide presentation
which you will continuously run as you explain to guests who will visit your stall
during the exhibition.
Presentation Guidelines:
Slide 1
• Use a Blank slide layout (01 mark)
• A Title slide outlining the basic information about Orange Uganda.
• Use some or all of this information. (02 marks)
Orange Uganda is one of the best mobile phone operator in Uganda. At orange you
get the best deals. Like we say “Technology Changes with Orange”.
Our contact:
P. O. Box 411, KAMPALA:
E-mail: [email protected]
Any other additional but relevant information and slide designs will earn you marks.
(03 marks)
Slide II
Use an Organizational Chart slide layout (01 mark)
Use an appropriate Slide Title (01 mark)
Organize the information below in the most appropriate way on this slide.
(04 marks)
Highest in hierarchy FOUNDER DIRECTOR [Mrs. Nasimolo Grace], followed by
the CEO [Mrs. Kigongo Keith], followed by the EXECUTIVE MANAGER [Ms.
Mutibwa Faith]
The OPERATIONS MANAGER [Mr. Opio Rosco], the HUMAN RESOURCE
[Mr. Wangolobe Norbert] and the PUBLIC RELATIONS [Ms. Tumwine Edith] all
report directly to the EXECUTIVE DIRECTOR.
The ACCOUNTANTS who report to the EXECUTIVE MANAGER,
EMPLOYEES and SUPPORT STAFF will report directly to the HUMAN
RESOURCE.
Slide III
6
Use a Title and Chart slide layout (01 mark)
The title of this slide will be Orange Expo 2015
In the table on the slide, organize the following products that will be on sale.
(02 marks)
Laptops Acer
Toshiber Satellite
Hp Notebooks
Del Inspiration
Mobile phones Samsung GALAXY
XPERA Sense
NOKIA ASHA
IPHONE 4
Tablet Offers SAMSUNG GALAXY Tab 7.7”
APPLE IPAD 4
Slide IV
Use a Title and Chart slide layout (01 mark)
The title of this slide will be The Company Growth 2013-2015.
The table below shows subscriber figures between 2013 and 2015. Use it to generate
the chart that will appear on this slide. (03 marks)
Service 2013 2014 2015
SMS 20 33 52
Calls 10 15 75
Internet 18 24 60
MMS 5 10 11
Coverage 5 15 36
Formatting Guidelines:
Insert relevant clip art images appropriately. (01 mark)
Your slide must run automatically after 00:02 Seconds. (01 mark)
Insert a footer of your Name slide and Index No. on each of the slides. (01 mark)
Apply a slow transition, box out, automatically after 02 sec and Neutron as the
animation scheme. (02 marks)
Apply a glass layer as the slide design (02 marks)
Link all slides to one another using action buttons (02 marks)
Print all your 4 slides on one page. (02 marks)
7 Turn Over
4. Using any web publishing software, publish a website for your district with the
following pages.
All Pages should have Similar Navigational Links and Background of green.
All Pages should have a Marquee as Welcome to Our Home District, Font Size 20,
and Bookman Old style (03 marks)
➢ Home page (03 marks)
Should have a brief introduction of about three lines
➢ District administration page (03 marks)
Bring out leaders at different levels
➢ Education page giving schools in the district (03 marks)
Include a table of about six rows and 2 columns indicating schools and their
location if possible indicate whether primary or secondary
➢ Economic activities page for economic activities (03 marks)
Like farming, fishing, manufacturing, trade, etc.
➢ Social activities page (03 marks)
To cater for leisure activities, family life in the district, religion etc
➢ District problems page (03 marks)
To cater for things like deforestation, food shortage, pests, diseases etc
NOTE:
You are expected to include the following on all your pages:
(i) Relevant graphics (03 marks)
(ii) Attractive layout and creativity (01 mark)
(iii) Include your name as the designer in the right bottom footer. (02 marks)
(iv) Save your website as District Website in Your Folder (01 mark)
(v) Print all pages (02 marks)
END
