Protected Preview

Computing · B8

Term 3 · Week 4 · 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, 08 May 2026 Backdated

Week & Term

Week 4 · Term 3

Class Teacher

Kassim Abdul-Ganiu

Subject

Computing

Class

JHS 2 (B8)

Class Size

Duration

60 mins

Week No.

Week 4

Strand

2. Productivity Software

Sub-Strand

4. Introduction to Electronic Spreadsheet

Content Standard & Indicators

B8.2.4.1.1 B8.2.4.1.2

Content Standard

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

Indicator 1 B8.2.4.1.1

Perform operations using functions and Built-in functions

Indicator 2 B8.2.4.1.2

Demonstrate how to create complex formulas

Performance Indicator

Learners will identify the difference between formulas and functions in a spreadsheet by classifying given examples into two categories.

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 05 May 2026	1Identify the difference between formulas and functions in spreadsheet applications 2Display on the projector two calculations written as: =2+3*4 and =SUM(A1:A5); ask learners to whisper which one they think is a formula and which is a function	UNDERSTANDING FORMULAS VS. FUNCTIONS 1Open MS-Excel on the computer and project onto the screen using the projector; write =B3+C3 in cell A1 and explain: this is a formula—it uses mathematical operators (+, −, *, /) to do simple calculations 2Now type =SUM(B3:C3) in cell B1 on the same spreadsheet; explain: this is a function—it is a built-in tool that Excel already knows how to use to add numbers automatically 3Provide the textbook definition: a formula is any calculation you write yourself using operators; a function is a pre-built command that performs specific operations on data when you type its name and data range	1Computer/Laptop 2Projector 3Textbook 4MS-Excel	1Display four spreadsheet expressions on the projector and ask learners to hold up one finger if it is a formula or two fingers if it is a function: =A1+A2, =AVERAGE(B1:B10), =C5*2, =COUNT(D1:D20) 2Ask the learner who finished first to come to the board and circle all the functions they identified; the class confirms by showing thumbs up or down Exercise 1Write in your exercise book: Is =MAX(5,10,15) a formula or a function? Give one reason for your answer
Thu 07 May 2026	1Recall the structure of spreadsheet formulas and identify the components needed to build complex calculations 2Display on projector: =A1+B1 and =A1*B1. Ask learners to whisper to their partner which operation each formula performs	CREATING COMPLEX FORMULAS FOR PERCENTAGES, COMMISSIONS, AND INTEREST RATES 1Open MS-Excel on laptop connected to projector. Type: A1=5000 (principal amount), B1=0.05 (interest rate 5%), C1==A1B1 (formula for simple interest). Ask: What will cell C1 show? Learners write answer in exercise books, then volunteer reads aloud. Confirm: 250 (GH₵250 interest) 2Create second example on spreadsheet: Ama sold goods worth GH₵2000 and earns 10% commission. Type A2=2000, B2=0.10, C2==A2B2. Learners calculate in books first, then check against projector result (GH₵200 commission) 3Provide third task: Kwame's capital is GH₵1500 at 8% yearly interest. Learners write the complete formula =1500*0.08 in their exercise books, then type it into a spreadsheet cell using the laptop at their desk and share the result with their pair	1Computer/Laptop 2Projector 3Textbook 4Exercise books	1Ask one representative from each group to state one component of a complex formula they used today (cell reference, operator, function) 2Learners hold up their exercise books showing their three completed formulas while teacher checks accuracy with a thumbs-up signal Exercise 1Write the formula to calculate 15% of GH₵8000 and state the expected result 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.