Week 13: Types of Data in a Spreadsheet

 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:

1. What is a data type in a spreadsheet?
   

2. How can you know if something is a number or text?
   

3. Why do formulas always start with “=”?
   

4. 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.

Week 12: Cell Formatting – Alignment, Merge, Borders, Fill, Font & Number Formats

 

CLASS OBJECTIVE

Learn how to change the appearance of cells using alignment, merging, borders, fill color, font styles, and number formats to make spreadsheets clearer, more attractive, and easier to read.

⸻

🗓 CLASS AGENDA

💬 Introduction

“Have you ever seen a messy table that’s hard to read?
Today, you’ll learn how to make your spreadsheet look professional.”

---

1️⃣ Short Review

Identify the main elements of a spreadsheet:

• Cell
  

• Row
  

• Column
  

• Data
  

• Formula bar
  
  

---

2️⃣ Explanation

🎨 Cell Formatting Tools

• Alignment: Left, center, right, top, middle, bottom
  

• Merge cells: Combine two or more cells
  

• Wrap text: Make text fit inside a cell
  

• Borders: Add lines around cells
  

• Fill color: Change background color of cells
  
  

✏️ Font Formatting

• Font type
  

• Font size
  

• Bold
  

• Italic
  

• Underline
  

• Text color
  
  

💰 Number Formatting

• Currency ($)
  

• Date formats
  

• Percentage (%)
  

• Decimal places
  
  

---

3️⃣ Demonstration

Teacher creates a simple table and demonstrates:

• How to format the title row
  

• How to apply borders
  

• How to use fill color
  

• How to apply different alignments
  

• How to change number formats (currency, date, %, decimals)
  
  

---

4️⃣ Take notes in your notebook.

⸻

📓 NOTES IN YOUR NOTEBOOK

Answer these questions:

1. Why is formatting important in a spreadsheet?
   

2. What does “merge cells” mean?
   

3. What is the difference between text format and number format?
   

4. How can color and borders help readers understand your data?
   
   

⸻

📌 KEYWORDS

• Alignment: Position of text in a cell
  

• Merge cells: Combine multiple cells into one
  

• Wrap text: Adjust long text to fit inside a cell
  

• Borders: Outline around cells
  

• Fill color: Background color
  

• Font: Style and appearance of text
  

• Number format: How numbers appear (currency, %, date)
  

• Currency: Format for money
  

• Percentage: Multiplies by 100 and adds %
  
  

⸻

🖋 HOMEWORK

• Will be published in Classroom.
• Don’t forget to write it in your agenda.