Sunday, August 5, 2012

Amazing things with Google Forms! (IMPORTRANGE)

This tutorial is the second of two parts and covers how to use the IMPORTRANGE feature of Google Docs.

The first part (coming soon!) covers the VLOOKUP feature of Google Docs and is a pre-requisite to this tutorial. CLICK HERE

I utilize the IMPORTRANGE feature in my Flipped Classroom to help organize the submissions of Online WSQs.

In the past, I would have to sort through all the WSQ submissions and try to figure out who had submitted it and who hadn't.  Then, I would have to constantly open spreadsheet after spreadsheet since there were 3-5 spreadsheets eah week!  It was a pain in the butt and took a ton of my time!

Then... here comes the power of Twitter!  I made a quick screencast of the problem and what I wanted to be able to do and tweeted it out.  That afternoon, I heard back from an amazing new "tweep" who worked on a formula and taught me how to use it via Google+ Hangout.

Since then, I have now applied this formula to merge together needed data from well over 25 spreadsheets and am excited to use it once school begins.

The IMPORTRANGE feature can be used for more than what I show below, but this will show you the basics of what the formula includes, what the pieces mean, and conceptually what is actually happening.

Feel free to leave comments on my blog (I've blocked comments on the YT video itself) if something is confusing.  It makes sense to me because I've been playing around with it for a month or so... if it's not clear, please let me know!


  1. I am very new to Google Docs. Could you please help me with my question? I posted items in My Big Campus for students to access with iPads. He files open up fine using Pages or Adobe, and students can then fill in their answers. Can the completed work then be sent to Google Docs? I'm looking for a quick way to see who turned it in (much like your video).

    1. Hi Alicia,
      I have never used my big campus so I am not sure how google docs is incorporated with it. Sorry!!


Related Posts Plugin for WordPress, Blogger...