JHS1 Computing · Term 2 Week 12: Introduction to Electronic Spreadsheet

Lesson notes

Indicator: B7.2.3.3.1 - Demonstrate how to create formulas

By the end of the lesson, learners can:

Identify the equal sign (=) as the required starting character for every formula in a spreadsheet.
Create simple arithmetic formulas using addition (+), subtraction (−), multiplication (×), and division (÷) operators in a spreadsheet.
Write formulas using cell references (e.g., =A1+A2) rather than typing numbers directly.
Demonstrate how to enter a formula into a cell and verify the displayed result.
Explain how spreadsheets recalculate results automatically when the values in referenced cells change.

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

Strand: Productivity Software (Strand 2)
Sub-strand: Introduction to Electronic Spreadsheet (2.3)
Content standard: B7.2.3.3 - Demonstrate how to use spreadsheet formula
Indicator: B7.2.3.3.1 - Demonstrate how to create formulas
Suggested placement: Term 2, Week 12 (Week 24 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. 15
Transcribed from the official NaCCA publication. Check this page against the source.

1. Create simple formulas starting with the equal sign (=)