#EduDuctTape Episode 38!

Image shows a picture of Joe and Kristin Merrill, guests on this podcast episode.

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

“Interactive Learning is learning that is responsive and relevant, that engages students.”
Graphic created by Matt Meyer @54Mr_Meyer

 

Video by David Allan (@_david_allan)

#EduDuctTape Episode 37!

Promo Image for Episode 37, shows a headshot of Andreas Johansson

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:

Andreas Johansson: "I have the fortunate now to work with a lot of what's called classified staff, or as I think of it, the other 50% of a school district.
GIF created by David Allan.

Video created by David Allan.

CopyDown Add-On

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.

Enter the CopyDown Add-On

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:

CopyDown Add-On Animation

  1. Set up your Google Form.
  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).
  5. Click Add-Ons and follow the steps to add CopyDown.
  6. Click Add-Ons > CopyDown > CopyDown Settings.
  7. Flip the switch to “On.”
  8. Generally, I select to paste the results “as values” (otherwise it puts the formula itself into each cell which, if it’s a lengthy spreadsheet, will ultimately slow it down).
  9. Save Settings.
  10. Start gathering form submissions!

FormRanger Add-On

I love me some Add-Ons. One of my favorites is FormRanger from New Visions Cloud Lab. It can be used to pull in a column of information from a Google Sheet as multiple choice or dropdown options.

This is nice for quickly creating a lot of options for a multiple choice or dropdown question, but what takes it from nice to awesome is  . . . you can set it to automatically update based on changes made to the spreadsheet. Whaaaaat!?  I know, right?

There are two main cases for use: Continue reading FormRanger Add-On