Lesson Notes By Weeks and Term v4 - SHS 1

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

• Describe key features like workbooks, worksheets, and cells.
• Create and format a basic spreadsheet.
• Use simple formulas for calculations.
• Present data using charts.

Lesson summary

In today's world, we are surrounded by information, especially numbers—from the prices of items at the market to our own class scores. Manually calculating and organising this data can be difficult and time-consuming. Spreadsheet software is a powerful digital tool that helps us organise, calculate, and analyse numerical data efficiently. For a Ghanaian student, learning this skill is essential for managing personal finances (like "chop money"), excelling in academic projects, and preparing for future careers in business, science, and many other fields. This lesson introduces the fundamental building blocks of spreadsheet software, setting the stage for more advanced data analysis.

Lesson notes

This section breaks down the essential ideas you need to understand spreadsheet software. We will use Microsoft Excel as our primary example, but these concepts also apply to other software like Google Sheets. a. What is a Spreadsheet? A spreadsheet is a computer application used to store, organise, and analyse data in a table format. Think of it as a digital version of a large accounting ledger or a mathematics exercise book with a grid of boxes. Its main power lies in its ability to perform calculations automatically. b. The Structure of a Spreadsheet File When you open a spreadsheet program, you are working with a file that has a specific structure, like a book. Workbook: The workbook is the entire spreadsheet file. It is like a complete exercise book or a folder that contains all your work on a particular project. When you save your work in Excel, you are saving the entire workbook (e.g., `MyClassBudget.xlsx`). Worksheet (or Sheet): A worksheet is a single page or a single "sheet" within the workbook. A workbook can contain many worksheets. Think of the tabs at the bottom of the screen as the pages of your exercise book. You can have a sheet for "Term 1 Scores," another for "Term 2 Scores," and a third for "Term 3 Scores," all within the same workbook called "My ICT Class." You can add, rename, or delete sheets as needed. *Analogy:* Workbook = Exercise Book, Worksheet = A Page in the Book.

*(Teacher can draw this on the board)* c. The Worksheet Grid: The Building Blocks Each worksheet is a large grid made up of the following: Columns: These are the vertical divisions of the worksheet. They are identified by letters at the top (A, B, C, ... AA, AB, etc.). Rows: These are the horizontal divisions of the worksheet. They are identified by numbers on the left side (1, 2, 3, ...). Cell: A cell is the most basic unit of a worksheet. It is the small rectangular box formed by the intersection of a column and a row. Every piece of data you enter—whether it's text, a number, or a formula—is placed inside a cell. d. Cell Referencing: The Address System Every cell on a worksheet has a unique address, called a cell reference or cell address. This is how the software knows exactly which cell you are talking about. How it works: The cell reference is formed by combining the column letter and the row number. Example: The cell at the intersection of Column C and Row 5 has the cell reference C5. The very first cell at the top-left corner is A1.

This address system is crucial for creating formulas. For example, instead of telling the computer to "add the number in the first box to the number in the second box," you can simply write a formula like `=A1+A2`. e. Key Interface Elements

When you look at a worksheet, you will see these important components: Name Box: Located on the top-left, just above the columns. It displays the cell reference of the *active cell* (the cell you have currently selected). You can also type a cell address in the name box and press Enter to jump directly to that cell. Formula Bar: Located next to the name box. It shows the actual content of the active cell. If the cell contains a simple value (like the number `50` or the text "Ama"), the formula bar will show that value. If the cell contains a formula (like `=B2+C2`), the cell itself will show the calculated result (e.g., `95`), but the formula bar will show you the actual formula (`=B2+C2`). This allows you to see and edit your calculations.

Evaluation guide

• Demonstrate knowledge and
• understanding of Analysing
• numerical data using
• Spreadsheet software Describe Spreadsheet software workbooks, worksheets, cell referencing