Episode 13: Using Google Tools in the Classroom: Google Sheets Edition
featuring Jared and Kari Wall

SHOW DATE: November 12, 2018

SUMMARY: Basic tips for choosing and using Google tools in the classroom for teaching and learning: focusing on how we use Google Sheets.

SHOW NOTES:
News and Notes:
Thank you to all who followed us on twitter the past three weeks and shared one of our podcast episodes via your twitter feed. The winner of our drawing the $25 Amazon Gift Card is (drumroll):
Heather White-@WhiteBoardTechy Heather is a Louisiana teacher and technology integrator. She is using all kinds of technology and we hope she can use the $25 Amazon gift card. Congratulations to Heather White
We are still looking for comments or suggestions on tools you could use to teach your class when you have to be off campus. Any comments may be used in one of our upcoming episodes! Here is the link to our Flipgrid: https://flipgrid.com/b0eab2bd.
Our next contest will be a Christmas Goodie Box giveaway from Wall EdTech. To enter for a chance to win, you must visit our podcast page on Itunes, Spreaker, or Iheart Radio and leave a review of the podcast. Be honest. Tell us what you think. Just like our students, we need to know what is working and what needs to be tweaked in order to make this show as effective as it can be for you, our listeners.

Technology Tools & Trends
Technology Tools:
JoeZoo add on for Google Docs and App.
Useful for teacher assessment of work in Google Docs
Provides a platform for leaving typed or spoken comments in student work.
Typed comments can be read by a text to speech function
Automated grammar and mechanics checker to save teacher time and help students identify common errors in their writing.
Rubrics for easy grading.
Works with Google Classroom to export grades and gives you charts and graphs of student progress in writing.
Screencastify
Mentioned before, but let’s talk about its ability to allow for visual and auditory feedback on student work. Don’t just leave written comments student won’t look at. Engage them with screencastify.
Voice Notes: Audio instructions for students-I’ve been going through our notes and objective for students who are not at school.

Question:
What is Google Sheets?
Google slides is a spreadsheet much like Excel, but for those of you who are in Google Education districts (have google accounts for teachers and students), it is so much more.
Data from Google forms can be collected in a Google Sheet. This is a game changer for teachers in so many ways! Let’s discuss how this can be used in the classroom.
How are we using Google Sheets in the classroom?
Pair with a Google Form to
Collect student answers to simple quiz questions to maximize the impact of gauging student performance for formative assessment.
Use as a rubric tool to collect student scores and quickly see your notes and evaluation of student performance and work.
Use as a walkaround tool to give students feedback on their performance in class.
Use as a behavior tracker that connects to student trackers providing the teacher with information and allowing the student to see their progress.
Use it for student accountability-useful when called to a parent/teacher conference to be able to show how that student has been conducting themselves in class.
Behavior, on tasks, performing skills, etc.
Weekly Business Report-students reflect on the week and set goals
Stand Alone
Use as a test corrections tracker for my students to see how they are performing on standards across multiple assessments.
Use as checklist for students to check items completed on a project.
Use it as a formative assessment with the checkbox feature to ensure that my...