Introduction to Electronic… · JHS3 Computing

Lesson notes

Learning Objectives

Indicator: B9.2.4.1.1 - Perform data filtering, sorting and validation

By the end of the lesson, learners can:

Distinguish between fields (columns), records (rows), and structured versus unstructured tables, giving examples of each.
Construct a structured data table of class members with at least five fields, including Surname, First name, Date of Birth, Sex, Home Town, and Region.
Apply validation rules, including creating a drop-down validation list for the Sex column, to prevent incorrect data entry.
Sort data in ascending and descending alphabetical order and explain when each is useful.
Filter data to display only selected records that meet a specific condition.

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.1 - Perform data filtering, sorting and validation
Suggested placement: Term 2, Week 8 (Week 20 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. 48
Transcribed from the official NaCCA publication. Check this page against the source.

Exemplars (from the NaCCA curriculum)

1. Describe Fields (columns), Records (rows) and Tables (structured/unstructured).
2. Illustrate examples of structured and unstructured tables.
3. Construct a structured data table of class members (e.g. data table may have the following fields: Surname, First name, Date of Birth, Sex, Home Town, Region, etc).
4. Apply validation rules to check for errors.
5. Convert data tables to a list in MS Excel.
6. Demonstrate the process of entering data to a list.
7. Demonstrate the use of validation list in the Sex column (in Exemplar(s): 3) to provide options in a drop-down for data entry.
8. Demonstrate how to sort data in alphabetical order (ascending/descending) and filter data to display only selected data.