# IF you use 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 […]

# Google Sheets: Find Unique Entries

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 […]

# Together… Let’s Make a Google Form

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 […]

# Measurement Activity: Google Sheets for Littles

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: […]

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

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 […]

# Mark It – Round to Tens Game

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. […]

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

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 […]

# 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 […]

# Gamification To-Do List Level Up Challenge

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 […]

# 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 […]

# 5 Steps to do When Using Google Forms for Formative Assessment

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 […]

# Google Sheets: Take Off One Character

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 […]

# Google Sheets: Do Not Type There

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 […]