• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Lepre's Learning Log

Beginning Teacher Coaching | Strategies for New Teachers

  • Home
    • Privacy Policy
  • About
  • Blog
  • Podcast
  • FB Group
  • Contact me!

Let’s be social!

  • facebook
  • instagram
  • twitter
  • pinterest
  • mail

Some Google Sheets fun

March 1, 2016 by Kim Lepre Leave a Comment

Share
Tweet
Pin16
Share
16 Shares

For the past several weeks I’ve been writing about Google Docs and a little bit about Google Forms. For those of you who are familiar with Google Apps for Education (GAFE), you know that there are other apps in the suite that are amazing. Today I want to highlight a few functions I use in Google Sheets.

What is Google Sheets? It’s Google’s answer to Microsoft Excel, which is a spreadsheet that has a plethora of functionalities. While Excel is extremely powerful, it’s also very daunting, especially for the average use such as myself. Consequently, I prefer the sweet simplicity of Sheets, particularly since users can collaborate with it similar to the rest of the GAFE apps.

The three functions I’m going to cover are 1) splitting the data from one to two (or more) cells, 2) merging data in cells, and 3) sending out an email template to responders. Since these steps are a bit involved, I’ve uploaded short videos for each. Additionally, I outline how I use these functions, but obviously you can use it in a variety of ways. Once you’ve had a chance to play with it, you’ll dream up of ways this will save you time!

NOTE: in order to use these functions, you’ll need to use Google Chrome to get the proper add-ons. Also, these are all fictitious names and email addresses.

Splitting cells

https://kimberlyl.edublogs.org/files/2016/03/Split-first-last-names-2bfgmjl.mp4

Merging cells

https://kimberlyl.edublogs.org/files/2016/03/Create-student-usernames-29q3m0a.mp4

Email Merge

I want to add that part of the genius of this function is that you can send personalized emails to students.

Let’s say you created a Google Form for students to assess each other online. As long as you set up the Google Form correctly, you could use this email merge to send that feedback directly to the students!

https://kimberlyl.edublogs.org/files/2016/03/Email-merge-1u8g3v1.mp4

As always, if you have any questions or want some one-on-one help, let me know!

You might also like these

Share
Tweet
Pin16
Share
16 Shares

Filed Under: Educational Technology, Teaching Tagged With: Google Sheets, mail merge, merge cells, split cells, spreadsheet

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Hi, I'm Kim! I help new and beginning teachers navigate through their crazy first few years of teaching so that they can THRIVE instead of survive.
Facebook
Facebook
fb-share-icon
Twitter
Visit Us
Follow Me
Tweet
Instagram
Pinterest
Pinterest
fb-share-icon

Learn more about

  • Assessment and Grading
  • Beyond Teaching
  • Curriculum
  • Digging into Data Series
  • Educational Technology
  • Podcast
  • Student Blogging Series
  • Teaching
  • Teaching Strategies

What are you looking for?

My most popular posts

Footer

Categories

Let’s be social!

Facebook
Facebook
fb-share-icon
Twitter
Visit Us
Follow Me
Tweet
Instagram
Pinterest
Pinterest
fb-share-icon
Contact Me!
  • Privacy Policy

Copyright © 2018 Lepre's Learning Log - All Rights Reserved | Sitemap

Beginning Teacher Coaching | Strategies for New Teachers