Lesson Notes By Weeks and Term v4 - SHS 1
ORGANISING, MANAGING AND PRESENTING INFORMATION USING ESSENTIAL PRODUCTIVITY
Download the Lessonotes Mobile Ghana app for faster lesson access on Android and iPhone.
ORGANISING, MANAGING AND PRESENTING INFORMATION USING ESSENTIAL PRODUCTIVITY
Download the Lessonotes Mobile Ghana app for faster lesson access on Android and iPhone.
Subject: Ict
Class: SHS 1
Term: 2nd Term
Week: 7
Grade code: 2.1.1.LI.2
Strand code: 1
Sub-strand code: 1
Content standard code: 1.2.2.CS.1
Indicator code: 2.1.1.LI.2
Theme: ICTs IN THE SOCIETY
Subtheme: ORGANISING, MANAGING AND PRESENTING INFORMATION USING ESSENTIAL PRODUCTIVITY
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, we constantly deal with numbers: our grades, the price of waakye, bus fares, or the money we save. Spreadsheet applications like Microsoft Excel or Google Sheets are powerful tools that help us organize, calculate, and make sense of this numerical information quickly and accurately. Instead of using a calculator for every single sum, we can command the computer to do the work for us using special instructions called formulas and functions. This skill is essential not just for passing ICT, but for managing a small business, planning a personal budget, or analysing information in any future career, from farming to banking.
A. The Spreadsheet Environment Before we create formulas, let's remember the basics: A spreadsheet is a grid of cells. Each cell has a unique address, called a cell reference (e.g., A1, B4, C10). We can put text, numbers, or formulas into these cells. B. What is a Formula? A formula is an expression that you write to perform a calculation. In spreadsheets, every formula must begin with an equal sign (=). This tells the software "I want you to calculate something." Components of a Formula: The equal sign (`=`) Cell References (e.g., `A2`, `B3`) - It's better to use cell references than actual numbers so that if the number in the cell changes, the formula's result updates automatically. Mathematical Operators: `+` (Addition) `-` (Subtraction) `*` (Multiplication) `/` (Division)