practical questions fro both ordinary and advanced level by nkoyoyo edward

8/18/2019 Practical Questions Fro Both Ordinary and Advanced Level by Nkoyoyo Edward

1/188

COMPUTER STUDIES

FOR O’LEVEL

&

SUB – ICT FOR A’LEVEL

PRACTICALS

Prepared byNKOYOYOEDWARD

[email protected]

[email protected]

Contents

WORD PROCESSING........................................................................................................2SPREADSHEETS.............................................................................................................44POWER POINT.................................................................................................................78

DATABASE.....................................................................................................................102

WEB DESIGN.................................................................................................................142DESK TOP PUBLISHING..............................................................................................152

FELLOW THE INSTRUCTIONS BELOW

Word processing ………… 2…..43 O’ and A’LEVEL

Spread sheets …………..….44 …77 O’ and A’LEVEL

Power point …………………78 …..101 O and A’LEVEL

Database ……………………102 …141 O’ and A’LEVEL

Web design ……………...…142 … 151 O’LEVEL ONLY

Desktop publishing…….… 152 … 158 A’LEVEL ONLY

By [email protected] Page 1

mailto:[email protected]:[email protected]:[email protected]:[email protected]


2/188

“No m!!"# $o% m&' m()!*") 'o+ m*" o# $o% ),o% 'o+ -#o#"))/ 'o+

#" )!(,, %' $" o ""#'o&" %$o ()&3! !#'(& Do 'o+ ")!

WORD PROCESSING

A word processor (more formally known asdocument preparation

system)is a computer application used for production (including

composition, editing formatting and possibly printing) of any sort of

printable material

Popular word processing packages include:• Word pad

• Word star

• Word perfect

• Microsoft word

• Amin pro

Question one

Type the following statements

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


mailto:[email protected]:[email protected]


3/188

Questions

i) Change the case of title to title case and bold it.

ii) Instead of word sister/brother put both your names.

iii) Apply a header as your company name with a logo and current

date appropriately. (use word art where necessary )

iv) Apply a footnote on the word Ramathan, call it ramathan tips.

v) Justify your work.

vi) Save your work as your name.

vii) Print a copy of your work.

Question two

Insert the table below

Keth 45 86 85Beth 56 67 57

Ham 42 78 70

Kit 63 95 67

Tim 75 42 90

Val 50 63 76

a)Apply border on every cell.

b)Insert another row to represent the title for records as “Name and

marks”.

c)Merge and centre the last three cells for the title.

d)Insert a row between Ham and Kit for Ali

e)Align all the records in the centre.

f)Save your work as your name.

g)Print a copy of your work.

Question three

(i) In a few words, design an invitation card inviting four of your friends to your birth day party.

(ii) Apply a boarder to detach your card and an appropriate background.

(iii) Apply appropriate bullets on the names of your invitees

Use appropriate fonts, word art and a clip to your work look nice

(iv) Save it under your names in the folder you created.




4/188

(v) Print a copy of your work.

Question four

(a) Type the document below

How the East Indies got their name.

In 1492, Christopher Columbus, an Italian sailor, sailed from Palos in

Spain and crossed the Atlantic Ocean to the West Indies. He was the first

European to set foot in the New World.

Long before this time, people in Europe had become interested in

exploring the world outside Europe. In the thirteenth century, the

traveler Marco polo had gone fro Italy to China. He even visited Japan.

Questions

(b) Bold, centre, Underline and apply the font size 16 for the heading.

(c) Change the heading to upper case.

(d) Left indent the first lines of both paragraphs to 1

(e) Insert the current date at the top paragraph and right align it.

(f) Make a spell check of the whole document(g) Insert your name and stream as footer font size 8

(h) Make three copies of the work and create two columns in the

passage and add a footnote as your school name on the right corner

(i) Apply 1.5 line spacing in your work

(j) Save your work with file name ‘Columbus’ in a folder with your

name and class.

(k) Print a copy of your work

Question five

(a) Design a letterhead for your company which should among others

have a logo, address, date, well designed in appropriate fonts

(b) In the normal view, list down the products offered by your company




5/188

(c) Indent your work “0.5” to the left and “0.5” to the right and apply 1.54

line spacing

(d) Apply a page boarder on your document

(e) Save your work with your name as a file name

(f) Print a copy of your work.

Question six

Type the document below.

Uganda’s stock exchange is quite nascent to the Uganda securities

exchange

(USE) formerly commencing trading in January 1998 of the East African

Development bank (EADB) bond. Another fixed income security, the PTA bank

bond is also being traded on the USE located at East African

Development

Bank (EADB) building in Kampala.

Uganda clay ltd is the company whose shares were the first to be listed

on the

Stock exchange on January 18, 2000 while a multinational, British

American Tobacco Uganda (BATU)’s shares were initially listed on the

USE on October 3, 2000.

Required

a)Justify the whole of the document

b)Make three copies of your document

c)Apply two columns to your document

d)Drop the first letter of the paragraph

e)Shade the first paragraph with color blue

f)Apply header as your name and class and stream as your footer

g)Save your work as instructed

h)Print the copy of your work

Question seven




6/188

You have been asked to send acknowledgement letters to people who have

so far made contributions towards the program. The letter content is the

same for all persons except the addresses, name and nature of

contributions.

Below is the letter to sent and a table of people who have madecontributions

HAWA SSS

P.O.Box 2333,

Wakiso.

14th Aug, 2015

[ADDRESS]

DEAR[NAME],

Thank your contribution of[NATURE OF CONTRIBUTION]towards the

“Funds for Food” program.

This project is in its inaugural year but it has been a resounding

success. The learners and staff agree that it should become an annual

event. The principle would like to thank you and hopes for more support

in future.

Thank you very much.

……………………..

PRINCIPAL

YUDA TADEO

NAME ADDRESS NATURE OF

CONTRIBUTION

Alfonso Miguel P.O.BOX 14, KAMULI $300

Lorene Mark P.O.BOX23, MBARARA 200000/=

Alfred Manuel P.O.BOX21, KAMPALA 30kgs of maize

Tim Howard P.O.BOX20, KASESE 10bags of rice

a)Use appropriate method in any word processing program to make a

letter to be sent to each person in a table.




7/188

b)Save your work as your name

c)Print a copy of your work

Question eight

Type the following statements.

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 oneto 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

every one.

Yours in Allah

Shake Hubei

Required

(i) Change the case toUPPERCASE and bold it and change the

font of all the text size 12

(ii) Instead of word sister/brother put both your names.

(iii) Apply a header as you company name.( Use word art wherenecessary)

(iv) Justify the two paragraphs.

(v) Copy your two paragraphs to page two, duplicate them to form

eight paragraphs.




8/188

(vi) Put eight paragraphs into three columns with a line between

them.

(vii) Insert today’s date and time in the footer section and update it

automatically.

(viii) Apply a three lines 3 point border around your document

(ix) Apply a footnote asRamathan tips.

(x) Number your pages in Lowercase Alphabet

(xi) Save your work as your name

(xii) Print a copy of your work.

Question nine

Type the following document as it appears using suitable word

processing.

The use of DDT is welcome

Malaria is the biggest health problem in Uganda and Africa in general. Its

toll in Africa is the heaviest yearly. 90% of(World) malaria deaths occur

in Africa. It is responsible for over 300 million cases of acute illness each

year leading to many deaths. On the economic front, malaria costs Africa

more than $12 billion annually. It has slowed economic growth in African

countries by 1.3 % per year. If the disease had been wiped out decades

ago, about $900 billion would be added to sub-Saharan African’s GDP of

about $3.00 trillion.

Malaria transmission occurs by mosquitoes moving to houses, entering

during the early evenings, resting indoors and at some point during the

night, landing on humans and biting them. During the act of biting, the

mosquitoes might acquire malaria parasites and become infected, or if

already infected, they might transmit malaria to another human.

Required

(i) Copy the typed document above and paste it to on page 2




9/188

(ii) Using the pasted copy on page 2, format the heading of the font

“Bell MT” with font size 19, double underlined and the rest of

the next in font size 13

(iii) Convert paragraph 1 into a two column with a line between the

columns(iv) Change the line spacing of paragraph two to 2 points and justify

your work. And insert aheaderof Your name and class.

(v) Drop cap the first letter of the second paragraph and give it a

red colour.

(vi) Apply a preset rainbow background colour. Insert a footer of

“today’s date” aligned left and an auto textpage X of Y aligned

to the right.

(vii) Apply a printed water mark (text watermark) diagonal, using your surname in red colour.

(viii)Save your work and print it out.

Question ten

Type the following text as it is, correcting any spelling mistakes their in

From its very earliet day, the internet has been primarily concened wit

one task, making it easier for people to communicate with one antherusing computers. The internet was creted to let university reseahers

share their thoughts, work, and resources and for military people to

communicat with each other incas of war and even, theortically a

nuclear attack.

By P Gralla

How the internet works.

Required to:

(i) Set the page margins to the following measurements: Left=2.5cm, Right =2.5 cm, Top =1.5 cm and Bottom =1.5 cm.

(ii) Insert a title calledINTERNETto the top right in Arial black,

and with font size 20.

(iii) Change the font of the text to 14 points.




10/188

(iv) Copy your text to another page end apply a 6 point shadow text

border around the typeset document.

(v) Number your pages in upper alphabet.

(vi) Insert the current date and time in the lower bottom margin.

(vii) Add a footnote asHow the internet works

(viii)Insert a header as your name and class

(ix) Drop cap letter F at the beginning of your Text

(x) Print your work

Question eleven

Below is a schedule for Sunday Services for December 2015 at the bigchurch in Kampala. The schedule is shown on the billboard below.

KAMPALA CHURCH OF GOD

P.O.BOX 111333 KAMPALA

People going to church Picture of the church

DECEMBER 2010

MON TUE WED THUR FRI SAT SUN

TIME TABLE

29 30 1 2 3 4 5 Time Activity Preacher

6 7 8 9 10 11 12 8:00 AM

10:00AM

First

Service

REV.

PETER13 14 15 16 17 18 19

20 21 22 23 24 25 26 10:00AM

12:30PM

Second

Service

PR.

JOEL27 28 29 30 31 1 2

Required(a) Design the above table using a suitable word processor.

(b)Insert appropriate clip art image for people going to church and the

picture of a church in the spaces provided in the above table

(c)Copy the table to another page and put in the provision for example

evening service beginning at 4:00 pm to 6:00pm




11/188

(d) Add a footnote as Church Service time table 2015

(e)Insert your name and index No as footer

(f)Print your work

(g)Save your work in a folder bearing your names as Time table 2015

Question twelve

(a) Using Microsoft word,

I.Design a certificate for any club of your choice in your school.

II.Apply a border to detach your certificate and an appropriate

background.

III.Use appropriate fonts and signatories to your certificate.

IV.Design a logo for your certificate.

V.Save it in the names of your club and print it.

(b)Using Microsoft word

I.Design the badge of your school

II.Design the logo of your school badge

III.Apply the necessary parts of the badge

IV.Use the appropriate fonts to make your work look nice

V.Save it in the names of your school

VI.Print a copy of your work.

Question thirteen

Using appropriate word processing program, prepare extracted document

from www.monitor.co.ug of July 20, 2015;

Thinnest laptop computer unveiled

Apple computer boss, Lenard Job last week unveiled the world’s thinnest

computer laptop computer called MacBook Air.

The computer, which is 0.76 inches (1.93 cm) at its thickness point, was

unveiled at an event in San Francisco.

About the laptop, Mr. Jobs said “it’s an amazing feat of engineering”

It does not have a CD or DVD drive in order to save space.


http://www.monitor/mailto:[email protected]://www.monitor/mailto:[email protected]


12/188

It was built to be wireless machine, he added.

The MacBook Air is the new 13.3” wide-screen. Ultra-portable from

Apple.

It’s only 0.75” thick and weighs only 1.4 kg.

It comes with 80 GB hard disk or high end model that makes use

of 64 GB solid state drive (SSD).

Think of this like a 64 GB flash disk, so with no moving parts such

a drive legally eliminates seek time, latency and other electronic-

mechanical delays and failures associated with convectional hard

drives.

This the boot time, files accessed and searches shall be in order of

seconds.

This machine goes on sale and in

two weeks and costs from $1,799in the

s (£1,99 in the UK) and

comes with either an 80gigabyte hard drives as

standard or 64 Gigabyte solid

state drive for an added $999.U Apple worked with cheap maker Intel to produce a small version of its

core 2 duo processor for the laptop.

Source: the Sunday monitor January 20, 2008 BBC.

Required

a)Copy the document you typed on page one and paste it on page

two.

b)Number the pages on top of your page in uppercase alphabet,

center them

c)Centre, bold and underline the heading of the pasted document

with 16 point, stencil.

d)Indent sentences 2 and 3 by 1.2 inches on either side, single space

and italicize them. The rest of the document should be 1.5 spacing

and justified.

e)Include bullets on paragraph 3 so that features are clearly seen.




13/188

f)Bold the range of sales as indicated in the text.

g)Provide left align italicized, bolded font 8 footer called “revolution of

computer engineering” plus your names in font size 12.

h)Provide a background of your choice.

i)Insert a water mark of your name

j)Save your document as your registration number as its name.

k)Print your pages that is A and B

Question fourteen

Mr. Edward is a house teacher in LAKE VIEW KITINDA C/U HIGH

SCHOOL. His school will be holding its inter-house MDD competitions

soon: Being a Day school, Mr, Edward needs to put in extra time to

perfect most of the activities. He intends to send special letters

requesting parents to release their children on non-schooling day for

practice.

The contents of the letter will be in the same for all parents except for the

parents’ personal details and titles; below is the letter to be sent and a

table showing the personal details of the different parents

LAKE VIEW KITINDA C/U HIGH SCHOOL

P.O. Box 53,

ENTEBBE

10th JULY 2016




14/188

THRU: THE HEADTEACHER

TO: Parent/Guardian of:

Dear

RE: REQUEST TO RELEASE YOUR CHILD ON SATURDAY 26TH JULY

As the annual Inter-house MDD competitions draw nearer, our hose is

devising means of increasing time for practice.

I hereby request you to release your on the above

mentioned date, to enable us polish his/her performance as a

.

We will be grateful for your positive response.

Yours faithfully,

…………………..

Mr. Nkoyoyo Edward

HOUSE MASTER-UGANDA HOUSE

Student’s

Name

Parent’s

Name

Phone Number Title Gender Category

Okech Kate Mr.Okech Moses 0703-232 522 Sir Daughter Dancer

Kale Angel Ms. Nankya Percy 0772-545 333 Madam Daughter Actress

Ssali Ben Mr.Ssali James 0752-562 418 Sir Son Actor

Bbaale Tonny Mr. Bbuye Bob 0712-214 555 Sir Son SingerNambi Annet Ms. Sonko Sally 0783-655 631 Madam Daughter Actress

Ladli Robert Mr. Okidi Fred 0752-989 536 Sir Son Drummer

Required

a)Type the letter and save it as permit Letter-Your name




15/188

b)Create the table and save it as permit table-Your name

c)Include a header of your name and index No on the letter

d)Insert current date and time in the lower bottom center of your

letter and update it automatically.

e)Insert a three lines 3 point page border on your document (letter)

f)Using appropriate word processing feature link the table to the

letter so as to generate 5 letters to be sent to the respective parents

of the participants in Mrs. Sylvia’s House.

g)All merge fields inserted should be bolded

h)Set the left and right page margins to 1.5 inches.

i)Insert a printed water mark of the name of your school in the

entire document.

j)Make the reference appear in blue colour font size 14 Arial Black

style and the rest of the text 14 font size and in Black times Roman

k)Print the 6 letters.

Question fifteen

Mrs. Kaine Aisha is a secretary of Booster Trading Company Ltd and her

company wants to invite shareholders for the Annual General Meeting

(AGM). The contents of the letter are to be similar to all shareholders

except for each shareholder’s personal details and titles.

Mrs. Kaine Aisha has prepared the letter below to be sent to various

shareholders.




16/188

BOOSTER TADING COMPANY LIMITEDP.O.BOX 5678, WAKISO

22nd /o5/2015

TO: [title]

[Shareholder’s name]

[Address]

[Telephone contact]

Dear sir/ madam,

RE: ANNUAL GENERAL MEETING SCHEDULED FOR FRIDAY 30th

NOVEMBER 2013

You are cordially invited to attend the AGM without fail on the date

indicated above starting 10:00 am. In this meeting we shall elect new

office bearers.

Each shareholder is expected to pay non-refundable amount fee of[fee] to cater for elections.

Agendaof the meeting is attached here on

See youthere.

Yours faithfully

KAINEMBABAZI AISHA

COMPANY SECRETARY

C.C Managing Director

Below is the table showing a list of various shareholders to receive the

above letter.

Title Shareholder’s

name

Telephone

contact

Address Fee




17/188

Mr. Dr Joma T 0772456678 570,Nairobi 80000 /=

Mr. Rev Obina P 0774678000 320, Kampala 65000 /=

Rev. Dr Baleke g 0776878797 321, Luwero 45000 /=

Mrs. Damba Don 0998987877 786, Luwero 12000 /=

Mr. Br Fatty Fire 0456752869 768, Wakiso 100000 /=REQUIRED

(i) Type the letter and save it as booster plus your name

(ii) Create the table and save it asshareholder-your name in your

folder

(iii) Include a header of your name3 and index No on the letter

(iv) Insert current date and time in the lower bottom center of your

letter and update it automatically.

(v) Insert a three lines 3 point page border on your document(letter)(vi) Using an appropriate word processing feature link the table to

the letter so as to generate 6 letters to be sent to the respective

shareholders.

(vii) Insert a back ground color of your choice.

(viii)All the merge fields inserted should be bolded

(ix) Set the left and right page margins to 1.5 inches.

(x) Insert a printed water mark in red of the name of your school in

the entire document.

(xi) Make the reference to appear in blue colour font size 14 Arial

Black style and the rest of the text 14 font size and in black

colour Times New Roman.

(xii) Drop cap the first letter of your body-letter to three lines and

make it justified.

(xiii)Set your page to landscape orientation and adjust your letter

appropriately.

Question sixteen

Using a word processor of your choice, typeset the following passages as

it is.

SAVOURY POTATO CAKES

Ingredients:

500g cooked and mashed potatoes.




18/188

120g grated cheese

Salt and pepper

60g flour

Cooking oil

1 tablespoon Royco Muchuzi mix

Mix the mashed potatoes well with Royco, flour, salt and pepper.

Roll out onto a flour board and cut into rounds using a biscuit

cutter. Heat the oil i a frying pan and fry the cakes until golden brown.

Remove from the fat and drain. Sprinkle cheese on top of each cake

and put under grill until golden brown too.

Serve hot. If you do not have a grill, put the cakes on a clean

chopping board or metal tray. Put large, hot coals on a wire rack or meshand hold it closely over the cakes until the cheese melts and turns golden

brown.

You can serve 6.

[Adapted from Malaria Murore-daily Monitor Saturday May 5th 2007, page

11, col 5]

i. Apply a 6 point shadow border around the typeset document.

ii. Bullet the list of ingredients.

iii. Apply colour green on the heading, centre it and change font to

13.5”.

iv. Double space and justify the body of the text.

v. Set page margins to 1.8” left, 1.5” right, 1.5”up and 1.6” bottom.

vi. Create another page of the same passage without retyping.

vii. Number the pages in uppercase alphabet.

viii. Insert the current date and time in the right lower bottom

margin.

ix. Save your work in your name and index number.

x. Print your work

Question seventeen




19/188

(a)(i) Type the text below using word processing program.

Choosing word processing software

Word processing is the using of computer to enter, store, manipulate and

print text in letters report books and so on. Once you have used word

processing you will probably wonder (like a million other before you) how

in the world you ever survived without it.

As more word processing come on market, choosing the right software

becomes confusing. Nevertheless, there is a word processing package

that will serve your needs. As you begin looking, ask yourselfer these

questionsI What type of document am I

Now producing?

IIWhat type of features do I

need?

want?

Document types can range from simple letters and memos to proposals

reports, legal documents, books, newsletters, scientific packages. Forexample, if you write articles that require references, you will need the

footnoting features; if you develop a newsletters, having the multicolumn

layout features would be handy; if scientific nation is needed, you will

want super scripts (X2+Y2) and subscripts (A21); and if you send

“personalized” form letters the mail merge feature is a necessity.

A number of add-on program are available to enhance the functionality of

word processing packages. These include:

On-line thesaurus

Spelling checker

Style checker

Idea processor (outline)




20/188

What you can do with word processing is only limited by your

imagination and willingness to learn the system. Good luck in your

computer assisted writing adventure-now and in feature

Required

(ii) Insert the header the word “Tips” on left hand corner and “Word

processing” on the right corner

(iii) Bold the heading font size 22-point underlined and center it.

(iv) In paragraph starting with the “document” bold the second

statement.

(v) Make 2 the superscript of X and Y in the expression (X2+Y2) and

21 subscript of A in expression (A21).(vi) Insert bullets on the list of functionality of word processing

packages given in text

(vii) Insert footnote of your name on left and page number on right

corner.

(viii)Use appropriate format to replace the word “notation” with the

other one of same meaning.

(ix) Use the appropriate format to replace the word “notation” with the

other of the same meaning.(x) Indent the whole document by ‘0.5” to both the left and right hand

side.

(xi) Insert a clip art picture in the middle of the paragraph, which

begins with “Document”.

(xii) Save your work under your name.

(xiii)Print a copy of your work.




21/188

Question nineteen

(a) (i) Type the text below using a word processing program:

HUMAN RIGHTS

Historical images of Apartheid in South Africa

Apartheid consisted of numerous laws that allowed the ruling white

minority in South Africa to segregate exploit and terrorize the vast

majority: Africans, mostly, but also Asians and colored people of mixed

race. In white –ruled South Africa, black people was exploited, their lives

segregated.

Under Apartheid, racist beliefs were enshrined in low and any criticism of

the law was suppressed. Apartheid was racism made law. It was a

system dictated in the minutest detail as to how and where the large

black majority would live, work and die. This system of institutionalize

racial discrimination defled the principles of the United Nations charter

and the universal Declaration of Human Rights.

In 1976 the united Nation unanimously condemned the elevation of oneof the “homelands”, Transkei; into an independent state because it

remained dependent on South Africa .Not one country in the world

recognized the new state. In 1982, almost one million black South

Africans were transferred to another country -- Swaziland—without their

having ant say in the matter.

Ultimately, blacks demonstrated, held strikes and rioted over such

discriminatory practices. As a result, diplomatic pressure mountedabroad for exchange. In 1990 Nelson Mandela who had devoted his life to

democracy, equality and leaning for all South Africans was released from

prison after serving almost 30 years for those beliefs.




22/188

He was elected president of the African National Congress the following

year, and 1993 received the Noble Peace Prize on behalf of all South

Africans who suffered and sacrificed so much to bring peace to their

country. On May 10, 1994, Nelson Mandela was elected South Africa’s

first black president in that country’s first truly democratic election

Required

(ii) Insert in the header the word of your choice on the left hand corner

(iii) Bold the heading font size 18-point, underline, italicize and center it

(iv) Block indent all paragraphs by 1-inch in the left and right margins

(v) In he forth paragraph, starting withOn May……..Bold the second

sentence.(vi) Make the body font size to 13 and font style to Aerial

(vii) Justify your work

(viii) Create two columns in the passage and he footnote of your school

and name on right corner

(ix) Save your work as your name and make a print out

Question twenty

Type the text below using word processing program

On decision to buy

The members of exchange require that forwarded payments be made to

reduce default. On making the buying order, clients will fill in the client

information form, an order and sign a purchase transfer form and then

pay for the number of shares he/she is willing to buy and broker will

issue him/her with a receipt. On the day the order is executed at theexchange, the broker will then send his/her buying client a purchase

contract note showing the number of shares purchased, the price per

share and the commission chargeable. A purchase contract note is a

legal document that acts as proof of ownership until the share certificate

arrives therefore it must be kept safely.




23/188

At the same time, the broker forwards the signed Purchase Transfer

Form to the registrar through the exchange. The registrar upon receiving

your transfer form through your broker issues a new certificate in your

name via the same broker. This certificate is legal document confirmingownership and should be kept safely.

Required

(i) Set the page margin to “1.5 ‘ to left and right of document

(ii) Apply a harder to a document which should among others a

name of the company in word art, address, logo and lines

(iii) Apply “1.5” line spacing to your work.

(iv) Drop the first letter of each paragraph(v) Capitalize the title and format it accordingly.

(vi) Save your work and make a print out.

Question twenty one

Use Microsoft word to enter the records below

No. Name Address Contribution

1 Alfonso Miguel P.O.Box14, Kamuli $300

2 Loren Mark P.O.Box23, Mbarara 200,000/=

3 Alfredo Manuel P.O.Box21, Kampala 30 kg of maize4 Tim Howard P.O.Box20, Kasese

Required

a)Apply three line boarder to the table.

b)Bold and capitalize the title.

c)Insert three rows below and insert records of your choice.

d)Sort the names in ascending order.

e)Split the column for Lorena and enter another name.

f)Split the row for Tim and enter another record.

g)Insert a row at beginning, merge it and key the title for the table.

Question twenty two

Make a headed paper of your company




24/188

a)The header should include among others, the name of company,

address (box number, email address, phone number and fax) and

date.

NB: The name of company should be done in word art

b)Apply a logo of company in the herder.c)Make the company’s motto as footer.

d)Apply a line at the header and footer with 4 ½ line style.

e)In the normal view, list down the products or services offered by your

company.

Question twenty three

Construct the table below and answer questions that follow

Particulars Quantity Price@

Dry cells 30 120000/=

Threads 15 12000/=Connecting wires 27 15000/=

Resistance wire (SWG28) 27 20000/=

Torches 4 18000/=

Ammeters 50 20000/=

Voltmeter 50 20000/=

Bulb holders 50 2000/=

Cell holders (single) 100 4000/=

Concave mirror (f10) 40 5000/=

Concave mirror (f15) 40 5000/=

a)Insert a column before particulars to number the particulars.

b)Insert a column after price to calculate the amount.

c)Delete the rows for torches and bulb holders.

d)Insert a row at bottom to calculate the total amount of products.

e)Make row height “0.3”

f)Save your work and make a printout.

Question twenty four

Type the text below as it is exactly and follow the steps as will be

indicated in the text bellow :




25/188

It’s the answer spoken by the young and old, rich and poor, Democrat

and Republican, black, white, Latino, Asian, Native American, gay,

straight, disabled and not disabled-Americans who sent a message to the

world that we have never been a collection of Red States and Blue States:

we are, and always will be, the United States of America.

It’s the answer that led those who have been told for so long by so many

to be cynical, and fearful, and doubtful of what we can achieve to put

their hands on arc of history and bend it once more toward the hope of a

better day. It’s been a long time coming, but tonight, because of what we

did on this day, in this election, at this defining moment, change has

come to America.

Required

(a) Insert a header of your document to be B̀arack Obama Victory

Speech̀ in the centre and the footer to bèChange has come to

Americà. This should be at the right hand corner.

(a) Insert a footnotèChange for the better̀

(b) Drop the first letter to cover 2 lines.

(c) Save your work and make a printout.

Question twenty four

You have been asked to send invitation letter to people to be invited for




26/188

Your graduation party. The letter contents are same for all the persons

except the addresses, names and pledge.

Below is the letter to be sent and a table of people and their pledges.

St. Edward Rest.P.O. Box 8125,Kampala

23rd July 2009

[TITLE]

Dear[NAME],

You are invited to attend a wedding ceremony of Salvador Sarenza and

Isabelle Oroyal scheduled to take place at st. Anthony restaurant and

takeaway, Buganda road.

Please don’t forget your pledge of[pledge].

We shall be very grateful if our invitation is honored.

Thanks,

Yours truly,

…………………………….. ADRE CORONA

B",o% #" !$" -,"").

Name Address Pledge

1 Rostte Bugolobi Cake

2 Keith Kasubi Wine

3 Hyde Kitintale Bride shoe

4 Hearte Bunga Gift

5 Reina Mutungo Gown

Required

(a)Use the appropriate method in any word processing program to make

a letter to be sent to each person in the table.

(b)Save your work as your names and make a printout.




27/188

Question twenty five

Using Microsoft word, type the statements below and answer the

questions that follow.

IRR analysis is generally used to evaluate the project’s cash flows, rather

than the income from the project that would be shown on an income

statement (also known as the profit and loss statement). Why? Because

on a P&L reflects depreciation, but depreciation is not an out –of-pocket

expenses. For instance, if revenue of $10,000 is reduced to $7,000 of

income because of a $3,000 depreciation deduction, you still have theuse the full $10,000. So the cash flow figure of $10,000 is usually the

more instructive one to look at. However, if you are very concerned about

the appearance of your income statement (for example if you anticipate

putting the business up for sale or seeking the major financing in the

future, or if you’re under stockholder pressure for increased income) you

may decide that the income figure is more appropriate to use.

How do you compute the IRR? .The easiest way is to use a good financial

calculator. if you don’t have one , or don’t want to take the time to learn

to use one, you can also use the present value table located inBusiness.

Tools.

Required

(a)Apply line spacingof 0.5 to the document.

(b)Justify your work to look orderly.

(c)(I) make a copy of the document and paste to another page.

(II) In the first paragraph, shade the first sentence with color blue.(III) Indent your work by 0.5 to the left and right.

(IV) Save your work as “Investment” and make a print out.

Question twenty six




28/188

1.Use a word processor of your choice to produce the document

below as it appears

ICT AS A TOOL FOR TEACHING AND LEARNING

he term ICT stands for Information and Communication

Technology and is defined as a “Diverse set of technological tools

and resources used to communicate, and to create, disseminate,

store and manage information”. ICT has become a very important part of

the educational delivery and management process. ICT has largely

facilitated the acquisition and absorption of knowledge, and hence can

provide extraordinary opportunities to developing constituency, and

thereby for raising the level of quality life of their people.

T

Required

a)Copy the document to another page

b)Double space the text in the document

c)Italicize and bold the word ICT throughout the document

d)Use “Times New Roman” font size, “12” for the entire document

e)Insert your name and personal number as the header and footer

respectively and centre align them

f)Use mail merge feature to post the document above to the recipients

below

NAME ADDRESS COUNTRY

MS. AKIIRO GRACE P.O. BOX 23 KAMPALA UGANDA

MR. ASIIMWE ANDREW P.O. BOX 16 NAIROBI KENYA

g)Save your work as your name and personal number

h)Print all your work

Question twenty seven

(a) (i) Enter the table below into a word processing program as it is.




29/188

Computer College, Kalungu ADMINISTRATION KITCHE

N

COMPUTER

DEPARTMENT

DORMITORY SICK

BAY

•

Headmaster’soffice GeneralCatering

Course to

Cater for

all

24 Computer ‘O’ Level boys Firstclass

medical

facilities

and care

• Deputy

headmaster’s

office

12 Modems ‘A’ Level boys

• Accounts office 6 Sets of

Speakers

‘O’ Level girls

• Examinations

office

• Director of

studies

‘A’ level girls

Sports Complex

Swimming pool Gym

i. Insert your name and index number as your header.

ii. Save the document on a CD-rewritable as “My doc”

Question twenty eight

Using Microsoft word, type the statements below and answer the

Questions that follow.

Tips for financing major purchases

Don’t fall for expensive products. Service contracts that are pitched to

you when you buy a piece of business equipment are often good deal for

the supplier – but not for you. In most cases, the amount you‘d spend on

a service contract is wasted money. This is especially true in case of

generic equipment that normally caries a warranty anyway – if some




30/188

thing is going to go wrong, it will generally do so in the first 30 days to 60

days, when your warranty should cover your problem.

There may be situations where service contracts are good deal. For

example if the equipment was custom-built and is expected to needregular maintenance in future, if the space parts and knowledge lobour

will be hard to find, or if getting repair done immediately is extremely

important to your business’ operation, you might decide to purchase a

service contract on trial basis.

Compare the NPV of loan payments. If you have decided to purchase a

major asset and are planning to take out a loan, a good way to compare

option available is to do a net present value analysis of your cash flowsunder the various interest rates and terms your local lender have

available. Your cash flow project should consider the loan payment

outflows as well as revenue inflows that would result from your purchase

or project.

Required

a)Format the title to font size 18, centered, bold with uppercase.

b)Justify the sentences.

c)Drop the first letters of the paragraph.

d)Format your work to be double spaced.

e)Apply two columns to your document.

f)Save you work as your name.

Question twenty nine

14.Type the document below in word processor.

Is network marketing just a scam




31/188

There’s huge difference between network marketing and pyramid

schemes. Learn the truth here.

Q: Some friends try to recruit me into network marketing deals that seem

like some type of money game or pyramid. Other friends tell me they’re

illegal and I’ll get into trouble. How do I know what’s legal and legitimate?

A: To help you understand what network marketing is, I must first

explain what it isn’t.

First, network marketing isn’t a pyramid scheme. Pyramids are programs

similar to chain letters where people just invest money based on

promises that other people will put in money that will filtrate back tothem and somehow, they’ll get rich. A pyramid is strictly a money game

and has no basis in real commerce. Normally, there is no product

involved at all, just money changing hands. Modern-day pyramids may

have a product, but it’s Cleary there just to disguise the money game.

Required

(i) Change the heading to upper case

(ii) Change the font of the whole document to Tahoma, point size 11

except the heading which should be point 15

(iii) Drop the first letter to cover two lines of paragraph

(iv) Apply 1.5 line spacing

(v) Indent your work to 0.5 to left and right respectively

(vi) Justify your work

(vii) Add your name as harder.

(viii)Save your file as “Networking and business” and make printout




32/188

Question thirty

(i) Using a word processing program, key in the document below as it

appears and save it as “energy cries”

Depending energy crises

Almost Kampala have shifted from using electricity to charcoal,

Mpreviously regarded as cheap energy source for the poor. But charcoal

price gas doubled within less than a year.

“The country is already neck-deep in the firewood crises”, says Ditch,“Now people paying for not taking action”

However, ditch says the energy crisis is localized meaning that some

areas have been hit by the scarcity while others have in abundance.

To copy, some people especially low income earners now buy cooked food

from the evening road side markets.

Adapted from New Vision Monday, December,22,2008

Required

I.Insert the following table after the second paragraph of the

text above.

Source of fuel in Uganda Innovations

• Firewood

•

Charcoal• Kerosene

• gas

Improved stoves

hydro




33/188

II. Copy and paste the last two paragraph into the second page of this file

and do the following to the copied text: insert the title “effect of the

crises” make it italic and underlined and font type Arial black.

III. Change the font size of the body to size 14.

IV. Change the left indentation of the last paragraph to 0.5

(inches).

V. Insert your name and index number as the footer of your

document.

VI. Save your worker as “illustrations”and make a printout

Question thirty one

(a) Use a word processor to prepare a computer based version of report

below, for the product Buying Company.

REPORT

During the month of June, the Company dealt in five types of produce:

maize, beans, rice, Sim-sim and groundnuts. The major client countries

have been Zambia, Zimbabwe, Malawi and Mozambique.

The quantities exported are detailed below:

Code

Number

Item Quantity

(‘000 Kg)

Local Cost Price per

Kg (Ug. Shs)

001 Maize grain 200 200

002 Beans 500 180

003 Rice 800 650004 Sim-sim 1,000 800

005 Ground nuts 650 850

Special report:




34/188

The price of maize went up relatively, because of the dry season. The rest

of the items were about the same price as last month.

Complied by: (Name and index number)

Operations OfficerDate: …………………………….

Required

Save your work as “produce 1”

i. Assuming you are working for this company as operations manager/

Officer, use a word processor to create the above report and assign it

an appropriate title. Use font size 16, New times Roman, blue colour

for the title and new times roman, black size 12 for the whole

document.ii. Insert an appropriate picture at the top of the report to serve as your

logo.

iii. Put the export quantities data detailed above in the table.

iv. Save your work in a folder called “Report” and the file as “Produce 2”

Question thirty two

Type the following information as it is: (use font size 14). The time table

below will be our by the beginning of next term academic year. It should be copied and filled withrelevant subjects.

Senior Four Time Table 2010 8 : 0 0-

9 : 0 0

9 : 0 0-

1 0 : 0 0

BREAK

1 0 : 3 0-

11 : 3 0

11 : 3 0-

12 : 3 0

L UN CH

2 : 0 0-

3 : 0 0

3 : 0 0-

4 : 0 0

FREE




35/188

Put a footer as your name and index number

Colour “Senior Four Time Table 2010, BREAK, LUNCH and FREE

Save your work as your name and index number

Print your work

Question thirty three

(i) Type the article below as it appears

Family Fun

Friday, 4th June, 2010

The bread and side dishes

Harry was a married man who succumbed to the temptation of a

girlfriend. But this new catch did not like his beards. From the first day,

she started coaxing him into shaving them off. “But my wife loves this

beard; I could not possibly do it. She would kill me,” Harry replied.

That set the girlfriend to have the beard cut if only to check her prowess

against hers. A month later, she told Harry the relationship had to end

because he had refused to shave off his beard. Harry was madly in love

and decided to have the beard removed.

That night, fearing his wife would raise hell over the beards she loved so

much, Harry came late and sneaked into bed while the wife was sleeping.

When the wife woke up and left him, she startled out of her sleep.

“Mike!” She exclaimed. “You still here? How did you forget? You must go

home before my husband comes. He must be on his way. He will be here

soon.”

Required




36/188

i. Copy the article to page 2 and use it to answer the following parts:

ii. Capitalize the heading and centre it in font size 18

iii. Create a hanging indent in the second paragraph

iv. Give a line spacing of 1.5 to the third paragraph

v. Drop letter “T” in the third paragraph to three lines

vi. Create a three lines boarder around the fourth paragraph

vii. Create a footer called beards and centre it

viii. Save your work

ix. Print your work

Question thirty four

Using any word processing software type the text below.

MY SHOES Thank God for my shoes-they fit.

I woke up one day and realize that there were many things about my life I

was not satisfied with or better still, there were challenges that were

threatening my soul and I said to myself, “Why should anyone envy me

and want to in my shoes”. They said did not know how far I have come,

they do not know what lies ahead of me, and neither do they know what

dissatisfaction I get with myself from time to time.

People do not know the trouble that you have had or the price you had topay to get where you are. All they to know is that they wish they were like

you. Why should you wish you were in any body’s shoes when you hardly

know how they fit? When you have worn your shoes for a while, they take

the shape of your feet and align to the way you walk. If you were to wear

my shoes, you would not be comfortable in them. So I stop to wishing

that I am in some ones else shoes because they might not fit: rather I

thank God for my shoes, because they fit! I have learnt to be the best in

what I do and I know no one can replace me anywhere and in my sphere.

I am original, my God is not in the cloning business. He makes originals!

Make the best of you do; besides you have this beautiful life to live ONLY

ONCE. Live it to the fullest.

Required

i. Spell check the text




37/188

ii. Set the text font to papyrus

iii. Set the text to single line spacing

iv. Make the text justified

v. Set the text size to 20 points

vi. Add a relevant footnote to your text vii. Place your text in two equally spaced columns with a line between

them

viii. Insert a word art with the words- TECHNOLOGY IS WONDERFULL

ix. Save your text and then produce a hard copy of the two pages.

Question thirty five

You are chosen among the S4 candidates attending a computer seminar

in Munyonyo Kampala to evaluate the seminar and give a vote of thanks

to discussants, write brief report of at least three paragraphs with each

paragraph having at least four lines.

(i) Space your lines with 1.5 inches and justify your work.

(ii) Save your work in the floppy disk provided as work in the folder of

your both names created on the floppy disk.

(iii) Mail merge your letters to the following addresses

The headmistress

Mayhill high school

P. o. box 360

Mbarara

Uganda

The headmaster

St. Joseph’s voc. School

P. o. box120

Mbarara

Uganda

The headmaster




38/188

Mbarara High School

P. o. box 205

Mbarara

Uganda

(iv) Copy the content in the second and third paragraphs of page one

and paste it on page 6.

(v) Duplicate the two paragraphs on page 6 and make them six

paragraphs. Then apply three columns to page 6.

(vi) Insert a text box in the middle column of page 6 and in it put your

name and Reg. number. Apply appropriate designs in your text

box.

(vii) Insert page numbers and save changes to your work.

Question thirty six

(a)Load an appropriate word processing application program and

process the following text:

21 June 2003

The personnel officer,

Africa one Traders,P. o. box 20,

Entebbe Airport.

Dear Sir,

CONCERNS ABOUT DATABASE SKILLS

As you are aware, the previous board of director’s meeting directed that

all professional staff be equipped with computer skills particularly

Database skills. They have to know how to design database tables,

queries, reports and forms. This is important for everybody but especially

staff in our accounting and salary sections.




39/188

They need skills in addition to spreadsheet modeling and word

processing.

Please urgently arrange for their training in the prestigious summer

university, the coming summer that shall run from July 20- August 252003. Ensure that they get their appropriate travel and out station

packages including a booking to in economy class.

In case you have any questions, please do not hastate to contact me.

Yours sincerely,

AbdulZak Peter

Required:

i.Centre and bold the heading with font size 20, Arial Black.

ii.Indent paragraph two to 2.5” on either side and italicize it.

iii.Save your work with the name THE LETTER

iv.Print the letter.

(b) Make a copy of the above letter and paste it on a new workspace and

name it mail document and send it to the following personnel officers:

(i) The personnel officer, (ii) The Regional officer,

Mega Traders, Wally’s Traders,

p. o. box 210, P. O. Box 12,

Luwumu street, plot 34 Tel: +256775 610 762 Tel: +256778 669 259 Ibanda, Uganda.

Kampala, Uganda

Question thirty seven




40/188

(i) Type the following information as it is: (use font size 14) for the

subjects. The time table below will be out by the beginning of next

academic year. It should be copied and filled with yourrelevant

subjects.

Senior Four Time Table 2014 8 : 0 0- 9 : 0 0

9 : 0 0-

1 0 : 0 0

BREAK

1 0 : 3 0-

11 : 3 0

11 : 3 0-

1 3 : 3 0

L UN CH

2 : 0 0- 3 : 0 0

3 : 0 0-4 : 0 0

MON

TUES WED

THUR

FRI

SAT

Note: The table title is in font 18 while BREAK and LUNCH in font 28,

the outer boarders are (3) triple lines.

(ii) Provide color “pink” to senior four time table 2014, BREAK

LUNCH and FREE. Days of the week should be in green while your

subjects should be in blue.

(iii) Write the following information on top of your table.

Equatorial College Ibanda

P. o. box 53,

Ibanda




41/188

28 March 2014

(NAME)

(CLASS)

(TITLE)Dear (sir/madam),

RE: CHANGE IN THE TIME TABLE 2014

Please you are informed of the changes in the time table.

Kindly adjust.

Yours DOS.

Post your letter to the following personnel with their details.

NAME CLASS TITLE SIR/MADAM

AGIIRA PAUL S3J DEPUTY H/M SIR

ATAYO JANE S4K SENIOR WOMAN MADAM

ASIIMWE

PETER

S1L GAMES MASTER SIR

Save your work as TIME TABLE 2014 plus your names as header and

footer respectively.

Print your work.

Question thirty eight

10. Carefully study the text below and answer the quotations that follow:

Spirit of Ferguson will live to Haunt and Torment Many Clubs




42/188

Thinking that Man. United is the only EPL top-four team in trouble is a

reflection question. United whenever they started underdogs they

performed well. Reflect on the 2011/2012 season.

When they clear off their seemingly games for the 2013/14 season, it isgood for May 2014. Ferguson one time said that the premiership is won

in may. United are the defending champions.

United never had fleets of high profile players.

David Moyes has support of almost everybody at Old Trafford Fergusson

was not chased the Mourinho was by Chelsea.

Crossing to Merseyside was never a joke.

David has a point to prove

Players will continue to be paid on results. When one says that United is in trouble because of playing Chelsea.

Liverpool and Man-city in the opening games, and you do not appreciate

the fact that also Chelsea, Liverpool and Man-city are in trouble because

of going to play united, and then we do not deserve to be in the logical

sports world.

Required

(i) Load a word processor of your choice and save your work as

“Ferguson sprit”

(ii) Typeset the above passage as it is exactly

(iii) Apply an outside boarder on the last paragraph

(iv) Apply an appropriate word art style onto the title with 24 font size,

and color yellow

(v) Insert a table before the last paragraph with six rows and four

columns. The column titles are; NO, Team, Position and Points. Set

the line spacing of the last paragraph to 2.0 points

(vi) Insert a text watermark of your name and index number

Auto number the reasons for United being Still strong.

(vii) Set the margins to 1.5cmleft and 1.5cm to and bottom

(viii)Apply a justified alignment on your text in the last paragraph

(ix) Apply a light orange back ground and blue color to the rest of the

text and a three page boarder around the document




43/188

Question thirty nine

Load appropriate word processing program and enter the following text.

GRANDMOTHER:

One moring, grandmother came down with fever. She was in bed when

Red Riding Hood came to visit her. The little girl was very concerned

aboiut the health of her grandmother and stayed with her for the whole

afternoo. When it was becoming dark, Red Ridding Hood told her

grandmother that to leave as her mother would become concerned if shedid not return home. She promised to return early next morning.

In the woods where grandmother lived, a cunning fox usedto see Red

Ridding hood every day. It dearly wanted to make a mal of the litle girl.

But it dared not to chase the little girl through the woods as some

woodcutter was likely to see them and come to rescue the girl.

Requiredi. Bold the heading GRANDMOTHER and make it size 14

ii. Create two more pages 2 and 3, copy the two paragraphs you

entere in page 1 to page 2 and page 3 of your document.

iii. Using pae 1, replace the text fever with malaria and italicize the

inserted text

iv. Using page 2 in your documet: underline the text she promised to

return make it blue color

v. Double space the lines of the paragrap two in page 1

vi. Insert the header to read as Red Ridding:tells story and your

names as footer.




44/188

vii. Number the pages of your document.

viii. Join the two paragraphs you pasted in page 3 and justify the

resulting paragraph

ix. Change the font type of paragraphs 1 in Page 1 to a different one

(papyrus)

x. Save the document as you rsurname on the CD-RW provided

Question forty

Use a word processor to produce the document below as it appears

HEALTH MOTHERS BOOST ECONOMIC DEVELOPMENT

As part of celebrations to mark international Mothers Day this Sunday,

New vision is the week higlighting issues that affect motherhood. Agnes

kyotalengerire explores women economic empowerment.

Thirty –year old mary okia, a

maried woman , clinics and

delivered ina health facility under Was able to deliver her three

children without there care of a

skilled health

worker.Complications becauseshe atteende antenatal

Required

(a)Set all margines to 1.5 centimeters

(b)Insert an image of a computer after the first paragraph

(c)Post the document above to the following recipeints:

1. Mr. Adaru Darlin 2. Ms. Atwine Groly 3. Atukunda Grace

Minister of health Minister of health Minister of health

Mbarara district Kabale district Maska district

Question forty one




45/188


46/188

(v) Add the following subheadings to the two paragraphs:

plumbingand views.

(vi) Now add the following as bullets at the end of the second

paragraph, keep the list double spaced:

Here are some of the emergencies that can happen

to flat owners:

1.Burst pipes 4. Blocked kitchen sink

2.Leaking washing machine 5. Blocked toilet

3.Nail through heating pipe 6. Leaking radiator valve

(vii) Apply two colors of your choice in the background and Save it as

Flats inside the folder bearing your name and index number on the

desktop.

Question forty two

(a) Type the document shown below exactly as it appears using a word

processor program. Save the document as trees. (10 marks)

BINARY TREES

Introduction




47/188

The term “tree” is used in computer science to denote a particular

type of abstract data structure. Trees contain data in structures called

nodes, which are in turn linked to other nodes in the tree. Every tree has

a primary node called a root, from which all other branch nodes in the

tree descends. In continuance with the botanical naming system, the

nodes that have no descendants are called leaf nodes.

Root node

Leaf node

Why should you use trees?

Primarily, trees are useful for organizing data in a manner that

makes it efficient to retrieve it. To illustrate this, is a picture of acollection of data organized in a linked list structure.

A binary tree is made up of nodes that can have at most two offspring

(children). The root node is the node that is not a child of any other node,

and is found at the top of the tree structure. A node with no children is

referred to as a leaf node. Nodes that are not root nodes or leaf nodes are

often referred to as non-leaf nodes.

(b) Copy your document to the next page (01 mark)

(c) Apply styles and formatting on the copied document as follows

i. The body text to be

Normal 12 points

Comic san ms

Justified (03 marks)

ii. Change the colour of the whole body text to blue. (01 mark)

(d) Insert headers and footers. The headers should be “your name” whilethe footer should be your “personal number” (02 marks)

(e) Insert page numbers at the top centre of the document. (01 mark)

(f) Format the second paragraph into two columns. (01 mark)

(g) Save a copy of the document and your folder and print a copy.

(01 mark)


5 3 9 7 11



48/188


49/188

(a)Type the above document in microsoft word (10 marks)

(b)Format the Title using font type elephant, font size 15, and alignment

center and font colour orange. (02 marks)

(c)Change line spacing to 2.0 for all passage (2 marks)

(d)Use justify to the passage in size 12 and font type Tahoma. (2marks)(e)Insert a background colour of your choice (2marks)

(f)Change the lastparagraph to upper case (1mark)

(g)Insert a footer note of your names and header of the course you are

doing. (2marks)

(h)Insert a water mark as Santorum. (2marks)

(i)Save the work as Race. (2marks)

Question forty four

(i) Using the suitable word processing software, type this document as it

is. (06 marks)

HUMAN BEINGS

Most infants are guided through life by a parent or guardian and taugh

how to talk, walk, eat and generally behave. The socialization process

beigins as soon as we are born when we being to imitate people around

us, copying the shapes and noises in our environment. Many other

people and circumstances affect our appearance, attitude and behavior,

such as work, lifestyle, ethnicity, family, environment, peer group(friends), gender, media etc.

Human beings are very different throughout the world and opinions of

what constitures a natural or nurtured human being differ enormously.

Without socialization, an individual would bear little resemblance to any

human being defined as “normal” by the standards of his or her society.

There have been some instances where a person has been deprived of the

assistance of a parent or any other social and human presenc. Thsee beings are oftern referred to as feral peopol meaning “wild”.

An example of feral people was the Wolf-infants of Midnapore who were

reportedly found in a wolf den in a Bengal forest in 1920. The infants,

age two and eight, walked on all fours, preferred a diet of raw meat,

howled like wolves and lacked any form of speech.




50/188

(Adapted from: Mckenzie and Bryden (2004:50), Introducing Word 2000 for

Windows)

Further Required(ii).Copy and paste the document to page 2 (02 marks)

(iii).Using the copy on page 2, center, bold and underline the heading

and make it font size 24. (02 marks)

(iv).Center align the second paragraph and make it all italics.(02 marks)

(v).Italicize the source of the document and make it font size 8.

(02 marks)

(vi).Spell check your document. (02 marks)

(vii).Insert your name and index number as footer. (02 marks)

(viii).Save your work asMyWork. (01 mark)

Question forty five

Use Microsoft word processing to write ten letters to ten students of

Hodge Road Elementary School for the field trip as below. Note these

students have different; Home address, Address 1 City, State, Postal

code and First Name. (20mks)

Hodge Road Elementary School

123 Mingo Bluff Road

Knightdale, NC 23456

Wednesday 2nd May 2013

>

>

>

>, >

Dear

This is to let you know that on June 3rd we plan to take ’s class on a day long field Trip to the Edison Home in North




51/188

Fort Myers. The trip will be the culminating activity after a five week

science unit where the work of Thomas Edison has been especially a

focus of interest for the class.

will leave and return within the normal time for the

school day, so there will be no disruption to your own schedule.

Please feel free to call at school should you have need to discuss this

matter further. Thank you.

Yours sincerely,

Donna Hendry

1st grade teacher

Question forty six

Type the following text exactly as it is and copy it to page 2 (06 marks)

STAYING VIRUS-FREE

omputer viruses are some of the biggest nightmares that

computer users all over the world face. A computer virus can

corrupt or delete important files, slow down the computer,

produce annoying pop-ups and even steal confidential information like

passwords and credit card numbers.

C As you have always heard time and again, you need an antivirus program

on your PC. However, most people use the free or trail programmes which

do not catch some new viruses or they expire soon and leave the PC

vulnerable to attacks.

• You need a licensed antivirus Programme which is dependable.

• Always keep virus definitions up-to-date since newer viruses are

created all the time.

• Regularly update all the software on your PC through the internet.

• Turn on the windows Firewall and if you can afford, get a personal

firewall like Norton Firewall and Zone Alarm.




52/188

• Avoid opening suspicious attachments and restrains from

forwarding chain-emails to all your contacts in your address book,

however nice those messages are.

• Almost all computers viruses are made targeting Microsoft

products like Windows and Microsoft office. Therefore, to avoid viruses, the best option is to turn open office.

• Since most viruses infect mainly Microsoft word documents, saving

all your work as Rich Text Format (rtf) will protect them from being

corrupted or deleted by viruses.

• Finally viruses are also spread from one PC to another through

flash disks. A write-protect lock on your disc can save you but you

can modify or add more files.

Required

(ii) Change the bulleted points on page 2 to numbered list

(02

marks)

(iii) Change the colour of your heading to blue. (02 marks)

(iv) Insert a footnote after the rtf and explain that this text is not

affected by virus. (02 marks)(v) Copy the precautions and put them in a frame which you can

put on the notice board of your computer laboratory for

students to read and understand. (05 marks)

(vi) Insert your name and index number as a footer. (01 marks)

(vii) Make a printout of your poster. (01 marks)

(viii)Save your work as virus poster. (01 marks)

SPREADSHEETS




53/188

Spreadsheet software is used to organize data in rows and columns and

performing calculations. The intersection between a row and a column is

called a cell. The figures are inserted into cells.

FEATURES OF SPREADSHEET PROGRAMS

Some of the popular features of spreadsheet programs include:

Recalculation. This helps the user to work out the rest of the worksheet

whenever work changes(available tool for what-if-analysis)

Built in functions. Allow the user to use functions to add, multiply,

make percentage, count and basic statistical functions.

Adjusting columns. Allows the user the ability to sort data accordingly

Data formatting. Helps the user to change both text and numeric data.

The fonts, sizes and styles can also be changed and the worksheet can

also be made attractive by using borders and shading.

Data validation. This is meant to ensure that correct data is entered in

the spreadsheet.

Printing. This allows the user to print the entire worksheets, proportions

of worksheets or several worksheets. E.t.c

Examples of spreadsheet software

♦

Microsoft excel

♦ Lotus1-2-3

♦ Corel Quattro

♦ VisiCalc

♦ Super calc




54/188

Question one

The following numbers of“Twegatte Savings and Cooperative Society”

took Loans from Gold Trust Bank. They were charged a handling fee

of 5% and an interest of 15% of the loan

Name Loan (Ush) period

Kato Sulaiman 500,000 2 years

Magembe Ivan 750,000 3 years

Nababi Justine 350,000 2 yearsKapere Douglas 1,250,000 6months

Sagala Martin 900,000 1 ½ years

Tumusange David 2,150,000 5 years

1)Create a worksheet with column headings NAMES, AMOUNT,

PERIOD, HANDLING FEES, INTEREST AND TOTAL PAYMENT.

2)Enter the above data

3)Using relevant formulae, calculate the handling fees, interest and

total payment for Kato Sulaiman.

4)Using the copy and paste features, complete calculations for all the

members

5)Create a 3-D column graph the total payment of each member.

6)Save your worksheet as in your folder.

Question two

i.Design a table with information/data created by yourself. The data

should be derived from items sold in the markets and their prices. Hint:the table should have five columns(for the markets e.g market 1, market

2 etc) and four rows (indicting the commodities sold in those markets)

ii.Create a scattered pie chart of one of the markets showing percentages

Question three




55/188

1. A company deals in six major stationary items, namely;

counter books, note books, printing papers, clip files, box files and

diaries

The table below represents the opening stock(O), closing stock ©,

Quantity sold (Q) selling price (S) and value of sales (V) respectively

where, Q=O-C and V=SxQ

A B C D E F

1 item Opening

Stock(O)

Closing

Stock

(C)

Quantity

Sold(S)

Selling

price (S)

Value of

Sales(V)

2 Note books 200 120 150

3 Printing paper 400 160 8000

4 Clip files 170 80 200

5 Box files 100 0 2500

6 Diaries 95 30 1800

7 Counter books 600 150 5000

Total

value of

sales

(i) Create a spreadsheet of data above, stating with item title in cell A3

and save it as“ stationery”

(ii) Put the appropriate formula in cell D3 to compute the amount

sold. Copy it to the rest of the column

(iii) Put the appropriate formula in cell F3 to compute V

(iv) Sum up column F to find the total value of sales

(v) Use the graph function a bar graph of sales for the various items.

Write your name and index number below the graph.

(vi) Save the graph asmy graph.

Question four




56/188

The following are transactions for KWAMI enterprises for the month of

May 2013

ITEMS BUDGET ACTUAL TRANSACTIONS

INCOME

Baby seats

Furniture

Salary

Sales of feeds

Miscellaneous

UG SHS

100,000

150,000

140,000

70,000

10,000

UG SHS

210,000

143,000

132,000

90,000

TOTAL

EXPENSES

Clothes

LunchesEntertainment

50,000

15,0004,000

20,000

17,0007,000

TOTAL

Surplus

Required

i. Enter the above data in a worksheet

ii. Add up the totals in the budget and actual transactions column for:-

• Income

• Expensesiii. Enter appropriate formulae to calculate the actual transactions and

the planned budget

iv. Calculate the difference between the actual transactions and the

planned budget.

v. Draw two bar graphs to;

• Compare budgeted income and actual income

• Compare budgeted expenses and actual expenses

Question five

The statistics below shows rainfall received in a certain district of Uganda

for six months (in mm) as follows:




57/188

June -186, July-181, August-191, September-158, October-181,

November-133, December-91

Required to:

(i) Table the data in a worksheet. Include a title for the table called

“Rainfall statistics”.

(ii) Create a column graph of the entries above showing the amount

(mm) of rainfall per month.

(iii) Provide a suitable title for the graph in (ii) above label the X-

and Y- axes. Place the chart as an object in sheet 1, below thetable.

(iv) Create a pie chart showing the amount of rainfall received in

percentage. Place the pie chart as an object in sheet 1, just

below the graph.

(v) Write your name and index number below the pie chart bar

(vi) Save your worksheet on a CD-Rewritable asGraph 1.

Question six

The table below shows part of sales schedule for a distributor of the diary

products.

Load suitable spreadsheet package and generate a similar schedule.

Ensure that you maintain the cell address. A B C D E F

1 Product Unit cost

2 Jesa (skimmed) 2100

3 Jesa (Big) 1900

4 Jesa(Small) 950




58/188


59/188

(b)Determine the final , average marks and the position

(c)At the end of the empty row after Peace insert a formulae/ function in

the “ Final mark column” to determine the best student.

(d)Insert:

A header “STUDENT PERFORMANCE” and footre as your names and

class and center them

The date

And a thick border outside the table with grids inside

(e)Copy and paste your worksheet to another worksheet, rename the

worksheets as original and copied respect

practical questions fro both ordinary and advanced level by nkoyoyo edward

Documents