Tag Archives: spreadsheets

IF you use Google Sheets

If Statements Google Sheets

IF Function in Google Sheets One of my favorite formulas for a spreadsheet is an IF function. If the value of a cell meets certain criteria, do this. Otherwise, do something else. If =IF(criteria, true, false) Examples Random Sort I like to use the formula =rand() to assign students a random number and then sort […]

Read more

Google Sheets: Find Unique Entries

Google Sheets pick a winner

Find Unique Entries in Google Sheets When the 2nd Google Classroom book that Libbi Miller and I wrote came out, we put out a Google Form to win a copy of the book. Before choosing a winner I needed to exclude duplicate entries. Here is how to do this. Sample Data CLICK HERE for some […]

Read more

Together… Let’s Make a Google Form

Collaborate on Google Forms

Collaborating on a Google Form Google Forms is awesome, but be warned there is NO revision history. If you have multiple collaborators on a Google Form and someone deletes a question or edits it accidentally, you have no recourse. Students Collaborate One idea for creating a collaborative Google Form is to have students create questions […]

Read more

Measurement Activity: Google Sheets for Littles

Kindergarten measurement count

Kindergarten Count Measure This spreadsheet template is for younger students to practice measuring and counting. This is an adaptation of a worksheet which had pictures of clip art next to blocks where the students counted the blocks. This asks students to figure out the blocks rather than the blocks being given to the student. Note: […]

Read more

Let’s Play Add-on – Students Collaborating on the Same Doc

lets play students collaborate on same game document

Collaborate on the Same Document One of the coolest things about Google Docs is the ability to be on the same document at the same time. This allows students to work together, peer evaluate and play games! It can be a little tricky for students to get on the same document, especially littles who may […]

Read more

Mark It – Round to Tens Game

rounding game mark it round 10

Based on this game the spreadsheet version is https://t.co/tB9fjTbdUL https://t.co/vE4JiRk01L — Alice Keeler (@alicekeeler) May 22, 2016 Rounding Game Since the answer is always a spreadsheet I created a digital version of the Mark It game for rounding. In the original game, students would roll 3 die and arrange them in any order they wish. […]

Read more

Try This It’s Easy – Google Sheets: Count Stuff

Count Google Sheets

Use Spreadsheets Spreadsheets are an incredibly valuable life skill. Students of any age can use them. Essentially you have a grid to put stuff in, doesn’t have to be numbers. Help students to sort and organize information by doing tasks in Google Sheets. Count In Google Sheets, highlight a range of data (stuff). Automatically the […]

Read more

Pixel Art Battleship

pixel art battleship

Battleship using @alicekeeler pixel art template plus chrome extension tab scissors. #EndOfYear2016 pic.twitter.com/OCgcl6pgAX — Cindy Schluckebier (@schluckteach) May 9, 2016 Pixel Art Battleship Pixel Art and Battleship… yup that sounds awesome! Cynthia Schluckebier shared on Twitter her students using the pixel art template (alicekeeler.com/pixelart) along with Tab Scissors to play the game Battleship. Cynthia’s Steps 1. I […]

Read more

Gamification To-Do List Level Up Challenge

Competition To-Do list

Gamification To-Do List If you have ever had your students play Kahoot you know that the power of gamification is undeniable. Gamification adds gaming elements to a non gaming situation. A little competition in a to-do list can really help motivate you to get your stuff done. To-Do Gamification Template I created a Google Sheets spreadsheet to […]

Read more

templateTab: Collaborate with Students using Spreadsheets


templateTab I love spreadsheets and I love students collaborating. This comes together by using Google Sheets spreadsheets. Template alicekeeler.com/templatetab Roster After making a copy of templateTab, paste your roster into column A. I recommend that you have a spreadsheet in your Google Drive that has a list of your students names and email addresses. This […]

Read more

5 Steps to do When Using Google Forms for Formative Assessment

Google Forms Quiz

5 Steps to Creating Using Google Forms for Formative Assessment Before providing students with the Google Forms quiz, try these 5 tips to make the process easier. Formative assessment should allow you to quickly respond and change your instruction based on the results. Setting up the Google Form and spreadsheet in advance of students taking […]

Read more

Google Sheets: Take Off One Character

remove character google sheets

Remove the Leading Character I sometimes have a need to extract part of word or text string when using a spreadsheet. For example if I have a hashtag in my spreadsheet #googlesheets and I want to create a clickable hyperlink, the link does not like the hashtag # symbol. =LEN() The first formula you might […]

Read more

Google Sheets: Do Not Type There

protect range google sheets

Protect Range in Google Sheets One nifty thing about using Google Sheets is the ability to lock collaborators from editing your work. I love to create crowdsourced spreadsheets and invite people on social media to add to the document. It is normal for people to start typing when they open a document. This causes them […]

Read more

Google Apps Script: Create New Tabs

google apps script tutorial make tabs

Create Tabs in Google Sheets Google Apps Script allows you to customize what Google text docs and Google Sheets can do for you. It is based on JavaScript, but you need to know very little to be able to do Google Apps Script. Here is a scripting activity to help you practice your Google Apps […]

Read more

Google Forms: Creating Formative Assessment Quizzes

creating a google forms quiz formative assessment alice keeler

Formative Assessment Quizzes with Google Forms The purpose of formative assessment is not to put a grade in the gradebook. When we are teaching we want to collect evidence and data as to how the students are understanding the material. We then use that evidence to form or change what we do next. Formative assessment […]

Read more