IL College and Career Report

Contents

Introduction

This report extracts college and career readiness data and information including GPA, Testing and other pertinent fields for students in grade 9-12. This report is due on of the year

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records based on the following criteria:

Student must not be excluded from state reporting
Student must be in grade 9, 10, 11, or 12

School Selection

The report selects records based on the following criteria:

Student's school must not be excluded from state reporting

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Schools to Include	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. The All Schools option is only available when running the report from the District Office.
Current Selection Students	Indicate which students to include in the report by selecting one of the following options: Selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. If running the report for a single student, or group of students, select the students prior to running the report.
RCDTS Number (Override)	To generate the report for a specific RCDTS school, enter the school's 15-digit RCDTS (Region, Country, District, Type, and School) number.
Report Start Date	Enter the start date for the reporting period.
Report End Date	Enter the end date for the reporting period.
GPA Method used to report GPA	Select the GPA method used for calculating and reporting the students' GPAs.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Field Length
1	State Student ID	The state student ID from the ISBE SIS Student Demographic/Enrollment Information page (Demo tab) .	[Students]State_StudentNumber	9
2	Local SAS ID	The student number	[Students]Student_Number	50
3	Last Name	The legal last name of the student to whom the student ID belongs. If legal last name is blank, last name is reported.	[S_IL_STU_Demographics_X] Legal_Last_Name [Students]Last Name	30
4	First Name	The legal first name of the student to whom the student ID belongs. If legal first name is blank, first name is reported.	[S_IL_STU_Demographics_X] Legal_First_Name [Students]First Name	30
5	Birth Date	The student's date of birth	[Students]DOB	10
6	RCDTS Home School	The Region, County, District, Type, School (RCDTS) code which uniquely identifies the student’s home school.	[S_IL_STU_X]RCDTS_Home_School [S_IL_SCH_X]RCDTS_Home_School	15
7	School Year	The ending year of the student's current active enrollment. For example, if the student is active in the 2019-20 school year, 2020 is reported.	Derived from student's current year active enrollment.	4
8	GPA	Applies to Grades 11 and 12 only. Valid Values: 00 = No GPA for the student 01 = Student's GPA is 3.75 and above 02 = Student's GPA is 2.8 – 3.74 03 = Student's GPA is below 2.8	Student's calculated GPA(s).	2
9	Identify a Career Area of Interest by the End of Sophomore Year	Indicates whether the student is: Participating in pathways as defined by a local board of education Creating an individualized plan as part of the College and Career Pathway Endorsement program, or Engaging in activities as part of Illinois Career Pathways Valid values: Blank 01 - Yes 02 - No	[S_IL_STU_CollegeCareer_X]Career_Interest	2
10	One Academic Indicator ELA	Indicates whether the student has either an ELA Advanced (AP) Exam score of 3 or higher, or an International Baccalaureate (IB) Exam score of 4 or higher. Valid values: Blank 01 - Yes 02 - No	[S_IL_STU_CollegeCareer_X]Academic_Indicator_ELA	2
11	One Academic Indicator Math	Indicates whether the student has either a Math AP Exam score of 3 or higher, or an IB Exam score of 4 or higher. Valid values: Blank 01 - Yes 02 - No	[S_IL_STU_CollegeCareer_X]Academic_Indicator_Math	2
12	Minimum ACT or SAT Subject Scores-English, Reading, and Writing	Indicates whether the student has either a minimum ACT subject score of English 18 and Reading 22, or a minimum SAT subject score of 540 fo evidence-based Reading and Writing Valid values: Blank 01 - Yes 02 - No	[S_IL_STU_CollegeCareer_X]Min_ACTSAT_English	2
13	Minimum ACT or SAT Subject Scores-Math	Indicates whether the student has either a minimum ACT Math subject score of 22, or a minimum SAT Math subject score of 540. Valid values: Blank 01 - Yes 02 - No	[S_IL_STU_CollegeCareer_X]Min_ACTSAT_Math	2
14	Career Development Experience	Indicates whether the student is involved in a supervised work experience relating to their career area of interest that meet all of the following criteria: Occurs in a workplace or under other authentic working conditions; Is co-developed by an education provider and at least one employer in the relevant field; Provides compensation or educational credit to the participant; Reinforces foundational professional skills including, at a minimum,those outlined in the Illinois Essential Employability Skills framework https://icsps.illinoisstate.edu/wp-content/uploads/2017/07/Essential-Handout-2.pdf Includes a Professional Skills Assessment that assesses skill development and is used as a participant feedback tool Takes place for a minimum of 60 total hours. Valid values: Blank 01 - Yes 02 - No	[S_IL_STU_CollegeCareer_X]Career_Dev_Experience	2
15	Industry Credential	Indicates the work-related industry credential that meets all of the following criteria: Verifies an individual’s qualifications or competence in a specific skillset related to a particular industry or occupation; Is issued by an industry-related organization or state licensing body with the relevant authority to issue such credentials Is broadly sought or accepted by employers as a recognized, preferred, or required credential for recruitment, screening, hiring, retention, or advancement purpose.	[S_IL_STU_CollegeCareer_X]Industry_Credential	2
16	Military Service or an ASVAB Score of 31 or Higher	Indicates whether the student made a commitment to serve in the armed services and met one of the following criteria: Received an Armed Services Vocational Aptitude Battery (ASVAB) score of 31 or higher, or Is 17 years old, has enlisted with permission from a parent or guardian, attended Basic Combat Training before Senior year, trained one weekend per month through Senior year with a local unit, and has planned attendance for Advanced Individual Training after Senior year, or Participated in Junior Reserve Officer Training Corps Valid values: Blank 01 - Yes 02 - No	[S_IL_STU_CollegeCareer_X]Military_Service_ASVAB	2
17	Attaining and Maintaining Consistent Employment for a Minimum of 12 Months	Indicates whether the student has been employed continuously for at least 12 months and the employment can be verified through pay stubs, timesheets, or a signed letter from an adult supervisor that includes the number of hours worked. Valid values: Blank 01 - Yes 02 - No	[S_IL_STU_CollegeCareer_X]Consistent_Employment	2
18	Consecutive Summer Employment	Indicates whether the student has been employed for two consecutive summers and the employment can be verified through pay stubs, timesheets, or a signed letter from an adult supervisor that includes the number of hours worked. Valid values: Blank 01 - Yes 02 - No	[S_IL_STU_CollegeCareer_X]Summer_Employment	2
19	25 Hours of Community Service	Indicates whether the student performed volunteer service or activity that addressed a social issue in the community, such as poverty, disaster relief, education, the environment, homelessness, community wellness or other social issues. Valid values: Blank 01 - Yes 02 - No	[S_IL_STU_CollegeCareer_X]Community_Service_25	2
20	Two or More Organized Co-curricular Activities	Indicates whether the student participated in an activity, program, or learning experience that: Is connected to or mirrors an academic curriculum for which the student did not receive credit, and Takes place outside or school or after regular school hours and may be operated by outside organizations, and Instills adaptive competencies and/or Illinois Essential Employability Skills, including personal and work ethics, teamwork, and communication. Valid values: Blank 01 - Yes 02 - No	[S_IL_STU_CollegeCareer_X]Org_Cocurricular_Activity	2