Andreas Johansson + Google Forms, Sheets & Sites; FormMule, AutoCrat & FormRanger Add-Ons; VLookUp, Concatenate & other Formulas; Lean Thinking and more!
Release Date: 02/19/2020
Mini011 - David Allan - Chromebook Accessibility Features + a Special Announcement
Educational Duct Tape
In the 11th mini-episode, Jake talks to Special Education Consultant David Allan about some of the accessibility features available on Chromebooks. Also, Jake shares a special announcement before the interview.
info_outline
Catlin Tucker, Feedback in Blended Learning, SE2R, Real-time Feedback, 1:1 Conferencing, Tips for Efficient Digital Feedback
Educational Duct Tape
In the 19th regular episode of Season 2, Jake is joined by Catlin Tucker, author of Balance With Blended Learning, to talk about how teachers can streamline feedback during class time so that they have less to do outside of class time. Catlin shares strategies from John Hattie and Mark Barnes as well as a handful of great tech tips to make feedback more efficient!
info_outline
Mini010 - Dan Stitzel - Using Screencasts to Give Feedback to Students
Educational Duct Tape
In the 10th mini-episode, Jake talks to Technology Integration Coach Dan Stitzel about the success that he had as a middle school language arts teacher with using Screencastify to give students feedback during the writing process.
info_outline
Supporting Students with Special Needs in Remote Learning with Accessibility Features, Assistive Technology, Accommodations, Modifications and more!
Educational Duct Tape
In the 18th full episode of Season 2, Jake shares tips, ideas, and recommendations from multiple educators about supporting students with special needs during remote learning. They discuss different accessibility features and assistive technologies within Chromebooks, iPads, Google Chrome, Microsoft and more, as well as some best practices, accommodations, and modifications.
info_outline
Special Remote Learning Episode, Part 3: Tracking Student Progress in #RemoteLearning
Educational Duct Tape
In the 3rd and final part of Episode 17 of Season 2, Jake continues his coverage of edtech ideas and suggestions for Remote or Home Learning during the covid-19 pandemic closures. In this episode, Jake shares the perspectives of 3 educators (plus his own) for tracking students’ progress during remote learning.
info_outline
Special Episode: WeVideo Giveaway
Educational Duct Tape
In this special episode, Jake is joined by Manny Curiel from Episode 36 and Jason Sholl from WeVideo to select the 3 winners of the February 2020 WeVideo contest! The winnerswill receive free WeVideo for Education Licenses for 12 months. 1 is a 30-seat license, 1 is a 50-seat license and the big prize is a 150-seat license!!!!
info_outline
Special Remote Learning Episode, Part 2: Formative Assessment in Home Learning Situations and lots of FUN!
Educational Duct Tape
In the 2nd part of episode 17 of Season 2 Jake continues his focus on the use of technology for #RemoteLearning, #HomeLearning or #DistanceLearning in the age of school closures for the coronavirus (covid-19). Multiple guests share their advice for formatively assessing students in these scenarios. Tools discussed include Quizizz, Zoom, Google Forms, Google Classroom, Screencastify, Edulastic, EdPuzzle, PearDeck, and Formative. Also, Jake’s son Cohen joins to show off his comedy chops.
info_outline
Special Remote Learning Episode, Part 1: Live, Synchronous Video Options, Advice, Thoughts and FUN!
Educational Duct Tape
The 17th episode of Season 2 is the 1st part of a special episode focusing on the use of technology for #RemoteLearning or #DistanceLearning in the age of school closures for the coronavirus (covid-19). Multiple guests share their advice for using live, synchronous video in these circumstances. We discuss StreamYard, OBS, Zoom, Google Meet, Screencastify and Flipgrid.
info_outline
March 16, 2020 Announcement
Educational Duct Tape
Jake shares a special announcement about an upcoming episode in the days of Coronavirus-induced remote learning.
info_outline
Mini009 - Missy Paden talks Choice Boards, tech in 1st Grade and more after the #EduDuctTape Workshop
Educational Duct Tape
In the 9th mini-episode, Jake and 1st grade teacher Missy Paden reflect on the first iteration of the Educational Duct Tape Workshop along with Missy’s goal of using Choice Boards, her experiences with using tech in the primary grades, and her growth and excitement around #edtech in her 18th year in the classroom.
info_outline#EduDuctTape S02-E037
#EduDuctTape -- EduDuctTape.com -- @JakeMillerTech -- JakeMiller.net -- JakeMillerTech@gmail.com
- 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