Paint Roller Tool in Google Sheets

I’m a big fan of the Paint Roller (Paint Format) tool in the gSuite platform.  I’ve posted before about using it in Google Docs, as well as in Google Slides.  I probably use it most often, though, in Google Sheets.  I love a nice, organized Google Sheet and this tool helps a lot with that.  My favorite part about it is that it even applies to number formatting (i.e., decimal places, date format, currency, etc.).  Check it out in the animated GIF below!

Paint Format in Google Sheets 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.

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

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

Use Preview in Docs for a Quick Whole Class Progress Check

In a blended classroom, it can be tough to see who is on and off task and know who is behind on their work.  One trick that I often used in my STEM classes was to open the Google Drive folder that all of my students’ work was in and click through the previews of their docs.  The previews weren’t always the most current version (it’s likely the status of the file when you most recently opened up Drive), but I could easily identify students who may be behind (or off task) and then open up their docs to check for sure.  It was much faster than opening all of the docs would have been!  I also used this occasionally when assigning some pretty simple grades, especially if they were completion grades.

Use Preview for Quick Progress Check Animation

Equations in Google Docs

Math & Chemistry teachers use Google Docs, too!  And so do other content areas and teachers who integrate math and sophisticated science across content areas.  And, for those peeps, there is the ability to add equations and other “mathy” symbols to Google Docs.  Just click Insert > Equation.

A quick note, before we get to the GIF: Some educators will tell you that this tool could be better.  And for people looking to use this functionality regularly, they’re probably right. In that case you may want to consider other tools (equatIO is a great one).  But for people who just use it occasionally, I think the Equation Editor is a’okay.

Equations in Docs Animation

Screencastify for Feedback

I’ve done a number of posts about Screencastify, but recently I was reading a blog post that presented an idea that I had not previously thought of.  In it, the author talks about using a screencasting tool to give both visual and auditory feedback on a student’s work.  It seems to me that this would be so much more useful for a student than just comments on the doc.  Plus they’d be more likely to view it.

Add in the ease of use with Screencastify – quickly sharing in Google Drive – and you’ve got a win-win.  Below is a GIF I made to share the process.  In the GIF, I am giving (fake) feedback on a Google Doc, but it could be anything.  I could even show how it falls on a rubric within the video!

You could even have students give each other feedback this way!

One last note – if you start doing this regularly, you could create one folder in your Drive for each of your students and then drag the videos into those folders for the students to view.

Screencastify for Feedback Animation

Representing the Writing Process with the Version History

Note: I’ve heard this mentioned elsewhere, so I’m not claiming to be the originator of the idea.  One place I heard it mentioned was in Episode 21 of the Google Teacher Tribe Podcast.  Another is in this great post by Eric Curts. I am, however, the creator of the GIF below.

I’ve gotta admit, I was apprehensive when Google renamed my beloved Revision History as the Version History.  I thought “If it ain’t broke, don’t fix it.”  But there is an added value in the format change – and that value rests mainly in the Writing classroom, but it applies in any classroom.

Now, you can name the versions in the Version History.  Pre-writing, First Draft, Peer Revision, Second Draft, Teacher Feedback, Final Draft, Published Version, you name it.  Students can now represent the stages of the Writing process with the names of their document versions.  With Writers’ Workshop being the trend in our writing classrooms, this seems like a no-brainer.

Name Versions of Version History Animation

Screencastify, Paper & Math: Spin It Around, Write It Down, Explain with Sound!

This post originally appeared on the Screencastify blog, here.

We all know how important it is for students to demonstrate

their understanding of a particular subject or problem by “showing their work.” If your students are using tablets, there are a number of great interactive whiteboard recording apps that allow students to write with a stylus, annotate images and provide audio explanations.

But what about the large student population who are using Chromebooks, not tablets?  Some new Chromebooks have touch screens and a small number are ready to roll with Android apps, but for the majority of our students, this type of recording feature is nowhere in their near future.  And it’s a great feature!  What’s better than telling a student to “show their work”!?  Telling them to “explain their work” or, better yet, narrate it.

As an educational technology advocate and problem-solver, I am always looking for a hack.  And, here’s my hack for this.  Tell your students: “click on the Screencastify extension, select Cam, spin the computer around, aim it at a piece of paper, starting writing or drawing and explain away.”  In short, spin it around, write it down, explain with sound.

Check out my hack in action in the video below!

Easy Citations in Google Docs

**Updated on 10/30/19 with fresh #EduGIFs & Pausable EduGIFs**

Digital citizens are constantly sharing other people’s content.  We are all cultivators of stuff.  Images, quotes, GIFs, artwork, you name it – we share it.  It is very important that we teach kids to give credit where credit’s due.

Unfortunately, students are very resistant to citing their sources when they do schoolwork.  Why?  I believe it’s because it’s a pain to do so.  Who would want to cite their source if you have to do tons of sleuth work to figure out who the original source really was?  Who would want to cite their source if you have to enter a boatload of information into a separate site to prepare the citation to put in your document?

In my book, the goal for students, especially those in middle school, should simply be to get them to cite their sources.  I’m not going to stress out about if it really is the accurate original source.  I also wouldn’t stress about them correctly placing their periods and commas in their MLA citation.  I just want them to recognize that the content is not their own and that the originator deserves credit.  Google Docs makes that easy with two tools.  Let’s check them out . . .

Using the Explore Tool in Google Docs

This will only work for resources on the web (not books), but it’s super easy to use.  It creates footnotes, which I’ve heard aren’t commonly used in K-12 writing.  However, as you’ll see in this animation, you can easily copy those footnotes and turn them into a Works Cited.  Check out this #EduGIF to see how (Pausable #EduGIF available here):

Citing in Docs with the Explore Animation

Using the EasyBib Add-On

This tool is great for citing books, but not as good at citing websites.  It keeps track of your entire bibliography until you’re ready to add it to your doc.  If you are using the Explore tool for your websites, you can just combine them when you’re done, just like I do in the #EduGIF animation below. (Pausable #EduGIF available here)

Citing in Docs with EasyBib Animation

Disclaimer: I’ve heard from a few sources that these two tools do not always produce 100% accurate citations.  In my opinion, as stated above, this is a risk that I’m willing to take, at least until students are in college prep high school courses.

Text on Both Sides of Images in Google Docs

When you look at newspapers, magazines or newsletters, you often see centered pictures with 2 separate sets of text on either side of the image.  However, when you center an image in Google Docs and set it as Wrap, the text continues horizontally around the image.  This may be useful sometimes, but in general, doesn’t look like what we’d see in a professional publication.

Now, Columns in Google Docs can help you with this, assuming that you want only 2 or 3 columns and that you want them to be equal widths.  But, what if you want more columns?  Or widths that aren’t equal?

Well, here’s the hack for you.  Create a table, put the picture into the table and use the remaining cells to type your text.  When you’re all done, set your table borders to 0 point (a.k.a. invisible!) and you’re good to go.  Check it out:

Docs Text on Both Sides of Image Animation