CLASS OBJECTIVE
Review and strengthen the use of basic spreadsheet tools — data types, basic formulas, functions, and counting — to help students feel confident working with spreadsheets independently.
🗓 CLASS AGENDA
💬 Introduction
“We have learned many tools in spreadsheets. Today is about practicing and making everything easier, not harder.”
1️⃣ Short Review
Teacher reviews with students:
What a spreadsheet is
Basic elements:
Cell
Row
Column
Difference between:
Data (text, numbers)
Formulas
2️⃣ Explanation: What We Know So Far
Teacher briefly reviews:
Formulas
Start with =
Use operators (+ – * /)
Functions
SUM()
AVERAGE()
MIN()
MAX()
Counting functions
COUNT()
COUNTA()
COUNTBLANK()
3️⃣ Demonstration
Teacher opens a simple spreadsheet and demonstrates:
Writing a basic formula
Using one function (SUM or AVERAGE)
Using one counting function
Changing a value and watching the result update
Students observe and ask questions.
4️⃣ Activity – “Practice Makes Easy”
Students will practice with a simple table combining data, formulas, functions, and counting.
5️⃣ Take notes in your notebook.
📓 NOTES IN YOUR NOTEBOOK
Answer these questions:
What is the difference between data and a formula?
What function helps you calculate an average?
When would you use COUNTBLANK()?
Why is it important to review spreadsheets?
⸻
📌
KEYWORDS
Spreadsheet: A digital table for organizing data
Data: Information written in cells
Formula: A calculation that starts with =
Function: A built-in calculation
COUNT(): Counts numbers
COUNTA(): Counts non-empty cells