10 BEST Google Sheets HACKS for Teachers

Don’t forget to like, comment, and subscribe so you don’t miss future videos!

MY TEACHERSPAYTEACHERS STORE:

POCKETFUL OF PRIMARY MERCHANDISE:

MY AMAZON FAVORITES:
__________________________________________________________________
0:00 Intro
0:56 Hack 1
3:17 Hack 2
4:18 Hack 3
5:59 Hack 4
7:20 Hack 5
9:55 Hack 6
11:57 Hack 7
15:08 Hack 8
17:45 Hack 9
18:59 Hack 10
20:21 Outro

STUDENT CHECKLISTS GOOGLE SHEETS TEMPLATE:

STUDENT DATA SHEETS GOOGLE SHEETS TEMPLATE:

HOW TO CREATE A STUDENT CHECKLIST IN GOOGLE SHEETS | TUTORIAL FOR TEACHERS:
__________________________________________________________________
Find me on my other social media platforms:
INSTAGRAM: @pocketfulofprimary
__________________________________________________________________
*My description includes referral codes/links that allow me to earn points or credit that can be redeemed for products and/or subscriptions. When you use my referral code/link, you are helping to support me and my recommendations! Thank you for your support!*

[asky]

Your tips are excellent, Michelle. Thank you! I have always stayed away from sheets because to me, it is overwhelming and thus I have always inserted tables into docs to get my "grids" and "arrays" for student documentation instead of using sheets. After watching your video today I feel like I might be more willing to try Google sheets out again. Thank you!

[alexiamcbride]

I’m a bookkeeper with a mom who is a teacher. She loves your channel! I do a lot of Data Entry at work & love learning more about spreadsheets! Thank you for a great video!

[firealarmdiscovery]

I want to be a special education teacher when i graduate. I always get bored and make things on technology (slides, worksheets ect.) and I use so much of what you teach us! Thanks Machelle

[benhunter]

Two hacks that you missed that I have seen used as an IT student were creating self grading assessments and creating QR codes. Thankyou very much Michelle for your videos and Happy 29th Birthday. Hopefully Billy, Ember, your cats are spoiling you.

[robinwilson]

Once again, a great BIG thank you Michelle. Your videos inspire me to make my teacher life easier and more organized. I’ve always been a paper and pencil person, but this information has changed me. I’m leaning towards purchasing your sheets to save even more time. Happy Birthday and congratulations on your second power lifting win. Enjoy your delayed celebration 🎉

[kimwoods]

As a special education teacher I am SCREAMING a big THANK YOU!! I’ve always been a pencil/paper kind of gal when it comes to data collection and sharing. With these tips, I am equipped to go digital!! 🎉

[isabelmarisy]

Data Validation, Auto-fill Across Sheets, and Conditional Formatting. Thank you! This teacher needs this in her life. I'm not a Google Sheets lover but you have changing my mind.

[colleendriggers]

Used several of your videos to help me review and study for the Google Level 1 Certification! Thanks for making learning enjoyable with all the topics you cover!

[laepelba]

Thanks for this fantastic list of Google Sheets hacks! I get more and more into GS every day. :) I teach high school math, and am often tracking over a hundred students over two different courses and five class period. I use data sorts based on columns a lot. One of the things that I use almost weekly is Google Forms to collect information from kids, make exit tickets, send forms home for parent input, etc. During the pandemic I was using Google forms for attendance and student feedback. Do you ever use Google Forms? I LOVE the connections between Forms and Sheets.

[jennygessner]

Oh my goodness! I've been down the rabbit hole today as I worked to create and replicate all the cool sheets you showed us, Michelle. Thank you for sharing!

[stefylovesCeline]

Thank you soooo. much dear Michelle! I already bought the templates!!! They are amaziiiing! I can't wait to hear you and Bridget next Thursday !😍😍😍😍

[jo-annguthur]

Actually productive advice! Thank you!

[Anna-utwx]

These videos are actually helping me in my project manager course! Now I can use all these tips for a neat layout!🙂

[kristinapaulson]

Thank you so much for sharing these hacks! I love tech tips and you are so easy to learn from. Would love to learn how to create the functional checkbox that toggles on/off highlighting empty cells, if you're able to share! Streamlining my sheets now for the upcoming school year! Keep up the helpful work!

[sloaneeisin]

I live for you! Your videos are so helpful!!! I love all of your organizational tips and tricks especially within the Google apps

[JuanDiaz-tzkg]

Excellent video, personally I find pretty useful to make use of the =sparkline() function. After you've selected a range of data it will display a minimalistic graph wich is basically a line plot, but designed to fit into a cell, pretty useful when wanting to have a simple visual aid to start seeing patterns on the data you're working with.

[amandabohn]

You are so easy to learn from! A stellar teacher. If you feel like it is something manageable, I would love to see how to add those toggle check boxes. Thanks so much for your guidance :)

[Mandymei]

Amazing!! I’m obsessed with your videos! They make my life so much easier! I look forward to hopefully learning about your checkbox formatting!

[NailDivaCreativeManicures]

Very good!! I am loving my journey with Sheets!

[mrs.angieduncan]

I always learn something when watching g your presentations and I have been teaching awhile!