Introduction to Electronic… · JHS2 Computing

Lesson notes

Learning Objectives

Indicator: B8.2.4.1.3 - Demonstrate how to copy formulas and references

By the end of the lesson, learners can:

Copy and paste a formula from one cell to another in a spreadsheet and predict the result.
Explain the difference between relative and absolute cell references using the dollar sign ($) notation.
Apply relative and absolute referencing correctly when copying formulas across rows and columns.
Identify and correct common formula errors such as #DIV/0! and #REF!.
Use the fill handle to copy formulas quickly and complete a small project involving the simple interest formula.

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.3 - Demonstrate how to copy formulas and references
Suggested placement: Term 3, Week 1 (Week 25 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. Demonstrate the procedure for copying and pasting formulas in a worksheet.
2. Explore how to reference cells and ranges in a worksheet.
3. Demonstrate the use of relative and absolute cell referencing in creating formulas.
4. Explore how to correct common formula errors.
5. Complete a project that involves creating a set of formulas with common functions (e.g. simple interest formula)