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 (8)
  • 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)

Google Tip: Using Google Books and Docs/Forms for Quality Assessments

Here is your weekly tip using Google. In this episode I will explain how we use Google Book, Google Docs and/or Forms to create a high quality common formative assessment for the following standard

Determine the meaning of words and phrases as they are used in a text, including vocabulary describing political, social, or economic aspects of history/social science.

Let me know what you think. Leave a comment here or on my Youtube channel

What do you do? Share with the world.

What do you think of this post?
  • Awesome (0)
  • 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 (2)
  • 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)

5 ways to prevent students from sharing a Google Quiz?

I was asked this great question by a fellow friend and educator last week about how to help another teacher eliminate students from sharing Google Quizzes. Students were sharing the quizzes to their friends ahead of class so they could prepare and see the questions.

For example, I give a quiz period 1.  A student could copy the link and share to friends in a later period to prepare. Is there a way to prevent this?

At the time I was not sure what the answer was to this question. I was fascinated. How can we trump students who try to defy the system?

I should have known better. By now I should know that this constant tension is something all educators face. However, I had to stop and think more deeply:

Is this question more about learning environments and control disguised as a tech question?

Now, before you answer I want you to know that I address both topics. The video will discuss some things to ponder about why this is a problem in the first place AND then I deal with the reality that this is indeed an issue no matter how great our classrooms are organized.  There will always be that one kid who pushes the envelope. I share 5 ways in which you can minimize students cheating/sharing quizzes online.

  1. Colorful Theme
  2. Shuffle answer order
  3. Shuffle question order
  4. Data validation
  5. Turn quiz on/off

I cannot wait to hear other tips and strategies as well as future conversation about this topic as a whole.

 

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

Google Classroom: The Mobile App Draw Tool

Here is another tip/tutorial to get your week off and running with GaFE and Google Classroom. Each week I share a tip for teachers in our building as we move to a 1:1 Chromebook environment this year.

This tip focuses the app for Google Classroom. One of the great features of the app is that students are able to draw, highlight, and add text to any assignment from their phone or tablet.

This ability allows students to read and highlight work, make notes, and do what is necessary while allowing them to use their devices as they already use them….with a swipe or tap of their finger.

Check out the video in which I showcase how it can be used for a formative assessment. As always, I welcome any and all feedback along with other things you would like to know.

Here is the support page from Google on this feature

 

If you missed the other previous tips this school year you can check them out here:

Google Classroom: Sort Stream With Topics 

Google Classroom: Guardian Notification is Here! 

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

Google Classroom: Sort Stream With Topics

The latest batch of updates from Google is so great. I previously provided a walkthrough about the update to add parents and guardians to the Classroom and today I must share the next great update.

Adding topics to posts in the Classroom.

So what this means is that we can now organize our assignments and posts by topic. What this will create is a column on the left side that students can click a topic and all posts will appear. Think about this for a minute. You can now sort by unit, standard, project, chapter, etc. Whatever works for you as a teacher can now be done.

No more strolling for days to find that one post from a month ago!

Check it out and let us know how this can help your classroom organization.

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