Home›Lesson Plans›Computer Science›Computer Science · Grade 6

Data in Spreadsheets

Sixth graders learn how spreadsheets organize data into cells, rows, and columns — and how formulas and charts turn raw numbers into calculations and visual insights, a key tool for working with data.

Grade 6Data45 minutes1 class periodUse → Modify → CreateExplicit teaching4 StandardsCSTA
Start the Lesson
Lesson at a Glance

Everything you need before the bell rings

Learning Objectives

Students will be able to…

  • ✓Explain a spreadsheet.
  • ✓Name cells, rows, columns.
  • ✓Use a formula.
  • ✓Make a chart.
Essential Question

How do people organize and make sense of lots of data? Spreadsheets! They store data in a grid and can even do the math for you. How do spreadsheets work?

0
Lesson Phases
0
Vocabulary Terms
0
Standards Aligned
0
Interactive Task
Match It · Interactive

Match the Spreadsheet Term

Project this and match each spreadsheet term to its meaning — tap a term, then tap what it means.

📊 Match each spreadsheet term to its meaningTry it
Term
What It Means
Now tap its meaning!
The Lesson · Use → Modify → Create (a coding progression with Unplugged practice)

45 minutes, five moves

Tap any phase to open the teacher moves and student actions.

1

Hook — Making Sense of Data

5 min

How do people organize lots of data? Spreadsheets do the math too!

👩‍🏫 Teacher Moves

  • Show a data table.
  • Ask how to organize it.
  • Set the goal.

🎒 Student Actions

  • Look.
  • Wonder.
  • Predict.
2

Unplugged — Unplug It

11 min

Students practice.

👩‍🏫 Teacher Moves

  • Fill a paper grid with data.
  • Add a row total.
  • Feel the structure.

🎒 Student Actions

  • Fill it.
  • Total it.
  • Feel it.
3

Use — Spreadsheets

14 min

Students use.

👩‍🏫 Teacher Moves

  • Send students to Match the Spreadsheet Term.
  • Note formulas.
  • Note charts.

🎒 Student Actions

  • Match.
  • Note it.
  • Explain.
4

Modify — Modify It

10 min

Students modify.

👩‍🏫 Teacher Moves

  • Write a formula.
  • Change data and see it update.
  • Make a chart.

🎒 Student Actions

  • Write it.
  • Update it.
  • Chart it.
5

Create — Create

5 min

Students conclude.

👩‍🏫 Teacher Moves

  • Build a small spreadsheet.
  • Explain a formula.
  • Complete the exit ticket.

🎒 Student Actions

  • Build it.
  • Explain it.
  • Complete the exit ticket.
Standards Alignment

Built to the standards you report on

Aligned to the CSTA K-12 Computer Science Standards and ISTE Standards for Students.

CSTA
2-DA-08

Collect data and use it to make things.

CSTA
2-DA-09

Refine and visualize data with tools.

CSTA
2-DA-07

Represent data using tables.

ISTE
5

Computational Thinker.

Differentiation

One lesson, every learner

Multilingual Learners

ELL / EMERGING READERS
  • Term + meaning cards.
  • Sentence frame: “A ___ is ___.”
  • Use a spreadsheet.

Support & Access

IEP / 504
  • Start with cell and row.
  • Use a physical grid.
  • Match one pair at a time.

Stretch & Extend

GIFTED / EARLY FINISHERS
  • Write a SUM formula.
  • Sort and filter data.
  • Make different charts.
Materials

What to gather

  • 📽️Projector / board
  • 📊A spreadsheet tool
  • 💻Match the Spreadsheet Term
  • 📄Grid paper
  • ✏️Pens
  • 🎫Exit-ticket slips
Vocabulary

Key terms — hover for a quick definition

spreadsheeta program that organizes data in a gridcella single box for datarowa horizontal line of cellscolumna vertical line of cellsformulaan instruction that calculatescharta visual of datadatainformation you work withsuma total of numbers
Evaluate

Exit Ticket

Preview the three formative checks. Tap “Sample answer” to see what mastery looks like — hide them before you print for students.

QUESTION 1
What is a cell in a spreadsheet?
A single box where data goes.
QUESTION 2
What is a formula?
An instruction that calculates a result, like =A1+B1.
QUESTION 3
What is a chart used for?
To show data visually, like a bar graph.

Create: build a sheet.

Have students plan a small spreadsheet with rows and columns and describe one formula it would use. A printable spreadsheets sheet is in the Computer Science library.

Study · Flashcards

Study the key terms

Tap a card to flip it, then rate whether you knew it. Built from this lesson’s vocabulary.

🃏 Data in SpreadsheetsFlip
Card 1
Term
Tap to flip →
Meaning
0

Nice work!

Practice · Quiz

Check your understanding

A quick self-check with instant feedback, drawn from this lesson’s key terms.

📝 Data in SpreadsheetsQuiz
Score: 0
1 / 6
Question 1
0%

Nice work!

Practice · Worksheet

Printable worksheet

A print-and-go review sheet with a built-in answer key. Tap “Show answer key” to reveal answers, or print the clean version for students.

🖨️ Data in SpreadsheetsPrint
Name: ________________________
Date: ____________

Part A · Write the word that matches each meaning

Word bank: cell, chart, column, data, formula, row, spreadsheet, sum
  1. a vertical line of cells
  2. a visual of data
  3. information you work with
  4. a single box for data
  5. a program that organizes data in a grid
  6. a total of numbers
  7. a horizontal line of cells
  8. an instruction that calculates

Part B · Show what you learned

  1. What is a cell in a spreadsheet?
  2. What is a formula?
  3. What is a chart used for?
Answer key — Part A: 1) column · 2) chart · 3) data · 4) cell · 5) spreadsheet · 6) sum · 7) row · 8) formula
Part B: 1) A single box where data goes. 2) An instruction that calculates a result, like =A1+B1. 3) To show data visually, like a bar graph.