[6/23/20 10:58 AM] Sir Mugwira
Tuesday 23June 2020
[6/23/20 10:58 AM] Sir Mugwira
Paragraph Formatting
[6/23/20 11:00 AM] Sir Mugwira
1. Paragraph Alignment
[6/24/20 12:08 PM] Sir Mugwira
Practical Activities
[6/24/20 12:10 PM] Sir Mugwira
default
[6/24/20 12:11 PM] Sir Mugwira
font.
[6/24/20 12:11 PM] Sir Mugwira
Select all the text and use the
[6/24/20 12:11 PM] Sir Mugwira
serif font instead.
[6/24/20 12:13 PM] Sir Mugwira
2. The user has used the return key
[6/24/20 12:14 PM] Sir Mugwira
to separate paragraphs
[6/24/20 12:14 PM] Sir Mugwira
Use the paragraph spacing of 12pt
[6/24/20 12:15 PM] Sir Mugwira
(after) instead.
[6/24/20 12:18 PM] Sir Mugwira
3. The address in the second paragraph is supposed to
[6/24/20 12:18 PM] Sir Mugwira
occupy three lines.
(1 liked)
[6/24/20 12:19 PM] Sir Mugwira
Use soft line breaks
[6/24/20 12:20 PM] Sir Mugwira
after the following text
[6/24/20 12:20 PM] Sir Mugwira
a. Street
[6/24/20 12:21 PM] Sir Mugwira
b. Sarawoga
[6/24/20 12:22 PM] Sir Mugwira
4. The space bar has been used
[6/24/20 12:23 PM] Sir Mugwira
separate the
[6/24/20 12:23 PM] Sir Mugwira
the titles on the left
[6/24/20 12:23 PM] Sir Mugwira
from the descriptions
[6/24/20 12:23 PM] Sir Mugwira
on the right.
[6/24/20 12:24 PM] Sir Mugwira
Use tab stops of 8cm instead
[6/24/20 12:40 PM] Sir Mugwira
Using the Tab key
[6/24/20 12:41 PM] Sir Mugwira
the tab key is used to space
[6/24/20 12:41 PM] Sir Mugwira
text
[6/24/20 12:41 PM] Sir Mugwira
using defined positions
[6/24/20 12:44 PM] Sir Mugwira
the tab stop position
[6/24/20 12:44 PM] Sir Mugwira
is set to
[6/24/20 12:44 PM] Sir Mugwira
guide the tab key when positioning
text.
[7/6/20 12:10 PM] Sir Mugwira
Monday 6 July 2020
[7/6/20 12:11 PM] Sir Mugwira
Inserting Objects
[7/6/20 12:11 PM] Sir Mugwira
1. Inserting Tables
[7/6/20 12:11 PM] Sir Mugwira
in word processing
[7/6/20 12:11 PM] Sir Mugwira
a table is
[7/6/20 12:12 PM] Sir Mugwira
an object that comprises of
[7/6/20 12:12 PM] Sir Mugwira
rows and columns
[7/6/20 12:12 PM] Sir Mugwira
data in tables
[7/6/20 12:13 PM] Sir Mugwira
is entered in cells.
[7/6/20 12:15 PM] Sir Mugwira
the gridlines in tables
[7/6/20 12:15 PM] Sir Mugwira
are known as borders
[7/6/20 12:16 PM] Sir Mugwira
Practical Activity
[7/6/20 12:16 PM] Sir Mugwira
Create a table
[7/6/20 12:17 PM] Sir Mugwira
with 5 rows and 3 columns
[7/6/20 12:33 PM] Sir Mugwira
Format the first row so that the
[7/6/20 12:33 PM] Sir Mugwira
text is bold
[7/6/20 12:34 PM] Sir Mugwira
and the cells background colour is blue
[7/6/20 12:37 PM] Sir Mugwira
Inserting rows and columns
[7/6/20 12:38 PM] Sir Mugwira
In the table, insert 2 rows
[7/6/20 12:39 PM] Sir Mugwira
between the first row and the second row
[7/6/20 12:42 PM] Sir Mugwira
Insert the fourth column
[7/6/20 12:44 PM] Sir Mugwira
Merging cells
[7/6/20 12:44 PM] Sir Mugwira
when we merge cells,
[7/6/20 12:45 PM] Sir Mugwira
we will be combining
[7/6/20 12:45 PM] Sir Mugwira
multiple cells
[7/6/20 12:45 PM] Sir Mugwira
into 1 cell
[7/6/20 12:46 PM] Sir Mugwira
Combine (merge) the second row cells into 1 cell.
[7/6/20 12:51 PM] Sir Mugwira
2. Inserting images
[8/3/20 11:59 AM] Sir Mugwira
Monday 3 August 2020
[8/3/20 11:59 AM] Sir Mugwira
Automated Fields
[8/3/20 12:00 PM] Sir Mugwira
In the lesson today, we look at the automated fields when inserting:
1. Headers and footers
2. Dates (including time)
3. Page numbers
4. Automated file names
[8/3/20 12:04 PM] Sir Mugwira
automated fields are sections of text that are automatically
[8/3/20 12:05 PM] Sir Mugwira
generated by the application.
[8/3/20 12:06 PM] Sir Mugwira
1. Headers and Footers
[8/3/20 12:06 PM] Sir Mugwira
a header is text that is automatically displayed
[8/3/20 12:07 PM] Sir Mugwira
at the top of every page.
[8/3/20 12:08 PM] Sir Mugwira
footer is automatically displayed at the bottom
[8/3/20 12:08 PM] Sir Mugwira
of every page.
[8/3/20 12:10 PM] Sir Mugwira
2. Automated file name
[8/3/20 12:10 PM] Sir Mugwira
a file name is
[8/3/20 12:11 PM] Sir Mugwira
the name we use to save our document.
[8/3/20 12:11 PM] Sir Mugwira
the file name has a file type (.docx)
[8/3/20 12:12 PM] Sir Mugwira
Practical Activity 1
[8/3/20 12:13 PM] Sir Mugwira
In the file Reports.docx
[8/3/20 12:13 PM] Sir Mugwira
a. Insert the header with:
[8/3/20 12:14 PM] Sir Mugwira
i. Your name and surname left aligned.
[8/3/20 12:15 PM] Sir Mugwira
ii. an automated file name right aligned.
[8/3/20 12:16 PM] Sir Mugwira
b. In the footer of the document, insert the following:
[8/3/20 12:17 PM] Sir Mugwira
i. an automated file name and path left aligned.
5. [8/3/20 12:18 PM] Sir Mugwira
6. ii. automated page numbers right aligned.
7.
8. [8/3/20 12:50 PM] Sir Mugwira
9. Practical Activity 2
10.
11. [8/3/20 12:51 PM] Sir Mugwira
12. At the end of your document, insert the text
13.
14. [8/3/20 12:51 PM] Sir Mugwira
15. Reports generated on:
16.
17. [8/3/20 12:52 PM] Sir Mugwira
18. insert an automated date (today's date)
[8/4/20 10:46 AM] Sir Mugwira
Tuesday 4 August 2020
[8/4/20 10:46 AM] Sir Mugwira
Document Output
[8/4/20 10:49 AM] Sir Mugwira
Page Size
[8/4/20 10:51 AM] Sir Mugwira
the page size
[8/4/20 10:51 AM] Sir Mugwira
is the width and the height of a page
[8/4/20 10:52 AM] Sir Mugwira
A4 is the common page size with a width of 21cm
[8/4/20 10:52 AM] Sir Mugwira
and 29.7cm as the height.
[8/4/20 10:55 AM] Sir Mugwira
Page margins
[8/4/20 10:56 AM] Sir Mugwira
a page margin is space
[8/4/20 10:56 AM] Sir Mugwira
between the text and the edge
[8/4/20 10:56 AM] Sir Mugwira
of a page.
[8/4/20 10:59 AM] Sir Mugwira
four types of margins are:
[8/4/20 10:59 AM] Sir Mugwira
left, right, top and bottom
[8/4/20 11:00 AM] Sir Mugwira
the default page margin
[8/4/20 11:00 AM] Sir Mugwira
is 2.54cm
[8/4/20 11:02 AM] Sir Mugwira
Page Orientation
[8/4/20 11:03 AM] Sir Mugwira
page orientation is the direction
[8/4/20 11:03 AM] Sir Mugwira
in which the document
[8/4/20 11:03 AM] Sir Mugwira
displayed
[8/4/20 11:04 AM] Sir Mugwira
two types of orientation
[8/4/20 11:04 AM] Sir Mugwira
are:
[8/4/20 11:07 AM] Sir Mugwira
landscape and portrait.
[8/12/20 12:04 PM] Sir Mugwira
Wednesday 12 August 2020
[8/12/20 12:04 PM] Sir Mugwira
Mail Merge
[8/12/20 12:14 PM] Sir Mugwira
Mail merge is tool
[8/12/20 12:14 PM] Sir Mugwira
in word processing
[8/12/20 12:15 PM] Sir Mugwira
that is used to create
[8/12/20 12:15 PM] Sir Mugwira
personalised documents.
[8/12/20 12:18 PM] Sir Mugwira
to perform mail merging
[8/12/20 12:18 PM] Sir Mugwira
we need two document
[8/12/20 12:18 PM] Sir Mugwira
to produce the third document
[8/12/20 12:20 PM] Sir Mugwira
1. Template
[8/12/20 12:20 PM] Sir Mugwira
2. Data source
[8/12/20 12:21 PM] Sir Mugwira
Template + Data source = Merged document
[8/12/20 12:23 PM] Sir Mugwira
What is template?
[8/12/20 12:23 PM] Sir Mugwira
a template is the main document
[8/12/20 12:23 PM] Sir Mugwira
where we insert merge fields
[8/12/20 12:24 PM] Sir Mugwira
What is a data source?
[8/12/20 12:25 PM] Sir Mugwira
a data source is the document that
[8/12/20 12:25 PM] Sir Mugwira
contains the merge fields
[8/12/20 12:33 PM] Sir Mugwira
Mail Merge steps
[8/12/20 12:33 PM] Sir Mugwira
1. Link the template
[8/12/20 12:34 PM] Sir Mugwira
with the data source
[8/12/20 12:34 PM] Sir Mugwira
(Make sure the
[8/12/20 12:34 PM] Sir Mugwira
data source file is closed)
[8/12/20 12:39 PM] Sir Mugwira
2. Insert relevant
[8/12/20 12:39 PM] Sir Mugwira
merge fields
[8/12/20 12:44 PM] Sir Mugwira
3. Format the template
[8/12/20 12:51 PM] Sir Mugwira
Produce and save
[8/12/20 12:51 PM] Sir Mugwira
the merged document
[9/24/20 9:06 AM] Sir Mugwira
Introduction to Networks
[9/24/20 9:08 AM] Sir Mugwira
are connected for the purpose of sharing resources
[9/24/20 9:08 AM] Sir Mugwira
2 or more computers
[9/24/20 9:08 AM] Sir Mugwira
o a computer network is when
[9/24/20 9:10 AM] Sir Mugwira
Why connect computers to a network?
[9/24/20 9:17 AM] Sir Mugwira
1. To share hardware resources
[9/24/20 9:20 AM] Sir Mugwira
2. To share software programs
[9/24/20 9:25 AM] Sir Mugwira
3. To share files
[9/24/20 9:32 AM] Sir Mugwira
4. for data backup
[9/24/20 9:34 AM] Sir Mugwira
5. To access the internet
Managing Worksheets ( 1 Oct)
Q3#t2020
Managing Cells ( 8 Oct)
[10/13/20 9:01 AM] Sir Mugwira
Data Transfer in Networks
[10/13/20 9:03 AM] Sir Mugwira
o the rate of data signals
[10/13/20 9:04 AM] Sir Mugwira
transfer rate
[10/13/20 9:04 AM] Sir Mugwira
o data transfer rate is measured in
[10/13/20 9:04 AM] Sir Mugwira
bits per second
[10/13/20 9:05 AM] Sir Mugwira
(bps)
[10/13/20 9:23 AM] Sir Mugwira
Server
[10/13/20 9:25 AM] Sir Mugwira
Client
[10/13/20 9:28 AM] Sir Mugwira
Uploading
Downloading
[10/15/20 9:02 AM] Sir Mugwira
Thursday 15 October 2020
[10/15/20 9:02 AM] Sir Mugwira
Entering Data in Spreadsheets
[10/15/20 9:04 AM] Sir Mugwira
o there are 3 types of data
[10/15/20 9:04 AM] Sir Mugwira
we can enter in a cell
[10/15/20 9:05 AM] Sir Mugwira
1. Values
[10/15/20 9:06 AM] Sir Mugwira
o in a spreadsheet, a value
[10/15/20 9:06 AM] Sir Mugwira
is a numeric
[10/15/20 9:06 AM] Sir Mugwira
data which can be
[10/15/20 9:07 AM] Sir Mugwira
involved in calculations
[10/15/20 9:07 AM] Sir Mugwira
o a value can be in form of:
[10/15/20 9:08 AM] Sir Mugwira
1. integers
[10/15/20 9:08 AM] Sir Mugwira
b. decimals
[10/15/20 9:08 AM] Sir Mugwira
c. currency
[10/15/20 9:08 AM] Sir Mugwira
d. dates
[10/15/20 9:08 AM] Sir Mugwira
e. time
[10/15/20 9:11 AM] Sir Mugwira
in cells
[10/15/20 9:11 AM] Sir Mugwira
o value are automatically right-aligned
[10/15/20 9:14 AM] Sir Mugwira
2. Labels
[10/15/20 9:15 AM] Sir Mugwira
o a label is in alphanumeric
[10/15/20 9:15 AM] Sir Mugwira
form
[10/15/20 9:16 AM] Sir Mugwira
(text form)
[10/15/20 9:17 AM] Sir Mugwira
o labels are automatically left-aligned
[10/15/20 9:22 AM] Sir Mugwira
3. Formulas
[10/15/20 9:23 AM] Sir Mugwira
o a formula is an expression
[10/15/20 9:24 AM] Sir Mugwira
used to perform calculations
[10/15/20 9:24 AM] Sir Mugwira
or other data manipulation
[10/15/20 9:24 AM] Sir Mugwira
activities in a spreadsheet
[10/15/20 9:25 AM] Sir Mugwira
o when entering a formula in a cell
[10/15/20 9:25 AM] Sir Mugwira
we start by typing an =sign
[10/15/20 9:26 AM] Sir Mugwira
o formulas can also be in form of functions
o [10/20/20 9:10 AM] Sir Mugwira
o Tuesday 20 October 2020
o
o [10/20/20 9:10 AM] Sir Mugwira
o Network Components
o
o [10/20/20 9:11 AM] Sir Mugwira
o network components are hardware and software
o
o [10/20/20 9:11 AM] Sir Mugwira
o components used when connecting
o
o [10/20/20 9:11 AM] Sir Mugwira
o computer systems
o
o [10/20/20 9:11 AM] Sir Mugwira
o to a network.
o
o [10/20/20 9:12 AM] Sir Mugwira
o Examples of network components
o
o [10/20/20 9:19 AM] Sir Mugwira
o 2. Network Interface Card (NIC)
o
o [10/20/20 9:24 AM] Sir Mugwira
o 3. Wireless Adapter
o
o [10/20/20 9:28 AM] Sir Mugwira
o 4. Switch
[10/22/20 9:02 AM] Sir Mugwira
Thursday 22 October 2020
[10/22/20 9:02 AM] Sir Mugwira
Editing Data
[10/22/20 9:03 AM] Sir Mugwira
Editing data in cells
[10/22/20 9:04 AM] Sir Mugwira
o when editing data in a cell, we can use the formula bar
[10/22/20 9:05 AM] Sir Mugwira
or we can double-click
[10/22/20 9:05 AM] Sir Mugwira
on the cell to be edited
[10/22/20 9:10 AM] Sir Mugwira
Copying and Moving data in cells
[10/22/20 9:13 AM] Sir Mugwira
o when copying we use the Copy and Paste commands while moving
[10/22/20 9:13 AM] Sir Mugwira
we use the Cut and Paste commands
[10/22/20 9:23 AM] Sir Mugwira
Finding and Replacing data
[10/22/20 9:24 AM] Sir Mugwira
o to find data we use the shortcut Ctrl+F
[10/22/20 9:25 AM] Sir Mugwira
o to replace data we use the shortcut
[10/22/20 9:25 AM] Sir Mugwira
Ctrl+H
[10/27/20 9:08 AM] Sir Mugwira
Tuesday 27 October 2020
[10/27/20 9:08 AM] Sir Mugwira
Router
[10/27/20 9:09 AM] Sir Mugwira
a router is a network device
[10/27/20 9:10 AM] Sir Mugwira
that is used to connect
[10/27/20 9:10 AM] Sir Mugwira
computer systems to the internet
[10/27/20 9:12 AM] Sir Mugwira
Proxy server
[10/27/20 9:16 AM] Sir Mugwira
using a proxy server we can block
[10/27/20 9:16 AM] Sir Mugwira
unwanted websites
[10/27/20 9:19 AM] Sir Mugwira
Bridge
[10/27/20 9:20 AM] Sir Mugwira
a bridge is a network device used to connect
[10/27/20 9:20 AM] Sir Mugwira
similiar networks
[10/27/20 9:21 AM] Sir Mugwira
for example, Local Area Networks
[10/27/20 9:23 AM] Sir Mugwira
Repeater
[10/27/20 9:23 AM] Sir Mugwira
a repeater is network device
[10/27/20 9:24 AM] Sir Mugwira
that is used to amply
[10/27/20 9:24 AM] Sir Mugwira
network signal
Formatting cells ( 29 Oct)
[10/30/20 9:47 AM] Sir Mugwira
Friday 30 October 2020
[10/30/20 9:47 AM] Sir Mugwira
Sorting Data
[10/30/20 9:48 AM] Sir Mugwira
sorting is the arrangement
[10/30/20 9:48 AM] Sir Mugwira
of data in a defined order
[10/30/20 9:50 AM] Sir Mugwira
sorting can be in ascending order
[10/30/20 9:51 AM] Sir Mugwira
(A to Z or smallest to largest)
[10/30/20 9:52 AM] Sir Mugwira
it can also be in descending order
[10/30/20 9:52 AM] Sir Mugwira
(Z to A or largest to smallest)
[10/30/20 9:56 AM] Sir Mugwira
Practical Activity 1
[10/30/20 9:56 AM] Sir Mugwira
Sort the students data by the final mark
[10/30/20 9:56 AM] Sir Mugwira
in descending order
[10/30/20 10:00 AM] Sir Mugwira
Practical Activity 2
[10/30/20 10:01 AM] Sir Mugwira
Sort the students data
[10/30/20 10:01 AM] Sir Mugwira
by the Surname in ascending order
[10/30/20 10:09 AM] Sir Mugwira
Multi-Level Sorting
[10/30/20 10:09 AM] Sir Mugwira
this is when we use more than 1 column
[10/30/20 10:09 AM] Sir Mugwira
when sorting data
[10/30/20 10:10 AM] Sir Mugwira
Practical Activity 3
[10/30/20 10:10 AM] Sir Mugwira
Sort the students data
[10/30/20 10:11 AM] Sir Mugwira
by Gender in ascending order and then by Surname in ascending ascending order
[11/3/20 9:02 AM] Sir Mugwira
Network Types
[11/3/20 9:02 AM] Sir Mugwira
we have three types of networks
[11/3/20 9:02 AM] Sir Mugwira
and these are:
[11/3/20 9:03 AM] Sir Mugwira
1. Local Area Network (LAN)
[11/3/20 9:04 AM] Sir Mugwira
this is a type of network
[11/3/20 9:04 AM] Sir Mugwira
where devices are
[11/3/20 9:04 AM] Sir Mugwira
are connected within
[11/3/20 9:05 AM] Sir Mugwira
a small geographical area
[11/3/20 9:05 AM] Sir Mugwira
an example of a LAN
[11/3/20 9:06 AM] Sir Mugwira
is when computers and devices
[11/3/20 9:06 AM] Sir Mugwira
communicate within a school campus
[11/3/20 9:06 AM] Sir Mugwira
in a LAN
[11/3/20 9:07 AM] Sir Mugwira
devices like printers
[11/3/20 9:07 AM] Sir Mugwira
scanners and projectors
[11/3/20 9:07 AM] Sir Mugwira
can be shared among users
[11/3/20 9:10 AM] Sir Mugwira
devices in a LAN
[11/3/20 9:10 AM] Sir Mugwira
can be connected using physical
[11/3/20 9:11 AM] Sir Mugwira
cables
[11/3/20 9:11 AM] Sir Mugwira
or they can be connected wirelessly
[11/3/20 9:11 AM] Sir Mugwira
when devices are connected
[11/3/20 9:12 AM] Sir Mugwira
wirelessly in a LAN
[11/3/20 9:12 AM] Sir Mugwira
the network is known as
[11/3/20 9:12 AM] Sir Mugwira
a Wireless Local Area Network
[11/3/20 9:12 AM] Sir Mugwira
(WLAN)
[11/3/20 9:22 AM] Sir Mugwira
2. Wide Area Network
[11/3/20 9:22 AM] Sir Mugwira
(WAN)
[11/3/20 9:23 AM] Sir Mugwira
this type of network
[11/3/20 9:23 AM] Sir Mugwira
covers large geographical area
[11/3/20 9:24 AM] Sir Mugwira
-the internet is a classic example of a WAN
[11/3/20 9:25 AM] Sir Mugwira
for example computers across the globe
[11/3/20 9:27 AM] Sir Mugwira
3. Personal Area Network
[11/3/20 9:27 AM] Sir Mugwira
(PAN)
[11/3/20 9:28 AM] Sir Mugwira
this is a type of
[11/3/20 9:28 AM] Sir Mugwira
network designed for short range communication
[11/3/20 9:29 AM] Sir Mugwira
bluetooth is an example
[11/3/20 9:29 AM] Sir Mugwira
of a PAN
[11/3/20 9:31 AM] Sir Mugwira
Homework
[11/3/20 9:31 AM] Sir Mugwira
List any uses of bluetooth
[11/3/20 9:31 AM] Sir Mugwira
in our day-to-day lives
[11/5/20 9:00 AM] Sir Mugwira
Thursday 5 November 2020
[11/5/20 9:00 AM] Sir Mugwira
Formulas
[11/5/20 9:02 AM] Sir Mugwira
equation that is used to
[11/5/20 9:03 AM] Sir Mugwira
perform calculations using
[11/5/20 9:03 AM] Sir Mugwira
using arithmetic operators
[11/5/20 9:04 AM] Sir Mugwira
when entering a formula
[11/5/20 9:04 AM] Sir Mugwira
we start by typing an = sign
[11/5/20 9:05 AM] Sir Mugwira
formulas are used to:
[11/5/20 9:05 AM] Sir Mugwira
a. add values -
[11/5/20 9:06 AM] Sir Mugwira
using the + operator
[11/5/20 9:07 AM] Sir Mugwira
b. subtract values -
[11/5/20 9:07 AM] Sir Mugwira
using the - operator
[11/5/20 9:07 AM] Sir Mugwira
c. multiply values -
[11/5/20 9:08 AM] Sir Mugwira
using the * operator
[11/5/20 9:09 AM] Sir Mugwira
d. divide values -
[11/5/20 9:09 AM] Sir Mugwira
using the / operator
[11/5/20 9:10 AM] Sir Mugwira
e. find the power of values
[11/5/20 9:11 AM] Sir Mugwira
using the ^ operator
[11/5/20 9:14 AM] Sir Mugwira
Practical Activities
[11/5/20 9:14 AM] Sir Mugwira
Using the display screen enter the following formulas
[11/5/20 9:14 AM] Sir Mugwira
1. In cell G2, enter a formula
[11/5/20 9:15 AM] Sir Mugwira
that adds
[11/5/20 9:15 AM] Sir Mugwira
all the tests written by John
[11/5/20 9:16 AM] Sir Mugwira
Copy this formula for all students
[11/5/20 9:20 AM] Sir Mugwira
2. In cell H2, enter a formula
[11/5/20 9:20 AM] Sir Mugwira
that subtracts 30 marks
[11/5/20 9:21 AM] Sir Mugwira
from the total marks in cell G2.
[11/5/20 9:21 AM] Sir Mugwira
Copy this formula
[11/5/20 9:21 AM] Sir Mugwira
for other students
[11/5/20 9:24 AM] Sir Mugwira
2. In cell I2
3. [11/5/20 9:24 AM] Sir Mugwira
4. enter a formula that
5.
6. [11/5/20 9:24 AM] Sir Mugwira
7. divides the mark in
8.
9. [11/5/20 9:25 AM] Sir Mugwira
10. in cell H2
11.
12. [11/5/20 9:25 AM] Sir Mugwira
13. by 300
14.
15. [11/5/20 9:25 AM] Sir Mugwira
16. and multiplies the result by 2
[11/10/20 9:03 AM] Sir Mugwira
o computers networks are used
[11/10/20 9:03 AM] Sir Mugwira
for various purposes
[11/10/20 9:04 AM] Sir Mugwira
1. Using the internet
[11/10/20 9:04 AM] Sir Mugwira
2. Using the Intranet
[11/10/20 9:05 AM] Sir Mugwira
3. Using the Extranet
[11/10/20 9:06 AM] Sir Mugwira
The Internet
[11/10/20 9:11 AM] Sir Mugwira
o the internet is a world-wide (global)
[11/10/20 9:12 AM] Sir Mugwira
collection of computer networks
[11/10/20 9:12 AM] Sir Mugwira
where users can access various services
[11/10/20 9:15 AM] Sir Mugwira
o the internet comprises of the
[11/10/20 9:16 AM] Sir Mugwira
following components
[11/10/20 9:16 AM] Sir Mugwira
1. computer systems
[11/10/20 9:16 AM] Sir Mugwira
b. transmission channels
[11/10/20 9:17 AM] Sir Mugwira
c. world wide web
[11/10/20 9:17 AM] Sir Mugwira
d. various protocols
[11/10/20 9:21 AM] Sir Mugwira
How to access the internet
[11/10/20 9:22 AM] Sir Mugwira
o for you to access the internet you need the following
[11/10/20 9:22 AM] Sir Mugwira
1. internet enabled device
[11/10/20 9:24 AM] Sir Mugwira
b. access to an Internet Service Provider (ISP)
[11/10/20 9:28 AM] Sir Mugwira
c. a browser
[11/10/20 9:28 AM] Sir Mugwira
Internet Services
[11/10/20 9:29 AM] Sir Mugwira
1. Communication
[11/10/20 9:30 AM] Sir Mugwira
2. Research
[11/10/20 9:31 AM] Sir Mugwira
3. Business Transactions
[11/10/20 9:32 AM] Sir Mugwira
4. Entertainment
[11/10/20 9:33 AM] Sir Mugwira
5. Online education
[11/10/20 9:34 AM] Sir Mugwira
6. Online storage
[11/10/20 9:35 AM] Sir Mugwira
7. Downloading software
[11/12/20 8:59 AM] Sir Mugwira
Thursday 12 November 2020
[11/12/20 9:00 AM] Sir Mugwira
Functions in Spreadsheets
[11/12/20 9:00 AM] Sir Mugwira
Meeting Download Expired
Edited
[11/12/20 9:02 AM] Sir Mugwira
o a function is pre-written formula
[11/12/20 9:02 AM] Sir Mugwira
(predefined formula)
[11/12/20 9:03 AM] Sir Mugwira
that is used to perform calculations
[11/12/20 9:03 AM] Sir Mugwira
and other operations
[11/12/20 9:04 AM] Sir Mugwira
o functions shorten or simplify
[11/12/20 9:05 AM] Sir Mugwira
long and complex formulas
[11/12/20 9:05 AM] Sir Mugwira
Examples of functions
[11/12/20 9:07 AM] Sir Mugwira
1. SUM function
[11/12/20 9:07 AM] Sir Mugwira
used to add values
[11/12/20 9:07 AM] Sir Mugwira
2. AVERAGE function
[11/12/20 9:08 AM] Sir Mugwira
used to find the mean or the average of values
[11/12/20 9:09 AM] Sir Mugwira
3. PRODUCT function
[11/12/20 9:09 AM] Sir Mugwira
used to multiply values
[11/12/20 9:10 AM] Sir Mugwira
4. POWER function
[11/12/20 9:10 AM] Sir Mugwira
used to raise a value
[11/12/20 9:10 AM] Sir Mugwira
to a a given power
[11/12/20 9:11 AM] Sir Mugwira
5. ROUND function
[11/12/20 9:11 AM] Sir Mugwira
used to round off
[11/12/20 9:11 AM] Sir Mugwira
a decimal number
[11/12/20 9:12 AM] Sir Mugwira
to given decimal places
[11/12/20 9:12 AM] Sir Mugwira
6. INT function
[11/12/20 9:13 AM] Sir Mugwira
used to extract the integer
[11/12/20 9:13 AM] Sir Mugwira
part of a given decimal number
[11/12/20 9:14 AM] Sir Mugwira
7. MAX function
[11/12/20 9:14 AM] Sir Mugwira
-used to determine the highest value
[11/12/20 9:14 AM] Sir Mugwira
from a given list
[11/12/20 9:15 AM] Sir Mugwira
8. MIN function
[11/12/20 9:15 AM] Sir Mugwira
used to determine the lowest
[11/12/20 9:15 AM] Sir Mugwira
value from a given list
[11/12/20 9:16 AM] Sir Mugwira
9. COUNT function
[11/12/20 9:16 AM] Sir Mugwira
used to count number of cells
[11/12/20 9:16 AM] Sir Mugwira
with values
[11/12/20 9:17 AM] Sir Mugwira
10 COUNTA function
[11/12/20 9:17 AM] Sir Mugwira
used to count all cells that are not
[11/12/20 9:18 AM] Sir Mugwira
Blank
