## #EduDuctTape Episode 38!

In the 16th episode of Season 2, I am joined by Joe & Kristin Merrill, 1st & 4th grade educators & authors of The InterACTIVE Class, to talk about making our classrooms and our students’ learning experiences InterACTIVE.  We discuss Apple Clips, Buncee, Seesaw, BookCreator & Flipgrid. Also, a game of edtech BFF!

See the Show Notes Here

Video by David Allan (@_david_allan)

## #EduDuctTape Episode 37!

In the 15th episode of Season 2, I am joined by Andreas Johansson to talk about things that we can do to support less tech-savvy staff members, especially non-teaching staff. Tools discussed include Google Forms, Sheets & Sites; the FormMule, AutoCrat & FormRanger Add-Ons; the VLookUp, Concatenate & Substitute Google Formulas; Lean Thinking and more!

See the Show Notes Here

BONUS CONTENT: This audio was not included in the regular podcast episode, but is available here for listening:

Video created by David Allan.

Years ago, as a STEM teacher, I had my students build basswood bridges.  We’d then test them by hanging weights from them.  I’d submit the results to a Google Form, which would kick it to a Google Spreadsheet, where a formula was all set up to calculate the “Engineering Efficiency” (a measure that leveled the playing field between heavy, strong bridges and light, strong bridges).  Unfortunately, formulas don’t automatically apply to the new rows created by new Form Submissions. I had to have a student manually drag the formula down each time a new result was submitted.

I later discovered this wonderful little add-on.  It automatically pulls that formula down to a each new form submission.  No manual dragging necessary.  This is super, super useful when your Form & Sheet are part of a bigger system that triggers other actions in other add-ons (i.e., autoCrat, formMule) that require those formulas.

Here’s a GIF of how it works, followed by a step-by-step guide to using it:

2. Open up the connected Spreadsheet.
3. Start with an initial form submission.  You’ll need this in the next step.
4. Create your formulas in Row 2 (the row with your first submission).