Andreas Johansson + Google Forms, Sheets & Sites; FormMule, AutoCrat & FormRanger Add-Ons; VLookUp, Concatenate & other Formulas; Lean Thinking and more!
Educational Duct Tape: An EdTech Integration Mindset
Release Date: 02/19/2020
EDT Jake on The Inspired Teacher Podcast
Educational Duct Tape: An EdTech Integration Mindset
What happens when two education nerds talk books, buffaloes, and Brisk? In this special episode, I join Mike Brilla on The Inspired Teacher Podcast to discuss the role of AI in classrooms, building a professional learning community, and the adjacent possible. We get candid about cell phones, feedback, tech integration, and remembering our “why” as educators. Tools we mention include MagicSchool, Diffit, Claude, ChatGPT, and Brisk. You’ll laugh, reflect, and leave with ideas you can try tomorrow. #EduDuctTape This interview was originally aired on The Inspired Teacher by Mike Brilla. It...
info_outline
EDT128 Google Gemini for Education
Educational Duct Tape: An EdTech Integration Mindset
Google announced Gemini for Education. In this episode, I break it all down, from Deep Research and Gemini Canvas to Gems, Gemini Live, and more. I also discuss the difference between the paid and free versions as well as the admin controls and privacy features in it. Plus, in the soapbox moment, I dig into the importance of growth mindset, perseverance, and what we can all learn from the Learning Pit. #EduDuctTape Episode 128 0:00:00 INTRO 0:02:31 Today's Soapbox Moment: “Rental Skates, Paintballs, and the Messy Middle” - The Anthropocene Reviewed - (Amazon affiliate link) - The Learning...
info_outline
EDT Jake on The Conversation Podcast
Educational Duct Tape: An EdTech Integration Mindset
Can AI help teachers do more of what matters most? In this episode, I join Rachel and Christina from The Conversation podcast to explore AI’s real impact in schools. We discuss tools like MagicSchool, Diffit, and Brisk, and how they support both students and teachers. We also dive into personalized learning, teacher PD, and the “baby steps” approach to AI adoption. Plus, I share practical insights on balancing tech with humanity in the classroom. #EduDuctTape This interview was originally aired on The Conversation Podcast by Rachel Daniels, John Hambrick, and Christina Grady-Watts of the...
info_outline
EDT127 Quizizz Becomes Wayground, Google Classroom Add-ons, Edpuzzle Quizizz and Slides, a Soapbox, and more!
Educational Duct Tape: An EdTech Integration Mindset
What do a name change, a new font, and fewer browser tabs have in common? In this episode, I unpack the Quizizz rebrand to Wayground, share Edpuzzle’s leap beyond video with new interactive tools, highlight Google Classroom’s latest add-on integrations, and spotlight Google Fonts’ Playwrite—a typeface built to support handwriting instruction. Plus, in the Soapbox moment, I reflect on my son learning to drive and the lessons we’re both picking up along the way. #EduDuctTape Episode 127 0:00:00 INTRO 0:02:04 Soapbox Moment: Mirrors, Mailboxes, and Merging 0:07:06 EdTech &...
info_outline
EDT126 Fonz Mendoza, Screencasting Tools, Screencastify, Kapwing, ScreenPal, Loom, plus NotebookLM, Padlet, Quizizz, and Google Lens
Educational Duct Tape: An EdTech Integration Mindset
What if your classroom ran more like a student-led workshop than a teacher-led lecture? In this episode, Alfonso Mendoza joins me to talk about screencasting tools like Screencastify, Loom, ScreenPal, and Kapwing. I also spotlight new features in Padlet and NotebookLM, share how Google Lens can support inquiry in the moment, and reflect on The Shift to Student-Led by Catlin Tucker and Katie Novak. EduDuctTape Episode 126 0:00:00 INTRO 0:01:47 Today's Guest: Fonz Mendoza Alfonso “Fonz” Mendoza Jr. is an educator, AI researcher, and host of My EdTech Life. He champions responsible...
info_outline
EDT125 Courtney Watson, Scribe, iorad, Bite-Sized Tech Instructions, BookCreator, Padlet, NotebookLM
Educational Duct Tape: An EdTech Integration Mindset
How do we make tech processes easier for students—and teachers—to follow? In this episode, I chat with Courtney Watson from friEdTechnology about strategies for creating clear, bite-sized tech instructions using tools like Scribe, iorad, Canva, and Adobe Express. We explore ways to lower the cognitive load and boost confidence in tech-rich classrooms. Plus, I share new feature updates in Book Creator, Padlet, and NotebookLM that support accessibility, flexibility, and efficiency. #EduDuctTape Episode 125 0:00:00 INTRO 0:02:59 Today's Guest: Courtney Watson Courtney is a Google Certified...
info_outline
EDT Jake on the State of Ed Podcast
Educational Duct Tape: An EdTech Integration Mindset
This interview was originally aired on the State of Ed Podcast by Dr. Nick Isseks and Dr. Nick Simone. It is being re-aired here with their permission. You can access the original episode here: and access all State of Ed Podcast episodes here: 0:00:00 INTRO 0:02:53 State of Ed Podcast 0:04:21 Jake's Journey 0:05:57 What is Personalized Learning? 0:10:33 Rogers' Law of Diffusion of Innovation 0:13:12 What is Educational Duct Tape? 0:16:04 More Than Words by John Warner 0:18:58 The Issue with Points-Based Grading 0:20:03 Mastery vs. Performance-Oriented Goals 0:22:29 The AI Infinite Loop...
info_outline
EDT124 Bryon Carpenter, Tools for Visuals like Adobe Express, Canva, Google Drawings, and Google Slides
Educational Duct Tape: An EdTech Integration Mindset
What’s your favorite tool for having students create visuals like infographics and diagrams? Bryon Carpenter from Fresh Air At Five joins me to answer that very question. We discuss Adobe Express, Canva, Google Drawings, and Google Slides. Also, I share about Brisk’s new Podcast Generator, a Chromebook monitoring feature coming soon to Google, SchoolAI’s response to some ethical concerns, and a documentary recommendation. #EduDuctTape Episode 124 0:00:00 INTRO 0:02:09 Today's Guest: Bryon Carpenter 0:06:49 Which of the Following is Less Torturous 0:10:22 Today's #EduDuctTape...
info_outline
EDT123 Think big, Start small, and Scale fast with the Eisenhower Matrix. Plus, helps me prioritize what matters. Plus, updates from Snorkl, Google Classroom, and SchoolAI
Educational Duct Tape: An EdTech Integration Mindset
Ever feel like the important work keeps getting overshadowed by what’s urgent? In this episode, I reflect on the quote “Think big. Start small. Scale fast.” and share how the Eisenhower Matrix helps me keep my priorities aligned. I also share updates from Snorkl, Google Classroom, and SchoolAI, plus a candid take on More Than Words by John Warner. Tools featured include Snorkl Coach, Video Explorer, and Read Along with custom content. #EduDuctTape Episode 123 0:00:00 INTRO 0:02:23 Today’s Soapbox Moment: “Parking Lots, Right Turns, and What’s Important” Think Big,...
info_outline
EDT122: Formative Assessment with Dan Niessen: Quizizz, Nearpod, Pear Deck, and Snorkl, plus Google Slides, Canva Visual Suite 2.0, and Canva Sheets
Educational Duct Tape: An EdTech Integration Mindset
What’s your go-to tool for formative assessment? In this episode, Dan Niessen joins me to unpack strategies for gathering real-time insights into student learning. We talk Quizizz, Nearpod, Snorkl, AI chatbot tutors, Pear Deck, ChatGPT, and more. Dan shares how he supports educators in choosing tools that fit their goals—and their students. Plus, I break down updates to Google Slides, Canva Visual Suite 2.0 and Canva Sheets, along with a timely tip on how to cite AI-generated content. Tune in! #EduDuctTape Episode 122 Today's Sponsor - M2 by Swivl - 0:00:00 INTRO 0:03:26 Today’s...
info_outline#EduDuctTape S02-E037
#EduDuctTape -- EduDuctTape.com -- @JakeMillerTech -- JakeMiller.net -- [email protected]
- Additional Audio Content from this episode available here: traffic.libsyn.com/eduducttape/EDT037_Bonus_Content_with_Andreas_Johansson.mp3
- Ways to Support the Show or Connect with Jake & other Duct Tapers!
- Apple Podcast Reviews
- FlipGrid.com/EduDuctTape
- #EduDuctTape on social media
- Telling your friends & colleagues
- The Duct Tapers Facebook Group - facebook.com/groups/ducttapers
- Stickers! Want to pass some out? Want some for yourself? JakeMiller.net/SendMeStickers
- Certificates of Listening, Laughing, and Learning!
- EduDuctTape.com/certificate
- Listen to the whole show to hear the “super-secret code”!
- #EduDuctTape Twitter Chats
- Access the calendar! - bit.ly/EduDuctTapeCalendar
- Highlights from the last chat - wke.lt/w/s/8WQtj7
- Thanks to The Mighty Ducts! Sarah Kiefer, Alex Oris, Amy Huckaby, Angela Green, Brandy New, Dan Stitzel, David Allan, Jennifer Conti, Kimberly Wren, Lisa Marie Bennett, Matt Meyer, Melinda Vandevort, Melissa Van Heck, Molly Klodor, Nanci Greene, Pam Inabinett!
- The JakeMillerTech Newsletter - Sign up! jakemiller.net/newsletter
- Jake’s Upcoming Events
- Educational Duct Tape Workshop Series: Flipgrid at Kent State University Research Center for Educational Technology - kent.edu/rcet/innovating-teaching-learning - 2.24.20, 9:00 a.m. - 3:00 p.m.
- KySTE Spring Conference - Louisville, KY - 3.12.20 - kyste.org/Content2/conference
- NEOTech Conference - Akron OH - 3.17.20 - neotechconference.org
- ITIP Ohio Google Summit - Sandusky, OH - 5.11-5.12.20 - itipohio.org/google-summit
- Tech Meet Tuscaloosa - Tuscaloosa, Alabama - 5.29.20 - uatmt.weebly.com
- Oconee County Schools Summer Institute - Walhalla, SC - 6.9-6.10.20
- WITCon (Whatever It Takes Conferences) - Galesburg, Ill - 6.12.20 - witconf.org
- ISTE - 6.30.20 - conference.iste.org/2020
- Engage Conference, San Angelo, TX - 7.15.20
- Jake on Other Shows: The MagicPotionEDU Podcast - magicpotionedu.com/episode-038-bring-it-together-with-educational-duct-tape-featuring-jakemillertech
- Today’s SoapBox Moment - “The How & The What”
- From You Are a Badass by Jen Sincero
- "Your job isn't to know the HOW it's to know the WHAT and to be open to discovering, and receiving, the HOW."
- Today’s Guest: Andreas Johansson
- Andreas launches rockets at Streetsboro City Schools. He's passionate about purpose, people, and problem solving. PhD student at KSU. He’s an INTJ. In his spare time, he runs in the woods with maps and a few other things...
- Contact Info:
- 2 Truths & 1 Lie
- Question #1: How can we make daily processes simpler and more efficient for staff that normally don't interface with technology?
- For some of these staff members just checking email may be difficult or inconvenient.
- Quick Links Menu for Staff
- Using the Design Thinking Process - observation, hearing feedback
- When they see you hearing & applying their feedback, it’s appreciated.
- “Go Do” - just fix it right away
- Lean Thinking - wikipedia.org/wiki/Lean_thinking
- “Go to the work where the place happens to see what’s truly happening.” - the Gemba - wikipedia.org/wiki/Gemba
- Question #2: Since there are still some procedures within schools that require paper by law, how can we make the process simpler?
- Bus Driver Hub (screenshot)
- Building value: Does it add value? Is it required? Create stuff that creates value.
- Mimic things that you already know work for the general public like a phone app.
- Make sure it works well on desktop as well as mobile.
- Google Sites
- Use preview mode to see what it’ll look like on different screens
- support.google.com/a/users/answer/9310269
- Keep the end-user in mind
- Pre-Trip Certification Form:
- Graphics for buttons - iconfinder.com
- Use Google Forms
- Keep in mind “How long will this process take?”
- Do you really need to collect email address? Or can you just ask them for name?
- With date questions in Google Forms click the center button to select “today.”
- Use branching with “go to page based on answer” for options that everyone doesn’t have to fill out
- Form Ranger Google Forms Add-On
- In the Google Sheets backend…
- Screenshot
- Leave the data collection sheet alone
- Use Pivot Tables (by date, by bus, etc.)
- FormMule Google Sheets Add-on - generates emails based on rules that you set - cloudlab.newvisions.org/form-mule
- Google Forms reuse a question - gsuiteupdates.googleblog.com/2019/07/import-questions-forms.html
- Standardize your data using dropdowns & multiple choice rather than open-ended questions
- FormRanger Add-on pulls a list from a Google Sheet and makes them multiple choice or dropdown options in a Form - cloudlab.newvisions.org/form-ranger
- AutoCrat Google Sheets Add-on - generates docs, pdfs or slides based on rules that you set and content in your spreadsheet - cloudlab.newvisions.org/autocrat
- VLookUp formula - Vertical Lookup pulls information from a separate tab in spreadsheet-based on content in the first one - support.google.com/docs/answer/3093318
- Lock any tabs of your Sheets that you don’t need others to edit
- Use Concatenate (support.google.com/docs/answer/3094123) & Substitute (support.google.com/docs/answer/3094215) to create URLs for things like links to Google Maps - Screenshot
- Additional Audio Content from this episode available here: traffic.libsyn.com/eduducttape/EDT037_Bonus_Content_with_Andreas_Johansson.mp3
- Screenshot of the Field Trip pivot table discussed in the bonus content
- Content from the Duct Taper Community
- Apple Podcasts Review - None to share
- Favorite #EduDuctTape Tweets: (each handle is linked to the mentioned tweet)
- New #EduDuctTape Tweeps: @atkauffman, @BandaBookChat, @breicher, @dailystem, @DominicSlauson, @edtech_workshop, @ehlmstech, @flrimmer, @HeskTech, @hickstro, @itsthemitchell, @jesshugSTEAM, @KarlOLeary4, @KenFromNelson, @kklaster, @Liftoff2Learn, @michelecarmode, @Mr_van_W, @mrkgsw, @MrsDi, @MsRomeroR, @mylifeaslinds, @Rrrerin2go, @SaiaStacy, @sdeereed, @shawnspaventa, @TechyLeaderEDU, @wagjuer, @Wainscott_Tech
- #EduDuctTape FlipGrid Responses: Skipped today for time