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

Lesson notes

Learning Objectives

Indicator: B7.2.3.2.3 - Demonstrate the use of the Autofill function in MS-Excel worksheet

By the end of the lesson, learners can:

Explain what the Autofill function is and when to use it in an Excel worksheet.
Demonstrate how to use the fill handle to generate a series of numbers, including counting numbers and odd numbers.
Demonstrate how to use Autofill to generate the days of the week and months of the year.
Use the Autofill function to generate a multiplication table (e.g. the 3-times table).
Identify the difference between copying a formula with Autofill and filling a simple data series.

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.3)
Content standard: B7.2.3.2 - Demonstrate how to format a worksheet
Indicator: B7.2.3.2.3 - Demonstrate the use of the Autofill function in MS-Excel worksheet
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.

Exemplars (from the NaCCA curriculum)

1. Demonstrate the use of the Autofill function e.g. to generate the days of the week, months of the year, set of numbers (e.g. counting numbers, odd numbers, multiplication tables etc.).