CTAN Curriculum Training and Technical Committee

Computer Studies Scheme of Work

Third Term 2022/2023 Session
JSS Three
Wk Theme/Content
1. Revision of last term work and Welcome test
2. Worksheet
a. Worksheet
- Starting worksheet - Data entry
- Editing - Saving
- Retrieving worksheets - Formatting worksheet (text, cell and columns naming, etc)
b. Calculations:
- Addition - Average
- Counting - Multiplication
- Division, etc - Printing a worksheet
3. Worksheet Practical
a. Practical on simple calculations with spreadsheet
b. Practical of printing data from worksheet
4. Introduction to IT Essential: Hands on Skills
5. Graphs
a. Creating Graphs
- Line graphs - Histograms
- Pie-charts - Legends, etc
b. Editing and formatting graphs:
6. Practical
a. Practical on how to construct standard graphs and chart from given records in a worksheet,
edit and format the graphs and charts
7. Revision: Gateway past questions
8. Revision: Gateway past question
9. Examination and Marking

REFERENCE MATERIALS:
i. Welcome to Computer Studies for Junior Secondary School Book Three by Dele Kelani and
Boye Jokotoye
ii. Early Learning of Computer Studies for Junior Secondary School Book 3 by YomiSoyombo
iii. Computer Teachers’ Association of Nigeria e-note for Junior Secondary School 3
JSS Three
 CTAN Curriculum Training and Technical Committee
SUBJECT: Computer Studies
WEEK: One
DATE: Monday 26th – Friday 30th April, 2021
CLASS: JSS Three
TOPIC: Revision and Welcome Test
SUB-TOPICS: Welcome Test
Revision: Spreadsheet
INSTRUCTIONAL MATERIALS: Ms – Excel package
ENTRY BEHAVIOUR: Learners had been taught application package
BEHAVIOURAL OBJECTIVES: By the end of the lesson, learners should be able to:
i. Define the term Spreadsheet
ii. Mention three examples of Spreadsheet packages
iii. State uses of Spreadsheet
REFERENCE MATERIALS:
i. Welcome to Computer Studies for Junior Secondary School Book Two by Dele Kelani and
Boye Jokotoye Pages 101 - 109
ii. Early Learning of Computer Studies for Junior Secondary School Book 3 by Yomi Soyombo
iii. Computer Teachers’ Association of Nigeria e-note for Junior Secondary School 3
DURATION: 80 Minutes
PERIODS: 2
FIRST PERIOD: 40 Minutes
a. CONTENT
Spreadsheet Package
It is an application package that is used for mathematical, accounting and statistical problems.
It consists of rows and columns where data can be entered, manipulated then retrieved for
graphical illustrations or mathematical analysis. Also it can be defined as a matrix of rows and
columns used for mathematical and accounting calculations and numerical analysis
Examples
Lotus 1-2-3 Ms Excel SuperCalc GS Calc Easy Calc
VisiCalc Stat View Multi Plan Corel QuartroPro
Uses of Spreadsheet
Spreadsheet packages are used basically for the calculation and analysis of large data. These
includes but is not limited to
Statistical analysis
Mathematical purposes
JSS Three
CTAN Curriculum Training and Technical Committee
Regression analysis
Budget management and control
Preparation of daily sales report
Stock / Inventory control analysis
Preparation of examination results
Accounting purpose
Financial projection and analysis
Preparation of Payroll
a. PRESENTATION
- The learners describe the terms “spreadsheet” and “workbook”
- The learners give 4 common examples of spreadsheet package
- The learners mention3uses of spreadsheet software
- The teacher describes term “spreadsheet” and “workbook”
- The teacher describes more used of the spreadsheet package
b. EVALUATION: Why do we use spreadsheet packages?
c. ASSIGNMENT: Mention three types of data in a worksheet

SECOND PERIOD: 40 Minutes

a. Welcome Test
1. Define spreadsheet 3marks
2. Mention three examples of spreadsheet 3marks
3. List four application areas of spreadsheet 4marks
Wk Theme/Content
1. Revision of last term work and Welcome test
2. Worksheet
a. Worksheet
- Starting worksheet - Data entry
- Editing - Saving
- Retrieving worksheets - Formatting worksheet (text, cell and columns naming, etc)
b. Calculations:
- Addition - Average
- Counting - Multiplication
- Division, etc - Printing a worksheet
3. Worksheet Practical
a. Practical on simple calculations with spreadsheet
JSS Three
CTAN Curriculum Training and Technical Committee
c. Practical of printing data from worksheet
4. Introduction to IT Essential: Hands on Skills
5. Graphs
a. Creating Graphs
- Line graphs - Histograms
- Pie-charts - Legends, etc
b. Editing and formatting graphs:
6. Practical
a. Practical on how to construct standard graphs and chart from given records in a worksheet,
edit and format the graphs and charts
7. Revision: Gateway past questions
8. Revision: Gateway past question
Examination and Marking
b. REMARK: The CA will be conducted in compliance with School schedule
c. PRESENTATION
- The teacher writes the continuous assessment on the chalkboard
- The teacher writes the scheme for the term on the chalkboard
d. ASSIGNMENT
i. Describe the term “Worksheet”
ii. List three features of Spreadsheet

Prepared by: Mr. Emosu T. O.

Compiled and Edited by: CTAN Curriculum Training and Technical Committee

___________________________
H.O.D's Signature & Date

JSS Three
 CTAN Curriculum Training and Technical Committee
SUBJECT: Computer Studies
WEEK: Two
DATE: Monday 3rd – Friday 7th May, 2021
CLASS: JSS Three
TOPIC: WORKSHEET
SUB-TOPICS: Starting Worksheet, data entry, editing etc
INSTRUCTIONAL MATERIALS: Computer system and Microsoft Excel
ENTRY BEHAVIOUR: Learners are conversant with pre knowledge of spreadsheet package
BEHAVIOURAL OBJECTIVES: By the end of the lesson, learners should be able to:
i. Define Spreadsheet
ii. identify the spreadsheet environment
REFERENCE MATERIALS:
i. Welcome to Computer Studies for Junior Secondary School Book Two by Dele Kelani and
Boye Jokotoye Pages 101 - 109
ii. Early Learning of Computer Studies for Junior Secondary School Book 3 by Yomi Soyombo
iii. Computer Teachers’ Association of Nigeria e-note for Junior Secondary School 3
DURATION: 80 Minutes
PERIODS: 2
FIRST PERIOD: 40 Minutes
a. CONTENT
SPREADSHEET/WORKSHEET
A spreadsheet is an interactive computer application program for organization, analysis and
storage of data in tabular form.
A worksheet is used to store, manipulate, and display data.
An Excel worksheet is a single spreadsheet that contains cells organized by rows and columns.
A worksheet begins with row number one and column A. Each cell can contain a number, text or
formula.

Spreadsheets developed as computerized simulations of paper accounting worksheets. The

program operates on data represented as cells of an array, organized in rows and columns. Each
cell of the array is a model–view–controller element that may contain either numeric or text data,
or the results of formulas that automatically calculate and display a value based on the contents of
other cells.

JSS Three
CTAN Curriculum Training and Technical Committee

b. PRESENTATION
- The learners enumerates features in a spreadsheet
- The teacher explains the term worksheet
- The learners attempt to describe features of a worksheet
- The teacher corrects the features of a worksheet
- The learners attempt to create new worksheet
c. EVALUATION: How can we add or remove new sheet in a worksheet
d. ASSIGNMENT: What are the benefits of a spreadsheet?

SECOND PERIOD: 40 Minutes

a. CONTENT
STARTING A WORKSHEET
Worksheet are file that can be created in excel. You can start worksheet any time you want to
create a new file for your excel data. Steps are
1. Open a new workbook in Excel
2. Point on Start button on the screen
3. Click on all programs
4. Point to Microsoft office
5. Select Microsoft excel (this will take you to the excel environment)
Every single time you Start Excel you are, by default, creating a New Blank Workbook. The
name of your Workbook has the default name of Book1, until you save the Workbook as a
different name. A Workbook is like the outer shell of the spreadsheet and contained within it are
the Worksheet(s) and cells. When you Start Excel you should first see a blue bar at the very top
of your screen. This is called the Title Bar. The title bar is where you will see the name of your
Workbook once you have saved it. (Note that if you have not yet saved a Workbook, the default
will probably be Book1). As you are familiar with Windows, you will notice to the right of the
JSS Three
CTAN Curriculum Training and Technical Committee
Title Bar the Minimize (hyphen), Restore (two squares) and Close (X) buttons

b. PRESENTATION
- The learners enumerate stages involved in starting a worksheet
- The learners enumerates some of the features of a worksheet
- The learners attempt to enumerates some features of a worksheet
- The teacher explains some of the terminologies
- The teacher copy note and marks
c. EVALUATION:
1. What is Spreadsheet?
2. How can you start a worksheet?

d. ASSIGNMENT: Explain formula in worksheet

Prepared by: Mr. Emosu T. O.

Compiled and Edited by: CTAN Curriculum Training and Technical Committee

___________________________
H.O.D's Signature & Date

JSS Three
 CTAN Curriculum Training and Technical Committee
SUBJECT: Computer Studies
WEEK: Three
DATE: Monday 10th – Friday 14th May, 2021
CLASS: JSS Three
TOPIC: WORKSHEET – HANDS ON SKILL
SUB-TOPICS: Practical’s
INSTRUCTIONAL MATERIALS: Computer system, Ms - Excel
ENTRY BEHAVIOUR: Learners are conversant with pre knowledge of spreadsheet package
BEHAVIOURAL OBJECTIVES: By the end of the lesson, learners should be able to
i. Boot the system and open MS Excel
ii. Move the mouse around to their desired destination for data entering.
REFERENCE MATERIALS:
i. Welcome to Computer Studies for Junior Secondary School Book Two by Dele Kelani and
Boye Jokotoye Pages 101 - 109
ii. Early Learning of Computer Studies for Junior Secondary School Book 3 by Yomi Soyombo
iii. Computer Teachers’ Association of Nigeria e-note for Junior Secondary School 3
DURATION: 80 Minutes
PERIODS: 2
FIRST PERIOD: 40 Minutes
a. CONTENT
CALCULATIONS IN WORKSHEET
One quick and easy way to add values in Excel is to
use AutoSum. Just select an empty cell directly
below a column of data. Then on the Formula tab,
click AutoSum > Sum. Excel will automatically
sense the range to be summed. (AutoSum can also
work horizontally if you select an empty cell to the
right of the cells to be summed.)
AutoSum creates the formula for you, so that you
don't have to do the typing.
Calculate the average of numbers in a contiguous row or column
1. Click a cell below or to the right of the numbers for which you want to find the average.
2. On the Home tab, in the Editing group, click the arrow next to AutoSum , click Average,
and then press ENTER.
ADDITION
Adding and subtracting in Excel is easy; you just have to create a simple formula to do it. Just
remember that all formulas in Excel begin with an equal sign (=), and you can use the formula bar
to create them.

Add two or more numbers in one cell

1. Click any blank cell, and then type an equal sign (=) to start a formula.
2. After the equal sign, type a few numbers separated by a plus sign (+).
For example, 50+10+5+3.
3. Press RETURN .
If you use the example numbers, the result is 68.
JSS Three
CTAN Curriculum Training and Technical Committee
Add numbers using cell references
A cell reference combines the column letter and row number, such as A1 or F345. When you use
cell references in a formula instead of the cell value, you can change the value without having to
change the formula.
1. Type a number, such as 5, in cell C1. Then type another number, such as 3, in D1.
2. In cell E1, type an equal sign (=) to start the formula.
3. After the equal sign, type C1+D1.
4. Press RETURN .

If you use the example numbers, the result is 8

Get a quick total from a row or column
1. Type a few numbers in a column, or in a row, and then select the range of cells that you
just filled.
2. On the status bar, look at the value next to Sum. The total is 86.

SUBRACTIONS
Subtract two or more numbers in a cell
1. Click any blank cell, and then type an equal sign (=) to start a formula.
2. After the equal sign, type a few numbers that are separated by a minus sign (-).
For example, 50-10-5-3.
3. Press RETURN .
If you use the example numbers, the result is 32.
Subtract numbers using cell references
A cell reference combines the column letter and row number, such as A1 or F345. When you use
cell references in a formula instead of the cell value, you can change the value without having to
change the formula.
1. Type a number in cells C1 and D1.
For example, a 5 and a 3.
2. In cell E1, type an equal sign (=) to start the formula.
3. After the equal sign, type C1-D1.

4. Press RETURN .
If you used the example numbers, the result is 2.
b. PRESENTATION
- The learners attempt to describe data entry with some available data around the class
JSS Three
CTAN Curriculum Training and Technical Committee
- The teacher explains the reason for data entry
- The learners enumerate purpose of data entry
- The teacher enumerates operations in a worksheet
- The teacher enumerates procedure for each operations
c. EVALUATION: Perform simple mathematical operation
d. ASSIGNMENT: Highlight stages used to simple mathematical operation
SECOND PERIOD: 40 Minutes
a. CONTENT
MULTIPLICATION
Suppose you want to multiply a column of numbers by the same number in another cell. The trick
to multiplying a column of numbers by one number is adding $ symbols to that number's cell
address in the formula before copying the formula.
In our example table below, we want to multiply all the numbers in column A by the number 3 in
cell C2. The formula =A2*C2 will get the correct result (4500) in cell B2. But copying the
formula down column B won’t work, because the cell reference C2 changes to C3, C4, and so on.
Because there’s no data in those cells, the result in cells B3 through B6 will all be zero.

To multiply all the numbers in column A by cell C2, add $ symbols to the cell reference like
this: $C$2, which you can see in the example below.

Using $ symbols tells Excel that the reference to C2 is “absolute,” so when you copy the formula
to another cell, the reference will always be to cell C2. To create the formula:
1. In cell B2, type an equal (=) sign.
2. Click cell A2 to enter the cell in the formula.
3. Enter an asterisk (*).
4. Click cell C2 to enter the cell in the formula.
5. Now type a $ symbol in front of C, and a $ symbol in front of 2: $C$2.
6. Press Enter.
Tip: Instead of typing the $ symbol, you can place the insertion point either before or after the
cell reference that you want to make “absolute,” and press the F4 key, which adds the $ symbols.
Now we’ll step back a bit to see an easy way to copy the formula down the column after you
press Enter in cell B2.
1. Select cell B2.
2. Double-click the small green square in the lower-right corner of the cell.
The formula automatically copies down through cell B6.

JSS Three
CTAN Curriculum Training and Technical Committee

And with the formula copied, column B returns the correct answers.

How to divide a cell in Excel

To divide two cells in Excel, you use the divide symbol exactly like shown in the above
examples, but supply cell references instead of numbers.
For example:
 To divide cell A2 by 5: =A2/5
 To divide cell A2 by cell B2: =A2/B2
 To divide multiple cells successively, type cell references separated by the division
symbol. For example, to divide the number in A2 by the number in B2, and then divide the result
by the number in C2, use this formula: =A2/B2/C2

b. PRESENTATION
- The learners attempt to describe data entry with some available data around the class
- The teacher explains the reason for data entry
- The learners enumerate purpose of data entry
- The teacher enumerates operations in a worksheet
- The teacher enumerates procedure for each operations
c. EVALUATION: Perform simple mathematical operation
d. ASSIGNMENT: Highlight stages used to simple mathematical operation

Prepared by: Mr. Emosu T. O.

Compiled and Edited by: CTAN Curriculum Training and Technical Committee

___________________________
H.O.D's Signature & Date

JSS Three
 CTAN Curriculum Training and Technical Committee

SUBJECT: Computer Studies

WEEK: Four
DATE: Monday 17th – Friday 21st May, 2021
CLASS: JSS Three
TOPIC: Introduction to IT Essential

SUB-TOPICS: Hands on Skills: Practical on Calculations and printing worksheet

INSTRUCTIONAL MATERIALS: Computer system, Ms - Excel
ENTRY BEHAVIOUR: Learners are conversant with pre knowledge of spreadsheet package
BEHAVIOURAL OBJECTIVES: By the end of the lesson, learners should be able to
i. Boot the system and open MS Excel
ii. Move the mouse around to their desired destination for data entering.
REFERENCE MATERIALS:
i. Welcome to Computer Studies for Junior Secondary School Book Two by Dele Kelani and
Boye Jokotoye Pages 101 - 109
ii. Early Learning of Computer Studies for Junior Secondary School Book 3 by Yomi Soyombo
iii. Computer Teachers’ Association of Nigeria e-note for Junior Secondary School 3
DURATION: 80 Minutes
PERIODS: 2
FIRST PERIOD: 40 Minutes
a. CONTENT
PRACTICAL ON CALCULATIONS
ADDITION
1. Open a new workbook
2. Type a few numbers in a column, or in a row, and then select the range of cells that you
just filled.
3. On the status bar, look at the value next to Sum. The total is 86.

SUBRACTIONS
Subtract two or more numbers in a cell
4. Click any blank cell, and then type an equal sign (=) to start a formula.
JSS Three
CTAN Curriculum Training and Technical Committee
5. After the equal sign, type a few numbers that are separated by a minus sign (-).
For example, 50-10-5-3.
6. Press RETURN .
How to divide a cell in Excel
To divide two cells in Excel, you use the divide symbol exactly like shown in the above
examples, but supply cell references instead of numbers.
For example:
 To divide cell A2 by 5: =A2/5
 To divide cell A2 by cell B2: =A2/B2
 To divide multiple cells successively, type cell references separated by the division
symbol. For example, to divide the number in A2 by the number in B2, and then divide the result
by the number in C2, use this formula: =A2/B2/C2

b. PRESENTATION
- The learners attempt to describe data entry with some available data around the class
- The teacher explains the reason for data entry
- The learners enumerate purpose of data entry
- The teacher enumerates operations in a worksheet
- The teacher enumerates procedure for each operations
c. EVALUATION: Perform simple mathematical operation
d. ASSIGNMENT: Highlight stages used to simple mathematical operation

Prepared by: Mr. Emosu T. O.

Compiled and Edited by: CTAN Curriculum Training and Technical Committee

___________________________
H.O.D's Signature & Date

JSS Three
 CTAN Curriculum Training and Technical Committee
SUBJECT: Computer Studies
WEEK: Five
DATE: Monday 24th – Friday 28th May, 2021
CLASS: JSS Three
TOPIC: WORKSHEET - GRAPH
SUB-TOPICS: Creating Graphs, editing and formatting Graphs in worksheet
INSTRUCTIONAL MATERIALS: Computer system, Ms - Excel
ENTRY BEHAVIOUR: Learners are conversant with pre knowledge of worksheet operations
BEHAVIOURAL OBJECTIVES: By the end of the lesson, learners should be able to
i. Define graphs
ii. Creating, editing and formatting graphs
REFERENCE MATERIALS:
i. Welcome to Computer Studies for Junior Secondary School Book Two by Dele Kelani and Boye
Jokotoye Pages 101 - 109
ii. Early Learning of Computer Studies for Junior Secondary School Book 3 by Yomi Soyombo
iii. Computer Teachers’ Association of Nigeria e-note for Junior Secondary School 3
DURATION: 80 Minutes
PERIODS: 2
FIRST PERIOD: 40 Minutes
a. CONTENT
CREATING GRAPHS
To insert a chart:
1. Select the cells you want to chart,
including the column titles and row labels.
These cells will be the source data for the
chart. ...
2. From the Insert tab, click the desired
Chart command. ...
3. Choose the desired chart type from the
drop-down menu. ...
4. The selected chart will be inserted in the
worksheet.

EDITING GRAPH
1. Click the chart for which you want to
change the cell range of the source data.
This displays the Chart Tools, adding the Design, Layout,
and Format tabs.
2. On the Design tab, in the Data group, click Select Data.
3. In the Select Data Source dialog box, note the location of the data
range, and then click OK.
4. Go to the location of the data range, and click any cell in the data
range.
5. On the Insert tab, in the Tables group, click Table.
Keyboard shortcut : Press CTRL+L or CTRL+T.
EDITING LEGENDS
1. On the worksheet, click the cell that contains the name of the data series that
appears as an entry in the chart legend.
JSS Three
CTAN Curriculum Training and Technical Committee
2. Type the new name, and then press ENTER.
The new name automatically appears in the legend on the chart.
PRESENTATION
- The learners are guided by teacher to create graph from data analyzed
- The learners insert and edit graphs
- The teacher guide learners to edit using legend
EVALUATION: Create and edit graphs
ASSIGNMENT: List and explain types of graphs
SECOND PERIOD: 40 Minutes
CONTENT
FORMATTING GRAPHS
1. In your chart, click to select the chart element that you want to format.
2. On the Format tab under Chart Tools, do one of the following:
Click Shape Fill to apply a different fill color, or a gradient, picture, or texture to
the chart element.
Click Shape Outline to change the color, weight, or style of the chart element.
Click Shape Effects to apply special visual effects to the chart element,
such as shadows, bevels, or 3-D rotation.
To apply a predefined shape style, on the Format tab, in the Shape
Styles group, click the style that you want. To see all available shape
styles, click the More button .

o To change the format of chart text, select the text, and then choose an option on the mini toolbar
that appears. Or, on the Home tab, in the Font group, select the formatting
that you want to use.
o To use WordArt styles to format text, select the text, and then on
the Format tab in the WordArt Styles group, choose a WordArt style to
apply. To see all available styles, click the More button .
CHART TYPES
1. Column
2. Bar
3. Line graph
4. Pie
5. Scatter
6. Area
7. Doughnut
PRESENTATION
- The learners are guided by teacher to create graph from data analyzed
- The learners insert and edit graphs
- The teacher guide learners to edit using legend
EVALUATION: Create and edit graphs
ASSIGNMENT: List and explain types of graphs
Prepared by: Mr. Emosu T. O.
Compiled and Edited by: CTAN Curriculum Training and Technical Committee

___________________________
H.O.D's Signature & Date
JSS Three
 CTAN Curriculum Training and Technical Committee
SUBJECT: Computer Studies
WEEK: Six
DATE: Monday 31st May – Friday 4th June, 2021
CLASS: JSS Three
TOPIC: WORKSHEET Practical – Hands on
SUB-TOPICS: Printing worksheet
INSTRUCTIONAL MATERIALS: Computer system, Ms - Excel
ENTRY BEHAVIOUR: Learners are conversant with pre knowledge of worksheet operations
BEHAVIOURAL OBJECTIVES: By the end of the lesson, learners should be able to
i. Define graphs
ii. Creating, editing and formatting graphs
REFERENCE MATERIALS:
i. Welcome to Computer Studies for Junior Secondary School Book Two by Dele Kelani and
Boye Jokotoye Pages 101 - 109
ii. Early Learning of Computer Studies for Junior Secondary School Book 3 by Yomi Soyombo
iii. Computer Teachers’ Association of Nigeria e-note for Junior Secondary School 3
DURATION: 80 Minutes
PERIODS: 2
FIRST PERIOD: 40 Minutes
a. CONTENT
PRINTING A WORKSHEET
Print a worksheet or workbook
You can print entire or partial worksheets and workbooks, one at a time, or several at once. And if
the data that you want to print is in a Microsoft Excel table, you can print just the Excel table.
You can also print a workbook to a file instead of to a printer. This is useful when you need to
print the workbook on a different type of printer from the one that you originally used to print it.
Print one or several worksheets
1. Select the worksheets that you want to print.
2. Click File, and then click Print, press Ctrl + P.
3. Click the Print button or adjust Settings before you click
the Print button.
Print one or several workbooks
All workbook files that you want to print must be in the same
folder.
1. Click File, and then click Open.
2. Hold down Ctrl and then click the name of each workbook
that you want to print, and then click Print.
Print all or part of a worksheet
1. Click the worksheet, and then select the range of data that
you want to print.
2. Click File, and then click Print.

JSS Three
CTAN Curriculum Training and Technical Committee
3. Under Settings, click the arrow next to Print Active Sheets and select the appropriate
option.
4. Click Print.
PRESENTATION
- The learners are guided by teacher to create graph from data analyzed
- The learners differentiate between soft and hard copy
- The teacher guide learners to print output of the information
EVALUATION: Print the entire worksheet
ASSIGNMENT: State advance use of spreadsheet

SECOND PERIOD: 40 Minutes

CONTENT
1. Examples of spreadsheet programs
 Google Sheets - (Online and free)
 Work Numbers - Apple Office Suite.
 Libre Office -> Calc (Free)
 Lotus 1-2-3 (Discontinued)
 Lotus Symphony - Spreadsheets.
 Microsoft Excel.
 Open Office -> Calc (Free)
 VisiCalc (Discontinued)

2. Uses of spreadsheet packages

 Create budgets
 Produce graphs and charts
 For storing and sorting data
 Forecast future performance
 Calculate tax
 Completing basic payroll
 Calculating revenues
 Preparation of daily sales
 Examination results
PRESENTATION
- The learners are guided by teacher to create graph from data analyzed
- The learners differentiate between soft and hard copy
- The teacher guide learners to print output of the information
EVALUATION: Print the entire worksheet
ASSIGNMENT: Solve theory of 2020 gateway past questions.

Prepared by: Mr. Emosu T. O.

Compiled and Edited by: CTAN Curriculum Training and Technical Committee
___________________________
H.O.D's Signature & Date

JSS Three
 CTAN Curriculum Training and Technical Committee
SUBJECT: Computer Studies
WEEK: Seven
DATE: Monday 7th – Wednesday 9th June, 2021
CLASS: JSS Three
TOPIC: Continuous Assessment and Midterm Break
INSTRUCTIONAL MATERIALS: Computer system, Ms Excel
ENTRY BEHAVIOUR: learners had been taught
i. The definition of worksheet
ii. The basic worksheet operations
BEHAVIOURAL OBJECTIVES: By the end of the lesson, learners should be able to
i. Launch the Ms Excel application
ii. Identify the features displayed on the screen
iii. Create a simple database file
REFERENCE MATERIALS:
i. Welcome to Computer Studies for Junior Secondary School Book Two by Dele Kelani and
Boye Jokotoye Pages 101 - 109
ii. Early Learning of Computer Studies for Junior Secondary School Book 3 by Yomi Soyombo
iii. Computer Teachers’ Association of Nigeria e-note for Junior Secondary School 3
DURATION: 80 Minutes
PERIODS: 2
FIRST PERIOD: 40 Minutes
a. CONTENT – Midterm Test
1. Mention four forms of Databases 1 x 1marks = 4marks
2. What is Spreadsheet Package 2 x 1marks = 2marks
3. Mention four features of Spreadsheet Packages 4 x 1marks = 4marks
4. State two reasons why digital divide exist 2 x 1marks = 2marks
b. ASSIGNMENT: i. Prepare classroom raw information?
ii. Enter data in a worksheet, perform simple calculation and print out your result?

c. REMARK: The students will go on Midterm Break

Prepared by: Mr. Emosu T. O.

Compiled and Edited by: CTAN Curriculum Training and Technical Committee
___________________________
H.O.D's Signature & Date
JSS Three
 CTAN Curriculum Training and Technical Committee
SUBJECT: Computer Studies
WEEK: Eight
DATE: 8th - 12th February, 2021
CLASS: JSS Three
TOPIC: Spreadsheet Packages
SUB_TOPICS: Definition and Examples
Uses of spreadsheet packages
INSTRUCTIONAL MATERIALS: Marks book, attendance register
ENTRY BEHAVIOUR: Learners are conversant with the use of databases
BEHAVIOURAL OBJECTIVES: By the end of the lesson, learners should be able to
i. Define the terms spreadsheet, workbook, raw data, work area
ii. Mention three features of spreadsheet package
iii. Mention three examples of spreadsheet package
REFERENCE MATERIALS:
i. Welcome to Computer Studies for Junior Secondary School Book Two by Dele Kelani and
Boye Jokotoye Pages 101 - 109
ii. Early Learning of Computer Studies for Junior Secondary School Book 3 by Yomi Soyombo
iii. Computer Teachers’ Association of Nigeria e-note for Junior Secondary School 3
FIRST PERIOD: 40 Minutes
a. CONTENT
Spreadsheet Package
It is an application package that is used for mathematical, accounting and statistical problems.
It consists of rows and columns where data can be entered, manipulated then retrieved for
graphical illustrations or mathematical analysis. Also it can be defined as a matrix of rows and
columns used for mathematical and accounting calculations and numerical analysis
Examples
Lotus 1-2-3 Ms Excel SuperCalc GS Calc Easy Calc
VisiCalc Stat View Multi Plan Corel QuartroPro
Uses of Spreadsheet
Spreadsheet packages are used basically for the calculation and analysis of large data. These
includes but is not limited to
Statistical analysis
Mathematical purposes
Regression analysis
Budget management and control
JSS Three
CTAN Curriculum Training and Technical Committee
Preparation of daily sales report
Stock / Inventory control analysis
Preparation of examination results
Accounting purpose
Financial projection and analysis
Preparation of Payroll
b. PRESENTATION
- The learners describe the terms “spreadsheet” and “workbook”
- The learners give 4 common examples of spreadsheet package
- The learners mention3uses of spreadsheet software
- The teacher describes term “spreadsheet” and “workbook”
- The teacher describes more used of the spreadsheet package
d. EVALUATION: Why do we use spreadsheet packages?
e. ASSIGNMENT: Mention three types of data in a worksheet

SECOND PERIOD: 40 Minutes

a. CONTENT
Features of Spreadsheet
i. Name-box
ii. Formula bar
iii. Work Area
iv. Sheet tab
Name Box: It displays the cell address/reference of the active cell. It can also be used to
assign name to cells or range of cells
Formula bar: It displays the data or formula stores in the active cell. It can also be used to
enter or edit formula, label or data into a cell. It is located next to the name-box, both are
above the work area or worksheet.
Work Area: It is the worksheet which comprises cells where data can be entered and
manipulated
Sheet tabs: This is the worksheet name tag located at the bottom of the work area. It can be
used to label, rename, delete or relocate a worksheet from a workbook
Row: A Row is a horizontal line of cells which runs from left to right in a worksheet. They
can be identified by the numbers at the left hand side of the sheet numbered from 1 to
1,048,576

JSS Three
CTAN Curriculum Training and Technical Committee
Column: A Column is a vertical line of cells in a worksheet usually identified by letters across
the top of the sheet. There are about 16,384 columns in Excel 2007.
Cell: A Cell is the intersection of a row and a column. The highlighted rectangle on the cell is
the cursor but is known as ‘cell pointer’ which enable users to move around the sheet. They
can be identified by the combination of column header (e.g ‘A’) and the row header (e.g ‘1’)
to give cell
Active Cell: The active cell is the cell that contains the cell pointer, while the active worksheet
is the worksheet where the cell pointer is currently located.
Worksheet: The worksheet (synonymous to page) is the working area of the package where
entering of data and calculations are handled. It consists of rows, columns, cells and a cell
pointer where data are actually entered and manipulated.
Workbook: It is the collection of worksheets. Each workbook contains many work sheets just
like a normal single book with a number of pages
Types of Data/Cell Entries
Three types of items can be entered into a cell
i. Label
ii. Raw data
iii. Formula
Label: It is a general name for a range of cell in a worksheet e.g. Name, Gender, Description
etc.
Raw Data: It is an actual value or alphabetic value for an item e.g Adeola, Female, 1070
Formula: It is a value obtained by the use of specific formula. It is started with “=”
b. PRESENTATION
- The learners mention three uses of spreadsheet package in the school
- The learners mention two features of spreadsheet package
- The teacher enumerates and explains some of the features
- The teacher demonstrates how to locate active cell or know cell address
- The teacher enumerates and explains types of cell/data entries
c. EVALUATION: Identify the address of highlighted cells on the chalkboard
d. ASSIGNMENT: How can you name a worksheet or column or row?
Prepared by: Mr. Emosu T. O.
Compiled and Edited by: CTAN Curriculum Training and Technical Committee

___________________________
H.O.D's Signature & Date
JSS Three
 CTAN Curriculum Training and Technical Committee
SUBJECT: Computer Studies
WEEK: Nine
DATE: 15th – 19th March, 2021
TOPIC: Spreadsheet Package
SUB-TOPICS: Starting a Worksheet, Data Entry, Editing, Saving, Retrieving
Formatting worksheet (text, cell and column naming)
INSTRUCTIONAL MATERIALS: Report sheet
ENTRY BEHAVIOUR: Learners are conversant with rows, columns and cells
BEHAVIOURAL OBJECTIVES: By the end of the lesson, learners should be able to:
i. Launch or open a spreadsheet package
ii. Enter data into the cells
iii. Retrieve and edit content of existing workbook
REFERENCE MATERIALS:
i. Welcome to Computer Studies for Junior Secondary School Book Two by Dele Kelani and
Boye Jokotoye Pages 101 - 109
ii. Early Learning of Computer Studies for Junior Secondary School Book 3 by Yomi Soyombo
iii. Computer Teachers’ Association of Nigeria e-note for Junior Secondary School 3
DURATION: 80 Minutes
PERIODS: 2
FIRST PERIOD: 40 Minutes
a. CONTENT
Open/Launch Software
Click on the window or Start button
Search for MS Office or Click on All Programs
Select and Click on MS Excel
Identification of displayed features

JSS Three
CTAN Curriculum Training and Technical Committee
Entering Data in a Worksheet
The place where the cursor is, is called the active cell
To enter data in a cell, the cell pointer is placed in that cell and click to make it the active
cell. Data is entered directly in the cell by typing the data through the keyboard.
To cancel the entry, press Esc key.
To accept the entry, just press the Enter key or the Tab key or any of the cursor keys
Saving the Worksheet
Click the Office button or File.
Click on Save as and locate Excel Workbook in the given option.
Enter the filename in the dialog box and click the Save button.
Retrieving a saved worksheet
Click the Office or File button.
Click Open
Locate the filename in the open dialog box and click on it.
Click Open
b. PRESENTATION
- The learners mention three types of data that can be entered into the cell
- The learners enumerate steps in opening a software
- The teacher demonstrates how to open/launch a software
- The learners identify the displayed features
- The learners enter data into the worksheet
c. EVALUATION: Enter the following data into the worksheet
Names English Maths Computer
Roseline Solomon 80 80 89
AdeboyeAdedotun 88 85 64
Moronkola Ismail 89 88 90
AzeezAzeezat 80 75 88
OgunbanwoMutiat 76 79 70

Edit Roseline’s English score to 85

Save the worksheet in My Document with your name
Exit Excel environment
Retrieve your saved worksheet

d. ASSIGNMENT: How can you calculate the average of a group of scores?

JSS Three
CTAN Curriculum Training and Technical Committee
SECOND PERIOD: 40 Minutes
a. CONTENT
Formatting Cell
Merge Cells
A group of two or more cells can be joined together to hold title on a worksheet
iii. Highlight the group of cells
iv. Click on Home (2007 version and above) or Format (2003 version)
v. Click on Merge & Center in Alignment section
Column Width
The width of a cell can be reduced or increase
i. Place the cursor at the end of the column (which is the beginning of the next column)
ii. Hold down the mouse and drag outward to expand or drag inward to reduce OR
iii. Click on Home
iv. Click on Format on the Cell section
v. Click on Column Width
vi. Enter a number into the dialog box and Click OK
Renaming a Worksheet
The default name of the worksheet is Sheet1 or Sheet2 etc., this can be change to reflect the
actual content of the worksheet
i. Right Click on the Sheet tab at the bottom of the worksheet
ii. Click on Rename
iii. Type in a short descriptive name in the dialog box
iv. Press enter key to confirm
Calculations
There are preloaded formulas which user can quickly use on data. Formula is an expression
that carries our calculation using data available in specified cells
Summation– This will add the numeric data in a specified range of cell
i. Highlight the group of data to be added
ii. Click on Home
iii. Click on AutoSum on the Editing section
iv. Click on Sum
v. Check that the selected range is correct and press Enter key
Other common formulas are: average, min, max, count, rank etc

JSS Three
CTAN Curriculum Training and Technical Committee
Names English Maths Computer Total
Roseline Solomon 80 80 89 249
AdeboyeAdedotun 88 85 64 237
Moronkola Ismail 89 88 90 267
AzeezAzeezat 80 75 88 243
OgunbanwoMutiat 76 79 70 225

b. PRESENTATION
- The learners attempt to retrieve their documents
- The teacher demonstrates with learners how to use enlarge or shrink a cell
- The teacher demonstrates with learners how to rename a worksheet using the sheet tab
- The teacher demonstrates with learners how to merge cells and enter job titles
- The learners practice the demonstrations

e. EVALUATION: Enlarge column C to accommodate names and format text

f. ASSIGNMENT: How can you sort the names or assign position to a group of data

Prepared by: Mr. Emosu T. O.

Compiled and Edited by: CTAN Curriculum Training and Technical Committee

___________________________
H.O.D's Signature & Date

JSS Three
 CTAN Curriculum Training and Technical Committee
SUBJECT: Computer Studies
WEEK: Ten
DATE: 22nd – 26thMarch, 2021
CLASS: JSS Three
TOPIC: Practical
SUB-TOPICS: How to launch a Spreadsheet package
How to Open an existing Workbook
Input, store and retrieve information from a spreadsheet workbook
INSTRUCTIONAL MATERIALS: Report sheet
ENTRY BEHAVIOUR: Learners are conversant with rows, columns and cells
BEHAVIOURAL OBJECTIVES: By the end of the lesson, learners should be able to
i. Retrieve an existing workbook
ii. Use preloaded formula
iii. Sort data
REFERENCE MATERIALS:
i. Welcome to Computer Studies for Junior Secondary School Book Two by Dele Kelani and
Boye Jokotoye Pages 101 - 109
ii. Early Learning of Computer Studies for Junior Secondary School Book 3 by Yomi Soyombo
iii. Computer Teachers’ Association of Nigeria e-note for Junior Secondary School 3
PERIODS: 2
DURATION: 80 Minutes
FIRST PERIOD: 40 Minutes
a. CONTENT
Calculations
There are preloaded formulas which user can quickly use on data. Formula is an expression that
carries our calculation using data available in specified cells
Summation– This will add the numeric data in a specified range of cell
i. Highlight the group of data to be added
ii. Click on Home
iii. Click on AutoSum on the Editing section
iv. Click on Sum
v. Check that the selected range is correct and press Enter key
Average – This will generate the mean of the numeric data in a specified range of cell
i. Highlight the group of data to be used
ii. Click on Home
JSS Three
CTAN Curriculum Training and Technical Committee
iii. Click on AutoSum on the Editing section
iv. Click on Average
v. Check that the selected range is correct and press Enter key
AutoFill – The formula used in a previous cell can copied to subsequent cells by using the
autofill feature
i. Highlight the cell with the formula
ii. Click on the notch of the active cell and drag down to fill subsequent cells
Auto-Numbering

i. Enter the first two numbers in two consecutive cells

ii. Highlight the two cells
iii. Click on the notch of the highlighted cells and drag down to fill subsequent cells

Names English Maths Computer Total Ave

Awobade Oluwanifemi 80 80 89 249 83
Hassan Daniel 88 85 64 237 79
Olatunji Olamide 89 88 90 267 89
Joseph Susan 80 75 88 243 81
Sodamola Dorcas 76 79 70 225 75

b. PRESENTATION
- The learners attempt to retrieve their documents
- The teacher demonstrates how to use preloaded formula for total and average
- The teacher demonstrates how to use the auto fill feature
- The teacher demonstrates how to generate numbers automatically using the auto fill
feature
- The learners practice the demonstrations

c. EVALUATION: Calculate the total and average for the data above?

d. ASSIGNMENT: Enumerate the steps to be taking in printing your worksheet

SECOND PERIOD: 40 Minutes

JSS Three
CTAN Curriculum Training and Technical Committee
a. CONTENT
Names English Maths Computer Total Ave
AwobadeOluwanifemi 80 80 89 249 83
Hassan Daniel 88 85 64 237 79
OlatunjiOlamide 89 88 90 267 89
Joseph Susan 80 75 88 243 81
SodamolaDorcas 76 79 70 225 75

Sorting – This will arrange a group of data in a specified order

Order: The order could be on values or text, ascending or descending
i. Highlight the group of data to be added
ii. Click on Home
iii. Click on Sort & Filter on the Editing section
iv. Click on Sort A to Z or Sort Z to A
This applies to alphabetical arrangement
We can use Custom Sort if we wish to specify more criteria for sorting the data

Printing – This will generate a copy of our worksheet on paper using the printer. It is
important specify the paper and pages to be printed
Paper
i. Click on Page Layout
ii. Click on Size in Page Setup section
iii. Select appropriate paper size
iv. Click on Orientation in Page Setup section
v. Select appropriate orientation
To Print
i. Click on File or Window button
ii. Click on Print
iii. Select the attached printer
iv. Specify the page
v. Specify the number of copies
vi. Click on Print

The Gridlines
The line of the row and column will not be printed except it is specified
JSS Three
CTAN Curriculum Training and Technical Committee
i. Select the desired work area
ii. Select Border in Font Section
iii. Select All Border
This will thicken the gridlines and make it to appear when printed

b. PRESENTATION
- The learners retrieve their documents
- The teacher demonstrates how to use sort function
- The teacher demonstrates how to setup the page for printing
- The teacher demonstrates how to put border and print
- The learners practice the demonstrations
c. EVALUATION: Apply the border, sort the data and print the worksheet
d. ASSIGNMENT: What is graph in spreadsheet?

Prepared by: Mrs. K. O. Adelase - Lawal

Compiled and Edited by: CTAN Curriculum Training and Technical Committee

___________________________
H.O.D's Signature & Date

JSS Three
CTAN Curriculum Training and Technical Committee

SUBJECT: Computer Studies

WEEK: Eleven
DATE: 29thMarch – 2nd April, 2021
CLASS: JSS Three
TOPIC: Examination
REMARK: Administration of the First term examination

Prepared by: Mrs. K. O. Adelase - Lawal

Compiled and Edited by: CTAN Curriculum Training and Technical Committee

___________________________
H.O.D's Signature & Date

SUBJECT: Computer Studies

WEEK: Twelve
DATE: 5th– 9th April, 2021
CLASS: JSS Three
TOPIC: Examination
SUB-TOPICS: Marking and Collation of Results
REMARK: Marking of scripts and collation of examination results

Prepared by: Mrs. K. O. Lawal - Adelase

Compiled and Edited by: CTAN Curriculum Training and Technical Committee

___________________________
JSS Three
CTAN Curriculum Training and Technical Committee
H.O.D's Signature & Date

SUBJECT: Computer Studies

WEEK: Thirteen
DATE: 12th – 16th April, 2021
CLASS: JSS Three
TOPIC: Examination
SUB-TOPICS: Marking and Collation of Results
REMARK: Marking of scripts and collation of examination results

Prepared by: Mrs. K. O. Adelase - Lawal

Compiled and Edited by: CTAN Curriculum Training and Technical Committee

___________________________
H.O.D's Signature & Date

JSS Three