This information is specific to South Dakota districts.
Classic Path: SD State Reporting > NCLB Student Data
Search Terms: NCLB Student Data
The No Child Left Behind Student Data report is used by schools to verify or contest Adequate Yearly Progress designations. This report is a snapshot of student data from the time a school's or district's AYP status was determined.
Image 1: NCLB Student Data Extract Editor
Report Editor
The only field available for selection in the extract editor is the end Reporting Year for which all district data is pulled. For example, a reporting year of 2011 will pull information from the 2010-11 school year.
Generating the Report
- Select a Reporting Year from the dropdown list.
- Click Generate Report to generate the extract in CSV format.
Image 2: NCLB Student Data Report - CSV Format
NCLB Student Data Report Layout
Element Name | Description | Type, Length and Format | Campus Database | Campus Location |
|---|---|---|---|---|
year | The reporting year chosen in the extract editor. | Date field, 4 characters | Not dynamically stored | SD State Reporting > NCLB Student Data > Reporting Year |
districtNumber | The identification number of the district for which the report is generated. | Numeric, 5 digits | district.number | System Administration > Resources > District Information > State District Number |
districtName | The name of the district for which the report is generated. | Alphanumeric, 50 characters | district.name | System Administration > Resources > District Information > Name |
schoolNumber | The identification number of the school into which the student is enrolled. | Numeric, 2 digits | school.number | System Administration > Resources > School > State School Number |
schoolName | The name of the school into which the student is enrolled. | Alphanumeric, 40 characters | school.name | System Administration > Resources > School > Name |
stateID | Student state identification number | Numeric, 9 digits | identity.stateID | Census > People > Demographics > Person Identifiers > Student State ID |
lastName | Student's legal last name. | Alphabetic, 25 characters | identity. lastName | Census > People > Demographics > Last Name |
firstName | Student's legal first name. | Alphabetic, 15 characters | identity.firstName | Census > People > Demographics > First Name |
middleName | Student's legal middle name. | Alphabetic, 25 characters | identity.middleName | Census > People > Demographics > Middle Name |
genderCode | The gender of the student. | Alphanumeric, 1 character | identity.gender | Census > People > Demographics > Gender |
raceCode | The student's race/ethnicity; see options in the Race/Ethnicity Options table following. | Alphanumeric, 2 characters | identity.raceEthinicity | Census > People > Demographics > Race Ethnicity |
enrollmentStart | The date on which student began enrollment. | Date field, 8 characters | enrollment.startDate | Student Information > General > Enrollments > District Start Date AND Student Information > General Enrollment > Start Date |
enrollmentEnd | The date on which student enrollment ended. | Date field, 8 characters | enrollment.endDate | Student Information > General > Enrollments > End Date |
grade | The grade level in which the student is enrolled. | Numeric, 2 digits | enrollment.grade | Student Information > General > Enrollments > Grade |
absentDays | The number of days the student was absent during the reporting year. Appears as a read-only field on student enrollments. | Decimal, 6 characters | Calculated, not dynamically stored | Student Information > General > Enrollments > State Reporting Fields > Absent Days |
residentDistrictName | The name of the district in which the student resides. | Alphanumeric, 50 characters | enrollment. residentDistrict | Student Information > General > Enrollments > State Reporting Fields > Resident District |
residentDistrictNumber | The identification number of the district in which the student resides. | Numeric, 5 digits | enrollment. residentDistrict | Student Information > General > Enrollments > State Reporting Fields > Resident District |
attendingDistrictName | The name of the district at which the student attends school. | Alphanumeric, 50 characters | enrollment. servingDistrict | Student Information > General > Enrollments > State Reporting Fields > Serving (Attending) District |
membershipDays | The number of days counted as membership days for the student. | Decimal, 6 characters | Calculated, not dynamically stored | Calculated, not dynamically stored |
percentEnrolled | The percent of a standard school day for which a student is expected to be in attendance. | Decimal, 5 characters | enrollment. percentEnrolled | Student Information > General > Enrollments > State Reporting Fields > Percent Enrolled |
enrollmentStatus | The status of the student's enrollment. See options in the South Dakota Enrollments Tab article. | Alphanumeric, 1 digit | enrollmentSD. enrollmentStatus | Student Information > General > Enrollments > State Reporting Fields > Enrollment Status |
exitCode | The end status of the student's enrollment. See options on the South Dakota Enrollments Tab article. | Numeric, 2 digits | enrollment. endStatus | Student Information > General > Enrollments > End Status |
foreignExchange | Indicates whether or not student is enrolled as a foreign exchange student based on the value of 2: Foreign Exchange Student in the Citizenship dropdown list. | Numeric, 1 digit | enrollment.citizenship | Student Information > General > Enrollments > State Reporting Fields > Citizenship |
lep | Indicates if student has a status as a limited English proficient. | Alphanumeric, 1 character | enrollment.lep | Student Information > General > Enrollments > LEP Status |
migrant | Indicates if student is a migrant. | Alphanumeric, 1 character | enrollment.migrant | Student Information > General > Enrollments > State Reporting Fields > Migrant Indicator |
mealStatusCode | Indicates whether student is eligible for meal assistance. Options are:
| Alphanumeric, 1 character | POSEligibility.eligibility | FRAM > Eligibility > Eligibility |
title1 | Indicates student is served by a Title 1 program. | Alphanumeric, 1 character | enrollment.title1 | Student Information > General > Enrollments > State Reporting Fields > Title 1 |
readingScaleScore | The student's scaled reading score. | Numeric, 2 digits | testScore.scaleScore | Student Information > General > Assessments > Test Score Detail > Reading Scale Score |
readingLevel | The achievement level of the student for a reading assessment based on a grade and assessment-specific scale. | Alphanumeric, 10 characters | testScore.result | Student Information > General > Assessments > Test Score Detail > Reading Result |
mathScaleScore | The student's scaled math score. | Numeric, 2 digits | testScore.scaleScore | Student Information > General > Assessments > Test Score Detail > Math Scale Score |
mathLevel | The achievement level of the student for a math assessment based on a grade and assessment-specific scale. | Alphanumeric, 10 characters | testScore.result | Student Information > General > Assessments > Test Score Detail > Math Result |
seStart | The effective date of the student's special education participation. | Date field, 10 characters | enrollment. spedStartDate | Student Information > General > Enrollments > Special Ed Fields > Effective Date |
seEnd | The end date of the student's participation in special education. | Date field, 10 characters | enrollment. spedEndDate | Student Information > General > Enrollments > Special Ed Fields > End Date |
seDisabilityCode | The special education student's primary disability. See options in the Primary Disability Options table following. | Numeric, 3 digits | enrollment. disability1 | Student Information > General > Enrollments > Special Ed Fields > Primary Disability |
seCategory | The special ed student's program category. See options in the Special Ed Category Options table following. | Numeric, 4 digits | enrollment. specialEdSetting | Student Information > General > Enrollments > Special Ed Fields > Special Ed Category |
seExitCode | The reason the student's participation in a special education program ended. See options in the Exit Code Options table following. | Numeric, 2 digits | enrollment. spedExitReason | Student Information > General > Enrollments > Special Ed Fields > Exit Code |
districtInclude | Indicates that the student spent a full academic year at the district. | Alphanumeric, 1 character | Not available in the user interface. | Not available in the user interface. |
schoolInclude | Indicates that the student spent a full academic year at the school. | Alphanumeric, 1 character | Not available in the user interface. | Not available in the user interface. |
districtIEPInclude | Indicates that the student spent a full academic year at the district while receiving special education services. | Alphanumeric, 1 character | Not available in the user interface. | Not available in the user interface. |
schoolIEPInclude | Indicates that the student spent a full academic year at the school while receiving special education services. | Alphanumeric, 1 character | Not available in the user interface. | Not available in the user interface. |
assessmentExemption | Indicates whether student is exempt from state-required assessments. | Alphanumeric, 5 characters | enrollmentSD. assessmentExemption | Student Information > General > Enrollments > State Reporting Fields > Assessment Exemption |
firstYearInCountry | Indicates that this year is the student's first year in the country. | Alphanumeric, 1 character | enrollmentSD. firstYear | Student Information > General > Enrollments > State Reporting Fields > First Year in Country |
seCognitiveDisabilities | Indicates that student has significant cognitive disabilities. | Alphanumeric, 1 character | Custom Enrollment | Student Information > General > Enrollments > Special Ed Fields > Significant Cognitive Disabilities |
delpTest | Indicates if student has taken a DELP assessment | Alphanumeric, 1 character | CustomAssessment | Student Information > General > Assessment > DELP Assessment |
scienceScaleScore | The student's scaled science score. | Numeric, 2 digits | testScore.scaleScore | Student Information > General > Assessment > Test Score Detail > Science Scale Score |
scienceLevel | The achievement level of the student for a science assessment based on a grade and assessment-specific scale. | Alphanumeric, 10 characters | testScore.result | Student Information > General > Assessment > Test Score Detail > Science Result |
accommodationreading | Indicates that student received accommodation on a Dakota STEP reading assessment. | Alphanumeric, 1 character | testScore. accommodation | Student Information > General > Assessment > Test Score Detail > Received Accommodation |
accommodationmath | Indicates that student received accommodation on a Dakota STEP math assessment. | Alphanumeric, 1 character | testScore. accommodation | Student Information > General > Assessment > Test Score Detail > Received Accommodation |
accommodationscience | Indicates that student received accommodation on a Dakota STEP science assessment. | Alphanumeric, 1 character | testScore. accommodation | Student Information > General > Assessment > Test Score Detail > Received Accommodation |
dec1count | Indicates that the student was considered special education on December 1st of the reporting year. | Alphanumeric, 5 characters | Not available in the user interface. | Not available in the user interface. |
formerschoolIEPInclude | Indicates that the student spent a full academic year in the school while receiving special education services at some point within the last two years, but not during the current year. | Alphanumeric, 1 character | Not available in the user interface. | Not available in the user interface. |
formerdistrictIEPInclude | Indicates that the student spent a full academic year in the district while receiving special education services at some point within the last two years, but not during the current year. | Alphanumeric, 1 character | Not available in the user interface. | Not available in the user interface. |
fomerstateIEPInclude | Indicates that the student spent a full academic year in the state while receiving special education services at some point within the last two years, but not during the current year. | Alphanumeric, 1 character | Not available in the user interface. | Not available in the user interface. |
LEP2year | Indicates that the student achieved Limited English Proficiency within the last two years. | Alphanumeric, 3 characters | Not available in the user interface. | Not available in the user interface. |
Sped2Year | Indicates that the student appeared in the December 1 Child Count for special education students at some point in the last two years, but not during the current year. | Alphanumeric, 3 characters | Not available in the user interface. | Not available in the user interface. |
Race/Ethnicity Options
Code | Description |
|---|---|
AS | Asian |
BL | Black, not Hispanic |
HI | Hispanic |
IN | American Indian or Alaskan Native |
PI | Native Hawaiian or Pacific Islander |
WH | White, not Hispanic |
TR | Two or more races |
Primary Disability Options
Code | Description |
|---|---|
500 | Deaf-Blindness |
505 | Emotional Disturbance |
510 | Cognitive Disability |
515 | Hearing Loss |
525 | Specific Learning Disability |
530 | Multiple Disabilities |
535 | Orthopedic Impairment |
540 | Visual Loss |
545 | Deafness |
550 | Speech/Language |
555 | Other Health Impairment |
560 | Autism |
565 | Traumatic Brain Injury |
570 | Developmental Delay |
Special Ed Category Options
Code | Description |
|---|---|
0100 | General Class with Modifications 80-100% |
0110 | Resource Room 40-79% |
0120 | Self-Contained Classroom 0-39% |
0130 | Separate Day School |
0140 | Residential Facility |
0150 | Home/Hospital |
0310 | EC 10 hrs +, services in EC |
0315 | EC 10 hrs +, services in other location |
0325 | EC less than 10 hrs, services in EC |
0330 | EC less than 10 hrs, services in other location |
0335 | Separate Class |
0345 | Separate School |
0355 | Residential Facility |
0365 | Home |
0375 | Service Provider Location |
Exit Code Options
Code | Description |
|---|---|
1 | Not receiving SE services |
2 | Graduated (high school diploma) |
| 03 | Continues/Completed IEP team mod/ course reqs |
4 | Reached the maximum age |
5 | Died |
6 | Moved, known to be continuing |
7 | Moved, not known to be continuing |
8 | Dropped out |
9 | Refused services |
10 | ISFP done before max age/Pt C |
11 | Change in IEP |
12 | Student Continues |
| 13 | Discontinued/Completed IEP team mod/course reqs |
| 14 | Aged Out/Completed IEP team mod/course reqs |
| 15 | Revocation of consent |
