Skip to main content

An Afternoon at Truman

Dr. Sparks invited LINC to share information on GoogleForms during two sessions during today's half-day. This is what we intend to cover (plus posting on our Blog means the resources are there when you need them)!
Google Forms is a useful tool to help you plan events, send a survey, give students a quiz, or collect other information in an easy, streamlined way.

A Google form can be connected to a Google spreadsheet. If a spreadsheet is linked to the form, responses will automatically be sent to the spreadsheet. Otherwise, users can view them on the “Summary of Responses” page accessible from the Responses menu.

Google Forms - official Google help page.  Look on the right side of the page for additional form topics.

Possible Roles in the Classroom
      - Formative Assessment, HW assignments, WS alternatives
      - Data Collection (Science, stats, Math) to graph (especially for class-wide experiments)
      - Self/Peer Assessment (checklists), Performance Critiques

      - Student Goal-setting
      - Opinion Polls/Surveys
      - Sign-up sheets

Let's Build a Homework/Bellringer Piece:
1. Create a Form.
2. Choose how students will identify themselves.
3. Create several questions (question types).
4. Embed support materials (such as images or YouTube videos).
5. Share it with a buddy and take the quiz.

A tour of Google Forms - this will show you how to create a form to the collection of the results.

What's the Data Look Like (and where'd it go)?:
1. From within the form, find "View Responses" and choose to open with a new spreadsheet.
2. Now, you have two connected documents: the form itself and the spreadsheet that shows data collected.
3. View the pretty charts by clicking Summary View.
4. Managing your data by filtering and conditional responses.
5. Color coding (conditional formatting) and formulas can help flex grouping/grading.

  • Summary View - overview of responses
  • Spreadsheet - in depth review of responses

New features in Spreadsheets- just out TODAY!

Taking it Further:

  • Adaptive Quizzes using page breaks and MC questions to allow a wrong answer to take you to support materials (images, YouTube videos).

Flubaroo - Grading Made Easy
Flubaroo is a free tool that helps you quickly grade multiple-choice or fill-in-blank assignments. This was designed by a teacher for classroom teachers.

Watch the demo video of how Flubaroo works.  Pay close attention to how easily it shares the results with your students.

Follow these steps to create an assignment for you class.


Popular posts from this blog

Your shoeboxes are full...break is a perfect time for this app.

1994 - Somalia just south of Mogadishu. 
We all have tons of actual physical pictures and would love to digitize them. Have you ever taken a picture of a picture? It usually looks awful, too dark or full of glare.

This break why not download the PhotoScan app from Google and start sharing those old pictures! This is a free app that works on both Android and iOS.

Download and install the PhotoScan app.
Follow on screen prompts.
Follow the arrows. You will move the open circle to the closed white circle. The while circle will turn blue, then follow the arrows to the next circle.
Bam! You now have an image that is digitized and ready to share! 
My next steps will be to open this in the Google Photos app and start to adjust the color a little.

Well that didn't go as expected...

I had this idea that I thought would be epic. The point was to help teachers see the power video can have over people. I started by showing a tiny clip of the Slap Chop. This was a product from a few years back. The infomercial played on cable and in the wee hours of the morning but the thing sold making someone millions.

The original video moved people to remix it.  That sold many more Slap Chops. Just google Slap Chop Remix, it is hilarious!

The final outside of education idea was the My Pillow.  You might have seen this on the news lately for deceptive advertising practices. Even after the news and government told people not to buy it, they still bought pillows. So many the company is manufacturing 25,000 pillows every single day. That is not a small number of pillows.

These three examples were meant to show the power of a convincing video. These videos moved people to do something they might not otherwise do on their own.

The final was to show how a student uses video to convince…

Shortcuts - we all love them.

Here are a few keyboard shortcuts for Windows 10 that we find useful. Somewhere I read that using the keyboard is actually more efficient than the mouse, try it and see what you think.

All of these shortcuts will require you to use the Windows key on the keyboard. Where is the Windows key? Look on the lower left side of your keyboard. The key has four white squares on it, it kinda looks like a window with four panes.

Hitting the Windows key alone will open the Start menu in the lower left side of your laptop screen. Hitting that key in combination with others allows you to do some amazing things saving tons of time.

Windows Key + D = Display and hide the desktop. When I am using Chrome and I need to quickly get back to the desktop, no more hitting the little minus sign in the upper corner of the browser window.

Windows Key + E = Opens the File Explorer, similar to My Computer from back in the day. I use this when I have to pull a file from a flashdrive or SD card.

Windows Key + Right/Le…