Polling and Voting Counseling Activities Using Google Apps

This is the fourth post in this series about using Google Apps in your school counseling program! Last week, I talked about using {Google Slides and Google Forms in emotion identification activities.} This week, I’ll show you how I use Google Slides and Google Sheets in polling/voting counseling activities in classroom guidance lessons.
Use Google Slides and Google Sheets to quickly represent data when using polling and voting activities in classroom guidance lessons or group counseling
This strategy is useful anytime you want to have your students vote or share their opinions with specific options. For example, I have a lesson in which I show students a picture of a person and ask them to vote on what they think the person’s occupation is. This activity leads into a discussion on assumptions and stereotyping, and I can visually represent students’ responses with a simple graph using both Google Slides and Google Sheets.
Begin with your slide, and include your question and any images you’d like. In this example, I’m using several statements about a person and asking students to record their “gut reaction” about who the person is.
First slide with polling question
Next, create a slide with your question, and insert a chart. Click the down arrow in the top right corner, and click “Open source.” This will open a new tab in your browser for Google Sheets.
Insert a chart on your  slide
New tab opens Google Sheets
Here you will be able to edit your polling choices (do this before your lesson).  Click back to your Google Slides tab. Click “Update Chart.” Now, when you begin your lesson, you’ll have a blank graph.
Edit the text on your chart

 

Set the numbers to zero

 

Click “Update Chart”
Your updated chart will appear
Once you have polled your students, you can again visit the Google Sheets tab that you have open (or click the down arrow and “Open source” again if you closed the tab). You can type the number of students who indicated each polling option into the cells. Once again, go back to your Google Slides tab and click “Update Chart.”
Insert your data into the cells

 

Update your chart again to show your class data
Here’s a video tutorial if you prefer to watch it in action:
This is a simple way to integrate technology and represent class or group data without having to draw your own graphs each time! And there are so many ways to poll students throughout classroom guidance activities! Create graphs to represent career interests, character trait values, needs assessments, voting for Red Ribbon Week activities, and more.
To check out this specific lesson on assumptions and stereotypes, {CLICK HERE} or click the image below:
How are you using polling or voting in your classroom guidance lessons? Let me know in the comments!

 

Be sure to come back next week to see how I use Google Apps to practice social skills. {Click here to sign up for my free newsletter} to get it directly delivered to your inbox. See you then!
Use Google Slides and Google Sheets to quickly represent data when using polling and voting activities in classroom guidance lessons or group counseling

SaveSave

SaveSave

2 thoughts on “Polling and Voting Counseling Activities Using Google Apps

Leave a Reply

Your email address will not be published. Required fields are marked *

Social media & sharing icons powered by UltimatelySocial
0 Shares
Share via
Copy link
Powered by Social Snap