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

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

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

2 Ways to Resize Sheets Columns

When using different technology tools I always look for the quickest and most efficient way to complete a task. Sometime the “Simplest” features are the ones which pack the most powerful punch. Today I’m going to share how to resize the width of several columns at once. There are two different approaches a teacher or student may take for resizing a sheets column. The following steps may be added to ones “Timesaving Tips Bags of Tricks.”

First Approach for Resizing Columns

I find this approach to be the quickest and easiest to use.

  • Highlight and Drag the columns

Drag columns

Second Approach for Resizing Columns

If you are better with converting size into number this approach is for you.

  • Highlight the Columns
  • Click down arrow or right click
  • Select Reset Columns a to ?
  • Enter cell size number or fit to data

Change cell sizes.gif

Gotta Luv It! Chart Auto-Updates in Slides

Thanks to the Google Docs Help Forum I discovered the “Auto-Update” ability when linking a Google Sheets Chart to a Google Slides. This is a useful and efficient feature for presentations which use the same monthly for presenting updated data. All it takes is a click of a button located on the chart to have the data update within a Google Slides Presentation. I can see this tool used in content areas such as science where data collecting may play an important role.

In science during a lab students may input data into to a Google Form. The linked class lab data collection chart from the Google Form may be placed into a Google Slide. This will involve linking a Sheet to the Forms. Students may use a Google Slide or Docs with a linked chart for lab write-ups. During the science lab the teacher may have the chart projected on a large screen. They may have students take a break from the lab to discuss the group data collection.

This provides an opportunity for students to potentially correct errors or use deep thinking skills to reason why their data may look different from everyone else. I feel science labs aren’t necessarily about getting the information right or wrong. It is about using “Reasoning Skills” to better understand a process. This is one way the linked Google Sheet Chart in a Google Slide may benefit students by supporting one of the most important “C’s”  known as “Critical Thinking Skills.”

How to Link a Sheets Chart to a Slide


Google Sheets Gridlines All Gone!

Okay it took me all year to discover how to eliminate the Gridlines from a Google Sheet. This is going to give my interactive creations a cleaner look. Oh my! You won’t believe how Easy this is to do!!!

How to Remove Gridlines from Google Sheets

Use a Spreadsheet to Help Students Hone Sorting Skills

Yes! It’s important to understand the process of alphabetizing. If a student is struggling with alphabetizing it doesn’t necessarily mean they don’t know how to alphabetize. Putting items in order can sometimes prevent students from completing a main objective presented by multiple step directions. Why stress the student who struggles when there is another choice they can use to complete the task?

Google Sheets has become my new support tool to teach my students how to use. Instead of taking the time to alphabetize by hand have the student enter the data into a sheet. Then highlight the column and choose the data tool. In the data tool there are several different sort options. The student will pick the option which best represents their needs.

Next time you have a student struggling with sorting a list try this out. You may be surprised when the student completes all the tasks presented to them to be completed in a classroom lesson.

Alphabetize Google Sheets