Two Ways To Beautify Your G Suite System

After binge listening to Google Teacher Tribe Podcast I thought it might be good for me to clean up all the tips and tutorials I have created to help teachers and students in the school I work at along with anyone who checks them out online.

I was pumped to see that I now have over 50+ tips and tried to organize them a bit better. It is not perfect, but something I working to make even nicer for the user(I need more time in my day!)

I thought I would share two tips I have to help beautify your Google Drive and Gmail. One is a new one and another is one I have shared before.

Enjoy!

If you have other tips and ideas please share so we can all learn together.

  1. Gmail Sender – this little tool adds icons to your email to help you visually find the emails you need faster!
  2. Add Emojis to Google Drive Folder – Want a better way to enhance the look of your Google Drive?Using http://www.copypastecharacter.com you can now copy an image and paste it into the name of a Google Folder to add emojis and symbols to your folder names. 
What do you think of this post?
  • Awesome (1)
  • Interesting (2)
  • Useful (0)
  • Boring (0)
  • Sucks (0)

Google Calendar: Using Appointment Slots to be Productive

This tip covers how to use the appointment slot feature in Google Calendar. It is time we start to use tools that help automate the communication and planning process.

This tutorial will help you create a calendar, develop the slots, share the calendar, and how to use it in various ways to be productive.

This is great for conferences, tutor sessions, making appointments with other teachers, etc.

How have you used it? Leave a comment.

If you like this video please subscribe to my YouTube channel.

What do you think of this post?
  • Awesome (0)
  • Interesting (0)
  • Useful (0)
  • Boring (0)
  • Sucks (0)

Google Chrome Tip: Picture in Picture

Netflix and Work at the Same Time!

This tip will make your life so much easier. Don’t you hate it when you only have one screen, but really need two? Have you ever needed to have two things going on at once to get a job done? Do you need to work on a document while watching a tutorial or movie? Do you need a screen in the corner while you are working?

This tip will walk you through how to set it all up quickly and easily so you can watch Netflix while working…..I mean have two vital pieces of work information up and going at once to be more productive.

If you like please give it a thumbs up and subscribe to the channel.

UPDATE – This tip works only works on Chrome OS(Chromebooks). The new Chrome updated 54 has disabled panel enabling. If you are Windows 10 machine or other platform this may not work anymore.

What do you think of this post?
  • Awesome (1)
  • Interesting (1)
  • Useful (2)
  • Boring (0)
  • Sucks (0)

How to Split screen on Mac, PC, and Chromebook

I have been asked several times how to split screen on multiple devices. There are several extensions, apps, and more that can help with this. However, I wanted to share how to easily do this task on all platforms with no extra tools.

I cover how to do so on a Mac, Chromebook, and PC.

What other shortcuts, tools, tips, etc. do you use to split screen or to make your productivity flow smoother and easier when you work?

Leave a comment and if you like please subscribe.

 

What do you think of this post?
  • Awesome (10)
  • Interesting (3)
  • Useful (8)
  • Boring (0)
  • Sucks (0)

Google Tip: Making the Most of Action Item Feature

Google recently announced some pretty cool updates on the horizon with Google G Suites.

One of these new features is the Action Item. While it is already working I think this is just going to be the tip of the iceberg of what is coming down the pipeline.

This video will showcase how it works and how educators and students can use this feature to be more productive in the classroom.

Let me know what you think and how you think it can help streamline the classroom.

What do you think of this post?
  • Awesome (2)
  • Interesting (0)
  • Useful (0)
  • Boring (0)
  • Sucks (0)

Google Sheets: Import Range Function To Share Data

In education there are times when we gather data into a sheet and need to share parts of the form out to others. How does one do that so that it populates automatically over time without copying and pasting time and time again?

Video

Warning: My goal is to take the questions people have about technology and provide solutions. This is just one solution. If you have other ideas or methods to solving the same issue, then please leave a comment or reach out so we can showcase the method. This is not the only method, but simply one that I use.

 

 

Steps

For those who don’t want to watch a video, here is a quick guide. To do this tutorial you need to have open

  1. Existing spreadsheet with the data you want to move to another Sheet
  2. The new Sheet you want to create

Step 1

Grab the key from the URL of the Google Doc you want to import.

screen-shot-2016-10-16-at-8-10-16-am

Step 2

Write down or take a mental note of the columns or range you want to import. You can import entire columns by entering something like Tab Title!A:F. Or, for a specific range, something like Tab Title!A6:F100.

Step 3

Go to your new Sheet that you are creating. Enter the following data in the Sheet where you want it to appear.

=IMPORTRANGE("1Nr7KSaqpkq52zRlPD0PybQ_AqKxh55jsY_LB-QWj-Mw","responses!D:F")

Make sure you swap out my key with your own as well as the range of data you want to copy over.

screen-shot-2016-10-16-at-8-24-12-am


Step 4

Format your data. You can do it by hand or use the Explore option to make it look nice. This is why choosing where to add the function is important.

 

Learn More

Check out the resources on my Google page on this website as well as my YouTube playlist of tips

Please be sure to leave a comment with other ways you sort data and any questions, tips, tricks, and ideas that you have.

What do you think of this post?
  • Awesome (1)
  • Interesting (0)
  • Useful (0)
  • Boring (0)
  • Sucks (0)

Google Drive Tip: Color Coding Folders in Drive

This tip is super short and super sweet. If you are like me, then your Google Drive continues to fill up with folders and documents over time.

Here is quick to get organized.

  1. Color code folders
  2. Star folders and filter by clicking Starred on the left hand side.

Let me know what you think.

What do you think of this post?
  • Awesome (1)
  • Interesting (1)
  • Useful (7)
  • Boring (0)
  • Sucks (2)

Autocrat Tutorial- Using Google Forms As A Rubric and More

A question was posed to me today. I love it when questions come my way where I don’t know the answer and am challenged to find the answer.

The challenge was that a few teachers wanted to use Google Forms as a rubric. They want to be able to quickly and efficiently score the work of a student using a Form and organize all their grading in one spreadsheet.

Easy and check.

They wanted to use the same spreadsheet for students to upload their self evaluations using the same Form.

Easy and check.

They also wanted to be able to take the scoring/feedback of each student from the spreadsheet and email the students their assessment in real time

WHOA!

Do what? Is that possible?

Today I am happy to report that indeed it is possible. It is amazing. It is efficient. It eliminates stacks of unnecessary papers and provides real time feedback that requires very little extra time on the teacher side of things.

What is this mystery? How do I harness the magic powers of all of this in which you speak?

Check out the video as I attempt to walk you through it. As always, I am super excited to see examples of how this plays out in real classrooms.

Even more important I plan to run PD and do live trainings to help those who need it. I really think this could be something big for teachers and students.

Go be awesome. Hi Ho!

What do you think of this post?
  • Awesome (5)
  • Interesting (0)
  • Useful (0)
  • Boring (0)
  • Sucks (0)

Gmail Tip: How To Unsend an Email

The tip this week is super simple, short, and easy. We have all had the moment where we have sent out an email and instantly wished we could take it back. Whatever your reason for wanting to bring your words back, there is a way to make it happen quick and easy.

As always please let me know what you think, tips, ideas, and questions. Each week I will share another tip to help make your life easier and more productive with the GaFE interface.

 

What do you think of this post?
  • Awesome (1)
  • Interesting (1)
  • Useful (4)
  • Boring (0)
  • Sucks (0)

Google Drive: 3 Tips To Provide Feedback Quickly

Here is your weekly Google tip.

This week we will take a look at Google Drive and uncover three way to provide feedback quickly to students. We all know that time is of the essence and as teachers continue to have larger class sizes, more students on their rosters and mix this with all the mandates of teaching we need to find shortcuts.

Every single second is precious in the life of a teacher. If we don’t find ways to be productive, then our balance of work and life suffer.

This video will cover three tips

  1. Master List of Comments created by BMS Staff(accessible to only BMS Teachers for the moment)
  2. Creating keyboard shortcuts for comments
  3. Suggesting mode of comments

 

 

What are other tips that you use to be more productive in giving feedback to students? If you want to join and crowdsource the Master List of Comments please use this document. It is open to everyone while the link above is for BMS staff.

These ideas were derived from Catlin Tucker as well as several other sites that have shared these tips in the past. I just made sure I could actually do the work and that I would actually use these tools which is why the video and such was created.

What do you think of this post?
  • Awesome (0)
  • Interesting (1)
  • Useful (0)
  • Boring (0)
  • Sucks (0)