The code in the template looks for the 'Master List of I Can Statements.xlsx' workbook in:
C:\Users\'Username'\Documents\
where 'Username' is whatever account name you're using. You wouldn't have received an error-message with the same code in the previous documents because opening a document doesn't trigger the template's 'Document_New' macro.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul!
This is amazing! It works beautifully! What a time saver this will be!!!!
Thank you soooooooooooooooo much!

I have a few questions and a few tweaks, if possible.

Question: Network Location Issue
The template is working great at home, but when I try to use it at school, it can't find the workbook of I Can Statements. I think this is happening because our computers at school are on networked drives. What would I need to ask our Tech Coordinator for (a "path" of some kind, I'm guessing) to send you to make a second version of the template which will work at school? Or is that even doable?

Question: Sharing with Colleagues
How do I share this with colleagues - just email them the template and the workbook as attachments and have them put the workbook in their "Documents" folder? (Of course, at school they will have the same network path issue I'm having, above.)

Question: Changing Template
How do I make changes to the template if I want to? How do I get into it without creating a new document? This is my first time using templates.

Tweak: Number of Learning Target Lines
Would it be possible to have there be two lines of Learning Targets with a button or something to add additional lines of Learning Targets, as needed? (Some lessons have 1-2 targets, while others have many.)

Tweak: Number of Date & Grade Lines
Similar to above - some lessons are for one grade level, others are for up to 3 grade levels.... can way to just have one date and grade level line and then a button to add another line if needed?

Tweak: Progress Description After I Can
Currently, when the drop-down (or pop-up) window opens, the progress descriptor ("Intermediate Novice", etc.) is at the start of the line. Can we move that descriptor to after the I Can Statement? Not all of us ESE teachers use the same progress descriptors, so that could be confusing for some.

Re: Network Location Issue & Sharing with Colleagues
If the template & workbook can be stored in the same folder, you (or I) could change this line in the code:
StrWkBkNm = "C:\Users\" & Environ("Username") & "\Documents\Master List of I Can Statements.xlsx"
to:
StrWkBkNm = "ThisDocument.Path & "\Master List of I Can Statements.xlsx"

That will address any Network Location & Sharing issues. Simply send colleagues both, with advice to keep them in the same folder.

To edit the template, simply use File|Open, choose the 'All Word templates' file type, then navigate to where your template is stored and select it.

Re: Number of Learning Target Lines & Number of Date & Grade Lines
Perhaps you could attach a document showing what you mean.

Re: Progress Description After I Can
Yes, that's possible, but it seems to me there is a more fundamental issue to be addressed: the standardisation of Progress Descriptors. In any event, if you distribute the workbook and don't protect it, anyone can change the Progress Descriptions there.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

=============================================

Can I bother you to make that alteration so that the network issue goes away - so keeping both docs in one file will work?
Thank you.

Next, I've attached a new version of the lesson plan.

There are two cells - each with a green box with an arrow.
One at the end of the Date - Grade - Notes line.
The other at the end of the Gifted Domains - Gifted Standards line.

Is it possible to turn those two green cells into a "button" of some kind which, when clicked or selected, will create an additional row of cells beneath the existing row?

ideally, when making the lesson plan, I'll be able to click on the green arrow cell and another row will show up so I can select another Gifted Domain and Gifted Standard.

Is that possible?

Thanks,
dede

Attached Files

Lesson Plan MASTER TEMPLATE C.dotm (55.4 KB, 17 views)

Try the attached. Instead of trying to treat a graphic as a button - which would require a great deal more code - the user gets prompted to add a new row upon exiting the last 'Grade Level' or 'ObjectivesBox' content control in the table concerned - provided it's not showing the placeholder text.

Note: Because you have more content controls below whatever will be the final 'ObjectivesBox' content control, it was necessary to split that table in two. That shouldn't affect the functionality, however.

Attached Files

Lesson Plan Template.dotm (59.8 KB, 25 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you!!!!! That's super helpful!!! The pop-up to add another line is great!

After some conversation with my admin today.... there have been changes to the requirements for lesson plans... and some changes to the terminology being used. (For normal classrooms it isn't usually this convoluted... the challenge is when trying to make ESE classrooms like mine fit into the rigid system used by general ed classes.)

I've attached the (hopefully) last revision needed - shifting the names of our two existing drop-downs and adding a new column with a new drop-down in between the existing two, fed by a 2nd workbook. I've improved the original workbook so I included that too.

The names of the drop downs are: ProgramGoals, GiftedObjective, GiftedStandard

I tried going in and altering the code/program based on what I could figure out, but that didn't work. There is more finesse to it than I can pick up for studying the sample - although I certainly know more now than I did before!

Than you so, so much for your help.
This is going to be wonderful!!!!!

dede

Attached Files

	Lesson Plan Template Master D.dotm (53.0 KB, 30 views)
	Master List of I Can Statements.xlsx (20.7 KB, 40 views)
	Master List of Program Goals and Objectives.xlsx (15.6 KB, 42 views)

There seems to be some serious scope creep going on here...

Try the attached

Attached Files

Lesson Plan Template.dotm (63.3 KB, 23 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

If scope creep is what I think it is, you're so, so right.
That is the world of education anymore. They are creeping our scopes all over the place.
Thank YOU so so much for making this area of my daily task list much easier to manage!

There is only one thing I see that needs a tweak.

When "Research" is selected in the "ProgramGoal" list, there is no content generated in the "GiftedObjective" list. The res of the program goals do have content there, just not Research.


I have a question - what would the terms be to use to describe what it is you created for me? I've been using "a lesson plan template fed by prescribed lists from a spreadsheet". Is that accurate?
You've been using, what? Visual Basic and Macros? I don't know what those are, but if that's what you've been doing, they seem incredibly useful and I would like to seek out some training... but I need to know what to look for. :0)


If I may ask - why is it that you have provided me with a service and I have not paid you anything for your many efforts on my behalf? Are you maybe a Microsoft Angel? :0)

Thank you!!!!

Hi Deirdre,

The 'Research' problem was caused by the 'Master List of Program Goals and Objectives' workbook having a trailing space in the worksheet name (i.e. 'Research ' instead of 'Research'). Deleting that space will prevent the problem occurring; I've also modified the code to trim the worksheet names, which will likewise overcome it.

As for the name, I'd just call the template a 'Lesson Plan Template'. To be sure, it gets its data from two Excel workbooks, but that doesn't mean they need to be referred to in the naming. Those workbooks exist only to make maintenance at your end a bit easier; I could have hard-coded all their data in the template - but then it'd be a nightmare for anyone else to update.

All the coding is done in Visual Basic for Applications (VBA), a programming environment built into Office. In Office parlance, VBA and macros refer to the same thing; though most people refer to macros when talking about something they've created using the macro recorder. The code I've written for this project goes way beyond anything the macro recorder is capable of generating, though. If you want to see the code, simply open the template or create a document from it and press Alt-F11 to open the Visual Basic Editor.

Forums like this exist to help people develop solutions to their problems. Occasionally, though, people who support such forums go beyond that and develop complete solutions. You'll probably know the adage "Give a man a fish and he'll have a meal for a day. Teach a man to fish and he'll have meals for a lifetime". In this case, you've been given the fish, but it also helps me hone my VBA skills (all of which are self-taught). Enjoy.

Attached Files

Lesson Plan Template.dotm (62.6 KB, 96 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]