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
Advertisements

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.

 

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