If you have already recorded student fitness testing scores in a spreadsheet, IHT Spirit provides an assessment template that can be used to prepare those scores for import.
The video demonstrates how to generate an IHT assessment template, enter previously recorded scores, and upload the completed file.
Important: Use the template generated by IHT Spirit. The video explains that other spreadsheet formats cannot be imported directly through this workflow.
Log in to IHTSpirit.com.
Click Assessments.
Select New Assessment.
Select the assessment type demonstrated in the video, FGPYFP.
Choose the fitness testing measures that match the scores you have already recorded.
Examples shown include height, weight, 20-meter PACER, sit-and-reach, push-ups, curl-ups, and trunk lift.
Choose the class or group associated with your existing scores.
Review the selected measures and class.
Make sure you have selected the correct students and assessment measures before downloading the template.
Instead of clicking Create Assessment, select Download Template.
IHT Spirit will download an Excel template based on the selected class and measures.
Open the downloaded file in Excel.
The downloaded template contains prefilled student information, including identifiers, along with columns for the selected fitness measures.
Open your original spreadsheet containing the recorded fitness scores.
Open the IHT assessment template.
Match each student's scores to the correct student in the IHT template.
Copy the scores into the corresponding measure columns.
Important:
Do not change the template's column headers.
Do not alter the prefilled student identifiers.
Make sure each score is entered for the correct student and measure.
Do not assume the row order in your original spreadsheet matches the IHT template.
After entering your assessment scores, save the completed file.
Keep the template structure unchanged.
Return to IHT Spirit.
Click Imports.
Select Choose File.
Locate the completed IHT assessment template.
Upload the file.
The video ends after demonstrating the file selection and upload process. It does not show the resulting import confirmation or any error messages.
After the upload, confirm that the expected student scores appear in the correct assessment.
If the upload fails or the scores do not appear as expected, contact IHT Customer Success before attempting repeated imports.
The demonstrated workflow requires the IHT-generated assessment template.
If your existing spreadsheet uses different columns or formatting, transfer the scores into the IHT template before uploading.
No.
Student roster import adds or updates student and class information.
Assessment score import uploads recorded fitness testing results for students already associated with the selected class.
How to Import Fitness Assessment Scores Using an Excel Template
If you couldn't find the answers you're looking for, please submit a support request here.
Select your state and the type of assistance you need so we can direct your request to the appropriate support specialist.