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
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_outlineEducational 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_outlineEducational Duct Tape: An EdTech Integration Mindset
Is the goal to complete the task… or to grow stronger? In this episode, I reflect on Rick Wormeli’s article “With A.I., Let’s Keep Students’ Learning Paramount” and what it means for educators navigating AI in classrooms. I also share updates on Common Sense Media’s free ChatGPT course, Google Classroom’s new “Grade All” feature, the CoSpaces rebrand to Delightex, and a TED Talk that might change how you view success. Vacuum metaphors, forklifts, and academic cosplay—press play! #EduDuctTape Episode 121 0:00:00 INTRO 0:04:01 Soapbox Moment: The Forklift, the Roomba, and...
info_outlineEducational Duct Tape: An EdTech Integration Mindset
How can we empower students to self-assess their learning? In this episode, Shantel Lott joins me to explore tech tools and strategies that foster reflection and agency. We chat about Snorkl, NotebookLM, Curipod, Knowt, and MagicSchool’s Custom ChatBot. I also share updates on using Google Gemini with Teens, Padlet Sandbox’s new sound and visual effects, and the magic of generating Google Slides with Alayna AI. #EduDuctTape Episode 120 Today's Sponsor M2 by Swivl - Today’s Guests: Shantel Lott Shantel is an EdTech enthusiast and Lead Learning Guide at friEdTech. Certified in Google...
info_outlineEducational Duct Tape: An EdTech Integration Mindset
What’s new in edtech? In this episode, I break down Google’s new parent permission requirements, an awesome Google Classroom add-on, and Screencastify’s expanded free plan. Science teachers, you’ll want to hear about PhET Simulations inside Quizizz, and we’ll discuss Common Sense Media’s latest report on AI in education. Plus, I’ll wrap up with a thought-provoking book that challenges how we create change in schools and communities. Tune in for all the updates and insights! #EduDuctTape Episode 119 - Google TOS Privacy Changes, Magic Exercise Book, Screencastify, Quizizz x PhET,...
info_outlineEducational Duct Tape: An EdTech Integration Mindset
Today on the Educational Duct Tape podcast, I’ve got five edtech updates that might impact your classroom and one educational strategy that’s new to me. I’ll start with the bad news first, which is Bitly adding ads to short links (not cool, Bitly) and then get into the good news, like a new educator-made alternative to Bitly and an AI teaching assistant from Padlet. Plus, handy updates from Pear Assessment and Quizizz that could save you some serious prep time. And then that educational strategy called Talking Chips. Curious yet? Press Play! #EduDuctTape Episode 118 Edu News I’ve...
info_outlineEducational Duct Tape: An EdTech Integration Mindset
How can we create more flexible, accessible, and differentiated learning experiences? In this episode, I chat with Adam Juarez and Katherine Goyette (husband and wife duo AdaKat) about tools and strategies to make learning more inclusive. We explore MagicSchool, Quizizz, Mote, Immersive Reader, Goblin Tools, MirrorTalk, Factors Education, Helperbird, Google Docs Voice Typing, and more. Plus, we dive into AI-powered tools like Perplexity AI, Diffit, and SchoolAI and creative solutions like image generators in Canva and Adobe Express. I also share updates on interactive charts in Canva, new Pear...
info_outlineEducational Duct Tape: An EdTech Integration Mindset
In today’s episode, I kick things off with a Soapbox Moment relating to a new CommonSense Media report about the gap between the AI-awareness of teens and their parents—and what that means for us as educators. Then, we’ll explore five updates! We’ve got a game-changing differentiation feature in Google Classroom, an time-saving resource in Canva’s Teacher Work Kit, an upgrade to Pear Deck with Graded Mode, a great learning opportunity from Google, and a powerful classroom culture strategy called Feedback Friday. #EduDuctTape Episode 116 Today's Sponsor Short Answer - use code...
info_outlineEducational Duct Tape: An EdTech Integration Mindset
Adam Sparks is back to continue our conversation about writing instruction in the age of AI. We’re diving into even more actionable strategies, from using tools like ShortAnswer to embedding more writing across the curriculum to help students recover those lost writing reps. Plus, we tackle big-picture topics like teaching students to use AI effectively, leveraging AI in scoring state-level assessments, and being intentional about making learning relevant. And stick around for updates from Pear Deck, MagicSchool, and Screencastify Submit. #EduDuctTape Episode 115 Today's Sponsor Swivl - ...
info_outlineEducational Duct Tape: An EdTech Integration Mindset
Adam Sparks joins the show to convince every educator to ditch AI-detection tools and focus on what really matters: the writing process. We discuss alternatives to AI-detection like Brisk, Draftback, revision history tracking, and Short Answer and share actionable strategies to teach writing effectively in the age of AI. From fostering transparency with students to leveraging powerful tools for formative assessment, this conversation is packed with insights to elevate your writing instruction. Plus: Instant Pear Decks, Canva Dream Lab, and new Google Forms Settings. #EduDuctTape Episode...
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