JHS2 Computing · Term 2 Week 11: Introduction to Electronic Spreadsheet

Lesson notes

Learning Objectives

Indicator: B8.2.4.1.1 - Perform operations using functions and Built-in functions

By the end of the lesson, learners can:

State the difference between a formula and a function in a spreadsheet.
Identify the parts of a function, including the equal sign, function name and arguments.
Use built-in functions such as SUM, AVERAGE, COUNT, COUNTA, COUNTIF, MAX and MIN to perform operations on sample data.
Select the appropriate function for a given data-handling problem.
Enter a function manually and through the Function Wizard or built-in function dialogue box.

Sign in with your phone number to read the full note and download the GES plan - free.

Sign in with phone number

Curriculum details

Strand: Productivity Software (Strand 2)
Sub-strand: Introduction to Electronic Spreadsheet (2.4)
Content standard: B8.2.4.1 - Demonstrate How to Use the Spreadsheet (using functions and complex formulas)
Indicator: B8.2.4.1.1 - Perform operations using functions and Built-in functions
Suggested placement: Term 2, Week 11 (Week 23 of the year)
Our suggestion, laid out in curriculum order across three terms of twelve weeks. NaCCA does not fix the week, so follow your school's scheme of learning.
Curriculum reference: Computing, Common Core Programme (JHS1-JHS3), 2023, p. 32
Transcribed from the official NaCCA publication. Check this page against the source.

Exemplars (from the NaCCA curriculum)

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