Join: s.risd.org/SheetGems
👋While we wait
Tap on the Sheet for a quick survey question.
Join: s.risd.org/SheetGems
Participants will be:⬜ EXPLORING 3 examples of self-checking activities in Sheets. ⬜ CREATING 1 self-checking activity ⬜ BRAINSTORMING ways Sheets can give you time back with students.
Join: s.risd.org/SheetGems
RHS Instructional Coach Specialty: Digital Learning
Join: s.risd.org/SheetGems
While Google Sheets can be a powerful spreadsheet tool, its features make it a PERFECT interactive choice for activities. Formulas are great for student data, but what if they could do more?
Join: s.risd.org/SheetGems
💬 Brief description 🔑Skills required & recommended
🌎Content Example
💚Template
📹Tutorial Video (under 5 min!)
Join: s.risd.org/SheetGems
We will be using this Workbook throughout today to freshen up our skills and play with activities.
Join: s.risd.org/SheetGems
Hidden Picture
Pixel Art
Magic Squares
What is it?Students answer variousquestions, either in the Sheetor paper. As the enter the correct answer, squares (or pixels to a picture will begin to appear. As more answers are correct, the picture will appear.
Tweet
Why I love it: 🎨 Easier to code and can save you time! 🎨 Self-assessing is built-in! 🎨 Create a hidden message or directions for students as next steps!
Example
1. Search ◼PIXEL art on Google to find an idea or create your own picture. 2. Use 🎨CONDITIONAL FORMATTING in your Google Sheet. 3. You'll select ALL cells that you want to change when a student answers. 4. Choose 👆CUSTOM FORMULA. 5. Add in the custom formula. Tap DONE. 6. Once your image is all hidden, READY TO ASSIGN!
Template
Play
VLOOKUP | 💛RECOMMENDEDBuilds the dropdown of questions for students to pick from. CONDITIOAL FORMAT | 🔴REQUIRED When students enter an answer, the cells automatically color code. DROP DOWN | 💛RECOMMENDED Create a dropdown menu if questions are longer than a quick sentence.
What is it? - adapted from Dr. Tolen Students choose a question from the dropdown menu. If they answer correctly, an image will appear. Once they do all the questions, a final picture is revealed.
Why I love it: 📸 Students can work problems in any order.
📸 Self-assessing is built-in!
📸 Can be a clue to next task, reward, or silly!
Example
Example
1. Find 🖼️IMAGES that you would like to appear. 2. RIGHT-click on image, and choose "COPY IMAGE ADDRESS." 3. On your Sheet, REPLACE the =IMAGE part of the formula with your new image. 4. Add in your ANSWERS. 5. Post for ALL STUDENTS to get a copy.
Template
Play
VLOOKUP | 🔴REQUIRED Builds the dropdown of questions for students to pick from. IF formula | 🔴REQUIRED
“If” students enter the right answer, an image needs to appear. “If” it is wrong, then NO image appears.
HYPERLINK formula | 🔴REQUIRED
This will bring the image into your Google Sheet.
Read more
What is it? - similar to Hidden Pic Students choose a question from the dropdown menu. If they answer correctly, a piece of a picture will appear. They will see the WHOLE picture at the end.
Why I love it:📸 Students can work problems in any order. 📸 Self-assessing is built-in! 📸 Can be a clue to next task, reward, or silly!
Example
Example
1. Find an 🖼️IMAGE that you would like to appear. 2. Insert your image on a 💛Google Slide. 3. Place a table on TOP to cut your picture into pieces. 4. 📸Screenshot + ✔️Save each piece. 5. On your Sheet, tap in [INSERT]. Choose [IMAGE IN CELL]. 6. Add in your ANSWERS. 7. Post for ALL STUDENTS to get a copy.
Template
Play
VLOOKUP | 🔴REQUIRED Builds the dropdown of questions for students to pick from.
IF formula | 🔴REQUIRED
“If” students enter the right answer, an image needs to appear. “If” it is wrong, then NO image appears.
INSERT images | 🔴REQUIRED
This will bring the image into your Google Sheet.
Link
Join: s.risd.org/SheetGems
Menu
Check out some of my favorite people to follow and some blogs to explore!
Join: s.risd.org/SheetGems
Where else can these skills take me?
Join: s.risd.org/SheetGems
Please share any anonymous feedback! Share your learning at #TCEA
Info
TCEA24 | Hidden Gems in Google Sheets
Lauren Hawkins
Created on January 11, 2024
Start designing with a free template
Discover more than 1500 professional designs like these:
View
Terrazzo Presentation
View
Visual Presentation
View
Relaxing Presentation
View
Modern Presentation
View
Colorful Presentation
View
Modular Structure Presentation
View
Chromatic Presentation
Explore all templates
Transcript
Join: s.risd.org/SheetGems
👋While we wait
Tap on the Sheet for a quick survey question.
Join: s.risd.org/SheetGems
Participants will be:⬜ EXPLORING 3 examples of self-checking activities in Sheets. ⬜ CREATING 1 self-checking activity ⬜ BRAINSTORMING ways Sheets can give you time back with students.
Join: s.risd.org/SheetGems
RHS Instructional Coach Specialty: Digital Learning
Join: s.risd.org/SheetGems
While Google Sheets can be a powerful spreadsheet tool, its features make it a PERFECT interactive choice for activities. Formulas are great for student data, but what if they could do more?
Join: s.risd.org/SheetGems
💬 Brief description 🔑Skills required & recommended 🌎Content Example 💚Template 📹Tutorial Video (under 5 min!)
Join: s.risd.org/SheetGems
We will be using this Workbook throughout today to freshen up our skills and play with activities.
Join: s.risd.org/SheetGems
Hidden Picture
Pixel Art
Magic Squares
What is it?Students answer variousquestions, either in the Sheetor paper. As the enter the correct answer, squares (or pixels to a picture will begin to appear. As more answers are correct, the picture will appear.
Tweet
Why I love it: 🎨 Easier to code and can save you time! 🎨 Self-assessing is built-in! 🎨 Create a hidden message or directions for students as next steps!
Example
1. Search ◼PIXEL art on Google to find an idea or create your own picture. 2. Use 🎨CONDITIONAL FORMATTING in your Google Sheet. 3. You'll select ALL cells that you want to change when a student answers. 4. Choose 👆CUSTOM FORMULA. 5. Add in the custom formula. Tap DONE. 6. Once your image is all hidden, READY TO ASSIGN!
Template
Play
VLOOKUP | 💛RECOMMENDEDBuilds the dropdown of questions for students to pick from. CONDITIOAL FORMAT | 🔴REQUIRED When students enter an answer, the cells automatically color code. DROP DOWN | 💛RECOMMENDED Create a dropdown menu if questions are longer than a quick sentence.
What is it? - adapted from Dr. Tolen Students choose a question from the dropdown menu. If they answer correctly, an image will appear. Once they do all the questions, a final picture is revealed.
Why I love it: 📸 Students can work problems in any order. 📸 Self-assessing is built-in! 📸 Can be a clue to next task, reward, or silly!
Example
Example
1. Find 🖼️IMAGES that you would like to appear. 2. RIGHT-click on image, and choose "COPY IMAGE ADDRESS." 3. On your Sheet, REPLACE the =IMAGE part of the formula with your new image. 4. Add in your ANSWERS. 5. Post for ALL STUDENTS to get a copy.
Template
Play
VLOOKUP | 🔴REQUIRED Builds the dropdown of questions for students to pick from. IF formula | 🔴REQUIRED “If” students enter the right answer, an image needs to appear. “If” it is wrong, then NO image appears. HYPERLINK formula | 🔴REQUIRED This will bring the image into your Google Sheet.
Read more
What is it? - similar to Hidden Pic Students choose a question from the dropdown menu. If they answer correctly, a piece of a picture will appear. They will see the WHOLE picture at the end.
Why I love it:📸 Students can work problems in any order. 📸 Self-assessing is built-in! 📸 Can be a clue to next task, reward, or silly!
Example
Example
1. Find an 🖼️IMAGE that you would like to appear. 2. Insert your image on a 💛Google Slide. 3. Place a table on TOP to cut your picture into pieces. 4. 📸Screenshot + ✔️Save each piece. 5. On your Sheet, tap in [INSERT]. Choose [IMAGE IN CELL]. 6. Add in your ANSWERS. 7. Post for ALL STUDENTS to get a copy.
Template
Play
VLOOKUP | 🔴REQUIRED Builds the dropdown of questions for students to pick from. IF formula | 🔴REQUIRED “If” students enter the right answer, an image needs to appear. “If” it is wrong, then NO image appears. INSERT images | 🔴REQUIRED This will bring the image into your Google Sheet.
Link
Join: s.risd.org/SheetGems
Menu
Check out some of my favorite people to follow and some blogs to explore!
Join: s.risd.org/SheetGems
Where else can these skills take me?
Join: s.risd.org/SheetGems
Please share any anonymous feedback! Share your learning at #TCEA
Info