Lesson Notes By Weeks and Term - Senior Secondary 1
Spreadsheet IV
Spreadsheet IV
Term: 3rd Term
Week: 7
Class: Senior Secondary School 1
Age: 15 years
Duration: 40 minutes of 2 periods each
Date:
Subject: Data Processing
Topic:- Spreadsheet IV
SPECIFIC OBJECTIVES: At the end of the lesson, pupils should be able to
INSTRUCTIONAL TECHNIQUES: Identification, explanation, questions and answers, demonstration, videos from source
INSTRUCTIONAL MATERIALS: Videos, loud speaker, pictures, Data Processing for senior Secondary Education by Hiit Plc, WAPB Computer Studies for Senior Secondary I by Adekunle et al, On-line Materials.
INSTRUCTIONAL PROCEDURES
PERIOD 1-2
|
PRESENTATION |
TEACHER’S ACTIVITY |
STUDENT’S ACTIVITY |
|
STEP 1 INTRODUCTION |
The teacher reviews the previous lesson on Spreadsheet |
Students pay attention |
|
STEP 2 EXPLANATION |
He shows the learners how to edit, retrieve, save and format worksheet in excel
|
Students pay attention and participates |
|
STEP 3 DEMONSTRATION |
He shows the learners how to change font and adjust column width in excel
|
Students pay attention and participate |
|
STEP 4 NOTE TAKING |
The teacher writes a summarized note on the board |
The students copy the note in their books |
NOTE
EDITING THE WORKSHEET
Editing a worksheet means to either insert data, delete existing ones or to make corrections to the already existing data.
SAVING A WORKSHEET
Click on the Microsoft office Button
Click on Save
When the dialog box appears, in the save in box click on the arrow, a drop-down menu
Select a location to save e.g. My Document
Type a file name in the File name
Click on Save.
Subsequently, just press ctrl + S to continue saving the worksheet.
RETRIEVING A WORKSHEET
To retrieve an existing or saved worksheet, follow the steps below;
Load the spreadsheet package (Microsoft Excel in this case)
Click on the File menu or the Microsoft Office button
Click on Open, the open dialog box will be displayed
Click on the arrow beside the Look in box
Select My Document from the drop-down menu
Click on the File Name
Click on Open
FORMATTING WORKSHEET
The general arrangement of data is known as ‘Formatting’. The contents of selected cells can be formatted using the formatting tool bar. Formatting changes the way numbers and text are displayed in a worksheet.
CHANGING FONTS
To do this,
Highlight the text within your spreadsheet
Select the font box from the toolbar at the top of your screen.
The font box may display the name of your default font.
Once you click this, select the font that you want to try from the drop down menu.
FORMATTING VALUES IN A RANGE
The number entered in the worksheet can be formatted to have currency symbols like the dollar ($). To format numbers in a worksheet follow the under listed steps
Highlight the number(s) in the desired range
Click on the arrow beside the number on the ribbon bar
When the dialog box appears, click on the number tab
Select Currency
Click on the arrow beside the symbol to get a drop-down menu
Select the required symbol e.g. dollar sign with 2 decimal places
Click on OK.
ADJUSTING THE COLUMN WIDTH
Click on the cell to be adjusted
Position the cell pointer on the column tab,
The cell pointer changes to a cross
Click and drag to the right to increase the column width.
CLASS ACTIVITY: 1. Edit, save and retrieve a worksheet
CLASSWORK: As in evaluation
CONCLUSION: The teacher commends the students positively