Forms Data Collection...Reverse The Order

I am not a fan of Google forms collecting data by putting the newest entries at the bottom. I often reuse forms with my students (I have some that I’ve been using since 2012) and can’t stand having to scroll to row 750 to find today’s entries. However, if you create a second tab in the spreadsheet and plop a simple formula in cell A2...all can be fixed. The formula pulls from the original data entry tab. So, if you make sure that tab is named “ENTRY”, just use the following formula in cell A2 of the new tab and you’ll be good to go: =SORT(ENTRY!A2:H,1,FALSE)

The only thing you’ll really need to pay attention to are the items in red. 1. “ENTRY” needs to match up with the exact name of the original data collection tab. 2. “A2” is in fact the top left cell from which you want to start pulling data.  3. “H” is the furthest right column from which you want to pull data. Don’t put a number after “H” so that it will continue to pull data ALL THE WAY down column H, even as new entries come in.

Should I Stay or Should I Go?

By 35 years old, I’d had 3 close friends take their own lives. Whatever their struggles were, they felt that they were not equipped enough to go on...so they stopped. I was so angry at all three funerals. At each one, I couldn’t pinpoint my anger. There were moments where I was angry with them, moments where I was angry with other people, moments where I was angry with myself, and moments where I was angry at the dirt on the ground and clouds in the sky. I knew the direction of my anger was off about all of them. Finally, it clicked… I was angry about our culture’s lack of education and support for how to deal with struggles. So, instead of just being angry, I decided to do something about it with a twitter account and recently a TEDx Talk.

We do so much to set kids up for success, to help kids avoid failure, to build confidence through wins. We ask kids… “What would you do if you knew you could not fail?” The intentions there are SO good, but the results are SO lacking. They ignore the reality that no matter how we protect our kids, they ARE going to fail, struggle, and become frustrated...A lot!  We need to put more effort into preparing kids to deal with the failure WHEN it happens, how to #GetUp from the struggles WHEN they occur, how to bounce back from the disappointments WHEN they set in.

What better time for us American adults to take advantage of the here and now, than now?!?!

This election process did not yield the result I wanted. I won’t go any further, politically, than that. There is an abundance of disappointment across this nation. Our kids are living it and watching it… but they’re also watching us! They are watching their parents, their teachers, their bosses, their coaches, their aunts and uncles and grandparents.

Over the last weeks, I heard so many adults, famous and less than famous, pre-emptively claim that they would be moving to another country if their candidate doesn’t win. And now I’m hearing so many pronounce the same declaration, reactively.

WHAT?!?!

This! Now! Here! Today! In our homes and schools and gyms and places of worship! This is our chance to show kids how to properly react to disappointment, losing, failing, and frustration. It’s NOT time to take our ball and go home. It’s time to BE AMERICA. We are NOT a nation of quitters! We dig down, play on the team that was picked for us, and make it as successful of a season as we can make it. If we don’t like a team-mate or our coach or our captain...we don’t HAVE to. But we do need to stop complaining, put our big boy shoes on, lace ‘em up, and play ball WITH them!

This “moving to another country” stuff is insane… joking or not, It’s for the quitter mindset. If we want to move to another country because we want to live in better weather, or experience a different culture, or be closer to family... Awesome!! But leaving this incredible nation (for sure we have faults) because we don’t like our new boss? Grow the… well, we need to grow up!

So, adults...parents, teachers, grandparents, aunts, uncles, bosses, coaches...here we go! This is such an incredible opportunity, right now!! #GetUp and grab your boots & overalls and strap ‘em up! Please...I beg, let’s model for our kids HOW to #GetUp from this and keep moving forward. Let’s dig and grind and forge on with each other so our kids and future can learn how to make the most of challenging scenarios.

Let’s do this, now, PLEASE?!?!

Casting Student Screens to Projector

A recent update to our Chrome browser now allows us to smoothly, with a small amount of setup work, fling student Chromebook screens (or any device running the Chrome browser) to the teacher computer.  Assuming this teacher computer is connected to the projector, this means you can project a student screen to the class with this cool tool! Just check out the video for a quick look at how it works and then dig in. It plays VERY nicely with Google Classroom. So...if you have students set up in your classroom, you can connect them all with one click. Good luck and happy casting!

Project Management Pace Tracking

Managing productivity and pacing when working on long term projects is difficult. As teachers, it’s our responsibility to provide our students with tools and skills to do this successfully. The tool I use with my students, google spreadsheets, is nothing that’s earth shattering. I used the spreadsheet to help my students create a system / map for them to follow while working on long term projects. I not only talk to them about goal setting and pacing, but also accountability for their time. We discuss the business world, especially consulting, and the need to document and bill for time. This tool has proven to be successful in helping keep students on pace, prevent them from becoming overwhelmed, and give them real time feedback on how effectively they use their time to be productive. Feel free to make a copy (from the link above) and use it for yourself and your students.