Class: Senior Secondary School 1 (SSS 1)
Term: 3rd Term
Week: 5
Age: 15 years
Duration: 45 minutes
Subject: Data Processing
Curriculum Theme: Technology
Previous Lesson: Managing Data in Spreadsheet: References, Sort and Filter.
Topic: Managing Data in Spreadsheets: Sorting and Filtering Data
Subject Matter: Sorting data in ascending order, sorting data in descending order, filtering data using auto filter, filtering data using custom filter.

Specific Objectives

By the end of the lesson, pupils should be able to:

Cognitive Domain:

Define sorting and filtering data in a spreadsheet.
State the purpose of sorting data in ascending and descending order.
Explain the difference between auto filter and custom filter.

Affective Domain:

Appreciate the importance of organizing data for better analysis.
Follow instructions when sorting and filtering data.
Pay attention to detail while performing data management tasks.

Psychomotor Domain:

Sort a given dataset in a spreadsheet in ascending order.
Sort a given dataset in a spreadsheet in descending order.
Filter a dataset using the auto filter feature.
Filter a dataset using the custom filter feature.

Collaborate with peers to solve data sorting and filtering problems.
Share ideas on the best methods for organizing data.

Reference Materials

The following resources were used in planning this lesson:

9 Years Basic Education Curriculum for Data Processing.
State Unified Scheme of Work for Data Processing.
Akinwumi, S. A. (2018). Comprehensive Data Processing for Senior Secondary Schools. Ibadan: University Press PLC.

Instructional Materials

The teacher will teach this lesson with the aid of:

A computer set with Microsoft Excel software installed.
Sample tables/datasets for sorting and filtering.
A projector (optional) for screen display.

Rationale for the Lesson

This lesson helps pupils learn how to organize and find specific information within large datasets efficiently. Understanding sorting and filtering is important for managing daily information, making data easier to understand and use.

Prerequisite/Previous Knowledge

Pupils should have basic knowledge of creating and entering data into spreadsheets.

Lesson Content/Board Summary

Managing Data in Spreadsheets: Sorting and Filtering

Sorting Data

Sorting data refers to arranging data in a specific order, either alphabetically, numerically, or by date. This helps in organizing data for easier analysis and retrieval.

There are two main types of sorting:

Ascending Order: Arranges data from smallest to largest (A-Z, 0-9, oldest to newest).
Descending Order: Arranges data from largest to smallest (Z-A, 9-0, newest to oldest).

Steps to Sort Data in Microsoft Excel

The general steps to sort data are:

Select the range of cells you want to sort.
Go to the ‘Data’ tab on the ribbon.
Click on ‘Sort & Filter’ group.
Choose ‘Sort A to Z’ for ascending or ‘Sort Z to A’ for descending.
For more options, click ‘Sort’ to open the Sort dialog box and specify criteria.

Filtering Data

Filtering data means displaying only the rows that meet certain criteria and hiding the rows that do not. This allows users to focus on specific data subsets.

Types of filtering include:

Auto Filter: A quick way to filter data based on values in one or more columns using dropdown arrows.
Custom Filter: Allows for more complex filtering criteria using logical operators (e.g., greater than, less than, equals, contains).

Steps to Filter Data in Microsoft Excel

The general steps to filter data are:

Select any cell within the dataset you want to filter.
Go to the ‘Data’ tab on the ribbon.
Click on ‘Filter’ in the ‘Sort & Filter’ group. Dropdown arrows will appear in the header row.
Click the dropdown arrow in the column you want to filter.
For Auto Filter: Select or deselect values from the list.
For Custom Filter: Choose ‘Number Filters’ or ‘Text Filters’ and then select ‘Custom Filter’ to set specific conditions.

Teaching Methods/Instructional Techniques

Discussion, Lecture, Demonstration, Question and Answer, Visual Aids

Instructional Procedures

Step 1: Introduction

Time: 5 minutes
Teaching Skill: Set Induction
Teacher’s Activity: The teacher greets the pupils and asks them how they organize their school notes or books. The teacher then introduces the topic by explaining that just as they arrange their notes, data in computers can also be organized for easy use.
Pupils’ Activity: Pupils respond to the teacher’s questions and listen attentively.
Learning Point: Pupils are introduced to the concept of data organization.

Step 2: Explanation of Sorting Data

Time: 10 minutes
Teaching Skill: Explanation/Lecture
Teacher’s Activity: The teacher defines sorting data, explains its purpose, and differentiates between ascending and descending order using real-life examples (e.g., student names alphabetically, scores from highest to lowest). The teacher projects a sample dataset on the screen.
Pupils’ Activity: Pupils listen, take notes, and ask questions for clarity.
Learning Point: Pupils understand the definition and types of data sorting.

Step 3: Demonstration of Sorting

Time: 5 minutes
Teaching Skill: Demonstration
Teacher’s Activity: The teacher demonstrates how to sort the projected sample dataset in Microsoft Excel, first in ascending order and then in descending order, explaining each step clearly.
Pupils’ Activity: Pupils observe the demonstration carefully and ask relevant questions.
Learning Point: Pupils see how to perform data sorting in practice.

Step 4: Explanation of Filtering Data

Time: 5 minutes
Teaching Skill: Explanation/Lecture
Teacher’s Activity: The teacher defines filtering data and explains its purpose. The teacher then explains the difference between auto filter and custom filter, giving examples of scenarios where each would be used.
Pupils’ Activity: Pupils listen and take notes.
Learning Point: Pupils understand the definition and types of data filtering.

Step 5: Demonstration of Filtering

Time: 5 minutes
Teaching Skill: Demonstration
Teacher’s Activity: The teacher demonstrates how to apply auto filter and custom filter to the sample dataset in Microsoft Excel, showing how to display specific data based on criteria.
Pupils’ Activity: Pupils observe the demonstration and ask questions.
Learning Point: Pupils see how to perform data filtering in practice.

Step 6: Guided Practice

Time: 5 minutes
Teaching Skill: Practical Application
Teacher’s Activity: The teacher provides pupils with a simple dataset and guides them to practice sorting and filtering data on their individual computers or in pairs, providing assistance as needed.
Pupils’ Activity: Pupils practice sorting and filtering data as guided by the teacher.
Learning Point: Pupils apply the learned skills practically.

Step 7: Evaluation/Review

Time: 5 minutes

Teaching Skill: Questioning/Assessment

Teacher’s Activity: The teacher evaluates the learning by asking the following questions:

Define sorting data.
Mention two types of data sorting.
What is data filtering?
State one difference between auto filter and custom filter.

Pupils’ Activity: Pupils answer orally and in writing.

Learning Point: Pupils demonstrate understanding of the lesson.

Step 8: Conclusion

Time: 5 minutes
Teaching Skill: Summarization
Teacher’s Activity: The teacher summarizes the key points of the lesson, emphasizing the importance of sorting and filtering for efficient data management. The teacher assigns homework: pupils should create a simple student record in Excel and practice sorting by name and filtering by gender.
Pupils’ Activity: Pupils listen to the summary and copy down the homework.
Learning Point: Pupils consolidate their understanding and are given tasks to reinforce learning.

Lesson Keywords

Sorting – Arranging data in a specific order (ascending or descending).
Filtering – Displaying only data that meets certain criteria and hiding the rest.
Ascending Order – Arranging data from smallest to largest (e.g., A-Z, 0-9).
Descending Order – Arranging data from largest to smallest (e.g., Z-A, 9-0).
Auto Filter – A quick way to filter data using dropdown menus in column headers.
Custom Filter – Filtering data using specific conditions and logical operators.

Differentiation

For pupils who grasp the concepts quickly, the teacher can provide more complex datasets or challenge them to apply multiple sorting levels or advanced custom filter conditions. For pupils who need more support, the teacher can provide simpler datasets, offer one-on-one guidance during practice, or pair them with a peer for collaborative learning.

Note for teachers using this lesson plan

Ensure that each pupil has access to a computer with Microsoft Excel for the practical sessions. If individual computers are not available, group pupils and use a projector for clear demonstrations. Encourage pupils to experiment with different sorting and filtering options to build confidence.