ISBE Extracts: ISBE College and Career Readiness Extract

Tool Search: ISBE Extracts

The ISBE College and Career Reading Extract reports students who are enrolled in grades 09-12 as of the Effective Date entered on the extract editor and who have a CCRI record within the current school calendar instructional dates.

Screenshot of the ISBE College and Career Readiness extract editor.  ISBE College and Career Readiness Extract

Report Editor

FieldDescription
Extract TypeSelection determines the extract that is generated. For this instance, select the College and Career Readiness option.
Effective Date

Entered date is used to return current enrollments for the report. This field automatically populates with the current date, but can be changed by entering a new date in mm/dd/yyyy format or by clicking the calendar icon to select a date. This date is required in order to generate the report.

  • If an enrollment record has an end date before the effective date, that record is not included
  • If an enrollment record has an end date after the effective date or does not have an end date, that record is included.
File IdentifierIndicates the number attached to the end of the file name and is used to differentiate the file from other files generated.
Strip Apostrophes

When marked, the following marks are removed from student names and other reported data:

  • Apostrophes ('), Commas (,), Periods (.)
  • Umlaut (Ö)
  • Tilde (Ñ)
  • Grave Accents (Ò), Acute Accents (Ó)
  • Circumflex (Ô)

When not marked, these marks are not removed.

Report Protected IdentitiesWhen marked, student identity information (last name, first name, etc.) reports from the Protected Identity Information fields.
Choose GradesOnly students enrolled in the selected grade level are included in the report when they meet the other report population requirements (i.e, enrolled as of the effective date and have a CCRI record).
FormatDetermines how the report generates. Use the State Format (Comma Delimited) when submitting the report to the state. Use the HTML or Tab Delimited option when reviewing data prior to state submission. 
Ad hocSelect a saved ad hoc filter to use when generating this report. Only those students included in the filter are returned on the report if they meet the reporting requirements.
Calendar SelectionAt least one calendar needs to be selected for the report to generate. Calendars can be chosen by Active Year, by School or by Year. If a calendar is selected in the Campus toolbar, that calendar is automatically selected.
Report GenerationThe report can be generated immediately using the Generate Extract button. When there is a larger amount of data chosen (several calendars, large date range, etc.), use the Submit to Batch button, which allows the user to choose when the report is generated. See the Batch Queue article for more information.

Generate the Report

  1. Select College and Career Readiness from the Extract Type field.
  2. Enter the Effective Date for the report.
  3. Enter a File Identifier. This is a three digit number attached to the file name used to differentiate itself from other ISBE Demographic and Enrollment Extract files generated.
  4. Mark the Strip Apostrophes checkbox, if desired.
  5. If desired, mark the Report Protected Identities checkbox.
  6. Select the desired grade levels from the Choose Grades list.
  7. Select which Format to generate the report in. To preview information prior to submission to the state, use the HTML format. When submitting data to the state, use the State Format (Comma Delimited).
  8. If desired, select an Ad hoc Filter from which to pull the student set.
  9. Select which Calendars to include within the report.
  10. Select the Generate Extract button or use the Submit to Batch option. The report displays in a separate window in the designated format. 

Screenshot of an example of the Career and College Readiness extract in HTML format. ISBE Career and College Readiness Extract - HTML Format

Screenshot of an example of the Career and College Readiness extract in State format (Comma Delimited). ISBE Career and College Readiness Extract - State Format (Comma Delimited)

Screenshot of an example of the Career and College Readiness extract in Tab Delimited format. ISBE Career and College Readiness Extract - Tab Delimited

Career and College Readiness Extract Layout

Header Layout

Element

Description

Location

Report Name

The name of the extract being generated. Always reports a value of College and Career Readiness.

N/A

Student Count

The total amount of records generated.


Numeric

N/A

File Name

EN + RCDT or District Name + _ + Date (mmddyyy)_File Identifier (i.e., CCRI_310453000260_01302015_001.txt)

N/A

Date

The date the extract was generated.


MMDDYYYY

N/A

RCDTS Code

The Region-County-District-Type-School code that uniquely identifies the school generating the extract.


RRCCCDDDDDTTSSSS, 15 characters

District Information > State District Number, Type, Region Number, County


District.districtID

District.county

District.region


School Information > State School Number


School.number

Extract Layout

Element

Description

Location

Student ID

Reports the student's state ID.

Numeric, 9 digits
Demographics > Person Identifiers > State ID

Person.stateID

SAP ID

Reports the student's locally assigned school identification number.

Numeric, 50 digits
Demographics > Person Identifiers > Student Number

Person.studentNumber

Student Last Name

Reports the student's legal last name.


When the Report Protected Identities checkbox is marked on the report editor, the student's first name reports from the Legal First Name field if populated.


Only alphabetical characters (A-Z) are reported; non-alphabetical characters are removed (apostrophes, hyphens, etc.).


Alphabetic, 30 characters

Identities > Last Name


Identity.lastName


Identities > Protected Identity Information > Legal Last Name


Identity.legalLastName

Student First Name

Reports the student's legal first name.


When the Report Protected Identities checkbox is marked on the report editor, the student's first name reports from the Legal First Name field if populated.


Only alphabetical characters (A-Z) are reported; non-alphabetical characters are removed (apostrophes, hyphens, etc.).


Alphabetic, 30 characters

Identities > First Name


Identity.firstName


Identities > Protected Identity Information > Legal First Name


Identity.legalFirstName

Birth DateThe student's date of birth.

Date field, 10 characters (MM/DD/YYYY)


Demographics > Person Information > Birth Date

dentity.birthDate
Home RCDTSThe Region-County-District-Type-School code that uniquely identifies the elementary, middle/junior, or high school the student attends or would attend if not placed/transferred to another school/program to receive needed services.

RRCCCDDDDDTTSSSS, 15 characters
Enrollments > State Reporting Fields > Home School

District.districtID

District.county

District.region

School.number

Enrollment.resident School

Enrollment.resident District


School Year
Reports the school year for which the enrollment is applicable.

Numeric, 4 digits
School Year Setup > School Year Editor > End Year

Calendar.endYear
GPA

Reports the student's grade point average, if the student is in grades 11 or 12.


If the GPA field on the CCRI record is populated, that value reports. If that GPA field is not populated, the student's GPA from the student Transcript is used to find the reported value:

  • Reports 01 when the student's GPA is 3.75 or above.
  • Reports 02 when the student's GPA is 2.8 - 3.74.
  • Reports 03 when the student's GPA is below 2.8.
  • Reports 00 when the student does not have a GPA.


The first two digits of the GPA report, meaning a GPA of 3.825 reports as 38.


Numeric, 2 digits

State Programs > CCRI > GPA

CCRI.gpa
Identify a Career Area of Interest by end of sophomore year

Indicates the student has identified a career as of the end of their sophomore year.

  • Reports a value of 01 when marked on the CCRI record.
  • Reports a value of 02 when not marked on the CCRI record.

Numeric, 2 digits

State Programs > CCRI > Identify Career Int EOY Soph

CCRI.identifyCareerInterest
AP or IB Exam Academic Indicator ELA

Indicates the student met ELA Academic requirements.


Reports a value of 01 when one of the following is true:

  • Student has an assessment with a National Test Code of AP or IB.
  • The subject of the assessment is Literacy.
  • The student has a score of 3 or higher on the AP test.
  • The student has a score of 4 or higher on the IB test.
  • The SCED Subject Area is 01 English Language and Literature.
  • The Course Type is AP (Advanced Placement) or IB (International Baccalaureate) OR
  • The course is marked as Dual Credit = 01 Yes.
  • The student received a Course Grade of C- or higher.

Otherwise, reports a value of 02 (default value).


Numeric, 2 digits

Assessments > Test > Score

TestScore.scaleScore
TestScore.rawScore
Course Information > NCES Data > SCED Subject Area


Course.scedSubjectArea


Course Information > Type


Course.type


Course Information > Dual Credit


Course.dualCredit


AP or IB Exam Academic Indicator Math

Indicates the student met Math Academic requirements.


Reports a value of 01 when one of the following is true:

  • Student has an assessment with a National Test Code of AP or IB.
  • The subject of the assessment is Math.
  • The student has a score of 3 or higher on the AP test.
  • The student has a score of 4 or higher on the IB test.
  • The SCED Subject Area is 02 Mathematics.
  • The Course Type is AP (Advanced Placement) or IB (International Baccalaureate) OR
  • The course is marked as Dual Credit = 01 Yes.
  • The student received a Course Grade of C- or higher.

Otherwise, reports a value of 02 (default value).


Numeric, 2 digits

Assessments > Test > Score

TestScore.scaleScore
TestScore.rawScore

Course Information > NCES Data > SCED Subject Area


Course.scedSubjectArea


Course Information > Type


Course.type


Course Information > Dual Credit


Course.dualCredit

Minimum ACT or SAT Subject Scores - English, Reading, and Writing from National Test Scores

Indicates the student has achieved the minimum score on the ACT and/or SAT for English, Reading and Writing.


Reports a value of 01 when one of the following is true:

  • Student has an assessment with a National Test Code of ACT or SAT.
  • The subject of the assessment is Literacy.
  • For Literacy, the student has an ACT English Score of 18 or higher, AND
  • For Reading, the student has an ACT Reading Score of 22 or higher, OR
  • For Reading, the student has a SAT Subject Score of 540 or higher.

Otherwise, reports a value of 02 (default value).


Numeric, 2 digits

Assessments > Test > Score

TestScore.scaleScore
TestScore.rawScore
Minimum ACT or SAT Subject Scores - Math from National Test Scores

Indicates the student has achieved the minimum score on the ACT and/or SAT for Math.


Reports a value of 01 when the student has the following: 

  • An Assessment with a National Test Code of ACT or SAT with a Subject of Math
  • An ACT Math score of 22 or higher OR
  • Sn SAT Subject Score of 540 or higher in math.

Otherwise, reports a value of 02 (default value).


Numeric, 2 digits

Assessments > Test Score

TestScore.scaleScore
TestScore.rawScore

Career development experience

Indicates the student participated in career development programming.

  • Reports a value of 01 when marked on the CCRI record.
  • Reports a value of 02 when not marked on the CCRI record.

Numeric, 2 digits

State Programs > CCRI > Career Development

CCRI.careerDevelopment

Industry Credential

Indicates the student achieved an industry credential in a specific area of interest.


Reports the selected value if one is selected; if a credential is not selected, reports a value of 00.


Numeric, 2 digits

State Programs > CCRI > Industry Credential

CCRI.industryCredential

Military Service or an ASVAB score of 31 or Higher

Indicates the student participated in military service or achieved a score of 31or higher on the Armed Services Vocational Aptitude Battery test.


Reports a value of 01 when one of the following is true:

  • Student has a Military Connection Status - Active Duty Deployed, Active Duty Not Deployed, Student Military Identifier Only. 
  • Student has an Assessment with a National Test Code of ASVAB with a score of 31 or higher.

Otherwise, reports a value of 02 (default value).


Numeric, 2 digits

Military Connection > Status

ImpactAidEmployment.militaryStatus
Assessments > Test Score

TestScore.scaleScore
TestScore.rawScore
Attain/Maintain consistent employment for a minimum of 12 months

Indicates the student acquired and held a job for at least 12 months.

  • Reports a value of 01 when marked on the CCRI record.
  • Reports a value of 02 when not marked on the CCRI record.

Numeric, 2 digits

State Programs > CCRI > Attain/Maintain Employment 12 Mo

CCRI.employment
Consecutive Summer Employment

Indicates the student was consecutively employed during the summer.

  • Reports a value of 01 when marked on the CCRI record.
  • Reports a value of 02 when not marked on the CCRI record.

Numeric, 2 digits

State Programs > CCRI > Consecutive Summer Employment

CCRI.consecutiveSummerEmployment
25 Hours of community service

Indicates the student has completed 25 hours of community service.


Reports a value of 01 when the student earned 25 hours or more. Otherwise, a value of 02 reports.


Numeric, 2 digits

State Programs > CCRI > 25 Hours Earned

CCRI.communityService
Two or more organized co-curricular activities

Indicates the student participated in and/or organized two or more co-curricular activities.


Reports a value of 01 when the student has two or more courses marked as Co-Curricular Activity.


When a student drops or withdraws from a course prior to the course end date, that course is not counted towards the two or more courses.


Otherwise, a value of 02 reports.


Numeric, 2 digits

Course Master Information > Organized Co-Curricular Activity

CourseMaster.coCurricular
Course.coCurricular