Google Drive as a Lesson Organizer


Doesn’t Summer just feel nice? I know for some of you, it’s way too hot. Where I am, it’s been a bit cooler than normal. But if you’re a teacher, there’s a good chance that Summer means you don’t have to go in to work every day. For a month or two. That’s a pretty darn good feeling.

But, of course, if you’re a teacher, you probably also have the itch to do something for your classroom. So while I’ve been reflooring my house, salvaging a flooded basement, and awaiting the birth of my first child (his due date is today, and as you can probably infer from the fact that I’m writing a blog post and not at the hospital, we’re still waiting on Baby Wyzlic), I’ve also been doing a lot for school. There’s one thing I’ve been working on in particular that maybe you find interesting/helpful as well: using Google Drive to organize my lessons.

I’m a big believer in using Google Drive for basically all things communication among staff members. Need to do athletic eligibility checks? Make a spreadsheet and share it. Have a roster of students who will be going on a field trip all day? Make a document and share it. Organizing a potluck? Make a spreadsheet or even a form and have everyone add their items to the list.

I love it so much, that my school has asked me to do a short PD on it in the fall so we can start to use it more as a staff. And while I was putting this together, I thought about how I might use this not with my students (I use Forms all the time with them already), but for myself as a teacher.

So I’ve created a spreadsheet for each class and I will be using it as my yearly lesson planner. Here’s what my first week of English 9 looks like:

First Week


I need this structure so I can keep track of the grammar, reading, writing, and speaking skills I’ve covered, as well as the standards we’ve hit. In the “Lesson Plan Outline” section, I’ve linked to the lesson I’ve created (I don’t have a lesson plan for every lesson, but I will try to have at least a basic outline created), also using Google Drive. Each of these is then nested in folders in my main Google Drive area.

This is no different than what many people do with a paper lesson planner, but I think it’s going to work really well for me. The main benefit is going to be CTRL+H. Many people are familiar with CTRL+F on a Word document or in most web browsers as being the “find” command. That works in Google Drive items as well, but is limited to searching through only the active sheet in a spreadsheet.

CTRL+H usually brings up your history in a web browser. But if you’re using a Google Spreadsheet, this happens:


It’s a find and replace! Not necessarily all that handy, until you look at the search options. Do you see it?


With this tool, I can easily search through my entire year’s worth of lessons and look for when we hit a given standard. “You’re saying I didn’t hit RL.9-10.7? Let me show you exactly when, where, and how I did.” Or if a student asks when we learned such-and-such a thing, instead of saying “oh, it was last Tuesday — wait, no, Wednesday — I think,” I can do a quick search, tell them the exact day, and also any other times we happened to touch on that (at least according to my plans).

This also makes for an easy way to make changes for the future, as Google tracks changes and can go into “comment” mode quite easily. For me, these are the things that have made curriculum mapping and unit planning difficult: having a place where it all exists together, and being able to make changes or suggestions for the future.

It’s possible this will blow up in my face. But I’m feeling pretty good about this.

It’s May Already?

After completing a more or less successful Slice of Life March (I missed a day at the beginning and a few at the end), I apparently took April off from blogging. Oops!

It’s that time of year, though. The snow has melted. The crocuses have bloomed. Spring break has come and gone. So now, it’s time for the break-neck sprint to mid-June and the end of the school year.

I’ve been at 4 different schools in my career, and each school has a different feel to it in May. However, there is one thing that is consistent: May is busy. Spring sports wrap up, so athletes are missing more and more school as tournaments abound. Seniors can see, smell, taste, and nearly touch the end of their high school career. Prom planning takes over at least one or two teachers’ lives and occasionally their classes. Honors nights are emphasized and de-emphasized. Graduation is planned, and it will happen.

Meanwhile, we need to not forget our focus: teaching our content. Even though it’s 75 degrees outside and 92 in our classrooms. Even though a promposal is happening between classes and all the students are atwitter (and a few even on Twitter). Even though even though even though.

Something I’ve found helps in these months: knowing what’s going on at the school, top-down. Is next week Tuesday a different schedule? Why? When do the students need to know? You don’t want to be the teacher without these answers. Also, keeping a solid bond between teachers and students. If the students trust you and your teaching, they’re much less likely to rebel in this last hectic month. You can actually get a full year of teaching in! And finally, keep a solid bond among teachers. This is not the time of year to cancel the Friday happy hour (or whatever you may do as a staff to keep connected). In fact, it’s even more important now as sometimes emotions and tempers can match the weather for increase in heat.

To teachers everywhere: good luck this month! You can do it!

Slice of Life: Multi-Lingual English Class

Slice of Life

My students know that I love Spanish. And many of them are taking Spanish, so there’s some solidarity there. But many others are taking French or Italian. So there’s a lot of good-natured teasing back and forth.

Something pretty cool has been happening lately, though. The French students have been doing what they can to pepper French into our class. They’ll greet me with a bonjour! or ask me ça va? when we pass in the hallways. Yesterday, we were writing haiku in class. One student called me over, a huge grin on his face. I knew something good or something funny was about to happen — either way, I was excited.

When I got to his desk, I looked at his haiku: completely in French. He looked up and asked me, with a smile, “What do you think?” I turned the tables on him, though, asking why he used the word for “funny” when he meant to use the word for “smart.” Our gentle teasing continued, while he was practicing his French.

A little background for this next snippet: teaching at a Catholic school, I start every class with prayer. Every day, I ask each of my classes if anyone would like to lead us. In every class but one, I’ve had volunteers throughout the year. One class, though: not a single person stepping up to lead. That’s fine; I would never force anyone to pray, I just ask that they join in if they’d like and be respectful if they’d rather not. But I ask every day anyway. I don’t want to deny someone the chance to do something just because I’m making an assumption that saves me 10 seconds of time. So today, I asked. And a hand went right up. I took my seat, and the student led us in prayer.

She chose the Our Father.

In Spanish.

The language battle continues :-)

Slice of Life: Getting Excited

Slice of Life

In two days, literacy professionals will descend on Grand Rapids, Michigan for the annual Michigan Reading Association Conference.

There are a lot of things I’m excited for:

  • Meeting up with my English teacher family
  • Finding new friends, those I’ve interacted with online and those I don’t even know exist at this moment
  • My first-ever solo presentation at a major conference
  • Friday night (so big, it gets a subsection)
    • I’m giving an Ignite talk as are several other Michigan educators. I’m a little nervous, but mostly excited.
    • There is a lip sync battle scheduled, and I just might be a part of it. I’ve picked some ridiculous songs. It’s going to be a lot of fun.
    • There will be plenty of Nerdy Book Club people around, and that makes this one of my favorite nights of the year
  • Grand Rapids: the city is just a wonderful place to be for a weekend

I can’t wait. Will you be there? Come to the Pure Michigan event Friday night! See you then!

Slice of Life: Skype, the Aftermath

Slice of Life

Today was the Skype day. Everything was set. We had questions prepared. We had a schedule set. We HAD SCHOOL, which was what foiled us the first two times.

Then I got to school. Our schedule had changed. The Skype times needed to be adjusted, too.

Of course.

Fortunately, we were able to be flexible, and our students finally got the chance to connect with some students in another classroom in another part of the country. Some questions worked, and some didn’t. Some students got stage fright, and some didn’t. It’s how it goes. But I was glad we connected. Just not without some hiccups, because that’s just how it goes. Thanks, Mrs. Minnich, for Skyping with us today!

Slice of Life: Skype!

Slice of Life

 As the school year has gone on, my friend Cindy and I have realized that since we both teach a bunch of freshmen and wouldn’t it be great if we had them Skype with each other? So we arranged a time. Our kids were excited.

And we had a snow day.

So we rescheduled. And our kids were excited.

And we had a cold day.

So we decided not to schedule. Bad things happen when we schedule it. So yesterday, Cindy approached me with an idea that we should Skype, as my students are beginning their poetry stuff, and her kids have good things to say about poetry. So we’re doing it! Tomorrow! It will happen.

::checks the weather forecast::

Yes! It will happen!

Slice of Life: A Chance to Breathe

Slice of Life

Today is a Sunday with not much planned. It’s been nice. I woke up, went to church, where the priest gave a nice homily on our duty to serve others, and then my wife and I went shopping. We’re just sort of lazing around now, getting a little cat nap in and some reading.

Which is good.

Because tomorrow, the 4th quarter begins.
This coming weekend is MRA.
The weekend after that begins spring break, and we’re taking our honeymoon trip (finally!).
Then the school year goes on full blast.
Then nErDcampMI is right around the corner.
And around the same time, our first born will be born.
Then there’s the rest of my life, being a parent.

So I’m grateful for today. And I’m sure every relaxing moment will be treasured four times as much as it ever was in just a few months from now.

Happy Sunday, everyone!