Organizing Long Range Plans

I’m a big picture person. I need to visualize where my students are going to be academically in the next 5 weeks in order to understand the way in which I need to teach them right now. That part of my personality is why I am OBSESSED with Long Range Plans. Keep reading to see how you can get started on organizing them for you and your team!

Slide1

 

Do you ever find yourself in a meeting with your team asking, “What did we do this time last year?” “When will we hit that standard?” “Did we do word problems before we did subtraction?” Ask no more, fam!

With this Long Range Plan document, you’ll be able to organize all of your standards, themes, and events in ONE location.

Screen Shot 2017-06-01 at 12.35.21 PM

Here’s how we do it:

Go ahead and download your copy of my Long Range Plan template. I’ll wait while you get yourself settled. 🙂 (NOTE: this link will prompt you to make a copy. Select YES so that it can automatically save to your drive and the template will remain untouched for future teacher use.)

Let’s get this template formatted the way you want it! 

Deleting columns

  • Click the letter above the column you do not want. For example, if you do not want the Unit column, you would click the letter B above the word Unit. This will highlight the entire column in blue.
  • For PC users, right click. For Mac users, two finger click on the letter. It will give you a drop down menu where you can select “Delete column.”
  • This will shift all other columns to the left without messing up your formatting.

Inserting Columns

  • Click the letter above the column you want to add a column next to.  For example, if you want to add a column next to Math, click the letter I. This will highlight the entire column in blue.
  • For PC users, right click. For Mac users, two finger click on the letter. It will give you a drop down menu where you can select “Insert 1 right” or “Insert 1 left.” Select one of these options based on whether you would like the new column to appear on the right or left of your selected column.

Renaming Columns

  • Select the column you would like to rename. Rather than clicking the letter like we did before, this time you will click on the word. For example, if I do not want to use the term “Comprehension,” I would just click the word “Comprehension.”
  • Type your new label in that column.
  • Note: This can also be an option for moving around the order in which each column is listed.

Now is the fun part!

Simply grab your unit plans or any lesson plans you have used in the past. Beginning with the first week, simply start plugging in your skills and standards!

Helpful Tips

  • Merge cells if you teach the same standard for more than one week in a row. Do this by selecting both cells (Click one, hold down shift, click the next one) that you want the standard to appear inside. Select “Merge cells” in the tool menu above the spreadsheet (See the picture below).

Screen Shot 2017-06-01 at 1.00.20 PM.png

  • Some weeks are only 2 days and you might not want to include them as a week of instruction. We signified that these did not count as “weeks” by removing the number and filling the Week # with a color instead. Here’s how: Click the number of the week. Hit backspace (don’t delete the cell!) Click the paint bucket in the tool bar and select the color you would like to fill the cell with.

Screen Shot 2017-06-01 at 1.02.57 PM.png

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s