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
Check out the EdTech News Brief! Online - On Apple Podcasts - On Spotify - On Amazon Podcasts -
info_outlineEducational Duct Tape: An EdTech Integration Mindset
In this episode, I share with the loyal Duct Taper listeners some news about the current and future status of the show. Plus, a little peek into life in my household. Find the show notes online at jakemiller.net/eduducttape-episode-73 Want to reach out? 📧 JakeMillerTech [at] gmail [dot] com 📲 @JakeMillerTech Ways to Support the Show or Connect with Jake & other Duct Tapers! Apple Podcast Reviews #EduDuctTape on social media Telling your friends & colleagues The Duct Tapers Facebook Group - Stickers! Want to pass some out? Want some for yourself? The JakeMillerTech...
info_outlineEducational Duct Tape: An EdTech Integration Mindset
Al Thomas, the Edu Copilot, joins the podcast to talk about visual storytelling. We discuss multiple apps including Adobe Creative Cloud Express, Canva, Adobe Premiere Rush, Adobe Capture, Adobe Photoshop Lightroom, Apple Clips, DaVinci Resolve, and Final Cut. #EduDuctTape S04-E72 Find the show notes online at Today’s Sponsor: The Toddle TIES Inquiry Educators Summit! - TIES is back for its third and largest edition yet. Designed to be a festival of learning like no other, TIES 2022 will feature 100+ phenomenal thinkers and doers across 10+ unique session formats. Whether you want to...
info_outlineEducational Duct Tape: An EdTech Integration Mindset
In this bonus episode, I chat with Batsheva Frankel about some great tech tools and we have lots of laughs! Show Notes available at Check out the Overthrowing Education Podcast at Check out this episode as well as the show notes at This episode is featured with the permission of Batsheva Frankel, host of the Overthrowing Education Podcast. Audio Endorsements for Jake’s Book - Submit your book endorsement on Flipgrid or Speakpipe! Ways to Support the Show or Connect with Jake & other Duct Tapers! Apple Podcast Reviews #EduDuctTape on social media Telling your...
info_outlineEducational Duct Tape: An EdTech Integration Mindset
Podcast host, high school teacher, podcast producer, university professor, and podcast network founder Chris Nesi joins the show to talk all about podcasting in the classroom. We cover a podcasting mindset, different types of podcasting, tools for micro-podcasting, tools for recording, editing, and hosting and, of course, a few microphone recommendations. Find the show notes online at Today’s Sponsor: The Toddle TIES Inquiry Educators Summit! - TIES is back for its third and largest edition yet. Designed to be a festival of learning like no other, TIES 2022 will feature 100+ phenomenal...
info_outlineEducational Duct Tape: An EdTech Integration Mindset
Stephanie Howell joins me to share what she’s learned in her experience designing student choice activities. She also shares some great Google Slides design tips. Find the show notes online at Soapbox Moment: “Is EdTech Luke Skywalker or Darth Vader?” Today’s Guest: Stephanie Howell Bio: Stephanie is the CEO of , a Google for Education Partner, a founder of , and the EdTech Lead for Pickerington Local Schools. She is key to the embedding and implementation of EdTech tools across her schools and organizations. She has a Master's in Curriculum and Instruction. Twitter - GoldEDU...
info_outlineEducational Duct Tape: An EdTech Integration Mindset
In this bonus episode, I chat with Adam Cobb and Ashley Pursley about podcasting, the adjacent possible, Teachers Pay Teachers, professional development through collaboration and sharing, and dogfooding. Show Notes available at Check out the a5iTalks Podcast at Check out this episode as well as the show notes at . This episode is featured with the permission of Adam Cobb, Ashley Pursley, Danae Acker, and Erin Darnell, hosts of the a5iTalks Podcast. . . . . . . . . . . . . . . . . . . . . . Audio Endorsements for Jake’s...
info_outlineEducational Duct Tape: An EdTech Integration Mindset
Nyree Clark joins the show to share a set of observable practices that we could see a culturally responsive practitioner using in their classroom. Also, Jake talks about LMSs and shares how to use pivot tables in Google Sheets to select the highest test score for each student Find the show notes online at Soapbox Moment: THROWBACK - “What I learned from a beard and glasses” Original episode: Today’s Guest: Nyree Clark - Nyree is an EdTech Curriculum Program Specialist for the Colton Joint Unified School District. She is a founding co-member of and was appointed to the...
info_outlineEducational Duct Tape: An EdTech Integration Mindset
Dr. Will Deyamport joins the show to talk about effectively building your curriculum in your learning management system (LMS) and a collection of compelling reasons that Schoology might be the LMS for you. Also, Jake answers a listener’s question about design thinking games. #EduDuctTape S04-E68 Find the show notes online at Soapbox Moment: Functional Before Fancy Today’s Guest: Dr. Will Deyamport - As seen on Forbes.com and Schoology, Dr. Will, as he is better known, is a District Instructional Technologist specializing in assisting educators in going digital. In this role, he delivers...
info_outlineEducational Duct Tape: An EdTech Integration Mindset
Jeni Long and Sallee Clark join to talk about fun projects that students can do to demonstrate their learning. The Microsoft Teams Playbook authors share about Canva for Edu, Buncee, Book Creator, Wakelet, and PowerPoint. Also, Jake answers listener questions about word clouds, Jamboard, and Seesaw. Find the show notes online at Soapbox Moment: A Throwback!!! “Adjacent Possible” Sound effect - “Popcorn Dream.wav” by breyenkatz - Original Episode - Today’s Guest: Jeni Long Sallee Clark (su-lee) Bio: Jeni Long & Sallee Clark are global speakers, EdTech consultants,...
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