Class Roster - Version 2

1.  Open YOUR Class Roster File 
2.  Rename your Sheet 1 tab to Version 1.
3.  Right Click the Version 1 tab and select Move/Copy

4.  In the Move/Copy box make the following changes.
Before Sheet: Version 1
Put a check mark in the "Create a copy" box

5.  Rick click the new tab and rename to Version 2. 
6.  
PERIOD 1:  OPEN THE FILE "CLASSNAMESP1" from the Shared Drive - Versteeg - Computer App folder.  Click on the tab for period 2 info.
PERIOD 2:  OPEN THE FILE "CLASSNAMESP2" from the Shared Drive - Versteeg - Computer App folder.  Click on the tab for period 1 info.

Male Side of Spreadsheet:
7.  Copy the Male information from the class that is NOT yours:  Last Name, First Name, and Birthdate and place in your document under the last name of the student in your class.  ADD BLANK ROWS TO YOUR SPREADSHEET BEFORE PASTING THE INFORMATION.  You don't want to erase any information that you currently have on the spreadsheet.
8.  Calculate the ages for the new male students and format to match.
9.  Resort the males to include the new male students. (Age - ascending order)
10.  Update the conditional format to include the new male students. (Age older than 15.49 - yellow with bold font)
11.  Update the formulas for Number of Students, Average Age, Oldest Age, and Youngest Age.
12. Format dates to all be the same.

Female Side of the Spreadsheet
13.  Copy the female information:  Last Name, First Name, and Birthdate and place in your document under the last name of the student in your class.  ADD BLANK ROWS TO YOUR SPREADSHEET BEFORE PASTING THE INFORMATION.  You don't want to erase any information that you currently have on the spreadsheet.
14.  Calculate the ages for the new female students and format to match.
15.  Resort the females to include the new female students. (Age - descending order)
16. Update the conditional format to include the new female students. (Age older than 15.49 - yellow with bold font)
17.  Update the formulas for Number of Students, Average Age, Oldest Age, and Youngest Age.

 NO CHARTS