Google Sheets often gets a reputation for the “difficult” or maybe the “least used" app in G-Suite waffle.  But that doesn’t need to be the case all the time! In today’s episode we will share ways students and teachers currently use Sheets in the classroom and then ways you can tech it up a notch when it comes to your knowledge and usage of Google Sheets. 

We are excited to have Emily McDonald as today's guest from Chattanooga, Tennessee! 

​Emily McDonald is a high school mathematics teacher at Red Bank High School in Chattanooga, Tennessee. RBHS is a Title 1 school that is 1:1 with Chromebooks. Emily currently teaches Algebra 2, Calculus, and Dual Enrollment Probability & Statistics. Emily enjoys incorporating technology to promote creativity and exploration in mathematics. Emily is a Level 1 and Level 2 Google Certified Educator and a Google Certified Trainer. Other certifications include EdPuzzle Coach, CK-12 Certified Educator, Screencastify Certified Genius, and EquatIO Level 1 Certified User. Emily has presented at several EdTechTeam Summits in the southern region as well as other regional and state professional development conferences.


Twitter: @EMcDonaldEDU 
Email (personal): mcdonald.emily.ann@gmail.com

Ways Educators Can Benefit from Google Sheets:
Tips from Emily  - New features in Sheets
Add a class roster, then use Check Marks to keep track of  beginning of year forms and other ungraded items.
Organize, sort, and filter test score data.
Create  charts and graphs with ease.
Freeze rows and columns to work with large data sets. 



Using Google Sheets with Students:
Self paced learning activity (could be used for PD with adults as well!)
Track scores over time  - students track their own keyboarding data - make a copy and edit to suit your content.
Manage a budget - a student activity facilitated by Emily - make a copy for your students. 
Create Pixal Art using Conditional Formatting



Tech it Up a Notch - Google Sheets Tips:
Use Scripts to send specific email to multiple recipients - Scripts Example
Explore the Add-ons Menu and use Sheets to automatically create flashcards, certificates of completion or PD attendance, send confirmation email, manage badging  and more!

Autocrat
Flippity
Form Mule
Magic Digital Badges



Share your Google Sheets ideas, successes,  and templates in the comments below.  Would you like to be a guest on our show?  Complete this Google Form and you might join us in a future episode of Somethin To Tech About!

More resources:
ISTE Standard(s) for Educators and Students
Newspapers In Education
Common Sense Media

Find out more about Somethin' To Tech About at:
Website
Facebook
Twitter
Email

Google Sheets often gets a reputation for the &ldquo;difficult&rdquo; or maybe the &ldquo;least used" app in G-Suite waffle.&nbsp; But that doesn&rsquo;t need to be the case all the time! In today&rsquo;s episode we will share ways students and teachers currently use Sheets in the classroom and then ways you can tech it up a notch when it comes to your knowledge and usage of Google Sheets.&nbsp;
We are excited to have Emily McDonald as today's guest from Chattanooga, Tennessee!&nbsp;
<hr>
​Emily McDonald is a high school mathematics teacher at Red Bank High School in Chattanooga, Tennessee. RBHS is a Title 1 school that is 1:1 with Chromebooks. Emily currently teaches Algebra 2, Calculus, and Dual Enrollment Probability &amp; Statistics. Emily enjoys incorporating technology to promote creativity and exploration in mathematics. Emily is a Level 1 and Level 2 Google Certified Educator and a Google Certified Trainer. Other certifications include EdPuzzle Coach, CK-12 Certified Educator, Screencastify Certified Genius, and EquatIO Level 1 Certified User. Emily has presented at several EdTechTeam Summits in the southern region as well as other regional and state professional development conferences.
 Twitter:&nbsp;<a href="https://twitter.com/EMcDonaldEDU" data-cke-saved-href="https://twitter.com/EMcDonaldEDU">@EMcDonaldEDU&nbsp;</a> Email (personal):&nbsp;<a href="mailto:mcdonald.emily.ann@gmail.com" data-cke-saved-href="mailto:mcdonald.emily.ann@gmail.com">mcdonald.emily.ann@gmail.com</a>
<hr>
Ways Educators Can Benefit from Google Sheets:
<ul>
<li><a href="https://docs.google.com/presentation/d/1xQM8qJnDf0ltTkAF2HMC-jxiPXbZ3kN8i64kvU5QgYU/edit?usp=sharing" data-cke-saved-href="https://docs.google.com/presentation/d/1xQM8qJnDf0ltTkAF2HMC-jxiPXbZ3kN8i64kvU5QgYU/edit?usp=sharing">Tips from Emily&nbsp;</a>&nbsp;- New features in Sheets</li>
<li>Add a class roster, then use Check Marks to keep track of&nbsp; beginning of year forms and other ungraded items.</li>
<li>Organize, sort, and filter test score data.</li>
<li>Create&nbsp; charts and graphs with ease.</li>
<li>Freeze rows and columns to work with large data sets.&nbsp;</li>
</ul>
 Using Google Sheets with Students:
<ul>
<li><a href="https://docs.google.com/spreadsheets/d/1eAPuxwWaSUkV1g_NUmZpOAeJGxVoHeooRUZCPx36YmY/edit?usp=sharing" data-cke-saved-href="https://docs.google.com/spreadsheets/d/1eAPuxwWaSUkV1g_NUmZpOAeJGxVoHeooRUZCPx36YmY/edit?usp=sharing">Self paced learning activity</a>&nbsp;(could be used for PD with adults as well!)</li>
<li><a href="https://docs.google.com/spreadsheets/d/17M_3fh2Aef_-HlZqmTUXYLxBRKIbH9DJdYx4WvE3O-k/edit#gid=0" data-cke-saved-href="https://docs.google.com/spreadsheets/d/17M_3fh2Aef_-HlZqmTUXYLxBRKIbH9DJdYx4WvE3O-k/edit#gid=0">Track scores over time&nbsp;</a>&nbsp;- students track their own keyboarding data - make a copy and edit to suit your content.</li>
<li><a href="https://docs.google.com/spreadsheets/d/1tVrJsUsAbp9eWdkEp3KTHckckPthwoytpZ3LnpE2AOI/edit?usp=sharing" data-cke-saved-href="https://docs.google.com/spreadsheets/d/1tVrJsUsAbp9eWdkEp3KTHckckPthwoytpZ3LnpE2AOI/edit?usp=sharing">Manage a budget</a>&nbsp;- a student activity facilitated by Emily - make a copy for your students.&nbsp;</li>
<li>Create Pixal Art using Conditional Formatting</li>
</ul>
 Tech it Up a Notch - Google Sheets Tips:
<ul>
<li>Use Scripts to send specific email to multiple recipients -&nbsp;<a href="https://docs.google.com/spreadsheets/d/1JBY83fPiRBykTyx3MYEP30FQTZpezU58c1V0K-oy-zE/edit#gid=1324399772" data-cke-saved-href="https://docs.google.com/spreadsheets/d/1JBY83fPiRBykTyx3MYEP30FQTZpezU58c1V0K-oy-zE/edit#gid=1324399772">Scripts Example</a></li>
<li>Explore the Add-ons Menu and&nbsp;use Sheets to automatically create flashcards, certificates of completion or PD attendance, send confirmation email, manage badging&nbsp;&nbsp;and more!
<ul>
<li><a href="https://cloudlab.newvisions.org/autocrat" data-cke-saved-href="https://cloudlab.newvisions.org/autocrat">Autocrat</a></li>
<li><a href="https://www.flippity.net/" data-cke-saved-href="https://www.flippity.net">Flippity</a></li>
<li><a href="https://cloudlab.newvisions.org/form-mule" data-cke-saved-href="https://cloudlab.newvisions.org/form-mule">Form Mule</a></li>
<li><a href="https://sites.google.com/view/notsomagicapps/magic-digital-badges?authuser=0" data-cke-saved-href="https://sites.google.com/view/notsomagicapps/magic-digital-badges?authuser=0">Magic Digital Badges</a></li>
</ul>
</li>
</ul>
 Share your Google Sheets ideas, successes,&nbsp; and templates in the comments below.&nbsp;&nbsp;Would you like to be a guest on our show?&nbsp; Complete this&nbsp;<a href="https://forms.gle/jShydoxToFzFhJqf9" data-cke-saved-href="https://forms.gle/jShydoxToFzFhJqf9">Google Form</a>&nbsp;and you might join us in a future episode of&nbsp;Somethin To Tech About!
<hr>
More resources:
<ul>
<li>ISTE Standard(s) for&nbsp;<a href="https://www.iste.org/standards/for-educators">Educators </a>and <a href="https://www.iste.org/standards/for-students">Students</a></li>
<li><a href="https://nieonline.com/savannah/">Newspapers In Education</a></li>
<li><a href="https://www.commonsensemedia.org/">Common Sense Media</a></li>
</ul>
Find out more about Somethin' To Tech About at:
<ul>
<li><a href="https://www.somethintotechabout.com/">Website</a></li>
<li><a href="https://www.facebook.com/sttechabout/">Facebook</a></li>
<li><a href="https://twitter.com/sttechabout">Twitter</a></li>
<li><a href="mailto:somethintotechabout@gmail.com">Email</a></li>
</ul>

News and Interviews from the Savannah Morning News, Savannah GA

Advertisement