What No Special Voice to Text Tool?

Due to neuromuscular spine issues, my fingers sometimes do their own thing when typing on a Google Slide. I find using voice to text instead to be a valuable support. One challenge I have is a Google Slide’s voice to text tool is limited to the speaker notes section. Despite this limitation, it is still possible to use voice typing for designing the canvas area of a slide. 

One popular method is to use voice typing in the notes section. Then to copy and paste the notes section text onto the Google Slide canvas. If a person has a small motor or cognitive challenges, copying and pasting may be frustrating. Instead, I like to use my smartphone or a tablet device to voice type into a text box on Google Slides. 

Quite a few mobile devices come with a voice to text capability. If you need to install an APP for voice to text, try  GBoard by Google keyboard.  Note you may also need to install the Google Slide APP onto the mobile device. It is handy that more than one device may use the Google Slide from one account. I find it helpful to talk into the phone or tablet and watch the type appear on a bigger screen. Doing this makes it easier visually to check grammar or spelling errors on a bigger screen. Using voice to text for typing may unlock doors for many different people from young to old.

Easy Tips for Turning Off Google Forms Assessment

Recently a teacher came to the Google Docs Help Forums to learn how to turn Google Forms Assessments off. The teacher was afraid students would copy the Assessment’s URL to share with friends. I was glad when Lance a Google Doc’s Product Expert friend reached out to me for help. The teacher learned two simple steps for maintaining assessment confidentiality.

First Make a Copy of Testing Template

  1. Open the Google Forms Assessment
  2. Click More Settings (3 Vertical Dots)
  3. Select “Make a Copy”

BENEFITS:

  • Making a Copy allows the user to make a blank question bank template to be used for future assessments.
  • Allows teachers to easily share individual forms with each class.
    • Copies provide more control for turning an assessment on & off.
      • Teacher has a choice of turning off one class or all

Turn Forms Assessment On & Off

  1. Open the Google Forms Assessment
  2. Click Responses Tab
  3. Toggle “Accepting Responses” to Left for OFF
  4. Toggle “Accepting Responses” to Right to Turn ON

BENEFITS:

  • Teacher may turn Forms Assessment Off after Assessment is Completed
  • If Student was absent teacher may turn the assessment on.
  • Provides control for collecting deadline information

Using Forms as a Motivational Tool…

I never met a student who truly didn’t care about receiving a “Good Grade”. This post is about supporting the students who  are struggling and have difficulty internalizing grades.  Have you ever noticed these students tend to be the ones who are motivated by achieving high game scores? If the student learns to internalize grades like they do game scores would they be motivated to improve?

Google Forms and Sheets visually provides the ability for a student to see the slightest upward grade movement. If grades keep moving upward in little leap and bounds the student may view this as a positive change. Using a Google Form to graph a series of grades may help with self-internalization. If the student views a constant upward movement could this become a “magical key” to “unlocking doors” and boosting esteem?

Creating a Student
Visual Grading Tool

Using Google Forms and Sheets

Following are the steps for creating a Google Forms and linking a Sheet for student internalization of Grades.

Screen Shot 2018-01-17 at 2.05.25 PM.png

Directions: Creating the Form

Form title

  • Click Dropdown Arrow Left of Multiple Choice
  • Select Date
  • Click Untitled Question Area
    • Type DATE

Forms Date.gif

  • Click Plus Sign to Add Question Type

click plus sign

  • Click Dropdown Arrow Right of Multiple Choice

dropdown arrow

  • Select Short Answer
  • Type Content Area Grades in “Question Field”

short answer

Directions: Linking Sheet

  • Open the Form
  • Click Responses Tab
  • Click Green Favicon to Link Sheet
  • Select Create a New Spreadsheet or Select Existing Spreadsheet

NOTE:
Selecting Existing Spreadsheet Adds the data on a new sheet in an existing spreadsheet.

Directions: Use Explore for Chart

  • Open the Sheet
  • Click Explore
  • An Analysis Chart (graph) is automatically generated from the data
  • Add to Sheet by Clicking Graph Favicon

add graph.gif

NOTE:
Chart maybe added to the spreadsheet or inserted into another Google File

Linking Reading Log to Spreadsheet

Recently one of my blog readers requested a tutorial about linking a Google Forms Reading Log to a Spreadsheet. They explained they are a new teacher and not quite so savvy. This was a good lesson for me about simplifying my blog posts. If you are a teacher interested in creating a custom Google Forms Reading Log then the following directions are for you.

The first tutorial will explain how to create the Google Form. This will be followed by a tutorial for linking the Google Forms to a spreadsheet for collecting the student’s reading data. You will also learn how to copy a Form for making it possible to build a spreadsheet which includes a tab for each individual student’s data. This may provide individualized longitudinal data supporting the readers growth. It is possible to import group data onto a separate sheet for further study.

Beyond collecting data using a Forms & Sheets Reading log becomes a timesaver for teachers. It puts all the information in one single place making it easier for accessing the information.

Creating a Google Forms Reading Log

NOTE: You will need to make multiple copies of the Form. One Form per Student because this is the only way to link individual student sheets to One Spreadsheet.

Linking a Sheet to Create a Spreadsheet

 

NOTE: The above steps will allow the teacher to view all the students in one spreadsheet

3 Tips for Using Google Forms

As a Google Top Contributor I’m exposed to an abundance of questions from teachers throughout the world. The following tips lists was created due to answering these questions in the Google Drive, Docs and G Suite for Education Help Forums.

1. Sharing a Google Forms…

It always amazes each year hearing the following question. “What am I doing wrong the students are requesting access to the form?”

This happens when the teacher copies and pastes the Google Forms URL instead of using the Send button to share the forms. Please follow the below steps to send a Google Forms.

FORMS DO NOT PASTE URL

Forms Send by Send button

Choose Forms Send Method.gif

2. Collecting Student Names…

What if a student forgets to enter their name? Is there a way to tell who the form belongs to?

If names aren’t collected from within the form there is no way to find out who completed the form. However teachers can prevent this from happening by using one of the two following steps.

  • Auto Collect Student Emails

    • Set the Form to Auto collect email by using the settings tool

Forms Click Settings

Forms Collect Email Addresses

  • Add a required Name Field

    • Add a Short Answer Question Field to the Google Form
    • Type First Name Last Initial in the question area
    • Set the Short Answer Field to Required

Forms Required Name.gif

3. Changing Submission Message…

Is it possible to edit the message a student receives once a Google Forms is submitted?

Yes, the message may be edited to add a mindful message. Please follow the illustrated steps to customize the Google Forms Confirmation message.

Forms Click Settings

Forms Click Presentation

Forms Type Confirmation Message

If you have further Google related questions you’d like answered please leave them in the comment area of this post. I’d be happy to answer them.