Mission
1. Paint Box A1 RED ❤️
2. Paint Box B2 YELLOW ⭐
3. Paint Box C3 BLUE 🌊
Your Screen Will Look Like This:
A1 ❤️
B1
C1
A2
B2 ⭐
C2
A3
B3
C3 🌊
Look! The colors slide diagonally across the grid like a rainbow slide!
Superpower
Did you pick the wrong box? Did you paint the wrong color? Don't worry! Google Sheets has a time machine button!
↩️ The Undo Arrow:
Click the curvy arrow pointing backward at the very top left of your screen.
Takes you one step back in time like it never even happened!
Remember: Explorers try new things without being afraid of mistakes!
Computer Time
1
Two hands carry your Chromebook gently.
2
One gentle tap with pointer finger.
3
Have fun making your own colorful art!
🎨
Open your template, find Box B2, and let's start painting!
Let's Explore!
Need help? Put a thumb up quietly and your teacher will help!
Step 3 (Column A Words):
Type Tag, Swings, Kickball, Slide down cells A2 to A5 using Enter.
Step 4 (Column B Numbers):
Click cell B2. Type the vote counts down B2 to B5!
Typing Words in the Same Cell: Students often try to type "Tag 8" in one box. Remind them: Words have their own room (Col A), numbers have their own room (Col B)!
Holding the Enter Key: Pressing Enter too hard flies all the way down to Row 50! Teach: Quick tap and release!
Spelling Panic: Students worry about typing speed. Assure them: Keep the words simple; approximations are fine!
Accidental Overwrites: Clicking a cell and typing replaces the whole word. Remind them about Ctrl + Z.
Exit Check (3 Mins): Ask the class: "Which button dropped your cursor down like an elevator?" (Enter!) "Which cell has the word Activity?" (A1!)
Ready for Grade 3!
Data Detectives • Grade 2 Bridge to Google Sheets Page 2 of 2 (Complete Lesson Plan)
B Click Bold to make the letters thick and strong.
🪣 Click the Paint Bucket to give Row 1 a royal color!
Plain (Hard to Tell Headers Apart):
Activity | Votes
Dressed Up (Super Clear!):
Activity | Votes
Now your table looks like a real computer scientist built it!
Troubleshooting
⌫
Did you misspell a word? Press Backspace to erase one letter at a time like an eraser.
↩️
Did you accidentally color the wrong box? Press Ctrl + Z to jump backwards one second!
Never panic! You always have your Backspace eraser and Undo time machine!
Ready to Type
1
Type Activity in A1 and Votes in B1.
2
Make Row 1 Bold with your favorite fill color.
3
Type 4 recess games down Column A using Enter.
4
Type the vote counts down Column B.
Open your sheet, grab your keyboard, and start building!
Let's Build!
Questions? Ask your Detective Partner or raise your hand!
fx
Favorite Book = Charlotte's Web
The Formula Bar:
Shows the true content inside your cell!
Skill 2
B
Make table titles stand out so everyone knows what your table is about.
Main Header
Paints the background of the cell box. Perfect for color-coding categories!
Green = Complete
A
Changes the color of your letters. Keep it high-contrast so it is readable.
Golden Text
Golden Design Rule:
Always use Dark text on Light backgrounds or Light text on Dark backgrounds!
Skill 2 Practice
Words & Names: Align Left ←
Numbers & Money: Align Right →
Column Titles / Codes: Align Center ↔
The faint gray lines on screen will not print unless you turn on Borders!
Highlight all your cells
Click the Borders icon (window pane)
Select "All Borders" for clean grid lines!
Neat alignment and crisp borders turn messy scribbles into a professional table!
Skill 3
1
Give each column a clear name like "Student", "Pet", "Count".
2
Type each person or item on its own separate row below.
3
View > Freeze > 1 Row keeps your title visible when scrolling.
Model Table: Class Pet Survey
Pet Choice (A)
Category (B)
Votes (C)
Golden Retriever
Dog
12
Tabby Cat
Cat
9
Hamster
Small Pet
5
Bearded Dragon
Reptile
4
Pro Tip: Keep one type of information in each column so you can sort and filter easily!
Skill 3 Practice
Sort A → Z (Ascending)
Puts words in alphabetical order (A, B, C...) or numbers from lowest to highest (1, 2, 3...).
Sort Z → A (Descending)
Puts words in reverse order or numbers from biggest to smallest (find your top scores!).
1
Hover over the column letter you want to sort (e.g. Column A).
2
Click the small drop-down arrow next to the letter.
3
Choose "Sort Sheet A → Z" and watch the rows line up!
Remember: The entire row travels together so names and their votes never get mixed up!
Skill 4
Every formula MUST start with =
When you type the = (equals sign), you tell Google Sheets: "Do not just show what I type—calculate the answer!"
Addition: = 5 + 3
Subtraction: = 10 - 4
Cell A1: What you type
= 15 + 25
Cell A1: What Sheets displays
40
If you forget the = sign, the sheet will just display the plain text instead of doing the math!
Skill 4 Master
= SUM ( B2:B5 )
= Tells Google Sheets to calculate
SUM The action word for "Add them all up"
B2:B5 The cell range: from cell B2 all the way to B5!
Item (A)
Price (B)
Notebook (B2) $3
Pencils (B3) $2
Erasers (B4) $1
Markers (B5) $4
Total Cost: $10
Magic Perk: If you change the price of Markers from $4 to $6, the Total updates automatically!
Ready to Build
1
Create a 3-column table with custom headers.
2
Style your headers with Bold text and a Fill Color.
3
Type in 4 rows of data with numbers in the last column.
4
Use =SUM(...) at the bottom to calculate your total!
Open a blank Google Sheet, claim your grid, and start building!
Let's Get Started!
Questions? Raise your hand or ask your elbow partner!
Hands-on Check: Have students practice clicking cell A1 in their blank sheet and turning it yellow.
Spreadsheet Superstars • Grade 3–5 Digital Literacy Page 1 of 2 (Continued on Page 2)
Teacher Lesson Plan • Continued
Phase 2: ~25–35 Mins
Slide 6: Alignment & Borders 5 Mins
Demonstrate why numbers must be right-aligned (so decimal points and place values align vertically). Show how grid lines disappear in print unless "All Borders" is clicked.
Slides 7 & 8: Building Tables & Sorting A–Z 7 Mins
Emphasize Row 1 as the "Header Row." Explain that sorting a column rearranges the entire row so names and counts remain matched. Model: View > Freeze > 1 row so titles never disappear when scrolling.
Slides 9, 10 & 11: Formulas, =SUM, & The Hands-On Mission 15–20 Mins
Write =SUM(C2:C5) on the board. Break it down: the = is the ignition key, SUM means add, and the colon : means "through". Release students to execute Slide 11's classroom mission.
Forgetting the "=": Typing 5+5 results in the text "5+5" sitting in the cell. Remind them: No equals, no magic!
Reversing Coordinates: Writing 2B instead of B2 will trigger an error or point to nothing.
Accidental Overwrites: Clicking once on a cell and typing replaces everything. Remind them to double-click to edit one character.
Typing $ signs in calculations: Encourage typing plain numbers first, then using the dollar icon formatting button.
Worksheet Answer Key (Quick Reference) Teacher Edition
Part 1: Cell Addresses: Dog = A2, Cat = B2, Fish = C3. Coordinates: Column comes first (letters), Row second (numbers).
Part 2: Bucket = Fill/Background Color; Bold 'B' = Header text weight; Left-align = Words; Right-align = Numbers.
Part 3: Row 1 = Headers; Sort A–Z orders words alphabetically and numbers from lowest to highest.
Part 4: Equation must start with =; =SUM(B2:B5) adds cells B2 through B5; Total cost in sample = $10.
Spreadsheet Superstars • Grade 3–5 Digital Literacy Page 2 of 2 (End of Teacher Guide)
Snack Stand Calculation: Cell B2 = 4 apples ($4)
Cell B3 = 2 juices ($2)
Cell B4 = 1 cookie ($1)
What will =SUM(B2:B4) equal?
Check off each task as you complete it
1. Opened a new blank sheet and named it "My Favorite Snacks".
2. Typed 3 headers in Row 1: Item, Category, and Cost.
3. Formatted Row 1 with Bold text and a fun Fill Color.
4. Added 4 rows of snacks with prices in Column C.
5. Typed =SUM(C2:C5) in cell C6 to find your total!
Teacher Verification
Show your screen to earn your official Superstar Stamp!
STAMP / SIGN
Spreadsheet Superstars • Congratulations on becoming a certified data wizard! Page 2 of 2
Accept: "Headers", "Titles", "Category names"
2. If sorted A to Z, which fruit is #1?
Apple
Full sort order: Apple → Banana → Grape → Mango
6 Points (2 pts each)
1. The Golden Rule: Every formula MUST start with this symbol:
= (Equals Sign)
Formula to Decode =SUM(B2:B5)
2. Decoded in student words:
"Add up all the numbers in cells B2 through B5"
Snack Stand Calculation: Cell B2 = 4 apples ($4) + B3 = 2 juices ($2) + B4 = 1 cookie ($1)
What will =SUM(B2:B4) equal?
$7 (or 7)
10 Points (2 pts each)
1. Opened new sheet & named "My Favorite Snacks" ✓ 2 pts
2. Row 1 headers: Item, Category, Cost ✓ 2 pts
3. Styled header with Bold + Fill Color ✓ 2 pts
4. 4 items with numeric costs in Column C ✓ 2 pts
5. Working =SUM formula calculates valid total in C6 ✓ 2 pts
Grading Scale
Certified Spreadsheet Superstar
Spreadsheet Superstars • Official Answer Key & Rubric Page 2 of 2 (Complete)
