V Planner V3 - COS - Course of Study

Course of Study

Latest Version - V Planner V4.3

V Planner 4.2, High School V Planner V4.2, and Homeschool Lesson Planner V4 are ready for use. Download from the Member's area.

The Course of Study Worksheet displays the each child's grade, list of classes, which term the class is conducted, books for each class, and the list of extra books. See Tip below to find out how to display additional information for each child.

The Course of Study (COS) is easy enough to use. Simply fill in the information at the Data worksheet (see Setup Step One) and return to COS.

To use COS do the following:

1. Select the student's name from the list in cell A2. Information will fill in.
2. Adjust the row heights if they are not displaying everything.

Less important drop-down lists
1. A second drop down is in cell A3
2. Another drop down list is in cell A36

Printing - Check print preview before printing the COS
Rows that contain the class book titles are set to wrap, but it is likely that the rows will not automatically lengthen to display wrapped content. If content is not displaying fully, lengthen the the height of the rows.

Tip I

If you want to add more course of study related information about the child and if you are not using all 63 extra book slots at Data, then I recommend adding the related information about the child at Data in the first and following available empty extra book cells. When information about a child is added in this way, then the information is with the child's course of study record and will populate the Course of Study worksheet when the child's name is selected. This is much better than typing in the COS worksheet.

A Caveat: Cells containing the list of additional books do not wrap, nor are they merged. This is good for the list of additional books, usually, but not for a long string of text. S., if you would like to use the empty additional book cells to add Child-specific Course of Study related information, do so, but enter the text like this:

• Type in a string of text that you believe will occupy a page width,
• View COS and print preview to make sure the text is neither too long or too short.
• If the length of the text is okay,
• Press enter and
• Type another string of text of the correct length in the next cell,
• And continue in this way until finished.

Tip II

While Tip I is okay, it is not without its challenges. A second way to have personal information that does not have to be removed is to make a copy of COS, one for each child, and set the copies up to be for a certain child. Making copies of worksheets is very easy - read how here - V Planner- How and Why to Copy a Worksheet

After making copies for each child-

1. Optional-Rename the copied worksheets at the Tabs, not the original COS
2. Decide which Copied COS is for which child and set the name drop-down accordingly
3. Additional information for each child may be entered at row 100
4. When typing, pay attention to the width
5. TIP- To see where "page" margins are, open and then close print preview
6. If you need them, add more rows before you get to row 106. Row 106 is the last open row for typing.
7. TIP- Rows may be added to COS anywhere between rows 100 and 106

Donna Young
Updated

About the V-Planner

The V Planner is a spreadsheet file in xls and xlsx format. To use the file, you must have Microsoft Excel on your computer. The V Planner is available from YoungMinds web site. YoungMinds is online via a subscription and on Donna Young's Site-CD.