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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s