Paperless Is Not A Pedagogy
AliceKeeler Select the Cells is a Google Sheets Add-on designed to help teachers select cells with a background color more efficiently. With this add-on, teachers can single-click on any cell in a range that has a background color and automatically select all the other cells in that range with the same color. How Do You Highlight Cells of the Same Color
This is going to be amazing… and easy Use format painter in Google Sheets. It is truly fun to magically apply formatting in multiple places across your spreadsheet.
If you use a Google Form and want to automate sorting in Google Sheets so that each time you open the spreadsheet you do not have redo the sorting here is a tutorial by Alice Keeler queen of spreadsheets.
Do you have a table of student data and need to lookup the guardian name for example? In this how to use XLOOKUP in Google Sheets Alice Keeler shows you how to return values in a table based on a look up value.
Spreadsheets can be made using Google tools. If you wan to know how to create a spreadsheet in Google here are some tips from the Queen of Spreadsheets Alice Keeler
Have fun with a Bingo Ice Breaker! Try out this free Add-on by Alice Keeler to create a fun activity to get students or participants up out of their seats and getting to know each other.
Rubrics for Google Classroom are slow to create and hard to reuse. Try GC Rubric by Alice Keeler to create faster and better rubrics for Google Classroom.
Add multiple Google Calendar events at once. CalAdd by Alice Keeler makes it fast to add student birthdays to Google Calendar. Or any list of calendar events.
You want to restrict editing on PART of a Google Doc. This step by step guide will show you a hack for how to lock areas of a google doc.
The Rule of One! Only Put In Once in Google Sheets!! Here is how to handle if you need something twice or more in a spreadsheet.
Finally! A way to grab a spreadsheet cell from individual student spreadsheets. This allows you to easily review all students responses to a question in one place.
You make a copy of a spreadsheet per student, but what if you have a typo or want to add to the spreadsheet? sheetPusher by Alice Keeler and Heather Lyon helps you update student spreadsheets. Here is how to update student spreadsheets.
What is something fun for students to do at the end of the year? While there are many choices, a fun word search can give students something to do while other students are finishing a task. Try my template!
Reuse TemplateTab to collaborate with students and have less paperwork to grade.
How to use COUNTA in Google Sheets. This helpful formula works differently than COUNT. I will explain how.