Google Sheets: Beyond the Formulas!

A quick read on 3 ways to use Google Sheets, besides calculating with formulas, in the classroom!

A quick read on 3 ways to use Google Sheets, besides calculating with formulas, in the classroom!

As you can tell, I’m a huge fan of Google Apps. I use Google Slides to create all of my lessons, Google Classroom to give my students assignments and Google Docs to create documents to share with my team. One application that I wasn’t using too often was Google Sheets. I took a course and it was so informative! I learned all about formulas, add-ons, and tips and tricks for students to use Google Sheets as well. Today I am going to share with you some ways I use Google Sheets to help me ease the time consuming to-do lists of teaching.

Conditional Formatting

Even if you’re not using Google Sheets for formulas, you can use it to type in students grades and you’ll have a neat and organized list of how your kids are doing. Conditional formatting is the greatest tool you will use to make your life 100x easier! Basically, you can set it so the lower grades are one color and the higher grades are a different color. I usually create a color scale to let me see the different grades, and I can easily see the students I need to conference with at a glance. I set up my Google Sheet like this:

Planning for Grouping

I created a grouping spreadsheet to help me when I make my center-time groups. Last year, I used paper and I left out kids more often than not and it was so frustrating for me and them to figure out where to put them. I no longer worry about that because of Google Sheets! I created a sheet for each of my classes and I have a master copy of the students names pre-populated in the first column. Then, as I put them into a group I change the fill color of the cell of their name to the color of the group I am putting them in. Check it out here:

As I am creating the groups, I can quickly see which students are going where and who I still have to put in a group. This is such an amazing time saver – I no longer take hours to plan for center time and small group!

Checklists for Planning

How frustrating is it when you’re planning this awesome lesson and in your mind it’s going to be the most jaw-dropping lesson of the week and then you get to work and realized theres a major component missing? Fear not – Google Sheets FTW! You can insert check boxes into a cell to check off as you complete the tasks! I created a master copy that I make a copy of and fill in for each chapter. This helps me so much when I’m planning for the unit and I can see what I need for each lesson and check it off as I create each piece.

Another use for the checkboxes is to check off as students had in assignments, trip slips, or anything really! This will save yourself from asking, “Where did I put that paper with the kids names that brought in the permission slip?” Such a simple solution to a very real problem!

Beyond Teaching

Google Sheets is such an important tool for me – I use it beyond teaching. I have a budget spreadsheet that helps me manage my money, a blog post tracker, and I track my TpT sales goals! Email me at letstechaboutmath@gmail.com if you have any questions or want some tips and tricks on Google Sheets beyond teaching!

I hope this helps with becoming more efficient in the classroom! Thank you for stopping by, don’t forget to subscribe for exclusive access to my Google Drive with FREEBIES just for subscribers! One of the freebies is a detailed explanation of how to do these three things, so be sure to subscribe for it!

Enjoy!

☆Alexandra☆

Leave a Reply

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