Training Notes (Autorecovered)
Training Notes (Autorecovered)
APPLICATION
COURSE
PREPARED BY:
PIUS KUSEKWA ELIAS.
0
TABLE OF CONTENTS
TOPIC 1............................................................................3
INTRODUCTION TO COMPUTERS.............................3
TOPIC 2..........................................................................21
INTRODUCTION TO MICROSOFT WORD...............21
TOPIC 3:........................................................................45
INTRODUCTION TO MICROSOFT EXCEL...............45
TOPIC 4:........................................................................52
INTRODUCTION TO E COMMERCE.........................52
TOPIC 5:......................................................................357
INTERNET AND EMAILS............................................57
TOPIC 6:........................................................................67
INTRODUCTION TO MICROSOFT PUBLISHER......67
TOPIC 7:........................................................................74
INTRODUCTION TO MICROSOFT POWERPOINT..74
TABLE OF FIGURES
1
Figure 1:DESKTOP COMPUTER....................................................................................................................................................4
Figure 3:SMARTPHONE..................................................................................................................................................................5
Figure 4:TABLET.............................................................................................................................................................................. 5
Figure 6:SOFTWARE........................................................................................................................................................................ 8
Figure 9:MOUSE............................................................................................................................................................................. 11
Figure 12:KEYBOARD....................................................................................................................................................................12
Figure 13:CPU.................................................................................................................................................................................. 13
Figure 14:PRINTER........................................................................................................................................................................ 14
Figure 15:SPEAKER........................................................................................................................................................................ 15
Figure 19:CD.................................................................................................................................................................................... 16
Figure 25:FLYER............................................................................................................................................................................. 72
2
Figure 26:BUSINESS CARD..........................................................................................................................................................73
TOPIC 1
INTRODUCTION TO COMPUTERS
DEFINITION
What is a computer?
A computer is an electronic device which is used to control data or
information.
Or
A computer refers to the digital electronic device that store data, process
data, retrieve data and process information.
Example of data samples that can be processed using a computer
Files
Pictures
Videos
Games
Websites
The computer has got its own way on which it can process data
NB:
There are various ways in which one can define a computer the best
thing is to be aware of its functionalities and what is the major work it
does.
3
TYPES OF COMPUTERS
There are various types of computers depending on the use plus the
specifications.
DESKTOP COMPUTER
Refers to the type of computer which functions directly when connected
to the power
LAPTOP COMPUTER
Refer to the type of computer which consists of battery, so it can operate
even if there is no power.
4
SMARTPHONE
Refer to the type of computer which operates with a battery and are
widely used to perform basic functions.
F IGURE 3 SMARTPHONE
TABLET
Refers to the other type of computer that controls and process
information similarly to what the computer does. It also comprises of a
battery.
F IGURE 4 TABLET
5
DIFFERENCES BETWEEN A DESKTOP COMPUTER AND A LAPTOP
COMPUTER
The main difference between a desktop computer and a laptop computer
is the use of a battery that is a laptop comprises of a battery while a
desktop does have that.
Another difference is with the regards to the portability, a laptop
computer is portable while the desktop is not.
COMPUTER MANUFACTURERS
There are various companies that are used to manufacture computers all
over the world. Some of these companies are like;-
DELL
TOSHIBA
LENOVO
HP(HAWLET PACKARD)
MACBOOK/APPLE
6
6. Screen size- it is vital also to know what screen size do you want
for your computer either a bigger screen or smaller. Examples
there are computers of screen sizes such as 19,21 and many others.
7. Operating system- it is vital also to know what kind of operating
system are you going to use for a given computer because there are
other computers due to their small size cannot be installed with
operating systems like windows 10.
8. Purpose- it is important to know before purchasing a computer that
how are you going to use it, for what purpose. Example one may
purchase a computer just because he want to use for graphics
purposes so he is advised to purchase a computer that has got his
capabilities in graphics.
Example of processor abilities are as follows;-
Intel Pentium, core i2, core i3, core i5 and core i7.
NOTE:
DESKTOP- refers to an area reserved for the files you are working on, it
is a place where multiple files can be open together, it enables you to
switch between files.
DOCUMENT- it is also referred as my computer part in windows 10.
7
l,;
F IGURE 5 HARDWARE PARTS OF A COMPUTER.
COMPUTER SOFTWARE
Refers to the intangible part of your computer
Or
Refers to the set of instructions given to a computer so as to enable it to
perform its functions accordingly.
F IGURE 6 SOFTWARES
8
CATEGORIES OF COMPUTER SOFTWARE
There are two categories of computer software.
1. SYSTEM SOFTWARE
2. APPLICATION SOFTWARE
1. SYSTEM SOFTWARE
This refers to a kind of software that is designed to run a
computer’s hardware and application program.
Example the operating system or OS which is used to manage
other programs in a computer.
The system software is used to manage a computer itself.
2. APPLICATION SOFTWARE
This refers to a kind of software that is capable of dealing with
user inputs and helps the user to complete the task.
It can be called an app and it stays above system software.
Example of these programs are like spreadsheet software,
Microsoft word software and many others.
9
OPERATING SYSTEM
Refers to the software program that enables us to control or operate
things using a computer.
The type of operating system that we will use in our course is windows
10.
There are various types of operating systems like window 7, windows 8,
windows 8.1 and many others.
ANTIVIRUS SOFTWARE
Is a software program developed to detect and remove computer viruses.
Example of antivirus software are like Kaspersky, smadav, avast and
many others.
10
2. Processing devices- they are mostly concerned on what happens to the information you
input
3. Storage devices- it is where the information is stored or saved example main memory
4. Output devices- how you get the information back out of the computer.
INPUT DEVICES
These are devices that allows the user to enter data or commands in the computer.
The computer accepts data or information that are provided by means of an input device.
These are devices which helps the user to communicate with the outside world.
These input devices are as follows;-
Mouse
Keyboard
scanner
1. MOUSE
This is the pointing device.
It helps to control the movement of the cursor on your computer.
F IGURE 8 MOUSE
TYPES OF MOUSE
a) WIRELESS MOUSE
It uses a sensors instead of a wire. It is fitted with a battery so as to store
power.
11
F IGURE 9 WIRELESS MOUSE.
b) WIRED MOUSE
It is a type of mouse that uses a wire.
2. KEYBOARD
Refers to the input device that is used to input text, characters and
numbers in your computer.
F IGURE 11 KEYBOARD
SCANNER
It is a device which is used to capture images and translate them into
files in which a computer can read and display.
F IGURE 12 SCANNER
12
PROCESSING DEVICES
These are devices which transforms data into usable information.
This happens through the use of CPU.
CPU (CENTRAL PROCESSING UNIT)
It is referred to as the brain of a computer
It helps to perform data control and operation within the computer.
F IGURE 13 CPU
OUTPUT DEVICES
These are devices which are used to give out data from the computer
The following are the output devices to the computer
PRINTER
It is used to give out the output of text and graphics from your computer
F IGURE 14 PRINTER
13
MONITOR
SPEAKER
It is used to give out the output of sound.
F IGURE 15 SPEAKER
STORAGE DEVICES
14
These are the devices which are used to store data in the computer.
It is where the information is saved either inside or outside the computer.
The following are storage devices in the computer;-
CATEGORIES OF STORAGE DEVICES
There are two categories of storage devices
Built in/internal storage devices.
Removal/external storage devices.
FLASH DRIVE
It is a device used to store in the computer
It is of various sizes like 4GB, 8GB, 16GB, 32 GB and many others.
CD/DVD
CD
The long form of cd is compact disk.
15
Are small plastic disks that stores and retrieves computer data or music
using light.
The main disadvantage of these is that they are prone to scratches.
It is used to store data.
F IGURE 18 CD
DVD
It stands for digital video disc or digital versatile disc.
They have got higher storage capacities more than CDs
It has a capacity of 4.7GB.
16
it is normally abbreviated as HD or HDD
example of data stored in computer
17
HOW TO TURN OFF THE COMPUTER
STEPS
1. Move your cursor up to the start icon/window icon
2. Click on the window icon (left click by using your mouse)
3. Move your cursor up and select the word “POWER”(left click
using your mouse)
4. Select the option “shutdown” and click it(left click using your
mouse)
5. Wait until it shutdowns itself.
HOW TO TURN ON YOUR DESKTOP COMPUTER
STEPS
1. Press on the power button on the CPU
2. Turn on the monitor
3. Wait until it will turn on itself.
THE USE OF COMPUTER
Computer can be applied in variety of fields such as follows;-
1. HOME
They have variety of uses at home like online bill payment, watching
movies or shows at home, home tutoring, social media access.
2. MEDICAL FIELD
Used in hospitals to maintain database of patient’s history, x rays and
other virtual related services. Use of robotics.
3. ENTERTAINMENT
Helps one to watch movies online, play games online also.
4. INDUSTRY
It performs several tasks in the industries like managing inventory,
designing purposes, video conferencing and many others.
18
5. EDUCATION
Computers are used for educational purposes such as online classes,
online examinations, e-books and online tutoring.
6. GOVERNMENT
Computers are used for data processing, maintaining database of citizens
and supporting paperless environments.
7. BANKING
They are used to store details of customers and processing transactions
8. BUSINESS
They are used for transactions processing.
PRACTICE EXERCISE 1
i. Define the following terms as used in computer technology;
i. Computer
ii. Computer hardware
iii. Computer software
iv. Storage devices
v. Input devices
1. What are the differences between laptop computer and a desktop
computer
2. Describe the factors to consider when buying a computer
3. What are the functions of the following devices?
i. Monitor
ii. CPU
iii. Keyboard
iv. HDD
19
PRACTICE EXERCISE 2
1. Define the following terms
i. Computer
ii. Hardware
iii. Software
2. List down types of computers
3. Briefly explain the use of computer in various areas.
TOPIC 2
INTRODUCTION TO WINDOWS
MICROSOFT WORD
It is the part of Microsoft office which is used to create beautiful
documents like resumes/cv, letters and brochures.
20
FILE MANAGEMENT
Refers to the process of controlling files and folders in your computer.
What is a file?
It is used to store data or information on a computer
What is a folder?
A folder refers to the collection of files. A folder can contain a file or
another folder.
HOW TO CREATE A FOLDER IN YOUR COMPUTER
STEPS
1. Select the place where you want to create a folder
2. Right click using your mouse
3. Move your cursor down up to the word “NEW” and click it(left
click using your mouse)
21
4. Write the name of your folder and click anywhere to save it.
HOW TO RENAME A FOLDER
STEPS
1. Select the folder (left click using your mouse)
2. Right click on the given folder
3. Move your cursor down up to the word “RENAME”
4. Click on the word “RENAME”(left click using your mouse)
5. Write the name of your folder
6. Click elsewhere to save your work
22
3. Move your cursor and select the word “OPEN”(left click using
your mouse and the folder will open).
MOUSE OPERATION POINTS
Right click
Left click
Double click
Drag and drop
23
9. PAGE DOWN- takes you down the page.
10. ARROW KEYS- it helps you to move UP
BETWEEN,BESIDE &DOWN
11. CTRL- it is combined with other keys to enable us to get
shortcuts
12. ALT- used to change the functions of other pressed keys.
13. TAB KEY- move the texts together.
FONT PROPERTIES
1) FONT THEME/THEME FONT
It is used to pick up a new font for your text.
Or in a simple way it helps to give a display on how your texts should
appear
2) FONT COLOR
It is used to change the color of your texts
3) FONT SIZE
It is used to change the size of your texts.
4) FONT HIGHLIGHT COLOR
Make your text pop up by highlighting in a bright color.
5) FONT TEXT EFFECT AND TOPOGRAPHY
It is used to add some flair to your text like blur and shadow.
6) FONT CHANGE CASE
Change the selected text into lower, upper and other common
capitalizations.
7) FONT BOLD
It is used to make your text bold
8) FONT ITALICS
25
It is used to italize your text.
9) FONT UNDERLINE
It is used to underline your texts.
CLIPBOARD
It is used to perform variety of functions like copy, paste.
COPY
It is used to copy your texts
CTRL + C= COPY
HOW TO COPY
STEPS
i. Select your texts/where you want to copy
ii. Move your cursor up to the word “COPY”
PASTE
It takes your text and paste them
CTRL + V=PASTE.
STEPS
Select the “PASTE” (on the clipboard) and make sure you choose one
paste option.
CUT
Remove the selection and put it on the clipboard and so you can paste it
somewhere else.
CTRL + X= CUT
NEW DOCUMENT
It helps to get a new document
e.g CTRL + N= New document.
PARAGRAPH
26
Refers to a collection of words and sentences that contain an end line
character(return, line feed or both) at the end.
27
TABLE
It refers to the arrangement of data in rows and columns.
It is important to know the number of rows and columns before drawing
any table so as it can fit accordingly.
HEADER
Refers to the words that appear on every front part of your page.
HOW TO INSERT A HEADER TO YOUR DOCUMENT
STEPS
1. Select the area where you want to insert the header
2. Move your cursor up to the word “INSERT”
3. Click on the word “insert” (left click using your mouse)
4. Move your cursor up to the word “header” and click it(left click
using your mouse)
5. Choose the header design you want to have and click it(left click
using your mouse).
FOOTER
Refers to the words that appear on every part of your page
HOW TO INSERT A FOOTER TO YOUR PAGES
STEPS
1. Select the area you want to insert your footer
2. Move your cursor up to the word “INSERT”
3. Click on the word “INSERT” (left click using your mouse)
4. Move your cursor up to the word “FOOTER’ and click it(left click
using your mouse)
5. Choose the footer design you want to have and click it(left click
using your mouse)
29
PAGE NUMBER
Refers to the number on the page
HOW TO INSERT A PAGE NUMBER TO YOUR DOCUMENT
STEPS
1. Select the area you want to insert a page number
2. Move your cursor up to the word “INSERT”
3. Click on the word “INSERT”(left click using your mouse)
4. Move your cursor up to the word “PAGE NUMBER”(left click
using your mouse)
5. Choose the page number design you want to have and click it (left
click using your mouse)
SORT
It is used to arrange your text in either ascending or descending order.
HOW TO SORT THE WORDS IN ASCENDING OR
DESCENDING ORDER
STEPS
1. Select the text in which you want to sort
2. Move your cursor up to the word “SORT” on the paragraph line.
3. Choose how you want to “SORT” and after you have done so click
the word “OK” and hence it will sort.
DESIGN
It is used to display different designs on how your document should look
like.
In our course we will look on the following things onto the design part
of Microsoft word
1. Watermark
2. Page colour
30
WATER MARK
It is used to add ghost texts to your work such as “confidential” and
many others.
HOW TO INSERT WATERMARK TO YOUR TEXT
STEPS
1. Select the area where you want to insert your watermark
2. Move your cursor up to the word “DESIGN” and click it (left click
by using your mouse)
3. Move your cursor up to the word “CUSTOM WATERMARK”
4. Click on the word “CUSTOM WATERMARK”
5. Select the kind of watermark you want to insert to your document,
either a picture watermark or a text watermark.
6. Click on the word “APPLY” to put the watermark.
PAGE COLOR
It changes the color of your page.
HOW TO INSERT A PAGE COLOR TO YOUR DOCUMENT
STEPS
1. Select the place you want to insert the page color
2. Move your cursor up to the word “DESIGN” and click it (left click
using your mouse)
3. Move your cursor up and select the word “PAGE COLOR”(left
click using your mouse)
4. Select the color you want and click it.
31
S/N SHORTCUT MEANING
1 CTRL +C COPY
2 CTRL +S SAVE
3 CTRL +U UNDERLINE
4 CTRL +O OPEN
5 CTRL +N NEW DOCUMENT
6 CTRL +B BOLD
7 CTRL + A SELECT ALL
8 CTRL +P PRINT
9 CTRL +Z UNDO
10 CTRL +Y REDO
11 CTRL +E CENTER
12 CTRL+L ALIGNS TO THE LEFT
13 CTRL +R ALIGNS TO RIGHT
14 CTRL +X CUT
PRACTICE EXERCISE 1
QUESTION 1
i. Create a new folder on your computer and save it in the
desktop part and name it “TANZANIA” (use capital letters)
ii. Inside the folder named “TANZANIA” create a word file
name it “ARUSHA”(use capital letters and make sure you
save it)
iii. Create a folder name it “DAR ES SALAAM”(use capital
letters) and inside the folder DAR ES SALAAM create sub
folders named Kinondoni,Temeke,Ilala,Kigamboni,Ubungo.
iv. Inside the folder Kinondoni create sub folders named
Sinza,Tegeta,Mbezi Beach, Mwenge
v. Inside the folder Temeke create sub folders named Yanga,
polisi, DIT,Uwanja
QUESTION 2
32
Copy the text below and paste it into the file named ARUSHA
which you created above
ARUSHA ANTHEM
Jambo, jambo Bwana, Habarigani?
Nzurisana, wageni, karibukwetu Arusha yetu
Hakunamatata…………..*2
Mlima,mlimamkubwa Africa nzimaupokwetu
Karibu, karibusanauwezekujioneauzuriwetu.
Mbugazawanyam, mito,mabondemengi
Karibusanaufurahie Arusha kwetuhakunamatata
Karibu, karibuwote, mataifayotetunawakaribisha
Lugha,lughayetu Kiswahili chetukinafurahisha
Karibu, karibusanatufurahieutamaduniwetu.
Ngoma, ngomazaasili, chakulachetunindizi
Ndizi, ndizimshale,ngumuzenyeladhanzuri
Kahawa, kahawanzuriyaasilitunayo……!
QUESTION 3
After pasting the text above, highlight all the text and change the
font size to 12 and use the same theme font named “Tahoma”.
Bold the heading of the song named “ARUSHA ANTHEM” and
underline it and also save it to the center.
QUESTION 4
Put a paragraph on the first line of the song beginning with
jambo,milima and lugha and make sure you save your work
QUESTION 5
1. Open a new word document and save it in the folder named
“TANZANIA”
Name it “mkoa”
2. Open a new document and save it in the folder named
“TANZANIA” name it “wilaya”
QUESTION SIX
1. Write an official letter as it is written below and save it
33
NEEMA HAULE PAUL
P.O BOX 5802,
TANGA.
6/8/2020
SECRETARY
PRESIDENT OFFICE PUBLIC SERVICE RECRUITMENT SECRETARY
UTUMISHI Ho9OUSE KIVUKONI.
1102,DAR ES SALAAM.
Dear sir/madam;-
RE:APPLICATION FOR ARTISIAN/LINESMANEMPLOYMENT
refer to the heading above. I would like to apply for the post of artisian/linesman as you
advertised on 27/07/2020 with REF.NO.EA.7/9601/J/249. I have been interested in working for
your company for sometimes and I believe I have the skill and experience you need.
My name is NeemaHaule. I am a Tanzanian. I completed my secondary education at
Kimandolu in Arusha and my index number is PO679-0013 and I joined VETA for two years in
Arusha and obtained my vocation certificate of competent LEVEL IN ELECRICAL
INSTALLATION registration number01/CBA-11/EL/19D/089.
Please find my curriculum vitae, giving further evidence on my skills and experience. I have
attached my certificates for your review and this should give you an idea of my education and
qualification.
QUESTION 7
Use the insert tab to insert pictures in any document of your choice.
QUESTION 8
Draw a table below in the new file called morombo and save it in the
folder called muriet.
34
JEDWALI LETU, TUNAJIVUNIA NALO
S/N MOSHON NJIRO MOROMBO UNGA
O LIMITED
QUESTION 9
Prepare a cv/resume. Use the available templates on Microsoft word.
QUESTION 10
Create a document/file name it “hazinayetu” save it under a folder
named “akiba”.
Write the following work below
The following are the requirements
o Gallon of sugar
o Pair of socks
o Beam of ligh
o Jar of juice
o School of fish
a. A troupe of soldiers
b. Den of web
c. Gallon of sugar
d. Pair of socks
e. Beam of light
f. Jar of juice
g. A school of fish
h. a barrack of soldiers
i. a club of students
35
1. Mama
2. Baba
3. Shangazi.
QUESTION 11
Arrange the following names in alphabetical order
Zuwena
Khalid
Kulwa
Nyamisango
Bosco
Benjamin
Neema
Joel
Ulfaty
Hamis
Octavian
Geramiana
Yoshua
Shida
Matatizo
PRACTICE EXERCISE 2
AFRICAN MAMA’S BIG UP
Mother what a sweet name
It sounds like gold to one who has one
She is the first one to love you unconditionally before anyone
This is because we stayed in their womb for a very long time
36
May the almighty God bless all the mothers in this world
We love you and we care about you a lot.
A. Create a new folder and name it “MAMA YETU” save it in the
document part of your computer
B. Inside the document create a word file and name it “MAMA MIA”
C. Inside the file named MAMA MIA write the story above
D. Change the theme font to “times new Romans”
E. Change the font size to 20
F. Underline the heading and align it to the center
G. Change the page color to blue
H. Copy your work created above and paste it in another word
document and name it MUMMY
I. Convert the word file MUMMY to pdf and name it MUMMY 2.
PRACTICE EXERCISE 3
QUESTION 1
i. Create a word document/file name it “hadithi” and write the story
below
Once upon a time there lived a bright youngman named David. He was
tall, athletic and very charming. He lived in a village called
karumekenge were the members of the village were all peasants. David
worked really hard each morning and made sure he made his people feel
at ease with their lives as he was elected as one of the village trusted
37
youth as he collaborated much on making sure that the people move out
to the right direction so as they can make a living.
All the members of the village were found with David so all the way out
he was embraced with stunning glancing faces of people who were
wildly filled with gratitudes. He was kind and friendly person.
As David was growing up to his ripe 30s he had never had any girlfriend
as he was not too much focused on the whole issue of socializing as he
based most on the issues with regards to the society welfare.one day he
met a tall, African shaped girl with long thighs and hinge hips her face
was black and shinning like silver. David got stunned out and felt in love
with the lady so he insisted to make sure that he never told her anything
about how he feels just to avoid the influence he had on the people.
One day he went to the beautiful one’s home where she hardly lived
with her grandmother. He was surprised to see her with such a beautiful
face bright like the beautiful one named Jackline.
ii. Highlight all the story
iii. Change the font size to 20
iv. Change the font theme to “TIMES NEW ROMAN’
v. Bold the paragraph number one
vi. Change the word “KARUMEKENGE” to uppercase
vii. Change the font color on paragraph 3 to blue
viii. Highlight the text on paragraph 2 to yellow
ix. Replace the word beautiful with cute
x. Find the word “David” on the given passage
xi. Underline the first paragraph
xii. Replace the word selected with elected
xiii. Italize the last paragraph of the story
xiv. Copy the whole story
xv. Open a new document name it “KIZAZI CHETU” and save it.
xvi. Create a pdf document of the file above
QUESTION TWO
Draw the following figures
38
QUESTION THREE
i. Create a new word document/file and name it “CHAMPIONS” and
write the story below
School is an environment for the educated people who love to
empower their minds so as they can think better with regards to issues
concerning the academic wellbeing of the future societies.
Schools helps us to widen or broaden our curiosity as it raises
our awareness to handle variety of matters not to our personal matters
but on the whole globe issues concerning with discipline and
articulation to life better phenomenas.
School acts as a light to most of the people as it helps to light up
people’s minds so they can control the daily environment as they
matter a lot to enrich a brighter foundation for a better tomorrow.
Schools helps parents in general upbringing or caring of their
kids as they spend most of their times in class so as to make sure that
they get the qualifiable skills to enable them to control their daily
activities.
It is my call for the parents and guardians to find it of
great help to send their kids to school for a bright and shinning
future attributes of the next coming generations.
School it is where a lot of great men were made particularly
the scientists such as Isaac Newton, AlexandarGraham,Galileo
Galilee and many others. It is a home of ideas.it is a home of
innovation so find it of great importance to come to school always.
Schools is where most of the politians originated such as the great
BENJAMIN FRANKLIN, the president of America, Bill Clinton,
Mwalimu Julius KambarageNyerere and many others.
39
School is the best place of all kinds of generations to dwell upon
and make the best use of the time plus the viable resources so as to make
sure that life moves on as planned as life is enriched with lots of
beautiful instings from the best memories associated in schools to make
a viable place for proper upbringing of the new generation
40
iv. Change the page color to blue
v. Insert a picture of school .
QUESTION 4
i. Write the following questions
MANAGING DIRECTOR
PO BOX 5478
DAR ES SALAAM
ii. Write the text as it is written above
iii. Save the work as pdf document type.
QUESTION 5
i. Create a folder name it USA
ii. Inside the folder USA create another folder and name it NEW
YORK
iii. Inside the folder NEW YORK create another folder and name it
NEW ROCHELLE
iv. Inside the folder NEW ROCHELLE create another folder and
name it FREE STATES
v. Inside the folder FREE STATES create another folder and name it
TEXAS
vi. Inside the folder TEXAS create a word document and name it
HOUSTON.
PRACTICE EXERCISE 4
QUESTION 1
Create the following folders and save them in the document part of your
computer
i. Create a folder and name it MARIE GORRET(use capital letters
both)
Inside the folder you create above create the other folders as follows
KINAMPANDA
RUVUMA
41
SINGIDA
MOSHI
MUSOMA
BUNDA
TARIME
KIGOMA
CHALINZE
MAILI MOJA
CHATO
BUHEMBA
BUHARE
ii. Inside the folder KINAMPANDA create other folders name them
as NYIRAMBA,TATURU,SIMBITI,KISII and PARE.
iii. Inside the folder SINGIDA create other folders and name them
Hehe,Kamba,nyakyusa, kinga,bondei and fipa.
iv. Inside the folder MUSOMA create a folder and name it
KIABAKARI
v. Inside the folder KIABAKARI create sub folders and name them
as follows
Zanaki,ikoma,kurya,jita,kwaya,kerewe and haya.
vi. Inside the folder jita create the following Microsoft word files
mtani,malegesi,mafwiri,mwizarubi,nyamisango,nyabwire,nyambo
ga,nyakwesi
vii. Inside the folder CHATO create another folder name it Magufuli
and inside the folder Magufuli create another folder and name it
Janeth and then inside the folder Janeth create word document files
and name them as follows;-
Kahama,manzese,nyihogo,kongwa,mary and Teikwa.
viii. Create another folder name it Nyamisango, inside the folder
nyamisango create another folder and name it Kendrick, inside the
folder Kendrick create a word document file and name it
Ndaishime.
42
QUESTION 2
1. Open a word document and name it shambara and save it in the
document part of your computer
Write the words as follows
LIFE IS FULL OF BEAUTIFUL INSTINGS
LIFE IS FULL OF BEAUTIFUL INSTINGS
2. copy the above text and paste it into the word file named “KAZI”
and therefore save the file in the folder named “WORK”
3. create the folder in the document part of your computer
4. change the page color to orange.
QUESTION 3
open a new word document and save it in the desktop part of your
computer, name it UPENDO.
Write the following statement
Upendohauhusudu, haukosikuwanaadabu,
Huvumiliayote, hufadhiliyote,hautafuti mambo yake.
Answer the following questions
1. Insert a word watermark into the text write it “UPENDO WA
MUNGU”
2. Insert a picture watermark to your document.
43
TOPIC 3:
INTRODUCTION TO MICROSOFT EXCEL
DEFINITION
MICROSOFT EXCEL
Refers to the type of Microsoft office tool used for calculations and
graphical representations.
44
A FUNCTION IN EXCEL
Refers to a way used to perform calculations in excel using specific
values in a particular order
COMMON FUNCTIONS IN EXCEL
ADDITION/SUM
It is a function which is used to add or sum up things or items together.
FORMULA
=SUM(CELL1:CELL2) OR =SUM(NUMBER1,NUMBER2).
DIVISION
It is a function used to divide up things
FORMULA
=NUMBER1/NUMBER2
MULTIPLICATION
It is used to perform multiplication
FORMULA
=NUMBER1*NUMBER2
AVERAGE
It is used to get the average or mean results of things
FORMULA:
=AVERAGE(NUMBER1,NUMBER2)
OR
=AVERAGE(NUMBER1:NUMBER2)
MINIMUM NUMBER
It is used to get the smallest possible number
FORMULA
45
=MIN(NUMBER1,NUMBER2)
OR
=MIN(NUMBER1:NUMBER2).
MAXIMUM NUMBER
It is used to get the largest/maximum possible number
FORMULA:
=MAX(NUMBER1,NUMBER2)
OR
=MAX(NUMBER1:NUMBER2).
RANK
It is used to rank different things
FORMULA
=RANK(NUMBER 1, ref[order])
ROUND FUNCTION
It is used to round your work to the decimal places you want to have in
your work
FORMULA:
=ROUND(NUMBER,2)
This means round off the number to two decimal places
PERCENTAGE IN EXCEL
It is used to calculate the percentage of different items in excel
FORMULA:
=PART/TOTAL
47
2. Add column for the total(sum) of TEST 1 and TEST 2(name it
TOTAL MARKS)
3. Calculate the average marks
4. Find the minimum number
5. Find the maximum number
6. Find the grand total of TEST 1
7. Find the grand total of TEST 2
8. Divide Test 1 over Test 2
9. Round off the answer obtained above to 2 decimal places
QUESTION 2
1. Draw the following table
NO QUANTITY ITEMS
1 1769 8
2 56 76
3 54 7
4 110 78
5 768 50
6 1008 456
7 789 89
JEVINA 56 67 45 30 78
PAUL
MARTIN 76 87 34 23 60
48
PETER
JUMANNE 65 89 23 45 90
ISAYA
MARY 90 89 89 90 80
KEJO
GRACE 75 90 90 90 98
LUKINDO
KALIST 76 80 64 78 45
GEORGE
PETER 65 80 80 54 90
CHARLES
NURU 98 90 100 98 98
JAMES
JENNIFER 7O 98 98 70 67
UGGY
ADAM 90 90 98 90 100
MAFWIRI
ELIAS 76 80 78 89 90
PAUL
JOVIN 89 90 78 60 43
JOEL
JOEL 90 90 90 90 90
MANGOMA
ERASTO 76 34 54 90 43
KONDI
MAJURA 100 56 75 76 89
JOSHUA
NEEMA 50 90 67 50 80
WAMENSA
JOHN 56 75 43 50 50
MCHILA
49
2. Calculate the total marks for each student
3. Calculate the average for each student.
4. Calculate the students position using excel from the first to last.
TOPIC 4:
INTRODUCTION TO E-COMMERCE
DEFINITION
E-COMMERCE
Refers to electronic commerce.
Or
Refers to the process of buying and selling goods and services through
the internet.
Or
Refers to digital marketing
ORIGIN
It started after the evolution of IT
Example of common sites that are commonly engaged in e commerce
are like e-bay, kikuu, kupatana.com, Alibaba, bforward, SBT and many
other platforms.
DIFFERENCES BETWEEN E-COMMERCE AND
TRADITIONAL MARKETING
1. It is available 24/7- anyone has got access to the service regardless
of time compared to traditional marketing.
2. It saves time- it is more easy and simple to shop online rather than
to go into the traditional shop.
3. It is more convenient- it is because you can shop anywhere you
want just with the use of a device like mobile phone or computer.
50
4. Wide options- the consumer gets chance to select whatever he or
she wants from the items available on the store.
5. It is reliable- it is because it is good in quality or performance
51
1. Login onto the required website
2. Select the item you want to purchase from the search tab/menu
3. Choose an option of put to “CART”
4. Fill out your credit card details
5. Add your SHIPPING information/details
6. Therefore wait for the specified time given to you for the product
to be delivered
ADVANTAGES OF E COMMERCE
1. Faster buying/selling procedure as well as easy to find products
2. Buying and selling 24/7
3. More reach to customers, no theoretical geographic limitations
4. Low operational costs and better quality of services
5. No need of physical company set up
6. Easy to start and manage in business
7. Customers can easily select products from different providers
without moving around physically.
53
DISADVANTAGES OF E COMMERCE
1. Anyone good or bad can start a business (presence of bad sites
which eat up people’s money).
2. There is no guarantee of product quality
3. Mechanical failure can cause unpredictable effect on the total
processes
4. Many hakers /thieves on the internet, who look up for
opportunities to explore.
REVISION EXERCISE
1. Visit an online shop like amazon and try to purchase a leather
jacket
2. Visit kupatana.com and try to purchase an iPhone 7 128gb
3. Visit bforward website and try to purchase a car
4. Briefly explain the advantages of e commerce
5. Differentiate between traditional marketing and e commerce
54
TOPIC 5:
INTERNET AND EMAILS
INTERNET
Refers to the global network of computers
Or
It is a way in which computers are made to communicate
ORIGIN
It started from the US army and spread throughout the world
www- world wide web
BROWSER- refers to the software program that helps to connect your
computer with the internet
Computer without having any browser can not access the internet.
Examples of browsers are like;-
1. Mozilla firefox
2. Google chrome
3. Internet explorer
4. Opera mini
HOW TO CONNECT YOUR COMPUTER WITH THE
INTERNET
There are number of ways in which you can connect your computer with
the internet
1. WIRED CONNECTION
2. WIRELESS CONNECTION.
55
1. WIRED CONNECTION
It is a way in which you can connect your computer to the internet using
a wire.
The type of wire to be used might be a data connection wire/cable that is
USB cable or Ethernet cable.
HOW TO CONNECT YOUR COMPUTER TO THE INTERNET
USING A USB WIRE FROM THE SMARTPHONE (ANDROID
PHONES)
STEPS
1. Turn on the data on your smartphone
2. Go to settings on your phone
3. Connect your wire from the phone to the computer
4. Click on the word settings on your phone
5. Click on the word “Hotspot and tethering”
select USB tethering
6. The internet connection will display on your computer
2. WIRELESS CONNECTION
Refers to a way you can connect your computer to the internet without
using a wire
Hence it uses sensors like wi-fi(wireless fidelity).
HOW TO CONNECT YOUR COMPUTER TO THE INTERNET
USING A WIRELESS NETWORK (USING ANDROID PHONES)
STEPS
1. Make sure your smartphone is connected to the internet
2. Go to the setting tab on your mobile phone and select the word
“mobile hotspot”
3. Turn on the mobile hotspot
4. Therefore it will display on your computer with its name and
demand you to put/write a password if necessary
56
NB:
It is possible to set up the name of your network
The wi-fi network can connect up to 10 computers maximum
It is possible to limit the number of users of your network
depending on the scope.
WEBSITE
Refers to the number of web pages that are linked together
Examples of websites are like;-
www.tcu.go.tz(TCU)
www.udom.ac.tz(UDOM)
www.vodacom.co.tz(VODACOM)
GOOGLE
It is a website referred to as a “SEARCH ENGINE”
It is through Google where most of the information you want to get from
the internet are found.
ACADEMIC INTERNET USES
HOW TO DOWNLOAD A ‘PDF’ FILE FROM THE INTERNET
STEPS
1. Make sure your computer is connected to the internet
2. Go to the browser and open it
3. Open the search engine/Google
4. Type the kind of document you want to download “make sure you
end up with the file extension pdf”
Example
Ufugaji wa kuku pdf
HIV/AIDS pdf
Ufugaji wa samaki pdf
57
5. Select the necessary tab from the given options and hence the
document will display itself
59
3. Downloading files
4. Uploading files
5. Discussion groups example team viewer app, zoom
6. Interactive games
7. Education and self improvement.eg online courses
8. Friendship and dating e.g social media like face book,
whatsapp,Instagram
9. Electronic magazine and newspaper
10. Job hunting
11. Shopping.
E-MAIL
Electronic mail
Or
refers to the kind of mail that is sent through electronic means
It is different from postal mail because it is more reliable and accessible
compared to normal/postal mail
Or
Email refers to the process of exchanging mail between people using
electronic devices such as phone and computer
Example of mail services companies include yahoo mail, Gmail,
Hotmail etc.
PRACTICE EXERCISE 2
QUESTION 1
a) Write an email and send it to the address below
b.mtani94@gmail.com
the subject of the mail should be
“LIFE IS SHORT”
62
In the body write the following;-
Dear sir;
I sincerely acknowledge your presence and taking into
consideration that life is a gift.
Yours faithfully;
(write your name)
b) Attach a pdf file to the mail and send it.
QUESTION 2
1. Write an email and send it to the address below
b.mtani94@gmail.com
Choose any subject of your choice
2. Write an email and send it to the address below
b.mtani94@gmail.com
3. Attach a cover letter for a job post of “CLINICAL OFFICER AT
ARUMERU HOSPITAL”
NB: the cover letter should be a pdf file.
PRACTICE EXERCISE 3
1. Write an e mail to the following address
b.mtani94@gmail.com
2. send blind carbon copies to the email address below
Neemapaul104@gmail.com
eligirene@gmail.com
3. attach the following to the e-mail
official letter(saved in pdf)
63
cv(saved in pdf file format)
attach pictures whenever necessary
TOPIC 6:
INTRODUCTION TO MICROSOFT PUBLISHER
MICROSOFT PUBLISHER
Refers to the creative part of Microsoft office.
It is used to design variety of documents like
Flyers
Brochures
Invitation cards
Business cards
CHARACTERISTICS OF A GOOD DESIGN
64
1. Alignment- placement of text and graphics so that they can line up
on the page
2. Balance- it is used to make sure the elements are evenly distributed
on the page
3. Whitespace- it refers to the space on the design which has nothing
on it
4. Unity- make sure all objects and pieces are distributed together
5. Simple- it should never be complex
6. Visible- it is easy to read
INVITATION CARD
Refers to the cards purposely created for variety of invitations such as
wedding, send-off, kitchen party, birthday party, graduation and many
other ceremonies.
The type of invitation card that we will learn in our course is the
wedding invitation card
66
F IGURE 22 INVITATION CARD
BRONCHURE
67
Refers to an informative paper used for marketing and advertisement
HOW TO CREATE A BRONCHURE USING PUBLISHER
STEPS
1. Open Microsoft publisher app on your compouter
2. Move your cursor down and select the word BRONCHURE
3. Left click using your mouse and select one from the available
templates
4. Choose the word CREATE to start editing the template
5. Save your work
6. Insert pictures and edit accordingly with regards to the instructions
given on the template
F IGURE 23 BRONCHUR
FLYER
68
Refer to the document created purposely for wide distributioin and
usually posted in public areas.
HOW TO CREATE/DESIGN A FLYER IN MICROSOFT
PUBLISHER
STEPS
1. Open the Microsoft publisher app on your computer
2. Move your cursor down and select the word FLYER
3. Click on the word flyer (left click using your mouse) to create it
4. Save your work
5. Edit the template accordingly
F IGURE 24 FLYE
BUSINESS CARDS
69
Refers to cards created purposely for business identity like companies,
personal businesses. It contains vital information about a given business.
HOW TO CREATE BUSINESS CARD USING MICROSOFT
PUBLISHER
STEPS
1. Open Microsoft publisher app on your computer
2. Move your cursor down and select the word “MORE
TEMPLATES”
3. Move your cursor down and select the word “BUSINES CARD”
4. Click on the word “BUSINESS CARD”(left click using your
mouse)
5. Move your cursor down and choose the design of business card
you want to create(click it, left click using your mouse)
6. Save your work
7. Edit the template accordingly
PRACTICE EXERCISE 1
70
1. Create a wedding invitation cards
2. Create a bronchure about BENSON COMPUTERS COMPANY
located at ARUSHA
3. Create a flyer about ELECTIONS “VOTE FOER MAGUFULI”
4. Create any business card of your choice
PRACTICE EXERCISE 2
1. Create a wedding contribution card(kadiyamchangowaharusi)
2. Create a bronchure about CRDB BANK MOROMBO
3. Create a flyer about coconut oil
4. Create a business card of your choice.
PRACTICE EXERCISE 3
Design an invitation card with the given information
Familiayamr&mrsFortunatusMasamakiwakibaha,
pichayandegewanayofurahakubwakukualika
prof/Dr/mhe/Arch/Rev/Mr/Mrs/Miss…………………………………
Katika harusiyakijanawaompendwa MAFURU PETER MASAMAKI
anayetarajiakufungandoasikuyajumamositarehe 16/11/2020 katika
kanisa la TAG-KIBAHA, PICHA YA NDEGE.
Uwepowakonimuhimu sana ukiwa kama nduguwakaribu.
Fikanakadiyakoukumbini.
MAWASILIANO
MWENYEKITI 0786 768900
KATIBU 0723 456789
Use decorations whenever you find it necessary
TOPIC 7:
INTRODUCTION TO MICROSOFT POWERPOINT
MICROSOFT POWERPOINTS
It is used to create beautiful slides or presentations
HOW TO CREATE SLIDES IN MICROSOFT POWERPOINT
71
STEPS
1. Open Microsoft PowerPoint
2. Choose the kinds of slides you want to prepare from the available
templates
3. Click on the slide(left click using your mouse) and choose the
word “CREATE”
4. Save the slide
5. Start working out the slides.
HOW TO ADD A NEW SLIDE IN MICROSOFT POWERPOINT
STEPS
1. Right click on the current slide
2. Move your cursor up to the word “NEW SLIDE”
3. Click on the word “NEW SLIDE”(left click using your mouse)
Therefore the new slide will appear
HOW TO DUPLICATE A SLIDE
STEPS
1. Click on the slide you want to duplicate(left click using your
mouse)
2. Move the cursor down and choose the word “DUPLICATE”
3. Click on the word “DUPLICATE”(left click using your mouse)
72
4. Click on the word “DELETE”(left click using your mouse to
delete)
HOW TO INSERT A PICTURE IN A SLIDE
STEPS
1. Select the slide which you want to insert a picture
2. Move your cursor up to the word “INSERT”on your tab menu
3. Click on the word “INSERT” (left click using your mouse)
4. Choose where you want to get your pictures from, either this
PC/COMPUTER or online
5. Select the picture you want to insert
6. Finally click on the word insert to insert your picture(left click
using your mouse) and adjust accordingly
HOW TO INSERT A VIDEO IN YOUR SLIDE
STEPS
1. Select the slide in which you want to insert the video
2. Move your cursor up to the word “INSERT’ (left click using your
mouse)
3. Select the word “VIDEO” and click it(left click using your mouse)
4. Choose where you want to upload your video from, either from the
internet/online or on the computer
5. Select the video you want to insert
6. Click on the word “INSERT” left click using your mouse
Then the video will appear.
73
2. Move your cursor up to the word “TRANSITIONS”(left click
using your mouse)
3. Choose the kind of transition you want to put into your slide
4. Click on the transition and it will appear on the slide.
COMMON TRANSITIONS ARE;-
Fade
Push
Wipe
Split
Reveal
Cut
PRACTICE EXERCISE 1
1. Create a folder in the desktop part of your computer and name it
“DOMESTIC TOURISM”
2. Inside the folder “DOMESTIC TOURISM” create a Microsoft
powerpoint file and name it “UTALII” and write about
TOURISM(atleast 10 slides)
PRACTICE EXERCISE 2
1. Create a new folder in the document part of your computer name it
“MIKIMIKIKI”
2. Inside the folder MIKIKIMIKIKI create Microsoft power point
files and name them as follows
Majanga- it should be about HIV/AIDS
Maafa- it should be about COVID-19
74
Maarifa –it should be about COMPUTERS
Insert pictures and video files whenever necessary
NB; maximum number of files 10, mimimum 6 slides
PRACTICE EXERCISE 3
1. Create a new folder in the desktop part of your computer and name
it MATUNDA
2. Inside the folder MATUNDA create a Microsoft powerpoint file
and and name them as follows
Maembe- it should be about mangoes fruits only
Machungwa- it should be about orange fruits only
Maparachichi- it should be about avocado fruits only
Insert pictures and videos files whenever necessary
NB; maximum number of files 10, mimimum 6 slides
75
76