Microsoft Excel 3. Statview 4. Quattro Pro 5. GS-Calc: 1. Lotus 1-2-3
Microsoft Excel 3. Statview 4. Quattro Pro 5. GS-Calc: 1. Lotus 1-2-3
Microsoft Excel 3. Statview 4. Quattro Pro 5. GS-Calc: 1. Lotus 1-2-3
are majorly used for organizing and analysing numeric data. They NOTE: For the purpose of this lesson, our focus shall be on
were designed to replace the pencil, calculator and the writing pad. Microsoft Excel because it is user-friendly, flexible and contains
It is widely used in diverse range of discipline like Engineering, more advanced features.
Mathematics, Science, Accounting, etc.
Sub-topic 2:
CELL:
WEEK 3
A Cell is the intersection of a row and a column. The highlighted
TOPIC: SPREADSHEET PACKAGES II rectangle on the cell is the cursor but is known as ‘cell pointer’
which enable users to move around the sheet. They can be
CONTENT: - Spreadsheet Features and Terminologies
identified by the combination of column header (e.g. ‘A’) and the
- Loading and Exiting Spreadsheet Packages
row header (e.g. ‘1’) to give cell A1.
Sub-Topic 1:
Spreadsheet Features and Terminologies
ACTIVE CELL:
The active cell is the cell that contains the cell pointer, while the
To fully understand and use a spreadsheet package, one must be
active worksheet is the worksheet where the cell pointer is
used to some terminologies. These terminologies include;
currently located.
1. Row
2. Column
WORKSHEET:
3. Cell
The worksheet (also known as spreadsheet) is the working area of
4. Active Cell
the package where entering of data and calculations are handled. It
5. Worksheets
consists of rows, columns, cells and a cell pointer where data are
6. Workbook
actually entered and manipulated.
7. Chart
8. Data Range
WORKBOOK:
9. Fill handle
This can be simply defined as a collection of worksheets. Each
10. Moving border
workbook contains many worksheets just like a normal single book
with a number of pages.
ROWS:
NOTE: Educators should please ensure that students practise the Saving a Worksheet
act of entering data into the worksheet by entering the data shown To save a worksheet for the first time, follow the steps below;
in fig. 4.1 above. 1. Click on the Microsoft office Button
2. Click on Save
Editing the Worksheet 3. When the dialog box appears, in the save in box click on the
Editing a worksheet means to either insert data, delete existing arrow, a drop-down menu appears.
ones or to make corrections to the already existing data. Fig. 4.2 4. Select a location to save e.g. My Document
below shows the edited version of fig. 4.1 5. Type a file name in the File name box.
6. Click on Save
Save in Box Arrow for Drop Down
tool bar. Formatting changes the way numbers and text are
displayed in a worksheet.
Changing Fonts:
NOTE: Educators should practically demonstrate the methods of
changing font sizes, style, colour, attributes (bold, italics and
underline), alignment(left, right, centre), style, etc.
Sub-Topic 2:
Formatting Worksheet:
The general arrangement of data is known as ‘Formatting’. The
contents of selected cells can be formatted using the formatting
When MS Excel is opened, the sheets are named Sheet 1, Sheet 2, EVALUATION:
etc. To rename a worksheet: 1. (a) Define Worksheet.
1. Right click on the sheet tab to be renamed (b) State the THREE types of data that can be entered into a
2. Select Rename worksheet.
3. Type the name you wish to give to give to the sheet 2. Highlight the steps required to do the following;
4. Press the Enter key (a) Open a worksheet (b) Save a worksheet (c) Retrieve a
worksheet
(d) Rename a worksheet
WEEKEND ASSIGNMENT:
1. ________can be defined as the working area of the program
where entering of data and calculations are handled.
(a) Worksheet (b) Workbook (c) Workcell (d) When working on Excel calculations, the following guidelines
row should be considered;
2. Which of the following cannot be found in a worksheet? 1. To enter a formula, first select the cell that will contain the
(a) Cell pointer (b) Column (c) Animations (d) Row formula.
3. ________are mathematical expressions which return 2. All formula must begin with equal (=) sign tells Excel to treat
calculated value. the cells contents as a formula.
(a) MS Excel (b) Formula (c) Equation (d) 3. The formula should not be more than 1024 characters.
Function 4. (iv) The function name (e.g. SUM, AVERAGE) which is
4. To save a workbook for future reference, a ________ must be preceded by equal (=) sign must be selected and followed by
given to it. the desired argument, i.e. =SUM (A5:F5). In this case, SUM is
(a) File name (b) File title (c) Reference name(d) Reference the function name and A5:F5 is the argument.
title
5. ________ changes the way numbers and text are displayed in Addition: Using the SUM Function
a worksheet. The SUM function is used to add together a range of data or
(a) Arrangement (b) Decoration (c) Formatting (d) numbers. To sum up the values of a range of data:
Highlighting 1. Open the worksheet containing data (as previously done in fig
6. ________ sign is displayed when the content of the cell is 4.2 above).
more than what the cell can accommodate. (a) ₦ (b) 2. Position the cell pointer on the desired cell i.e. the cell where
(c) £ (d) # the result should be displayed.
3. Type equal sign, Select the function (i.e. SUM) and state the
WEEK 5 range of cells.
4. MS Excel will highlight the range specified.
TOPIC: WORKSHEET II
5. Press the Enter key.
Sub-Topic 1: EXCEL CALCULATIONS: 6. The result is displayed.
The basic and most powerful feature of Microsoft Excel is the
ability to accept formula into the worksheet. A Formula is an
instruction that is entered to tell Excel how to Add, Subtract,
Multiply, Divide, or otherwise perform calculation by using the
content of other cells. It is advisable to construct formula that
makes reference to cells in the worksheet so that the result can be
instantly generated even the values are changed.
Fig 5.1: summing up a range of values 2. Click on AutoSum () and select “Count”
3. Press the ENTER KEY.
NOTE: Educators should kindly ensure that each student follow
the steps above and should also endeavour to explain alternative
Multiplication:
methods using the ‘AUTOSUM’ symbol (), and Addition sign(+).
The multiplication function is solely for multiplication of numbers
just like in arithmetic. To multiply a range of data;
Subtraction: Using the IMSUB Function
13. Position the cell pointer on the desired cell i.e. the cell
The IMSUB function is used to find the difference of two numbers.
where the result should be displayed.
To find the difference of a range of data;
14. Type equal sign, Select the function (i.e. PRODUCT) and
7. Open the worksheet containing data (as previously done in fig
state the range of cells.
4.2 above).
15. MS Excel will highlight the range specified.
8. Position the cell pointer on the desired cell i.e. the cell where
16. Press the Enter key.
the result should be displayed.
17. The result is displayed.
9. Type equal sign, Select the function (i.e. IMSUB) and state the
Also, the symbol (*) can be used.
range of cells, usually two cells.
10. MS Excel will highlight the range specified.
Division:
11. Press the Enter key.
To divide a range of values;
12. The result is displayed.
18. Position the cell pointer on the desired cell i.e. the cell
where the result should be displayed.
NOTE: Educators should kindly explain alternative methods
19. Type equal sign, Select the function (i.e. QUOTIENT to
using the Subtraction sign (-)
display the integer portion of a division) and state the range of
cells.
Average: It is also possible to use the spreadsheet package to find
20. MS Excel will highlight the range specified.
the average of certain values or group of numbers. To find average:
21. Press the Enter key.
1. Position the cell pointer in the desired cell where result is to
22. The result is displayed.
be displayed
Also, the symbol (/) can be used to display the exact result.
2. Type “=AVERAGE (DATA RANGE)”in the formula bar
3. Press the ENTER KEY
NOTE: Educators should please endeavour to expose the
4. The result is displayed in the cell
students to some other functions embedded in the worksheet
program.
Count:
The count function is used to ascertain the number of cells within a
Sub-topic 2:
specified range that contains values. To use the count function;
Printing of Worksheet
1. Position the cell pointer in the desired cell
After the spreadsheet have been formatted and properly calculated 4. The ______ function is used to ascertain the number of cells
the next thing is to get the worksheet printed. To print your within a specified range containing values.
worksheet, take the following steps: (a) MAXIMUM (b) COUNT (c) SORT (d) AVERAGE
1. Highlight the range to be printed
2. Click on the Office button and select Print
WEEK 6
3. Select the name of the printer from the Printer Name box
4. Enter the number of copies to print
TOPIC: GRAPH
5. Click on Preview button and select Page Set Up. Set all the
necessary parameters like margins, page layout, paper size
CONTENT: - Creating Graph
and grid lines (if necessary).
6. Click on OK
Sub-Topic 1: CREATING GRAPH
7. Click on Print.
GRAPH: A graph is a diagram showing the relationship that exist
EVALUATION
1. State THREE guidelines that must be followed when among variables, quantities (varies data), usually of two, each
performing excel calculations measured along one of a pair of axes at right angles. It may not be
2. Highlight the major steps required to carry out the following possible to plot a graph without value. The excel spreadsheet
calculations; provides the values that are plotted.
(a) Addition (b) Subtraction (c) Count (d) Average (e)
Division Creating graph
To create a graph, you can either use the chart wizard or press the
WEEKEND ASSIGNMENT F11 key
1. Which of the following signs can be used for multiplication in
MS Excel? Types of Chart
(a) + (b) X (c) & (d) * 1. Line graph
2. In Excel, the expression C4:F20 is usually referred to as 2. Histograms
a/an_______ 3. Pie-charts
(a) Function (b) Function Name (c) Argument (d) 4. Legends
Expression
3. In Excel, the function IMSUB is used for ________ 1. Line graph: Line graphs are often used to plot changes in
(a) Addition (b) Subtraction (c) Multiplication (d) data over time, such as monthly temperature changes or daily
Division changes in stock market prices. Line graphs have a vertical axis
and a horizontal axis. If you are plotting changes in data over
time, time is plotted along the horizontal or x-axis and your 3. PIE-CHART: Pie-charts, or circle graphs as they are
other data, such as rainfall amounts is plotted as individual sometimes known, are a little different from the other two
points along the vertical or y-axis types of graphs discussed.
For one, pie charts do not use horizontal and vertical axes to
plot points like the others. They also differ in that they are
used to chart only one variable at a time. As a result, it can
only be used to show percentages. The circle of pie charts
represents 100%. The circle is subdivided into slices
representing data values. The size of each slice shows what
part of the 100% it represents.
60 45 JSS1
JSS2
70 90 JSS3
2. Histograms: A histogram consists of tabular frequencies, 50
SSS1
SSS2
120
shown as adjacent rectangles, erected over discrete intervals SSS3
Subject English Maths Compute Technolog scienc After creating a chart, you can change it to the type you want. The
r y e type you choose depends on how you want to present your data.
Scores 60 80 85 75 55 1. Select the chart
2. Within the chart, click the right mouse button OR
3. Click on insert on menu bar
2. The table below gives the age of a group of pupils in a school
4. Click on change Chart type
Age (yr) 1 15 16 17 18
5. Under Chart Type, list click to select the desired chart type (e.g,
4
Column, Bar, Line, etc)
Number of 3 6 4 4 4
Under Chart sub-type list, click to select the chart sub-typed
pupils
desired. You can view the chart sample by pressing it and hold to
Draw a bar chart to show the information in the table
view sample button.
3. Represent the information in the table below on a line graph 6. Click on OK when satisfied
Subject English Maths Compute Basic Music
100
r Sci. 90
80
Time 120 130 130 100 130 70
60
allotted 50
40
30
20
10
WEEK 7 MID TERM HOLIDAY 0
MUSIC YORUBA ENGLISH FRENCH
45
MUSIC
90 45
YORUBA
ENGLISH MUSIC
90
FRENCH YORUBA
70
20 ENGLISH
FRENCH
70
20
Objective Test:
1. Which of the following is not a type of graph (a) Line graph (b)
Pie Chart (c) Histogram (d) Bigram
2. ……………………….. is a circle divided into sections (a) Bar Chart
(b) Histogram (c) Pictogram (d) Pie-chart
Essay Test:
1. Construct a bar chart for the data below
No. of 5 3 8 7 2 8 6 10 1 4
students Video game is an electronic or computerized game played by
Performance 10 20 30 40 50 60 70 80 90 100 manipulating images on a video display television screen.
s in Comp. Examples of computer game
studies Exam
Chess
Entertainment Games
These are types of games played to entertain friends and visitors
e.g Musical games, Mimicking and guessing
Evaluation
1. What is computer game
2. Name three input devices used to play computer games
Weekend Assignment
1. All the following are computer games except……… (a) Chess (b)
Trojan (c) Packman (d) Pinball
2. Computer games can be played using all the following except
…………. (a) Computer Keyboard (b) Mouse (c) Joystick (d)
Digger
3. Which of the following is not a reason for playing computer
game?
(a) For fraudulent purposes (b) For entertainment (c) For
educational purpose (d) For teaching purposes
4. ………….. is a computer software used for relaxation to learn
skill (a) Antivirus (b) Computer (c) Games (d) Game pad
Essay Questions
1. Mention two reasons for playing game
2. State four disadvantages of playing computer game.