Tool Search: Civil Rights Data Collection (CRDC)
Campus calculates the answers for the following questions via mappings you'll use the CRDC Setup Tool to create. Alternatively, you may choose to create Ad hoc filters to answer these questions. This information is provided for you to use as a reference. Consult the information on the official CRDC Resource Center website if you need information about instructions, skip logic or other CRDC topics.
1. SCHR: School Characteristics
(ONLY for SCHR-3: Grades with Students Enrolled)
Click here to expand...
Category Mapping: Grade Levels
Flat File Details:
Permitted Values: Yes/No/Null Length of Permitted Values: 3 | ||
Layout | Element Name | Data Element |
|---|---|---|
| SCHR-3.1 | SCH_GRADE_PS | Preschool |
| SCHR-3.2 | SCH_GRADE_KG | Kindergarten |
| SCHR-3.3 | SCH_GRADE_G01 | Grade 1 |
| SCHR-3.4 | SCH_GRADE_G02 | Grade 2 |
| SCHR-3.5 | SCH_GRADE_G03 | Grade 3 |
| SCHR-3.6 | SCH_GRADE_G04 | Grade 4 |
| SCHR-3.7 | SCH_GRADE_G05 | Grade 5 |
| SCHR-3.8 | SCH_GRADE_G06 | Grade 6 |
| SCHR-3.9 | SCH_GRADE_G07 | Grade 7 |
| SCHR-3.10 | SCH_GRADE_G08 | Grade 8 |
| SCHR-3.11 | SCH_GRADE_G09 | Grade 9 |
| SCHR-3.12 | SCH_GRADE_G10 | Grade 10 |
| SCHR-3.13 | SCH_GRADE_G11 | Grade 11 |
| SCHR-3.14 | SCH_GRADE_G12 | Grade 12 |
| SCHR-3.15 | SCH_GRADE_UG | Ungraded |
| Logic |
|---|
All CRDC Grade Levels will display with results for each grade:
|
| An override column will be next to the results with a droplist next to each grade level that can be set to Yes, No or NULL |
Detail Report Logic will display the following information:
|
3. PSCH: Preschool
(NOT for PSCH-2a, 2b, 2c, 2d)
PSCH-1: Preschool Age for Non-IDEA Children
Click here to expand...
Category Mapping: Grade Levels, Fall Snapshot IDEA Students
Flat File Details:
Permitted Values: Yes/No/NULL Length of Permitted Values: 3 | ||
Layout | Element Name | Data Element |
|---|---|---|
| PSCH1.1 | SCH_PSENR_NONIDEA_A3 | Children age 3 years |
| PSCH1.2 | SCH_PSENR_NONIDEA_A4_A5 | Children age 4 and 5 years |
| Logic |
|---|
Indicate whether any of the school’s preschool services or programs serve non-IDEA children in the ages specified.
|
Results Logic: Report if the school has any students with a qualifying enrollment in a grade level that is mapped to the CRDC Grade Level = Preschool and they meet the age requirement being reported
|
| An override column will be next to the results with a droplist next to each grade level that can be set to Yes, No, or NULL |
Detail Report Logic will display the following information:
|
PSCH-3: Preschool Enrollment
Click here to expand...
Category Mapping: Grade Levels, Fall Snapshot IDEA Students, Fall Snapshot EL Students, Fall Snapshot 504 Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | ||||
| Layout | Data Element | Male | Female | Total |
|---|---|---|---|---|
| PSCH-3.1, PSCH-3.2 | Hispanic or Latino of any race | SCH_PSENR_HI_M | SCH_PSENR_HI_F | |
| PSCH-3.3, PSCH-3.4 | American Indian or Alaska Native | SCH_PSENR_AM_M | SCH_PSENR_AM_F | |
| PSCH-3.5, PSCH-3.6 | Asian | SCH_PSENR_AS_M | SCH_PSENR_AS_F | |
| PSCH-3.7, PSCH-3.8 | Native Hawaiian or Other Pacific Islander | SCH_PSENR_HP_M | SCH_PSENR_HP_F | |
| PSCH-3.9, PSCH-3.10 | Black or African American | SCH_PSENR_BL_M | SCH_PSENR_BL_F | |
| PSCH-3.11, PSCH-3.12 | White | SCH_PSENR_WH_M | SCH_PSENR_WH_F | |
| PSCH-3.13, PSCH-3.14 | Two or More races | SCH_PSENR_TR_M | SCH_PSENR_TR_F | |
| Total | ||||
| PSCH-3.15, PSCH-3.16 | English Learners (EL) | SCH_PSENR_EL_M | SCH_PSENR_EL_F | |
| PSCH-3.17, PSCH-3.18 | Students with Disabilities (IDEA) | SCH_PSENR_IDEA_M | SCH_PSENR_IDEA_F | |
| PSCH-3.19, PSCH-3.20 | Students with Disabilities (Section 504 Only) | SCH_PSENR_504_M | SCH_PSENR_504_F | |
| Logic |
|---|
PSCH3.1-PSCH3.14: Count and display the total number of distinct students that fall into each Data Element listed
|
PSCH3.15-PSCH3.20: Report the total number of distinct students by gender for the following category mappings:
|
Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender
|
In the question detail screen, an override column will be next to the results with a text box next to each data element.
|
Detail Report Logic will display the following information:
|
PSCH-4a: Preschool Enrollment of English Learner Students
Click here to expand...
Category Mapping: Grade Levels, Fall Snapshot EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | ||||
| Layout | Data Element | Male | Female | Total |
|---|---|---|---|---|
| PSCH-4a.1, PSCH-4a.2 | Hispanic or Latino of any race | SCH_PSELENR_HI_M | SCH_PSELENR_HI_F | |
| PSCH-4a.3, PSCH-4a.4 | American Indian or Alaska Native | SCH_PSELENR_AM_M | SCH_PSELENR_AM_F | |
| PSCH-4a.5, PSCH-4a.6 | Asian | SCH_PSELENR_AS_M | SCH_PSELENR_AS_F | |
| PSCH-4a.7, PSCH-4a.8 | Native Hawaiian or Other Pacific Islander | SCH_PSELENR_HP_M | SCH_PSELENR_HP_F | |
| PSCH-4a.9, PSCH-4a.10 | Black or African American | SCH_PSELENR_BL_M | SCH_PSELENR_BL_F | |
| PSCH-4a.11, PSCH-4a.12 | White | SCH_PSELENR_WH_M | SCH_PSELENR_WH_F | |
| PSCH-4a.13, PSCH-4a.14 | Two or More races | SCH_PSELENR_TR_M | SCH_PSELENR_TR_F | |
| Total | ||||
| Logic |
|---|
PSCH4a.1-PSCH4a.14: Count and display the total number of distinct Fall Snapshot EL Students that fall into each Data Element listed
|
| Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender |
| The totals in the summary will be updated upon hitting save. Totals are not reported, they are only there for data verification. |
In the question detail screen, an override column will be next to the results with a text box next to each data element
|
Detail Report Logic will display the following information:
|
PSCH-4b: Preschool Enrollment of English Learner Students - EL Students in EL Programs
Click here to expand...
Category Mapping: Grade Levels, Fall Snapshot Students Enrolled in EL Programs, Fall Snapshot IDEA Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | ||||
| Layout | Data Element | Male | Female | Total |
|---|---|---|---|---|
| PSCH-4b.1, PSCH-4b.2 | Hispanic or Latino of any race | SCH_PSELPROGENR_HI_M | SCH_PSELPROGENR_HI_F | |
| PSCH-4b.3, PSCH-4b.4 | American Indian or Alaska Native | SCH_PSELPROGENR_AM_M | SCH_PSELPROGENR_AM_F | |
| PSCH-4b.5, PSCH-4b.6 | Asian | SCH_PSELPROGENR_AS_M | SCH_PSELPROGENR_AS_F | |
| PSCH-4b.7, PSCH-4b.8 | Native Hawaiian or Other Pacific Islander | SCH_PSELPROGENR_HP_M | SCH_PSELPROGENR_HP_F | |
| PSCH-4b.9, PSCH-4b.10 | Black or African American | SCH_PSELPROGENR_BL_M | SCH_PSELPROGENR_BL_F | |
| PSCH-4b.11, PSCH-4b.12 | White | SCH_PSELPROGENR_WH_M | SCH_PSELPROGENR_WH_F | |
| PSCH-4b.13, PSCH-4b.14 | Two or More races | SCH_PSELPROGENR_TR_M | SCH_PSELPROGENR_TR_F | |
| Total | ||||
| PSCH-4b.15, PSCH-4b.16 | Students with Disabilities (IDEA) | SCH_PSELPROGENR_IDEA_M | SCH_PSELPROGENR_IDEA_F | |
| Logic |
|---|
PSCH4b.1-PSCH4b.14: Count and display the total number of distinct Fall Snapshot Students Enrolled in EL Programs that fall into each Data Element listed
|
PSCH4b.15-PSCH4b.16: Count and display the total number of IDEA students who are also Fall Snapshot IDEA Students Enrolled in EL Programs that fall into each data element listed
|
Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender, IDEA by Gender
|
In the question detail screen, an override column will be next to the results with a text box next to each data element
|
Detail Report Logic will display the following information:
|
PSCH-5: Preschool Enrollment of Students with Disabilities - IDEA
Click here to expand...
Category Mapping: Grade Levels, Fall Snapshot IDEA Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | ||||
| Layout | Data Element | Male | Female | Total |
|---|---|---|---|---|
| PSCH-5.1, PSCH-5.2 | Hispanic or Latino of any race | SCH_PSIDEAENR_HI_M | SCH_PSIDEAENR_HI_F | |
| PSCH-5.3, PSCH-5.4 | American Indian or Alaska Native | SCH_PSIDEAENR_AM_M | SCH_PSIDEAENR_AM_F | |
| PSCH-5.5, PSCH-5.6 | Asian | SCH_PSIDEAENR_AS_M | SCH_PSIDEAENR_AS_F | |
| PSCH-5.7, PSCH-5.8 | Native Hawaiian or Other Pacific Islander | SCH_PSIDEAENR_HP_M | SCH_PSIDEAENR_HP_F | |
| PSCH-5.9, PSCH-5.10 | Black or African American | SCH_PSIDEAENR_BL_M | SCH_PSIDEAENR_BL_F | |
| PSCH-5.11, PSCH-5.12 | White | SCH_PSIDEAENR_WH_M | SCH_PSIDEAENR_WH_F | |
| PSCH-5.13, PSCH-5.14 | Two or More races | SCH_PSIDEAENR_TR_M | SCH_PSIDEAENR_TR_F | |
| Total | ||||
| PSCH-5.15, PSCH-5.16 | English Learners (EL) | SCH_PSIDEAENR_EL_M | SCH_PSIDEAENR_EL_F | |
| Logic | |
|---|---|
| PSCH5.1 | PSCH5.1-PSCH5.14: Count and display the total number of distinct Fall Snapshot IDEA Students that fall into each Data Element listed
|
| PSCH5.2 | PSCH5.15-PSCH5.16: Count and display the total number of students who are Fall Snapshot EL students that fall into each data element listed
|
| PSCH5.3 | Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender, EL by Gender
|
| PSCH5.4 | In the question detail screen, an override column will be next to the results with a text box next to each data element |
| PSCH5.5 | Detail Report Logic will display the following information:
|
PSCH-6: Preschool Enrollment of Students with Disabilities - Section 504 Only
Click here to expand...
Category Mapping: Grade Levels, Fall Snapshot 504 Students, Fall Snapshot EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | ||||
| Layout | Data Element | Male | Female | Total |
|---|---|---|---|---|
| PSCH-6.1, PSCH-6.2 | Hispanic or Latino of any race | SCH_PS504ENR_HI_M | SCH_PS504ENR_HI_F | |
| PSCH-6.3, PSCH-6.4 | American Indian or Alaska Native | SCH_PS504ENR_AM_M | SCH_PS504ENR_AM_F | |
| PSCH-6.5, PSCH-6.6 | Asian | SCH_PS504ENR_AS_M | SCH_PS504ENR_AS_F | |
| PSCH-6.7, PSCH-6.8 | Native Hawaiian or Other Pacific Islander | SCH_PS504ENR_HP_M | SCH_PS504ENR_HP_F | |
| PSCH-6.9, PSCH-6.10 | Black or African American | SCH_PS504ENR_BL_M | SCH_PS504ENR_BL_F | |
| PSCH-6.11, PSCH-6.12 | White | SCH_PS504ENR_WH_M | SCH_PS504ENR_WH_F | |
| PSCH-6.13, PSCH-6.14 | Two or More races | SCH_PS504ENR_TR_M | SCH_PS504ENR_TR_F | |
| Total | ||||
| PSCH-6.15, PSCH-6.16 | English Learners (EL) | SCH_PS504ENR_EL_M | SCH_PS504ENR_EL_F | |
| Logic | |
|---|---|
| PSCH6.1 | PSCH6.1-PSCH6.14: Count and display the total number of distinct Fall Snapshot 504 Students that fall into each Data Element listed
|
| PSCH6.2 | PSCH6.15-PSCH6.16: Count and display the total number of Fall Snapshot 504 students who are also Fall Snapshot EL students that fall into each data element listed
|
| PSCH6.3 | Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender, EL by Gender
|
| PSCH6.4 | In the question detail screen, an override column will be next to the results with a text box next to each data element |
| PSCH6.5 | Detail Report Logic will display the following information:
|
5. ENRL: Enrollment
ENRL-1: Student Enrollment
Click here to expand...
Category Mapping: Fall Snapshot IDEA Students, Fall Snapshot 504 Students, Fall Snapshot EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| ENRL-1.1, ENRL-1.2, ENRL-1.3 | Hispanic or Latino of any race | SCH_ENR_HI_M | SCH_ENR_HI_F | SCH_ENR_HI_X | |
| ENRL-1.4, ENRL-1.5, ENRL-1.6 | American Indian or Alaska Native | SCH_ENR_AM_M | SCH_ENR_AM_F | SCH_ENR_AM_X | |
| ENRL-1.7, ENRL-1.8, ENRL-1.9 | Asian | SCH_ENR_AS_M | SCH_ENR_AS_F | SCH_ENR_AS_X | |
| ENRL-1.10, ENRL-1.11, ENRL-1.12 | Native Hawaiian or Other Pacific Islander | SCH_ENR_HP_M | SCH_ENR_HP_F | SCH_ENR_HP_X | |
| ENRL-1.13, ENRL-1.14, ENRL-1.15 | Black or African American | SCH_ENR_BL_M | SCH_ENR_BL_F | SCH_ENR_BL_X | |
| ENRL-1.16, ENRL-1.17, ENRL-1.18 | White | SCH_ENR_WH_M | SCH_ENR_WH_F | SCH_ENR_WH_X | |
| ENRL-1.19, ENRL-1.20, ENRL-1.21 | Two or More races | SCH_ENR_TR_M | SCH_ENR_TR_F | SCH_ENR_TR_X | |
| Total | |||||
| ENRL-1.22, ENRL-1.23, ENRL-1.24 | English Learners (EL) | SCH_ENR_EL_M | SCH_ENR_EL_F | SCH_ENR_EL_X | |
| ENRL-1.25, ENRL-1.26, ENRL-1.27 | Students with Disabilities (IDEA) | SCH_ENR_IDEA_M | SCH_ENR_IDEA_F | SCH_ENR_IDEA_X | |
| ENRL-1.28, ENRL-1.29, ENRL-1.30 | Students with Disabilities (Section 504 Only) | SCH_ENR_504_M | SCH_ENR_504_F | SCH_ENR_504_X | |
| Logic |
|---|
ENRL1.1-ENRL1.21: Count and display the total number of distinct students that fall into each Data Element listed
|
ENRL1.22-ENRL1.30: Report the total number of distinct students by gender for the following category mappings:
|
Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender
|
In the question detail screen, an override column will be next to the results with a text box next to each data element.
|
Detail Report Logic will display the following information:
|
ENRL-2a: Enrollment of English Learner Students - All EL Students
Click here to expand...
Category Mapping: Fall Snapshot EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| ENRL2a.1, ENRL2a.2, ENRL2a.3 | Hispanic or Latino of any race | SCH_ELENR_HI_M | SCH_ELENR_HI_F | SCH_ELENR_HI_X | |
| ENRL2a.4, ENRL2a.5, ENRL2a.6 | American Indian or Alaska Native | SCH_ELENR_AM_M | SCH_ELENR_AM_F | SCH_ELENR_AM_X | |
| ENRL2a.7, ENRL2a.8, ENRL2a.9 | Asian | SCH_ELENR_AS_M | SCH_ELENR_AS_F | SCH_ELENR_AS_X | |
| ENRL2a.10, ENRL2a.11, ENRL2a.12 | Native Hawaiian or Other Pacific Islander | SCH_ELENR_HP_M | SCH_ELENR_HP_F | SCH_ELENR_HP_X | |
| ENRL2a.13, ENRL2a.14, ENRL2a.15 | Black or African American | SCH_ELENR_BL_M | SCH_ELENR_BL_F | SCH_ELENR_BL_X | |
| ENRL2a.16, ENRL2a.17, ENRL2a.18 | White | SCH_ELENR_WH_M | SCH_ELENR_WH_F | SCH_ELENR_WH_X | |
| ENRL2a.19, ENRL2a.20, ENRL2a.21 | Two or More races | SCH_ELENR_TR_M | SCH_ELENR_TR_F | SCH_ELENR_TR_X | |
| Total | |||||
| Logic |
|---|
ENRL2a.1-ENRL2a.21: Count and display the total number of distinct Fall Snapshot EL Students that fall into each Data Element listed
|
| Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender |
| The totals in the summary will be updated upon hitting save. Totals are not reported, they are only there for data verification. |
In the question detail screen, an override column will be next to the results with a text box next to each data element
|
Detail Report Logic will display the following information:
|
ENRL-2b: Enrollment of English Learner Students - EL Students in Programs
Click here to expand...
Category Mapping: Fall Snapshot Students Enrolled in EL Programs, Fall Snapshot IDEA Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| ENRL2b.1, ENRL2b.2, ENRL2b.3 | Hispanic or Latino of any race | SCH_ELPROGENR_HI_M | SCH_ELPROGENR_HI_F | SCH_ELPROGENR_HI_X | |
| ENRL2b.4, ENRL2b.5, ENRL2b.6 | American Indian or Alaska Native | SCH_ELPROGENR_AM_M | SCH_ELPROGENR_AM_F | SCH_ELPROGENR_AM_X | |
| ENRL2b.7, ENRL2b.8, ENRL2b.9 | Asian | SCH_ELPROGENR_AS_M | SCH_ELPROGENR_AS_F | SCH_ELPROGENR_AS_X | |
| ENRL2b.10, ENRL2b.11, ENRL2b.12 | Native Hawaiian or Other Pacific Islander | SCH_ELPROGENR_HP_M | SCH_ELPROGENR_HP_F | SCH_ELPROGENR_HP_X | |
| ENRL2b.13, ENRL2b.14, ENRL2b.15 | Black or African American | SCH_ELPROGENR_BL_M | SCH_ELPROGENR_BL_F | SCH_ELPROGENR_BL_X | |
| ENRL2b.16, ENRL2b.17, ENRL2b.18 | White | SCH_ELPROGENR_WH_M | SCH_ELPROGENR_WH_F | SCH_ELPROGENR_WH_X | |
| ENRL2b.19, ENRL2b.20, ENRL2b.21 | Two or More races | SCH_ELPROGENR_TR_M | SCH_ELPROGENR_TR_F | SCH_ELPROGENR_TR_X | |
| Total | |||||
| ENRL2b.22, ENRL2b.23, ENRL2b.24 | Students with Disabilities (IDEA) | SCH_ELPROGENR_IDEA_M | SCH_ELPROGENR_IDEA_F | SCH_ELPROGENR_IDEA_X | |
| Logic |
|---|
ENRL2b.1-ENRL2b.21: Count and display the total number of distinct Fall Snapshot Students Enrolled in EL Programs that fall into each Data Element listed
|
ENRL2b.22-ENRL2b.24: Count and display the total number of IDEA students who are also Fall Snapshot IDEA Students Enrolled in EL Programs that fall into each data element listed
|
Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender,
|
In the question detail screen, an override column will be next to the results with a text box next to each data element
|
Detail Report Logic will display the following information:
|
ENRL-3: Enrollment of Students with Disabilities - IDEA
Click here to expand...
Category Mapping: Fall Snapshot Idea Students, Fall Snapshot EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| ENRL3.1, ENRL3.2, ENRL3.3 | Hispanic or Latino of any race | SCH_IDEAENR_HI_M | SCH_IDEAENR_HI_F | SCH_IDEAENR_HI_X | |
| ENRL3.4, ENRL3.5, ENRL3.6 | American Indian or Alaska Native | SCH_IDEAENR_AM_M | SCH_IDEAENR_AM_F | SCH_IDEAENR_AM_X | |
| ENRL3.7, ENRL3.8, ENRL3.9 | Asian | SCH_IDEAENR_AS_M | SCH_IDEAENR_AS_F | SCH_IDEAENR_AS_X | |
| ENRL3.10, ENRL3.11, ENRL3.12 | Native Hawaiian or Other Pacific Islander | SCH_IDEAENR_HP_M | SCH_IDEAENR_HP_F | SCH_IDEAENR_HP_X | |
| ENRL3.13, ENRL3.14, ENRL3.15 | Black or African American | SCH_IDEAENR_BL_M | SCH_IDEAENR_BL_F | SCH_IDEAENR_BL_X | |
| ENRL3.16, ENRL3.17, ENRL3.18 | White | SCH_IDEAENR_WH_M | SCH_IDEAENR_WH_F | SCH_IDEAENR_WH_X | |
| ENRL3.19, ENRL3.20, ENRL3.21 | Two or More races | SCH_IDEAENR_TR_M | SCH_IDEAENR_TR_F | SCH_IDEAENR_TR_X | |
| Total | |||||
| ENRL3.22, ENRL3.23, ENRL3.24 | English Learners (EL) | SCH_IDEAENR_EL_M | SCH_IDEAENR_EL_F | SCH_IDEAENR_EL_X | |
| Logic |
|---|
ENRL3.1-ENRL3.21: Count and display the total number of distinct Fall Snapshot IDEA Students that fall into each Data Element listed
|
ENRL3.22-ENRL3.24: Count and display the total number of Fall Snapshot IDEA students who are also Fall Snapshot EL students that fall into each data element listed
|
Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender, EL by Gender
|
| In the question detail screen, an override column will be next to the results with a text box next to each data element |
Detail Report Logic will display the following information:
|
ENRL-4: Enrollment of Students with Disabilities - Section 504 Only
Click here to expand...
Category Mapping: Fall Snapshot 504 Students, Fall Snapshot EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| ENRL4.1, ENRL4.2, ENRL4.3 | Hispanic or Latino of any race | SCH_504ENR_HI_M | SCH_504ENR_HI_F | SCH_504ENR_HI_X | |
| ENRL4.4, ENRL4.5, ENRL4.6 | American Indian or Alaska Native | SCH_504ENR_AM_M | SCH_504ENR_AM_F | SCH_504ENR_AM_X | |
| ENRL4.7, ENRL4.8, ENRL4.9 | Asian | SCH_504ENR_AS_M | SCH_504ENR_AS_F | SCH_504ENR_AS_X | |
| ENRL4.10, ENRL4.11, ENRL4.12 | Native Hawaiian or Other Pacific Islander | SCH_504ENR_HP_M | SCH_504ENR_HP_F | SCH_504ENR_HP_X | |
| ENRL4.13, ENRL4.14, ENRL4.15 | Black or African American | SCH_504ENR_BL_M | SCH_504ENR_BL_F | SCH_504ENR_BL_X | |
| ENRL4.16, ENRL4.17, ENRL4.18 | White | SCH_504ENR_WH_M | SCH_504ENR_WH_F | SCH_504ENR_WH_X | |
| ENRL4.19, ENRL4.20, ENRL4.21 | Two or More races | SCH_504ENR_TR_M | SCH_504ENR_TR_F | SCH_504ENR_TR_X | |
| Total | |||||
| ENRL4.22, ENRL4.23, ENRL4.24 | English Learners (EL) | SCH_504ENR_EL_M | SCH_504ENR_EL_F | SCH_504ENR_EL_X | |
| Logic |
|---|
ENRL4.1-ENRL4.21: Count and display the total number of distinct Fall Snapshot 504 Students that fall into each Data Element listed
|
ENRL4.22-ENRL4.24: Count and display the total number of Fall Snapshot 504 students who are also Fall Snapshot EL students that fall into each data element listed
|
Show Totals in the question summary in the following groupings: Race/Ethnicity by Gender & Total Number by Gender, EL by Gender
|
| In the question detail screen, an override column will be next to the results with a text box next to each data element |
Detail Report Logic will display the following information:
|
7. COUR: Courses & Classes
COUR-1: Grade 7/8 Algebra 1 Classes
Click here to expand...
Category Mapping: Algebra I - Grades 7 & 8
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | ||
Layout | Element Name | Data Element |
|---|---|---|
| COUR1.1 | SCH_ALGCLASSES_GS0708 | Number of Algebra I classes for students in grades 7-8 |
| Logic |
|---|
Count and display the total number of Algebra I courses for the data element listed
|
| In the question detail screen, an override column will be next to the results with a text box to enter in values |
Detail Report Logic will display the following information:
|
COUR-2: Grade 7 Algebra I Enrollment Indicator
Click here to expand...
Category Mapping: Grade Levels, Algebra I - Grades 7 & 8
Flat File Details:
Permitted Values: Yes, No, NULL Length of Permitted Values: 3 | ||
Layout | Element Name | Data Element |
|---|---|---|
| COUR2.1 | SCH_ALGENR_G07_IND | Whether the school had any students in grade 7 enrolled in Algebra I |
| Logic |
|---|
Report Yes if the school has at least 1 student enrolled in Algebra I in Grade 7
|
| Report No if the school does not have any students enrolled in Algebra in Grade 7 |
| In the question detail screen, an override column will be next to the results with a droplist to select a value |
Detail Report Logic will display the following information:
|
COUR-3: Grade 8 Algebra I Enrollment Indicator
Click here to expand...
Category Mapping: Grade Levels, Algebra I - Grades 7 & 8
Flat File Details:
Permitted Values: Yes, No, NULL Length of Permitted Values: 3 | ||
Layout | Element Name | Data Element |
|---|---|---|
| COUR3.1 | SCH_ALGENR_G08_IND | Whether the school had any students in grade 8 enrolled in Algebra I |
| Logic |
|---|
Report Yes if the school has at least 1 student enrolled in Algebra I in Grade 8
|
| Report No if the school does not have any students enrolled in Algebra in Grade 8 |
| In the question detail screen, an override column will be next to the results with a droplist to select a value |
Detail Report Logic will display the following information:
|
COUR-4a: Student Enrollment in Algebra I - Grades 7 & 8
Click here to expand...
Category Mapping: Grade Levels, Algebra I - Grades 7 & 8, Regular School Year IDEA Students, Regular School Year English Learners
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| COUR4a.1, COUR4a.2, COUR4a.3 | Hispanic or Latino of any race | SCH_ALGENR_G0708_HI_M | SCH_ALGENR_G0708_HI_F | SCH_ALGENR_G0708_HI_X | |
| COUR4a.4, COUR4a.5, COUR4a.6 | American Indian or Alaska Native | SCH_ALGENR_G0708_AM_M | SCH_ALGENR_G0708_AM_F | SCH_ALGENR_G0708_AM_X | |
| COUR4a.7, COUR4a.8, COUR4a.9 | Asian | SCH_ALGENR_G0708_AS_M | SCH_ALGENR_G0708_AS_F | SCH_ALGENR_G0708_AS_X | |
| COUR4a.10, COUR4a.11, COUR4a.12 | Native Hawaiian or Other Pacific Islander | SCH_ALGENR_G0708_HP_M | SCH_ALGENR_G0708_HP_F | SCH_ALGENR_G0708_HP_X | |
| COUR4a.13, COUR4a.14, COUR4a.15 | Black or African American | SCH_ALGENR_G0708_BL_M | SCH_ALGENR_G0708_BL_F | SCH_ALGENR_G0708_BL_X | |
| COUR4a.16, COUR4a.17, COUR4a.18 | White | SCH_ALGENR_G0708_WH_M | SCH_ALGENR_G0708_WH_F | SCH_ALGENR_G0708_WH_X | |
| COUR4a.19, COUR4a.20, COUR4a.21 | Two or More races | SCH_ALGENR_G0708_TR_M | SCH_ALGENR_G0708_TR_F | SCH_ALGENR_G0708_TR_X | |
| Total | |||||
| COUR4a.22, COUR4a.23, COUR4a.24 | English Learners (EL) | SCH_ALGENR_G0708_EL_M | SCH_ALGENR_G0708_EL_F | SCH_ALGENR_G0708_EL_X | |
| COUR4a.25, COUR4a.26, COUR4a.27 | Students with Disabilities (IDEA) | SCH_ALGENR_G0708_IDEA_M | SCH_ALGENR_G0708_IDEA_F | SCH_ALGENR_G0708_IDEA_X | |
| Logic |
|---|
Report the distinct total number of students enrolled in Algebra I in Grade 7 or Grade 8 using the Student Roster Count logic. Only students who were included in the total for COUR-2 or COUR-3 can be reported in this question.
|
| Report Null if the school does not have any students enrolled in Algebra I in Grade 7 or Grade 8 |
| In the question detail screen, an override column will be next to the results with a droplist to select a value |
Detail Report Logic will display the following information:
|
COUR-4b: Students who Passed Algebra I - Grades 7 & 8
Click here to expand...
Category Mapping: Grade Levels, Algebra I - Grades 7 & 8, Regular School Year IDEA Students, Regular School Year EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| COUR4b.1, COUR4b.2, COUR4b.3 | Hispanic or Latino of any race | SCH_ALGPASS_G0708_HI_M | SCH_ALGPASS_G0708_HI_F | SCH_ALGPASS_G0708_HI_X | |
| COUR4b.4, COUR4b.5, COUR4b.6 | American Indian or Alaska Native | SCH_ALGPASS_G0708_AM_M | SCH_ALGPASS_G0708_AM_F | SCH_ALGPASS_G0708_AM_X | |
| COUR4b.7, COUR4b.8, COUR4b.9 | Asian | SCH_ALGPASS_G0708_AS_M | SCH_ALGPASS_G0708_AS_F | SCH_ALGPASS_G0708_AS_X | |
| COUR4b.10, COUR4b.11, COUR4b.12 | Native Hawaiian or Other Pacific Islander | SCH_ALGPASS_G0708_HP_M | SCH_ALGPASS_G0708_HP_F | SCH_ALGPASS_G0708_HP_X | |
| COUR4b.13, COUR4b.14, COUR4b.15 | Black or African American | SCH_ALGPASS_G0708_BL_M | SCH_ALGPASS_G0708_BL_F | SCH_ALGPASS_G0708_BL_X | |
| COUR4b.16, COUR4b.17, COUR4b.18 | White | SCH_ALGPASS_G0708_WH_M | SCH_ALGPASS_G0708_WH_F | SCH_ALGPASS_G0708_WH_X | |
| COUR4b.19, COUR4b.20, COUR4b.21 | Two or More races | SCH_ALGPASS_G0708_TR_M | SCH_ALGPASS_G0708_TR_F | SCH_ALGPASS_G0708_TR_X | |
| Total | |||||
| COUR4b.22, COUR4b.23, COUR4b.24 | English Learners (EL) | SCH_ALGPASS_G0708_EL_M | SCH_ALGPASS_G0708_EL_F | SCH_ALGPASS_G0708_EL_X | |
| COUR4b.25, COUR4b.26, COUR4b.27 | Students with Disabilities (IDEA) | SCH_ALGPASS_G0708_IDEA_M | SCH_ALGPASS_G0708_IDEA_F | SCH_ALGPASS_G0708_IDEA_X | |
| Logic |
|---|
Report the distinct total number of students who passed Algebra I in Grade 7 and Grade 8 on the last using the Student Roster Count logic of the school year. Only students who were included in the total for COUR-2 or COUR-3 can be reported in this question.
|
The student must have a passing score in at least 1 Algebra I course based on the Passing Score Indicator identified on the Algebra I - Grades 7 & 8 category mapping
|
| Report 0 if there are no students that meet the reporting criteria |
| Report NULL if the answer for COUR-2 and COUR-3 is NULL or '0' |
| In the question detail screen, an override column will be next to the results with a text box to select a value |
The user will be able to select a link on a result and a side panel will display the eligible students
|
Detail Report Logic will display the following information:
|
COUR-5: Grade 8 Geometry Enrollment Indicator
Click here to expand...
Category Mapping: Grade Levels, Geometry - Grade 8
Flat File Details:
Permitted Values: Yes, No, NULL Length of Permitted Values: 3 | ||
Layout | Element Name | Data Element |
|---|---|---|
| COUR5.1 | SCH_GEOMENR_G08_IND | Whether the school had any students in grade 8 enrolled in Geometry |
| Logic |
|---|
Report Yes if the school has at least 1 student enrolled in Geometry in Grade 8 on the Fall Snapshot Date
|
| Report No if the school does not have any students enrolled in Geometry in Grade 8 |
| In the question detail screen, an override column will be next to the results with a droplist to select a value |
Detail Report Logic will display the following information:
|
COUR-6: Student Enrollment in Geometry in Grade 8
Click here to expand...
Category Mapping: Grade Levels, Geometry - Grade 8
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | ||
Layout | Element Name | Data Element |
|---|---|---|
| COUR6.1 | SCH_GEOMENR_G08 | Total Number of Students |
| Logic |
|---|
Report the distinct total number of students enrolled in Geometry in Grade 8 for each data element
|
| Report 0 if there are no students that meet the reporting criteria for the data element |
| Report NULL if the answer for COUR-5 is NULL or No |
| In the question detail screen, an override column will be next to the results with a text box to select a value |
Detail Report Logic will display the following information:
|
COUR-7: Classes in Mathematics Courses in High School
Click here to expand...
Category Mapping: Algebra I - High School, Algebra II, Geometry - High School, Advanced Mathematics, Calculus
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | ||
Layout | Element Name | Data Element |
|---|---|---|
| COUR7.1 | SCH_MATHCLASSES_ALG | Number of High School Algebra I Classes |
| COUR7.2 | SCH_MATHCLASSES_GEOM | Number of High School Geometry Classes |
| COUR7.3 | SCH_MATHCLASSES_ALG2 | Number of High School Algebra II Classes |
| COUR7.4 | SCH_MATHCLASSES_ADVM | Number of High School Advanced Mathematics Classes |
| COUR7.5 | SCH_MATHCLASSES_CALC | Number of High School Calculus Classes |
| Logic |
|---|
Count and display the total number of Geometry, Algebra I, Algebra II, Advanced Mathematics & Calculus courses for the data element listed
|
| In the question detail screen, an override column will be next to the results with a text box to enter in values |
| Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number |
COUR-8a: High School Student Enrollment in Algebra I - Grades 9 & 10
Click here to expand...
Category Mapping: Grade Levels, Algebra I - High School, Regular School Year IDEA Students, Regular School Year EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| COUR8a.1, COUR8a.2, COUR8a.3 | Hispanic or Latino of any race | SCH_ALGENR_GS0910_HI_M | SCH_ALGENR_GS0910_HI_F | SCH_ALGENR_GS0910_HI_X | |
| COUR8a.4, COUR8a.5, COUR8a.6 | American Indian or Alaska Native | SCH_ALGENR_GS0910_AM_M | SCH_ALGENR_GS0910_AM_F | SCH_ALGENR_GS0910_AM_X | |
| COUR8a.7, COUR8a.8, COUR8a.9 | Asian | SCH_ALGENR_GS0910_AS_M | SCH_ALGENR_GS0910_AS_F | SCH_ALGENR_GS0910_AS_X | |
| COUR8a.10, COUR8a.11, COUR8a.12 | Native Hawaiian or Other Pacific Islander | SCH_ALGENR_GS0910_HP_M | SCH_ALGENR_GS0910_HP_F | SCH_ALGENR_GS0910_HP_X | |
| COUR8a.13, COUR8a.14, COUR8a.15 | Black or African American | SCH_ALGENR_GS0910_BL_M | SCH_ALGENR_GS0910_BL_F | SCH_ALGENR_GS0910_BL_X | |
| COUR8a.16, COUR8a.17, COUR8a.18 | White | SCH_ALGENR_GS0910_WH_M | SCH_ALGENR_GS0910_WH_F | SCH_ALGENR_GS0910_WH_X | |
| COUR8a.19, COUR8a.20, COUR8a.21 | Two or More races | SCH_ALGENR_GS0910_TR_M | SCH_ALGENR_GS0910_TR_F | SCH_ALGENR_GS0910_TR_X | |
| Total | |||||
| COUR8a.22, COUR8a.23, COUR8a.24 | English Learners (EL) | SCH_ALGENR_GS0910_EL_M | SCH_ALGENR_GS0910_EL_F | SCH_ALGENR_GS0910_EL_X | |
| COUR8a.25, COUR8a.26, COUR8a.27 | Students with Disabilities (IDEA) | SCH_ALGENR_GS0910_IDEA_M | SCH_ALGENR_GS0910_IDEA_F | SCH_ALGENR_GS0910_IDEA_X | |
| Logic |
|---|
Report the total number of distinct students enrolled in Algebra I in Grades 9 or 10 for each data element
|
| Report 0 if there are no students that meet the reporting criteria for the data element |
| In the question detail screen, an override column will be next to the results with a text box to select a value |
| Detail Report Logic will display the following information: Year, NCES School Number, School Name, Course Number, Course Name, SectionID, Section Number, Students PersonID, State ID, Name, Grade Name, EL, IDEA |
COUR-8b: High School Students who Passed Algebra I - Grades 9 & 10
Click here to expand...
Category Mapping: Grade Levels, Algebra I - High School, Regular School Year IDEA Students, Regular School Year EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| COUR8b.1, COUR8b.2, COUR8b.3 | Hispanic or Latino of any race | SCH_ALGPASS_GS0910_HI_M | SCH_ALGPASS_GS0910_HI_F | SCH_ALGPASS_GS0910_HI_X | |
| COUR8b.4, COUR8b.5, COUR8b.6 | American Indian or Alaska Native | SCH_ALGPASS_GS0910_AM_M | SCH_ALGPASS_GS0910_AM_F | SCH_ALGPASS_GS0910_AM_X | |
| COUR8b.7, COUR8b.8, COUR8b.9 | Asian | SCH_ALGPASS_GS0910_AS_M | SCH_ALGPASS_GS0910_AS_F | SCH_ALGPASS_GS0910_AS_X | |
| COUR8b.10, COUR8b.11, COUR8b.12 | Native Hawaiian or Other Pacific Islander | SCH_ALGPASS_GS0910_HP_M | SCH_ALGPASS_GS0910_HP_F | SCH_ALGPASS_GS0910_HP_X | |
| COUR8b.13, COUR8b.14, COUR8b.15 | Black or African American | SCH_ALGPASS_GS0910_BL_M | SCH_ALGPASS_GS0910_BL_F | SCH_ALGPASS_GS0910_BL_X | |
| COUR8b.16, COUR8b.17, COUR8b.18 | White | SCH_ALGPASS_GS0910_WH_M | SCH_ALGPASS_GS0910_WH_F | SCH_ALGPASS_GS0910_WH_X | |
| COUR8b.19, COUR8b.20, COUR8b.21 | Two or More races | SCH_ALGPASS_GS0910_TR_M | SCH_ALGPASS_GS0910_TR_F | SCH_ALGPASS_GS0910_TR_X | |
| Total | |||||
| COUR8b.22, COUR8b.23, COUR8b.24 | English Learners (EL) | SCH_ALGPASS_GS0910_EL_M | SCH_ALGPASS_GS0910_EL_F | SCH_ALGPASS_GS0910_EL_X | |
| COUR8b.25, COUR8b.26, COUR8b.27 | Students with Disabilities (IDEA) | SCH_ALGPASS_GS0910_IDEA_M | SCH_ALGPASS_GS0910_IDEA_F | SCH_ALGPASS_GS0910_IDEA_X | |
| Logic |
|---|
Report the distinct total number of students who passed Algebra I in Grades 9 or 10. Only students who were included in the total for COUR-8a can be reported in this question.
|
The student must have a passing score in at least 1 Algebra I course based on the Passing Score Indicator identified on the Algebra I - High School category mapping
|
| Report 0 if there are no students that meet the reporting criteria |
| Report NULL if the answer to question COUR-8a is '0' |
| In the question detail screen, an override column will be next to the results with a text box to select a value |
The user will be able to select a link on a result and a side panel will display the eligible students
|
Detail Report Logic will display the following information:
|
COUR-9a: High School Student Enrollment in Algebra I - Grades 11 & 12
Click here to expand...
Category Mapping: Grade Levels, Algebra I - High School, Regular School Year IDEA Students, Regular School Year EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| COUR9a.1,COUR9a.2,COUR9a.3 | Hispanic or Latino of any race | SCH_ALGENR_GS1112_HI_M | SCH_ALGENR_GS1112_HI_F | SCH_ALGENR_GS1112_HI_X | |
| COUR9a.4,COUR9a.5,COUR9a.6 | American Indian or Alaska Native | SCH_ALGENR_GS1112_AM_M | SCH_ALGENR_GS1112_AM_F | SCH_ALGENR_GS1112_AM_X | |
| COUR9a.7,COUR9a.8,COUR9a.9 | Asian | SCH_ALGENR_GS1112_AS_M | SCH_ALGENR_GS1112_AS_F | SCH_ALGENR_GS1112_AS_X | |
| COUR9a.10,COUR9a.11,COUR9a.12 | Native Hawaiian or Other Pacific Islander | SCH_ALGENR_GS1112_HP_M | SCH_ALGENR_GS1112_HP_F | SCH_ALGENR_GS1112_HP_X | |
| COUR9a.13,COUR9a.14,COUR9a.15 | Black or African American | SCH_ALGENR_GS1112_BL_M | SCH_ALGENR_GS1112_BL_F | SCH_ALGENR_GS1112_BL_X | |
| COUR9a.16,COUR9a.17,COUR9a.18 | White | SCH_ALGENR_GS1112_WH_M | SCH_ALGENR_GS1112_WH_F | SCH_ALGENR_GS1112_WH_X | |
| COUR9a.19,COUR9a.20,COUR9a.21 | Two or More races | SCH_ALGENR_GS1112_TR_M | SCH_ALGENR_GS1112_TR_F | SCH_ALGENR_GS1112_TR_X | |
| Total | |||||
| COUR9a.22,COUR9a.23,COUR9a.24 | English Learners (EL) | SCH_ALGENR_GS1112_EL_M | SCH_ALGENR_GS1112_EL_F | SCH_ALGENR_GS1112_EL_X | |
| COUR9a.25,COUR9a.26,COUR9a.27 | Students with Disabilities (IDEA) | SCH_ALGENR_GS1112_IDEA_M | SCH_ALGENR_GS1112_IDEA_F | SCH_ALGENR_GS1112_IDEA_X | |
| Logic |
|---|
Report the total number of distinct students enrolled in Algebra I in Grades 11 or 12 for each data element
|
| Report 0 if there are no students that meet the reporting criteria for the data element |
| In the question detail screen, an override column will be next to the results with a text box to select a value |
Detail Report Logic will display the following information:
|
COUR-9b: High School Students who Passed Algebra 1 - Grades 11 & 12
Click here to expand...
Category Mapping: Grade Levels, Algebra I - High School, Regular School Year IDEA Students, Regular School Year EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| COUR9b.1, COUR9b.2, COUR9b.3 | Hispanic or Latino of any race | SCH_ALGPASS_GS1112_HI_M | SCH_ALGPASS_GS1112_HI_F | SCH_ALGPASS_GS1112_HI_X | |
| COUR9b.4, COUR9b.5, COUR9b.6 | American Indian or Alaska Native | SCH_ALGPASS_GS1112_AM_M | SCH_ALGPASS_GS1112_AM_F | SCH_ALGPASS_GS1112_AM_X | |
| COUR9b.7, COUR9b.8, COUR9b.9 | Asian | SCH_ALGPASS_GS1112_AS_M | SCH_ALGPASS_GS1112_AS_F | SCH_ALGPASS_GS1112_AS_X | |
| COUR9b.10, COUR9b.11, COUR9b.12 | Native Hawaiian or Other Pacific Islander | SCH_ALGPASS_GS1112_HP_M | SCH_ALGPASS_GS1112_HP_F | SCH_ALGPASS_GS1112_HP_X | |
| COUR9b.13, COUR9b.14, COUR9b.15 | Black or African American | SCH_ALGPASS_GS1112_BL_M | SCH_ALGPASS_GS1112_BL_F | SCH_ALGPASS_GS1112_BL_X | |
| COUR9b.16, COUR9b.17, COUR9b.18 | White | SCH_ALGPASS_GS1112_WH_M | SCH_ALGPASS_GS1112_WH_F | SCH_ALGPASS_GS1112_WH_X | |
| COUR9b.19, COUR9b.20, COUR9b.21 | Two or More races | SCH_ALGPASS_GS1112_TR_M | SCH_ALGPASS_GS1112_TR_F | SCH_ALGPASS_GS1112_TR_X | |
| Total | |||||
| COUR9b.22, COUR9b.23, COUR9b.24 | English Learners (EL) | SCH_ALGPASS_GS1112_EL_M | SCH_ALGPASS_GS1112_EL_F | SCH_ALGPASS_GS1112_EL_X | |
| COUR9b.25, COUR9b.26, COUR9b.27 | Students with Disabilities (IDEA) | SCH_ALGPASS_GS1112_IDEA_M | SCH_ALGPASS_GS1112_IDEA_F | SCH_ALGPASS_GS1112_IDEA_X | |
| Logic |
|---|
Report the distinct total number of students who passed Algebra I in Grades 11 or 12. Only students who were included in the total for COUR-9a can be reported in this question.
|
The student must have a passing score in at least 1 Algebra I course based on the Passing Score Indicator identified on the Algebra I - High School category mapping
|
| Report 0 if there are no students that meet the reporting criteria |
| Report NULL if the answer to question COUR-9a is '0' |
| In the question detail screen, an override column will be next to the results with a text box to select a value |
The user will be able to select a link on a result and a side panel will display the eligible students
|
Detail Report Logic will display the following information:
|
COUR-10: Student Enrollment in Mathemantics Courses in High School - Geometry
Click here to expand...
Category Mapping: Grade Levels, Geometry - High School, Fall Snapshot IDEA Students, Fall Snapshot EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| COUR10.1, COUR10.2, COUR10.3 | Hispanic or Latino of any race | SCH_MATHENR_GEOM_HI_M | SCH_MATHENR_GEOM_HI_F | SCH_MATHENR_GEOM_HI_X | |
| COUR10.4, COUR10.5, COUR10.6 | American Indian or Alaska Native | SCH_MATHENR_GEOM_AM_M | SCH_MATHENR_GEOM_AM_F | SCH_MATHENR_GEOM_AM_X | |
| COUR10.7, COUR10.8, COUR10.9 | Asian | SCH_MATHENR_GEOM_AS_M | SCH_MATHENR_GEOM_AS_F | SCH_MATHENR_GEOM_AS_X | |
| COUR10.10, COUR10.11, COUR10.12 | Native Hawaiian or Other Pacific Islander | SCH_MATHENR_GEOM_HP_M | SCH_MATHENR_GEOM_HP_F | SCH_MATHENR_GEOM_HP_X | |
| COUR10.13, COUR10.14, COUR10.15 | Black or African American | SCH_MATHENR_GEOM_BL_M | SCH_MATHENR_GEOM_BL_F | SCH_MATHENR_GEOM_BL_X | |
| COUR10.16, COUR10.17, COUR10.18 | White | SCH_MATHENR_GEOM_WH_M | SCH_MATHENR_GEOM_WH_F | SCH_MATHENR_GEOM_WH_X | |
| COUR10.19, COUR10.20, COUR10.21 | Two or More races | SCH_MATHENR_GEOM_TR_M | SCH_MATHENR_GEOM_TR_F | SCH_MATHENR_GEOM_TR_X | |
| Total | |||||
| COUR10.22, COUR10.23, COUR10.24 | English Learners (EL) | SCH_MATHENR_GEOM_EL_M | SCH_MATHENR_GEOM_EL_F | SCH_MATHENR_GEOM_EL_X | |
| COUR10.25, COUR10.26, COUR10.27 | Students with Disabilities (IDEA) | SCH_MATHENR_GEOM_IDEA_M | SCH_MATHENR_GEOM_IDEA_F | SCH_MATHENR_GEOM_IDEA_X | |
| Logic |
|---|
Report the total number of distinct students enrolled in Geometry in Grades 9, 10, 11 or 12 for each data element
|
| Report 0 if there are no students that meet the reporting criteria for the data element |
| Report NULL if the answer for question COUR-7, Geometry is '0' |
| In the question detail screen, an override column will be next to the results with a text box to select a value |
Detail Report Logic will display the following information:
|
COUR-11: Student Enrollment in Mathematics Courses in High School - Algebra II
Click here to expand...
Category Mapping: Grade Levels, Algebra II, Fall Snapshot date IDEA Students, Fall Snapshot date EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| COUR11.1, COUR11.2, COUR11.3 | Hispanic or Latino of any race | SCH_MATHENR_ALG2_HI_M | SCH_MATHENR_ALG2_HI_F | SCH_MATHENR_ALG2_HI_X | |
| COUR11.4, COUR11.5, COUR11.6 | American Indian or Alaska Native | SCH_MATHENR_ALG2_AM_M | SCH_MATHENR_ALG2_AM_F | SCH_MATHENR_ALG2_AM_X | |
| COUR11.7, COUR11.8, COUR11.9 | Asian | SCH_MATHENR_ALG2_AS_M | SCH_MATHENR_ALG2_AS_F | SCH_MATHENR_ALG2_AS_X | |
| COUR11.10, COUR11.11, COUR11.12 | Native Hawaiian or Other Pacific Islander | SCH_MATHENR_ALG2_HP_M | SCH_MATHENR_ALG2_HP_F | SCH_MATHENR_ALG2_HP_X | |
| COUR11.13, COUR11.14, COUR11.15 | Black or African American | SCH_MATHENR_ALG2_BL_M | SCH_MATHENR_ALG2_BL_F | SCH_MATHENR_ALG2_BL_X | |
| COUR11.16, COUR11.17, COUR11.18 | White | SCH_MATHENR_ALG2_WH_M | SCH_MATHENR_ALG2_WH_F | SCH_MATHENR_ALG2_WH_X | |
| COUR11.19, COUR11.20, COUR11.21 | Two or More races | SCH_MATHENR_ALG2_TR_M | SCH_MATHENR_ALG2_TR_F | SCH_MATHENR_ALG2_TR_X | |
| Total | |||||
| COUR11.22, COUR11.23, COUR11.24 | English Learners (EL) | SCH_MATHENR_ALG2_EL_M | SCH_MATHENR_ALG2_EL_F | SCH_MATHENR_ALG2_EL_X | |
| COUR11.25, COUR11.26, COUR11.27 | Students with Disabilities (IDEA) | SCH_MATHENR_ALG2_IDEA_M | SCH_MATHENR_ALG2_IDEA_F | SCH_MATHENR_ALG2_IDEA_X | |
| Logic |
|---|
Report the total number of distinct students enrolled in Algebra II in Grades 9, 10, 11 or 12 for each data element
|
| Report 0 if there are no students that meet the reporting criteria for the data element |
| Report NULL if the answer for question COUR-7, Algebra II is '0' |
| In the question detail screen, an override column will be next to the results with a text box to select a value |
Detail Report Logic will display the following information:
|
COUR-12: Student Enrollment in Mathematics Courses in High School - Advanced Mathematics
Click here to expand...
Category Mapping: Grade Levels, Advanced Mathematics, Fall Snapshot date IDEA Students, Fall Snapshot date EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| COUR12.1, COUR12.2, COUR12.3 | Hispanic or Latino of any race | SCH_MATHENR_ADVM_HI_M | SCH_MATHENR_ADVM_HI_F | SCH_MATHENR_ADVM_HI_X | |
| COUR12.4, COUR12.5, COUR12.6 | American Indian or Alaska Native | SCH_MATHENR_ADVM_AM_M | SCH_MATHENR_ADVM_AM_F | SCH_MATHENR_ADVM_AM_X | |
| COUR12.7, COUR12.8, COUR12.9 | Asian | SCH_MATHENR_ADVM_AS_M | SCH_MATHENR_ADVM_AS_F | SCH_MATHENR_ADVM_AS_X | |
| COUR12.10, COUR12.11, COUR12.12 | Native Hawaiian or Other Pacific Islander | SCH_MATHENR_ADVM_HP_M | SCH_MATHENR_ADVM_HP_F | SCH_MATHENR_ADVM_HP_X | |
| COUR12.13, COUR12.14, COUR12.15 | Black or African American | SCH_MATHENR_ADVM_BL_M | SCH_MATHENR_ADVM_BL_F | SCH_MATHENR_ADVM_BL_X | |
| COUR12.16, COUR12.17, COUR12.18 | White | SCH_MATHENR_ADVM_WH_M | SCH_MATHENR_ADVM_WH_F | SCH_MATHENR_ADVM_WH_X | |
| COUR12.19, COUR12.20, COUR12.21 | Two or More races | SCH_MATHENR_ADVM_TR_M | SCH_MATHENR_ADVM_TR_F | SCH_MATHENR_ADVM_TR_X | |
| Total | |||||
| COUR12.22, COUR12.23, COUR12.24 | English Learners (EL) | SCH_MATHENR_ADVM_EL_M | SCH_MATHENR_ADVM_EL_F | SCH_MATHENR_ADVM_EL_X | |
| COUR12.25, COUR12.26, COUR12.27 | Students with Disabilities (IDEA) | SCH_MATHENR_ADVM_IDEA_M | SCH_MATHENR_ADVM_IDEA_F | SCH_MATHENR_ADVM_IDEA_X | |
| Logic |
|---|
Report the total number of distinct students enrolled in Advanced Mathematics in Grades 9, 10, 11 or 12 for each data element
|
| Report 0 if there are no students that meet the reporting criteria for the data element |
| Report NULL if the answer for question COUR-7, Advanced Mathematics is '0' |
| In the question detail screen, an override column will be next to the results with a text box to select a value |
Detail Report Logic will display the following information:
|
COUR-13: Student Enrollment in Mathematics Courses in High School - Algebra II
Click here to expand...
Category Mapping: Grade Levels, Calculus, Fall Snapshot IDEA Students, Fall Snapshot EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| COUR13.1, COUR13.2, COUR13.3 | Hispanic or Latino of any race | SCH_MATHENR_CALC_HI_M | SCH_MATHENR_CALC_HI_F | SCH_MATHENR_CALC_HI_X | |
| COUR13.4, COUR13.5, COUR13.6 | American Indian or Alaska Native | SCH_MATHENR_CALC_AM_M | SCH_MATHENR_CALC_AM_F | SCH_MATHENR_CALC_AM_X | |
| COUR13.7, COUR13.8, COUR13.9 | Asian | SCH_MATHENR_CALC_AS_M | SCH_MATHENR_CALC_AS_F | SCH_MATHENR_CALC_AS_X | |
| COUR13.10, COUR13.11, COUR13.12 | Native Hawaiian or Other Pacific Islander | SCH_MATHENR_CALC_HP_M | SCH_MATHENR_CALC_HP_F | SCH_MATHENR_CALC_HP_X | |
| COUR13.13, COUR13.14, COUR13.15 | Black or African American | SCH_MATHENR_CALC_BL_M | SCH_MATHENR_CALC_BL_F | SCH_MATHENR_CALC_BL_X | |
| COUR13.16, COUR13.17, COUR13.18 | White | SCH_MATHENR_CALC_WH_M | SCH_MATHENR_CALC_WH_F | SCH_MATHENR_CALC_WH_X | |
| COUR13.19, COUR13.20, COUR13.21 | Two or More races | SCH_MATHENR_CALC_TR_M | SCH_MATHENR_CALC_TR_F | SCH_MATHENR_CALC_TR_ | |
| Total | |||||
| COUR13.22, COUR13.23, COUR13.24 | English Learners (EL) | SCH_MATHENR_CALC_EL_M | SCH_MATHENR_CALC_EL_F | SCH_MATHENR_CALC_EL_X | |
| COUR13.25, COUR13.26, COUR13.27 | Students with Disabilities (IDEA) | SCH_MATHENR_CALC_IDEA_M | SCH_MATHENR_CALC_IDEA_F | SCH_MATHENR_CALC_IDEA_X | |
| Logic |
|---|
Report the total number of distinct students enrolled in Calculus in Grades 9, 10, 11 or 12 for each data element
|
| Report 0 if there are no students that meet the reporting criteria for the data element |
| Report NULL if the answer for question COUR-7, Calculus is '0' |
| In the question detail screen, an override column will be next to the results with a text box to select a value |
Detail Report Logic will display the following information:
|
COUR-14: Classes in Science Courses
Click here to expand...
Category Mapping: Biology, Chemistry, Physics
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | ||
Layout | Element Name | Data Element |
|---|---|---|
| COUR-14.1 | SCH_SCICLASSES_BIOL | Number of Biology Classes |
| COUR-14.2 | SCH_SCICLASSES_CHEM | Number of Chemistry Classes |
| COUR-14.3 | SCH_SCICLASSES_PHYS | Number of Physics Classes |
| Logic |
|---|
Count and display the total number of Biology, Chemistry & Physics courses for the data element listed
|
| In the question detail screen, an override column will be next to the results with a text box to enter in values |
Detail Report Logic will display the following information:
|
COUR-15: Student Enrollment in Science Courses - Biology
Click here to expand...
Category Mapping: Grade Levels, Biology, Fall Snapshot IDEA Students, Fall Snapshot EL Students
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| COUR15.1, COUR15.2, COUR15.3 | Hispanic or Latino of any race | SCH_SCIENR_BIOL_HI_M | SCH_SCIENR_BIOL_HI_F | SCH_SCIENR_BIOL_HI_X | |
| COUR15.4, COUR15.5, COUR15.6 | American Indian or Alaska Native | SCH_SCIENR_BIOL_AM_M | SCH_SCIENR_BIOL_AM_F | SCH_SCIENR_BIOL_AM_X | |
| COUR15.7, COUR15.8, COUR15.9 | Asian | SCH_SCIENR_BIOL_AS_M | SCH_SCIENR_BIOL_AS_F | SCH_SCIENR_BIOL_AS_X | |
| COUR15.10, COUR15.11, COUR15.12 | Native Hawaiian or Other Pacific Islander | SCH_SCIENR_BIOL_HP_M | SCH_SCIENR_BIOL_HP_F | SCH_SCIENR_BIOL_HP_X | |
| COUR15.13, COUR15.14, COUR15.15 | Black or African American | SCH_SCIENR_BIOL_BL_M | SCH_SCIENR_BIOL_BL_F | SCH_SCIENR_BIOL_BL_X | |
| COUR15.16, COUR15.17, COUR15.18 | White | SCH_SCIENR_BIOL_WH_M | SCH_SCIENR_BIOL_WH_F | SCH_SCIENR_BIOL_WH_X | |
| COUR15.19, COUR15.20, COUR15.21 | Two or More races | SCH_SCIENR_BIOL_TR_M | SCH_SCIENR_BIOL_TR_F | SCH_SCIENR_BIOL_TR_X | |
| Total | |||||
| COUR15.22, COUR15.23, COUR15.24 | English Learners (EL) | SCH_SCIENR_BIOL_EL_M | SCH_SCIENR_BIOL_EL_F | SCH_SCIENR_BIOL_EL_X | |
| COUR15.25, COUR15.26, COUR15.27 | Students with Disabilities (IDEA) | SCH_SCIENR_BIOL_IDEA_M | SCH_SCIENR_BIOL_IDEA_F | SCH_SCIENR_BIOL_IDEA_X | |
| Logic |
|---|
Report the total number of distinct students enrolled in Biology in Grades 9, 10, 11 or 12 for each data element
|
| Report 0 if there are no students that meet the reporting criteria for the data element |
| Report NULL if the answer for question COUR-14, Biology is '0' |
| In the question detail screen, an override column will be next to the results with a text box to select a value |
Detail Report Logic will display the following information:
|
COUR-16: Student Enrollment in Science Courses - Chemistry
Click here to expand...
Category Mapping: Grade Levels, Chemistry, Fall Snapshot IDEA Students, Fall Snapshot EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| COUR16.1, COUR16.2, COUR16.3 | Hispanic or Latino of any race | SCH_SCIENR_CHEM_HI_M | SCH_SCIENR_CHEM_HI_F | SCH_SCIENR_CHEM_AM_X | |
| COUR16.4, COUR16.5, COUR16.6 | American Indian or Alaska Native | SCH_SCIENR_CHEM_AM_M | SCH_SCIENR_CHEM_AM_F | SCH_SCIENR_CHEM_AM_X | |
| COUR16.7, COUR16.8, COUR16.9 | Asian | SCH_SCIENR_CHEM_AS_M | SCH_SCIENR_CHEM_AS_F | SCH_SCIENR_CHEM_AS_X | |
| COUR16.10, COUR16.11, COUR16.12 | Native Hawaiian or Other Pacific Islander | SCH_SCIENR_CHEM_HP_M | SCH_SCIENR_CHEM_HP_F | SCH_SCIENR_CHEM_HP_X | |
| COUR16.13, COUR16.14, COUR16.15 | Black or African American | SCH_SCIENR_CHEM_BL_M | SCH_SCIENR_CHEM_BL_F | SCH_SCIENR_CHEM_BL_X | |
| COUR16.16, COUR16.17, COUR16.18 | White | SCH_SCIENR_CHEM_WH_M | SCH_SCIENR_CHEM_WH_F | SCH_SCIENR_CHEM_WH_X | |
| COUR16.19, COUR16.20, COUR16.21 | Two or More races | SCH_SCIENR_CHEM_TR_M | SCH_SCIENR_CHEM_TR_F | SCH_SCIENR_CHEM_TR_X | |
| Total | |||||
| COUR16.22, COUR16.23, COUR16.24 | English Learners (EL) | SCH_SCIENR_CHEM_EL_M | SCH_SCIENR_CHEM_EL_F | SCH_SCIENR_CHEM_EL_X | |
| COUR16.25, COUR16.26, COUR16.27 | Students with Disabilities (IDEA) | SCH_SCIENR_CHEM_IDEA_M | SCH_SCIENR_CHEM_IDEA_F | SCH_SCIENR_CHEM_IDEA_X | |
| Logic |
|---|
Report the total number of distinct students enrolled in Chemistry in Grades 9, 10, 11 or 12 for each data element
|
| Report 0 if there are no students that meet the reporting criteria for the data element |
| Report NULL if the answer for question COUR-14, Chemistry is '0' |
| In the question detail screen, an override column will be next to the results with a text box to select a value |
Detail Report Logic will display the following information:
|
COUR-17: Student Enrollment in Science Courses - Physics
Click here to expand...
Category Mapping: Grade Levels, Physics, Fall Snapshot IDEA Students, Fall Snapshot EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| COUR17.1, COUR17.2, COUR17.3 | Hispanic or Latino of any race | SCH_SCIENR_PHYS_HI_M | SCH_SCIENR_PHYS_HI_F | SCH_SCIENR_PHYS_HI_X | |
| COUR17.4, COUR17.5, COUR17.6 | American Indian or Alaska Native | SCH_SCIENR_PHYS_AM_M | SCH_SCIENR_PHYS_AM_F | SCH_SCIENR_PHYS_AM_X | |
| COUR17.7, COUR17.8, COUR17.9 | Asian | SCH_SCIENR_PHYS_AS_M | SCH_SCIENR_PHYS_AS_F | SCH_SCIENR_PHYS_AS_X | |
| COUR17.10, COUR17.11, COUR17.12 | Native Hawaiian or Other Pacific Islander | SCH_SCIENR_PHYS_HP_M | SCH_SCIENR_PHYS_HP_F | SCH_SCIENR_PHYS_HP_X | |
| COUR17.13, COUR17.14, COUR17.15 | Black or African American | SCH_SCIENR_PHYS_BL_M | SCH_SCIENR_PHYS_BL_F | SCH_SCIENR_PHYS_BL_X | |
| COUR17.16, COUR17.17, COUR17.18 | White | SCH_SCIENR_PHYS_WH_M | SCH_SCIENR_PHYS_WH_F | SCH_SCIENR_PHYS_WH_X | |
| COUR17.19, COUR17.20, COUR17.21 | Two or More races | SCH_SCIENR_PHYS_TR_M | SCH_SCIENR_PHYS_TR_F | SCH_SCIENR_PHYS_TR_X | |
| Total | |||||
| COUR17.22, COUR17.23, COUR17.24 | English Learners (EL) | SCH_SCIENR_PHYS_EL_M | SCH_SCIENR_PHYS_EL_F | SCH_SCIENR_PHYS_EL_X | |
| COUR17.25, COUR17.26, COUR17.27 | Students with Disabilities (IDEA) | SCH_SCIENR_PHYS_IDEA_M | SCH_SCIENR_PHYS_IDEA_F | SCH_SCIENR_PHYS_IDEA_X | |
| Logic |
|---|
Report the total number of distinct students enrolled in Physics in Grades 9, 10, 11 or 12 for each data element
|
| Report 0 if there are no students that meet the reporting criteria for the data element |
| Report NULL if the answer for question COUR-14, Physics is '0' |
| In the question detail screen, an override column will be next to the results with a text box to select a value |
Detail Report Logic will display the following information:
|
COUR-18: Classes in Computer Science Courses
Click here to expand...
Category Mapping: Computer Science
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | ||
Layout | Element Name | Data Element |
|---|---|---|
| COUR18.1 | SCH_COMPCLASSES_CSCI | Classes in Computer Science Courses |
| Logic |
|---|
Count and display the total number of Computer Science courses for the data element listed
|
| In the question detail screen, an override column will be next to the results with a text box to enter in values |
Detail Report Logic will display the following information:
|
COUR19: Student Enrollment in Computer Science Courses
Click here to expand...
Category Mapping: Grade Levels, Computer Science, Fall Snapshot IDEA Students, Fall Snapshot EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| COUR19.1, COUR19.2, COUR19.3 | Hispanic or Latino of any race | SCH_COMPENR_CSCI_HI_M | SCH_COMPENR_CSCI_HI_F | SCH_COMPENR_CSCI_HI_X | |
| COUR19.4, COUR19.5, COUR19.6 | American Indian or Alaska Native | SCH_COMPENR_CSCI_AM_M | SCH_COMPENR_CSCI_AM_F | SCH_COMPENR_CSCI_AM_X | |
| COUR19.7, COUR19.8, COUR19.9 | Asian | SCH_COMPENR_CSCI_AS_M | SCH_COMPENR_CSCI_AS_F | SCH_COMPENR_CSCI_AS_X | |
| COUR19.10, COUR19.11, COUR19.12 | Native Hawaiian or Other Pacific Islander | SCH_COMPENR_CSCI_HP_M | SCH_COMPENR_CSCI_HP_F | SCH_COMPENR_CSCI_HP_X | |
| COUR19.13, COUR19.14, COUR19.15 | Black or African American | SCH_COMPENR_CSCI_BL_M | SCH_COMPENR_CSCI_BL_F | SCH_COMPENR_CSCI_BL_X | |
| COUR19.16, COUR19.17, COUR19.18 | White | SCH_COMPENR_CSCI_WH_M | SCH_COMPENR_CSCI_WH_F | SCH_COMPENR_CSCI_WH_X | |
| COUR19.19, COUR19.20, COUR19.21 | Two or More races | SCH_COMPENR_CSCI_TR_M | SCH_COMPENR_CSCI_TR_F | SCH_COMPENR_CSCI_TR_X | |
| Total | |||||
| COUR19.22, COUR19.23, COUR19.24 | English Learners (EL) | SCH_COMPENR_CSCI_EL_M | SCH_COMPENR_CSCI_EL_F | SCH_COMPENR_CSCI_EL_X | |
| COUR19.25, COUR19.26, COUR19.27 | Students with Disabilities (IDEA) | SCH_COMPENR_CSCI_IDEA_M | SCH_COMPENR_CSCI_IDEA_F | SCH_COMPENR_CSCI_IDEA_X | |
| Logic |
|---|
Report the total number of distinct students enrolled in Computer Science in Grades 9, 10, 11 or 12 for each data element
|
| Report 0 if there are no students that meet the reporting criteria for the data element |
| Report NULL if the answer for question COUR-18, is '0' |
| In the question detail screen, an override column will be next to the results with a text box to select a value |
Detail Report Logic will display the following information:
|
COUR-20: Classes in Data Science Courses
Click here to expand...
Category Mapping: Data Science
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | ||
Layout | Element Name | Data Element |
|---|---|---|
| COUR20.1 | SCH_DATACLASSES_DSCI | Classes in Data Science Courses |
| Logic |
|---|
Count and display the total number of Data Science courses for the data element listed
|
| In the question detail screen, an override column will be next to the results with a text box to enter in values |
Detail Report Logic will display the following information:
|
COUR-21: Student Enrollment in Data Science Courses
Click here to expand...
Category Mapping: Grade Levels, Data Science, Fall Snapshot IDEA Students, Fall Snapshot EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| COUR21.1, COUR21.2, COUR21.3 | Hispanic or Latino of any race | SCH_DATAENR_DSCI_HI_M | SCH_DATAENR_DSCI_HI_F | SCH_DATAENR_DSCI_HI_X | |
| COUR21.4, COUR21.5, COUR21.6 | American Indian or Alaska Native | SCH_DATAENR_DSCI_AM_M | SCH_DATAENR_DSCI_AM_F | SCH_DATAENR_DSCI_AM_X | |
| COUR21.7, COUR21.8, COUR21.9 | Asian | SCH_DATAENR_DSCI_AS_M | SCH_DATAENR_DSCI_AS_F | SCH_DATAENR_DSCI_AS_X | |
| COUR21.10, COUR21.11, COUR21.12 | Native Hawaiian or Other Pacific Islander | SCH_DATAENR_DSCI_HP_M | SCH_DATAENR_DSCI_HP_F | SCH_DATAENR_DSCI_HP_X | |
| COUR21.13, COUR21.14, COUR21.15 | Black or African American | SCH_DATAENR_DSCI_BL_M | SCH_DATAENR_DSCI_BL_F | SCH_DATAENR_DSCI_BL_X | |
| COUR21.16, COUR21.17, COUR21.18 | White | SCH_DATAENR_DSCI_WH_M | SCH_DATAENR_DSCI_WH_F | SCH_DATAENR_DSCI_WH_X | |
| COUR21.19, COUR21.20, COUR21.21 | Two or More races | SCH_DATAENR_DSCI_TR_M | SCH_DATAENR_DSCI_TR_F | SCH_DATAENR_DSCI_TR_X | |
| Total | |||||
| COUR21.22, COUR21.23, COUR21.24 | English Learners (EL) | SCH_DATAENR_DSCI_EL_M | SCH_DATAENR_DSCI_EL_F | SCH_DATAENR_DSCI_EL_X | |
| COUR21.25, COUR21.26, COUR21.27 | Students with Disabilities (IDEA) | SCH_DATAENR_DSCI_IDEA_M | SCH_DATAENR_DSCI_IDEA_F | SCH_DATAENR_DSCI_IDEA_X | |
| Logic |
|---|
Report the total number of distinct students enrolled in Data Science in Grades 9, 10, 11 or 12 for each data element
|
| Report 0 if there are no students that meet the reporting criteria for the data element |
| Report NULL if the answer for question COUR-20, is '0' |
| In the question detail screen, an override column will be next to the results with a text box to select a value |
Detail Report Logic will display the following information:
|
COUR-22: Singe-Sex Academic Classes Indicator
Click here to expand...
Category Mapping: N/A
The results for this question are not calculated by the CRDC tool. Enter an override value to report this question in the flat file.
Flat File Details:
Permitted Values: Yes, No, NULL Length of Permitted Values: 3 | ||
Layout | Element Name | Data Element |
|---|---|---|
| COUR22.1 | SCH_SSCLASSES_IND | Whether the school had any students enrolled in one or more single-sex academic classes |
| Logic |
|---|
The results column will not show but the user can enter an override
|
COUR-23: Single-Sex Academic Classes Detail
Click here to expand...
Instructions: (Only for co-educational schools, grades K-12, UG with single-sex classes)
This table is about CLASSES. For the Fall 2023 snapshot date, enter the number of single-sex academic classes in each course or subject area that had one or more students in grades K-12 (or the ungraded equivalent) enrolled.
- Report classes that cover the content of the courses outlined in the definitions, regardless of the course name.
- Count classes, not courses.
- Enter the total count of classes, not the enrollment of students in those classes.
- Include only classes that exclude students of one sex from enrolling or otherwise participating in that class because of their sex.
- Include classes in Advanced Placement courses and International Baccalaureate Diploma Programme courses.
- If the school has students who receive all of their academic instruction from one teacher in one single-sex classroom, then each academic subject area taught in the classroom is considered one single-sex class. For example, a co-educational elementary school that has male students who receive mathematics, science, reading/language arts and social studies instruction from one teacher in one single-sex classroom should consider each subject area a single-sex class.
- A physical education class is not considered an academic class.
- For schools that use regular scheduling, the count should be based on October 1 (or the closest school day to October 1).
- For schools that use block scheduling that allows a full-year course to be taken in one semester, the count should be based on the sum of a count taken on October 1 (or the closest school day to October 1) in the first block, and around March 1 in the second block.
Additional instructions left out of Question UI due to 2000 character max
- Mathematics includes general mathematics courses as well as college-preparatory mathematics courses such as Algebra I, Geometry, and Algebra II.
- English/reading/language arts includes general English/reading/language arts courses as well as college-preparatory English/reading/language arts courses.
- Science includes general science courses as well as college-preparatory science courses such as Biology, Chemistry, and Physics.
- “Other academic subjects” includes history, social studies, foreign languages, and computer science.
Category Mapping: N/A
The results for this question are not calculated by the CRDC tool. Enter an override value to report this question in the flat file.
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||
Layout | Element Name | Data Element 1 | Data Element 2 |
|---|---|---|---|
| COUR23.1 | SCH_SSCLASSES_MATH_M | Male | Mathematics |
| COUR23.2 | SCH_SSCLASSES_MATH_F | Female | Mathematics |
| COUR23.3 | SCH_SSCLASSES_SCI_M | Male | Science |
| COUR23.4 | SCH_SSCLASSES_SCI_F | Female | Science |
| COUR23.5 | SCH_SSCLASSES_ENGL_M | Male | English/Reading/Language Arts |
| COUR23.6 | SCH_SSCLASSES_ENGL_F | Female | English/Reading/Language Arts |
| COUR23.7 | SCH_SSCLASSES_OTHA_M | Male | Other Academic Subjects |
| COUR23.8 | SCH_SSCLASSES_OTHA_F | Female | Other Academic Subjects |
| Total | |||
| Logic |
|---|
The results column will not show but the user can enter an override
|
9. EXAM: SAT/ACT
EXAM-1: Student Participation in the SAT Reasoning Test or ACT
Click here to expand...
Category Mapping: Grade Levels, Regular School Year IDEA Students, Regular School Year EL Students
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| EXAM1.1, EXAM1.2, EXAM1.3 | Hispanic or Latino of any race | SCH_SATACT_HI_M | SCH_SATACT_HI_F | SCH_SATACT_HI_X | |
| EXAM1.4, EXAM1.5, EXAM1.6 | American Indian or Alaska Native | SCH_SATACT_AM_M | SCH_SATACT_AM_F | SCH_SATACT_AM_X | |
| EXAM1.7, EXAM1.8, EXAM1.9 | Asian | SCH_SATACT_AS_M | SCH_SATACT_AS_F | SCH_SATACT_AS_X | |
| EXAM1.10, EXAM1.11, EXAM1.12 | Native Hawaiian or Other Pacific Islander | SCH_SATACT_HP_M | SCH_SATACT_HP_F | SCH_SATACT_HP_X | |
| EXAM1.13, EXAM1.14, EXAM1.15 | Black or African American | SCH_SATACT_BL_M | SCH_SATACT_BL_F | SCH_SATACT_BL_X | |
| EXAM1.16, EXAM1.17, EXAM1.18 | White | SCH_SATACT_WH_M | SCH_SATACT_WH_F | SCH_SATACT_WH_X | |
| EXAM1.19, EXAM1.20, EXAM1.21 | Two or More races | SCH_SATACT_TR_M | SCH_SATACT_TR_F | SCH_SATACT_TR_X | |
| Total | |||||
| EXAM1.22, EXAM1.23, EXAM1.24 | English Learners (EL) | SCH_SATACT_EL_M | SCH_SATACT_EL_F | SCH_SATACT_EL_X | |
| EXAM1.25, EXAM1.26, EXAM1.27 | Students with Disabilities (IDEA) | SCH_SATACT_IDEA_M | SCH_SATACT_IDEA_F | SCH_SATACT_IDEA_X | |
| Logic |
|---|
Report the distinct total number of students who took the SAT Reasoning Test (SAT), ACT Test (ACT) or both.
|
| Report 0 if there are no students that meet the reporting criteria |
| In the question detail screen, an override column will be next to the results with a text box to select a value |
Detail Report Logic will display the following information:
|
12. RETN: Retention
RETN-1: Student Retention Indicator
Click here to expand...
Category Mapping: Grade Levels
Flat File Details:
Permitted Values: Yes, No, NULL Length of Permitted Value: 3 | ||
Layout | Element Name | Data Element |
|---|---|---|
| RETN1.1 | SCH_RET_KG_IND | Kindergarten |
| RETN1.2 | SCH_RET_G01_IND | Grade 1 |
| RETN1.3 | SCH_RET_G02_IND | Grade 2 |
| RETN1.4 | SCH_RET_G03_IND | Grade 3 |
| RETN1.5 | SCH_RET_G04_IND | Grade 4 |
| RETN1.6 | SCH_RET_G05_IND | Grade 5 |
| RETN1.7 | SCH_RET_G06_IND | Grade 6 |
| RETN1.8 | SCH_RET_G07_IND | Grade 7 |
| RETN1.9 | SCH_RET_G08_IND | Grade 8 |
| RETN1.10 | SCH_RET_G09_IND | Grade 9 |
| RETN1.11 | SCH_RET_G10_IND | Grade 10 |
| RETN1.12 | SCH_RET_G11_IND | Grade 11 |
| RETN1.13 | SCH_RET_G12_IND | Grade 12 |
| Logic |
|---|
All CRDC Grade Levels will display with results for each applicable grade:
|
A student will be considered retained when they meet the following criteria:
|
| An override column will be next to the results with a droplist next to each grade level that can be set to Yes, No, NS or NULL |
Detail Report Logic will display the following information:
|
RETN-2 GRK: Retention of Students in Kindergarten
Click here to expand...
Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| RETN2.1, RETN2.2, RETN2.3 | Hispanic or Latino of any race | SCH_RET_KG_HI_M | SCH_RET_KG_HI_F_M | SCH_RET_KG_HI_X | |
| RETN2.4, RETN2.5, RETN2.6 | American Indian or Alaska Native | SCH_RET_KG_AM_M | SCH_RET_KG_AM_M | SCH_RET_KG_AM_X | |
| RETN2.7, RETN2.8, RETN2.9 | Asian | SCH_RET_KG_AS_M | SCH_RET_KG_AS_M | SCH_RET_KG_AS_X | |
| RETN2.10, RETN2.11, RETN2.12 | Native Hawaiian or Other Pacific Islander | SCH_RET_KG_HP_M | SCH_RET_KG_HP_M | SCH_RET_KG_HP_X | |
| RETN2.13, RETN2.14, RETN2.15 | Black or African American | SCH_RET_KG_BL_M | SCH_RET_KG_BL_M | SCH_RET_KG_BL_X | |
| RETN2.16, RETN2.17, RETN2.18 | White | SCH_RET_KG_WH_M | SCH_RET_KG_WH_M | SCH_RET_KG_WH_X | |
| RETN2.19, RETN2.20, RETN2.21 | Two or More races | SCH_RET_KG_TR_M | SCH_RET_KG_TR_M | SCH_RET_KG_TR_X | |
| Total | |||||
| RETN2.22, RETN2.23, RETN2.24 | English Learners (EL) | SCH_RET_KG_EL_M | SCH_RET_KG_EL_M | SCH_RET_KG_EL_X | |
| RETN2.25, RETN2.26, RETN2.27 | Students with Disabilities (IDEA) | SCH_RET_KG_IDEA_M | SCH_RET_KG_IDEA_M | SCH_RET_KG_IDEA_X | |
| RETN2.28, RETN2.29, RETN2.30 | Students with Disabilities (Section 504 Only) | SCH_RET_KG_504_M | SCH_RET_KG_504_M | SCH_RET_KG_504_X | |
| Logic |
|---|
Count the distinct number of students that were retained in each grade level offered by the school
|
A student will be considered retained when they meet the following criteria:
|
| An override column will be next to the results with a text box that users can enter a value. |
Detail Report Logic will display the following information:
|
RETN-2 GR1: Retention of Students in Grade 1
Click here to expand...
Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| RETN2.31, RETN2.32, RETN2.33 | Hispanic or Latino of any race | SCH_RET_G01_HI_M | SCH_RET_G01_HI_F | SCH_RET_G01_HI_X | |
| RETN2.34, RETN2.35, RETN2.36 | American Indian or Alaska Native | SCH_RET_G01_AM_M | SCH_RET_G01_AM_F | SCH_RET_G01_AM_X | |
| RETN2.37, RETN2.38, RETN2.39 | Asian | SCH_RET_G01_AS_M | SCH_RET_G01_AS_F | SCH_RET_G01_AS_X | |
| RETN2.40, RETN2.41, RETN2.42 | Native Hawaiian or Other Pacific Islander | SCH_RET_G01_HP_M | SCH_RET_G01_HP_F | SCH_RET_G01_HP_X | |
| RETN2.43, RETN2.44, RETN2.45 | Black or African American | SCH_RET_G01_BL_M | SCH_RET_G01_BL_F | SCH_RET_G01_BL_X | |
| RETN2.46, RETN2.47, RETN2.48 | White | SCH_RET_G01_WH_M | SCH_RET_G01_WH_F | SCH_RET_G01_WH_X | |
| RETN2.49, RETN2.50, RETN2.51 | Two or More races | SCH_RET_G01_TR_M | SCH_RET_G01_TR_F | SCH_RET_G01_TR_X | |
| Total | |||||
| RETN2.52, RETN2.53, RETN2.54 | English Learners (EL) | SCH_RET_G01_EL_M | SCH_RET_G01_EL_F | SCH_RET_G01_EL_X | |
| RETN2.55, RETN2.56, RETN2.57 | Students with Disabilities (IDEA) | SCH_RET_G01_IDEA_M | SCH_RET_G01_IDEA_F | SCH_RET_G01_IDEA_X | |
| RETN2.58, RETN2.59, RETN2.60 | Students with Disabilities (Section 504 Only) | SCH_RET_G01_504_M | SCH_RET_G01_504_F | SCH_RET_G01_504_X | |
| Logic |
|---|
Count the distinct number of students that were retained in each grade level offered by the school
|
A student will be considered retained when they meet the following criteria:
|
| An override column will be next to the results with a text box that users can enter a value. |
Detail Report Logic will display the following information:
|
RETN-2 GR2: Retention of Students in Grade 2
Click here to expand...
Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| RETN2.61, RETN2.62, RETN2.63 | Hispanic or Latino of any race | SCH_RET_G02_HI_M | SCH_RET_G02_HI_F | SCH_RET_G02_HI_X | |
| RETN2.64, RETN2.65, RETN2.66 | American Indian or Alaska Native | SCH_RET_G02_AM_M | SCH_RET_G02_AM_F | SCH_RET_G02_AM_X | |
| RETN2.67, RETN2.68, RETN2.69 | Asian | SCH_RET_G02_AS_M | SCH_RET_G02_AS_F | SCH_RET_G02_AS_X | |
| RETN2.70, RETN2.71, RETN2.72 | Native Hawaiian or Other Pacific Islander | SCH_RET_G02_HP_M | SCH_RET_G02_HP_F | SCH_RET_G02_HP_X | |
| RETN2.73, RETN2.74, RETN2.75 | Black or African American | SCH_RET_G02_BL_M | SCH_RET_G02_BL_F | SCH_RET_G02_BL_X | |
| RETN2.76, RETN2.77, RETN2.78 | White | SCH_RET_G02_WH_M | SCH_RET_G02_WH_F | SCH_RET_G02_WH_X | |
| RETN2.79, RETN2.80, RETN2.81 | Two or More races | SCH_RET_G02_TR_M | SCH_RET_G02_TR_F | SCH_RET_G02_TR_X | |
| Total | |||||
| RETN2.82, RETN2.83, RETN2.84 | English Learners (EL) | SCH_RET_G02_EL_M | SCH_RET_G02_EL_F | SCH_RET_G02_EL_X | |
| RETN2.85, RETN2.86, RETN2.87 | Students with Disabilities (IDEA) | SCH_RET_G02_IDEA_M | SCH_RET_G02_IDEA_F | SCH_RET_G02_IDEA_X | |
| RETN2.88, RETN2.89, RETN2.90 | Students with Disabilities (Section 504 Only) | SCH_RET_G02_504_M | SCH_RET_G02_504_F | SCH_RET_G02_504_X | |
| Logic |
|---|
Count the distinct number of students that were retained in each grade level offered by the school
|
A student will be considered retained when they meet the following criteria:
|
| An override column will be next to the results with a text box that users can enter a value. |
Detail Report Logic will display the following information:
|
RETN-2 GR3: Retention of Students in Grade 3
Click here to expand...
Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| RETN2.91, RETN2.92, RETN2.93 | Hispanic or Latino of any race | SCH_RET_G03_HI_M | SCH_RET_G03_HI_F | SCH_RET_G03_HI_X | |
| RETN2.94, RETN2.95, RETN2.96 | American Indian or Alaska Native | SCH_RET_G03_AM_M | SCH_RET_G03_AM_F | SCH_RET_G03_AM_X | |
| RETN2.97, RETN2.98, RETN2.99 | Asian | SCH_RET_G03_AS_M | SCH_RET_G03_AS_F | SCH_RET_G03_AS_X | |
| RETN2.100, RETN2.101, RETN2.102 | Native Hawaiian or Other Pacific Islander | SCH_RET_G03_HP_M | SCH_RET_G03_HP_F | SCH_RET_G03_HP_X | |
| RETN2.103 RETN2.104, RETN2.105 | Black or African American | SCH_RET_G03_BL_M | SCH_RET_G03_BL_F | SCH_RET_G03_BL_X | |
| RETN2.106, RETN2.107, RETN2.108 | White | SCH_RET_G03_WH_M | SCH_RET_G03_WH_F | SCH_RET_G03_WH_X | |
| RETN2.109, RETN2.110, RETN2.111 | Two or More races | SCH_RET_G03_TR_M | SCH_RET_G03_TR_F | SCH_RET_G03_TR_X | |
| Total | |||||
| RETN2.112, RETN2.113, RETN2.114 | English Learners (EL) | SCH_RET_G03_EL_M | SCH_RET_G03_EL_F | SCH_RET_G03_EL_X | |
| RETN2.115, RETN2.116, RETN2.117 | Students with Disabilities (IDEA) | SCH_RET_G03_IDEA_M | SCH_RET_G03_IDEA_F | SCH_RET_G03_IDEA_X | |
| RETN2.118, RETN2.119, RETN2.120 | Students with Disabilities (Section 504 Only) | SCH_RET_G03_504_M | SCH_RET_G03_504_F | SCH_RET_G03_504_X | |
| Logic |
|---|
Count the distinct number of students that were retained in each grade level offered by the school
|
A student will be considered retained when they meet the following criteria:
|
| An override column will be next to the results with a text box that users can enter a value. |
Detail Report Logic will display the following information:
|
RETN-2 GR4: Retention of Students in Grade 4
Click here to expand...
Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| RETN2.121, RETN2.122, RETN2.123 | Hispanic or Latino of any race | SCH_RET_G04_HI_M | SCH_RET_G04_HI_F | SCH_RET_G04_HI_X | |
| RETN2.124, RETN2.125, RETN2.126 | American Indian or Alaska Native | SCH_RET_G04_AM_M | SCH_RET_G04_AM_F | SCH_RET_G04_AM_X | |
| RETN2.127, RETN2.128, RETN2.129 | Asian | SCH_RET_G04_AS_M | SCH_RET_G04_AS_F | SCH_RET_G04_AS_X | |
| RETN2.130, RETN2.131, RETN2.132 | Native Hawaiian or Other Pacific Islander | SCH_RET_G04_HP_M | SCH_RET_G04_HP_F | SCH_RET_G04_HP_X | |
| RETN2.133, RETN2.134, RETN2.135 | Black or African American | SCH_RET_G04_BL_M | SCH_RET_G04_BL_F | SCH_RET_G04_BL_X | |
| RETN2.136, RETN2.137, RETN2.138 | White | SCH_RET_G04_WH_M | SCH_RET_G04_WH_F | SCH_RET_G04_WH_X | |
| RETN2.139, RETN2.140, RETN2.141 | Two or More races | SCH_RET_G04_TR_M | SCH_RET_G04_TR_F | SCH_RET_G04_TR_X | |
| Total | |||||
| RETN2.142, RETN2.143, RETN2.144 | English Learners (EL) | SCH_RET_G04_EL_M | SCH_RET_G04_EL_F | SCH_RET_G04_EL_X | |
| RETN2.145, RETN2.146, RETN2.147 | Students with Disabilities (IDEA) | SCH_RET_G04_IDEA_M | SCH_RET_G04_IDEA_F | SCH_RET_G04_IDEA_X | |
| RETN2.148, RETN2.149, RETN2.150 | Students with Disabilities (Section 504 Only) | SCH_RET_G04_504_M | SCH_RET_G04_504_F | SCH_RET_G04_504_X | |
| Logic |
|---|
Count the distinct number of students that were retained in each grade level offered by the school
|
A student will be considered retained when they meet the following criteria:
|
| An override column will be next to the results with a text box that users can enter a value. |
Detail Report Logic will display the following information:
|
RETN-2 GR5: Retention of Students in Grade 5
Click here to expand...
Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| RETN2.151, RETN2.152, RETN2.153 | Hispanic or Latino of any race | SCH_RET_G05_HI_M | SCH_RET_G05_HI_F | SCH_RET_G05_HI_X | |
| RETN2.154, RETN2.155, RETN2.156 | American Indian or Alaska Native | SCH_RET_G05_AM_M | SCH_RET_G05_AM_F | SCH_RET_G05_AM_X | |
| RETN2.157, RETN2.158, RETN2.159 | Asian | SCH_RET_G05_AS_M | SCH_RET_G05_AS_F | SCH_RET_G05_AS_X | |
| RETN2.160, RETN2.161, RETN2.162 | Native Hawaiian or Other Pacific Islander | SCH_RET_G05_HP_M | SCH_RET_G05_HP_F | SCH_RET_G05_HP_X | |
| RETN2.163, RETN2.164, RETN2.165 | Black or African American | SCH_RET_G05_BL_M | SCH_RET_G05_BL_F | SCH_RET_G05_BL_X | |
| RETN2.166, RETN2.167, RETN2.168 | White | SCH_RET_G05_WH_M | SCH_RET_G05_WH_F | SCH_RET_G05_WH_X | |
| RETN2.169, RETN2.170, RETN2.171 | Two or More races | SCH_RET_G05_TR_M | SCH_RET_G05_TR_F | SCH_RET_G05_TR_X | |
| Total | |||||
| RETN2.172, RETN2.173, RETN2.174 | English Learners (EL) | SCH_RET_G05_EL_M | SCH_RET_G05_EL_F | SCH_RET_G05_EL_X | |
| RETN2.175, RETN2.176, RETN2.177 | Students with Disabilities (IDEA) | SCH_RET_G05_IDEA_M | SCH_RET_G05_IDEA_F | SCH_RET_G05_IDEA_X | |
| RETN2.178, RETN2.179, RETN2.180 | Students with Disabilities (Section 504 Only) | SCH_RET_G05_504_M | SCH_RET_G05_504_F | SCH_RET_G05_504_X | |
| Logic |
|---|
Count the distinct number of students that were retained in each grade level offered by the school
|
A student will be considered retained when they meet the following criteria:
|
| An override column will be next to the results with a text box that users can enter a value. |
Detail Report Logic will display the following information:
|
RETN-2 GR6: Retention of Students in Grade 6
Click here to expand...
Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| RETN2.181, RETN2.182, RETN2.183 | Hispanic or Latino of any race | SCH_RET_G06_HI_M | SCH_RET_G06_HI_F | SCH_RET_G06_HI_X | |
| RETN2.184, RETN2.185, RETN2.186 | American Indian or Alaska Native | SCH_RET_G06_AM_M | SCH_RET_G06_AM_F | SCH_RET_G06_AM_X | |
| RETN2.187, RETN2.188, RETN2.189 | Asian | SCH_RET_G06_AS_M | SCH_RET_G06_AS_F | SCH_RET_G06_AS_X | |
| RETN2.190, RETN2.191, RETN2.192 | Native Hawaiian or Other Pacific Islander | SCH_RET_G06_HP_M | SCH_RET_G06_HP_F | SCH_RET_G06_HP_X | |
| RETN2.193, RETN2.194, RETN2.195 | Black or African American | SCH_RET_G06_BL_M | SCH_RET_G06_BL_F | SCH_RET_G06_BL_X | |
| RETN2.196, RETN2.197, RETN2.198 | White | SCH_RET_G06_WH_M | SCH_RET_G06_WH_F | SCH_RET_G06_WH_X | |
| RETN2.199, RETN2.200, RETN2.201 | Two or More races | SCH_RET_G06_TR_M | SCH_RET_G06_TR_F | SCH_RET_G06_TR_X | |
| Total | |||||
| RETN2.202, RETN2.203, RETN2.204 | English Learners (EL) | SCH_RET_G06_EL_M | SCH_RET_G06_EL_F | SCH_RET_G06_EL_X | |
| RETN2.205, RETN2.206, RETN2.207 | Students with Disabilities (IDEA) | SCH_RET_G06_IDEA_M | SCH_RET_G06_IDEA_F | SCH_RET_G06_IDEA_X | |
| RETN2.208, RETN2.209, RETN2.210 | Students with Disabilities (Section 504 Only) | SCH_RET_G06_504_M | SCH_RET_G06_504_F | SCH_RET_G06_504_X | |
| Logic |
|---|
Count the distinct number of students that were retained in each grade level offered by the school
|
A student will be considered retained when they meet the following criteria:
|
| An override column will be next to the results with a text box that users can enter a value. |
Detail Report Logic will display the following information:
|
RETN-2 GR7: Retention of Students in Grade 7
Click here to expand...
Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| RETN2.211, RETN2.212, RETN2.213 | Hispanic or Latino of any race | SCH_RET_G07_HI_M | SCH_RET_G07_HI_F | SCH_RET_G07_HI_X | |
| RETN2.214, RETN2.215, RETN2.216 | American Indian or Alaska Native | SCH_RET_G07_AM_M | SCH_RET_G07_AM_F | SCH_RET_G07_AM_X | |
| RETN2.217, RETN2.218, RETN2.219 | Asian | SCH_RET_G07_AS_M | SCH_RET_G07_AS_F | SCH_RET_G07_AS_X | |
| RETN2.220, RETN2.221, RETN2.222 | Native Hawaiian or Other Pacific Islander | SCH_RET_G07_HP_M | SCH_RET_G07_HP_F | SCH_RET_G07_HP_X | |
| RETN2.223, RETN2.224, RETN2.225 | Black or African American | SCH_RET_G07_BL_M | SCH_RET_G07_BL_F | SCH_RET_G07_BL_X | |
| RETN2.226, RETN2.227, RETN2.228 | White | SCH_RET_G07_WH_M | SCH_RET_G07_WH_F | SCH_RET_G07_WH_X | |
| RETN2.229, RETN2.230, RETN2.231 | Two or More races | SCH_RET_G07_TR_M | SCH_RET_G07_TR_F | SCH_RET_G07_TR_X | |
| Total | |||||
| RETN2.232, RETN2.233, RETN2.234 | English Learners (EL) | SCH_RET_G07_EL_M | SCH_RET_G07_EL_F | SCH_RET_G07_EL_X | |
| RETN2.235, RETN2.236, RETN2.237 | Students with Disabilities (IDEA) | SCH_RET_G07_IDEA_M | SCH_RET_G07_IDEA_F | SCH_RET_G07_IDEA_X | |
| RETN2.238, RETN2.239, RETN2.240 | Students with Disabilities (Section 504 Only) | SCH_RET_G07_504_M | SCH_RET_G07_504_F | SCH_RET_G07_504_X | |
| Logic |
|---|
Count the distinct number of students that were retained in each grade level offered by the school
|
A student will be considered retained when they meet the following criteria:
|
| An override column will be next to the results with a text box that users can enter a value. |
Detail Report Logic will display the following information:
|
RETN-2 GR8: Retention of Students in Grade 8
Click here to expand...
Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| RETN2.241, RETN2.242, RETN2.243 | Hispanic or Latino of any race | SCH_RET_G08_HI_M | SCH_RET_G08_HI_F | SCH_RET_G08_HI_X | |
| RETN2.244, RETN2.245, RETN2.246 | American Indian or Alaska Native | SCH_RET_G08_AM_M | SCH_RET_G08_AM_F | SCH_RET_G08_AM_X | |
| RETN2.247, RETN2.248, RETN2.249 | Asian | SCH_RET_G08_AS_M | SCH_RET_G08_AS_F | SCH_RET_G08_AS_X | |
| RETN2.250, RETN2.251, RETN2.252 | Native Hawaiian or Other Pacific Islander | SCH_RET_G08_HP_M | SCH_RET_G08_HP_F | SCH_RET_G08_HP_X | |
| RETN2.253, RETN2.254, RETN2.255 | Black or African American | SCH_RET_G08_BL_M | SCH_RET_G08_BL_F | SCH_RET_G08_BL_X | |
| RETN2.256, RETN2.257, RETN2.258 | White | SCH_RET_G08_WH_M | SCH_RET_G08_WH_F | SCH_RET_G08_WH_X | |
| RETN2.259, RETN2.260, RETN2.261 | Two or More races | SCH_RET_G08_TR_M | SCH_RET_G08_TR_F | SCH_RET_G08_TR_X | |
| Total | |||||
| RETN2.262, RETN2.263, RETN2.264 | English Learners (EL) | SCH_RET_G08_EL_M | SCH_RET_G08_EL_F | SCH_RET_G08_EL_X | |
| RETN2.265, RETN2.266, RETN2.267 | Students with Disabilities (IDEA) | SCH_RET_G08_IDEA_M | SCH_RET_G08_IDEA_F | SCH_RET_G08_IDEA_X | |
| RETN2.268, RETN2.269, RETN2.270 | Students with Disabilities (Section 504 Only) | SCH_RET_G08_504_M | SCH_RET_G08_504_F | SCH_RET_G08_504_X | |
| Logic |
|---|
Count the distinct number of students that were retained in each grade level offered by the school
|
A student will be considered retained when they meet the following criteria:
|
| An override column will be next to the results with a text box that users can enter a value. |
Detail Report Logic will display the following information:
|
RETN-2 GR9: Retention of Students in Grade 9
Click here to expand...
Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| RETN2.271, RETN2.272, RETN2.273 | Hispanic or Latino of any race | SCH_RET_G09_HI_M | SCH_RET_G09_HI_F | SCH_RET_G09_HI_X | |
| RETN2.274, RETN2.275, RETN2.276 | American Indian or Alaska Native | SCH_RET_G09_AM_M | SCH_RET_G09_AM_F | SCH_RET_G09_AM_X | |
| RETN2.277, RETN2.278, RETN2.279 | Asian | SCH_RET_G09_AS_M | SCH_RET_G09_AS_F | SCH_RET_G09_AS_X | |
| RETN2.280, RETN2.281, RETN2.282 | Native Hawaiian or Other Pacific Islander | SCH_RET_G09_HP_M | SCH_RET_G09_HP_F | SCH_RET_G09_HP_X | |
| RETN2.283, RETN2.284, RETN2.285 | Black or African American | SCH_RET_G09_BL_M | SCH_RET_G09_BL_F | SCH_RET_G09_BL_X | |
| RETN2.286, RETN2.287, RETN2.288 | White | SCH_RET_G09_WH_M | SCH_RET_G09_WH_F | SCH_RET_G09_WH_X | |
| RETN2.289, RETN2.290, RETN2.291 | Two or More races | SCH_RET_G09_TR_M | SCH_RET_G09_TR_F | SCH_RET_G09_TR_X | |
| Total | |||||
| RETN2.292, RETN2.293, RETN2.294 | English Learners (EL) | SCH_RET_G09_EL_M | SCH_RET_G09_EL_F | SCH_RET_G09_EL_X | |
| RETN2.295, RETN2.296, RETN2.297 | Students with Disabilities (IDEA) | SCH_RET_G09_IDEA_M | SCH_RET_G09_IDEA_F | SCH_RET_G09_IDEA_X | |
| RETN2.298, RETN2.299, RETN2.300 | Students with Disabilities (Section 504 Only) | SCH_RET_G09_504_M | SCH_RET_G09_504_F | SCH_RET_G09_504_X | |
| Logic |
|---|
Count the distinct number of students that were retained in each grade level offered by the school
|
A student will be considered retained when they meet the following criteria:
|
| An override column will be next to the results with a text box that users can enter a value. |
Detail Report Logic will display the following information:
|
RETN-2 GR10: Retention of Students in Grade 10
Click here to expand...
Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| RETN2.301, RETN2.302, RETN2.303 | Hispanic or Latino of any race | SCH_RET_G10_HI_M | SCH_RET_G10_HI_F | SCH_RET_G10_HI_X | |
| RETN2.304, RETN2.305, RETN2.306 | American Indian or Alaska Native | SCH_RET_G10_AM_M | SCH_RET_G10_AM_F | SCH_RET_G10_AM_X | |
| RETN2.307, RETN2.308, RETN2.309 | Asian | SCH_RET_G10_AS_M | SCH_RET_G10_AS_F | SCH_RET_G10_AS_X | |
| RETN2.310, RETN2.311, RETN2.312 | Native Hawaiian or Other Pacific Islander | SCH_RET_G10_HP_M | SCH_RET_G10_HP_F | SCH_RET_G10_HP_X | |
| RETN2.313, RETN2.314, RETN2.315 | Black or African American | SCH_RET_G10_BL_M | SCH_RET_G10_BL_F | SCH_RET_G10_BL_X | |
| RETN2.315, RETN2.317, RETN2.318 | White | SCH_RET_G10_WH_M | SCH_RET_G10_WH_F | SCH_RET_G10_WH_X | |
| RETN2.319, RETN2.320, RETN2.321 | Two or More races | SCH_RET_G10_TR_M | SCH_RET_G10_TR_F | SCH_RET_G10_TR_X | |
| Total | |||||
| RETN2.322, RETN2.323, RETN2.324 | English Learners (EL) | SCH_RET_G10_EL_M | SCH_RET_G10_EL_F | SCH_RET_G10_EL_X | |
| RETN2.325, RETN2.326, RETN2.327 | Students with Disabilities (IDEA) | SCH_RET_G10_IDEA_M | SCH_RET_G10_IDEA_F | SCH_RET_G10_IDEA_X | |
| RETN2.328, RETN2.329, RETN2.330 | Students with Disabilities (Section 504 Only) | SCH_RET_G10_504_M | SCH_RET_G10_504_F | SCH_RET_G10_504_X | |
| Logic |
|---|
Count the distinct number of students that were retained in each grade level offered by the school
|
A student will be considered retained when they meet the following criteria:
|
| An override column will be next to the results with a text box that users can enter a value. |
Detail Report Logic will display the following information:
|
RETN-2 GR11: Retention of Students in Grade 11
Click here to expand...
Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| RETN2.331, RETN2.332, RETN2.333 | Hispanic or Latino of any race | SCH_RET_G11_HI_M | SCH_RET_G11_HI_F | SCH_RET_G11_HI_X | |
| RETN2.334, RETN2.335, RETN2.336 | American Indian or Alaska Native | SCH_RET_G11_AM_M | SCH_RET_G11_AM_F | SCH_RET_G11_AM_X | |
| RETN2.337, RETN2.338, RETN2.339 | Asian | SCH_RET_G11_AS_M | SCH_RET_G11_AS_F | SCH_RET_G11_AS_X | |
| RETN2.340, RETN2.341, RETN2.342 | Native Hawaiian or Other Pacific Islander | SCH_RET_G11_HP_M | SCH_RET_G11_HP_F | SCH_RET_G11_HP_X | |
| RETN2.343, RETN2.344, RETN2.345 | Black or African American | SCH_RET_G11_BL_M | SCH_RET_G11_BL_F | SCH_RET_G11_BL_X | |
| RETN2.346, RETN2.347, RETN2.348 | White | SCH_RET_G11_WH_M | SCH_RET_G11_WH_F | SCH_RET_G11_WH_X | |
| RETN2.349, RETN2.350, RETN2.351 | Two or More races | SCH_RET_G11_TR_M | SCH_RET_G11_TR_F | SCH_RET_G11_TR_X | |
| Total | |||||
| RETN2.352, RETN2.353, RETN2.354 | English Learners (EL) | SCH_RET_G11_EL_M | SCH_RET_G11_EL_F | SCH_RET_G11_EL_X | |
| RETN2.355, RETN2.356, RETN2.357 | Students with Disabilities (IDEA) | SCH_RET_G11_IDEA_M | SCH_RET_G11_IDEA_F | SCH_RET_G11_IDEA_X | |
| RETN2.358, RETN2.359, RETN2.360 | Students with Disabilities (Section 504 Only) | SCH_RET_G11_504_M | SCH_RET_G11_504_F | SCH_RET_G11_504_X | |
| Logic |
|---|
Count the distinct number of students that were retained in each grade level offered by the school
|
A student will be considered retained when they meet the following criteria:
|
| An override column will be next to the results with a text box that users can enter a value. |
Detail Report Logic will display the following information:
|
RETN-2 GR12: Retention of Students in Grade 12
Click here to expand...
Category Mapping: Grade Levels, Regular School Year EL, Regular School Year IDEA, Regular School Year 504
Flat File Details:
Permitted Values: Integer, NULL Length of Permitted Values: 7 | |||||
| Layout | Data Element | Male | Female | Nonbinary | Total |
|---|---|---|---|---|---|
| RETN2.361, RETN2.362, RETN2.363 | Hispanic or Latino of any race | SCH_RET_G12_HI_M | SCH_RET_G12_HI_F | SCH_RET_G12_HI_X | |
| RETN2.364, RETN2.365, RETN2.366 | American Indian or Alaska Native | SCH_RET_G12_AM_M | SCH_RET_G12_AM_F | SCH_RET_G12_AM_X | |
| RETN2.367, RETN2.368, RETN2.369 | Asian | SCH_RET_G12_AS_M | SCH_RET_G12_AS_F | SCH_RET_G12_AS_X | |
| RETN2.370, RETN2.371, RETN2.372 | Native Hawaiian or Other Pacific Islander | SCH_RET_G12_HP_M | SCH_RET_G12_HP_F | SCH_RET_G12_HP_X | |
| RETN2.373, RETN2.374, RETN2.375 | Black or African American | SCH_RET_G12_BL_M | SCH_RET_G12_BL_F | SCH_RET_G12_BL_X | |
| RETN2.376, RETN2.377, RETN2.378 | White | SCH_RET_G12_WH_M | SCH_RET_G12_WH_F | SCH_RET_G12_WH_X | |
| RETN2.379, RETN2.380, RETN2.381 | Two or More races | SCH_RET_G12_TR_M | SCH_RET_G12_TR_F | SCH_RET_G12_TR_X | |
| Total | |||||
| RETN2.382, RETN2.383, RETN2.384 | English Learners (EL) | SCH_RET_G12_EL_M | SCH_RET_G12_EL_F | SCH_RET_G12_EL_X | |
| RETN2.385, RETN2.386, RETN2.387 | Students with Disabilities (IDEA) | SCH_RET_G12_IDEA_M | SCH_RET_G12_IDEA_F | SCH_RET_G12_IDEA_X | |
| RETN2.388, RETN2.389, RETN2.390 | Students with Disabilities (Section 504 Only) | SCH_RET_G12_504_M | SCH_RET_G12_504_F | SCH_RET_G12_504_X | |
| Logic |
|---|
Count the distinct number of students that were retained in each grade level offered by the school.
|
A student will be considered retained when they meet the following criteria:
|
| An override column will be next to the results with a text box that users can enter a value. |
Detail Report Logic will display the following information:
|
