Tag Archives: Sheets

Google Sheets: Student Practice Template

Spreadsheets are an incredibly useful tool for students and adults. Here is a template to teach your students some basic spreadsheet skills. This template was created specifically to help practice skills students would need for the Common Core online test. Feel free to modify and use this template with your students. Template alicekeeler.com/sheetspractice

Read more

Google Drive: Shift S

Start with Google Drive. Instead of using the “New” button to create a Google Sheets spreadsheet, hold down the Shift key and press S to magically launch a new Sheets in a new tab.

Read more

List Scramble: Create Sublists of a Vocabulary List

List Scramble is an Add-On script that takes a list of vocabulary words (or list of student names or anything you like) and creates sublists randomly. I saw a blog post by Catlin Tucker on an activity called Word Sneak. I thought it might be helpful to have students be given a random sublist of vocabulary or […]

Read more

Google Sheets: Have Fun with Fonts

Fun news!! Google Sheets now allows for web fonts. All those fun fonts you use in Google Docs you can now use in a Google spreadsheet. Even better, when editing a cell, you can change the formatting within the cell. This means one word can have different formatting than the rest of the words in […]

Read more

Peer Evaluation in Google Classroom

I am a big fan of self and peer evaluation. No matter what digital tools I use to give students feedback faster, there is still only one of me. If you provide students a rubric, having them assess themselves and their peers against the rubric helps to give them a better understanding of the assessment. […]

Read more

Google Forms: Hidden Feedback Questions

Google Forms Hidden Questions

When using Google Forms for formative assessment you probably want to provide students feedback on their answers. Particularly if the question is a short answer question. If you add feedback to additional columns you run into the problem that for you the students answer is not next to the feedback you are giving them. This might […]

Read more

Template to Sign Up for Peer Evaluation

Recently I was assigned to give feedback to 3 of my peers. There was also a stipulation that everyone is evaluated at least 2 times. It was challenging to tell who had already been commented on twice. In response, I created a spreadsheet to help facilitate this process. Copy the Template Click Here to make […]

Read more

Using Mail Merge from a Google Form

  If you use Google Forms with students you can use mail merge to provide students with feedback. The Flubaroo Add-On allows you to add personalized comments to each students responses before emailing back quiz scores. When you are not using Flubaroo you can use the Add-On “Yet Another Mail Merge” to email information from a […]

Read more

Google Forms: Quick Start Guide

Quick guide to getting started with using Google Forms. Please feel free to utilize this resource with students and teachers in trainings on Google Forms. Please do not republish this graphic to your blog. Link to PDF: http://goo.gl/yB956a Link to Image File: http://goo.gl/VApqkl  Link to Google Drawing: http://goo.gl/2P6kwi  

Read more

Progress Bar in Google Sheets: Minecraft Example

First let me thank Lucas Gillespie for creating the Minecraft Challenge and sharing it under a Creative Commons license. If you’re not familiar with Lucas’ work in Game Based Learning I highly encourage you to check out his website: http://edurealms.com/ Lucas shared the Minecraft Challenge with me as a Google Doc. It is a list of […]

Read more

Be Data Driven – Use Conditional Formatting

Google has updated how conditional formatting works in Google Sheets. Using data to help direct next steps in teaching is important. Conditional formatting color codes responses to help you more easily find which students are being successful and which ones are struggling. Previously I had posted on formative assessment tips which included using conditional formatting. This […]

Read more

Google Sheets: Click Here to Tweet

I like to use a spreadsheet to tweet things. There is a formula you can use in a spreadsheet that allows you to click on a hyperlink and compose a tweet. You can create a list of questions for your Twitter chat. Using the spreadsheet allows you to more easily tweet out the questions. If […]

Read more

Pivot This: Summarize Google Forms Data

After collecting data from a Google Form it is likely that you want some summary data. Pivot tables allow you to not only count or add up information in your spreadsheet but also enables you to cross tabulate with another characteristic. For example to count how many votes each candidate earned but break down the votes […]

Read more

Webinar: Use FilterRoster on your Google Forms for Individual Student Spreadsheets

This is a webinar that is a result of @edtechchic exclaiming on Twitter how much she loves the Google Sheets formula =importrange(). I told her that if she loved that she might like my script I wrote that creates and individual spreadsheet for each student based on filtered data from a Google Form. The process uses […]

Read more

Google Forms: Sign In Sheet & Providing Weekly Feedback to Students

Google Forms allow you to collect information from students. One thing I use Google Forms for is to have students sign into class. Once a week I ask for students “Comments, Questions, Concerns or Compliments” to allow me to hear from every student in the class. The information from the Google Form goes to a Google […]

Read more