Friday, August 11, 2017

10 Things You Can Do With Google Sheets

As I mentioned yesterday in my run-down of ten ways to use Google Forms, Google Forms and Google Sheets is the part of G Suite for Education that I get most excited about teaching to others. My excitement comes from seeing how many applications for Google Forms and Google Sheets teachers develop once they understand the basics of how Forms and Sheets work. Here are ten ways that you can use Google Sheets once you understand the basics of how to use Sheets.

1. Send personalized emails to everyone in a group. Rather than sending a generic, "hi everyone" greeting you can address each person by name.

2. Create and display progress trackers. This is ideal for things like reading logs or fundraisers.

3. Create flashcards. You can make them or have your students make flashcards from the information in a Google Sheet.

4. Schedule room use. Keep track of who is using a meeting room and when.

5. Develop and publish multimedia timelines. Include pictures, videos, and maps in your timeline.

6. Keep track of iPad/ Chromebook carts in your school. The same logic can be applied to keeping track of anything commonly borrowed in your school.

7. Create maps of data sets. If your spreadsheet contains location data, you can map it from a Google Sheet.

8. Create rubrics and email grades from a spreadsheet. Email scores and feedback from the same place that you recorded scores and feedback.

9. Develop and manage a gradebook. If your school doesn't have a system-wide gradebook system in place, you can create your own in Google Sheets.

10. Create Jeopardy-style games. This staple of review games can be developed and played from a Google Sheet.

This Is Augmented Reality, This Is Virtual Reality

The difference between augmented reality and virtual reality is one of the things that I get asked to clarify on a fairly regular basis. This post has an example of each.

Earlier this year I featured a fun app from PBS Kids called Plum's Creaturizer. It's a free augmented reality app that lets students create fun cartoon creatures then place them into outdoor settings through the use of augmented reality. The purpose of the app is to have students learn and show how the characteristics of an animal help it thrive in its environment. A video demonstration of the app can be seen here.


Plum's Creaturizer and other augmented reality apps like it, are dependent upon location services in order to provide your on-screen experience. Virtual Reality apps, however, are not dependent upon location services to provide you with an immersive on-screen experience. Google Expeditions is an example of a virtual reality app. In my video embedded below I provide a short overview of how to use the "explorer mode" in Google Expeditions to view Mount Everest in virtual reality.


You can create your own basic virtual reality experiences by using the Cardboard Camera app from Google.

The Imperial Presidents - And Other New Lessons from Tom Richey

After a little bit of a summer break it looks like Tom Richey is back to publishing some great videos for history students. His latest videos focus on the topic of American Imperialism. In particular, the most recent video is about the policies of Theodore Roosevelt, William Howard Taft, and Woodrow Wilson.


Tom's videos for AP U.S. History and A.P. European History have become quite popular with students and teachers. That popularity is due in part to Tom's relaxed manner of presentation which is a nice contrast to the sometimes harried style of Crash Course videos.