Introduction to Electronic… · JHS2 Computing

Lesson notes

Indicator: B8.2.4.1.2 - Demonstrate how to create complex formulas

By the end of the lesson, learners can:

Identify the parts of a complex formula (operators, cell references, and constants) in a spreadsheet.
Create a formula to calculate percentages (e.g., percentage of total sales) using correct cell references.
Create a formula to calculate commission earned, given a sales amount and a commission rate.
Create a formula to calculate simple interest using the formula I = PRT/100.
Explain the order in which a spreadsheet performs calculations (BODMAS/BIDMAS) when a complex formula is entered.

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.4)
Content standard: B8.2.4.1 - Demonstrate How to Use the Spreadsheet (using functions and complex formulas)
Indicator: B8.2.4.1.2 - Demonstrate how to create complex 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. 32
Transcribed from the official NaCCA publication. Check this page against the source.

1. Create complex formulas (e.g. finding percentages, commissions, interest rates, etc.).