Data Detectives Slides Digital Skills Lab
Data Detectives
Cracking the Case of the Spreadsheet!
What is a Spreadsheet?
A spreadsheet is a computer program used to organize and calculate data.
Why use them?
To track collections (like Pokémon cards!)
To plan a classroom party budget
To record science experiment results
To make colorful charts and graphs
The Ultimate Organizer
Anatomy of a Grid
Columns
Go UP and DOWN. They are named with LETTERS (A, B, C...).
Rows
Go SIDE to SIDE. They are named with NUMBERS (1, 2, 3...).
Cells
Where a Column and Row meet. Like an address!Example: B4
B4
Handling Data
Add Data
Click a cell and start typing. Hit 'Enter' to move down!
Update Data
Oops! Mistake? Double-click the cell to change the number.
Delete Data
Highlight the cell and press 'Delete' or 'Backspace' on your keyboard.
A B 1 Item Qty 2 Apples 12 3 Click to type...
Practice: Try updating "12" to "15"!
The Magic of Charts
Spreadsheets take boring lists and turn them into exciting pictures!
01
Highlight
Click and drag your mouse over your data.
02
Insert
Find the "Insert" menu and click "Chart" or "Graph".
03
Choose
Pick a Bar, Line, or Pie chart to show your data!
Mission Ready!
Today you've learned to navigate the grid, handle data like a pro, and prepare for chart-making.
Next stop: The Grid Giants Activity!
Grid Giants Worksheet Grid Giants
The Data Detective Training Manual
Name:
Date:
Goal: Identify the parts of a spreadsheet and practice updating data to plan a colorful chart.
Task 1: Anatomy of a Spreadsheet
Label the parts of the spreadsheet using the word bank below.
Column
Row
Cell
Formula Bar
fx | =Sum(B2:B5)
| | A | B
| C |
| --- | --- | --- | --- |
| 1
| Item | Score | Notes |
| 2 | Game 1 | 10
| Win |
Task 2: Update and Delete
Current Fruit Inventory
Cell A (Fruit) B (Amount) 1 Apples 8 2 Bananas 15 3 Oranges 5
Mission A: Update Data
You just found 4 more apples! What should be the new number in cell B1?
Mission B: Delete Data
The class ate all the oranges. What will you do to cell B3?
Task 3: Chart Builder
Based on your updated data from Task 2 (8+4 Apples, 15 Bananas, 0 Oranges), draw a bar chart below!
Apples
Bananas
Oranges
20 15 10 5 0
"I can visualize data like a giant!"
Grid Giants Answer Key Grid Giants
Answer Key & Teacher Guide
Teacher Resource
Task 1: Anatomy of a Spreadsheet
Formula Bar: The long white bar at the top (fx).
Column: The vertical group (Label B).
Row: The horizontal group (Label 1).
Cell: The specific box (where 10 is typed).
Teacher Tip:
Explain that a Cell Address is like a map coordinate (Column letter first, then Row number). "B2" is the address of the selected cell in the example.
Task 2: Update and Delete
Mission A: Update
12
(Original 8 + 4 new apples = 12)
Mission B: Delete
Select cell and press Delete
(Cell B3 should be 0 or empty)
Task 3: Chart Builder
The student's bar chart should show:
Apples: Bar reaches the 12 line.Bananas: Bar reaches the 15 line.Oranges: Empty space (or line at 0 ).
Success Criteria:
Correct values used from Task 2
Bars are labeled properly
Relative heights are correct (Bananas tallest)
Wrap-Up Questions
Q: Why not just draw the chart first?
A: Spreadsheets do the math and drawing for us, so if the data changes, the chart updates automatically!
Q: What happens if you delete a whole row?
A: All information in that row is removed, and the rows below move up to fill the gap.
Grid Master Slides Level 2: Data Detectives
The Grid Masters
Unlocking the Secrets of Sorting and Formulas
Review & Ranges
We know Rows (1, 2, 3) and Columns (A, B, C) . Now meet the Range.
What is a Range?
A group of cells selected together. We write it with a colon (:).
A1:B5
"Everything from A1 to B5!"
<table class="w-full h-full text-4xl border-collapse bg-white"><tbody><tr class="bg-slate-100"><td class="border p-4"></td><td class="border p-4 text-center font-bold">A</td><td class="border p-4 text-center font-bold">B</td></tr><tr><td class="border p-4 bg-slate-100 text-center font-bold">1</td><td class="border p-4 bg-indigo-200"></td><td class="border p-4 bg-indigo-200"></td></tr><tr><td class="border p-4 bg-slate-100 text-center font-bold">2</td><td class="border p-4 bg-indigo-200"></td><td class="border p-4 bg-indigo-200"></td></tr><tr><td class="border p-4 bg-slate-100 text-center font-bold">3</td><td class="border p-4 bg-indigo-200"></td><td class="border p-4 bg-indigo-200"></td></tr><tr><td class="border p-4 bg-slate-100 text-center font-bold">4</td><td class="border p-4"></td><td class="border p-4"></td></tr></tbody></table>
Sorting the Chaos
A to Z / Z to A
Put words in alphabetical order or numbers from smallest to largest with one click!
Filter Tool
Custom Sort
Scrambled Sorted
Zebra
Apple
Cat
Apple
Cat
Zebra
Formula Power
Spreadsheets are living calculators. Every formula starts with the magic symbol:
=
SUM
Total Addition
Adds up all numbers in a range.
Example: =SUM(A1:A5)
AVG
Average
Finds the middle point of data.
Example: =AVERAGE(B1:B10)
Better Visuals
Bar Charts
Great for comparing amounts of different things.
Pie Charts
Perfect for showing parts of a whole (like pizza!).
Line Graphs
Best for showing how data changes over time.
Pro Detective Tip: Always add a title and labels to your chart!
Level 2 Complete!
You've mastered Ranges, Sorting, and Formulas.
Grab your worksheet! It's time to test your skills.
Grid Masters Worksheet Grid Masters
Level 2: Data Detective Worksheet
Name:
Date:
Goal: Use cell ranges, sort data, and apply basic formulas to solve information puzzles.
Task 1: Identifying Ranges
A B C 1 Red Blue Green 2 Apple Pear Kiwi 3 Car Bike Bus 4 Cat Dog Fish
Look at the highlighted cells.
Write the correct Range notation for the highlighted yellow area:
Format like A1:B2
Which cell is at address C2 ?
Task 2: Sorting Logic
Unsorted Sports Stats
Player Name Points Charlie 12 Alice 34 Bob 21
If we sort Column A (Player Name) from A to Z , who will be in the top row?
If we sort Column B (Points) from Largest to Smallest , who will be in the top row?
Task 3: Formula Lab
Calculate the totals for the classroom party budget.
A (Item) B (Cost) 1 Balloons $10 2 Cupcakes $25 3 Juice $15 4 TOTAL ??
Write the formula you would use in cell B4 to find the total:
=
What will the actual total cost be?
$
Task 4: Chart Detective
Look at this Favorite Lunch pie chart. Which statement is TRUE based on the data?
Pizza (50%)
More students like Tacos (Amber) than Pizza (Blue).
Exactly half of the students chose Pizza.
Sushi (Rose) is the most popular choice.
Grid Masters Answer Key Grid Masters
Level 2: Answer Key & Teacher Guide
4th Grade Resource
Task 1: Identifying Ranges
Range Notation:
A1:B3
(All cells from Column A, Row 1 through Column B, Row 3)
Cell C2:
Kiwi
Teaching Point:
Remind students that a Range always uses a colon (:) . If they use a comma, it only selects two separate cells, not the whole block!
Task 2: Sorting Logic
A to Z (Player Name)
Alice
Alice comes before Bob and Charlie alphabetically.
Largest to Smallest (Points)
Alice
34 is the highest number in the Points column.
Task 3: Formula Lab
Formula for B4
=SUM(B1:B3)
Acceptable variations:=B1+B2+B3 or =SUM(B1,B2,B3)
Total Calculation
$50
(10 + 25 + 15 = 50)
Task 4: Chart Detective
Correct Statement:
"Exactly half of the students chose Pizza."
Differentiation & Extension
For Students Who Struggle:
Provide a physical grid paper or "Formula Finder" card that lists =SUM() and =AVERAGE() as templates they can fill in.
For Advanced Learners:
Challenge them to find the AVERAGE cost per item in Task 3 using the =AVERAGE(B1:B3) formula.
