Translate in Google Sheets

Living in a new country where a different language is spoken is something that I can barely fathom. Doing it as a child just blows my mind. Our schools are often ill-equipped to support these kiddos, but they often do have one powerful tool that can help: compassionate teachers.

One of these compassionate teachers once came to me looking to create a tool to support an ELL (English Language Learner) student. We both knew that we worked with a great ELL Tutor who was helping this student assimilate to the school . . . but what about the vocabulary that was being learned in the meantime?

His idea was to organize important English vocabulary words and their translations to the student’s native language into a spreadsheet. After he came to me with this idea, I started exploring options. What I discovered was really exciting! There’s a Google Translate formula in Google Sheets!

Enter a word in one language in a cell, and then use the formula =GoogleTranslate(text, source_language, target_language) in another cell to automagically translate it! Translating one word this way doesn’t save my time, but you can drag (or double-click) the fill handle at the bottom of the formula cell to apply this formula to more than one cell.

This formula appears to work for all languages supported by Google Translate, of which there are more than 100! It even outputs the results with the correct letters and alphabet–not just our ABC English letters. You’ll just need to know the 2-letter code for the language, which you can find in this list.

A note: as with using the regular Google Translate site, the results are not 100% accurate, but they’re close. This method is free, fast, and easy. There may be other options that can yield better results.

Check out how to do it in the animation below and then read the steps below the EduGIF!

This animated GIF shows the process for translating large sets of words in Google Sheets. Captions or audio are not currently available, but the steps are in the blog post.

Continue reading Translate in Google Sheets

Tab-Level Edit Rights in Google Sheets

In Episode 50 of the Google Teacher Tribe Podcast, Bailee Sandsmark, a 6th-grade middle school PE teacher, asked a Google Sheets question that got my gears turning.  All that gear turning inspired a new #EduGIF from me.  First, let’s look at her question:

I’d like to send out a Sheets template to all 250 of my students for them to individually track their fitness testing data, but then I would like to have an efficient way for them to share that info with me so that I can see all of my students’ data in one sheet. Having to access 250 different sheets makes my head spin…

While Matt & Kasey had a handful of good ideas of their own, I had another one that I wanted to share.  It came from a thought that Matt shared: it’d be nice to give each student a tab in one spreadsheet, but then each student could edit the others’ tabs.  That’s where “tab-level permissions” comes into play.  If you click on the tabs at the bottom of your Google Sheet, there’s a Protect Sheet option.  It’s also accessible from under Tools.  As you’ll see in the Animated GIF below, you can use this to give tab-level edit rights to specific students.

Before we get the GIF, a few notes:

  • If each tab will be identical, you can duplicate the tabs.
  • If you’d like to create a tab for each of your students, you can use Alice Keeler’s Template Tab add-on.
  • You can also use this to give or limit edit access for just specific cells – I do this sometimes to make sure no one messes up formulas that I have running.
  • In Bailee’s, situation, she’ll still have the issue that each student can see their classmate’s information (even though they can’t edit it).  To prevent this, you could give them code names or numbers.
  • The tabs that we’re referring to are technically called sheets, but I think that’s super confusing that the individual parts of Google Sheets are Sheets.  What!?

And finally, the GIF:

Tab-Level Edit Rights in Google Sheets Animation

Customize the Numbers or Letters in a List in Google Docs

Educators use bulleted and numbered lists all of the time.  Wouldn’t it be nice to be able to customize those lists?  Maybe instead of 1, 2, 3… you’d like Step 1, Step 2, Step 3…  Well, you’re in luck.  This is one of those features in Google Docs that many people may have never noticed was there.  Right-click on a numbered list (or go to Formats > Bullets & Numbering > List Options) and you can modify the prefix and suffix of the numbers (or letters) in your list.

I can think of a few prefixes you may use – step, station, period, day, activity, option, choice, # – but I’d love to hear your ideas and uses!  Finally, here’s an animated GIF of how it works:

Add Prefix & Suffix to a Numbered List Animation

Speech & Thought Bubbles in Google Drawings

On the Google Teacher Tribe podcast and on his site DitchThatTextbook.com, Matt Miller shared about his recommended use of thought bubbles (and speech bubbles) in Google Drawings.  When I first heard it, I thought – “Whoa!  What a simple, but powerful application of a technology tool.”  Think about it: students being able to comprehend a story or historical event well enough to synthesize the information back into what they predict a character/person may have been thinking or saying?  Not to mention, it’s quick and it’s much more engaging that writing it on a worksheet or in a Google Doc.  Matt recommends this as a Bell Ringer activity, which I think is an awesome idea, but certainly not the only way it can be used. Teachers these days are incorporating kindergarten worksheets for kids to help them learn better.

This can also be done in Google Slides–it would be neat to have each kid have their own slide–and through the “Insert > Drawing” option on Google Docs.  Just like with Google Docs, you can have students make copies of your drawing to add their own thought bubbles or you can use them as assignments in Google Classroom or other LMS’s.

Check it out in the Animated GIF below and then, after the GIF, is a published version of that Drawing, just to show how easy it is to post the completed project.

Speech & Thought Bubbles in Google Drawings Animation

Continue reading Speech & Thought Bubbles in Google Drawings

Enhanced Sharing Settings on New Google Sites

As soon as it came out, I thought the New Google Sites made a pretty awesome Digital Portfolio tool.  However, there was one important feature missing – sharing settings that allow you to choose to not make student work public.  Well, it’s there now!

First up, a quick overview of this in Animated GIF form, followed by detailed information about the options.

Sharing Settings in New Google Sites

You have a few publishing options with New Google Sites, assuming you’re on a gSuite for Education domain.  Here they are:

Continue reading Enhanced Sharing Settings on New Google Sites

Padlet Embed on New Google Sites

With it’s recent addition of different wall formats, Padlet has become one of my favorite edtech tools – there’s just so many possibilities for its uses!  And embedding it in a Google Site opens up so many additional possibilities!  Just think of the open lines of communication, collaboration and sharing that this can open up! Got a great idea for how it could be used?  Share it in the comments below – or share this post with your idea on social media.  Below, an animated GIF to show you how to embed a Padlet board onto a New Google Site:

Padlet Embed on New Google Sites Animation

Paint Roller Tool in Google Slides

One of the more underutilized tools within Google Docs, Slides, Drawings & Sheets is the Paint Roller (Paint Format) Tool.  It’s purpose is simple – when you want some text or an object to be formatted just like another set of text or an object, the Paint Roller is the tool that you need.  Click once on the already-formatted object/text, then on the Paint Roller and then on the to-be-formatted object/text.

I’ve posted before about how it works in Google Docs, but I wanted to share an animated GIF about how it works in Google Slides!  Notice that it works on text boxes, as well as on shapes, lines and images!  With text boxes, you can even apply it to certain words in the box rather than the entire box.

Paint Roller in Google Slides Animation

Embed Twitter Timeline in Google Sites

**Oops. As of 2/21/19, you cannot embed a “stream” of tweets with a certain hashtag.  I believe it was a future at the time of this original post that has been removed.  Alternatives include (but are not limited to) adding tweets manually to a Twitter moment & embedding that, adding tweets to a Wakelet wake and embedding that, use other tools (TweetDeck’s Stories, possibly HootSuite’s hootfeed tool).**

Whether you’re a teacher communicating with your class, a school communicating with your community or an educator sharing with other educators around the world, embedding Twitter in Google Sites is a good tool.  It was missing from the new Google Sites initially, but now they’ve added it in.

The animated GIF below demonstrates how to do it.  I’m not the first to share this process, but I wanted to create a GIF to demonstrate it.  I looked at Alice Keeler’s post about it to make sure I knew the steps before I started.  If you need the step-by-step (or info about the other Twitter-Google Sites embeds), check out her post.

Embed Twitter Timeline in Google Sites Animation

5 Ways to Link to Parts of Google Docs

There are a lot of reasons that you may want to put links into a doc that allow you (or the reader) to jump to certain parts of a Google Doc.  Here are a few possible reasons:

  • You’re creating a HyperDoc with lots of stuff in it!
  • Your students are creating eBooks and need a Table of Contents
  • You’re managing a long doc of lesson plans and want to be able to jump to different units or months
  • Your students are creating Choose Your Own Adventure books
  • You’re collaborating with a team of educators in a doc with multiple meetings worth of notes
  • A slightly different reason – sending a link in an email (or messaging system) that takes the recipient directly to a certain location within the doc

There are a few different ways to manage this and different ones are best in different situations.  Let’s check them out!

1. Using “Headings” to create linkable pieces of text

When you use the “Styles” dropdown to format parts of your doc as Heading 1, Heading 2 or Heading 3 those Headings become links that even show up in the Insert Link menu.  Check out the steps in the animated GIF below.

Headings as Links Animation

2. Copying the url for headings, titles & Subtitles

You may have noticed that in #1, I didn’t mention Titles or Subtitles along with the 3 different levels of Headings.  This is because they don’t naturally appear in that Insert Link box.  I’m not sure why.  Regardless, if you add a title or subtitle (just like a heading) you’ll notice that when you click on them, the URL changes. This is because the URL is specific to that location in the doc.  So, copy that URL and create a link with it elsewhere in the doc to jump to that spot.  Check out how in the animation below.

URLs from Titles Animation

Note: These URLs are nice outside of that doc as well.  Let’s say a colleague asks you about a specific topic that was discussed in a faculty meeting a few weeks back.  Copy the URL for the heading or title from that meeting and email it to them – then, when they click on that, not only will the doc open, but they’ll jump to the right spot.

3. Use Bookmarks

What if you don’t want to format some of your text as a “title” or “heading”?  Well, bookmarks are the answer for you.  In my school, we have a shared document for the plans for our “PRIDE” period, that all teachers teach.  We use bookmarks to make it easy to jump by month.  The biggest use of this that I can see, though, is to have students link to the locations of their evidence.  Think about it: How do I know that the character is feeling remorseful?  I can see evidence here when he says “sorry” and here when he is feeling depressed about what he did.  Add links to the spots in that document where those events happened and you can see evidence of your students’ reading comprehension.  *Boom!*  Check out the process for adding bookmarks and using them for links in the animation below.

Bookmarks in Docs for Links Animation

4. Insert Table of Contents

If you want there to be links to each chapter of your ebook (or dates of your lesson plan or agendas from your meeting…) up at the top of your document, the Table of Contents is a great solution for you.  There are two main downsides of the Table of Contents.  First,it doesn’t work with Titles or Subtitles.  Second, the Table of Contents can become really long.  But, if you want links to each of those Headings in the doc, this will be great for you, because it’s really simple to set up.  Check it out:

Insert Table of Contents in Docs Animation

5. Document Outline

The last option is convenient, but isn’t for creating links in the document itself.  If your goal is just to be able to navigate the document quickly without concern for how other people navigate your document, the Document Outline is a great solution for you.  Anything that you format as Title, Subtitle or Heading automatically goes into the Document Outline.  An interesting tidbit is that it also adds things that look like headings to this list (i.e., something bold and underlined).  Just remember: your document’s viewers only see the document outline if they go to View and turn it on themselves.Document Outline Animation

The Ultimate App Smash Lesson

 

Recently, I was fortunate to be a guest on the awesome Google Teacher Tribe Podcast.  Not only are Matt & Kasey rockstars, but their show is my favorite education podcast.  It was an honor and a blast.

It’s a tradition on the show for the guest to create a lesson plan that listeners can use.  I chose to take a few ideas that I’ve posted about here and combine them into the Ultimate App Smash Lesson.  The lesson combines #StopMotionSlides, Screencastify & FlipGrid.  It can be used with any just about any content and is appropriate in most grades, starting in around 3rd grade.

You can find the lesson at bit.ly/ultimateappsmash.  I hope you enjoy it . . . and I’d love to see some of what your kiddos create when you use it!