Google provides a great shortcut to create a Doc, Sheet, Slides, Calendar Event, etc super fast using the .new feature.
Create a New Google File Super Fast
Reply
Category Archives: Tutorial Videos
Multiple Copies of a Google Doc, Sheet, Slides
Ever have a time where you needed to make quite a few copies of a Google Doc, Sheet, or Slides file? Right clicking and “Make a copy” is nice, but not when you need a lot of copies of a file. Follow the video below to learn the steps in making multiple copies using a provided script. Don’t let the nerdy-ness of it scare you off. It really is a copy and paste process.
Making Appointments Slots in Google Calendar
Trying to schedule times to work with students either on the phone, face to face, or in Zoom, it can be tough making things fit everyone’s schedule. Google has always offered the option to use appointment scheduling in your Calendar, but the look has changed somewhat since I introduced it in 2015. Below is an updated video from Richard Byrne showing the steps. Worth the few minutes to watch to help with this year’s planning.
Using Google Drive Offline
It’s been a few years since I posted the steps on how to setup student Chromebooks to utilize Google Drive offline without the Internet. Below is a video that shows the steps with the latest menu updates from Google.
Revision History in Google
Doing collaborative work in Google is simple and very efficient. Say you are working with colleagues building PBL units or common planning documents and someone remembers they deleted a big section two days ago that they really wish was still there. Or, you are just monitoring Documents/Slides/Sheets being built collaboratively between students and one student says they have been adding content but somehow it is magically disappearing. Besides, it is great to know who is doing what work. What do you do? You use Revision History to see the living history of that item. This great video below will walk you through how it works and advanced options.
Budget Lesson in Google Sheets
Do you have a unit or lesson where students have to present a budget? They should give Google Sheets a try for that process. This short video gives you an idea as to how easy it is and what options they have with the data.
Undo Send in Email
Have you ever hit the Send button on an email just to realize that you either misspelled something or forgot to mention something else? Well, you can add a nice little feature in your email that lets you Undo the Send if you choose to within 10 seconds. Here’s another short video from the Google Gooru on how to do just that.
Keeping Students Informed
We all know the feeling. The students show up to class, you tell them to put away everything but a pencil because it’s test time, and they groan and announce they knew nothing about the test. Right.
Your students have Google accounts. Why not add those major events to your Google Calendar and “invite” the students. This gives you two more points of documentation of the event: it sends them an email telling them it’s been added, and it adds it to their school Google Calendar. Add to the fact it’s probably on your blog in lesson plans and has been announced repeatedly in class, and you’ve covered more ground than anyone would expect.
If you create Groups in your mail Contact list ahead of time (learn how HERE), this process is made even more simple than it already is. You’d just type the name of the Group and the entire list is populated automatically.
Let the Google Gooru walk you through how easy it is to keep your students informed of major events using Google Calendar.
Common Planning Time Assistance
There always seems to be the need to meet with your team, and you end up standing in the hall between classes trying to find who is available when. Well, let Google Calendar do the work for you with the Find Available Time option. If your team keeps their calendars up to date, this will save you loads of time. Let the Google Gooru walk you through the steps.
Creating Appointment Slots on Your Google Calendar
This is a great, short tutorial from the Google Gooru on creating appointment time slots on your Google Calendar. Keep in mind, you have to be in either Week or Day view so you can select the time slots you want in order for Appointments option to be available. Also, Those picking slots have to have Google accounts themselves since it will automatically collect their name for you.
This would be excellent for any number of classroom or school based functions:
- reserving a time slot for writer’s conference with teacher
- reserving device cart
- reserving computer lab
- reserving ThinkLab (our innovative learning space)
- tutoring or extra help
- PBL presentation sign-up
- and more!