Andreas Johansson + Google Forms, Sheets & Sites; FormMule, AutoCrat & FormRanger Add-Ons; VLookUp, Concatenate & other Formulas; Lean Thinking and more!
Release Date: 02/19/2020
17 Takeaways from Season 3! (Fixed Audio)
Educational Duct Tape
In this episode we look back at some of the amazing things shared by my Season 3 guests! 17 awesome educators joined me on the podcast during 2020-21 school year and this is our chance to reflect on the great educational technology insights that they shared! ***FIXED AUDIO*** Show Notes available at Get on the Season 3 Finale Episode, Part 2! (1) Duct Taper Success Story, (2) Favorite EdTech Takeaway, (3) Favorite SoapBox Moment, (4) Favorite Giggle Moment 7:56 - Holly Clark - 10:44 - Dee Lanier - Sneak Peek… Educational Duct Tape: An EdTech Integration Mindset...
info_outline
BONUS: Osprey Reading Experience
Educational Duct Tape
Recently, I got to chat with my friend Brian Santimaw about merging reading and educational technology. We talked about how edtech can be a part of developing your school’s reading culture and about a bunch of tools including Flipgrid, Gimkit Ink, Google Earth, Google Arts & Culture, Pear Deck, Nearpod, choice boards, social media template activities, and others! Show Notes available at Check out the Osprey Reading Experience Podcast . Check out this episode and the show notes . This episode is featured with the permission of Brian Santimaw, host of the Osprey Reading Experience...
info_outline
Sam Kary - Engaging Learning with TPACK, SAMR, and EdTech
Educational Duct Tape
Sam Kary of The New EdTech Classroom YouTube Channel and blog joins me to talk about ways to develop engaging instruction, the TPACK and SAMR technology integration models, Actively Learn, Whiteboard.chat, Whiteboard.fi, and more! 🧼 Soapbox Moment: Sinus Pressure and Pandemic Teaching Pressure 🗣️Get on the Season 3 Finale Episode! (1) Duct Taper Success Story, (2) Favorite EdTech Takeaway, (3) Favorite SoapBox Moment, (4) Favorite Giggle Moment 📞 Today’s Guest: Sam Kary Sam is the founder of dedicated to showing teachers how to teach with technology. Sam believes...
info_outline
BONUS - The Peg Doesn't Fit
Educational Duct Tape
In April 2021, I had the opportunity to be a guest on The Peg Doesn't Fit, a podcast where the hosts Erich Stephen and Ryan Bartel discuss frustrations with the educational system and provide solutions. We spoke about some of my thoughts on edtech integration, professional development, coaching, and more!
info_outline
Kasey Bell - Dynamic Blended Learning from Shake Up Learning
Educational Duct Tape
Kasey Bell, host of the Shake Up Learning Podcast, and author of 3 books including Blended Learning with Google, joins me to talk about making blended learning meaningful and dynamic. We hear about her 5 “beyonds” of blended learning and her tips for using choice boards in the classroom.
info_outline
Dr. Desiree Alexander - Formative Assessment in Videos
Educational Duct Tape
Dr. Desiree Alexander of EducatorAlexander.com joins the show to talk about formative assessment with videos in the classroom. Desiree and I discuss Edpuzzle, PlayPosit, Razor Arts, Nearpod, and more! Plus, I’ve got a BIG announcement to share!
info_outline
BONUS: The Suite Talk, "Kick Of Your Lessons with Fun Activities"
Educational Duct Tape
In January 2021, I had the opportunity to be on one of my favorite sources of educational technology learning: Kimberly Mattina's YouTube Live + Podcast, The Suite Talk. In this appearance, I share some of my favorite ways to kick off my class periods with smiles and laughs. I focus on Pear Deck, but the ideas can be used in other platforms, too.
info_outline
Dr. Monica Burns - Leveraging Choice & Agency to Hear from All Students
Educational Duct Tape
EdTech and Curriculum Consultant and Easy EdTech Podcast host Dr. Monica Burns joins me to identify ways that we can hear from ALL of our students. Her suggestion? Select tools that can give our learners choice and agency in how we hear from them! Tune in to hear what tools she suggests!
info_outline
Eric Curts - Creative Projects with Docs, Slides, and Sheets
Educational Duct Tape
Control Alt Achieve author Eric Curts joins me to talk about creative projects with Docs, Slides, and Sheets including Stop Motion Animation, Choose Your Own Adventure Activities, Emoji Learning Activities, Rebus Stories, Blackout Poetry, and Pixel Art! We also touch on Canva for Education, Adobe Spark for Education, Google Forms headers, flashcard makers like Quizlet and Flippity.net, and more!
info_outline
Dr. Natasha Rachell - Engaging Instruction with Student Choice and EdTech
Educational Duct Tape
Dr. Natasha Rachell joins me in this episode for lots of laughs, but also to share some of her strategies for making instruction engaging. Natasha shares about student choice, choice boards, the Flipgrid Discovery Library, Microsoft Sway, Wakelet, Mentimeter, Buncee, and the awesome Minecraft Good Trouble project!
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