Lesson Notes By Weeks and Term - Senior Secondary 1

Spreadsheet I

Get it on Google Play
Get it on the Apple App Store
  1. Home
  2. Lesson Notes By Weeks and Term
  3. Senior Secondary 1
  4. Spreadsheet I

Term: 3rd Term

Week: 4

Class: Senior Secondary School 1

Age: 15 years

Duration: 40 minutes of 2 periods each

Date:       

Subject:      Data Processing

Topic:-       Spreadsheet I

SPECIFIC OBJECTIVES: At the end of the lesson, pupils should be able to

  1. Define spreadsheet
  2. List the examples of spreadsheet
  3. State the uses of spreadsheet
  4. Describe the components of spreadsheet
  5. Explain some common terminologies in spreadsheet

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 Word processing

Students pay attention

STEP 2

EXPLANATION

He defines spreadsheet and explains it. He lists the popular examples of spreadsheet

 

 

Students pay attention and participates

STEP 3

DEMONSTRATION

He explains the uses and components of the spreadsheet package

 

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

SPREADSHEET

A spreadsheet package (sometimes called Spreadsheet) is an application program consisting of grid of cells arranged in rows and columns that is used for modeling data for the purpose of budgeting, planning, data analysis etc.

The columns in a spreadsheet are represented by letters, ‘A’, ‘B’, ‘CA’ etc., while rows are represented by numbers, 1, 2, 3 etc. A single cell is referenced by addressing its column letter and row number e.g. ‘B5’. In spreadsheet, a contiguous group of cells is referred to as a Range. For example A1:A10 reference the contiguous group of cells A1 to A10. In MS Excel 2007 and above, a typical worksheet contains 16384 (XFD) columns and 1,048,576 rows. A spreadsheet is generally designed to hold numeric data, short text strings or results of formulas that is automatically calculated based on the contents of other cells. A file created by MS Excel is called a Workbook with default name Book1 or BookX, where X can be any number starting from 1. This workbook has three worksheets (sheets) by default and users can create as many as the computer memory allows. A workbook has the extension ‘.xlsx’. The total number of characters a cell can contain is 32,767.

 

Examples of Spreadsheet packages

  1. Microsoft Excel                                           
  2. Google Sheet              
  3. SuperCalc
  4. StatView Spreadsheet     
  5. Lotus 1-2-3
  6. Gnumeric   

 

Uses of Spreadsheet

  1. Used for simple lists
  2. Used for analysis of numerical data
  3. Used for sorting and filtering of information
  4. Used for preparation of daily sales report
  5. Spreadsheet turns information within table into detailed graphs and charts to show visual representation of the data.

 

Components of Spreadsheet

  1. Name box: this is a space to the left of the formula bar that references the cell that is active. It shows the name (address) of a selected cell.
  2. Formula bar: this bar displays information entered (being entered as you type) in the current or active cell. The content of this cell can be edited in the formula bar

 

SOME COMMON TERMINOLOGIES IN SPREADSHEET

  1. Rows

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 work sheet. They are numbered from 1, 2, 3 to 1,048,576 in Excel 2007, 2010, 2013 & 2016.

 

  1. Columns

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, 2010, 2013 & 2016.

 

  1. Cells

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 A1.

 

  1. The 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.

 

  1. Worksheet

The worksheet (also known as spreadsheet) 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.

 

  1. Workbook

This can be simply defined as a collection of worksheets. Each workbook contains many worksheets just like a normal single book with a number of pages.

 

  1. Chart

A Chart is a graphical representation of data that enables you to understand the data at a glance. Examples of Charts include Column (histogram), Pie chart, Bar Chart, Line Chart, Surface, Doughnut, etc.

 

  1. Data Range

A group of highlighted cells in a worksheet is referred to as a Range.

 

  1. Fill Handle

This is a small black square at the corner of selected cells. The cursor changes to a black cross when moved to it.

 

  1. Moving Border

This is an animated border that appears around a selected cell that has been cut or copied. Press the ESC key to cancel a moving border. 

 

EVALUATION:    1. Define spreadsheet

  1. List some common examples of spreadsheet
  2. What are the uses of spreadsheet?
  3. Describe two components of the spreadsheet
  4. Write short notes on the following

           a. rows

           b. columns

           c. cells

           d. worksheet

           e. workbook

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively