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.

Get it on Google Play

Get it on the Apple App Store

Subject: Ict

Class: SHS 1

Term: 2nd Term

Week: 3

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

Lesson Video

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.

Performance objectives

Define spreadsheets, formulas, and functions.
Create a spreadsheet and enter data.
Use functions like SUM, AVERAGE, MIN, MAX, and IF.
Apply date and time functions.
Present data visually with charts.

Lesson summary

In today's world, we are surrounded by data – from our class scores and house points to the daily sales at a local provisions store. Simply collecting this information is not enough; we need to understand it. Spreadsheet software gives us powerful tools called formulas and functions to analyse this data quickly and accurately. Instead of using a calculator to add up 50 numbers, we can do it in a second! This skill is essential not just for ICT, but for business, science, and even managing your own personal finances. Imagine being able to calculate your average grade, find your highest score, or even help a family member track their small business profits, all with a few clicks.

Lesson notes

A. The Spreadsheet Environment (Quick Recap) A spreadsheet is a grid of cells organised into rows (numbered 1, 2, 3...) and columns (lettered A, B, C...). Each cell has a unique address, called a cell reference (e.g., A1, B4, C10). We use these references to tell the computer which data to use in our calculations. B. What is a Formula? A formula is a mathematical expression you create to perform calculations. Golden Rule: All formulas in a spreadsheet MUST begin with an equal sign (`=`). This tells the software "I want you to calculate something." Components: Formulas use cell references and mathematical operators. `+` (Addition) `-` (Subtraction) `*` (Multiplication) `/` (Division)

Evaluation guide

Create and utilise formula e and functions for data analysis.
Project -Based learning :
Work on practical assignments , individually or in groups , to create and use
formula e and functions in spreadsheet software.

Reference guide

: Computers with spreadsheet software (e.g., Microsoft Excel, Google Sheets), Projector, Whiteboard/Marker, Sample Datasets.
Overview and Learning Objectives
Introduction:
In today's world, we are surrounded by data – from our class scores and house points to the daily sales at a local provisions store. Simply collecting this information is not enough; we need to understand it. Spreadsheet software gives us powerful tools called formulas and functions to analyse this data quickly and accurately. Instead of using a calculator to add up 50 numbers, we can do it in a second! This skill is essential not just for ICT, but for business, science, and even managing your own personal finances. Imagine being able to calculate your average grade, find your highest score, or even help a family member track their small business profits, all with a few clicks. This lesson will empower you to do just that.
Learning Objectives:
By the end of this lesson, you will be able to: