SS1 Third Term Data Processing Lesson Note – Spreadsheet

The content is just an excerpt from the complete note for SS1 Third Term Data Processing Lesson Note – Spreadsheet. Check below to download the complete DOCUMENT

WEEK TWO                                                                                                  

TOPIC:   SPREADSHEET

CONTENT: 

1. Definition of Spreadsheet.
2. Uses of Spreadsheet.
3. Examples of Spreadsheet.

SUBTOPIC 1:      Definition of Spreadsheet

Spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form.  Spreadsheets are developed as computerized simulations of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. A spreadsheet may also refer to one such electronic document.

Spreadsheet is simply a sheet of paper on which horizontal and vertical lines to generate a rectangular grid, much as your mathematics copy. A spreadsheet can also be called a workbook or code book. A workbook (e.g., Excel) is a collection of one or more worksheets (A worksheet is like a page in the workbook). Each square or block is used to write number or text or figure for calculations if required as shown below;

A rectangular grid for data entry

A spreadsheet consists of a table of cells arranged into rows and columns and referred to by the X and Y locations. X locations, the columns, are normally represented by letters, “A”, “B”, “C”, etc., while rows are normally represented by numbers, 1, 2, 3, etc. A single cell can be referred to by addressing its row and column, “C10” for instance. This electronic concept of cell references was first introduced in LANPAR (Language for Programming Arrays at Random) (co-invented by Rene Pardo and Remy Landau) and a variant used in VisiCalc, and known as “A1 notation”. Additionally, spreadsheets have the concept of a range, a group of cells, normally contiguous.

To gain full access to the note: DOWNLOAD FILE