Skip to main content
Skip table of contents

Detailed IL End-of-Year Report Data

Page 1 Information

Section

Description

Where are the numbers coming from?

A1

12 Grade Housed – Male

The total number of male students in grade 12 enrolled on the end date from the prompts

+

the total number of male students not enrolled on the end date with a graduation year (reg_academic.graduation_year) = to the prompted school year

+

the total number of male students with a graduation date (reg_academic.graduation_date) = to the prompted summer graduation date

A2

12 Grade Housed – Female

The total number of female students in grade 12 enrolled on the end date from the prompts

+

the total number of female students not enrolled on the end date with a graduation year (reg_academic.graduation_year) = to the prompted school year

+

the total number of female students with a graduation date (reg_academic.graduation_date) = to the prompted summer graduation date

B3

Total School Housed – Male

The total number of male students enrolled on the end date from the prompts

+

the total number of male students with a graduation date (reg_academic.graduation_date) = to the prompted end of year graduation date

B4

Total School Housed – Female

The total number of female students enrolled on the end date from the prompts

+

the total number of female students with a graduation date (reg_academic.graduation_date) = to the prompted end of year graduation date

C

Did your school offer an educational program for persons who had dropped out of school?

Always N/A (not currently stored anywhere)

D7

High School Graduates by Race/Ethnicity – White – Male
 

The total number of male students with regtb_ethnicity.state_code_equiv = '05' with a graduation year (reg_academic.graduation_year) = to the prompted school year

+

the total number of male students with regtb_ethnicity.state_code_equiv = '05' with a graduation date (reg_academic.graduation_date) = to the prompted summer graduation date

D8

High School Graduates by Race/Ethnicity – White – Female
 

The total number of female students with regtb_ethnicity.state_code_equiv = '05' with a graduation year (reg_academic.graduation_year) = to the prompted school year

+

the total number of female students with regtb_ethnicity.state_code_equiv = '05' with a graduation date (reg_academic.graduation_date) = to the prompted summer graduation date

D9

High School Graduates by Race/Ethnicity – Black  - Male
 

The total number of male students with regtb_ethnicity.state_code_equiv = '03' with a graduation year (reg_academic.graduation_year) = to the prompted school year

+

the total number of male students with regtb_ethnicity.state_code_equiv = '03' with a graduation date (reg_academic.graduation_date) = to the prompted summer graduation date

D10

High School Graduates by Race/Ethnicity – Black – Female
 

The total number of female students with regtb_ethnicity.state_code_equiv = '03' with a graduation year (reg_academic.graduation_year) = to the prompted school year

+

the total number of female students with regtb_ethnicity.state_code_equiv = '03' with a graduation date (reg_academic.graduation_date) = to the prompted summer graduation date

D11

High School Graduates by Race/Ethnicity – American Indian or Alaskan Native  - Male
 

The total number of male students with regtb_ethnicity.state_code_equiv = '01' with a graduation year (reg_academic.graduation_year) = to the prompted school year

+

the total number of male students with regtb_ethnicity.state_code_equiv = '01' with a graduation date (reg_academic.graduation_date) = to the prompted summer graduation date

D12

High School Graduates by Race/Ethnicity – American Indian or Alaskan Native  – Female
 

The total number of female students with regtb_ethnicity.state_code_equiv = '01' with a graduation year (reg_academic.graduation_year) = to the prompted school year

+

the total number of female students with regtb_ethnicity.state_code_equiv = '01' with a graduation date (reg_academic.graduation_date) = to the prompted summer graduation date

D13

High School Graduates by Race/Ethnicity – Asian or Pacific Islander  - Male
 

The total number of male students with regtb_ethnicity.state_code_equiv = '02' with a graduation year (reg_academic.graduation_year) = to the prompted school year

+

the total number of male students with regtb_ethnicity.state_code_equiv = '02' with a graduation date (reg_academic.graduation_date) = to the prompted summer graduation date

D14

High School Graduates by Race/Ethnicity – Asian or Pacific Islander  – Female
 

The total number of female students with regtb_ethnicity.state_code_equiv = '02' with a graduation year (reg_academic.graduation_year) = to the prompted school year

+

the total number of female students with regtb_ethnicity.state_code_equiv = '02' with a graduation date (reg_academic.graduation_date) = to the prompted summer graduation date

D15

High School Graduates by Race/Ethnicity – Hispanic  - Male
 

The total number of male students with regtb_ethnicity.state_code_equiv = '04' with a graduation year (reg_academic.graduation_year) = to the prompted school year

+

the total number of male students with regtb_ethnicity.state_code_equiv = '04' with a graduation date (reg_academic.graduation_date) = to the prompted summer graduation date

D16

High School Graduates by Race/Ethnicity – Hispanic  – Female
 

The total number of female students with regtb_ethnicity.state_code_equiv = '04' with a graduation year (reg_academic.graduation_year) = to the prompted school year

+

the total number of female students with regtb_ethnicity.state_code_equiv = '04' with a graduation date (reg_academic.graduation_date) = to the prompted summer graduation date

D

High School Graduates by Race/Ethnicity – Multiracial  - Male
 

The total number of male students with regtb_ethnicity.state_code_equiv = '06' with a graduation year (reg_academic.graduation_year) = to the prompted school year

+

the total number of male students with regtb_ethnicity.state_code_equiv = '06' with a graduation date (reg_academic.graduation_date) = to the prompted summer graduation date

D

High School Graduates by Race/Ethnicity – Multiracial  – Female
 

The total number of female students with regtb_ethnicity.state_code_equiv = '06' with a graduation year (reg_academic.graduation_year) = to the prompted school year

+

the total number of female students with regtb_ethnicity.state_code_equiv = '06' with a graduation date (reg_academic.graduation_date) = to the prompted summer graduation date

D17

High School Graduates by Race/Ethnicity – Total # of Grads  - Male

Total of the D# Male sections above

D18

High School Graduates by Race/Ethnicity – Total # of Grads  – Female

Total of the D# Female sections above

E-A Grid

Dropouts by Grade Gender and race/ethnicity

The E-A Grid is calculated by getting total number of dropouts by ethnicity, grade and male/female.  It calculates if a student is a dropout by checking if they withdrew sometime between the date range entered with a withdrawal code that matches a code in the Dropout Withdrawal code list from the prompts.

Page 2 Information

Section

Description

Where are the numbers coming from?

E-B 1

Dropouts and Enrollment in grades 9-12 for Special Student Groups – LEP Students

Students who are LEP have reg_program_column. state_code_equiv = 'ILLEP'  If a student has a value of 'Y' or '01' in the reg_program field for their LEP program during the prompted date range – then they will be counted in this counted in the Enrollment column.

If the student also is considered a dropout this year (E-A previous page) then they would be counted in the dropout column.

E-B 2

Dropouts and Enrollment in grades 9-12 for Special Student Groups – Migrant Students

Students who are Migrant have reg_program_column. state_code_equiv = 'ILMIG'  If a student has a value of 'Y' or '01'  in the reg_program field for their Migrant program during the prompted date range – then they will be counted in this counted in the Enrollment column.

If the student also is considered a dropout this year (E-A previous page) then they would be counted in the dropout column.

E-B 3

Dropouts and Enrollment in grades 9-12 for Special Student Groups – Economically Disadvantaged

Students Meal Status information have reg_program_column. state_code_equiv = 'ILFRL'  If a student has a value listed in the Economically Disadvantaged Meal Status codes list from the prompts in the reg_program field for their meal status program during the prompted date range – then they will be counted in this counted in the Enrollment column.

If the student also is considered a dropout this year (E-A previous page) then they would be counted in the dropout column.

E-B 4

Dropouts and Enrollment in grades 9-12 for Special Student Groups – IEP

Students who are IEP have reg_program_column. state_code_equiv = 'ILIEP'  If a student has a value of 'Y' or '01' in the reg_program field for their IEP program during the prompted date range – then they will be counted in this counted in the Enrollment column.

If the student also were considered a dropout this year (E-A previous page) then they would be counted in the dropout column.

F-1

Other School Info – Agg Number of Days Attendance

The attendance information will come from your Day Totals – so you will have to run the Day Totals Calculation for the view you are using in this report to get accurate data.  The attendance is then calculated by selecting the sum(att_stu_day_memb.membership_value) for the building being processed, for the date range entered to get total membership… then subtract the total days absent (calculated in the next line F-2) and subtract from membership total. 

F-2

Other School Info – Agg Number of Days Absent

As in F-1 – the Day Totals calculation must be run prior to this report.

Select the sum(att_stu_day_totals.att_code_value) for the prompted view and absence codes, for the building being processed, for the date range entered.

F-3

Area of District in square miles

From prompts (Number of square miles prompt)

F-4

Number of new permanent buildings in district

From prompts (Number of new permanent buildings)

F-5

Number of new permanent additions in district

From prompts (Number of new permanent additions in district)

G-1

Truants

Count of students in the building who have been absent with a Truant code from the prompts during the date range entered (DOES NOT include students who are counted in G-2 Chronic Truants below)

Note: Break into Male and Female columns

G-2

Chronic Truants

Count of students who have been absent with a Truant code from the prompts 10% or more during the date range entered.

Note: This is counting students not absences.  It is broken into male and female

If a student is absent with a truant code 10% or more then they get counted in the G-2 total if not they will be counted in the G-1 total. 

G-3

Truant Minors

 

H-A

Suspension

Totals for suspensions broken out by Ethnic, grades and Male/Female.

Totals for students suspended ONLY 1 time during the prompted date range.  Students are considered suspended if they have an action code included in the prompted suspension list.

Totals for students suspended More than 1 time during the prompted date range.

H-B

Suspensions due to various reasons

Calculated using the different reason codes and building type codes from prompts

  • Use list of codes in Physical Fighting Code list to know if a suspended student should be counted in this category, etc.
  • Use elementary code list from the prompts to know if the building being processed is Elementary, etc.

If a reason code is not filled in on the prompts – then 0's display for those counts.

H-C

No Pass  - No Play Suspensions

Calculated using the action codes from the No Pass No Play suspensions – if not tracking occurrences, checks the disc_off_action.actual_duration to see if the result was 0-7, 8-14 or 15+ days.  If tracking occurrences, then the disc_occurrence table is checked to calculate the length of the action

I-A

Expulsion

Totals for expulsions broken out by Ethnic, grades and Male/Female.

A student is expelled if they have an action code matching the expulsion code list in the prompts.

I-B

Expulsion due to various reasons

Calculated using the different reason codes and building type codes from prompts

  • Use list of codes in Physical Fighting Code list to know if an expelled student should be counted in this category, etc.
  • Use elementary code list from the prompts to know if the building being processed is Elementary, etc.

If a reason code is not filled in on the prompts – then 0's display for those counts. 

Page 3 Information

Section

Description

Where are the numbers coming from?

J-A

Disability

Includes students who were suspended or expelled for more than 10 days during the school year: (Uses the suspension and expulsion code list to know who to include – checks the sum of the actual duration field for the student to know if it was more than 10 days – if they were suspended 2 times and had 5 days and 6 days, then they would be included)

Row 1-13 (Disabilities will have the following state code equivs):

  • 01 – Mental Retardation
  • 02 – Hearing Impaired
  • 03 – Speech or Language Impairments
  • 04 – Visual Impairment
  • 05 – Emotional Disturbance
  • 06 – Orthopedic Impairment
  • 07 – Other Health Impairments
  • 08 – Specific Learning Disability
  • 09 – Deaf-Blindness
  • 10 – Multiple Disabilities
  • 11 – Autism
  • 12 – Traumatic Brain Injury
  • 13 – Developmental Delay (Note:If the state code equiv is not set up for any codes – then there is nothing to calculate in that row.)

Row 14: Totals for Rows 1-13 above:

  • Column 1A: Count of children removed due to drugs or weapons – uses the weapon code list, the alcohol code list and the drug related codes to calculate. To get the count of students who were removed to the alternate education program compare the action code against a state code equiv for the alternate program (ALTED).  So, you must set any discipline codes that indicate alternate ed to ALTED.
  • Column 1B: Use the alcohol code and drug code list to calculate
  • Column 1C: Use the Weapon Code list
  • Column 2: Not currently calculated
  • Column 3A: Count of unique students who were suspended more than 10 days total throughout the year
  • Column 3B: Count of unique students who had 1 suspension or expulsion for more than 10 days.
  • Column 3C: Count of unique students who had multiple suspension/expulsion totaling more than 10 days.

J-B

Race/ethnicity

Same as J-A above but summing for the ethnicity categories using ethnic conversion information from D-7 above.


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.