Tuesday, February 4, 2020

Google Form Fans, This One's for You!

Google Form Fans, This One's for You!

If Google Forms have become part of your regular routine, you may want to check out some of these time-saving tips.

Make a Google Form from a Spreadsheet.

I always say teacher time is too limited to waste!  Get the most out of your efforts when creating new materials!  This is why I always promote putting vocabulary terms and key unit questions into a spreadsheet first and foremost.  From there you can import them into a variety of online quiz games and assessments.

Google Forms is no different!  And, with the help of Alice Keeler of Teacher Tech you can create a form directly from a spreadsheet.   Go to alicekeeler.com/form to get started.  Copy and paste your questions from your unit spreadsheet or import this one later for a Quizz.izz, Quizlet or Kahoot !

*Be patient with the Add-On menu when you first try it.  It takes a moment to appear on the list.



Import Questions from one Form to Another
Now that you have an easy way to create a Form from Sheets, why not make a "Master Form" for your chapter, unit or novel?   Have the whole department collaborate on a "Question Bank" Form.  No one will really use this form, it will just hold your question inventory!

Then, when creating pre-tests, post-test, formative checks, spiral reviews, differentiated quizzes, etc  all you need is one button > Import Question to access your bank of pre-made questions.


Select the "Master Form" and quickly check off the questions you would like to reuse in your comprehension check, exit ticket or summative assessment.  Then POOF you are done, faster than you could have gone to the copier!

Let me know how I can help you make this and other tech work in your classroom or office!


Keep working smarter, not harder SMASD!

1 comment:

  1. I love importing questions from another form. Even if it is just name, period, quarter kind of questions. Forms rock my world.

    ReplyDelete