Saturday, January 25, 2020

Three Neat Things You Can Do With Google Sheets

Earlier this week my friend Beth asked me for some tutorials on Google Forms for beginners. As a follow up to that I've selected three Google Sheets tutorials from my library. These tutorials are for doing some interesting things with Google Sheets besides just looking at information collected through Google Forms.

Create a Random Name Picker in Google Sheets.

Create a Progress Tracker With Google Sheets

Create a Map of Spreadsheet Data

The Week in Review - The Most Popular Posts

Good morning from Maine where it's nearly forty degrees warmer than last week. It almost felt like March weather when I went out with my dogs this morning. It's going to be a great day for taking my toddlers skiing. Wherever you are this weekend, I hope that you get to do something fun too. If that means catching up on some reading, take a look at this week's list of the most popular posts.

This week I hosted the third installment of Teaching History With Technology. A few folks have asked if I'll be offering the course again. I will be hosting it again in the spring after I wrap up Video Projects for Almost Every Classroom.

These were the week's most popular posts:
1. Quickly Create Collaborative Maps With Ethermap
2. How to Use Microsoft Forms to Collect Files
3. Rubrics and Originality Reports in Google Classroom
4. Three Google Forms Tutorials for Beginners
5. A Tip for Your Colleagues Who Unneccesarily Use "Reply All"
6. Vortex by ClassTools - Create Your Own Sorting Game
7. How to Create an Online Sorting Activity Using Google Sheets

I'll come to your school in 2020! 
Send me an email at richardbyrne (at) to learn more about how we can work together. This year I'm offering an opportunity to bring me to your school for free! Ask me for details.

Video Projects for Almost Every Classroom
Video Projects for Almost Every Classroom starts next week! You can get more information and a discount code right here.

Thank You for Your Support!
Other Places to Follow My Work
Besides and the daily email digest, there are other ways to keep up with what I'm publishing. 
  • Practical Ed Tech Newsletter - This comes out once per week (Sunday night/ Monday morning) and includes my tip of the week and a summary of the week's most popular posts from
  • My YouTube Channel - More than 16,000 are subscribed to my YouTube channel for my regular series of tutorial videos including more than 300 Google tools tutorials. 
  • The Practical Ed Tech Podcast is where I answer questions from readers, share news and notes, and occasionally talk to interesting people in education. 
  • Facebook - The Facebook page has nearly 450,000 followers. 
  • Twitter - I've been Tweeting away for the last twelve years at
  • Instagram - this is mostly pictures of my kids, my dogs, my bikes, my skis, and fly fishing.