Introduction to Electronic… · JHS3 Computing

Lesson notes

Learning Objectives

Indicator: B9.2.4.1.3 - Demonstrate the use of data tables, pivot tables, charts and pivot charts

By the end of the lesson, learners can:

Define a data table and a pivot table and explain the difference between them.
Create a pivot table from a given dataset to summarise information, such as counting males and females in the class.
Use the sort and filter features of a pivot table to rearrange and narrow down data summaries.
Insert a pivot chart from a pivot table to visually display data, such as a bar chart of male and female counts.
Interpret a pivot chart and state at least one conclusion drawn from the displayed summary.

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.3 - Demonstrate the use of data tables, pivot tables, charts and pivot charts
Suggested placement: Term 2, Week 10 (Week 22 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. Explore pivot tables and charts.
2. Explore the use of a pivot table to display a summary of the dataset (refer to indicator B9.2.4.1.1).
3. Insert a pivot chart to display the number of males and females in the class.
4. Demonstrate the use of the sort and filter features of the pivot table.