Organising, Managing and Presenting… · SHS2 Ict

Lesson notes

Learning Objectives

Indicator: 2.1.1.LI.4 - Apply sorting and filtering operations to manipulate tables.

By the end of the lesson, learners can:

Define sorting and filtering and explain the difference between the two operations.
Apply ascending and descending sort orders to arrange numerical and textual data in a spreadsheet table.
Use filtering operations to display only the data subset that meets given criteria (for example, values above a certain amount or records matching a specific name).
Explain how sorting and filtering work together to help analyse data more effectively in a spreadsheet.
Demonstrate the correct steps for sorting and filtering a given data table on a spreadsheet application (or by writing step-by-step instructions, where devices are limited).

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: ICTs IN THE SOCIETY (Strand 1)
Sub-strand: Organising, Managing and Presenting Information Using Essential Productivity (1.1)
Content standard: 2.1.1.CS.1 - Demonstrate knowledge and understanding of Analysing numerical data using Spreadsheet software 2.1.1.LO.1 Utilise knowledge of Spreadsheet software to create functions for data analysis, interpret graphs and manipulate tables.
Indicator: 2.1.1.LI.4 - Apply sorting and filtering operations to manipulate tables.
Suggested placement: Semester 1, Week 4 (Week 4 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.
Source document note: The official curriculum document has a fault in this entry, so the curriculum text above is transcribed exactly as printed:

content standard text - p.48: the content-standard token is visibly printed `2.1.1.CS1`, which omits the separator before the final sequence; `2.1.1.CS.1` is used as the import code only to preserve the document's year/strand/sub-strand association
Curriculum reference: NaCCA curriculum document, p. 49

Exemplars (from the NaCCA curriculum)

Project-Based learning:
- Apply sorting operations (ascending, descending) to arrange data in tables effectively.
- Utilise filtering operations to display specific data subsets based on given criteria. reasoning
- Engage in project-based learning activities to practise and demonstrate the application of sorting and filtering operations in spreadsheet software.
Teaching and Learning Materials:
- Notepad or exercise book
- Pen
- Smartphones
- Laptops
- Desktop computers
- Tablets
- TV
- Radio
- Open Educational
- Resources (Including
- YouTube, MOOCs -
- Udemy/Coursera, Khan
- Academy, TESSA)
- The iBox (CENDLOS)
- Productivity tools
- Subject-based application software
- Instructional
- Laboratories (with multimedia equipment and smartboards)
- Maintenance and repair workshops
Assessment (2.1.1.AS.4). The document marks these depth-of-knowledge levels for this indicator: Level 3 Strategic reasoning.
Strategic