CLASS OBJECTIVE
Apply sorting, filtering, and basic functions (SUMA, PROMEDIO, MIN, MAX, COUNT, COUNTA and COUNTBLANK) together to organize and analyze simple data efficiently in a spreadsheet.
⸻
🗓
CLASS AGENDA
💬 Introduction
“Imagine you have a list of grades, expenses, or attendance.
What if you could organize it, see only what you need, and calculate everything automatically?”
1️⃣ Short Review
Students recall:
What sorting does (change order).
What filtering does (show specific data).
What functions do (calculate or count automatically).
Teacher reminds:
📌 Spreadsheets are powerful when you combine tools.
2️⃣ Explanation: Working With Data Step by Step
Teacher explains the correct order:
Organize data (clear table with headers).
Sort data (A–Z, highest to lowest).
Filter data (show only what you need).
Apply functions to analyze results.
Simple examples:
Sort grades from highest to lowest.
Filter only “Passed” students.
Use PROMEDIO() to find average grade.
3️⃣ Demonstration
Teacher shows a simple table (grades, attendance, or expenses) and demonstrates:
Turning filters on and off.
Sorting numeric and text data.
Applying functions after filtering.
How results change when data changes.
Students observe how one table gives many answers.
4️⃣ Activity – “From Data to Answers”
Students will organize a table, apply sorting and filters, and use functions to answer simple questions.
5️⃣ Take notes in your notebook.
📓 NOTES IN YOUR NOTEBOOK
Answer these questions:
Why is it important to sort data before analyzing it?
What is the advantage of filtering information?
Which function do you use to calculate an average?
How can these tools help you in real life (school or home)?
⸻
📌
KEYWORDS
Sort: Change the order of data.
Filter: Show specific information only.
Function: A built-in calculation tool.
PROMEDIO(): Calculates average.
CONTAR.SI(): Counts using a condition.
Data analysis: Understanding information using tools.