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
  1. Home
  2. Lesson Notes By Weeks and Term v4
  3. SHS 1
  4. ORGANISING, MANAGING AND PRESENTING INFORMATION USING ESSENTIAL PRODUCTIVITY

Subject: Ict

Class: SHS 1

Term: 2nd Term

Week: 9

Grade code: 2.1.1.LI.4

Strand code: 1

Sub-strand code: 1

Content standard code: 1.2.2.CS.1

Indicator code: 2.1.1.LI.4

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

Lesson summary

In our daily lives, we are surrounded by large amounts of information. Think about the register your form master uses, the list of items in a provision shop, or even the results from the BECE. Without a proper way to arrange this information, it can be very confusing and difficult to find what we need. This lesson introduces two powerful tools found in spreadsheet software like Microsoft Excel or Google Sheets: Sorting and Filtering. These tools help us arrange data in a meaningful order and find specific pieces of information quickly.

Lesson notes

Before we learn about sorting and filtering, let's understand the structure we'll be working with: a table of data in a spreadsheet. Table/Dataset: A collection of related data organised in rows and columns. Column: A vertical set of cells, usually representing a specific type of information (e.g., 'Student Name', 'Age', 'ICT Score'). The top cell of a column is the Header. Row: A horizontal set of cells, representing a single record or entry (e.g., all the information for one student).

Example Table: SHS1 Students' Mock Scores

| Student Name | House | Region | ICT Score | Maths Score | | :--- | :--- | :--- | :--- | :--- | | Ama Serwaa | Aggrey | Ashanti | 78 | 85 | | Kofi Mensah | Sarbah | Central | 92 | 77 | | Esi Parker | Guggisberg | Western | 65 | 70 | | Yaw Boakye | Aggrey | Ashanti | 88 | 91 | | Fati Adamu | Sarbah | Northern | 78 | 68 |

Concept 1: Sorting

Evaluation guide