Lesson Notes By Weeks and Term v4 - JHS 2

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

• Demonstrate how to copy and paste formulas.
• Explain the difference between relative and absolute cell references.
• Create formulas using both relative and absolute references.
• Identify and correct common formula errors.
• Apply these skills to a simple interest formula project.

Lesson summary

Welcome, learners! In our last lesson, we learned how to write basic formulas to perform calculations in a spreadsheet. Today, we will learn a powerful trick that saves a lot of time and effort: how to copy formulas. Imagine you are a shopkeeper with 100 items. Would you type the formula to calculate the total price for each of the 100 items one by one? No! That would be tiring and you might make mistakes. Spreadsheets are smart enough to help us do this with just one click. We will learn how to make the spreadsheet work for us by understanding how it handles cell references when we copy formulas.

Lesson notes

A. Review: What is a Formula? A formula is an instruction we give to the spreadsheet to perform a calculation. It always begins with an equals sign (`=`). It uses cell references (e.g., `A1`, `B2`) to get the values for the calculation. It uses mathematical operators like `+` (add), `-` (subtract), `*` (multiply), and `/` (divide). Example: `=A2 * B2` tells the spreadsheet to multiply the value in cell A2 by the value in cell B2. B. Copying Formulas with the Fill Handle (Relative Referencing)

This is the most common and fastest way to copy a formula. Imagine we have a small tuck shop list.

| | A | B | C | D | | :--- | :--- | :--- | :--- | :--- | | 1 | Item | Quantity | Price (GHS) | Total Cost (GHS) | | 2 | Kalypo | 3 | 1.50 | | | 3 | Meat Pie | 2 | 3.00 | | | 4 | Bofrot | 5 | 0.50 | | | 5 | Water | 1 | 2.00 | |

To calculate the Total Cost for Kalypo, we would type this formula in cell D2: `=B2 * C2` After pressing Enter, D2 will show `4.50`.

Evaluation guide

• Demonstrate the procedure for copying and pasting formulas in a
• worksheet.
• Explore how to reference cells and ranges in a worksheet.
• Demonstrate the use of relative and absolute cell referencing in creating