Ten Second Tech Tip - Google Sheets

Do you use Google Sheets? Here are a couple of quick tips to help make your experience more efficient!

Search:

If you have a lengthy Google Sheet, looking for specific information in cells can be hard! Click Command + F, and a search box appears!

Type in your search, and click the up or down arrow next to the search box. Sheets will take you to each instance there is a match on your search text and highlight the cell in green! (Ignore the static green cells you see on this sheet to the right!)

Move text to a new line within a cell:

It can be really handy to start a new sentence or thought on a new line within a cell. To do that, place the cursor after the line existing in the cell. Click Command + Return to go to a new line within the same cell!

Enjoy a restful and relaxing spring break!

Comments

Google Classroom: Why Are Students Seeing Graded Returned Work as Assigned or Late?

Are students giving you feedback that work you returned to them after grading is now showing as 'late' or 'assigned'? The addition of the Grading module to Google Classroom has impacted this process. Read on to understand what is happening and how to fix it! What is happening? Let's follow through the typical workflow in Google Classroom where students are submitting work to you. You create an assignment in Google Classroom and assign the appropriate points to the assignment . You assign the work to students, which puts the work in status ' Assigned ' in the student view. After updating the assignment, students turn in or submit work back to you by clicking the Turn In button. The work status changes to ' Turned in.' After grading, you return work to students. This is a necessary step to ensure the student owns the document. The status now changes to ' Returned ' if you...

Draftback Replays a Google Document's Changes in Video Format!

Student plagiarism can be a problem. The world we live in makes it easy for students to copy/paste, using works not their own. Identifying plagiarism and addressing it is a big part of students learning to be good digital citizens. My last post outlined the new Originality Reports in Google Classroom, which check student submissions for plagiarism and incorrect or missing citations. Occasionally, you will have a situation that needs a thorough investigation. The Google Chrome extension Draftback is your superhero in this situation! (Shout out to the Science Department, who discovered this gem!) Can't I see a document's version history? You may be aware that you can look at the revision history for any Google Doc or Slide. Click File>Version History>See version history. You are provided a right sidebar. You can click on any revision to review the document at that time. Changes from the pr...

Teen Cell Phone Use Impact on Learning Infographic

I wrote my first research paper in at least two decades a few weeks ago. I was assigned to write on an education topic that had recently appeared in the media, finding one scholarly research paper and comparing and contrasting the current articles and research. I chose cell phone usage for teens as my topic. We have engaged in a lot of conversations about this topic in the past few months at CCHS. I also wanted to create an infographic, so I decided to do that in addition to the paper. You might not recognize the name Infographic, but you will recognize one when you see it. The internet is filled with these digital posters that inform and contain lots of graphics and visuals. Check out my Infographic below. I used a tool called PiktoChart . This tool is designed to create Infographics and provides a lot of templates. Many of the templates mimic research paper organization (topic, subtopic), so creating the Infographic ...

Terry's Tech Tips

Search This Blog