Records is one serious looking worksheet and it asks a lot of you. First you have to put something over there and then you have to pick it up over here; this worksheet has rules. But then it does almost magical things for you if you follow its measly little rules.
Note- the records worksheet at the High School V Planner is slightly different.
With the Records worksheet you can –
- Enter your children’s extracurricular activities and the time spent at said activities
- Enter your children’s notable awards
And then these records are analyzed and calculated by some clever formulating by yours truly and the results are transported to the Transcripts. But the catch is — you have to type the records into the Records worksheet and you have to do it correctly. Don’t let me scare you; it’s not hard.
How to Enter the Extracurricular Records
You will find a brief How-To at the Records worksheet but, in case you need the expanded version, here is how it’s done.
Activity List in Column A – Type the activity name ONLY ONCE. It does not matter how many different children will do the same activity.
Column E or G (highschool planner)
Select Activity From Drop-Down List – Do NOT alter the name of the activity
Now for the Step by Step
..and don’t forget those two rules..
- The Activity List in Column A – The First time a certain activity is done, enter the Activity name in column A.
Note – If the same activity “name” is already entered, do not enter it again.
- Enter The Record – To enter a record of an activity do the following steps in the next empty row:
- Column C – Select the student’s name from the list
- Column D- Type or Select the date of the activity
- Column E – Select the activity from the list – (do not alter the name of the activity; do not type in column E)
- Column F – Enter the number of Minutes (not hours, but minutes please). I’ve supplied a calculator so there’s no excuses.
- Column G – Optional! A comment may be entered – The comments are not sent to any documents in this planner. The comments merely allow you to keep a more detailed record in case you need to do so.
That is how to enter a record.
Columns J-M near the top of the worksheet will display the results of the individual record entries. You will do nothing there, but you may look at it.
Where and How to Enter Records of Awards
To enter an award, achievement, or other type of well earned recognition, scroll down to row 57.
- Enter the award name in column I
- Staying in the same row, “pin” the award on a child by selecting Y (for yes) under the child’s name.
That is all.
Please note that, in the example image, both Fred and George are spelling bee champions. This is to show that pinning an award to more than one child is possible.
Comments from Donna
Please read my comments that are on the Records worksheet; they start at row 61 in column A.
Up to 20 extracurricular activity records and 14 awards for each student will be automagically transported to the transcripts. Pictured below