Tag Archives: Sheets

templateTab: Collaborate with Students using Spreadsheets

templateTab

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

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 Level Up Challenge

Part of my lesson for this week is to introduce my students to Google Drive. Some of the students are adept at tech skills and others struggle with highlighting text. To help differentiate for the variety of Google Drive knowledge, I created a challenge list the students can choose from. The students choose the challenges […]

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