GC: Forms
Meet Google Forms
About
Need to make survey and don't want to end up with a million emailed responses? Use Google Forms to make a survey to gather data and information. You can add questions with a variety of ways for respondents to put in information. Those ways include multiple choice, drop down, grids, scales, date, time, short or long responses.
Even more exciting, you can create forms that have YouTube videos and/or images. Videos can appear before or after questions,while images can be used as part of a response/answer to a question.
Self-Assess: Turn and Talk
Review the checklist below. What do you know how to do? When you are done reflecting, Turn and Talk with someone nearby. Do this:
- Share ONE thing you know how to do well.
- Share ONE thing you want learn more about.
Gather Info with Google Forms
I can create a new Google Form.
I can add a variety of questions to a form using different questions types (short answer, paragraph, multiple choice, checkboxes, and dropdown).
I know how to make the question required.
I know how to customize the theme.
I can find and understand how the general settings work: progress bar, shuffle order and show link to submit another response.
I know how to add a confirmation message.
What Can I Do With It?
- AutoCrat
- Make Your Own App with Glide and Sheets
- Mail Merge for Email
- FormMule
- Yet Another Mail Merge (YAMM)
You can do a lot more with Google Forms, but these are only three of the things possible.
Exploring Google Forms
PowerTools (or Add-Ons) for Forms
1-Google Forms and AutoCrat
AutoCrat makes it easy to automate merging of data from a Google Form into a Google Doc or Adobe Portable Document Format (PDF). This is pretty easy, but it requires you to be aware of several components.
2-Make Your Own App with Google Sheets
Glide is a service that lets you add information to a Google sheet, then quickly create an app from its contents, all without coding. Just pick one of your sheets and Glide assembles it into a polished app that you can customize, share with a link, and even publish to the app store.
3-Mail Merge Tools for Email
Wish you had a way to send emails like you print labels? Then email merge is your tool of choice. Tools like Yet Another Mail Merge and FormMule make sending out bulk emails to your students, colleagues, friends, and family easy as compiling a list in Google Sheets.
Important Info To Keep in Mind
Free Gmail account: If you use a free Gmail account, you are limited to sending a maximum of 500 emails in a 24-hour period, and a maximum of 100 addresses per email.
Paid Google Workspace account: If you use a paid Google Workspace account, you are limited to sending a maximum of 2,000 emails in a 24-hour period.
Mail Merge Tool #1: FormMule
Tip #1 - Send out custom directions or information. Need to send out Home Learning Codes for Seesaw? Seesaw provides you with a comma-delimited file that you can use. Use bulk email for that.
Tip #2 - Create custom comments in English or Spanish. Put comments can be placed in different columns, then include them in the text/body of your email. Some examples of English comments can be seen in this blog from Scholastic and Spanish ones are available here.
Get Stuff You Need First
In Google Sheets, get the FormMule add-on
Prepare Your Mail Merge Data
In Sheets, create your Sheets with Name and Email columns of data, at minimum
In Sheets, work through FormMule wizard. You may want to compose your HTML email in a text editor to get it to look the way you want
Sending Bulk Email
Send total emails your Gmail account supports (500 or 2000) with FormMule
Copies of sent emails are saved in your Gmail Sent folder
Track job completion with your emailed message in Sheets
Mail Merge Tool #2:YAMM
Get Stuff You Need First
In Google Sheets, get the YAMM add-on
Prepare Your Mail Merge Data
In Gmail, create a draft copy of your email and leave it in your Draft folder, unsent. Put {{ }} around merge tags, such as: {{FirstName}}
In Sheets, create your Sheets with Name and Email columns of data, at minimum
Sending Bulk Email
Send 50 to 100 emails using YAMM Add-On (see pricing for more)
Copies of sent emails are saved in your Gmail Sent folder
Track interaction with your emailed message in Sheets
Templates and Tasks
Here are a few templates you will want to explore:
Find a Time
Quiz Maker - Insert video from TeachFlix or YouTube
Project #1: Create a Climate Survey for Your Organization
Instructions go here
Project #2: Create an AutoCrat Online Certificate Generator
Click a folder whose color you want to change
Right-click the folder and select your preferred color for the folder
Add special characters like exclamation marks and emojis to put them at the top of the list
