On the eighth day of Google, we will look at a couple of aha moments from Google Sheets. Google Sheets is such a valuable tool to help us be efficient with data. I have found over the years that I have been able to improve my skillset in working with data. I by no means am an expert but I do enjoy learning new stuff. Did you know…
Did you know that you now have the ability to see edit history of particular cells? How to see this history?
Right click on a cell
Choose ‘show edit history’
A small window will appear with any edit history of that cell. You might notice a left/right arrow having you take a look at different versions of just that one cell.
I like that you have the ability to focus on one particular part of the Google Sheet rather than having to sort through everything to find what I are looking for.
On the fifth day of Google, we will take a look into YouTube. Some of the features below are not necessarily all new ideas but ideas that are worth taking a second look at.
Ever in a situation where you want to speed through a video? Consider changing the speed by which it is played. Perhaps you are running out of time or you feel like you can get more out of the material if it is sped up. I find myself doing this more and more. If I see a video or webinar that I want to watch, and I see that it is 30 or more minutes, I will change the speed of the video.
Select the gear on the bottom of a YouTube video and change the playback speed to a faster speed. My suggestion is watching at 1.5 speed.
On Day 3 of Google, we will take a look at Google Calendar. Perhaps some of these features can help streamline your workflow.
When organizing a meeting, you now have the ability as the owner to initiate meeting notes. What I like about this, is that the file is named the name of the calendar invite. It also automatically creates a space for attendees to add notes as well as action items (that can then be crossed off once completed).
If you forget to add meeting notes, you have the ability to edit your calendar event and add it after the fact. All attendees to the calendar invite have access to the file as well as editing access.
To add meeting notes, select the ‘create meeting notes’ button in the meeting description section.
On our first day, we will take a deeper dive into some features of Google Chrome. I must say for myself, there were several “I didn’t know you could do that moments” for me.
First thing we will talk about is your own settings in chrome. I think it is a great time to remind people about things that have been saved under your account. Some users save their passwords on websites that they use. It can be a risky thing to do. If you don’t remember what websites you have saved passwords for, or you no longer want to grant access to saved passwords, or you didn’t know you even save a password for a paricular tool/website…have no fear. You can see and make changes, by:
Selecting the three dots on top right corner of chrome
Select Autofill on left column
In a similar fashion, check to see if you have any saved payment methods. You might not want websites to have your saved credit card information or better yet, any saved financial data on your school google account.
HIGHLIGHT TEXT and SHARE
Did you know you can direct students to particular text on a webpage? This was a learning moment for me! Yes, you have the ability to draw attention to a certain part of a website for students so that they don’t get distracted. How to make this happen?
Highlight the section you want students to read or pay attention to
Select “copy link to highlight”
Then provide link to students
The gif below will walk you through the process.
HIGHLIGHT TEXT and SAVE IN GOOGLE KEEP
In a similar fashion, I have been seeing people talk about how they have students use Google Keep for note taking purposes. As students are doing research online with certain websites, they can highlight information that they want to keep. Once the text is highlighted, they can select the Google Keep chrome extension. Students will notice that the link is already added to the keep note, as well as the text that was highlighted. Students can add a title to the note, as well as type any other text they want to add. Students would then provide a tag to the note so that they can go back to all of the information they found useful in their research under that particular tag. Student would go to keep.google.com, search that tag they decided to use, to see all of their notes. Clever. In fact, very clever.
Below is a gif walking through the process of how to use the keep chrome extension.
It is that time of year to highlight some features of Google that are ‘Good to Know’ items. Look out for helpful tips starting next week. Hope you are able to have a couple of ‘aha moments’. (Hard to believe this is either my fourth or fifth time putting this together).