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...
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." ...
Post a Comment
Read more

Skyward Tech Tip: Student Birthday List

By Jessica Winstanley
Would you like to get a list of your students' birthdays from Skyward? This can be done in just a few clicks. Step 1: Login to Skyward and select the blue gradebook for the class you want to print usernames and passwords for - elementary staff, you can just select any of your gradebooks. Step 2: Go to the reports menu at the top of the screen and select Class Roster. Step 3: Choose Student Name & Student Info, then select Clone Template. Step 4: Give your new template a name, such as Birthdays. Click Save. Step 5: Select how you want the Names to Display, then UNCHECK all the boxes. Now only check Birth Date. Click Save. Step 6: Now you can select the template you just created. Click Print. Step 7: A PDF preview will open. From here you can choose to save or print. You do this by placing your curser in the bottom right corner of the screen and clicking on the picture of the disc (save) or the printer (print). This is what the report would look like:...
Read more