CLASS OBJECTIVE
Identify the different types of data used in spreadsheets (text, numbers, dates, and formulas) in order to understand how each type behaves and how spreadsheets interpret information.
⸻
🗓 CLASS AGENDA
💬 Introduction
“Have you ever typed something into a spreadsheet and it didn’t behave the way you expected?
That's because spreadsheets read data in different ways.”
1️⃣ Short Review
Students recall:
What a cell is
What rows and columns are
The difference between data and a formula
2️⃣ Explanation: Types of Data
🔤 Text (Labels)
Words, names, titles, categories.
Examples: “Name”, “Math”, “Apple”, “Monday”
📌 Important: Text cannot be added or calculated.
🔢 Numbers (Values)
Used for calculations: prices, quantities, scores.
Examples: 24, 98.5, 1500
📌 Important: Numbers must NOT have letters.
📅 Dates
Represent days, months, years.
Examples: 01/03/2025, 3/15/25
📌 Sheets treat dates as numbers to calculate days, months, etc.
➕ Formulas
Start with =
Examples:
=5+2
=A1+A2
=SUM(A1:A5)
📌 Used to calculate or process information automatically.
3️⃣ Demonstration
Teacher shows:
How Sheets reacts differently to text vs. numbers
How entering a date automatically formats itself
How Sheets shows a formula result
Common mistakes students make
Mixing letters and numbers (wrong)
Writing formulas without =
Using commas instead of dots (depending on regional settings)
Students identify each type with simple examples.
4️⃣ Activity – “Sort My Data!” (Mention only)
Students will classify different small examples into:
✔ Text
✔ Number
✔ Date
✔ Formula
5️⃣ Homework (Mention only)
A short classification exercise will be posted in Classroom.
6️⃣ Take notes in your notebook.
⸻
📓 NOTES IN YOUR NOTEBOOK
Answer these questions:
What is a data type in a spreadsheet?
How can you know if something is a number or text?
Why do formulas always start with “=”?
Why do spreadsheets need different types of data?
⸻
📌 KEYWORDS
Text: Words used as labels
Number: Values you can calculate
Date: A numerical value that represents a day
Formula: An instruction that starts with “=”
Cell: Where data is written
Value: Any number used in calculations
⸻
🖋 HOMEWORK
- Will be published in Classroom.
- Please write it in your agenda.