User Tools

Site Tools


student:fitnessgram_export

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
student:fitnessgram_export [2022/03/03 16:32] apapestudent:fitnessgram_export [2022/03/03 21:55] apape
Line 1: Line 1:
 ======FitnessGram Export====== ======FitnessGram Export======
  
-===== (future release: Physical Fitness Assessment Initiative (PFAIExport) =====+<WRAP round intro> **NOTE**: In a future release, //Registration > FitnessGram Export// will be renamed //Registration > PFAI Export//.\\ 
 + 
 +This utility exports information as a PFAI Export, not as a FitnessGram Export.</WRAP>
  
  
 The extract file name is FG_Extract_SchoolYear_CampusID+.csv (e.g., FG_Extract_2019_001.csv).\\  \\   The extract file name is FG_Extract_SchoolYear_CampusID+.csv (e.g., FG_Extract_2019_001.csv).\\  \\  
-If the district is submitting a district-wide FitnessGram file, copy each campus extract into one file, and remove the campus ID from the name (e.g., FG_Extract_2019.csv). Save the exported document as a .csv file.+If the district is submitting a district-wide PFAI file, copy each campus extract into one file, and remove the campus ID from the name (e.g., FG_Extract_2019.csv). Save the exported document as a .csv file.
 \\   \\  
 ^ ^Column^Type^Max Length^Valid Values^Description^ ^ ^Column^Type^Max Length^Valid Values^Description^
Line 11: Line 13:
 |B|School Name*|Alphanumeric|75| |Name of school.| |B|School Name*|Alphanumeric|75| |Name of school.|
 |C|Test Date*|Alphanumeric| |Values may contain leading zeroes or not.\\ //Example: 3/1/2021 or 03/01/2021//| |C|Test Date*|Alphanumeric| |Values may contain leading zeroes or not.\\ //Example: 3/1/2021 or 03/01/2021//|
-|D|StudentGrade*|Alphanumeric|10|3-12|Single, alphanumeric characters for grade levels 3-9, or two digits for grade levels 10-12.\\ Leading zeros are acceptable (03 or 3) On columns Y - AD, the value of 0 or blank should be **Not Selected**.|+|D|StudentGrade*|Alphanumeric|10|3-12|Single, alphanumeric characters for grade levels 3-9, or two digits for grade levels 10-12.\\ Leading zeros are acceptable (03 or 3)|
 |E|StudentGender*|Alphanumeric|1|m, f, M, F| | |E|StudentGender*|Alphanumeric|1|m, f, M, F| |
 |F|Height|Numeric| | |Expressed in inches.| |F|Height|Numeric| | |Expressed in inches.|
Line 32: Line 34:
 |W|Shoulder Stretch-Left|Numeric| |1 or 2|1 = No; 2 = Yes| |W|Shoulder Stretch-Left|Numeric| |1 or 2|1 = No; 2 = Yes|
 |X|Shoulder Stretch-Right|Numeric| |1 or 2 |1 = No; 2 = Yes| |X|Shoulder Stretch-Right|Numeric| |1 or 2 |1 = No; 2 = Yes|
-|Y|IsHispanicLatino|Alphanumeric| |1, 0, or blank |1 = Yes; 0 or blank = No+|Y|IsHispanicLatino|Alphanumeric| |1, 0, or blank |1 = Yes; 0 or blank = Not Selected
-|Z|IsAmericanIndianAlaskaNative|Alphanumeric| | 1, 0, or blank|1 = Yes; 0 or blank = No+|Z|IsAmericanIndianAlaskaNative|Alphanumeric| | 1, 0, or blank|1 = Yes; 0 or blank = Not Selected
-|AA|IsAsian|Alphanumeric|  | 1, 0, or blank| 1 = Yes; 0 or blank = No+|AA|IsAsian|Alphanumeric|  | 1, 0, or blank| 1 = Yes; 0 or blank = Not Selected
-|AB|IsBlackAfricanAmerican|Alphanumeric| |1, 0, or blank |1 = Yes; 0 or blank = No +|AB|IsBlackAfricanAmerican|Alphanumeric| |1, 0, or blank |1 = Yes; 0 or blank = Not Selected
-|AC|IsNativeHawaiianOtherPacificIslander|Alphanumeric| | 1, 0, or blank|1 = Yes; 0 or blank = No +|AC|IsNativeHawaiianOtherPacificIslander|Alphanumeric| | 1, 0, or blank|1 = Yes; 0 or blank = Not Selected
-|AD|IsWhite|Alphanumeric|  |1, 0, or blank| 1 = Yes; 0 or blank = No|+|AD|IsWhite|Alphanumeric|  |1, 0, or blank|1 = Yes; 0 or blank = Not Selected|
  
  
student/fitnessgram_export.txt · Last modified: 2022/07/26 13:02 by apape