Ict Computer Studies Book Practical Guide
Ict Computer Studies Book Practical Guide
Ict Computer Studies Book Practical Guide
STUDIES.
(A Complete Practical Guide to 0‟Level, A „Level & Institution Computer
studies and ICT Scholars)
BY
REVISED EDITION
MARCH - 2019
All rights reserved, no parts of this publication may be reproduced, stored in any
of the author.
Furthermore, the author reserves the right to revise this publication and even to
make changes to this content at any time without obligation whatsoever to notify
Crips Computertech
Director
Cadre K. Nakiir
+256776222235/0702555411.
nakiir@yahoo.com.
All Thanks be to the almighty, the most Gracious the most merciful ALLAH for
Teaching Staff of The Science Foundation College for their credible support and
The continued efforts of my fellows in the field for their continued involvement,
practice and teaching ICT in particular Mr. Mwesigwa Joseph – St Micheal High
School – Ssonde, Mr. Dyogo Andrew HOD ICT Mpoma Royal, Mr. Isiko Kenneth
HOD ICT Namilyango S.S.S Mr. Musa HODCT Bombo S.S.S, Mr. Ngobi HOD ICT
This book covers basics of ICT like Windows and Accessories, Ms Word Processor,
Ms Excel (Spread Sheets), Ms Power Point (Presentation), Ms Access(Data Bases),
Ms Publisher and web Design moreover each of them having over 25 resourceful
questions for reference and simplicity.
In trying to write this book, I have made it so simple (Simple — Complex) bearing in
mind that most learners/students have insufficient or no background knowledge
about the use of computers.
This book does not only predispose on the student‘s use in school but to anyone
outside there that may be willing to learn how to launch and use IT basicprograms.
It is however important to note that the author has carefully studied the habitual
National Examination computer studies/Sub ICT syllabi and has carefully
complied content and resourceful papers from resourceful heads, so interesting,
and moreover comprehensible to cater for this field of teaching ICT at different
levels. It is therefore important for the students and teachers to snatch themselves
a copy so as to ease the teaching — learning process.
This manuscript is also an inspiration from the 0‘ level and recently rationalized
secondary schools A‘ level Curriculum for ICT and Sub math that affect tertiary and
university entry prerequisite.
It has also been an inspiration that has been as a result of constructive criticism
from our fellows in the field and my own students that have driven me to come up
with such organized manuscript as a need to strengthen computer skills in schools
and at individual level.
Compiled content herein is to guide the teacher and learner during practical based
sessions and partly theory but majorly aims at equipping learners with computer
skills.
I dedicate this Guide book to all my students of The Science Foundation College
and St. Michael High School Ssonde who have used part of this book‘s content to
their benefit.
Qaasim Abdallah and family whose hobby is to read and get informed on how to
ACKNOWLEDGEMENT 3
PREFACE 4
DEDICATION 5
POWER POINT
In a typical office where documents are typeset, formatting and editing of such
documents becomes a nightmare where manual modes of document production,
filling and transmission are used.
In order to minimize and eliminate such hustles, several electronic devices and
services by computerized systems and electronic typewriters have been developed
for more efficiency and effectiveness in document production. There has always
been a need to come up with better writing tools to improve on efficiency and
legibility of the written work.
ELECTRONIC WORDPROCESSORS
Word has got a number of versions and these include the following
1) Title bar.
A title bar indicates the task currently running. On its right are the minimize,
restore and close button.
2) Menu bar.
The menu bar provides the user with a group of commands. Each command has a
drop down list, when click used to create and manipulate a document.
Figure 1
Italics Increase & Color (font,
Decrease Font line, fill)
Alignment Line spacing
size
5) Status bar
The status bar is the communication channel between the user and the application
program. It displays the current page, section line and activities such as file saving
progress.
This is the work area where you create your document. It resembles an ordinary piece
of paper.
Figure 2
When typing, once the cursor reaches the end of the current line, it automatically
jumps to the next line. If a word does not fit in the current line, it automatically wraps
at the beginning of the next line. This is referred to as word wrap.
2) Saving a document
• On the office button/, File menu click the Save As command.
• Select the storage location from the Save in list box.
Type the name of the file in the File name box then click OK/save.
3) Editing a document
Making changes or modifying an existing document is called editing. Some editing
operations include:
4) Deleting text, files and folders.
To delete a character, a word or a block of text:
• Highlight the text to be deleted.
• Press the delete key or the backspace key.
Note:
• Delete key erases a character to the right of the cursor while the backspace
deletes characters to the left.
• Use the type over mode to write characters to the right of the cursor or insert
mode to insert a character(s)
5) Find and replace
Find and replace is used to locate a word or a phrase and replaces it with another.
To find and replace a word or phrase:
Figure 3
Spelling and grammar checker automatically locates wrongly spelt and misspelled
words and grammatical mistakes.
7) Thesaurus.
The thesaurus allows the user to automatically find words or phrases with similar
meaning (synonyms) or opposite meaning (antonyms) to the one selected.
• Highlight text.
• On Tools menu, point to Language then click Thesaurus.
• Select a synonym or an antonym.
Autocorrect and Auto Text are used to automatically correct a commonly misspelled
word and insert a predefined text when creating a document.
• On the Insert tab menu, point to Auto text, and then click Auto text command.
• Click the Auto text or Autocorrect tab and type the autocorrect or auto text.
Undo reverses the most recently executed command while redo reverts back to the
cancelled action.
A superscript appears just above the rest of the characters as in cm2 while a subscript
appears just below other characters as in H20.
• Highlight character(s):
• On the Formatting tool bar, you can directly select it i.e. X2 or X2, or click Font
A paragraph is a special block of text dealing with a single theme and starting on a
new line or indent. Some of the formatting features you can apply onto a paragraph
include: alignment, setting tabs and indents, drop cap, bullets and numbering, line
spacing, inserting columns and page breaks.
13) Alignment.
Alignment is the arrangement of text relative to the left margin, center of page or the
right margin. The five major alignment options available are the left, center, right,
justified and force justified.
To align text:
Indenting is moving a sentence or a block of text away from the margin using the tab
key.
A drop cap is a large character in a paragraph that occupies more than one line down.
• To Start a Mall Merge: Select mailings —>Mailings, start mail merge —> you can
select from the dialog box an option i.e. ―start a step by step mail merge‖ or you
can use a mail merge wizard.
• To Select a Data Source: In the Mail Merge task pane, select the appropriate
option under Create recipient list and click next. Perform the necessary tasks and
click next when you‘re finished.
• To Insert a Merge Field: In the Mail Merge task pane, click and drag the
appropriate merge field to the desired location in the publication. Use the options
listed under more items as necessary. Click Next.
• To Complete the Merge: Select the desired option under Create merged
publications and performs the necessary tasks.
Figure 4
Superscript Text highlighter
Italics &
Subscript
Press Ctrl + B
Click the ―B‖ icon on the Home tab at the top of Word
Click the —I‖ icon on the Home tab at the top of Word
• If you want to change the File Name of the edited document from the one you
started with but maintain the original document.
• Click: Office button+ Save As+ choose format +File Name+ Location
• Press Ctrl +S
OR
• Click the save icon on the top left corner of the word window.
1. Print Layout View—this is the view Word users generally stay in during most
of the editing session.
The Print Layout view displays your document exactly as it will appear on the
printed page when you print the document.
By editing in the Print Layout view, you can more accurately see how those
changes will affect the final printed document.
2. Outline View—the Outline view button enables you to manage outlines you
create in Word.
3. Draft View—the Draft view hides all margins, pictures, headers, and footers
from your document so that you can see and edit strictly the text inside.
Press the Delete key (which is labeled Del on some keyboards) or Backspace Key to
delete characters where the insertion point appears.
Every time you press Delete, Word removes one character to the right of the text
cursor (including a space, number, or even a blank line if that‘s where the insertion
point is positioned).
When you press Back space key, Word removes one character to the left of the text
cursor.
Shift + Enter-Moves the text cursor to the next line but does not start a new
paragraph or insert a Paragraph mark.
Ctrl+ left -arrow Moves the text cursor to the beginning of the word.
Ctrl+Shift+left - arrow Moves the text cursor to the left and selects text as it moves by
highlighting the text.
Ctrl+Right- arrow Moves the text cursor to the end of the word.
To print.
Quick Print (sends the document directly to the default printer without making
changes)
Click to select either All or Pages to designate that you want to print the Entire
document or only a portion of it. If you click Pages, type the page Number or
arrangement of page numbers (such as 2-5 or 1-10, 15-25) that you want to print.
After selection,
How to Copy
Press Ctrl + C to copy the selection to your document. The original text remains
unchanged in the document. The selected content is copied and held into the
clipboard.
OR
Right click on the highlighted text & choose copy from the menu
How to Cut
Press Ctrl + X. This moves the selected text from its original location to the clipboard.
This option leaves no copy behind.
OR
Right click selected text & choose Cut option
How to paste
Choose location
Press Ctrl + V
When we add a new story, we want it to begin on a new page. To do this, you can add
breaks.
There are two types of breaks, page breaks and section breaks.
Section breaks allow you to format things like headers and footers differently. For
example, we don‘t want headers on pages with a title, but we do want them on other
pages. Section breaks are ideal for this. If you didn‘t have them, each page would have
the same header.
• Scroll to the end of your first story, and ‗left click on a new line
• Click on the Page Layout tab at the top of Word. Locate the Page Set up panel
and the Breaks item:
• Click on Breaks to see the following menu
• Select Section Breaks > Next Page.
• This adds a new page to your document, and a new section.
When we add a new story, we want it to begin on a new page. To do this, you can add
breaks.
There are two types of breaks, page breaks and section breaks.
Section breaks allow you to format things like headers and footers differently for
example, we don‘t want headers on pages with a title, but we do want them on other
Scroll to the end of the first story and left click on the new line.
Click on the page layout tab at the top of the word. Locate the page set up panel and
the break item
QUESTION 1.
(a) Using Microsoft word, type the passage below as it is and answers the questions
that follow.
The Director General of the United Nations Educational, scientific and cultural
Organization (UNESCO), KIOCHIRO Matsuura, has commended Uganda‘s efforts in
emphasizing science Education. Matsuura, who is here for a two-day visit, said on his
arrival at Entebbe Airport yesterday that the UN agency was ―enjoying a strong
bilateral relationship with Uganda.
―We appreciate Uganda‘s efforts in embracing science and cultural education as part
of national development. This being my first official visit here, I hope strengthen the
ties between Uganda and UNESCO‖, Matsuura said.
He emphasized that Uganda‘s cultural and scientific education statistics which stand
as shown in the table below were encouraging by world standards. These statistics
were carried out in the year 2000, 2001, 2002, 2004 for both cultural and science
education.
Cultural education:
Males (%) 70, 50, 28, 40, and 80
Females (%) 60,30,96,48 and 78
Science education:
Males (%) 30,78,90,20 and 60
Females (%) 56,89,76,59 and 90
Males Females
Year % Year %
Cultural education
Year % Year %
Science Education
(iii) Set the title ―UNESCO‖ hails Uganda to font size 14 and bolded.
(iv) Set the margins to(1.5) and (1.3 right) then bottom and top (1.2)
(vii) Set the whole document to justified and font color, red
QUESTION 2.
computer.
Computers in business.
Different types of businesses commonly use computers to assist with day-to-day operating activities as:
Sales Order Entry: procedures for handling customer orders, including receipt of the order and
verification of availability of ordered stock.
Inventory Management and Control: procedures of tracking, counting, and reordering stock
items.
Personnel Management: procedures for maintaining employee information (such as hire date,
salary, performance rating, and date of last review) for both development and reporting
purposes.
Payroll: procedures for producing paychecks and reports on employee compensation.
Accounting: procedures for maintaining the company’s financial records.
Security: procedures for controlling who has access to what data and information at what times
and where, and who may enter data to a computer-based information system.
Investment and General Financial Management: procedures a company institutes, follows, and
reviews to guarantee profit and growth.
Computers are also being used in business to collect and analyze data, to produce concise information for
management in a clear format suitable for making decisions, and to help managers avoid being overloaded
with unnecessary information.
To keep up to date with detailed information about how computers are being used in the various
sections of the business and banking world, consult well-known business publications such as Business
Week, Fortune, and The Wall Street Journal, as well as computer publications such as PC World and
Macworld.
Source: Hutchinson, Sarah E. and Sawyer, Stacey C. (1992). Computers The User Perspective, 3rd edition, pg.
31, ISBN– 0-256-10435-2
(i) Change the heading to upper case, bold and underline it.
(ii) Change the font of the whole document to Tahoma, point size 11 except the
heading which should be point size 15.
QUESTION 3.
(i) Using the suitable word processing software, type this document as it is.
HUMAN BEINGS
Most infants are guided through life by a parent or guardian and taught how to
talk, walk, eat and generally behave. The socialization process begins 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
constitutes 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 presence. These beings are
often referred to as feral people 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.
(Adapted from: McKenzie and Bryden (2004:50), Introducing Word 2000 for
Windows)
Further Required
QUESTION 4.
(a) (i) Launch a suitable word processing application, typeset the following
document as it appears, save as ―TEEP 2016‖
Please note you can save your informofion of any point in the process and
return to complete your saved applicofion before the closing date to complete
your application.
In order to speed up the application process, prepare these documents before
you start your application.
Required documents are:
(ii) Copy and paste the document to page two which you will use to perform
the rest OF the instructions.
(iii) Using the copied work on page 2, Centre align the heading, Font size 20.5,
and font style comic sans ms
(iv) Apply appropriate bullets on all the required documents for the
application.
(v) Add a hyperlink ―will Run For The Whole Year‖ to the word 2016
PROGRAMME
(vi) Using a word feature, replace the word of with OF every where it appears
in the document. It should be bold, italics and underlined.
(vii) Insert a relevant clip art behind the text on page two
(viii) Insert an end note ―Lets kick out youth unemployment‖ on TEEP found in
the second paragraph.
(ix) Insert a relevant clip art behind the text on page two
(x) This clip should be 2cm and 3cm width and height.
QUESTION 5
(a) (i) Type the following information as it is: (use font size 14)
The time table below will be out by the beginning of next academic year. It
should be copied and filled with relevant subjects.
10:00
9:00-
BREAK
11:30
10:30-
12:30
11:30-
LUNCH
2:00-3:00
3:00-4:00
Mon
Tues
Wed FREE
Thur
Fri
Sat
(ii) Color ―senior four Time table 2010‖ ―BREAK‖, ―LUNCH‖, and ―FREE‖ green
(a) Open an appropriate word processing program and prepare the following extracted
document from https://en.wikipedia.org/wiki/2018_FIFA_World_Cup as it appears:
2018 FIFA World Cup
The 2018 FIFA World Cup will be the 21st FIFA World Cup, a quadrennial
international football tournament contested by the men's national teams of the
member associations of FIFA.
It is scheduled to take place in Russia from 14 June to 15 July 2018, after the country
was awarded the hosting rights on 2 December 2010. This will be the first World Cup
ever held in Eastern Europe, and the first held in Europe since 2006,
all but one of the stadium venues are in European Russia, west of the Ural Mountains
to keep travel time manageable.
The final tournament will involve 32 national teams, which include 31 teams
determined through qualifying competitions and the automatically qualified host team.
A total of 64 matches will be played in 12 venues located in 11 cities. The final will
take place on 15 July in Moscow at the Luzhniki Stadium.
The winners will qualify for the 2021 FIFA Confederations Cup.
Host selection
The bidding procedure to host the 2018 and 2022 FIFA World Cups began in January
2009, and national associations had until 2 February 2009 to register their interest.
Initially, nine countries placed bids for the 2018 FIFA World Cup, but Mexico later
withdrew from proceedings, and Indonesia's bid was rejected by FIFA in February
2010 after the Indonesian government failed to submit a letter to support the bid.
During the bidding process, the three remaining non-UEFA nations (Australia, Japan,
and the United States) gradually withdrew from the 2018 bids, and the UEFA nations
were thus ruled out of the 2022 bid. As such, there were eventually four bids for
(ii) Centre align, and underline the heading of the pasted document.
(iii) Apply a picture of football as water mark to the document.
(iv) Design the rest of the document to have 1.5 spacing and justified.
(v) Include Wikipedia, the free encyclopedia as footnotes on the word Luzhniki.
(vi) Provide your personal number and name on the footer.
(vii) Save your document with your name and personal number.
QUESTION 7
―Internet‖, ―world wide web‖, and ―web page‖ are no longer the buzzwords
now. They are now a reality. The internet is the world‘s largest computer
network and is referred to as the network of networks. One of the subsets of
the internet is the World Wide Web.
QUESTION 8
Computer Performance
In order to compare how fast computers can process data, we have to
measure their performance.
There are a number of measurements of performance.
Clock speed, MIPS, FLOPS & Benchmark tests are all used. Some are a better
measure than others.
The table below shows impact of each element on system performance.
Tactic Effect on Performance
1 Increase clock speed Increase
2 Increase data bus width Increase
3 Increase Cache memory Increase
4 Increase Address Bus None
(b) (i) Format the title as follows. All caps, Center, Bold, and enclose it in a text
boarder.
(ii) Insert a new row between row 4 and 5 and include the item below and
numbering
C. (i) Highlight with a light blue color the word increase wherever it appears in the
document
(ii) Include a header and footer your name and index number respectively
(iii) Include a Hyperlink at the bottom of the page in such a way that allows you to
move at the top when clicked
QUESTION 9.
You are provided with the Science foundation college club time table.
Using a word processor, you are required to produce the below time table exactly
as it appears
MONDAY 07:00-
9:00
MORNING
WEDNESDAY
THURSDAY 8:20-1:00AM
FRIDAY 1:00-12:30AM
SATURDAY
QUESTION 10
Do not wish to be anything else, but what you are and try to be that perfect. No
problem can stand the assault of sustained thinking. The worst bankruptcy in the
world is the person who has lost Enthusiasm.
A man‘s success is not how much money he has made, but what kind of family he
has brought up. Luck is what happens when preparation meets opportunities. The
heart of learning is the will to try.
(ii) Copy the text you have typed and paste it below the first copy.
(iv) Insert an auto shape object, fill it with a light colour and order it behind text.
(vi) Draw a thick 6pt line to separate the two copies. Colour the line red.
(vii) Insert bullets on the second copy.
(vii) Insert your name, index number and ―©‖ symbol as footer.
QUESTION 11
Use Microsoft word processor to write ten letters to ten students of Hodge road
Elementary School for the field trip as below. Note these students have different;
Home addresses, address 1, City, State, Postal Code, and first Name.
Please prepare <<FIRSTNAME>> a pack lunch for the trip. The restaurant facilities
at the Edison home are somehow expensive and we have been unable to negotiate
an acceptable reduced charge for school children.
Please feel free to call me at 0776-222235 should you have need to discuss this
matter further. Thank you for your help and support in this endeavor and
throughout the year.
QUESTION 12.
a) Use the word processor of your choice, to produce the document below as it
appears.
The term ICT stands for information and communication technology and is defined
as Diverse set of technology tools and resources used to communicate, and to
create, disseminate, store and manage information. ICT has become a very
important part in education delivery and management processes. ICT largely
facilitates the acquisition and absorption of knowledge, and hence can provide
extraordinary opportunities to developing Countries for enhancing the educational
system particularly for the underprivileged constituency, and thereby for raising
the level of quality of life of their people.
QUESTION 13.
Insert the table below
Keith 45 86 85
Beth 56 67 57
Ham 42 78 70
Tim 63 95 67
Val 75 42 90
Kit 50 63 76
QUESTION 14
a) Type the document shown below exactly as it appears using Word Processor
of your choice. Save the document as trees.
Introduction:
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
Figure 5
Leaf node
Primarily, trees are useful for organizing data in a manner that makes it efficient to
retrieve it. To illustrate this, is a picture of collection of data organized in linked list
structure. A binary tree is made up of nodes that can have 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 none-
leaf nodes.
QUESTION 15
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.
Required
b. Bold, centre, underline and apply 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 of the documents and right align it.
f. Make a spell check of the whole document.
g. Insert your name and stream as footer, font size‘ 18.
h. Make three copies of your work and create two columns in the passage and add
a footnote as ―our school name‖ on the right hand 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 16
On 18th, July 2005, less than two months after launch plans were announced, Flis
Excellency, President Yoweri Museveni of Uganda officially launched the
Bugulumbya e-School, attended by approximately 5,000 country officials and
members of the community.
Table 2
Name Gender
Jose Chameleon Male
Silvia Kyansunti Female
Bobi Wine Male
vii) Insert a merged row at the top of the table and type
QUESTION 17
Uganda‘s stock exchange is quite nascent with 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 the East African Development
Bank (EADB) building in Kampala.
Uganda‘s clays Ltd is the company whose shares were the first to be listed onthe,
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.
QUESTION 18.
You have been asked to send acknowledgement letters to people who have so far
made contributions towards the program. The letter contents are the same for all
the persons except the addresses, names, and nature of contributions.
Below is the letter to be sent and a table of people who have made contribution.
NAKIIRS.S.S
P.O.BOX 2333
MBARARA:
14thAug, 2009
[ADDRESS]
Dear [name]
This project is its inaugural year but it has been a resounding success. The
learners and staff agree that it should become an annual event. The principal
would like to thank you and hopes for more support in future.
……………………………………………..
PRINCIPAL
YUDA TADEO
Table 3
NAME ADDRESS NATURE OF CONTRIBUTION
1 Alfonso Miguel P.O Box 245 Kamuli $300
2 Lorene Mark P.O Box 245 Kampala 200,000
3 Alfredo Manuel P.O Box 731 Kasese 30kg of maize
4 Tim Howard P.O Box 245 Kamuli 10 bags of rice
QUESTION 19
Type the text below using a word processing p1gram: choosing word processing
software.
Word processing is using the computer to enter, store, manipulate, and print text
in letters, reports, and books and so on. Once you have used word processing, you
will probably wonder (like million others before you) how in the world you ever
survived without it.
As more word processing packages come on the market, choosing the right software
can become very confusing. Nevertheless, there is probably a word processing
packages that will serve your needs .As you begin looking, ask yourself these
questions:
i. What type of document am I
ii. Now processing?
iii. What types of features do I
Needs?
Want?
Document types can range from simple letters and memos to proposals, reports,
legal documents, books newsletters, scientific papers, form letters, and so on. The
point is matching the features you need with the features in the software packages.
For example, if you, write articles that require references, you will need the
footnoting features; if you develop a newsletter, having the multicolumn layout
feature would superscripts (X2+Y2) and subscripts (A21); and if you send
―personalized‖ form letters the mail-merge feature is a necessity.
QUESTION 20
HUMAN RIGHTS.
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 were denied basic human rights and political rights. Their labor was
exploited, their lives segregated.
Under Apartheid, racist beliefs were enshrined in law 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 institutionalized racial discrimination defied the principles of
the United Nations charter and the universal declaration of Human Rights.
In 1976 the United Nations unanimously condemned the elevation of one of the
―homeland‖, Transkei, into an independent state because it remained dependent on
South Africans. 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 any say in the matter.
He was elected president of the African National Congress the following year, and in
1993 received the Noble peace prize on behalf of all South Africans who suffered
and sacrificed so much to bring peace to their country. On10th, May 1994, Nelson
Mandela was elected South Africa‘s first black president, in that country‘s first
truly democratic election.
Required:
i. Insert in the header the word of your choice on the left hand corner.
ii. Bold the heading font size 18 —point, underline, Italy and center it.
iii. Block indent all paragraphs by 1 inch in the left and right margins.
iv. In the fourth paragraphs starting with On may bold the second sentence
v. Make the body font size to 13 and foot style to Anal.
vi. Justify your work.
vii. Create two columns in the passage and a footnote of your school and
name on the right corner.
viii. Save the work as your name and make a printout.
QUESTION 21
ON DECISION TO BUY
The members of the Exchange require that forward payment for shares be made to
reduce defaults. On making the buying order, the client will fill in client
information, an order form and sign a purchase transfer form and then pay for the
number of shares he/she is willing to buy and the broker will issue him/her with a
receipt. On the day the order is executed at the exchange, the broker then will 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.
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
i). Set the page margin to ―1.5‖ to the left and right of the document.
ii). Apply a header to the document which should among others have 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 on each paragraph.
v). Capitalize the title format it accordingly.
vi). Save your work and make a printout.
QUESTION 22.
QUESTION 23
i. The header should include among others, the name of the company, address
(box number, email address, phone number and fax) and date.
QUESTION 24
Construct the table below and answer the questions that follow
Table 5
QUESTION 25
Type the following text exactly as it is and follows the steps as will be indicated in
the text below:
a) It‘s the answer spoken by young and old, rich and poor, democrat and republic,
black, white, Latino, Asian, Native American, gay, straight, disabled Americans who
sent a message to the world that we have never been a collection of Red States and
Blue states: we are always will be, the United States Of America.
c) 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 ―Barrack Obama victory speech‖ in the
centre and the footer to ―change has come to America‖. This should be at the right
hand corner.
QUESTION 26
You have been asked to send invitation letters to people to be invited for your
graduation party. The letter contents are the same for all the persons except the
address, names and pledge.
Below is the letter to be sent and a table of people and their pledge.
Thanks,
Yours truly,
……………………………………………………
ANDRE CORONA
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 name and make a printout.
QUESTION 27
Using Microsoft word, type the statements below and answer questions that follow.
IRR analysis is generally used to evaluate the projects 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 income on a P&L reflects
depreciation, but depreciation is not an out-of-pocket expense. For instance, if
revenue of $10,000 is reduced to $7000 of income because of a $3000 depreciation
deduction, you still have the use of 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 major financing in the future,
or if you are 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 to use a good financial calculator. If
you have one, or don‘t want to take the time to learn to use one, you can also use
the present value tables located in Business Tools.
Required:
Using Microsoft, type the statements bellow exactly as they are and answer the
questions that follow.
Don‘t fall for expensive service contracts. Service contracts that are pitched to you
when you buy a piece of business equipment are often a good deal for the supplier
but not for you. In most cases, the amounts you would spend on a service contract
is wasted money. This is especially true in the case of generic equipment that
normally carries a warranty any way if something is going to go wrong, it will
generally do so in the first 30 to 60 days, when your warranty should cover the
problem.
There may be situations where service contracts are a good deal. For example, if
the equipment was custom-built and expected to need regular maintenance in the
future, if spare parts and knowledgeable labor will be hard to find, or if getting
repairs done immediately is extremely important to your business‘s operation, you
might decide to purchase a service contract on a trial basis.
Compare the NPV of the loan payments. If you have decided to purchase a major
asset and are planning to take out a loan, a good way to compare the options
available is to do a net present value analysis of your cash flows under the various
interest rates and terms your local leaders have available. Your cash flow
projections should consider the loan payment out flows as well as their venue
inflows that would result from your purchase or projects.
Required:
a) Format the title to, font size 18, centered, bolded with upper case.
b) Justify the statements.
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 your work as your name
QUESTION 29
Malaria is the biggest health problem in Uganda and in general, Africa. Its toll in
Africa is the heaviest yearly. Ninety percent of malaria deaths occur in Africa. It is
responsible for over 300 million cases of accurate illness each year leading to
DDT residues on house on house walls can alter this sequence of mosquito
behavior.
The non-contact repellent action of DDT residues can prevent a malaria mosquito
from entering a house. If the mosquito enters, in spite of repellent action, then the
contact irritant action might cause it to exit before biting. If the contact irritant
action falls then contact toxicity might still result in mosquito death, after
prolonged contact with DDT - treated surfaces.
Required
i. Using a suitable word processor, type the above document.
ii. Embold the title using Arial font type with size 14.
iii. Ensure the rest of the document is in Times News Romans, size 12
iv. Include a Header ―DDT‖ and Footer with a left adjusted value for ―today‘s
date‖ and a right adjusted ―page number‖.
v. Ensure both the top and bottom margins are set at 1.1‖ while both left and
right margins are 1.25‖
vi. Replace every occurrence of the word DDT, except in the title, with
―dichlorodiphenyl trichloethane‖
vii. Save document as ―pre-mock word processing‖ on the floppy provided
QUESTION 30
(a) Type the text below using air-appropriate word processing program.
Of all the boys in the town, the most forward in singing nonsensical verse was
always the same one who had begun teasing the storks, a little urchin not more
than six years old. The young storks, indeed, fancied him a hundred years old,
because he was bigger than either their father or mother and what should they
know about the ages of children, or grown-up human beings!
The young storks were highly excited about it, and the older they grew the lessthey
were inclined to endure persecution. Their mother, in order to pacify them, at last
promised that they should be revenged, but not until the last dayof their stay in
that place. Hans Christian Andersen
(c) Change the heading to upper case, font comic sans ms, underline it with any
dotted line and a font size 13.
(f) Drop cap on two lines the letter beginning paragraph one.
(g) Create a footnote on the word ―pacify‖ and it should have the statement ―to calm
somebody who is angry‖.
(h) Your name and personal number should appear as footer and in italics.
QUESTION 31
(a) Using a word processing application of your choice typeset the following text as
it appears and save as „flow chart”
In the late 1970s data-flow diagrams (DFDs) were introduced and popularized for
structured analysis and design. DFDs show the flow of data from external entities
into the system, they showed how data moved from one process to another, as well
as its logical storage.
Below is a sample of a data flow chart showing what happens when you make a
phone call.
Is ringer turned on
N
Y
Voice mail picks up
Phone rings
Y
N
N
Does user answer
Is ring #
phone
4
Y
Figure 6
(b) Present your work on an A4 paper size, margin dimensions as 2cm top, bottom,
left and right respectively.
(f) Include a hyperlink .in such a way that when you click, it takes you to the top of
the document.
(h) Add a caption to appear at the bottom of your flow chart to read ―Phonecall flow
chart‖.
(i) Italicize the word ‗data‘ wherever it appears and change it to color Blue.
QUESTION 32
a) Using available word processing application to type the following as is. Save this
file as remote workers in a folder.
Table 7.
f) Justify your work and insert footnote on the last paragraph: BYCHRISTINA
BESMARAIS Contributor, Inc.com
h) For the title, remove the underlining, bold the title and make it uppercase. .
i) Make a drop cap as ‗dropped‘ in the first paragraph with orange font colour
Therefore, presentation program helps the presenter with a wide range of tools to
clearly structure his ideas and offer the participants with multimodal information
that is so engaging.
There are many areas where power point can be used, these include;
Presentation programs can either supplement or replace the use of older visual aid
technology, such as pamphlets, handouts, chalkboards, flip charts, posters, slides
and overhead transparencies.
A presentation program (power point) typically includes three major functions i.e.
With presentation, texts, audios, graphics, movies and other objects are positioned
on individual pages or slides in a given presentation.
1. Slide Sorter: a window that arranges all slides in one screen in horizontal
rows. This kind of view is useful to make changes to several slides at a time.
Slides can also be re-arranged in any order. Changes may include;
Rearranging,
Deleting, moving,
Copying among others. All these are important in a slide sorter view.
2. Normal View: it can also be called a slide view. A single slide and can add text,
delete or modify the slide contents. It is the main working window in the
presentation. The slide is shown full size on the screen.
3 Notes Page View: Allows one to view the Notes Pane better add and modify
additional notes to a selected slide. Our text placed on the slide.
Multimedia in PowerPoint.
This is both audio/sound, video and pictures but in motion/movement state.
9. Video/movies clips: Video clips are added to enhance your presentation. This
can show authentication, movement or simulated movement, which makes the
presentation more interesting. Movement is either by click of the mouse or
automatic.
10. Hyperlinks.
11. Sound.
Sound as with video or movie clips, is added to enhance your presentation. If for
example your presentation is about weather, as sound clip of thunder can be
added. Clicking on the sound clip will activate the sound.
QUESTION 1
The four ―Categories of Computer Hardware‖ are input, storage, processing,
and output.
Required
Create a Presentation as indicated below:
(i) Slide One – Include the Title, your name, class and email address
(if applicable).
(ii) Slide Two Introduction notes to hardware and types of computer
hardware.
(iii) Slide Three – Outline Input Hardware.
(iv) Slide four – Outline Storage Hardware and Processing Hardware
(v) Slide Five – Outline. Output Hardware.
(vi) Insert six numbers in your presentation.
(vii) Save the Presentation as Computer Hardware.
(viii) Print your Slides.
QUESTION 2
The three ―Categories of Computer Software‖ are Operating System,
Application Software and Utility Software.
Required
Create a Presentation as indicated below:
(i) Slide One – Include the Title, your name, class and email address (if
applicable).
(ii) Slide Two – Define the Operating System and give at least two
examples.
(iii) Slide Three – Define Application Software and give two examples.
Slide Four – Define Utility Software. Give two examples.
(iv) Slide Five – Your conclusion.
(v) Insert slide numbers in your presentation.
(vi) Save the Presentation as Computer Software.
(vii) Print your Slides.
Note The slides should:
a. Run automatically.
b. Use minimal graphic effect.
c. Have your name and class as footer
QUESTION 2
You have been appointed a Public Relations Officer in the Ministry OF Information
and Technology. Prepare a manually running presentation to be used to address
the workshop OF ICT Teachers Introducing them to new changes in examining
Computer studies in all Secondary Schools across the Country.
Slide one: Introduction:
Title and name OF the presenter
Slide two: Aims OF teaching Computer studies
Should include Aims OF teaching computer studies to students
in secondary schools.
QUESTION 3
As an experienced student of computer studies, you have been appointed by
your teacher to go and talk to the new S.Is about the subject called computer
Club on their first careers day in the orientation week. The topic is “ICT
Club”.
(a) Prepare a five slide presentation to deliver your content to the senior
ones considering the following;
(i) Slide one is a title slide and the Topic and presenter‘s details.
(ii) Slide two contains a description of ICT Club at your school.
(iii) Slide three should have key benefits of being a member of the ICT club
and what is expected from new members.
(iv) Slide four should have the challenges the club faces and the way forward
(v) Design the fifth Slide with concluding remarks.
(b) Let your slides have a fly-in transition affect from top left corner.
(c) The slides should be able to loop continuously until escape key is
pressed.
(d) Apply appropriate background color of your choices.
(e) Insert an action button to link all slides to the next slide.
(f) Insert the current date and your name as your footer
(g) Save your presentation with your ―index number‖
(h) Print all the five slides on handout.
QUESTION 5
(i) Video.
(ii) Hyperlink.
(iii) Sound.
(a) Create a presentation in which each concept (i) (ii) and (iii) is on its own Slide.
Enhance with a graphic of your choice.
(b) The first slide should contain links through action buttons to each other Slide.
Note: Each slide must contain a link to the first slide, through an action button.
(c) Include your name and index number on each slide and save your work. (d)
Print your slides.
QUESTION 6
Create a suitable 6 - slide show presentation for the advert of your favorite artist
who is going to stage a, show at national theatre with the following items:
(b) The date and time the show will feature Location of the theatre
QUESTION 7
Road accidents are very rampant in Uganda. Many people have lost their lives in
road accidents. You are required, using presentation software to educate Ugandans
about road accidents. Create four slides indicated in parts (i)-(iv).
(i) Slide I - should include the title, your name and your school name
(ii) Slide II - should include the actual causes of road accidents in Uganda.
(iii) Slide III - Should include the contribution of traffic police in the prevention of
road accidents.
QUESTION 8
Pollution is becoming rampant and a problem in Uganda and the whole World at
large. You are required, using presentation software to educate Ugandans about
pollution. Create four slides as indicated in parts (i)-(iv). Every slide should:
(iv) Slide IV - Should include the effects, and problems of pollution to the
environment.
QUESTION 9
Agriculture is one of the leading income generating activities in Uganda but its
growth has been hindered by many factors including soil erosion. You are required,
using presentation software to educate Ugandans about soil erosion. Create four
slides as indicated in parts (i) - (iv). Every slide should:
(ii) Slide II - Should include the definition for soil erosion and various types of soil
erosion
(iii) Slide in - should include the causes and effects of soil erosion
Create a suitable 6 - slide show presentation for the wild life & Environment club of
the parish with the following items:
(d) A two column text slide with the names of the workers in the club.
(f) A tabular slide with fifteen imaginary volunteers with their imaginary annual
subscription payments.
(g) A column chart for analyzing the highest payments per individual member.
QUESTION 11
Create a suitable 6 - slide show presentation for the networking essentials with the
following items:
QUESTION 12
QUESTION 13
As a forest officer in your home district, you have been‘ assigned a project to
sensitize people in your locality about the importance of education.
QUESTION 14
d) Creativity S
QUESTION 15
You are required to prepare a project of 4 slides on CAUSES OF HIV AMONG THE
YOUTH IN UGANDA.
(i) The first slide should be your topic, presenters name and school.
(ii) Format all your title slides (headings) to ―Algerian‖ Font style.
(iii) Insert a relevant and different back ground on each of the slide.
(iv) Insert a ―dissolver transition to run automatically every after 5 seconds.
(v) Your project should have at least an image.
(vi) Add an animation ―exit blinds ―on all your slides.
(vii) Save your work in your folder on the desktop.
(viii) Print out
QUESTION 17
You are required to prepare a project of 4 slides on WHY SECONDARY STUDENT
HAVE FAILED TO PASS EXAMS.
(i) The first slide should be your topic, presenters name and school.
(ii) Format all your title slides (headings) to ―Algerian‖ Font style.
(iii) Insert a relevant and different back ground on each of the slide.
(iv) Insert a ―dissolve‖ transition to run automatically every after 5 seconds.
(v) Your project should have at least an image.
(vi) Add an animation ―exit blinds ―on all your slides.
(vii) Save your work in your folder on the desktop.
(viii)Print out
QUESTION 18
You are required to prepare a project of4 slides on Causes of road accidents in
Uganda today.
(i) The first slide should be your topic, presenters name and school.
(ii) Format all your title slides (headings) to. ―Algerian‖ Font style.
(iii) Insert a relevant and different back ground on each of the slides.
(iv) Insert a ―dissolve‖ transition to run automatically every after 5 seconds. Your
project should have at least an image.
(v) Add an animation ―exit blinds ―on all your slides.
(vi) Save your work in your folder on the desktop.
(vii) Printout
(i) The first slide should be your topic, presenters name and school.
(ii) ii, Format all your title slides (headings) to ―Algerian‖ Font style.
(iii) Insert a relevant and different back ground on each of the slide.
(iv) -. Insert a ―dissolve‖ transition to run automatically every after 5 seconds.
(v) Your project should have at least an image.
(vi) Add an animation ―exit blinds ―on all your slides.
(vii) Save your work in your folder on the desktop.
(viii)Print out.
QUESTION 20
a) Create a five - slide presentation about the introduction of subsidiary
Information and Communication Technology (ICT) for A-level in Uganda. In your
presentation do the following:
(i) Slide I- Include the title ―Report on the Introduction of Subsidiary ICT‖.
(ii) Slide II - State reasons why Subsidiary ICT was introduced in Uganda.
(iii) Slide III - Give the expected outcomes of studying Subsidiary ICT.
(iv) Slide IV — List problems that are faced in schools offering SubsidiaryICT.
(v) Slide V — Make a conclusion thanking the Ministry of Education, Science,
Technology and Sports for introducing Subsidiary ICT to the curriculum of
Uganda.
g) The title should have the font size of 43.9, and it should appear different / from
the other slides.
h) All the slides should bear a footer of your name and personal number except the
title slide.
1) Apply appropriate colors for each slide.
j) Save your work as your name and personal number.
k) Print your work.
Assume that you are working as a Relation Officer in one of the leading Hotels in
Uganda. Make a five-slide presentation with relevant data about the major areas
you would focus on while campaigning to market the products in your Hotel to
consumers or customers. Suggest an appropriate title to this advertisement.
(c) Save the as your name and print all slides on a page
QUESTION 22
The School Nurse is planning a student‘s workshop shortly this month. He has
requested you to prepare a presentation entitled Typhoid with the following sub-
heading.
Instructions:
a) Insert one slide (Slide one) to contain a title: Typhoid. On this slide, write your
name as a presenter. Lay out your text to create better slide usage. You are free to
vary-the font sizes.
b) Insert a slide (Slide two) to contain a title: How Typhoid is spread. On this slide,
list five possible causes of Typhoid. This list should be ordered
Make a three page presentation for your school dealing with computer training.
(i) Find a template (background) which is appropriate for this presentation and
use it.
(ii) Use your school name as the title on all three pages in this presentation.
(iii) Type the following text in the first page. The schools postal addresses and its
e-mail address.
(iv) Use different font sizes to make it look neat.
(v) Type the following in page two.
Computer classroom training
CD self study
IT training consultancy.
(vi) Use bullets, according to the number of lines in the text and lay out the
pages to make it easy to read.
(vii) Create a slide show and save it with an appropriate name.
QUESTION 24
As health educationist, you are required to make five slides for the community.
This is to be presented in form of a slide show on health.
b. Use minimal effects in the slide. This should make the presentation entertaining.
The school has been assigned to make a presentation about its nature of studies
being offered. As a result offering computer studies, you are required to: -
QUESTION 26
As an education officer, you have been assigned to sensitive projecting your locality
on ―the importance of Education‖
c) Slide III should represent the benefits and shortcomings of education. Include a
conclusion.
A travel agent has been invited to an international tour and travel exhibition. The
travel agent wants to market Uganda‘s tourism sector using a power point
presentation of 10 slides, with the following.
i. Title Slide with the company name of presenter a variety of slides detailing the
tourism attractions of Uganda.
Prepare a presentation for the agent as described below.
ii. One title slide.
iii. Two slides about eco tourism (forests, botanical gardens, etc.)
iv. Three slides on, physical features mountains, rivers and waterfalls, lakes)
v. Three slides of animals tourism (national parks, game reserves and wildlife
centers)
(Ms. EXCELL).
Throughout the ages, people have always wanted to calculate. Tools such as the
abacus were invented by the earl Chinese to help keep track of large numbers.
About thirty years ago, students only had pen, paper, slide rules and mathematical
tables to help them in their mathematical examinations. There were no such things
like calculators and certainly, no personal computer.
Or
Or
One can also say that it is a piece of software used to work out calculations.
A spread sheet can do a lot more than simply adding up a column of numbers
spread sheets can handle financial calculations for a large business, calculate
• Database - Enable the •user to perform functions such as sort, filter, subtotaling
and consolidation on worksheet data. A spreadsheet file can also be saved with a
.dbf extension to make it accessible from other applications using a db engine
• Easy management of large amount of data using data management features such
as sorting, filtering, data validation and subtotaling.
Apart from the title bar, Menu bar, Standard toolbar and Status bar: found in Word
processing, Spreadsheets have the following additional features.
1. Formula bar. Is an area where a cell entry or a formula is displayed before being
entered into the selected cell
2. Worksheets. A worksheet is the area made up of rows and columns where data
is entered. In Excel, a spreadsheet file is referred to as a workbook which consists
of one or more related worksheets.
4. Searching and sorting: this gives the u, ability to search the worksheet for any
phrase, number or even other texts. It even makes the user scroll between the
search results.
5. Import and export: spreadsheets can be transferred onto and off the mobile
phone using a window explorer on the d. Spreadsheets can also be e-mailed as
attachments, from within the spreadsheet application.
A workbook window.
Figure 7
When entering data item into the work sheet, the entry is displayed in the formula
bar before you move to another cell. To place the content to the selected cell, press
Enter key or an arrow key or click into another cell. Below are the three main cell
entries:
• Labels -alphanumeric characters or text that describes the content of a row or
column e.g. names.
To save a workbook:
• On the office button (File menu), click Save As. Alternatively click the Save
button on the standard toolbar.
• Select the storage location.
• Type the name of the workbook then click the Save button
3. Protecting a workbook
To protect a worksheet or workbook from unauthorized access or modification:
• On the Tools menu, point to Protection, and then select Sheet or Workbook.
• Click check boxes for protection options.
4. Editing a Worksheet
• Double click the cell to place the insertion pointer in the cell and then type
or modify the entry.
• Position the pointer where the new row or column will appear.
• On the Insert menu, click Rows or Columns.
Figure 8
Figure 9
• Highlight a row or column on each side of the hidden rows or columns while
pressing the shift key.
• On Format menu, point to Row or Column, and then click Unhide.
/ Division = A2/B2
* Multiplication =A2*B2
+ Addition =A2+B2
- Subtraction =B2-A2
b. Relational operators
A relational operator returns either true or false depending on the magnitude of the
value being evaluated. Summary or relational operators
= Equal to =A2=B2
2. Cell Referencing
There are three types of cell referencing used when creating formulae and
manipulating cell(s), content:
a. Relative referencing. When.‘ you copy a formula that contains cell references,
say A3, the references adjust to their new location. E.g. If C1 containing a formula
=A1+B1 is copied to C2, the reference changes to A2+B2.
b. Absolute referencing. The reference is4ikde to a specific address and does not
change even if the formula is copied to another cell. In Excel an absolute cell
reference is made by placing a dollar sign before the referencing. $A$2, i.e. if the
result in C1 is 170 if absolute reference is used, 170 will be copied to C2.
Figure 10
80 - 100 A
60 - 79 B
40 - 59 C
Below 40 Fail,
• AND () - Returns true if all its arguments are true or false if any argument is
false. E.g., =AND (3+2=5, 2+2=4) returns true.
• OR () — Returns true if any of its arguments is true or false if both
arguments are false. E.g., =OR (3+2=7, 2+2=4) returns true.
• NOT ( ) — Negates the unary operand. E.g., =NOT (.3+2=5) returns false.
NB. It‘s important to note that this function is only applicable in Subsidiary ICT (A
‗level) but not at O‘level. This is according to UNEB standards. But it is vital if
students at all levels understood how the function is applied.
Lookup value - The value to search in the first column of the table array. Lookup
value can be a value or a reference. If lookup_value is smaller than the smallest
value-in the first column of table_array, VLOOKUP returns the #N/A error value.
Range_lookup- A logical value that specifies whether you want VLOOKUP to find
an exact match or an approximate match:
Remarks
When searching text values in the first column of table_array, ensure that
the data in the first column of table_array does not have leading spaces,
trailing spaces, inconsistent use of straight (‗ or ‗) and curly (‗ or ―) quotation
marks, or nonprinting characters. In these cases, VLOOKUP may give an
incorrect or unexpected value. For more information
When searching number or date values, ensure that the data in the first
If range_lookup is FALSE and lookup_value is text, then you can use the
NOW () - Returns the current date and time formatted as date and time. It
date. Ms Excel uses year 1900 serial number1. E.g., =DATE (107, 1, 4)
Data form allows the user to easily display and enter records into a worksheet
database. To display a form:
Data form allows the user to easily display and enter records into a worksheet
database. To display a form:
Figure 11
4 Filtering
Click OK.
6. Input validation
To ensure that a user does not enter invalid data, set the validation criteria.
An error message is displayed when data that violates this rule is entered.
To set data validation:
• Highlight the range of cells to validate.
• On the Data menu, click Validation.
• Click the Settings tab and select a validation criterion
• To display an input message when the cell is selected, click the Input
Message tab, type the message to be displayed and check ―Show input
message when cell is selected‖.
• Set the Error alert then click OK.
7. Creating charts and printing
A chart is a component of a spreadsheet program used to present data from a
worksheet in a way that provides instant visual impact. E.g. Column and bar
charts, pie chart, line graph, scatter diagram and area graph. To create a chart:
Table 10
########### The column is not wide enough to Increase the column width or
accommodate the value or a negative shrink the contents to fit the
date or time is used e.g. = column. Avoid using negative
(2/4/2007) time or date value.
#DIV/0! Division by zero or using a blank or Change the cell reference one
cell e.g. = 45/0 that contains a value nonzero
in the cell.
#N/A The formula or function uses a name Make use of a valid argument
that Excel does not recognize or the correct type of value
#NAME? The formula or function uses a name Correct the spelling of the
that Excel does not recognize name.
#NUL! The formula references an invalid To refer to two areas that don‘t
intersection of cells intersect, use a comma (,) e.g.
= (SUM(A1:A10,C1:C10))
#NUM! Due to use of invalid numeric values Use numeric arguments in a
formula or function e.g. S
Enter 1000 not Ush 1000
#VALUE The formula or function uses Make sure that referenced cells
incorrect argument or operator by the formula contain values.
#REF! Due to invalid cell referencing as a Change the reference in the
result of deleting referenced cells. formulae, or restore the deleted
cells.
QUESTION 1
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.
(ii) A lunch allowance for all employees is 22% of their basic pay.
(iii) Housing allowances are 62% of lunch allowances.
(iv) All employees are paid transport allowances of 59,000
(v) Compute the employees‘ gross pay.
(vi) PAYE is 2.5% of basic salary.
(vii) National social security fund is calculated at 18% of gross pay.
(viii) Compute the employees‘ net pay.
(ix) Plot a line graph of net pay against basic salary in worksheet 2.
(x) Save your work in your name and registration number on the desktop.
QUESTION 2
Study the following multiplication table.
Required:
(i) Enter it into an Excel worksheet.
(ii) Enter a formula to B3 that will generate for you the product of A3
and B2.
(iii) Copy the formula entered to B3 to other blank cells.
(iv) Apply borders to the table.
(v) Save the file as Multiplication Table.
(vi) Rename Sheet1 to Multiplication Work.
(vii) Put your name as footer.
Required
QUESTION 4
The following students sat for their term two examinations in Mathematics (mat),
Computer studies (comp) and commerce (com) and obtained the following marks:
John got 40 in mat, 20 in comp and 50 in com. Mary got 90 in mat, 60 in comp, 30
in com. Tania got 75 in mat, 65 in comp, and 90 in com. Samuel got 55 in mat, 40
in comp and 80 in com. Paul got 50 in mat, 20 in comp and 35 in com. Albert got
50 in mat, 60 in comp, and 50 in com.
(i) Enter the data given in spreadsheet. All names should be in column A.
(ii) Use a formula to compute the total for each student and put them in column
E.
(iii) Sort the data entered in column E in descending order.
Iv How many students got a D1 in Math given that a D1 was awarded at 75%
(v) Put the titles for column A, B, C, D and E in orientation 450.
(vi) Give your work a professional look.
(vii) Plot a bar/column graph for the students‘ marks in the three (3) subjects.
Your graph should have appropriate heading and axis
(viii) Include a header as your name and save your work as ―Senior four Exam‖
(ix) Print your work.
Table 10
(i) Use available spreadsheet application to enter the entire records in the table.
(ii) Apply functions or formula to automatically compute:
o Total Cost of these products.
o The VAT if its 18% of the total cost.
o The Net pay per each product supplied.
(iii) In column G, use function to position these products beginning with the
most expensive one as position 1 and end with the less expensive one as
position 11.
(iv) Make your work look professional.
(v) Draw a column graph to compare the net pay for these products. Label the
axes and title clearly.
(vi) Indicate your name as footer.
(vii) Save your work with file name ―Abili Sec School‖.
QUESTION 6.
Below is an extract of Daily paper sales of one of Red Pepper. Use it to answer
the questions that follow.
AGENT MON TUE WED THUR FRI SAT SUN TOTA COMME
L NT
New Taxi Park 25000 54000 54000 45000 54010 65000
Mubende 65040 68040 9600 65000 65000 54600
supermarket
QUESTION 7.
A school produced an end of term mark list for senior five using any spreadsheet
program; enter the data into the table below.
Table 11
a) Provide a heading for your worksheet as Cadet Secondary school, results for
2012 and centre it with font size 24.5.
b) Using appropriate functions, determine for each student the
i. Total mark.
ii. Average mark.
iii. Position.
c) Apply boarders on the data you have entered in the worksheet.
d) Insert your name and personal number as footer.
i. The heading senior five term one mark, Cadet Secondary school.
ii. Labels with the cart.
QUESTION 8.
The table below shows examination results of senior six students of Mugo
Secondary School. Study it and answer the questions that follow.
Table 12
A B C D E F G H I
1 MUGO Secondary School Six Science Class, 2013
2 SUBJECTS
AVERAGE
CHEMIST
BIOLOGY
PHYSICS
GRADE
NAME
NAME
MATH
FIRST
LAST
ICT
3
RY
4 OKUMU DAVID 80 90 80 90 70
5 NAIGA LILIAN 72 85 63 47 90
6 APUNU JOSEPH 78 86 82 52
7 ODYEK TONNY 78 87 86 82 52
8 WAISWA MAX 30 25 58 58 67
9 LUBEGA KARIM 86 56 47 78 82
10 KATAIKE JENN1FER 59 85 64 55 85
11 KATEREGGA JULIUS 98 45 25 93 69
12
13 HIGHEST VALUE
14 LOWEST VALUE
15 MEDIAN VALUE
QUESTION 9.
Pic-Hill Primary School scored the following marks in their Primary Leaving
Examinations.
Table 15
QUESTION 10.
Enter the following data into a Microsoft excel sheet.
Table 16
Name Department Basic Salary
Sophia Accounting 350000
Beth Finance 200000
Paula Accounting 450000
Aisha Human Resource 365000
Grace Finance 150000
Sarah Management 460000
Kate Transportation 550000
Namubiru Accounting 650000
Lwanga Accounting 190000
Hearte Finance 420000
Trina Human Resource 800000
Lorena Management 850000
Morel Accounting 280000
i. Add a column for employees‘ Age and fill it with figures of your choice.
ii. Sort the department column alphabetically.
iii. Extract subtotals for each department‘s basic salary
i. If employees pay NSSF (National Social Security Fund), PAYE (Pay As You
Earn) and tax which is 2%, 5% and 3% of the basic salary respectively,
introduce a column for NSSF, PAYE and Tax and calculate the net pay after
those deductions.
iv. Select the names column and Net pay to for a clustered column with 3D
visual effect chart and save it as ―Analysis‖.
v. Save your work under your names in the folder you created.
vi. Make a printout of your work.
QUESTION 11.
The school marks are divided into beginning of term (20%) and end of term (80%).
Thus the total mark should be generated with a function that can sum the figures
while considering the percentage weights.
Table 17
Table 18
Name Math (%) Science (%) SST (%) English (%) Lou (%)
Monica 78 66 67 45 •... 89
Jane 67 .77 70 65 77
John 55 45 100 84 98
Peter 45 56 82 56
Nelson 100 88 77 89 100
Patria 82 100 70 87
a) Enter the records in a spreadsheet application and arrange the names of these
pupils in alphabetical order.
b) Use function to auto compute the:
i. Total mark of each pupil
ii. Position of each pupil in the class based on total mark scored by each child.
c) Return the total number of pupils who:
i. Missed Lou examinations
ii. Scored above 60% in mathematics
d) Use HLOOKUP Function to return the name of the pupil with 100% in
Mathematics
e) Plot a column graph to compare the performance of pupils in Mathematics and
English only. Label all axes, title and legend.
f) Save the work as Alokolum and print the file.
QUESTION 13.
KB Computer Enterprises agreed to maintain an electronic spreadsheet to keep
track of business books for the various branches country wise. The following is a
worksheet used to extract records from business partner‘s vendors.
(a) Enter the following in any available spreadsheet software of your choice and
save as KB enterprises.
Table 19
(c) With use of a VLOOKUP, use the following criteria to include remarks.
QUESTION 14
Create a Worksheet and enter the data below.
Table 20
Auto stores Year 1 Year 2 Year 3 Year 4 ATS
1998 1999 2000 2001
Sales Revenue 32600 48000 62000 96800
Cost of Goods Sold
Gross Margin
Variable Expenses
Fixed Expenses 000 . 6000 6000 6000
Net Profit
QUESTION 15
Enter the data bellow into a suitable application program and save it as ―Raw-
marks‖
Table 21.
A B D E F
Student No. Names Telephone number Test A % Test B %
01 Harriet 0712445230 53 43
02 Beth 0702512012 48 22
03 Harith O772652310 62 35
04 Bruno 0773652140 85 68
05 Hyde 0782416212 56 56
06 Hearten 0752316242 72 70
07 Pilly 0774512634 62 62
i. Copy the work and paste it in worksheet 2 of the same workbook. Name the
worksheet 2 as ―percentage-marks‖.
ii. Given that Test A and Test 13 are marked out of 90 and 70 respectively,
enter appropriate formulae to calculate the percentage marks using
―percentage-marks‖ worksheet.
iii. Use functions to obtain the difference between the highest and the lowest
percentage marks in Test ―A‖ in cell G21.
iv. Calculate the average mark for Test B in cell G21.
v. Save your work and make a printout.
QUESTION 16.
Name SSN Working Rate Advance Overtime Overtime Gross Tax Net
No. hours of rate wage pay
pay
Paul S00I 150 3000 -
Kate S002 200 4200 1500
Kim S003 300 6000 4000
Beth S004 250 3500 -
Harry S005 240 8000 5000
Paul S006 200 5000 2000
Rita S007 150 4000 1500
Sherry S008 250 7500 3000
Hearte S009 280 5800 2100
QUESTION 17.
The school did several tests marked out of 20. Use the information given to answer
the questions that follow.
Table 23
c) Using the ‗If‘ statement, assign grades to students using their averages in a way
that, average above 70, assign a ―Dl‖, 65-70, a ―D2‖, 55-60, a ―C3‖, 50-55, a ―C4‖,
45-49, a ―C5‖, the rest, an ―F‖.
d) Differentiate those who have passed from those who have failed in a way that if a
person has average above 50, then that person has passed, otherwise, failed.
Table 24
Required:
i. Add a column for employees‘ age and fill it with the figures of your choice.
ii. Sort the department column alphabetically.
iii. Extract subtotals for each department‘s basic salary.
iv. Copy your work and paste it on sheet 2 to continue with the rest of the
questions.
v. If employees pay NSSF (National Social Security Fund), PAYE (Pay As You
Earn) and tax which is 2%, 3% and 2% of basic salary respectively,
introduce a column for NSSF, PAYE and Tax and calculate the net pay after
those deductions.
vi. Select the names column and Net pay to form a clustered column with 3- D
visual effect chart and save it as ―Analysis‖.
vii. Save your work under your names in the folder you created.
Table 25
A B C D E F
1 CITY SALES EXPENDITURE INCOME/LOSS COMMISSION
2 Delhi 15111 13400
3 Chandigarh 26100 24050
4 Patna 17270 15670
5 5aipur 19800 21500
6 Agra 29400 25600
7 Total
8 PERCENT 10
QUESTION 20.
A farmer‘s income and expenditure is shown in the spreadsheet below;
Table 26
A B C D E
1 RATES
2 Increase 3%
3 . Decrease 2.5%
4
5
2000
6 INCOME Maize sales
‗
7 Wheat sales 25000
8 Mi1i sales 12500 ‗
9
10 Total Income 37500
11 EXPENDITURE
12 Fertilizer 16000
13 Labor 10000
14 Transport 8000
15
Total
16 34000
Expenditure
17
18 PROFIT 23500
19 .
QUESTION 21
The following students sat for their term one examination in Math (mat),
Computer studies (comp), commerce (corn) and History (hist) and obtained the
following marks.
Abbey got 50 in mat, 30 in comp, 20 in corn and 70 in hist. Obbo got 60 inmat, 56
in comp, 40 in com and 55 in hist. Kato got 8O in mat, 75 in comp, 39 in com and
49 in hist. Val got 49 in mat, 50 in comp, 86 in com and 74 in hist. Ham got 60 in
mat, 45 in comp, 48 in com and 90 in hist. Kim got 62 in mat,53 in comp, 50 in
com and 80 in hist. Tim got 29 in mat, 60 in comp, 49 incom and 78 in hist.
QUESTION 22.
The school marks are divided into Beginning of term (30%) and End of term (70%).
Thus the total mark should be generated with a function that can sum the figures
while considering the percentage weights.
Table 27
Name Reg. No B.O.T E.O.T T/MARK Grade
Keith U/0O1 86 85
Beth U/002 - 67 57
Ham U/003 78 70
Kit U/004 95 67
Tim U/005 42 90
Val U/006 63 76
Pilly U/007 59 60
QUESTION 23.
Create a spread sheet of the data above, starting with the item title cell A3 and save
as “stationery 1”
A B C D E F
Opening Closing Quantities Selling Value of
1 Item
stock(O) stock(C) sold(Q) price (S) sales(V)
2 Note books 200 120 1500
3 Printing paper 400 160 8000
4 Clip files 170 80 200
5 Box files 100 0 2500
6 Diaries 95 30 1800
600 5000
7 Counter books 150
Total value
of sales
Table 29
Required
i. Add a column for employees Age and fill it with figures of your choice
ii. Sort the department column alphabetically
iii. Extract subtotals for each department‘s basic salary
iv. If employees pay NSSF (National Social Security Fund) and Payee (Pay as
You Earn) which is 3% and 4% of basic salary respectively introduce a
column for NSSF and Payee and calculate the net pay after those
deductions.
v. Select the names column and Net pay to form a clustered column with 3-D
Visual effect chart.
vi. Save your work as your name.
QUESTION 25
The following members of twegatte saving and cooperative society toOK loans from
gold trust bank. They were charged a handling fee of 5% and an interest
of 15%of theloan.
Name Loan (Ush) Period
Kato sulaiman 500,000 2 years
Magembe Ivan 750,000 3 years
Nababi Justine 350,000 2 years
Kapere Douglas 1,250,000 6 months
Sagala Martin 900,000 1.5 years
Tomusange David 2,150,000 5 years
QUESTION 26.
Table 30
Required:
i. Add a column for employees‘ Age and fill it with figures of your choice.
ii. Sort the department column alphabetically.
iii. Extract subtotals for each department‘s basic salary
iv. If employees pay NSSF (National Social Security Fund), PAYE (Pay As You
Earn) and tax which is 2°/9, 5%, and 3% of the basic salary respectively,
v. Introduce a column for NSSF, PAYE and Tax and calculate the net pay after
those deductions.
vi. Select the names column and Net pay to for a clustered column with 3D
visual effect chart and save it as ―Analysis‖.
vii. Save your work under your names in the folder you created.
viii. Make a printout of your work.
The school marks are divided into beginning of term (20%) and end of term (80%).
Thus the total mark should be generated with a function that can sum the figures
while considering the percentage weights.
Table 31
QUESTION 28.
Enter the data bellow into a suitable application program and save it as “Raw-
marks”
Table 32
A B C D E F 0
Student Names Telephone Test % Test B %
number number A L
01 Harriet 0712445230 53 43
02 Beth 0702512012 48 22
03 Harith 0772652310 62 35
04 Bruno 0773652140 85 68
05 Hyde 0782416212 56 56
06 Hearte 0752316242 72 70
07 Pilly 0774512634 62 62
i. Copy the work and paste it in worksheet 2 of the same workbook. Name the
worksheet 2 as “percentage-marks”.
ii. Given that Test A and Test B are marked out of 90 and 70 respectively, enter
appropriate formulae to calculate the percentage marks using “percentage-
marks” worksheet.
QUESTION 29.
Table 33
STUDENT NAME MATHS ENGLISH BIOLOGY
HadijahKadondi 67 74 71
LutaleAcram 58 65 56.
AhumuzaShamsa 81 69 70
KusiimaNasur 45 50 49
Komugisha Sandra 78 76 68
MaskaHairat 34 47 65
LutakomeBasam 56 56 56.
BalukuAiman 85 88 69
NajjingoSohpia 60 .55 46
QUESTION 30.
Hill Primary School scored the following marks in their Primary Leaving
Examinations.
QUESTION 31.
The following spreadsheet shows the profit or loss on sales at an ice- cream stall
during a four week period.
Table 35
A B C D E F
1 ICE-CREAM STALL
2 Cost price (Ug)
3 Ice 500
cream
4 800
5
6 Ice-cream Orange Income Expenses Profit/Loss
Sales juice sales (Ug) (Ug) (Ug)
(Ug) (Ug) .
7 Week 1 3000 400 980,000 900,000 Profit
8 Week 2 2500 100 770,000 900,000 Loss
9 Week 3 4500 100 1,370,000 900,000 Profit
10 Week 4 3000 200 940,000 900,000 Profit
Table 38
Employee Age Service Salary Allowance Gross Taxable PAYE NSSF Net
pay amount pay
Nalwanga 54 120,000 70,000
Kityo 34 135,000 85,000
Abigaga 65 110,000 100,000
Akello 35 150,000 130,000
Lowery 60 200,000 70,000
Bamoshena 57 98,000 15,000
Omoding 49 78,000 10,000
Nakimuli 29 140,000 80,000
OKiru 27 95,000 65,000
Olowo 63 130,000 20,000
Namutebi 27 115,000 75,800
a. enter the above data into your worksheet and answer the questions below
b. Assuming each employee started working at the age of 23years, compute the
years spent in service (to fill the service column)
c. Taxable amount is computed after deducting NSSF and 13,300 (threshold)
from the Gross Pay, PAYE is 30% of the Taxable amount; NSSF is 5% of the
Gross pay. Compute the Gross pay, Taxable amount, PAYE, NSSF and Net
pay.
d. Insert the following records after Omoding and compute the relevant entries
e. Delete the record for lowery from the worksheet
QUESTION 33.
Table 39
A B C D E F
Opening
Closing Quantities Selling price Value of
1 Item stock
stock (C) sold (Q) (S) sales (V)
(0)
2 Note books 200 120 1500
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
QUESTION 34.
Table 40
QUESTION 35.
Table 41
A B DC E F
COMMODITY MARKET MARKET MARKET MARKET
1
1 2 3 4
2 Rice 1,000 1,100 1,950 1,100
3 Sugar 1,700 1,650 1,710 1,800
4
Meat 2,500 2,20O 2,700 2,800
Table 42
Other information:
Tasks:
(At the beginning of next year the canteen operators have asked the school
management that he is going to increase selling price by 20%. Insert a new column
to work out the new prices for all canteen items next year.)
vi. Format all figures with UGX currency symbol with one decimal place.
(DATA BASES).
b. A Record:
Every entry of data is referred to as a record. A record is a group of related items
that we can treat as a single group. A record is a row in a table that contains
information about a given person, product, or event. (An individual entry in a table)
c. A Field:
A field is a column of similar information or group of vertically arranged data that
contains similar, information of the same data type. Or it can be a column in the
table that contains specific piece of information within a record.
d. Table structure:
This refers to the number of fields, field name (s), field length and data types in a
database table.
QUESTION 1.
G4S is a security organization that owns runs a saving scheme for its members. You
have been asked to use a use a database management system (DBMS) to help the
scheme members maintain records of the association.
Table 44.
First Last Membership DOB Age Membership Fully
Name Name NO Fee (shs) paid
Kintu Mark 4321 12/11/1990 200,000 Y
Akullo Warren 5855 10/1/2015 50,000 N
Akongo Joshua 514 08/08/2003 12,000 N
Kifampa Bob 123 12/1/1999 10,000 N
Kaleb Peter 411 l0/03/2014 70,000 N
Ondigo Sophie 868 12/12/2010 100,000 Y
Wakiaga Precious 654 14/1/2013 140,000 Y
Aketch Lucy 744 11/03/1992 60,0000 N
(a) Create a database file called G4S that has the following fields of data for each
member.
(b) Assign an appropriate primary key and data types for your database
(c) Use a form to enter the records in your database save your form as data
(d) Use a query to compute
i. Age of members of the association, save query as age
ii. Create another query that would be used to display those whose first name
starts with letter A and aged 18 and above name it Age
iii. 18‖
iv. For members born between 1990 and 2013, save it as born e) Generate a report
for age query, save report as Age report
f) Print your report
BOWWOWERS
Borrower Number Name Of Address of borrower Borrowers‟ Phone
Borrower Number
113 Tobias Anendra 658 Uhuru High way, 0772344567
P.o box 2809
16582 Carlos Moyes 12, Avenue De Lupin, 0712417398
P.o box 65432
Required
(i) You are required to design a suitable database to manage the above
information, name the Database KAKIRA PS DATABASE.
(ii) Create a table using Design View, and name it STUDENTS
RESULTS.
(iii) Create a form called Results Entry Form and enter the above
records.
(iv) Create a query displaying all the fields in the above table to filter out
only pupils who are females. Save it as Females. Print the query and
its output.
(v) Create another query displaying all the fields of pupils with ages 15
and above. Name it Aged 15 Plus. Print the query and its output.
(vi) Create a query displaying all the fields in the above table to filter out
only pupils whose Math marks are between 35 and 81. Name it Marks
between 35 and 81.
(vii) Create a query to filter out the pupils who scored at least 70 marks in
SST and English. Name it AT LEAST 70 MARKS IN SST AND
ENGLISH. Print the query and its output.
(viii) Create a report showing FamilyName, FirstName, Sex and Age. Name
it Simple Report. Print the report.
Required
a) Design a suitable database to manage the above information, name the
Database BCM DATABASE.
b) Create a table using Design View, and name it STUDENTS TABLE.
c) Create a form called Students Entry Form and enter the above records.
d) Create a query displaying all the fields in the above table to filter out only
students who are females. Save it as Females. Print the query and its output.
(a) Create another query displaying all the fields of students with donations 5000
and above. Name it 5000 Plus. Print the query and its output.
(b) Create a query displaying all the fields in the above table to filter out only
students whose donations are between 2200 and 9900. Name it Donations
between 2200 and 9900.
(c) Create a query to filter out the students who donated at least 5000 in Interact
and Writers clubs. Name it Interact and Writers. Print the query and its output.
(d) Create a report using Donations between 2200 and 9900 query. Name it
Report Between. Print the report.
(a) Using any database software of your choice create this database for Kiti Primary
School
Save it as KITI database. (01 mark)
QUESTION 6.
(a) Create a table using design view with the following fields: NAME, DATE OF
BIRTH, SEX, RELIGION and FEES BALANCE. Set the NAME field as the primary key
and save the table as ―Candidates Table‖
(06marks)
(b) Creates a form to enter the records below and save the form as ―Candidates
form‖
(c) Create a query displaying all the students whose names begin with letters ‗B‘
and ‗T‘. Save it as ―BT” query.
(d) Create another form in ―Design View‖ with all the available records in the given
table and name it ―Design view form‖
(e) Use a query to calculate the fees balance of the students supposing the school
fees payable is ‟90,000‟. Save the query as fees Balance.
(f) Generate a report for the above table with FEES BALANCE in descending order.
Use columnar lay out and Portrait as the form orientation. Name this report
―Columnar report 1‖
(g) Generate a query to filter out students who are NOT Protestants and Catholics
(h) Save your database as your name and index number.
QUESTION 7.
The table exhibited shows the records of hours worked in the month of June 2017
by each employee in one of the wheat industry in Kampala.
EmployeeNo Name Gender Date of Hours Hourly Total
Birth worked Rate June
Wedge
1 Pius Mukasa M 2/12/1980 40 25000
2 Rita Nanono F 14/04/1979 36 30000
3 Susan Akot F 30/5/1985 24 38000
4 Margaret Nin F 5/5/1978 30 26000
5 Paul Toto M 7/6/1977 35 22000
6 Peter Zziwa M 6/1/1979 33 20000
7 Lilian Achan F 4/6/1978 25 25000
8 Joyce Mum F 25/3/1986 50 15000
9 Tom Wawa M 23/2/1984 46 22000
10 James M 24/4/1981 45 24000
Semakula
QUESTION 8.
The table below shows departmental records of a certain secondary school.
ITEM Table
Table 43
ItemNo ItemName Quantity Arrival Date Price Per Item Department Total
Price
I PC 40 15/2/2015 Shs. 1,500,000 1CT
2 Chair 100 10/1/2015 Shs. 100,000 Academic
3 Microscope 05 5/1/2015 Shs. 2,000,000 Chemistry
5 Bible 100 4/2/2015 Shs. 50,000 C.R.E
4 Voltmeter 60 20/1/2015 Shs.80,000 Physics
5 Bible 100 4/2/20 15 Shs.50,000 C.R.E
6 Atlas 200 30/3/2015 Shs.50,000 Geography
7 Rabbit 150 20/3/2015 Shs.26,000 Biology
8 Pure 2 300 4/4/2015 Shs.75,000 Mathematics
Math book
9 Printers 10 10/3/2012 Shs.1,500,000 ICT
10 Smart Board 11 13/5/2012 Shs.10,000,000 Academic
QUESTION 9
Create a table with the information below and name it ―patient tab1e‖ (Use
appropriate data type).
Table 45
Reg. no. First name Gender Age Ailment Prescription Review
QUESTION 11.
Create a table with the information below and name it ―customer table‖. (Use
appropriate data type)
Table 47
Id No. Name Gender Title Sales Cost of goods sold
revenue
U12201 Ham Male W.seller 12,000 9,500
U15421 Beth Male Retailer 8,500 6,100
U62452 Kit Female W.seller 10,200 8,200
U45781 Harry Male Retailer 6,000 4,200
U14202 Alpha Male Agent 15,000 7,200
U34752 Chris Male W.seller 62,000 400,000
U21123 Maggie Female W.seller 74,000 51,000
U17650 Morene Male Retailer 5,600 2900
U12431 Francesca Female Retailer 8,300 1500
U18214 Keith Male Agent 20,300 10,000
QUESTION 12.
Create a table with the information below and name it ―workers‘ table‖. (Use
appropriate data type)
ID.NO SUR SEX TITLE DEPARTMENT SALARY D.O B
NAME
ZL001 JESSICA F CHIEF MANAGEMENT 730,000 18/06/37
WORKER
ZL040 JULIANA F WORKER KITCHEN 630,000 05/08/78
ZL071 ZAK M WORKER KITCHEN 700,000 05/06/72
ZL160 ANN F SECRETARY RESEARCH 385,000 19/06/37
ZL178 JAMES M WORKER KITCHEN 600,000 14/05/64
ZL180 JONAH M DIRECTOR MANAGEMENT 120,000 18/08/67
ZL185 EMILY F CASHIER MANAGEMENT 700,000 14/05/69
ZL220 JACOB M DRIVER MANAGEMENT 375,000 17/06/64
ZL230 JULIET F SECRETARY ICT 385,000 19/08/71
ZL340 AMIN M LIBRARIAN RESEARCH 420,000 08/12/75
Database of borrowers:
Table 50
NUMBER NAME ADDRES PHONE NUMBER
1524 Tobias Kalema P.OBOX 123 0752621342
The database manager of Kakira primary school provides you with the following
details. Use it carefully attempt the following instructions.
Table 51
FAMILY FIRST
SEX AGE SCIENCE SST ENGLISH MATHS
NAME NAME
Kamusiime Edwin M 17 50 77 47 88
Moren Nicholas M 17 63 56 13 56
Mugerwa Ronald M 16 55 28 83 35
Akena Kennedy M 18 22 47 55 78
Kakair Musa M 14 36 75 68 98
Ssentongo David M 18 99 96 91 65
Babirye Lonah F 19 55 35 38 65
Narnulondo Mary F 16 66 84 61 67
Kafuko Ivan M 15 47 82 53 35
Kingugwe Joseph M 13 12 82 24 81
Namboso Helen F 17 36 83 35 80
Aketch Harriet F 16 88 96 56 50
Naigamba Pauline F 18 71 72 77 60
Opio William M 16‘ 29 56 88 75
Required:
QUESTION 15.
The table below is a record of employees in a school canteen.
SIRNAME FIRST SEX DATE OF TELEPHONE BOX
NAME BIRTH NUMBERS NUMBERS
Mandela Margaret F 02/16/1967 079-488-888 P.OBOX267 K‘LA
OKello Joel M 12/17/1970 090-500-555 P.O BOX433 M‘KA
Nyaika Ronnie M 07/28/1980 040-400-767 P.O BOX444 K‘LA
Waibale Anthony M 10/03/1979 090-333-212 P.O BOXJJA
Jamila Liza F 02/25/1985 099-233-345 P.OBOX 453 K‘LA
Saidi Juma M 11/12/1977 011-333-466 P.O BOX123 K‘LA
Zaweede Zubeda F 14/12/1977 088-444-666 P.O BOX990 ARUA
Table 53
QUESTION 17.
Use the information in the table below to design a database. Name the table as
tblEmp and store the database file as company.
Table 54
c) Create a report to show the commission paid to all the sales people, if the basic
salary for sales people is 300,000.
d) Create a query to show who will be retiring at the end of the year, if the
retirement age is 55.
QUESTION 18.
Tertiary institutions loan board is a government body created to give loans and
bursaries to needy students at the public universities. It is required that the
information of the students is stored in a database for future repayment of the
loans. The following data is stored.
Name
Students‘ registration number
Sex
Date of entry to the university
Loan given
Interest charged
Repayment period
i. Create a table to store the above data.
ii. Create a form to enter data.
Enter 10 sample records. The form should have validation routines to ensure that
the amount borrowed does not exceed Ush.420, 000 and the minimum age of the
student is not below 16.
iii. Create query called ―loan over 200k‖ that will filter the students who have
been given a loan of more than Ush.200, 000.
iv. Create a report called repayment to show Name, loan amount, interest
charged, repayment amount and monthly installment.
v. Create a report that shows a history of loan given out over a period of 10
years. Include a summary showing the total, minimum, maximum and
average loan amount for that period.
Required:
QUESTION 20.
QUESTION 21.
Create a new database and save it as workshop register.
i. Create a new table for the following fields: Reg No, Names, Sex, Date of
birth, Status, Address.
ii. Set RegNo as the primary key.
iii. Save the table as ―attendance registry‖ and close it.
iv. Modify the table design for the following field properties.
Reg-no text (size 12)
Name Text (size 20)
Date text (format long-date)
v. Create a form and save it as ―data entry form‖ and use the form to enter the
records here below in the table.
Table 56
vi. Create a form and save it as data entry form and use the form to enter the
records here below in the table.
vii. Create query displaying only Reg-no, name and sex to filter female
attendants. Save it as female attendants.
viii. Create a query displaying on Reg-no, name and status to filter out resident
attendants. Save it as residents.
ix. Create a query displaying attendants whose dates of birth are between
01/01/ 1965 and 01/01/1970.
x. Create a report out of the above data (ix).name it attendants born between
1965 and 1970.
xi. Create a report grouping the records by status using the registry table. Give
it a title “COMP99 WORKSHOP REGISTRY”
xii. Save the report as registry list by sex.
QUESTION 22.
Create a new table using the corresponding raw data below
OLD STUDENTS ASSOCIATION MEMBERSHIP
Table 57
ii. Create a form based on all the fields in the table, name it membership entry
form.
iii. Create a form based on all the fields in the table, name it membership entry
form.
iv. Create a query to display only membership ID, first name. Last name and
status. Those with executive members
v. Create another query displaying all fields to display members with
membership fee between 20000 and 80000 call it ―paid up members.‖
vi. Create another report using the query by home town grouping all records by
town; name the report as members by Hometown.
vii. Create another report using the query members by home town grouping all
the records by town; name the report as members by home town.
QUESTION 23.
The table below gives information on some students in a certain secondary school
about the registration numbers, names, classes, age and names of house where
they reside.
a) create a database file team that can be used to store the above data
b) Enter the above records in the database you have created
c) It is required that the total number of goals scored by each player in the
previous matches be included in the database file.
d) The first two players have two goals each, mutual and letoiya have scored
three goals each, Suzuki and Kimatha have not scored any goal, while the
rest have scored 1 goal each. Include these details in the database file and
save as “TEAM 1”
e) Make the field containing names to be primary key.
i. Sort the database record in descending order of players goals scored and
save the data base as ―Team ―
ii. Create a report that displays the names, heights and goals scored for players
whose weight are below 75 kg.
iii. Make a print out.
A school in Kiboga County, Mubende district has a population of 500 students and
various subject departments. Some twenty students, 12 of the girls live in Maria
and Theresa houses. The other 8 are boys who live in Muteesa and Kabalega
houses.
Required to:
(ELECTRONIC PUBLICATION)
QUESTION 1
Using Microsoft office Publisher, design the business card of an individual working
in any Institution of your choice. Include:
h. Save your file as business and the print preview of 6 cards per A4 paper.
QUESTION 2.
Using a Desktop Publishing Program of your choice, design the following cash
Receipt and make four Copies on your publication page. Set the guides to the
following positions: 2cm, 10.7cm, 11cm and 19.7cm (all vertical) and 1.5cm,
11.5cm, 12cm, and 22cm horizontal.
QUESTION 3.
Note:
QUESTION 4
a) Adjust the paper size to a width of 11 inches and a height of 8.5 inches.
b) Insert a clip art to represent the owner‘s photograph.
c) Use your name as the owner of the certificate,
d) Insert your name and personal number in the footer.
e) Save and print your publication.
QUESTION 5.
Using suitable publishing software, design eight identical business cards titled on
A4 page size, 3.5‖ width and 2‘ height.
i. A logo of the company at the left hand side of the card. Provide the logo
ii. A company name of your choice.
iii. Job title e.g. managing director.
iv. Your name e.g. Aisha Kainembabazi.
v. Contact address, phone and e-mail.
QUESTION 7
Table 59
KKTRANSPORTERS LIMITED
P.O.BOX 7000
KAMPALA.
Dealers in electronics and electricity equipment
Figure 15
a) Font size should be 12 for the three line heading and the rest of the work in
font size 10.
b) Font color is black.
c) Font face (style) is Anal Narrow.
d) Insert header your name and footer your index number.
Using a suitable publishing software, design eight identical business cards titled on
A4 page size ―width and 2‖height
i. A logo of the company at the left hand side of the card. Provide the logo
ii. Company name of your choice
iii. Job title e.g. Managing Director
iv. Contact address, phone and e-mail
QUESTION 9
QUESTION 10
Design a letterhead for your company which should among others have a logo,
address, date, well designed in appropriate fonts.
a) In the normal view, list down the products offered by your company.
b) Indent your work ―0.5‖ to the left and ―0.5‖ to the right and apply 1.5 line
spacing.
c) Apply a page borders on your document
QUESTION 11
You have been chosen a graphics designer of your school. Your responsibility i to
develop a logo for the Writers‘ club in your school.
a) Using only “three” - “four” letters to abbreviate the club name, Create a
logo to be used by the writers‘ club of your school.
b) Apply good graphics and graphical colors for the club to your logo.
c) Use appropriate fonts.
d) Use color patterns in any two of the letters.
e) Save your work in your names and index number.
f) Make a hard copy out of your work.
QUESTION 12
QUESTION 13
QUESTION 14
a) As graphics designer of your school, design a flyer for your favorite elections
candidate on the post of Headboyship of your school.
b) Your flyer should include.
i. The Candidates‘ Names
ii. Post and Class.
iii. The school motto.
c) It should among others include the best and appropriate fonts and colors.
d) Save your work.
e) Make two hard copies out of your work.
QUESTION 15
a) Using Microsoft Office Publisher, develop a simple webpage of your school. The
page should among others have all features of a good webpage.
b) Include the following on your page;
Any introductory information about your school; Among the introductory
information include;
i. The School Mot
ii. Subjects offered.
c) A link for each of the departments in your school. (Physics MathDepartment,
Languages Department, Chemistry Biology Department, theHistory, CRE,
Geography, the Commerce, Entrepreneurship and Economics Department. .
d) Include appropriate images on your home page.
e) Table showing the classes the school has an enrolment for each class.
e) Appropriate graphics and colors.
f) Save your work as a webpage.
g) Import it to the available browser offline.
h) Print out the page.
QUESTION 17
Using a desktop publishing application of your choice, help Titus to come out with
a designer ―business card‖ through the following activities.
a) Use an appropriate page design to make eight identical cards per page.
c) Using a ruler guide measure take the following card dimensions-width 3.5 inches
and height 2 inches.
d) Design one card with the following details: Company logo of your choice;
Company name; Name of employee; designation; Location; Contact address; Email
and Telephone contacts.
e) Select all the contents on the card and group them into one object.
Kawomera Restaurant LTD has embarked on re-designing their Menu card offered
to customers.
As a Desktop Publisher expert, you have been appointed to assist the marketing
team in re-designing a menu card for the restaurant as a marketing and persuasive
tool. The fonts, borders and graphics used should be relevant to the publication as
may be available in your software.
QUESTION 19
Using any available publishing software, design an invitation wedding cardwith the
following:
QUESTION 20
Eastern pride high school would like to have a calendar designed for it,
a) Use any publishing software; design a calendar for the school to includethe
following information:
b) The calendar area should be of font monotype corsiva size 36, colour dark blue.
c) Pill the table part with an orange color. Set the color to 56% transparency.
A web page can contain graphics, image, text, links and other multimedia
components. A web page can be made up of a number of separate paged
documents. It is normally a collection of documents that make up a website.
A home page: this is main page or the cover page of the web document that
contains an index or table of content to the rest of the documents.
Usually, a web site after being fully developed/designed, it is hosted on at least one
web server that is accessible via a network such as a the internet network, or any
other available private network.
The most common way to get a web site is to feed in or enter that Uniform
Resource Locator (URL).
• A Uniform Resource Locator is a unique address of the file that is accessible
over the internet.
<BODY>something<| |
rz‘ <B>cool</B>‘</BODY>.
Underlining
Font sizing
To change the font size, you need to first add the font tag
1. Using any available web publishing software, design a web page for a hotel.
Make sure our home page is impressive but not too slow to download.
a) page title
b) less graphics
c) Work (text) text between 150 — 200.
d) not more than two links
e) an ordered list (6 hobbies)
f) good designing
g) Creativity.
as a member of the environment club you are assigned to design a web page‖ on
the effects of pollution on society‖
i. page title
ii. less graphics
iii. not more than 100 words
iv. one link to environ@yahoo.com
v. creativity
vi. date/source/feed back
a. A page title
b. Appropriate graphics
c. A 100-120 word text
d. 1 link(for the ministry‘s email address)
e. Table showing the duties of the ministry
f. Layout
g. Creative designing
h. Save your work as education ministry.
3. You are contracted to design a web page for Mukono industries. As a web
master, you are required to include:
i. A page title
ii. Appropriate graphics
iii. Not more than 120 words on the company and its products
iv. A link for each of the products
v. A layout
vi. The author of the text who can be contracted•
vii. Creativity
viii. Save your web site as Mukono.
4. Using any available web publishing software, design a two page web site for your
former primary school:
i. The first page is the index or home page, it should include:
a. The name of the school and the school logo.(the logo does not have to be the
actual logo of the school)
b. Any introduction information
c. Address of the school (does not have to be the actual address)
d. A facility for visitors to sd an e-mail to the school.
e. Navigation bars
(ii) The second page should contain a bulleted list of the department in the school,
and a table showing at least four teachers indicating the classes and the respective
subjects they teach.
a. An index page with the name of the school and a picture of an important
feature in the school. (The picture does not have to be the actual one but
should be closely related.)
b. One page on the,
i. Different subjects offered
ii. School admission
iii. Sports and co- curricular activities.
iv. Neighboring community.
6. Using any available publishing software design a school home page .make sure
the home page is very impressive but too slow to download.
a. A page title
b. Appropriate graphics
c. A 100-l20 word text
d. 1 link (for the school email address)
e. Table — showing at least four years UCE performance by the school.
f. Layout
g. Creative designing
h. Save your work as my school
a. Create a link on the production department in (a) (ii) above that will lead you to
page explaining what the department does.
b. Include the company‘s vision, mission, and core values‘ statement at the bottom
of the index page.
8. Using any available web publishing software, design your school‘s home page
make sure that your school is well represented in this project.
a. Page title
b. Less graphics
c. Word (text) between 100-1 10.
d. 1 link (for the school‘s e-mail address.)
e. Table -showing four departments of your school.
f. Designing
g. Creativity.
9. You are contracted to design a web page for Mukwano industries. As a web
master, you are required to include:
a. Page title.
b. Appropriate graphics
c. Not more than 120 words on the company and its products.
d. A link for each of the products.
e. A layout.
f. The author of the text who can be contacted.
g. Creativity.
h. Save your work as on a RW CD as Mukwano.
Using any availab1e web publishing software, design a web page for this
community Make sure your home page is impressive, creative arid has appropriate
graphics,and not too download.
11. As a professional web designer, you are contracted to design a web page Mr.
M&J hotel Bwebajja. This should include among others,
12. Using any available publishing software, design a website about your personal
information. ).
Page I: page title, bio-data e.g. name, age, nationality and religion.
Page III: a bulleted list of activities and responsibilities held e.g. had prefect.
Note: