Lesson Notes By Weeks and Term - Senior Secondary School 1

SUBJECT: DATA PROCESSING

CLASS:  SS 1

DATE:

TERM: 3rd TERM

REFERENCES

• Data Processing for Senior Secondary Schools by Hiit Plc.
• Modern Computer Studies by Victoria.
• Computing Essentials by Westpatterns Technologies Limited. 

 
WEEK FOUR

TOPIC: SPREADSHEET I

DEFINITION OF SPREADSHEET: A spreadsheet is a collection of cells organized into rows and columns where data is stored and manipulated. The spreadsheet is known as worksheet. A spreadsheet begins with row number one and column A. A cell is a space in a worksheet formed by the intersection of a row and a column. Each cell can contain a number, text or formula. A cell can also reference another cell in the same worksheet, the same workbook or a different workbook. Each cell has an address called Cell Referencee.g. A1, B3, C7 etc. combination of more than one sheet is referred to as workbook. The worksheets can accept thousands of rows of data and columns in form of fields.Active Cell is recognized by heavy border surrounding. It is the cell that is currently worked upon.

                A SPREADSHEET

CONTENT OF SPREADSHEET

When you are setting out a spreadsheet, you have to enter values, labels and formulas.

• VALUES: Values are those numbers you already know before starting the spreadsheet operation. These values are inserted into cells of the spreadsheet.
• LABELS: Labels are words you enter to explain the values. You would not just enter a list of numbers without explanation. Putting labels next to each of the numbers makes it easier for to check it through.
• FORMULA: Formulas are the mathematical equations you insert into the cells. Formulas are commands that instruct the computer on what to do.

EVALUATION

1. Define a worksheet.
2. What do you understand by cell reference?

USES OF SPREADSHEET

There are various uses of spreadsheet. It uses varies according to the intended purpose. Some of its uses are as follows:

1. Spreadsheets are used for administrative functions. 
2. Spreadsheets are used for creating reports.
3. They are used for preparation of daily sales.
4. They are used in computing school results.
5. They are used for project budgeting control.
6. They are used for drawing balance sheets.
7. Excel can store and calculate the data as directed using existing data.
8. Spreadsheet can be used for analysis and decision making.
9. It makes calculations much easier than working things out yourself.

GENERAL EVALUATION

1. State the uses of spreadsheet.
2. Excel can be used to create analysis, Explain.
3. What is an active cell?
4. What are the contents in spreadsheet?

READING ASSIGNMENT: Modern Computer studies by Victoria, page 25

WEEKEND ASSIGNMENT

1. A cell can also reference another cell in the same……..A. worksheet B. workbook 

1. cellular D. sheet

1. Spreadsheet can be used for data analysis and…………making A. cell B. decision 

1. data D. reference

1. The………….. can contain thousands of rows of data and columns in form of fields. A. cell B. worksheet C. reference cell D. excel
2. The cell that is been currently worked upon is known as ……………cell. A. current B. active C. reference D. initial
3. A ……….. can also reference another cell in the same worksheet. A. cell B. sheet 

1. worksheet D. none

THEORY

• Define an active cell.

• List and explain the THREE major contents in a spreadsheet.