Skip to main content

Going Google #3: I have all this data from my form...what do I do with it now? Part 1

By Jessica Winstanley
It is no secret that I love Google Forms.  Paul Murray and I frequently share our love of this easy to use data collection tool with our teachers and others around the state, like in this presentation from miGoogle 2013.  One of the problems I have with data collection, however, is what to do with all the information, and make it manageable, once you have it collected.  I often look at spreadsheets full of Form responses and wonder, "There are 200 responses here!  How am I going to make sense of all this?"  Thankfully, there are some really amazing add-ons and tools that, with little effort on the users part, can make the data come alive.

Tool #1: Add-on - autoCrat

As a teacher, I collect information from my students/families every year.  Information such as names, parents/guardians names, preferred email address, preferred phone number, best way to contact parents/guardians, etc.  This information can be easily collected with a Form at open house, parent night, or on a classroom website.  Once the forms are filled out, all the information can be reviewed in a Google Spreadsheet.  Wouldn't it be nice, though, to take all that information and have it automatically create a document for each entry that lists all the information for that particular child in a way that would be easy to read and reference?  Of course it would be!  This is where autoCrat comes in.  autoCrat is a document merge tool that works as a add-on in Google Spreadsheets.  It allows you to create a Google Doc or PDF and have information from your spreadsheet automatically populate the document with the specific information.  Here is a video to explain more about how to use autoCrat.


Classroom Uses:
  • Formative Assessments - Have students take a quick formative assessment using a Google Form.  Share their answers back with them using autoCrat.  autoCrat will also auto-create the document and send it out as the forms are filled in.
  • Sign Up Sheets - Ski Club Adviser?  Coach?  Activity Leader?  Have students/families sign up using a google form and automatically send them confirmation of their registration via autoCrat
  • Open House Information Sheets - Yup, I already mentioned this one above.


Tool #2: Add-ons - Merge by Mail Chimp

Sometimes you don't need a fancy document, you just want to send out an email to the respondents of the form with the some (or all) of the information collected in the form.  If this is the case, then the Add-on Merge by Mail Chimp - found in documents, is the tool for you.  Check out this easy tool in the video below.



Classroom Uses:
  • Formative Assessments - Have students take a quick formative assessment using a Google Form.  Share their answers back with them via email with Merge.
  • Confirm responses to a survey or form via email
  • Send out a personalized email to a group
Labels:

Comments

Post a Comment

Popular posts from this blog

Google Docs: Fonts for Early Elementary

By Jessica Winstanley
Sample of search results from fonts.google.com A couple weeks ago, I was sitting in a training with a bunch of my favorite lower elementary teacher friends, and several of them were lamenting the fact that it is hard to find "good" Google fonts for the little people they work with on a daily basis.  Specifically, it is a challenge to find the single story lower case a and the open 4 .  This conversation, of course, sent me out on a mission to remedy this for these fantastic people.  So, the next day I put on my headphones, turned up the tunes on Spotify, and dived into the website fonts.google.com .  This website lists all the Google fonts available.  It also allows you to type in your own letters and numbers and see them in all the various fonts.  For my purpose, I typed in "abckgy 1234 This is the font."  From here I could see all 877 fonts, and look specifically for the a   and the 4.  It was quite an adventure, and I came across a lot of really awesome font
Post a Comment
Read more

It's time to change your password!

By Jessica Winstanley
There are several times a year when it is important to change your password.  Your password will expire every 90 days. When your windows computer informs you that your password will be expiring soon, CHANGE IT THEN! It is also always a good idea to change your password before going on break so that you do not get locked out of your computer, email or gradebook.  Here is how you change your password from the school windows computers. On your Windows desktop/TEC computer , press the Alt, Ctrl and Delete buttons at the same time. Click on "Change a Password" on the menu below: Enter your username, if needed, and follow the directions on screen. If you are off site or working solely on a Chromebook , you can use the VDI (Virtual Desktop) to change your password.   Simply go to vdi.portageps.org.  Click "VMware Horizon HTML Access."  Click "Accept."  Login with your portage username (leave off the @portageps.org) and password.  Click "Login."  Cli
Post a Comment
Read more

Skyward Tech Tip: Unlocking a Closed Grade Period

By
Have you recently attempted to change a grade from last quarter only to be met with the statement “ This Grade Period is closed for Grade Entry “? This occurs because the date for the end of a marking period or quarter has past and that grading period has been locked in the Skyward Gradebook. Below you will find the process for changing term grades, assignment scores, and other information from past grading periods. Google Docs Version Go to your gradebook Let’s start with the gradebook for the class where you need to make a change. In this example, we will be adding a score to a missing assignment and removing the incomplete grade from the quarter grade. (Note: The process to open or unlock the gradebook is the same regardless the change you need to make.) This change will be made for marking period three, Q3. In that marking period column, click on the “Options” dropdown button. From the Options dropdown, choose “Grade Posting Status for Term QX”, whe
Post a Comment
Read more