The state of Illinois requires fitness data to be submitted to the state. For that purpose, the ISBE created an Excel Spreadsheet. To make this useful to G-Suite Districts, I have converted it to Google Sheets here: bit.ly/2N3y0eh

The spreadsheet automatically determines the age when you enter the test date in cell B2. (You do not have to manually enter the age as shown below with this new version.) It then calculates Healthy Fitness Zone (or not) for Aerobic Capacity (Pacer), Flexibility (Back Saver Sit and Reach), Muscular Endurance (Curl Up), Muscular Strength (90 Degree Push Up).

It, also, does cumulative counts for Males and Females, Healthy Fitness Zone and Needs Improvement, and Total Counts for each at the very bottom of the available data entry rows.