Protected Preview

Computing · B8

Term 3 · Week 5 · 2.00 credits · GHS 1.00

This preview is shortened and watermarked. Unlock it to get the clean note and export options.

Back to Marketplace Sign in to Download Create Account to Edit

Lesson Note - Computing

ANA CENTRAL JHS

Weekly Lesson Plan

JHS 2 (B8) · Term 3

Computing

Lesson 1 of 1

Week Ending

Friday, 15 May 2026 Backdated

Week & Term

Week 5 · Term 3

Class Teacher

Kassim Abdul-Ganiu

Subject

Computing

Class

JHS 2 (B8)

Class Size

Duration

60 mins

Week No.

Week 5

Strand

2. Productivity Software

Sub-Strand

4. Introduction to Electronic Spreadsheet

Content Standard & Indicators

B8.2.4.1.2 B8.2.4.1.3

Content Standard

Demonstrate How to Use the Spreadsheet (using functions and complex formulas)

Indicator 1 B8.2.4.1.2

Demonstrate how to create complex formulas

Indicator 2 B8.2.4.1.3

Demonstrate how to copy formulas and references

Performance Indicator

Learners will identify and explain the structure of spreadsheet formulas used in calculating percentages, commissions, and interest rates.

Core Competencies

Key Words

Teaching / Learning Resources (TLR)

References

Lesson Activities by Day

Date	Phase 1: Starter (7 mins) Preparing the brain	Phase 2: Main (20 mins) New learning + assessment	Resources	Phase 3: Plenary (6 mins) Reflection + exercise
Tue 12 May 2026	1Identify the basic components of spreadsheet formulas and their purpose in calculations 2Display on projector: =A1*B1. Ask: What do you think this formula does? Learners write their guess in exercise books	UNDERSTANDING COMPLEX FORMULAS FOR PERCENTAGE, COMMISSION, AND INTEREST RATE CALCULATIONS 1Write on board: Ama bought items at Makola Market for GH₵200. The percentage profit is 15%. Using the formula =A1(1+B1/100), show learners how this calculates final price. Open the textbook and Computer/Laptop with projector to display the formula in a spreadsheet cell. Ask: Which part of the formula finds 15 percent? 2Type the formula =5000.10 on the projected screen. Explain: This calculates 10% commission on GH₵500 sales. Ask learners to write both formulas in their exercise books and label each part (cell reference, operator, percentage value) 3Guide learners to open the Learners Resource Pack section on spreadsheet functions. Select a learner who finished early to read aloud one real example using commission or interest rate from the pack	1Computer/Laptop 2Projector 3Textbook 4Learners Resource Pack	1Ask pairs to compare the two formulas from the main activity and whisper one difference to their partner 2Invite one representative from each group to state aloud which formula they would use to calculate interest on a loan of GH₵5000 at 8% per year Exercise 1Write the formula that calculates 20% interest on GH₵1000, and identify which part represents the interest rate in their exercise books.
Thu 14 May 2026	1Recall the difference between relative and absolute cell references in spreadsheet formulas 2Display on projector: two cells showing =A1+B1 and =A2+B1 side by side; ask learners to name which cell reference stays the same when copied	COPYING FORMULAS AND USING CELL REFERENCES 1Open the Computer/Laptop and projector to display a sample spreadsheet: Makola Market vegetable prices (Tomato GH₵2.50, Pepper GH₵1.80, Onion GH₵3.00 in column A rows 2–4; quantities in column B); write formula =A2B2 in cell C2; demonstrate copying the formula down to C3 and C4 to show relative references auto-adjust (A3B3, A4*B4) 2Ask learners to identify aloud which cell references changed and which stayed the same after copying; confirm that relative references update automatically when pasted. Use Computer/Laptop during the task 3Guide learners through a second example: Kofi's market budget of GH₵100 (fixed in cell D1); write =D$1-C2 in cell E2 and copy down to E3, E4 to show how the $ locks the row (absolute reference); learners observe that D1 never changes but C2 becomes C3, C4. Use Computer/Laptop during the task	1Computer/Laptop 2Projector 3Textbook 4Internet connection	1One representative from each pair writes on the board whether the formula they were assigned uses relative or absolute references; class votes thumbs up or down 2Learners compare their copied formulas with the person sitting next to them and check if cell references updated correctly Exercise 1Open a new spreadsheet on the Computer and write a formula in cell A1 that multiplies the price in B1 (GH₵5) by the quantity in B2; copy the formula down one row and state whether the cell references are relative or absolute and why in their exercise books.

Class Teacher

Kassim Abdul-Ganiu

Head Teacher

Signature & Date

SISO / Circuit Supervisor

Signature & Date

Preview ends here

Unlock the full lesson note

Use 2.00 credits (GHS 1.00) to unlock a PDF or save an editable copy in My Notes.