Computer Studies - Junior Secondary 3 - Spreadsheet packages

Term: 2^nd Term

Week: 5

Class: Junior Secondary School 3

Age: 14 years

Duration: 40 minutes of 2 periods each

Date:

Subject:      Computer studies

Topic:-       Spreadsheet packages

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

1. State and explain the features of the spreadsheet package
2. Load and exit spreadsheet packages

INSTRUCTIONAL TECHNIQUES: Identification, explanation, questions and answers, demonstration, videos from source

INSTRUCTIONAL MATERIALS: Videos, loud speaker, textbook, pictures

INSTRUCTIONAL PROCEDURES

PERIOD 1-2

NOTE

SPREADSHEET PACKAGES
FEATURES OF THE SPREADSHEET PACKAGES

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.

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

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

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

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

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

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

8. Data Range

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

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

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

LOADING AND EXITING SPREADSHEET PACKAGES

LOADING THE SPREADSHEET PACKAGE

METHOD I

To load a spreadsheet package, take the following steps:

1. Click on the START button
2. Point to ALL PROGRAM
3. Point to Microsoft Office
4. Click on Microsoft Excel

METHOD II

1. Double-click the Microsoft Excel icon on the desktop. The spreadsheet package opens. The active cell is cell A1 and the active worksheet is sheet 1.

Exiting the Spreadsheet Package

To exit a spreadsheet package, take any of the following steps:

1. Click on the File menu and select Exit.
2. Click on the Close button on the Title bar
3. Press ALT + F4.

EVALUATION:    1. Mention and explain five features of the spreadsheet packages

CLASS ACTIVITY

Load and exit Microsoft excel

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively