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: 8
Grade code: 2.1.1.LI.3
Strand code: 1
Sub-strand code: 1
Content standard code: 1.2.2.CS.1
Indicator code: 2.1.1.LI.3
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 today's world, we are surrounded by information, often in the form of numbers (data). Looking at a long list of numbers, like the scores of all students in an exam, can be confusing. Graphs and charts are powerful tools that help us turn this confusing data into a clear picture. They help us see patterns, compare values, and understand information quickly. This skill is not just for ICT class; it is essential for business, science, and even for understanding news reports about Ghana's economy or election results. In this lesson, we will learn how to use spreadsheet software (like Microsoft Excel) to create and understand the most common types of charts.
A. What is Data Visualisation?
Data visualisation is the practice of representing information and data in a graphical format. Think of it as telling a story with pictures instead of just words and numbers. When you see a table of numbers, your brain has to work hard to understand it. When you see a chart, your brain can quickly grasp the main message. Data: Raw, unorganised facts and figures. E.g., `15, 25, 12, 30`. Information: Data that has been organised and given context to make it meaningful. E.g., "Sales of Kenkey in Madina Market: Monday - 15 balls, Tuesday - 25 balls, Wednesday - 12 balls, Thursday - 30 balls." Visualisation: A chart or graph that shows this information, making it easy to see that Tuesday and Thursday were the best sales days. B. Common Types of Charts and Their Uses
It is important to choose the right type of chart for your data. Using the wrong chart can be confusing or misleading.
| Chart Type | Description | Best Used For... | Ghanaian Example | | :--- | :--- | :--- | :--- | | Bar Chart | Uses rectangular bars (vertical or horizontal) to represent data. The length of the bar is proportional to the value it represents. | Comparing quantities across different categories. | Comparing the number of students from different regions in your school (Ashanti, Greater Accra, Volta, etc.). | | Pie Chart | A circular chart divided into slices. Each slice represents a part or percentage of a whole. The total of all slices is always 100%. | Showing the composition or proportion of a whole. | Showing how a student spends their weekly pocket money (transport, food, airtime, savings). | | Line Graph | Uses points connected by lines to show how values change over a period of time. | Tracking trends, changes, or patterns over time. | Showing the change in the price of a bag of maize in Ghana over 12 months. | C. How to Create Charts in Spreadsheet Software (e.g., Microsoft Excel)