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: 5
Grade code: 2.1.1.LI.1
Strand code: 1
Sub-strand code: 1
Content standard code: 1.2.2.CS.1
Indicator code: 2.1.1.LI.1
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 in Ghana, we handle numbers and information all the time. Think about a market woman tracking her daily sales, a class prefect keeping a list of students' scores, or a family budgeting for monthly expenses like electricity bills and trotro fare. Doing this with a pen and paper can be slow and prone to errors. Spreadsheet software is a powerful computer application that helps us organise, calculate, and analyse this kind of numerical data easily and accurately. Today, we will learn the basic building blocks of this important tool.
This section is the core content for the lesson. It should be delivered using a mix of direct instruction, whole-class discussion, and demonstration using the projector. What is a Spreadsheet?
A spreadsheet is a computer application used for organizing, analysing, and storing data in a table format. Think of it as a digital version of an accountant's ledger or a mathematics graph book. It is made up of a grid of rows and columns. Purpose: Its main job is to work with numbers. We can use it to perform calculations (from simple addition to complex formulas), create charts and graphs, and manage large sets of data. Examples of Spreadsheet Software: Microsoft Excel, Google Sheets, LibreOffice Calc. We will primarily use Microsoft Excel for our examples. The Main Components of a Spreadsheet a) The Workbook
The workbook is the entire spreadsheet file. When you open Microsoft Excel and save your work, you are saving a workbook. Analogy: Think of a workbook as a complete exercise book or a file folder. The file itself, for example, `SHS1_Class_Scores.xlsx`, is the workbook. It can contain one or more worksheets. b) The Worksheet (or Sheet)
A worksheet is a single page or sheet within a workbook. By default, most spreadsheet programs open with one or three worksheets. Analogy: If the workbook is the exercise book, then a worksheet is a single page inside that book. You can see tabs at the bottom of the screen, usually named `Sheet1`, `Sheet2`, etc. You can add, delete, and rename these sheets to make your work organised. For example, in a workbook for a small provisions shop, you could have worksheets named `January Sales`, `February Sales`, `Stock`, etc.