ELA teachers here are 4 tips to help you love spreadsheets for your class.
Create Avery Address Labels in Google Docs for FREE.
In this guest post by Alice Aspinall, she shares number puzzles she made for her own children. Alice Keeler made a Math Puzzle spreadsheet we all can use for students K-12!
Melody McAllister shares how using BINGO is a fun way to build community and introduce/review academic units. Go to alicekeeler.com/bingo for a copy of this fun game to play with your friends, staff, and class!
Word searches are fun!! I did spend some hours looking up research articles on the educational benefits of word searches. While they are fun for students, circling words does not have a lot of benefits in terms of learning. BUT sometimes we do things just for fun, so I have a way to generate your own Word Search. Copy the… Read More »Make a 4th of July Word Search
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