Tool Search: i4see Extracts
The 21st Century Report returns all students who have a 21st Century Program record during the entered Start and End Dates on the extract editor. The 21st Century Community Learning Center program (a Title IV, part B program) awards competitive grants for expanded academic enrichment opportunities for children attending high poverty school.
21st Century Report Editor
Report Logic
Students who have a 21st Century Program Record as of the entered Start and End Dates on the report editor are included, and can be generated for the active year or a prior year.
Students are not included when:
- The Enrollment record is marked as State Exclude or No Show.
- The Grade Level of Enrollment is marked as State Exclude.
- The Calendar of Enrollment is marked as State Exclude.
Report Editor
Data Element | Description |
|---|---|
Extract Type | Indicates the type of extract selected. Different options may appear depending on the selection. For this instance, choose 21st Century Report. |
Start Date | Beginning date of the 21st Century Program records. Dates are entered in mmddyy format or can be selected by using the calendar icon. |
End Date | End date of the 21st Century Program records. Dates are entered in mmddyy format or can be selected by using the calendar icon. |
Ad hoc Filter | Selection of previously made filter that contains specific students to include in the label request. |
Report Format | Determines how the request is generated - in the State Format (CSV) or HTML. Use the HTML format when reviewing data. Use the State Format when submitting the list to the state. |
Select Calendars | At least one calendar must be selected in order for the extract to generate. Students in the chosen calendars are included in the extract. Calendars can be selected by the active year, the school or the year. |
| Report Generation | Use the Generate Report to immediately display the results. For larger selections of data (multiple calendars, multiple years), use the Submit to Batch option to choose when the report generates. |
Generate the 21st Century Report
- Select the 21st Century Report options from the Extract Type dropdown list.
- Enter the Start Date and End Date of the program records to include.
- Select an Ad hoc filter from the dropdown list to reduce the amount of students included in the extract.
- Select the desired Report Format.
- Select the desired Calendars from which to report students.
- Click the Generate Extract or the Submit to Batch button. The report displays in the selected format.
21st Century Report - HTML Format
21st Century Report - State Format (CSV)
Report Layout
Data Element | Description | Location |
|---|---|---|
SASID | State-assigned student identification number. Numeric, 10 digits | Census > People > Demographics > Person Identifiers > State ID Person.stateID |
Date of Birth | Student's date of birth. Date field, 10 characters (MM/DD/YYYY) | Census > People > Demographics > Person Information > Birth Date Identity.birthdate |
| Program Category | Reports a value of 1. | N/A |
| Program Provider | Reports the value entered in the Program Provider field, or if that field is not populated, reports the School Code. Numeric, 5 digits | Student Information > Program Participation > State Programs > 21st Century > Program Provider TwentyFirstCCLC.programProvider School & District Settings > Schools > School Information > State School Number School.Number |
| Fall Visits | Indicates the number of visits (between 0 and 400) the student had in the fall term. Numeric, 3 digits | Student Information > Program Participation > State Programs > 21st Century > Fall Visits TwentyFirstCCLC.fallVisits |
| Spring Visits | Indicates the number of visits (between 0 and 400) the student had in the spring term. Numeric, 3 digits | Student Information > Program Participation > State Programs > 21st Century > Spring Visits TwentyFirstCCLC.springVisits |
| Summer Visits | Indicates the number of visits (between 0 and 400) the student had in the summer term. Numeric, 3 digits | Student Information > Program Participation > State Programs > 21st Century > Summer Visits TwentyFirstCCLC.summerVisits |
| Increased Math Grade | Indicates the student had improvement in Math. Reports the selected code on the student's 21st Century record. Numeric, 1 digit | Student Information > Program Participation > State Programs > 21st Century > Increased Math Grade TwentyFirstCCLC.increasedMathGrade |
| Increased RLA Grade | Indicates the student had improvement in Reading/Language Arts grade. Reports the selected code on the student's 21st Century record. Numeric, 1 digit | Student Information > Program Participation > State Programs > 21st Century > Increased RLA Grade TwentyFirstCCLC.increasedReadingGrade |
| Turning in Homework On Time | Indicates the student improved in turning in homework on time: Reports the selected code on the student's 21st Century record. Numeric, 1 digit | Student Information > Program Participation > State Programs > 21st Century > Turning In Homework On Time TwentyFirstCCLC.turningHomeworkOnTime |
| Completing Homework to Satisfaction | Indicates the student improved in completing homework to satisfaction. Reports the selected code on the student's 21st Century record. Numeric 1, digit | Student Information > Program Participation > State Programs > 21st Century > Completing Homework to Satisfaction TwentyFirstCCLC.homeworkSatisfaction |
| Participating in Class | Indicates the student improved in class participation. Reports the selected code on the student's 21st Century record. Numeric, 1 digit | Student Information > Program Participation > State Programs > 21st Century > Participating in Class TwentyFirstCCLC.participatingInClass |
| Volunteering | Indicates the student improved in voluteering. Reports the selected code on the student's 21st Century record. Numeric, 1 digit | Student Information > Program Participation > State Programs > 21st Century > Volunteering TwentyFirstCCLC.volunteering |
| Attending Class Regularly | Indicates the student improved in class attendance. Reports the selected code on the student's 21st Century record. Numeric, 1 digit | Student Information > Program Participation > State Programs > 21st Century > Attending Class Regularly TwentyFirstCCLC.attendingClassRegularly |
| Being Attentive in Class | Indicates the student improved in being attentive in class. Reports the selected code on the student's 21st Century record. Numeric, 1 digit | Student Information > Program Participation > State Programs > 21st Century > Being Attentive in Class TwentyFirstCCLC.beingAttentiveInClass |
| Behaving Well in Class | Indicates the student improved behavior in class. Reports the selected code on the student's 21st Century record. Numeric, 1 digit | Student Information > Program Participation > State Programs > 21st Century > Behaving Well in Class TwentyFirstCCLC.behavingWellInClass |
| Academic Performance | Indicates the student improved in overall academic performance. Reports the selected code on the student's 21st Century record. Numeric, 1 digit | Student Information > Program Participation > State Programs > 21st Century > Academic Performance TwentyFirstCCLC.academicPerformance |
| Getting Along Well with Others | Indicates the student improved in getting along with others. Reports the selected code on the student's 21st Century record. Numeric, 1 digit | Student Information > Program Participation > State Programs > 21st Century > Getting Along Well with Others TwentyFirstCCLC.gettingAlongWellWithOthers |
| Coming Motivated to Learn | Indicates the student improved in motivation to learn. Reports the selected code on the student's 21st Century record. Numeric, 1 digit | Student Information > Program Participation > State Programs > 21st Century > Coming Motivated to Learn TwentyFirstCCLC.comingMotivatedToLearn |
