Create QR Codes Right in Google Sheets

Standard
You know what QR codes are, right? They are those funky square images that you can scan and be instantly transported to a website. But QR codes are so much more than that. You can create QR codes that provide directions, prompt the user to make a phone call, share contact information and more. QR […]

Math + Pixel Art = Engaging Activity

Standard
This week’s tip builds on a previous one that Kristie Hughes did on Pixel Art. I highly recommend that you read Kristie’s tip when you get a chance, but the TL:DR version is this: You can use conditional formatting in Google Sheets to color cells to make pictures. This is called pixel art, and it […]

A (Dot) New Way to Google

Standard
There are several ways to create a new Google file. You can do it using the plus sign in Google Drive… or start a new document from a current one using the File menu… or go to docs.google.com/create. Now there is a super easy way to start a new Google file… and it’s (dot) new! […]

Split Text to Columns Easily

Standard
Sometimes the simplest features can be the lifesavers! Today’s tip is no different. Have you ever had a list of names or other data that need split? In my example, I have a roster of students’ full names. This is not ideal, because I’d like to have them split by first and last so I […]

Summer PD Roundup

Standard
Summer is almost here! It’s a great time to relax, recharge and yes, even level up your technology proficiency. While Tech Tips Tuesday is going on our annual break, we wanted to leave you with some summer professional development opportunities. Remember, all Northern Buckeye/NWOCA trainings are included with membership at no additional cost. You also have access …

Copy Comments and Suggestions in Google Docs, Sheets and Slides

Standard

I love collaborating with my team (and educators all over NW Ohio!) with Google Docs, Sheets, and Slides. One of my biggest frustrations is that the comments and suggestions don’t transfer when you make a copy. This means you lose your history of all your collaboration when you duplicate a document, spreadsheet, or presentation.. Now Google is making it possible to copy comments and suggestions any time you make a copy of a Docs, Sheets, or Slides file.

To copy your comments and suggestions, simply select “Make a copy” from the File menu as your normally do. Now you’ll see an option for “Copy comments and suggestions” or “Copy comments.”

Copy comments screen

Check the box, and you’ll see your comments and suggestions transfer to the new document! The comments and suggestions will contain a note indicating that they were copied from the original document.

Check it out today, and collaborate—even on copies—with ease!

Comments… comments everywhere!

Standard

One of the things we might lose when moving to digital tools is communicating with our students. Just like we can leave notes on physical assignments, we can also do this with our digital assignments in Google Classroom.

There are three basic kinds of comments you can leave students in Classroom.

Class Comments: These are comments that you add to your class stream on the “outside” of an assignment or announcement. This type of comment is visible to the entire class, and can be used to answer questions that anyone might have.

Example of Class Comment

 

Private comments: You can add these comments by viewing assignment results and clicking on an individual student. On the right, below the student submission there is a  comment bar. Leave comments here that only the student can see. This is useful if it has sensitive grade or feedback information. You can also add a private comment to a number of students at once when returning an assignment. Check out our previous tech tip on managing private comments.

Example of a Private Comment

 

Example of a comment in a doc

Comments in a Doc/Slide/Sheet/Drawing: These comments are left on the student’s file that he/she submitted to you. Highlight something you’d like to comment on, then click the black speech bubble icon. This adds a comment on specific items in student work.

 

Knowing how each of these comments works and when to use each kind will make giving student feedback more efficient and effective.