JHS3 Computing · Term 2, Week 10
Introduction to Electronic Spreadsheet
Full lesson notes coming
Notes for this lesson are being prepared. The curriculum details below are complete and ready to use for your planning.
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.