Skip to main content
Skip table of contents

Import and Export Fitness Tests and Scales

On this page:

Administrators can input and extract the fitness tests and scales needed by the district. These ensure that the tests and scales are accurate when calculating student results.

You must import the fitness tests and scales before an administrator can access any fitness-related pages, including the option to track fitness for a course.

The ability to import or export fitness tests and scales requires the necessary permissions to manage student fitness records.

    • View provides export access.
    • View/Modify provides import access to create new tests.
    • View/Modify/Delete provides access to import overrides for existing tests.

Import Fitness Tests and Fitness Scales

Before tests and scales can be defined to be used in tracking student fitness, the tests and scales must first be imported using Data Import Manager. The template for the Presidential Fitness Test found on the PowerSchool Community can be used to import custom fitness tests into PowerSchool SIS.

Three new code sets have been created to import fitness tests and scales.

  • Test Label allows you to add metadata to the type of fitness being measured by the test type or subsets.
  • Test Code allows you to set exception scores (for example, Non-Compliant or Medically Excused.)

  • Test Unit sets the types of measures used for the fitness tests.

    Test Units should be included as-in from the CodeSets import file.

Data Sets

The Test data set establishes the broad overall fitness test (for example, the Presidential Physical Fitness Test) while the Test Score data set establishes the test types within the test (for example, One Mile Run or Curl Ups).

If you are importing more than one test, be sure that your test types have differentiated names.

To link tests and scales together, an import code must be created for the data set being imported. For example, each data set in the table below has a corresponding import code.

Data Set

Name

Import Code

Test

Presidential Physical Fitness Test

PPFT09

Test Score

Curl- Ups

PPFT09CU

Fitness Scale Definition

Curl-Ups

PPFT09CU

Fitness Code

High Fitness Zone

PPFT09CUZ

Fitness Scale

Female Table

PPFT09CUF

Multiple tables can be created in the Fitness Scale data set. For example, when importing data sets for the Presidential Physical Fitness Test, you can create two tables for each test type, one for males and another for females. Alternately, these tables can be associated with multiple genders. For fitness scores to be calculated, all student genders need to be associated with a table for each fitness scale.

When importing scales that include time, the time measurements should be entered in milliseconds.

Data Set Upload Order

You must upload the data sets in the following order:

  1. CodeSets defines the new code sets necessary for Fitness Tracking to function.
  2. Test creates the overall fitness test.
  3. TestScore creates test types for the fitness test.
  4. TestLabel (optional) sets the metadata for the fitness area of the test type.
  5. FitnessScaleDefinition creates the name, test unit, and definition of each fitness scale.
  6. FitnessCode sets the scale items or scores for each fitness scale.
  7. FitnessScale creates different tables within the scale for use with genders.
  8. FitnessScaleGender assigns genders to the fitness scale tables.
  9. FitnessScaleItem sets the code assigned to a student for a result based on their age and assigned gender table.

Importing Data Sets

  1. From the main navigation, select System.
  2. Under Data Management, click Page and Data Management.
  3. Under Data Import, select Data Import Manager.
  4. Click Choose File and select the source file you want to import.
  5. Click Open.
  6. Choose the related fitness target from the Import Into drop-down list.
  7. Choose the Field Delimiter used in the source file.
  8. Click Next.
  9. Map the columns from your import file by choosing the corresponding PowerSchool Field from the drop-down list.
  10. Choose from the additional importing options, then click Import.

Export Fitness Tests and Fitness Scales

  1. From the main navigation, select System.
  2. Under Data Management, click Page and Data Management.
  3. Under Data Export, select Data Export Manager.
  4. Choose Fitness from the Category drop-down list.
  5. Choose a data set from the Export From drop-down list.
  6. Select the checkboxes for all fields to export.
  7. Click Next.
  8. Choose a Test Type.
  9. Click Next.
  10. Make any necessary changes to the Export Summary and Output Options.
  11. Click Export.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.