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.

Directions: Creating the Form

• Open a Google Forms
• Give the Forms a Title

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

• Click Plus Sign to Add Question Type

• Click Dropdown Arrow Right of Multiple Choice

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

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

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