Andreas Johansson + Google Forms, Sheets & Sites; FormMule, AutoCrat & FormRanger Add-Ons; VLookUp, Concatenate & other Formulas; Lean Thinking and more!

#EduDuctTape S02-E037

#EduDuctTape -- -- @JakeMillerTech -- --


  • Additional Audio Content from this episode available here:
  • Ways to Support the Show or Connect with Jake & other Duct Tapers! 
  • Certificates of Listening, Laughing, and Learning!
  • #EduDuctTape Twitter Chats
  • 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!
  • Jake’s Upcoming Events
  • Jake on Other Shows: The MagicPotionEDU Podcast -
  • Today’s SoapBox Moment - “The How & The What”
  • Today’s Guest: Andreas Johansson
  • 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 -
    • “Go to the work where the place happens to see what’s truly happening.” - the 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
    • Keep the end-user in mind
    • Pre-Trip Certification Form:
    • Graphics for buttons -
    • 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…
  • Additional Audio Content from this episode available here:
    • 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











from Educational Duct Tape

No comments

Thank you for adding to the conversation!

Note: Only a member of this blog may post a comment.

Powered by Blogger.