Spreadsheet SS3 Data Processing Lesson Note

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 the spreadsheet
5. Explain some common terminologies in a spreadsheet

INSTRUCTIONAL TECHNIQUES: 

• Identification, 
• explanation, 
• questions and answers, 
• demonstration, 
• videos from source

INSTRUCTIONAL MATERIALS: 

• Videos, 
• loudspeaker, 
• pictures, 
• Data Processing for Senior Secondary Education by Hiit Plc, 
• WAPB Computer Studies for Senior Secondary I by Adekunle et al,
• On-line Materials.

NOTE

SPREADSHEET

A spreadsheet package (sometimes called Spreadsheet) is an application program consisting of a grid of cells arranged in rows and columns that is used for modelling 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 the spreadsheet, a contiguous group of cells is referred to as a Range. For example, A1:A10 references 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 are automatically calculated based on the contents of other cells. A file created by MS Excel is called a Workbook with the default name Book 1 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 information
4. Used for preparation of daily sales report
5. A spreadsheet turns information within tables into detailed graphs and charts to show a 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 active cell. 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

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

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

• 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 enables 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. 

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

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

• Workbook

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

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

• Date Range

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

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

• 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 spreadsheets?
3. Describe two components of the spreadsheet
4. Write short notes on the following

1. Rows
2. Columns
3. Cells
4. Worksheet
5. workbook

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively

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 the spreadsheet
5. Explain some common terminologies in a spreadsheet

INSTRUCTIONAL TECHNIQUES: 

• Identification, 
• explanation, 
• questions and answers, 
• demonstration, 
• videos from source

INSTRUCTIONAL MATERIALS: 

• Videos, 
• loudspeaker, 
• pictures, 
• Data Processing for Senior Secondary Education by Hiit Plc, 
• WAPB Computer Studies for Senior Secondary I by Adekunle et al,
• On-line Materials.

NOTE

SPREADSHEET

A spreadsheet package (sometimes called Spreadsheet) is an application program consisting of a grid of cells arranged in rows and columns that is used for modelling 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 the spreadsheet, a contiguous group of cells is referred to as a Range. For example, A1:A10 references 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 are automatically calculated based on the contents of other cells. A file created by MS Excel is called a Workbook with the default name Book 1 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 information
4. Used for preparation of daily sales report
5. A spreadsheet turns information within tables into detailed graphs and charts to show a 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 active cell. 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

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

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

• 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 enables 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. 

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

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

• Workbook

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

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

• Date Range

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

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

• 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
2. List some common examples of spreadsheet
3. What are the uses of spreadsheets?
4. Describe two components of the spreadsheet
5. Write short notes on the following

• Rows
• Columns
• Cells
• Worksheet
• workbook

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively