Thursday, June 8, 2017

5 Neat Things You Can Do With Google Sheets

Once you get the hang of working with Google Sheets there are a lot of great ways to use spreadsheets as a teacher or as a student. Here's a run-down of some of my favorite things to do with Google Sheets in the classroom.

Map spreadsheet data:
One of the overlooked and or misunderstood features of Google My Maps is the option to import spreadsheet data. Provided that your spreadsheet contains at least one column that has location information in it, you can have the data in the spreadsheet displayed as placemarks on a map. In the video embedded below I provide a demonstration of how this can be done.

StoryMap JS is a nice tool for creating mapped stories. On StoryMap JS you create slides that are matched to locations on your map. Each slide in your story can include images or videos along with text. As you scroll through your story there are simple transitions between each slide. StoryMap JS integrates with your Google Drive account. To get started with StoryMap JS you have to grant it access to your Google Drive account. StoryMap JS will create a folder in your Google Drive account where all of your storymap projects will be saved. With StoryMap JS connected to your Google Drive account you will be able to pull images from your Google Drive account to use in your StoryMap JS projects.

Create multimedia timelines from a spreadsheet:
Timeline JS creates a timeline based on entries made in a Google Spreadsheets template provide by Timeline JS. Your entries can include links to videos, images, and maps. I made a video on how to use Timeline JS. That video is embedded below.

Guided/ Automatic Data Visualizations:
The Explore function in Google Sheets will help students see and understand data sets in new ways. Now when students open a Google Sheet they will have the option to click the Explore function to have a set of suggested graphs and charts based on the data in the Sheet they're viewing. The Explore function is found in the bottom, right corner of the Google Sheet you're viewing. The Explore function won't work in every spreadsheet. It is dependent on the spreadsheet having data like locations, currencies, or demographics. See how it works in the video embedded below.

Grade students' assignments:
Flubaroo is a popular Google Sheets Add-on that enables me to grade all at once all of my students' responses to a quiz created in Google Forms. The autograde option in Flubaroo allows you to have students automatically receive their scores after submitting their responses to a quiz you created in Google Forms. The autograde feature will send students an email with their scores and the answer key (you can exclude the answer key). With autograding enabled students do not have to wait for you to run the grading process or wait for you to send emails.

Online Rubric is a Google Spreadsheets Add-on that enables to you create rubrics, enter scores, and email scores to students all from one place. Online Rubric provides very clear instructions for each step of the processes of creating a roster sheet, creating a rubric, and emailing grades to students. The video below provides a demonstration of how to use the Online Rubric Add-on.

Email reminders:
Add Reminders is a Google Sheets Add-on that will set-up your spreadsheet so that you simply enter reminder messages and email addresses then specify a date on which you want your reminders sent. The Add Reminders Add-on allows you to send the same reminder to everyone in your email list or you can send individualized reminders to everyone in your email list. Watch the video below to learn how to use the Add Reminders Add-on.

4 Good Formative Assessment Tools for Classrooms That Aren't 1:1

Earlier today Kahoot announced that they now have 50 million users. That prompted one person to email me asking if there was something similar that she can use in her classroom that isn't 1:1. My immediate reply was to try Kahoot's team mode.

Kahoot's team mode is designed to be used with students who are sharing computers, tablets, or phones. In team mode students arrange themselves in teams around a shared computer or tablet. When you start a Kahoot game you'll now choose "team mode." With team mode selected your students will be prompted to enter a team name and a list of the team members. After the teams have entered their names you will be ready to start the game. One of the nice features of team mode is that students have time to discuss their answer choices before they are allowed to submit a response. From there the game is played and scored as any other Kahoot game is played and scored.

Socrative is the standard to which I compare all new student response systems. Socrative uses cell phones and or laptops (user's choice) for gathering feedback from students. You can post as many questions as you like in a variety of formats. One of the more fun question formats is the "space race" format in which students can work individually or in teams to answer questions as quickly as possible.

If not every student in your classroom has a laptop or tablet to use, then you need to check out Plickers as a student response system. Plickers uses a teacher's iPad or Android tablet in conjunction with a series of QR codes to create a student response system. Students are given a set of QR codes on large index cards. The codes are assigned to students. Each code card can be turned in four orientations. Each orientation provides a different answer. When the teacher is ready to collect data, he or she uses the Plickers mobile app to scan the cards to see a bar graph of responses. In your teacher account on Plickers you can view and save all of the data that you collected from scanning your students' Plickers cards.

Quick Key is an excellent platform for creating and conducting formative assessments. It is a tool that works equally well in classrooms that are 1:1 and in classrooms that are not 1:1. This is possible because Quick Key allows you to create formative assessments that you can distribute electronically as well as on paper. If you use Quick Key to distribute your assessments electronically, Quick Key will score your students' responses automatically. One of the latest features of Quick Key is an integration with Google Classroom. This integration lets you use your Google Classroom rosters to distribute and collect assessments. If you distribute your assessments on paper, you can use the Quick Key mobile app to quickly scan your students' answer sheets and receive the scores.

Disclosure: Quick Key is an advertiser on this blog and Plickers once sent me a free t-shirt and some cards.