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.
V Planner V3 provides a one-year Transcript for each child. High School V Planner provides four One-year transcripts and one four-year Transcript.
Click here to see a full sized image of the one-year transcript annotated with reference numbers. The image will open in a new window so that you can reference the numbers while reading the descriptions below.
Refer to the full sized image or when available the images below when reading about the parts of the transcript.
The information in the header of the transcript comes from the Data worksheet.
TIP- If you did not fill in the personal information - address, date of birth, school name, parent name and phone number, then hide those rows before printing.
Classes will not appear until you select them from the drop-down lists in column C. Normally I would enter formulas in such a way that would make all of the classes appear automatically but that was not a good solution for V3 planners.
Why? Two reasons -
Because there is the potential of 16 classes and that you might overlook a class, I added all of the classes to the right side of the transcript in column K.
How it Works - Next to each class name is either a 0 or a 1. 1 indicates that the class has been selected.
0 indicates that the class has not been selected.
There are several mechanisms associated with displaying grade scales. Each one is designed for your convenience.
Column B is the GS Column. You may opt to hide the contents of the GS Column via the drop-down in cell K9 -Show or Hide GS Column- shown in image as 4a. The GS Column - Column B - Displays reference numbers that are set at the Tips worksheet - see image on right.
Select the grades scale(s) from the drop-down lists that are in cells K35, K36, K37. The grades scales do not have to be selected in any particular order, but it makes sense to display the most used grade scale first.
If you do not want to display a grade scale(s), then do that following
Attendance is automatically displayed but I included the option not to display attendance.
To hide attendance counts do the following
If your child has taken a standardized test and if you entered the score into the Data worksheet, then the score(s) will automatically be displayed in rows 30-33. You do not have to do anything to rows 30-33, but if there are not scores this area will be completely blank. It is safe to hide rows 30-33 if you choose to do so.
If you used the Records worksheet, then up to 7 extracurricular records and up to 13 awards for the child will automatically display in this area. If there are no records to display, then the rows in this area may be hidden.
As stated above up to 7 extracurricular records and up to 13 awards for the child will automatically display. To let you know if all items are being displayed, Rows 41 and 42 will tell you how many activities and awards that child has. If the child has more activities and awards than what is being displayed, then the extra items will have to be typed in beginning at the first open row, which is row 45. You may insert additional rows at row 45, however, you might have to unprotect the worksheet in order to insert rows. Please do not insert rows at any other location on the transcript.Click here to open the image in a new window
You may change the labels at cell K40 and at cell K43. This is pictured in the image at 7a and 7b.
Row 44 displays all of the awards in a comma separated string of text. Because the content is imported from Records, the row might not automatically expand to display all of the awards. If you believe the row is not displaying all of the child's awards, then make the row taller by either double-clicking the row boundary just under Row 44 or click on the boundary under row 44 and drag it lower. See also - XLS Tips - Changing the Row Height
If there are no awards or activities to display in this area, then Rows 38-44 may be hidden in the usual way. See - XLS Tips - Hide and Unhide and Moving
Lastly, please do not feel odd if your child has no awards or activities to display.
If your child is 12 years old and above, it is time or close to time to look into outside activities that will develop his or her followership and leadership skills.
If a class is a co-op class and you want to make a note of that on the transcript, you may do so with the features that are marked "8" on the image.
Column A, next to the class names is open for reference marks such as asterisks.
In Row 51, create a key for the reference marks that you placed in column A.
Row 50 - An awkwardly worded document summary will appear here when "End Date" is added at Data sheet in row #. The row for the end date varies for each child.
Note for future V3 edit - One would think that I would have just programmed in the last day of school based on the Days worksheet, but I didn't and that is one little thing that I hope to remember to change in a few months. So if your V3 has not end date for the student, that means that I did finally make the change.
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.