Lesson Notes By Weeks and Term v4 - JHS 1

INTRODUCTION TO ELECTRONIC SPREADSHEET

Download the Lessonotes Mobile Ghana app for faster lesson access on Android and iPhone.

Get it on Google Play
Get it on the Apple App Store
  1. Home
  2. Lesson Notes By Weeks and Term v4
  3. JHS 1
  4. INTRODUCTION TO ELECTRONIC SPREADSHEET

Subject: Computing

Class: JHS 1

Term: 2nd Term

Week: 9

Grade code: B7.2.3.3.1

Strand code: 2

Sub-strand code: 3

Content standard code: B7.2.3.2

Indicator code: B7.2.3.3.1

Theme: PRODUCTIVITY SOFTWARE

Subtheme: INTRODUCTION TO ELECTRONIC SPREADSHEET

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

Lesson summary

This lesson introduces one of the most powerful features of electronic spreadsheets: formulas. Spreadsheets are not just for typing in lists of words and numbers; they are powerful calculators. By learning how to create formulas, we can command the computer to perform calculations for us automatically, saving us time and reducing mistakes. This is a skill used everywhere in Ghana, from the woman selling tomatoes in the market to keep track of her sales, to the headteacher calculating students' report card averages, to a family planning its monthly budget. Mastering formulas turns a simple table of data into a dynamic tool for solving problems.

Lesson notes

What is a Formula?

A formula is a special instruction we give to a spreadsheet application (like Microsoft Excel or Google Sheets) to perform a calculation. Think of it as a mathematical sentence that the computer understands. Instead of you using a calculator and then typing the answer, you tell the spreadsheet *how* to find the answer, and it does the work for you.

The most important advantage of using a formula is that it is dynamic. This means if you change the numbers in the cells used by the formula, the formula's result will automatically update. The Golden Rule of Formulas

In any spreadsheet program, there is one rule you must never forget:

Evaluation guide