Cloud Print Saves Forms Individual Data…

Recently in the  Google Drive Help Forum  a user asked, “Is there a way to save Google Forms Data other than linking it to a spreadsheet?” My answer was, “Of course you can!” The user wanted the individual student data to appear as individual printed pages rather than viewing it in a spreadsheet. Thanks to the “Power of Cloud Printing” it is possible to save this information as a PDF File directly to Google Drive.

The PDF may be split into individual pages to share with the students or parents. Teachers can split the PDF into pages by using an online file splitters such as: “I love PDF” or “Split PDF”.  This will enable the teacher to attach the PDF page to an email or share via Google Drive.

NOTE: It is best practices and  recommend to link a Google Forms  Assessment Data to a Spreadsheet. The reason is due to the analytics capabilities built into Google Sheets for assessing data.

How to Save Forms Data as PDF

  1. Open a Google Forms
  2. Select Responses
  3. Choose Individual
  4. Click More Icon Screen Shot 2017-05-01 at 6.08.12 AM
  5. Select  Screen Shot 2017-05-01 at 6.07.05 AM
  6. Printer Window Opens
    • Select Change
    • Pick “Save to Drive”
    • Click Save
  7. Open Google Drive
    • PDF can be found in “My Drive”

Forms create indiviual Response PDF.gif

 

 

Insert Google Forms Chart into a Google Slide

Recently this question was asked in the Google Doc Help Forum, “Can I insert a Chart from Google Forms into a Google Slides Presentation?” I started thinking about this question realized both students and teachers could benefit from the below directions. Adding data to a student project or classroom presentation makes it more engaging to the audience.

There are several steps to follow for inserting a Google Forms Graph into a Google Slides Presentation. It isn’t hard to do and the benefits are well worth it!

How to Insert Google Forms Chart into a Google Slides

First please link the Google Forms to a Spreadsheet:
  1. Open a form in Google Forms.
  2. At the top, click RESPONSES.
  3. Below, click More More.
  4. Select Response Destination
  5. Choose Create New Spreadsheet
Next insert the type of chart you want from the data collected into the spreadsheet
  1. Open a spreadsheet in Google Sheets.
  2. Select the cells with data you want to include in your chart. Note: To make labels on your chart, add a header row or column to your data.
  3. Click Insert > Chart.
  4. In the “Recommendations” tab, choose a chart style. For more options, click Chart types.
  5. To edit your chart, click Customization.
  6. To create the chart, click Insert.
Or use the explore tool to drag a chart into the spreadsheet
  1. Open a spreadsheet in Google Sheets.
  2. Click the Column with Data
  3. Click Explore Lower right corner
  4. Drag the Chart to the Sheet
  5. Click the Chart’s Down arrow to Move to a new sheet in the spreadsheet

Last Step: Insert Chart into Google Slide Presentation

  1. Open a  Google Slides Presentation
  2. Select Layout choose blank
  3. Go to Insert and Select Chart
  4. Click from Sheets
  5. Choose Sheet and Click Select
  6. Select the Chart 
  7. Click Import

Simple Tip for Resizing Google Forms Video

Resizing a Google Forms Video is as simple as “boiling water”.  “Fill the pot and turn on the heat and watch the magic happen.” Now place a students in front of a Google Forms with an enlarged video and surprises just may occur!

I like the idea of inserting videos for supporting answer mastery when using a Google Forms worksheet. The larger the video the more it stands out and better probability for student to click and watch. Try enlarging your next Google Forms Video and watch the “Magic Happen.”

HOW to Resize Google Forms Video

You will be happy to hear this it is still possible to resize a video in a Google Forms.
Please follow these steps:
  1. Open Google Forms
  2. Click Video symbol
  3. Select a YouTube video
  4. Click the Video (blue box lines appear)
  5. Click and Drag box corner outwards to make it larger

dec-28-2016-7-17-am-edited

 

Best Practices for Sending a Google Form

Due to my role as a Google Help Forum Top Contributor  I’ve learned sending a Google Form isn’t simple for everyone. If a Google Form isn’t shared properly it could cause a lot of chaos. Nobody wants to send a Google Form only to discover no data was collected. This is one small issue which can happen if “Best Practices” aren’t followed when sharing a Google Form Link with respondence.

HOW to SEND a GOOGLE FORM

  1. Open a Google Form
  2. Click the Send Button
  3. Pop out window opens
  4. Choose a way to send the form
    • Email
    • weblink
    • Embed code
    • Social Media

Google Form Sending.gif

 

 

STEP 2b: Google Forms Magical Feature

Built into Google Forms is the Go to Next Section Based on Answer feature. The feature can provide students with a second chance to review the question and master the concept. This method  can help with minimizing “Test Anxiety” for students. When the student is referred to the next section based on a wrong answer they’re presented with visual or video review. This is followed by the student trying to answer the same question a second time. Imagine how this could bolster a students esteem due to a passing grade?

Tutorial: Next Question based on Answer

  • Click the More Symbol

download.png

  • Choose Go to Section Based on Answer
    • Based on the section selection the student is sent:
      • To the next question
      • Or to a review Section
        • Here the student will watch a video or see a visual for supporting mastery of the question.
        • The student is provided with a second chance to answer the same question before moving onto the next question or submitting the answers.
  • Click the Dropdown Arrow for each Answer
    • This is activated by Choosing “Go to Next Section Based on Answer”
  • Select the Section or Choose Submit Form

Screen Shot 2016-10-27 at 6.24.06 AM.png