Lesson Notes By Weeks and Term v4 - JHS 1
INTRODUCTION TO ELECTRONIC SPREADSHEET
Download the Lessonotes Mobile Ghana app for faster lesson access on Android and iPhone.
INTRODUCTION TO ELECTRONIC SPREADSHEET
Download the Lessonotes Mobile Ghana app for faster lesson access on Android and iPhone.
Subject: Computing
Class: JHS 1
Term: 2nd Term
Week: 5
Grade code: B7.2.3.1.1
Strand code: 2
Sub-strand code: 3
Content standard code: B7.2.2.1
Indicator code: B7.2.3.1.1
Theme: PRODUCTIVITY SOFTWARE
Subtheme: INTRODUCTION TO ELECTRONIC SPREADSHEET
This page supports the lesson note with a companion video and a short classroom-ready summary.
For class groups and homework, share this lesson page so learners also get the summary, objectives, and full lesson context.
In our daily lives, from the market woman selling tomatoes to the headmaster managing our school records, people need to work with numbers and information. For a long time, this was done using paper and pen in books called ledgers or registers. This method can be slow, tiring, and prone to mistakes. Today, we have a powerful computer tool that makes this work faster, easier, and much more accurate: the Electronic Spreadsheet. This lesson will introduce you to what spreadsheets are, why they are so important, and how they can help us solve problems in school, at home, and in our communities.
This section breaks down the main ideas you need to understand. A. What is an Electronic Spreadsheet?
Think about your class teacher's mark book or a shopkeeper's sales book. It is a large sheet of paper with lines that form a grid of rows and columns. This is a manual spreadsheet.
An electronic spreadsheet is a computer program (software) that does the same thing, but on a computer screen. It is an interactive application for organizing, analysing, and storing data in a table format.
Key Features of a Spreadsheet: Grid System: It is made up of a grid of rows and columns. Rows: These run horizontally (from left to right) and are identified by numbers (1, 2, 3, ...). Columns: These run vertically (from top to bottom) and are identified by letters (A, B, C, ...). Cell: The box where a row and a column meet is called a cell. Each cell has a unique address, like a house address. For example, the cell where Column B and Row 3 meet is called Cell B3. We enter data (text, numbers, or formulas) into cells. Worksheet/Sheet: A single page within a spreadsheet file is called a worksheet. You can have many worksheets in one file, just like having many pages in an exercise book.