lgms media

weekly snapshot and tips


Make life all better.

tech tip takeaway: Google Forms

This week's tech tip was a website that provided 20 "practical" ways to use google forms. ( http://ditchthattextbook.com/2016/09/08/20-practical-ways-to-use-google-forms-in-class-school/)

A lot of the suggestions are things I had never thought, and a lot of them were things that I really don't think would be necessary in a classroom. You can decide.

Here are the five I found most useful:

1. Sign-out sheets — "Ditch the sign-out sheet when students leave and return from the room (or when they check equipment in and out). Use a Google Form instead! Use the CheckItOut add-on. It uses multiple choice, list or check boxes questions. When something is signed out, it moves to another question — the signed-out group. When it’s signed back in, it’s moved to the signed-in question. Create a “Name” short-answer question and you can see the paper trail of who checked equipment in and out and at what time in the spreadsheet of results " I see this being helpful if you have headphones or textbooks in your class!

2. Sign-up sheets — "Need students or parents to sign up to bring something to class, work the concession stand, etc.? Have them sign up in a Google Form! Want to eliminate a choice once someone has taken it (i.e. remove a time slot when it’s been claimed)? Use the Choice Eliminator add-on to remove that choice after someone makes it (so nothing gets claimed twice!). Check out the Choice Eliminator page to see how it works." I used this for my book fair volunteer sign up sheet. It worked great for gathering contact information.

3. Autograded quizzes — "If you create a quiz or other assessment with closed-ended questions, Google Forms will autograde it for you. Create your quiz and click the gear (settings) button. Choose the “Quizzes” tab and turn on “Make this a quiz”. You have some options in that window. Then, go through your questions and select the correct answer (your answer key)." I've never done this one, but it sounds easy enough.

4. Quizzes with Flubaroo —" Flubaroo is an add-on to Google Sheets that can create a detailed grading summary with student results from an assessment. When students complete a quiz/assessment in Google Forms, click the “Responses” tab and click the little green Sheets button. This will create a spreadsheet of results from the quiz/assessment. Open that sheet. Flubaroo’s official user guide walks you through the steps of setting Flubaroo up to autograde your assessment. It creates a summary that shows average student grade, individual student grades (plus which questions each student got right or wrong), questions students struggled on, and more." Again, never used, but sounds pretty cool.

5. The Amazing Race, Google Style. "This game is an intense mashup of Google Slides/Documents, Google Forms and Google Maps (optional). Students must complete several challenges provided by the instructor using Google Slides or Documents. Once the complete the first challenge in the slide presentation or document, they submit the link to the presentation/document in a Google Form. Once submitted, the link to the next challenge in the game is in a link on the confirmation page for the form. Clear as crystal, right? No? Check out this outstanding example by Michelle Green. Once you get it, this activity is super engaging."It had the word "amazing" in it so it has to be good.

Things to know for today

1. The book fair/library is open until 2

...but still closed during IF.

2. we'll re-open around 3

...for any student or teacher wanting a book for the break.

3. watch your email and think of one deserving student per team

Last spring I did $10 gift certificates for deserving students who may not be able to shop the book fair due to financial hardships. Think of one student per team that you want to nominate. I'll send out instructions on how to notify that student and what to do next.