IL FitnessGram Report
Regulatory > Physical Fitness Assessment > IL FitnessGram
Use this option to create an Excel file with class lists for a building's physical fitness courses which you can import into the FitnessGram software. The class lists are organized by course-section. Course-sections are included in processing based on the IL FitnessGram course district-defined page, and its Include in FitnessGram setting. Refer to IL FitnessGram for information on course setup.
Course-section FitnessGram spreadsheet records include the following information:
- Linking students with teachers and courses.
- FitnessGram login IDs and passwords for students and staff.
- Student and staff demographic information.
Prerequisites
Make sure you set up the appropriate courses' IL FitnessGram page with the Include in FitnessGram box checked. This setting is available at the District Course Catalog, Building Course Catalog, and Course Section levels. Refer to the IL FitnessGram course district-defined page section for information on how the report option refers to these levels when determining the course-sections to process.
Procedure
To generate an Excel file with records you can import into the FitnessGram software:
- Select Regulatory > Physical Fitness Assessment > IL FitnessGram.
- Enter your report prompt selections referring to the Fields section for more information.
- Use the Filter panel to limit the course-sections to process. You may also filter based on student demographic information.
- Click Run
- In the Tasks/Reports > Recent Reports menu, open the IL_FitnessGram spreadsheet file to see the results.
- Repeat Steps 2 - 5 until you are satisfied with the results.
- Import student and staff information from the Excel file using the FitnessGram application.
When you are ready to import in FitnessGram, you can use Settings > District/Schools to access the option Do Not Update Username and Password on Import. Select this box if the import should not overwrite existing login credentials based on the spreadsheet you are currently loading.
| Fields | Description |
|---|---|
| School Year | Select the school year the FitnessGram option will use when choosing Master Schedule course-sections to process. |
| Building List | Choose which buildings the FitnessGram option should use when choosing the Master Schedule course-sections to process. |
| As of Date | Select the calendar date the FitnessGram option uses to determine if each student is active in the processed course-section and enrolled in the reported building. |
| Log File Type | Select whether the error log should generate as a PDF or CSV file. |
IL FitnessGram Mapping
Field Name | Field Length | Database Table and Field | Notes |
|---|---|---|---|
School ID | 50 | reg_building.state_code_equiv for the student's reg_entry_with.building |
|
Student ID | 50 | reg_personal.state_report_id |
|
Student First Name | 35 | reg.first_name |
|
Student Last Name | 35 | reg.last_name |
|
Student Middle Initial | 35 | reg.middle_name |
|
Student Nick Name | 35 | reg.nickname |
|
Student Birthdate | 10 | reg.birthdate | MM/DD/YYYY |
Student Grade | 2 | reg_grade.state_code_equiv for the student's reg_entry_with.grade | K - 12. For grades 1 - 9, use a single digit. |
Student Gender | 1 | reg.gender | m, f, M, F |
Student Ethnicity Code | 10 | N/A | Not tracked in eSchoolPlus |
Student Username | 60 | reg_personal.state_report_id |
|
Student Password | 100 | System-generated as described in the Notes. | Concatenation of the student's first initial + middle initial + last initial + birthdate. |
Student Report Email | 128 | reg_contact.email where reg_stu_contact.contact_type = M | Email from the student's Addresses page |
Parent Report Email 1 | 128 | reg_contact.email where reg_stu_contact.contact_type = G. Use the contact with the highest contact_priority where 1 is the highest number. | Email from the student's highest Priority Contact where 1 is the highest number. |
Parent Report Email 2 | 128 | reg_contact.email where reg_stu_contact.contact_type = G. Use the contact with the next highest contact_priority, using an ordinal scale with 1 as the highest number. | Email from the student's next highest Priority Contact on an ordinal scale, using 1 as the highest number. |
Student Address 1 | 45 | Use a concatenation of reg_contact.street_number + reg_contact.street_prefix + reg_contact.street_name + reg_contact.street_type where reg_stu_contact.contact_type = M | Use the student's Mailing Address. |
Student Address 2 | 35 | Use a concatenation of reg_contact.apartment + reg_contact.complex where reg_stu_contact.contact_type = M | Use the student's Mailing Address. |
Student Address 3 | 35 | Use reg_contact.development where reg_stu_contact.contact_type = M | Use the student's Mailing Address. |
Student City | 30 | reg_contact.city |
|
Student State | 5 | reg_contact.state |
|
Student Zip Code | 20 | reg_contact.zip |
|
Student Print Body Comp | 1 | Defaults as 'Y' |
|
Student Print Report in Spanish | 1 | Defaults as 'N' |
|
Student Permanent Exemption Code | 10 | N/A | Leave blank |
Student is Active? | 1 | The report compares your As of Date entry to the following date ranges: schd_stu_crs_dates.date_added to schd_stu_crs_dates.date_dropped and reg_entry_with.entry_date to reg_entry_with.withdrawal_date | See if the student is active in the reported course, comparing the FitnessGram As of Date prompt to the student's course dates on the Student Course page. Also, see if the student is enrolled in the reported building, comparing the FitnessGram As of Date prompt to the student's Entry/Withdrawal page. If the answer is Yes in both cases, report Y. If the student is in the course but not enrolled in the building, report N. If the student is not active in the course on the As of Date, report N. |
Class Name | 100 | Concatenation of schd_ms.course + schd_ms.course_section + reg_mp_date.marking_period To get the reg_mp_date.marking_period, first use the prompted FitnessGram As of Date. Find the schd_ms_mp.marking_period including the As of Date. Then get the corresponding reg_mp_date.marking_period code. | Report the course ID, section number, and marking period code. Each record needs a unique Class Name and Teacher ID combination. |
Class ID | 100 | Concatenation of reg_district.state_code_equiv + schd_ms.building + schd_ms.course + schd_ms.course_section Confirm schd_ms.building has reg_building.state_code_equiv | Combine the reported district, building, course ID, and section number. Separate each element using an underscore. |
Class Description | 255 | schd_ms.description |
|
Class Start Date | 10 | reg_mp_date.start_date Get this value by finding the course-section's schd_ms_mp.marking_period corresponding the FitnessGram As of Date. Then map to the reg_mp_date.start_date. | This is the Marking Period start date for the earliest marking period associated with the course-section. |
Class End Date | 10 | reg_mp_date.end_date Get this value by finding the course-section's schd_ms_mp.marking_period corresponding the FitnessGram As of Date. Then map to the reg_mp_date.end_date. | This is the Marking Period end date for the latest marking period associated with the course-section |
Teacher ID | 50 | reg_staff.staff_state_id |
|
Teacher First Name | 35 | reg_staff.first_name | Exclude the record if there is no Teacher First Name. |
Teacher Last Name | 35 | reg_staff.last_name | Exclude the record if there is no Teacher Last Name. |
Teacher Middle Initial | 35 | reg_staff.middle_name | Include only the first character. |
Teacher Nick Name | 35 | N/A | Leave blank |
Teacher User Name | 60 | reg_staff.email | Unique identifier the teacher can use as a secure login. The common practice is to use the teacher's official school email address. |
Teacher Password | 100 | Default to Fitnessgram |
|
Teacher Email | 128 | reg_staff.email |
|
Teacher Address 1 | 45 | reg_building.street1 based on schd_ms.building | Use the school's mailing address |
Teacher Address 2 | 35 | reg_building.street2 based on schd_ms.building | Use the school's mailing address |
Teacher Address 3 | 35 | N/A | Leave blank |
Teacher City | 30 | reg_building.city based on schd_ms.building |
|
Teacher State | 5 | reg_building.state based on schd_ms.building |
|
Teacher Zip | 20 | reg_building.zip based on schd_ms.building |
|
Teacher is Active | 1 | Default Y |
|