Introduction to Electronic… · JHS3 Computing

Lesson notes

Learning Objectives

Indicator: B9.2.4.1.2 - Demonstrate how to use styles, themes, templates and macros

By the end of the lesson, learners can:

Distinguish between a template and a macro, giving at least one example of each.
Create a new spreadsheet document from a predefined template in Microsoft Excel.
Apply a built-in style and a theme to a sample worksheet and explain the visible effect of each.
Record and run a simple macro (such as formatting a selected cell range) in Microsoft Excel.
Format a given dataset by applying styles and themes, and present the result to the class.

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: B9.2.4.1 - Demonstrate how to use spreadsheet (Advanced Operations)
Indicator: B9.2.4.1.2 - Demonstrate how to use styles, themes, templates and macros
Suggested placement: Term 2, Week 9 (Week 21 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. 49
Transcribed from the official NaCCA publication. Check this page against the source.

Exemplars (from the NaCCA curriculum)

1. Describe the difference between templates and macros.
2. Create new spreadsheet documents from predefined templates in MS Excel.
3. Demonstrate the use of styles and themes on sample worksheets.
4. Do a project on formatting a dataset by applying styles and themes.
5. Explore the use of macros.