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

#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:  @rocketcto eajohansson.net linkedin.com/in/eandreas youtube.com/user/TheEajohansson 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: Screenshot 1 Screenshot 2 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) @AngelaGreene12 @MrsDi @hartel30 @MrCoachK15 @engageducate 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