Lesson Notes By Weeks and Term v4 - JHS 3

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 an electronic spreadsheet and its importance.
• Identify key components like cells, rows, and columns.
• Create a simple spreadsheet to record data.
• Perform basic calculations using formulas and functions.
• Format a spreadsheet to make it clear and readable.

Lesson summary

Welcome, students! Today, we are starting a very exciting and useful topic: Electronic Spreadsheets. Imagine your exercise book, but a special one that can do maths for you, create charts, and organise information neatly. That is what a spreadsheet is! In Ghana, many people, from the woman selling provisions at the corner shop to big companies like MTN and cocoa farmers, use spreadsheets to manage their money and information. Learning this skill will be very valuable for your future studies and any job you do. We will be using Microsoft Excel as our main example, but the skills apply to other programs like Google Sheets and LibreOffice Calc.

Lesson notes

What is an Electronic Spreadsheet?

An electronic spreadsheet is a computer application used for organising, analysing, and storing data in a table format. Think of it as a grid of rows and columns. It is powerful because it can perform calculations automatically. Purpose/Uses: Calculating: Performing mathematical operations (addition, subtraction, etc.). Budgeting: Tracking income and expenses (e.g., managing your weekly "chop money"). Data Analysis: Organising data to find patterns (e.g., analysing students' test scores). Creating Charts: Visualising data with graphs and charts. Exploring the Spreadsheet Interface (Using MS Excel as an example)

When you open a spreadsheet program, you see a large grid. Let's break down its parts.

![A labelled diagram of the MS Excel interface would be drawn on the board here] Cell: This is the most basic unit of a spreadsheet. It is the small rectangular box where a row and a column meet. Each cell can hold data like text, a number, or a formula. **Cell Address (or Cell Reference) :** Every cell has a unique name, which is formed by combining its column letter and row number. *Example:* The cell where Column B and Row 4 meet is called B4. This is like a house address. Row: A row is a horizontal line of cells. Rows are identified by numbers (1, 2, 3, 4, ...). Column: A column is a vertical line of cells. Columns are identified by letters (A, B, C, D, ...). After Z, it continues with AA, AB, AC, and so on. Active Cell: This is the cell you are currently working in. It has a thick border around it. The data you type will appear in the active cell. Name Box: Located on the left side above the columns, this box displays the cell address of the active cell. You can also type a cell address here and press Enter to jump directly to that cell. Formula Bar: Located next to the Name Box, this bar shows the actual content of the active cell. If the cell contains a formula, you see the formula here, while the cell itself shows the result. If it contains text or a number, you see that text or number. Worksheet (or Sheet): This is the single grid of cells you are working on. You can have multiple worksheets in one file. They are represented by tabs at the bottom, usually named Sheet1, Sheet2, etc. You can rename them (e.g., "JHS3A Scores", "JHS3B Scores"). Workbook: This is the entire spreadsheet file. A workbook contains one or more worksheets. Think of the workbook as your entire exercise book, and each worksheet as a single page in that book. Entering and Editing Data