FTT - Google Sheets

Google Sheets: Not as scary as you think!

@LisaBerghoff/@MrKimDHS

Not gonna lie, when people come to see me about Google Sheets, or Excel, I have a quick tinge of panic as I try to remember some of the basic coding language needed to run Sheets. But I remember how simple it can all be with cheat sheets and practice! While spreadsheets can be intimidating, they are a powerful tool in working with aggregate data.

 Need to make sense of a large amount of data in sheets? Or organize your SLO data? These next few tips and tricks will part the veil of the mysterious and intimidating spreadsheet!

Freezing a Header Row

I hate having to constantly scroll back up to see which column's data I am looking at. Freeze your headers! If your first row has important qualifiers, lock it in place as you scroll by going to: 

• View - Freeze - 1 Row (same for columns)

Sorting by Ranges

So lets say you have the data of 50 students and you want to sort by last name. But the problem is, if you sort by their last names, the rest of the data doesn't match up! Create ranges that fix your data for each student:

• Highlight your data, then Data - Sort Range - "Data has header row" - "Sort by Last Name"

Creating Filters

Filters are a very powerful, yet simple way to make sense of your aggregate data. Use your data criteria to filter and sort through information:

• Highlight your data, then - Data - Create a filter 
• Filter symbols will appear above each column. Click to sort.

• Don't worry your filtered data still exists in the sheets! 

Simple Formulas

Formulas may be the most intimidating part of spreadsheets, but by learning the basics, you can eventually make your way to the pros. So lets say you have a set of assessment data you'd like to average:

• Highlight your numbers first
• Functions(summation button that looks like a backwards 3) - AVERAGE

• You can fill in the rest of your data by highlighting, and pressing Control/Command + D

Keyboard Shortcuts

My favorite time saving tools - while a shortcut may only save you half a second, using them day after week after month after year can really make your work more efficient. 

• Help - Keyboard Shortcuts (Control + /)

Here are some of my favorites (PC - blue, Mac - red, Both - purple):

• Shift + Space - highlights your row
• Control + Space - highlights your column
• Alt + A / Command + A - highlights all of your data
• Control + D / Command + D - Fills all boxes down
• Control + Shift + E / Command + Shift + E - Center align
• Control + Shift + R / Command + Shift + R - Right Align
• Control + Shift + L / Command + Shift + L - Left Align
• Control + K / Command + K - Insert Link
• Control + ; / Command + ; - Insert Date
• Control + Shift + ; / Command + Shift + ; - Insert Time

Do you have some spreadsheet tips to share? Comment below!

FTT - Schedule Email in Gmail

Schedule Send For Gmail Is Here!

@LisaBerghoff/@MrKimDHS

There has been a phenomena on YouTube for some time that I never understood. It's known as "unboxing". In case you don't know what I'm talking about here's the gist, you watch a video of someone opening a box that contains a new product. That's it. They spend some time talking about it at first, slowly building anticipation and then they close up on their hands opening the box as they are describing the box. You watch them take everything out of the box. 

People watch these videos. I never really understood why. 

Until now.

Well, not really but here's the connection. About a month ago, Google announced among other new features the ability to schedule gmail messages to be sent at a later date and time. This feature has been long needed, anticipated, and talked about. As Google rolled out this feature, those who received it first have been posting their own videos and gifs showing how it works. 

I will admit, I watched them.

But the wait is over! YOU now have the ability to compose a message and determine a date and time in the future to have that message automatically sent without the need for you to click send.

Here's how it works:

1. Open gmail and click compose

2. Enter the recipient in the To field, a subject, and the text of your message.

3. Click on the small triangle to the right of the Send button and click Schedule Send.

You will see several automatically created options. If you don't like those, you can click Pick A Date And Time and enter when you want your message to be sent. 

4. Click Schedule Send and walk away with the knowledge that your message will be sent when you wanted it to be sent. 

Why Would I Want To Use This?

There are many reasons why you would want to send an email at a time other than when you are composing it.  First, if you're like me, you forget things. My brain simply doesn't always have the bandwidth to remember everything that needs to get done. To-Do lists are great but sometimes I'm getting to my list at a time other than when a time-sensitive message should go out. Now, I can compose my message when I'm able to cross that item off my list and not when it needs to be sent. 

For example, think about messages to students. A message sent from a teacher to a student at 9:30 at night, when the teacher is working, lesson planning, grading etc., may imply to the student that a response is expected right away. You can avoid the awkward subtext of inappropriate timing by writing that email at 9:30pm but scheduling it to be sent the following morning during school hours. 

Often, email communication occurs between parents and teachers. Sometimes I don't want the parents of my students to know that I'm up at all hours of the night working. I have had some people comment on the odd times that my emails were delivered. I can't help it if I can't sleep and just need to get some things done so I can quiet my brain! Now, I can still write those emails but I can schedule them to be sent the following morning.

I like to send reminders prior to certain events or meetings. The event is set so I can easily predict when I want the reminder email to go out. Now, I can schedule those reminders without needing to set a reminder for myself to send them out!

What are some other uses for scheduling gmail?

Post in the comments below. 

FTT - Backchannels

Yo Teach! 

Backchannel Like You Mean It

@LisaBerghoff/@TheMrKim

After reading Most Likely To Succeed (Preparing Our Kids For The Innovation Era) a few years ago, I have a new understanding of our education system and how we got here. Once you see it, you can't unsee it. For example, the way classrooms are set up, the sequence of curricular options, even how our hallways are organized all come from an earlier era when compliance, quiet, and rote memory were priorities. Teachers wanted students to sit quietly in their seats, in rows, and absorb the information given to them so students could repeat it back on tests. There was no room for creative thinking, or critical problem solving, or collaboration. 

Today, I am amazed with our students as I walk through the halls of our schools. I love to listen in, look around, and ask kids what they are working on. 99% of the time, they are totally on  task. It may look like organized chaos, but our students are learning in new ways and  no longer expected to sit and be lectured to. 

If only there was a way for our students to have a structured conversation or ask questions without disrupting the flow of class. If only there was a way for shy students, or students lacking confidence, to get in on the class discussion without putting them in anxiety provoking positions. If only there was a way for our students who struggle with impulse control, who need to get their questions and comments out now, could do it without social embarrassment. If only a teacher could follow the discussion going on among most students, as opposed to just those few who raise their hands.

If Only...

For those of you scratching your heads right now, I'm about to introduce you (or re-introduce you) to the concept of a backchannel. There was a previous post on backchannels in February 2016 that includes a list of ways to use backchannels in the classroom as well as a guide to student backchanneling.  As our seasons change, so does technology and the 2 backchannel sites mentioned in that post are no longer in operation. I have 2 more new ones for you to try and if you weren't sold on it the first time around, I thought this would be a wonderful time to reintroduce the concept. 

A Backchannel is an alternate route for communication in your classroom. The  first time I experienced a backchannel I was at a conference. I was sitting in a very long session that was really quite good but I just couldn't stay focused. I started to think about opening my email when I saw the backchannel link posted on the presenter's slides and I decided to check it out. I was amazed to find that many other participants in the room were also on the backchannel. As I started to feel bad for the presenter I started to read the posts and saw that nearly all of the comments were on topic (it was baseball season so there might have been some score sharing). Participants were posting suggestions, ideas, questions, thoughts, and more. The presenter even had someone designated to monitor the backchannel and several times paused to respond to a question that was widely asked.

I have seen this happen in classrooms as well. From "fishbowl" conversations to group check-ins, to crowd-sourcing feedback, there is definitely a place for the backchannel in school. 

Another wonderful thing about backchannels is they are incredibly quick and easy to set up. Here are two that are currently on my list:

Yo Teach! 

This backchannel site is free, simple to use, and has some nice interactive features, including the ability to draw. In Yo Teach, you can set a password so only your students can enter. You can  also  set your "room" so that it is not searchable. All you have to do is click "make room", give it a name, and set the password. Then your students can enter using using a pin or the built in QR code. Students enter their name and the password and then they are in. 

Here is a 1 minute video showing how to get started on  their new interface.

Backchannel Chat

This backchannel is designed for teachers so it has a few more bells and whistles and allows teachers to do more moderating.  Backchannel chat has a few pricing options with the free version allowing for 30 concurrent students and a "fair use" policy on the number of rooms. In other words, if you go overboard they are going to politely ask you to pay. You can  also access a web transcript of your chat. The site also allows for embedding YouTube videos and Flickr images. Backchannel chat is also simple to set up and allow your students to access. All they need to do is type and hit send. You have the ability to remove any comments or give students view only access. 

Are  you using backchannels in your classes? Post in the comments below and tell us what you are using and how. Want some help or to see some examples? Let us know!

FTT - Video Conferencing via Google Meet (Hangouts)

Google Meet (Hangouts)

@TheMrKim/@LisaBerghoff

Considering the impressive list of things I miss about the '90s, I feel oddly nostalgic about online AOL chatrooms. I can still hear that weird, metallic sound of my 56k dialup modem connecting me to the early proto-form of the internet and chatting with all of my Counterstrike buddies. Anyway... the future is here and that future is Video Conferencing. With Facetime, SnapChat, and Instagram vying for digital turf, students are becoming more and more comfortable with online video communications. How can we build upon that comfort in our classes? Google Meet, the new face of Hangouts, can be a place where we can give instruction, and collaborate in real time. OK, so when would we use it?

Guest Speakers

Last year Hilary Quagliana invited the former US Ambassador to Sweden to her AP Government class, and through Hangouts, the ambassador was able to speak, show a slide deck and YouTube video, and have a Q&A. Your school's tech department is more than happy to help by supporting your event with speakers/mics/etc.

Snowmaggedon and the Polar Vortex

While I'm not saying we need to subject our students to a full day's worth of instruction by porting it online, we could meet our students online to field questions or verbally explain instructions. It was hard to offer this suggestion 5 years ago because not every student had access to the internet or a computer. Smartphones today have seemingly solved the issue of access. 

Review Sessions/Student Collaboration

Back when I was at an iPad district, I used an app called Talkboard to hold evening study sessions for students who couldn't meet after school due to sports or activities. I thoroughly enjoyed reviewing with students from the comfort of my own room (although I didn't have a wife, a baby, or two dogs then). Your students could also hold meets to collaborate on projects. 

So how does it work?

• First, go to meet.google.com where you'll be greeted by a very simplistic menu with two options. You can either start a brand new meeting or join one using a code.

• By starting a meeting you will be given the options to mute your mic and turn off your camera (you can switch these anytime). You are also given the "joining info" so others can join your meeting.

There are three ways for someone to join your meeting. 

• First, you can either copy the meeting URL, or give them the "Meeting Code" which is the string of letters at the end of the URL. In this case, it would be "oeo-muco-cfe." (hyphens aren't needed when typing your code)

• Second, individuals can call in through their cellphones by dialing the number, and entering the given PIN number (callers won't have the video option). 

• The last option requires the meeting to be scheduled via Google Calendar. Participants can join directly from their Calendar invite. 

During the Video Conference

Once you begin the meeting there are a few things to keep in mind

• You can easily mute your volume, as well as turn off your camera at the bottom of your video.

• You can also mute the volume of one of your participants by toggling their mic button at the top right corner.

• There is also an in-conference chat window.

Presenting Powerpoint/Slides or YouTube videos

Another cool option is to present a slide deck to everyone in your video conference and run through the slides in real time. Just click on the "present now" button and you will be given two options:

• Your Entire Screen: your video will mirror whatever is on your screen. You can do Powerpoints, Word Docs, or any other program.
• A Window: gives you the option to show a window for your browser. 

• You can stop sharing anytime by clicking on the "You are Presenting" button.

Why should the corporate world have all the fun? There is plenty of educational utility in Video Conferencing! Still need help? Watch this video for more information

FTT - Take A Virtual Field Trip With 360Cities!

Take A Virtual Field Trip With 360Cities!

@LisaBerghoff/@MrKimDHS

I was once at a workshop where the leader asked us to think about the ultimate learning experience. It was one of those moonshot thinking activities where money, time, and the other usual barriers were supposed to be removed and we were just supposed to think about what would be best for my students. I instantly wrote down that we would take a field trip almost every day. I thought about how much I have learned from traveling and how many of my students are visual thinkers and if they could just be there, they would learn so much more than just hearing me tell about it.

That was a fun exercise but not really steeped in reality. Many of our students are fortunate enough to get to travel, and we do live near one of the greatest cities in the world, but we still spend much of our time just talking about amazing places and things without getting to experience them. This is where the world of VR and 360 images comes in.

While some think that virtual reality is a fad, I'm here to say let's ride this wave and hope that it sticks because we have 360 images from all over the world that are at our fingertips for free. You may think that you need fancy VR goggles to experience 360 images and those goggles certainly enhance the experience but they are not completely necessary.

When I first discovered 360Cities, it was based on a recommendation from National Geographic. I figured if they approved this site, it has to be good. I decided to check it out and it did not disappoint.

There are so many practical uses for 360 images in the classroom and 360Cities is an incredible source for 360/VR content for educational use.  According to the 360Cities website, it is the largest collection of stunning, high resolution, interactive panoramic photos and 360 videos created by a network of thousands of the first panorama photographers and videographers from around the world. 

Step 1: Go to 360Cities and create a free account.

Step 2: Explore and find content.

There are 5 ways to find the panoramas you are looking for.

1. Search. You can enter many different parameters in the search bar. For instance, you can search for specific words, or search by people.

2. Map. Take a look at the 360 map and click on an image thumbnail to open the panorama.

3. Use the categories that are created, such as "editor's picks:

4. Gigapixels. They even have the world's largest panoramic photos!

5. License and download images.

Step 3: Share

Once you find the images that you will use, you can grab the sharing link so your students can experience it for themselves.

Once you see the level of engagement in your classroom, you will want your students to create their own 360 images. Interested? Contact me for more information. 

Are you using VR images in your class? Post in the comments below to let us know what you're doing!