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

• Explain the difference between formulas and functions.
• Access and use built-in spreadsheet functions.
• Demonstrate common functions like SUM, AVERAGE, and COUNT.
• Apply spreadsheet functions to solve simple problems.

Lesson summary

In our daily lives, from the market woman calculating her daily sales to a student tracking their test scores, we deal with numbers and calculations. Doing these by hand or with a basic calculator can be slow and prone to errors, especially with lots of data. Electronic spreadsheets, like Microsoft Excel or Google Sheets, are powerful tools that help us organise, calculate, and analyse data quickly and accurately. Today, we will learn how to unlock the "magic" of spreadsheets by using built-in functions to perform calculations automatically, saving us time and effort.

Lesson notes

This section explains the core ideas for today's lesson. We will use a sample dataset of a student's end-of-term scores to illustrate these concepts.

Sample Data: Adwoa's Term 1 Scores

| | A | B | |---|---|---| | 1| Subject | Score (/100) | | 2| English Language | 85 | | 3| Mathematics | 92 | | 4| Integrated Science| 78 | | 5| Social Studies | 88 | | 6| R.M.E. | 95 | | 7| B.D.T. | | | 8| Ghanaian Language| 81 | Concept 1: The Difference Between Formulas and Functions

In a spreadsheet, both formulas and functions are used to perform calculations. However, they are not the same.

Evaluation guide

• Enumerate the difference between formulas and functions.
• Access built-in functions to perform operations on sample data.
• Demonstrate the use of common spreadsheet functions such as SUM,
• AVERAGE, COUNT, COUNTA, COUNTIF, MAX and MIN. DL5.1: Ability to ascertain when