If your school uses Google Calendar for keeping track of meetings and room availability? To limit the number of emails back and forth of “are you available” and “I am not then, try this time,” Google Calendar has created the ‘Find a Time’ feature.
Go into creating an event and invite some of your colleagues using the ‘Add guests’ menu on the right-hand side.
Once you have added people now you can select the “Find a Time” and begin to find a time that works the best for all guests invited. *If you do not see the calendar of your guests, they do have to ‘share’ it with you.
To pick the time, just click on the calendar shown and it will highlight the time where you can see what everyone is doing then.
Every year, Google produces their year in search. This year I found personally powerful with all of the events that happened.
Check out the Google Trends, Year in Search video here.
More than just the powerful video, check out this great list of breakout searches, by month, for the year 2016.
Specific to Canada (though you can change the location with the dropdown menu), here are the top searches by category.
If you are bringing this into your classroom, when you click on the top searches, you will get be sent to that searches Google Trends graph which will showcase how popular that search was over a specified time period.
Here are some great prompting questions:
When was this search most popular and how do you know this?
What was happening in Canada, at that time, to increase the number of searches?
If we looked outside of Canada, do you think we would see this as a top search? Justify your answer.
What is the overall trend of this search? What does this tell you about Canadian culture?
Coming from a Microsoft Office world, I always thought of Google Slides as a Slide Deck. A place to make slides and add in cool transitions to wow my audience.
It was not until Michelle Armstrong, Regional Director of EdTechTeam Canada, showed me that you can edit the size of a slide and really change it into a working document where you have no limitations on where you can add in images, write, and create.
When you have Google Slides open, go to File -> Page Set-Up.
This will allow you to then choose “Custom” and enter in the size of slide you would like to have.
You can have your standard piece of paper – 8.5 x 11 inches, or experiment to make the size that best works for your creation.
Now your favourite GSuite Tool has just turned into the most powerful tool you and your students have access to!
Using Google Chrome, follow the link above to add this extension to Chrome. Once added, click on the eye dropper icon. This will open up the eye dropper menu:
From here you can either select “Eye Dropper” or “Color Picker”. Colour Picker is similar to your regular colour wheel to select the colour of your choice.
The real magic, in my opinion, is in the “Eye Dropper” menu. When selected, you now have a button that says “Pick colour from web page.” If you click on that button you will notice that your cursor is now has a little box that shows the colour it is hovering over.
Find the colour you want to use and click on it. Now the boxes in the Eye Dropper menu will change to that colour. From here, you can pull the code you need for the tool you are using.
If we wanted to add the purple colour I have selected in the screen shot to a Google Drawing shape, we need to click on “custom” in the colour selection menu.
Once custom is selected, you can then change the letters/numbers after the “#” to the ones that match from the Eye Dropper menu.
Selecting “OK” will change the selected items to that colour! Say hello to beautifully coloured digital work!
Data drives our world. We use it to identify interventions for students, we use it to provide feedback to our teaching methods, we use it to make assumptions or to start inquiring about a topic.
Google Sheets allows us to view large amounts of data at once all while collaborating with as many people as we would like.
Take this Google Sheet for example. We have multiple columns which can be sorted. If we wanted to, we could sort the “Class Level” column in order.
When you do this though, you will notice that the entire sheet shifts rows to match your recent sort. Super handy if you are the only one looking at the data, but frustrating for everyone else in the Google Sheet as you have just changed their view too!
Filter Views in Google Sheets solves this problem. Each person can select their own Filter View which will ONLY change their view, not the entire spreadsheet.
You can find filter views under the martini glass, , in the top menu. Clicking on the small triangle beside it, you can then select to “Create a New Filter View.”
When you have selected a filter view, you will notice that the row and column headers are now black. This is your indication that you are in the filter view.
From here, you can name your filter view to save it for next time. So if I wanted to create a filter view that sorts the Class Level and a new filter view that sorts the major, I could do that. Now that information is easily accessible to me and all who use the Google Sheet without changing everyone’s view!