Class: JSS 2

Week: 1
Date: Tuesday 2nd May, 2023
Subject: Computer Studies
Duration: 80 minutes
Topic: ICT AS A TRANSFORMATIONAL TOOL
Subtopic: Meaning of ICT

BEHAVIORAL OBJECTIVES: At the end of the lesson, the learners should be able to:
 Explain the meaning of ICT
 State the major components of ICT
REFERENCE MATERIALS: HCITECH COMPUTER STUDIES FOR JSS 2 TEXTBOOK

INSTRUCTIONAL MATERIAL: Computer System

ENTRY BEHAVIOR: The learners are familiar with the computer system.

CONTENT:
MEANING OF ICT
ICT is an acronym that stands for Information and Communication Technology. Information: Information is
refers to knowledge obtained from reading, investigating, study and research.
Communication: Communication is an act of transmitting messages.
Technology: Technology is the application of scientific knowledge for practical purpose especially in industry.
ICT can therefore be defined as technologies that provide access to information through telecommunication. It
also defined as the use of diverse set of technological tool and resources to communicate, create, disseminate,
store and manage information. It is the combination of compatible hardware and computer-based information
systems together with improved communication technologies.
Information can be transmitted from one place to the other with the use of ICT. For example, sending and
receiving e-mail messages, making phone calls, audio and video conferencing, sending and receiving fax
messages, chatting and instant messaging etc.
Examples of ICT gadgets are computers, cellular network, satellites communication, television, telephone, etc

ICT COMPONENTS
The major components of ICT are:
1. Computer: It is needed to process data and information.
2. Input/output devices: These sends or receive data
3. Communication channels: These are links by which voice or data are transmitted. These links used various
media such as telephone line, fiber optic cable, coaxial cable and wireless transmission which could be radio or
satellite link.
4. Communication processors: These are processors which provide support function of data transmission and
reception. Examples are modem, router and multiplexer.
5. Communication software: This control input and out activities and also manage other functions of the
communication network.

BENEFITS OF ICT
i. It is timely, better and cheaper access to knowledge and information
ii. It speeds up transactions and processes
iii. It causes human beings interact with each other in new ways.
iv. Distances becomes irrelevant in business transaction and dealing

DISADVANTAGES OF ICT
i. It leads to job loses 
ii. Threatens other areas/fields of human endeavour. E.g., criminals view it as an avenue to commit crime of all
kinds. 
iii. ICT tools may not be easily affordable. 
iv. Maintenance of some ICT tools or gadgets are expensive.

PRESENTATION
Step1: The teacher revises the previous term exam questions and introduces the present term scheme of works.
Step2: The teacher introduces the week 1 topic to the learner.
Step3: The teacher explains the topic to the learners.
Step4: The teacher entertains questions and provides answers.
Step5: The teacher asked the learners to copy their notes.

EVALUATION:
1. State the benefits of ICT
2. List out FOUR disadvantages of ICT

CLASSWORK: Practical Class

ASSIGNMENT
List and explain the major ICT components

Class: JSS 2
Week: 2
Date: Monday 8th May, 2023
Subject: Computer Studies
Duration: 80 minutes
Topic: INTERNET
Subtopic: Understanding Internet Terms

BEHAVIORAL OBJECTIVES: At the end of the lesson, the learners should be able to:
 Define Internet and State the features of Internet Browser
 Send files to e-mail address
REFERENCE MATERIALS: HCITECH COMPUTER STUDIES FOR JSS 2 TEXTBOOK

INSTRUCTIONAL MATERIAL: Computer System

ENTRY BEHAVIOR: The learners are familiar with the computer system.

CONTENT:
Definition of Internet
Internet is a worldwide network of computers that share information. The Internet is a global network
connecting millions of computers. It is also defined as a global system of interconnected computer networks
that use the Internet protocol suite to link devices worldwide.

Internet Terms
1. Cyber café: An internet café or cyber café is a place which provides internet access to the public, usually for
a fee.
2. Download: To transfer a file from remote computer to a local computer. In other words, it means to transfer a
file from a web server to a web client.
3. Upload: To transfer a file from a local computer to a remote computer. In other words, it means to transfer a
file from a web client to a web server.
4. E-mail: An email is a mail that is electronically transmitted by your computer.
5. Email Address: An email address is the name for an electronic postbox that can receive and send email
messages on a network. An email address consists of two parts, which are the username and the domain name.
In steve@[Link], steve is the username and [Link] is the domain-part. The domain name part of
an email address is case insensitive. The local mailbox part, however, is case sensitive. Examples of email
addresses are: okolojoe90@[Link], uvajoy@[Link], ugbainnocentugbajbr@[Link] etc.
6. Homepage or Home page: It is the first page that appears when you visit any website. It is also the page of a
Web site that provides the introduction or content with links.
7. HTTP: HTTP is an abbreviation for Hypertext Transfer Protocol. It is the set of rules by which Web pages
are transferred across the Internet.
8. URL: URL Stands for "Uniform Resource Locator." A URL is the address of a specific webpage or file on
the Internet.
9. World Wide Web (WWW): It is defined as part of the internet that contains linked text, image sound, and
video documents.
10. Website: A Website is a collection of World Wide Web pages or files. Examples of website address include:
[Link], [Link], [Link],
[Link] etc
11. Webpage: A Web page is a single hypertext file or a page that is part of a Web site
12. Web server: A server is a computer that delivers web content to web browser.
13. HTML (Hypertext Markup Language). It is the language of the web.
14. ISP (Internet Service Provider): ISP is an organisation that provides access to the internet and web hosting.
15. Browse: The term to describe a user’s movement across the web
16. Web Browser (Internet Browser): A software program used to display WebPages. It is also defined as is a
software application for retrieving, presenting, and traversing (moving through) information resources on the
World Wide Web.

Types of Internet Browser

a. Mozilla firefox
b. Opera mini browser
c. Microsoft Internet explorer (Microsoft edge)
d. Google Chrome
e. Apple Safari, etc

Features of Internet Browser

An internet browser has many different parts. They include:
1. Title bar: Displays the title of the open web page
2. Menu bar: The menu bar can be used to activate commands. Depending on the browser you are using, some
contain the following: File, edit, view, tools, Bookmark, help, etc
3. Address Bar: An address bar is a component of an Internet browser which is used to input and show the
address of a website. The web address is generally given in lowercase letters and is case insensitive. There are
no spaces in a webpage or website address.
4. Status Bar: Status bar displays the status of the current page
5. Scroll Bar: This provides vertical or horizontal scrolling through the web pages.
6. Standard tool bar: Standard tool bar has many different buttons. They are explained below.
a. Back: To go back to previously viewed page
b. Forward: To move forward to a page which was viewed
c. Stop: To halt loading of webpage.
d. Refresh/Reload: To refresh the contents of the currently displayed webpage from the start
e. Home: To go to the homepage of the currently viewed website.
f. History: It displays a list of previously viewed website
g. Print: Prints the webpage with the default printer settings.

Uses of the Internet

1. The Internet is used for communication to any part of the world
2. The internet is used to search for information on the web through search engines
3. It is used in sending and receiving messages.
4. It is used for chatting
5. It can be used in planning of trip. E,g. GPS.
6. It can be used for advertisement and marketing. Etc
Benefits of the internet
a. It enables us to share resources globally.
b. Internet allows access to information in a very fast manner.
c. It is cost effective.
d. It allows online banking transactions.
e. E-education
f. E-friends
g. E-entertainment
Abuse of the Internet
1. It is used by impostors to defraud people
2. Piracy of software
3. Pornography
4. Hacking
5. Plagiarism
6. Computer virus

Definition of Electronic Mail

Electronic mail, commonly called email or e-mail, is a method of exchanging digital messages from an author
to one or more recipients. It can also be defined as a system for sending and receiving messages electronically
over a computer network.

Steps to Create Email Account

Follow the steps below to create email account
1. Click On a web browser
2. Visit a website that offers an email service e.g. [Link]
3. Click on the Free Sign Up Button
4. Enter all mandatory fields (First Name, Last Name, Gender, etc.)
5. Click the "Accept" - Button underneath

Procedure for sending an Email

1. Log in to your email account
2. Click Compose.
3. A new blank email window will open up. In the ‘To’ box, type in the email address of the recipient.
4. You might want to include someone else in your email to ‘keep them in the loop’. You can do this by
clicking Cc or Bcc, which will open another field. ‘Cc’ means ‘carbon copy’ and ‘Bcc’ means ‘blind carbon
copy’
5. Type in the subject of the email. The subject field allows you to give the recipient an idea of the topic of your
email, like a heading.
6. Type your message in the main body field of your email.
7. Email text can be formatted in a similar way to text in a word document.
8. Click the Send button at the bottom of the compose window.

PRESENTATION
Step1: The teacher revises the previous class topics and test the learner’s knowledge on the previous class topic.
Step2: The teacher introduces the week 2 topic to the learner.
Step3: The teacher explains the topic to the learners.
Step4: The teacher entertains questions and provides answers.
 Step5: The teacher asked the learners to copy their notes.

EVALUATION:
1. Log in to your email account
2. Click Compose.
3. A new blank email window will open up. In the ‘To’ box, type in the email address of the recipient.
4. You might want to include someone else in your email to ‘keep them in the loop’. You can do this by
clicking Cc or Bcc, which will open another field. ‘Cc’ means ‘carbon copy’ and ‘Bcc’ means ‘blind carbon
copy’
5. Type in the subject of the email. The subject field allows you to give the recipient an idea of the topic of your
email, like a heading.
6. Type your message in the main body field of your email.
7. Email text can be formatted in a similar way to text in a word document.
8. Click the Send button at the bottom of the compose window.

CLASSWORK: Practical

ASSIGNMENT
Create a file in MS Word, Write a composition about your school.
Send the file to this e-mail address: Greyconceptsltd@[Link]

Class: JSS 2
Week: 3
Date: Monday 15th May, 2023
Subject: Computer Studies
Duration: 80 minutes
Topic: FORMATING CELLS (MS EXCEL)
Subtopic: How to format cells in spreadsheet

BEHAVIORAL OBJECTIVES: At the end of the lesson, the learners should be able to:
 Know how to format data in worksheet
 Explain the steps in formatting cells
REFERENCE MATERIALS: HCITECH COMPUTER STUDIES FOR JSS 2 TEXTBOOK

INSTRUCTIONAL MATERIAL: Computer System

ENTRY BEHAVIOR: The learners are familiar with the computer system.

CONTENT:
FORMATING CELLS (MS EXCEL)
Formatting refers to changing the appearance of data to draw attention to parts of the worksheet, or to make the
data easier to read. Formatting does not affect any underlying values. Formatted text and cells can draw
attention to specific parts of the spreadsheet and make the spreadsheet more visually appealing and easier to
understand. In Excel, there are many tools you can use to format text and cells. You can format a cell or range
of cells at any time, either before or after you enter the data.
You can apply formatting using one of the following methods:
 On the Home tab, click the command to apply formatting from the appropriate group; or
 on the Home tab, in the appropriate group, click the Format Cells: Dialog box launcher;
or
 • Press CTRL + 1; or
• Right-click and then click Format Cells;
or
• Press the appropriate keyboard shortcut for specific formatting
features, such as CTRL + B for bold; or
• click the appropriate formatting option from the Mini toolbar, if
active.
Changing Fonts and Sizes
A font is a typeface or text style. Changing fonts alters the way text and numbers appear. Keep the number of
fonts in a worksheet to one or two, as the appearance of too many fonts can be distracting.
To format selected cells, use one of the following methods:
• On the Home tab, in the Font group, click the desired format; or
• On the Home tab, in the Font group, click the Format Cells: Font Dialog box launcher, and then choose the
appropriate option from the Font tab; or
 Press CTRL + SHIFT + F and choose the appropriate option from the Font tab:

PRESENTATION
Step1: The teacher revises the previous class topics and test the learner’s knowledge on the previous class topic.
Step2: The teacher introduces the new week topic to the learner.
Step3: The teacher explains the topic to the learners.
Step4: The teacher entertains questions and provides answers.
Step5: The teacher asked the learners to copy their notes.

EVALUATION:
• On the Home tab, in the Font group, click the desired format; or
• On the Home tab, in the Font group, click the Format Cells: Font Dialog box launcher, and then choose the
appropriate option from the Font tab; or
 Press CTRL + SHIFT + F and choose the appropriate option from the Font tab:
CLASSWORK: Practical

ASSIGNMENT
In this exercise, you will format different parts of the worksheet to emphasize values and text.
1. Open Microsoft Excel, then prepare the above table.

2. Select cells A1 to C1. Then on the Home tab, in the Alignment group, click Merge & Center.

3. Repeat step 2 for cells A2 to C2 and A3 to C3.

4. For the Asset use font style berlin san fb, font size 16pt, the give the entire cell your desire colour of your
choice. Note: your text colour must appear clearly.

5. Repeat the question 4 for both Current Year Column and Previous Year Column.

6. To be printed and submitted in colour on or before Monday 8th May, 2022.

Class: JSS 2
Week: 4
Date: Monday 22nd May, 2023
Subject: Computer Studies
Duration: 80 minutes
Topic: MANAGING WORKSHEET
Subtopic: working with worksheet

BEHAVIORAL OBJECTIVES: At the end of the lesson, the learners should be able to:
 Name and re-name worksheet tab
 Insert and delete worksheet

REFERENCE MATERIALS: HCITECH COMPUTER STUDIES FOR JSS 2 TEXTBOOK

INSTRUCTIONAL MATERIAL: Computer System

ENTRY BEHAVIOR: The learners are familiar with the computer system.

CONTENT:
A workbook is a collection of worksheets. While each worksheet can be treated as an independent spreadsheet,
information on the worksheets within a workbook is typically interrelated. Worksheets can be renamed, added,
deleted, copied, and moved within a workbook. Use the tab scrolling buttons to display more worksheet tabs as
required.

NAMING WORKSHEETS

Sheet1, Sheet2, Sheet3, and so on help to identify different sheets as you create them, but do not describe their
contents, which can make it difficult for you to find what you want. Renaming your worksheet with more
descriptive names makes locating data easier. Worksheet tab names can be up to 31 characters long.

To Rename a Worksheet tab, use one of the following methods:

 On the Home tab, in the Cells group,

 Click Format, and then Rename Sheet; or
 Double-click the sheet tab and then type the new name.
INSERTING OR DELETING WORKSHEETS

Excel automatically includes three worksheets with a new workbook, but you can add more. To insert a new
worksheet, use one of the following methods:

 On the Home tab, in the Cells group

 Click Insert
 Then Insert Sheet; or
 In the sheet tabs area, click (Insert Worksheet) to automatically add a worksheet at the end of the current
worksheet tabs; or
 Press SHIFT + F11 ; or
 Right-click the tab where you want to place the new sheet
 Click Insert, Worksheet
 Then click OK.

PRESENTATION
Step1: The teacher revises the previous class topics and test the learner’s knowledge on the previous class topic.
Step2: The teacher introduces the new week topic to the learner.
Step3: The teacher explains the topic to the learners.
Step4: The teacher entertains questions and provides answers.
Step5: The teacher asked the learners to copy their notes.

EVALUATION:
 On the Home tab, in the Cells group
 Click Insert
 Then Insert Sheet; or
 In the sheet tabs area, click (Insert Worksheet) to automatically add a worksheet at the end of the current
worksheet tabs; or
 Press SHIFT + F11 ; or
 Right-click the tab where you want to place the new sheet
 Click Insert, Worksheet
 Then click OK.

CLASSWORK: Practical

ASSIGNMENT
1. Open Excel package,
2. create a document and add 10 worksheets.
3. Save the document with your name.
4. Send the document to the e-mail: greyconceptsltd@[Link].
5. To be submitted before Friday 26th May, 2023.
Class: JSS 2
Week: 5
Date: Monday 29th May, 2023
Subject: Computer Studies
Duration: 80 minutes
Topic: WORKING WITH CHART
Subtopic: Selecting Chart Types

BEHAVIORAL OBJECTIVES: At the end of the lesson, the learners should be able to:
 Work with chart
 Select chart types
REFERENCE MATERIALS: HCITECH COMPUTER STUDIES FOR JSS 2 TEXTBOOK

INSTRUCTIONAL MATERIAL: Computer System

ENTRY BEHAVIOR: The learners are familiar with the computer system.

CONTENT:
A chart is a pictorial representation of data in a worksheet. A chart can be a more descriptive way of
representing your data, as it can clearly illustrate trends or patterns in the data. You can create a chart by
selecting data from the worksheet, and then using the commands on the Chart Tools ribbon. Once you have
created the chart, you can save it with the workbook. You can create an embedded chart that displays on the
same sheet as the data, or you can create charts on their own sheets.

SELECTING CHART TYPES

As noted previously, the type of chart you select will depend on what you are trying to show.
Excel provides a variety of chart types and several sub-types within each major type:
1. Column 8. Line
2. Pie 9. Bar
3. Area 10. Scatter
4. Stock 11. Doughnut
5. Bubble 12. Radar
6. Cylinder 13. Cone
7. Pyramid

PRESENTATION
Step1: The teacher revises the previous class topics and test the learner’s knowledge on the previous class topic.
Step2: The teacher introduces the new week topic to the learner.
Step3: The teacher explains the topic to the learners.
Step4: The teacher entertains questions and provides answers.
Step5: The teacher asked the learners to copy their notes.

EVALUATION:
1. The learners copied their notes and the teacher marks the note.

CLASSWORK: Practical

ASSIGNMENT:
List Eight types of charts in Excel
Class: JSS 2
Week: 6
Date: Monday 5th June, 2022
Subject: Computer Studies
Duration: 80 minutes
Topic: CREATING FORMULA
Subtopic: To Create a Formula Using Cell References

BEHAVIORAL OBJECTIVES: At the end of the lesson, the learners should be able to:
 Create a simple formula in Excel
 Create formula using cell reference
REFERENCE MATERIALS: HCITECH COMPUTER STUDIES FOR JSS 2 TEXTBOOK

INSTRUCTIONAL MATERIAL: Computer System

ENTRY BEHAVIOR: The learners are familiar with the computer system.

CONTENT:
A formula is a calculation using numbers (or other data) in a cell or from other cells, such as:

• Automatically calculating sums horizontally and vertically

• Performing “what-if” analyses by performing a calculation based on one or more changing input values,
such as estimated profit for a business during the next year
• Using one or more Excel functions to perform tedious or complex calculations, such as monthly
mortgage payments.
The following symbols are used in Excel to represent standard mathematical operators:

* Multiplication + Addition

/ Division – Subtraction

To Create a Simple Formula in Excel:

1. Select the cell where the answer will appear (B4, for example).
2. Type the equal sign (=).
3. Type in the formula you want Excel to calculate. For example, "75/250".
4. Press Enter. The formula will be calculated and the value will be displayed in the cell.
Creating Formulas with Cell References

When a formula contains a cell address, it is called a cell reference. Creating a formula with cell references is
useful because you can update data in your worksheet without having to rewrite the values in the formula.

To Create a Formula Using Cell References:

1. Select the cell where the answer will appear (B3, for example).
2. Type the equal sign (=).
3. Type the cell address that contains the first number in the equation (B1, for example).
4. Type the operator you need for your formula. For example, type the addition sign (+).
5. Type the cell address that contains the second number in the equation (B2, for example).
6. Press Enter. The formula will be calculated and the value will be displayed in the cell.
To Edit a Formula:

1. Click on the cell you want to edit.

2. Insert the cursor in the formula bar and edit the formula as desired. You can also double-click the cell to
view and edit the formula directly from the cell.
3. When finished, press Enter
4. The new value will be displayed in the cell.

PRESENTATION
Step1: The teacher revises the previous class topics and test the learner’s knowledge on the previous class topic.
Step2: The teacher introduces the new week topic to the learner.
Step3: The teacher explains the topic to the learners.
Step4: The teacher entertains questions and provides answers.
Step5: The teacher asked the learners to copy their notes.

EVALUATION:
1. Click on the cell you want to edit.
2. Insert the cursor in the formula bar and edit the formula as desired. You can also double-click the cell to
view and edit the formula directly from the cell.
3. When finished, press Enter
4. The new value will be displayed in the cell.
CLASSWORK: Practical

ASSIGNMENT
In this Exercise, you will enter a few simple formulas using math operators.

1. Open the AM Personal Budget file and save as AM Personal Budget - Student.
2. Click in cell B5. Type: =B3+B4 and press ENTER KEY.
3. Click cell B5 once more and on the Home tab, in the Clipboard group, click Copy.
4. Select cells C5 to D5 and on the Home tab, in the Clipboard group, click Paste.
5. Click in cell B14 and type: =B5-B12 and press Enter.
6. Click in cell B14 again and then press Ctrl + C to start the copy process.
7. Select cells C14 and D14. Press Ctrl + V to paste the formula into these cells.
 8. Save and close the budget report.

Class: JSS 2
Week: 8
Date: Monday 5th June, 2022
Subject: Computer Studies
Duration: 80 minutes
Topic: SAVING WORKBOOK (MS EXCEL)
Subtopic: Uses Other Saving Methods

BEHAVIORAL OBJECTIVES: At the end of the lesson, the learners should be able to:
 Save documents in MS EXCEL
 Uses other saving methods
REFERENCE MATERIALS: HCITECH COMPUTER STUDIES FOR JSS 2 TEXTBOOK

INSTRUCTIONAL MATERIAL: Computer System

ENTRY BEHAVIOR: The learners are familiar with the computer system.

CONTENT:

To use a file again, you must save the workbook. It is a good practice to save work frequently during a session,
especially if the workbook is large, or if you are using a process, you have not tried before.
To save the changes made to an existing file, use one of the following methods:
• Click the File tab and then Save; or
• on the Quick Access toolbar, click (Save); or Press CNTR + S.
The first time you save a file, you will always see the Save As dialog box so that you can give the new
workbook a distinct name and select the location where it will be stored, such as the hard drive, network drive,
or portable media drive. By default, Excel selects the My Documents folder within the Documents library as the
location to save the file. You can choose this location or navigate to another location using the Save in field.
You can also create new folders within Excel during the save process. To save the changes made to an existing
file and save it with a new name or in a different file format, click the File tab and then click Save As. The
default file type given to an Excel file is .xlsx, although you can save it in different file formats using the Save
as type field in the Save As dialog box.

PRESENTATION
Step1: The teacher revises the previous class topics and test the learner’s knowledge on the previous class topic.
Step2: The teacher introduces the new week topic to the learner.
Step3: The teacher explains the topic to the learners.
Step4: The teacher entertains questions and provides answers.
Step5: The teacher asked the learners to copy their notes.

EVALUATION:
Practical class on how to save document in excel

CLASSWORK: Practical class

ASSIGNMENT
In this Exercise, you will enter a few simple formulas using math operators.

Class: JSS 2
Week: 9
Date: Monday 5th June, 2022
Subject: Computer Studies
Duration: 80 minutes
Topic GETTING READY TO PRINT IN MS EXCEL
Subtopic: To Create a Formula Using Cell References

BEHAVIORAL OBJECTIVES: At the end of the lesson, the learners should be able to:
 Create a simple formula in Excel
 Create formula using cell reference
REFERENCE MATERIALS: HCITECH COMPUTER STUDIES FOR JSS 2 TEXTBOOK

INSTRUCTIONAL MATERIAL: Computer System

ENTRY BEHAVIOR: The learners are familiar with the computer system.

CONTENT:
GETTING READY TO PRINT IN MS EXCEL
As you begin working with large worksheets, you may find that the data extends further than what the screen shows.
Accordingly, Excel provides you with the ability to change how it displays the worksheet. For instance, if you are
performing some “What-if” evaluations, you may want to view distant sections of one large worksheet or workbook on
the screen at the same time. As a result, you may experience difficulty working on your large worksheet because you
cannot see the row and column headings when making entries. By changing the view to display the values you want to
work with in the worksheet, you can determine what options you may want to set prior to printing, such as whether to
print the entire document onto a larger paper size, or to select only a specific cell range for printing.

To Print a Worksheet,
click the File tab, and click Print.
Excel displays both the print options as well as a preview of the worksheet with the existing print
options applied.
The total number of pages in the printout displays at the bottom left of the preview. If the number of pages exceeds or
falls short of what you expected, you may need to revisit and/or change the page setup before printing.
A chart in the worksheet previews or prints based on where it is positioned in the worksheet. You can move the chart to a
new worksheet, or insert a page break between the data and the chart. If you are using a monochrome printer, the chart
will print in varying shades of gray; it will print in color only if you have a color printer. Once you have previewed the
worksheet on the screen and made sure it is ready to print, you can select the Print option.
By default, Excel prints only the current active worksheet in the workbook. You can also specify to print all worksheets in
the workbook, a selected group of worksheets, or only a selected range of cells.

PRESENTATION
Step1: The teacher revises the previous class topics and test the learner’s knowledge on the previous class topic.
Step2: The teacher introduces the new week topic to the learner.
Step3: The teacher explains the topic to the learners.
Step4: The teacher entertains questions and provides answers.
Step5: The teacher asked the learners to copy their notes.

EVALUATION:
Practical class on how to print document in excel

CLASSWORK: Practical class

ASSIGNMENT
Practicalize this at home
Click File and then click Print.
In the list of print options, click the No Scaling box and then click Custom Scaling Options.
The Page tab of the Page Setup dialog box appears. Click the incremental button for the Adjust to field until it reads
75%. Click OK. At the bottom left of the preview portion on the screen, click the to go to page 2.
Now try changing the margins to see if this will allow you to increase the scaling for the chart. Click the Normal Margins
option and change this to Narrow Margins.
Click the Custom Scaling option and click Custom Scaling Options. Change the scaling to 85 and click OK to see the
impact it may have on the chart preview. Even though you increased the chart size by 10% (and in fact, you may be able
to make it a bit bigger) the smaller margin size allows the chart to fit on one page. This is an example of how you can
tweak options to enhance or change elements in the report.
Try changing the scaling slightly to see how it appears in the preview.
Click File to go back to the worksheet.
Click the Page Layout tab and in the Page Setup group, click the Dialog box launcher.
Click the Header/Footer tab and click the Custom Footer button.

Class: JSS 2
Week: 10
Date: Monday 5th June, 2022
Subject: Computer Studies
Duration: 80 minutes
Topic: PRACTICAL CLASS IN MS EXCEL
Subtopic: To Create a Formula Using Cell References

BEHAVIORAL OBJECTIVES: At the end of the lesson, the learners should be able to:
 Create a simple formula in Excel
 Create formula using cell reference
REFERENCE MATERIALS: HCITECH COMPUTER STUDIES FOR JSS 2 TEXTBOOK
INSTRUCTIONAL MATERIAL: Computer System
ENTRY BEHAVIOR: The learners are familiar with the computer system.

CONTENT:
PRACTICAL CLASS

PRESENTATION
Step1: The teacher revises the previous class topics and test the learner’s knowledge on the previous class topic.
Step2: The teacher introduces the new week topic to the learner.
Step3: The teacher explains the topic to the learners.
Step4: The teacher entertains questions and provides answers.
Step5: The teacher asked the learners to copy their notes.

EVALUATION:
Practical class

CLASSWORK: Practical class

ASSIGNMENT Practical class