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

Advertisements

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

 

 

STEP 2A: Creating the Google Form

Inserting an image in the questions and answer fields of a Google Forms is an upgrade I immediately fell in love with! Instantly I realized the value it offers for supporting a wide variety of learners.

Insert a Question or Answer Image

  • Open a Google Form
  • Click the + sign under Start a New Form

start-a-new-form

  • Give it a Title
    • Click “Untitled Form” to type a title name (Located in upper left corner)

Give it a title.png

  • Go to the first question section
    • Type a Question
    • Click the Image Icon

screen-shot-2016-09-10-at-11-59-59-am

                    (mountain symbol) this will allow you to add an image

  • Select one of these choices for adding image:
    • Take a snap shot
    • By URL
    • Your Albums
    • Google Drive
    • Search
  • Next chose multiple choice for the answers

Google Forms Type Question Insert Image.gif

NOTE: This will allow you to go to the next section base upon the answer. My next post will explain how to do this.