Font Formatting in Google Comments

Did you ever really, really, really want a student (or colleague) to understand your feedback on a portion of a Google Doc?  Well, my friend, I have got news for you.  Surround a word (or group of words) in a Google Docs (or Slides, Sheets, Drawings…) Comment with asterisks (*) and you’ve got bold text. 💥Boom💥 Surround them with underscores ( _ ) and you’ve got italicized text. 💥Boom💥

🤔❓Why does using the underscore lead to italicized text instead of underlined text!?  I have no idea.  Ask the Googs.❓🤔

Even more puzzling, there’s no option to create underlined text.  But hey, 3 minutes ago, you didn’t know about how to do bold or italics, so calm it down, buddy.

Here’s the real head-scratcher: some people seem to want strikethrough text in a comment.  🤷🏻‍♂️  Why?  I dunno.  But it’s possible.  Just surround your text with hyphens (-) and you’ve got strikethrough.  Medium-half-excited-don’t-know-why-anyone-wants-this-feature-💥Boom💥.  But again, 4 minutes ago, you were clueless that this was even within the realm of possibility, so turn your snark dial down, Francis.  Anyhow, here’s a GIF.  Please enjoy.

Formatting Font in Comments GIF


Using Answer Tables in Google Docs

A few weeks ago, I posted a little hack that I like to use for making student answers in Google Docs easier to find.  You can see that post here.  Multiple people reminded me of a practice that many elementary educators love using:

Instead of just pre-formatting the answer space, actually create an answer table.  This makes it less likely that students accidentally mess up the pre-existing content in the doc and makes their answers easier to find.  This is a great practice when assigning these Docs as Make a Copy for Each Student in Google Classroom.

There are 3 different ways to do this.  I’ll show each in the GIF below and then go over them in some additional detail below the GIF.

Tables in Docs for Answers

More details on what you see in the GIF below . . . Continue reading Using Answer Tables in Google Docs

Google Drawings in Google Classroom

A few weeks ago, I shared a post about putting Drawings in Google Docs that are assigned in Google Classroom. After seeing some of the reactions, I realized that some educators either weren’t aware of the powers of Google Drawings or had never thought of using them in assignments with Google Classroom.  I was all “whaaaaat!?”  So, now I’m here to dial it back a notch…  Let’s talk about assigning Google Drawings (not Drawings in Docs, just Drawings) in Google Classroom.  First up: an animated GIF for your viewing pleasure; and then: a quick step-by-step of how to use Drawings in Classroom.

Google Drawings in Classroom Animation

Continue reading Google Drawings in Google Classroom

Creating & Locking Google Slides Backgrounds

If you’ve ever created assignments in Google Docs, Slides or Drawings for students to complete, you’re all too familiar with this struggle: students accidentally deleting, moving or modifying elements of the assignment.

Well, in Google Slides, there are 2 ways to prevent this from happening and here’s the easier of the two: put the content of the assignment in as a background.  Then, the only way a student can delete, move or modify it would be to actually go into the background settings and change it…. which can’t be done by accident.

Let me show you how, first with an animated GIF and then with step-by-step instructions.Creating & Locking Google Slides Backgrounds Animation

  1. Set up your slide with any text, images, etc.
  2. File > Download as > PNG Image (JPEG will work too)
  3. Clear off the slide.
  4. Click Background, then, next to Image, click Choose.
  5. Click the downloaded image file from Step 2.
  6. Voila!  Send your assignment out in Classroom (or share it with students or have them make a copy).

Insert Drawings into Docs Being Assigned in Classroom

When given the chance, I’m always going to pick an assignment where students are creating their own representations of their mastery of learning standards.  However, I know that it’s not realistic to expect this all the time.  So, I can see the value in annotating images rather than just typing.  Google Drawings and Google Slides are great platforms for this . . . but what if it’s part of a bigger activity that does involve typing?  Well, insert a drawing into a document, put the picture in, and tell the students to annotate it!  Check it out in the animated GIF below (typed instructions follow the GIF).

Drawings in Docs with Google Classroom Animation

  1. In the Google Docs menu, click Insert > Drawing.
  2. In the Drawing that pops up, copy and paste in an image (or drag it in from a separate tab as I did in the GIF).
  3. Add instructions within the Drawing as needed.
  4. Click Save and Close to finish preparing the drawing.
  5. Assign the document in Google Classroom as Make a Copy for Each Student.
  6. When students open the document, instruct them to double-click on the image that they see to open up the drawing and annotate it.

Pre-Format Student Answers

Grading stinks.  Anything that we can do to make it better–without sacrificing the quality of the pedagogy or feedback–is worth doing!  Here’s a little trick to make it easier to locate student answers in Google Docs (or other files) that you assign in Google Classroom . . .

Pre-Format Classroom Answers Animation

Saving Images from Google Docs

When edtech rockstar Matt Miller says “Hey Jake, you should make this into an #EduGIF!” you listen.  He was right, too.  It was an awesome tip.

It was a pickle that I had been in before, but I had never known the solution.  You’re preparing something–a lesson, a blog post, whatever–and you need a picture.  Not just any picture, but a picture that you’ve used before.  It’s in that one Google Doc, but you can’t get to the picture from anywhere else.  So, you right-click on it in that Google Doc . . . but there’s no Save Image option.

There are a handful of ways that you can get that image saved as a file on your computer, but the one that Matt sent to me is pretty awesome.  It’s just a few steps and super easy.  And it’s even more convenient if you have multiple images that you need from the same Google Doc.  So, let’s get to it – first an animated #EduGIF and then the steps for those of you who like to read words.

Save Images from Docs Animation

  1. Open the Google Doc
  2. Select File > Download As > Web Page (.html, zipped)
  3. Locate the saved file on your computer
  4. Unzip the file (on my Mac, all that I have to do is double-click)
  5. A new folder should have been created. Inside of that folder will be all of the images that are in that Google Doc.  Feel free to move your image out of there and delete the other files as well as the zipped file.

Dropdown List in Google Sheets

Did you know that you could add a dropdown list of options to a cell (or cells, plural) in Google Sheets?  This is nice for creating something like a “multiple-choice option,” but is also nice when you want to force your collaborators (or yourself!) to select from a specific list of choices.

It can be especially useful if you have formulas acting on that cell.  For example, if you were keeping track of a budget and wanted different things (i.e., adding versus subtracting) to happen if a row was marked as a deposit, purchase or interest.

Here’s an animated GIF about how to do it followed, as usual, by a list of the steps.

Sheets Dropdown Animation

Step 1: Click on the cell or cells that you plan to add the dropdown list to
Step 2: Right-click & select Data Validation
Step 3: In the dropdown by Criteria, select List of Items
Step 4: Type your options into the box, separating them with commas (I tend to alphabetize them)
Step 5: Click Save.