Install Add-on TemplateTab TemplateTab is a Google Sheets Add-on that allows you to duplicate a graphic organizer within a spreadsheet for every student on your roster. Hack TemplateTab Hack TemplateTab to simply create a lot of tabs quickly. Add-on Menu After installing TemplateTab you will find it permanently installed in the Add-on menu. Meaning it is available in any spreadsheet.… Read More »Make Tabs FAST in Google Sheets
Free Gamification template for students to have choice and level up.
See all student responses to multiple questions in one place! A Google Sheets spreadsheet is a document. If you can do it in a Google Text Document you can probably also do it in a Google Sheets spreadsheet. I like to say “The Answer is Always a Spreadsheet.” Incorporating spreadsheets into your class provides students with a valuable life skill.… Read More »Make a Student Answer Sheet
Gamification Works!! We know when we gamify activities it increases student engagement and increased engagement increases student learning. In my webinar today I went over how to create digital badges using Google Slides and Google Drawings. Make Badges in Google Slides I have created a template in Google Slides to help you to quickly create digital badges. Create a copy… Read More »Make Badges with Google Apps
Looking for ways to engage students? Try some gamification and choice. I have added some features to my Badge Game template that I hope will make it easier and more fun. Template New Features I updated several new features to the Badge Game Change the game colors. Create a Google Slides tutorial to go with the game. Google Slides are… Read More »SUPER COOL Badge Game Updates
I am working on a Google Form where I need a drop down list of student names… first and last name. However, the names are not in the same cell in the spreadsheet. Start with an Equals Sign For all formulas in a spreadsheet you need to start with an equals sign. In a blank cell type the equals sign.… Read More »First and Last Name Together… When They Are Not
Google Sheets is great for creating a checklist in. You can share the spreadsheet with others to check off tasks. You can sort and filter your checklist. I created template that allows you to create your checklist and when you check off the items the checkbox turns green and the item on the sheet greys out. Template
This week I was asked…. when you need to go back to a cell, how do you edit the cell so as to not have to start over? Single Click to Replace Cell Text When you click on a cell and start typing it will override what is in the cell. Use Control Z to undo if you did not… Read More »Google Sheets: Edit in the Cell
It’s my birthday and everyone knows no one loves a spreadsheet more than I love a spreadsheet! Here are 5 things you can do with a spreadsheet that will save you time! 1) Automatic Numbering Spreadsheets recognize a pattern. Highlight the pattern and grab the fill square to drag the pattern. The fill square is the small square in the… Read More »5 Time Saving Tips for Teaching with Spreadsheets
One of my most popular non published Add-ons is First Slide. This allows you to push slides to student Google Slides and to also grab the text off of their first slide so you can quickly read and give feedback. Spreadsheet The answer is always a spreadsheet. First Slide is an Add-on for Google Sheets. After making a copy of… Read More »Google Slides: Hide Columns in First Slide
I had a request by a premium member that they had one Google Sheets spreadsheet with a tab per teacher to keep track of the daily contacts with students and parents. She wanted to add a column each day with the date to each of the sheets for the spreadsheet. Authorize the Add-on After making a copy of the spreadsheet… Read More »Push a Column to Each Sheet in Google Sheets
You can add a rubric to a Google Classroom assignment using Google Sheets. This is my preferred way. Template Make a copy of the rubric template to help you successfully upload your rubric. It has to be in a specific format. I created a no code template. Rename Spreadsheet Google Sheets automatically saves to Google Drive. No need to do… Read More »Add a Rubric to Google Classroom with Google Sheets
Google Classroom is designed for students to find their work. There is no ability to give parents the ability to see the Classwork page other than the student showing it to them. If you would like to communicate with parents the list of assignments I have coded a way to extract the assignments list from Classroom. AliceKeeler Add-on I have… Read More »Google Classroom: Give Parents a List of Assignments
In my Intro to Google Sheets spreadsheets webinar I showed 6 key skills that you need for teaching with Google Sheets spreadsheets. One of the things we covered in the webinar is how to create a seating chart using Google Sheets. Resize the Cells To the left of the column indicator A and above the row indicator 1 is the… Read More »Begin with Google Sheets: Make a Seating Chart
My favorite part of Google Sheets is inserting checkboxes! WICKED USEFUL FOR TEACHERS! My daughter is helping me with my YouTube thumbnails (check out her handiwork and subscribe to my channel 🙂 She is using a Google Sheets spreadsheet to keep track of how many thumbnails she creates for me, and I’m paying her. She made a list of checkboxes… Read More »Count Up Checkboxes in Google Sheets
