Spreadsheet: 139234a1-fd83-486d-9c40-30c7e7b60a86
Sheet: Sheet1

DRAFT  Business Rules for the Warehouse/UPASS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Section | Date Updated | Rule Name | Description | Sponsor | Comments
CACTUS |  | NCLB Highly Qualified | See CACTUS documentation on the Classes Not Taught by Highly Qualified Teachers | [NAME]
CACTUS | 2003 | Poverty Schools | Column in CACTUS
CACTUS | 2004-01-01 00:00:00 | Rural Schools | Rural schools designator will be added to the be_school_year table | [NAME]
CACTUS
CACTUS
Cb_divider
Clearinghouse |  | Membership | 2003 - If the number of membership days is greater than 180 then it is set to 180.  2004 -  membership > 180 is an error (with some exceptions) 2005 - Same as 2004 | [NAME] | A student can have more than 180 days membership if they attended more than one school.  180 days is the [NAME] for a single school.  180 days + 10 days for each school they attended during a single school year.
Clearinghouse |  | Attendance | Attendance can be greater than school membership | [NAME]
Clearinghouse |  | Attendance | Attendance cannot be greater than School membership + YIC membership + Special Ed membership (self-contained) | [NAME]
Clearinghouse |  | Birthdate | Students must be between the ages of 3 - 23 | [NAME]
Clearinghouse | 2005-04-21 00:00:00 | Elementary School Students | Student should use course code that begins with 22xxxxxxxxx Should only have a single row reported for any period of time.   If the student switches teachers (home room) then another AM row may be reported with the new information (entry date, instructional hours, course membership days, etc) Above rule is true for moving from one school to another Multiple rows should not be submitted for a single period in time (reading, writing, math, etc) | Curriculum - Lynn Greenwood
Clearinghouse
Divider
Assessment & Accountability |  | Full Academic Year (FAY) | See Full Academic Year under AYP Business Rules | [NAME]
Assessment & Accountability |  | Re-calc SAT Summaries | Summary rows on SAT (Stanford) will need to be recalculated because they may contain rows for students that did not attend the school (home schooled students). |  | This means we cannot use the summary rows on the research disk.  2005 - No longer used
Assessment & Accountability | 2003-06-19 00:00:00 | Part-Time Students | 2003 - Part-time students will not be included in AYP calculations this year as they will not meet the FAY minimum 145 days in membership. | [NAME]
Assessment & Accountability | 2003-09-04 00:00:00 | Student subgroups | If a student is low-income for any part of the year, that student will be considered as part of the low-income sub-category.  This is true for LEP, etc. | [NAME] | This can only happen if the student is in more than one school during the school year thus having multiple rows in the clearinghouse.
Assessment & Accountability | 2003-09-15 00:00:00 | UPASS Report Minimums | 1.  Do not report demographic information by grade if there are fewer than 10 students in the box. 2. Do no report less than 10% proficient or greater than 95% proficient in the CRT portion of the UPASS report. | [NAME]
Assessment & Accountability | 2007-07-10 00:00:00 | AYP & U-PASS | Yes – met the criteria Yes* -- met the criteria with confidence interval No – did not meet the criteria Cactus – will correctly show which schools should generate accountability reports
F_divider
Finance & Statistics
S_divider
Special Ed | 2007-07-10 00:00:00 |  | The assessment scores of students who exit the Special Education Program will be retained    for accountability in the SWD subgroup for two school years following the school year in    which they exit.  (beginning 08)   If modified and accommodation is bubbled – it is an error.  We do not track accommodations    for a modified test.    2% Interim Flexibility   For 2007    August 15th, after reports are sent to districts, the following will be hand calculated:     Determine the schools that fail AYP due to SWD only     Determine the proficiency rate of SWD in that school     Add the proxy (15%) to the proficiency rate of the school (without confidence       interval) to see if the target is reached.       If target is reached that would change AYP from a no to a yes, the school will be       contacted and allowed to appeal the report.      December 1st     The Business rule for the 2% interim Flexibility will be included in the final run      of the [NAME] reports.     For 2008    The Business rule for the 2% interim Flexibility will be included in the [NAME] reports.     Business Rule – will need additional work if needed:   If school fails AYP for SWD only, then:    Take the school proficiency % for language arts, add the 15% proxy, compare to      target - Did the school pass AYP for language arts?    Take the school proficiency % for math, add the 15% proxy, compare to target –      Did the school pass AYP for math?    Change Report     Yes** Group within allowed SWD interim 2% flexibility (report shows original       proficiency)      On report under academic achievement only. | [NAME]
Special Ed | 2003-06-26 00:00:00 | UAA | UAA students whose birthdate is in 9-12th grades will be added to 00000GE0812R Geometry. | [NAME]
Special Ed | 2003-06-26 00:00:00 | UAA | UAA in 7-8th grade will be added to 7th grade math. 00000MA0707R | [NAME]
Special Ed | 2003-06-26 00:00:00 |  | Test id and grade level will be used to determine which Actual Test ID to assign a student to.    LA and grade level will correspond to an Actual Language (Reading) class for that student.  [NAME] and grade level will correspond to a math course. | [NAME]
Special Ed | 2003-06-26 00:00:00 |  | MA for Test_id and grade 1st grade birthdate will correspond to 00000MA0101R TEST ID. | [NAME]
Special Ed | 2003-06-26 00:00:00 |  | LA for test_id and grade 1st grade birthdate will correspond to 00000LA0101R test id. | [NAME]
Special Ed | 2003-06-26 00:00:00 |  | Grade level is derived based on birthdate | [NAME]
Special Ed | 2003-06-26 00:00:00 |  | If a student is older than high school students, they should not be tested and will not be included in the results. | [NAME]
Special Ed | 2003-07-10 00:00:00 |  | Out of level CRT tests where the grade is lower than the grade of the student will be assigned a proficiency of Minimal Mastery (level 1).  7/21/03 per Hal | [NAME]
Special Ed | 2004-09-03 00:00:00 |  | The grade level for the test is derived from the grade level for the student in the warehouse.  The grade level in the warehouse for the student is copied directly from the information that we receive in the clearinghouse (from the district). | [NAME] [NAME]
Special Ed | 2004-09-03 00:00:00 |  | We do NOT use [NAME] or 12th grade UAA tests in UPASS or [NAME] | [NAME] [NAME]
Special Ed | 2004-09-03 00:00:00 |  | Profiles are printed for UAA tests if the appropriate task #’s, etc. are used | [NAME] [NAME]
Special Ed | 2005-07-26 00:00:00 |  | UAA tests that have a proficiency level of 0 and do not have a non-participation code are not loaded |  | wf_process_3
Special Ed | 2005-07-26 00:00:00
Y_divider
YICSIS | 2003-08-07 00:00:00 | Enrollments | If a corresponding enrollment row is not found in the student_enrollment table in the [NAME] an enrollment row will be added, the YICSIS membership will be inserted into the yic_membership_days field in the student_enrollment table of the row that was just inserted, and the loaded from source field will be set to 'Y'. After the first enrollment from YICSIS is loaded if another enrollment is encountered for the same school; the YICSIS membership will be added to the value in the yic_membership_days. 2) If a corresponding enrollment row is not found in the student_enrollment table in the [NAME] an enrollment row will be added, the YICSIS membership will be inserted into the yic_membership_days field in the student_enrollment table of the row that was just inserted, and the loaded from source field will be set to 'Y'. After the first enrollment from YICSIS is loaded if another enrollment is encountered for the same school; the YICSIS membership will be added to the value in the yic_membership_days. | Warehouse Group
YICSIS | 2003-08-07 00:00:00 | Enrollment | Enrollment Selection Criteria : Select enrollment data where's the dates are between July 1 and June 30 and where the program code in not [NAME] or ISI-1. [NAME] added a flag : tbl_schools.sch_upass_export = 1 .
YICSIS | 2003-08-07 00:00:00 | Enrollments Reminder | The program code list has been expanded for the 2003 school year. When we process the 2003 YICSIS enrollments we will have to apply a set of rules to the membership days based on the program codes before we enter the values into the Warehouses tables. | Warehouse Group
YICSIS | 2003-08-13 00:00:00 | Course Hours to Days | Course hours will be converted as follows:            li_num = (ad_credits/.25) li_days = li_num * 45 return li_days
YICSIS | 2003-08-13 00:00:00 | Courses Where Credit Given | Courses for YICSIS enrollments will only be inserted in the [NAME] if they were given credit. | Warehouse Group
YICSIS | 2003-04-10 00:00:00 | Teachers Reporting | Teachers will need to be reported under a generic ID for this year and measures put in place to collect the correct data for next year
AMAO divider
AMAO | 2007-07-10 00:00:00 | AMAO Business Rules | 1. Annual increases in the number or percentage of children making progress in learning English FAYD - Compares students in the state last year with the FAY students in the district this year. [NAME] - not included in progress calculation as there is not a previous year for comparison.  Y and U codes for ELL students will not be included in the progress calculation  For the school year 2006-2007 The percentage of students who move from one proficiency level to a higher proficiency level from 2006- to 2007. August 2007, determine the required % of students that move For the school year 2007-08 The percentage of students who increase __ # of scale score points from 2007 to 2008. August 2007, determine the # of scale score points.
AMAO | 2007-07-10 00:00:00 | AMAO Business Rules | 2. Annual increases in the number or percentage of children attaining English proficiency FAYD - Compares students in the state last year with the FAY students in the district this year. [NAME] - not included in progress calculation as there is not a previous year for comparison.  Y and U codes for ELL students will not be included in the progress calculation  For the school year 2006-2007 The percentage of students who were A, B, C in 2006 and who are A or F in 2007. August 2007, determine the required % of students that move to A or F. For the school year 2007-08 The percentage of 2008 students who had a scale score of 1 - __  in 2007 and who have a scale score of ___ or higher in 2008. August 2007, determine the scale score points.
AMAO | 2007-07-10 00:00:00 | AMAO Business Rules | Making AYP for ELL Same as last year
[NAME]
AYP | 2006-11-07 00:00:00 | Full Academic Year (FAY) | Full Academic year 2003-  1.  Student who was in membership on Oct 1 2.  Student membership >=145    2.1 Student membership = School Membership +            Special Ed Membership (Self-Contained)+ YIC membership Full Academic year 2004-2006 1.  Student who was in membership on Sept. 15th  2.  Student membership >=160    2.1 Student membership = School Membership +            Special Ed Membership (Self-Contained)+ YIC membership 3.  If the school's first day of membership is after Sept. 14th then the constraint "Student who was in membership on Sept. 15th" will not be applied Full Academic year 2007 Student membership >=160    Student membership = School Membership +            Special Ed Membership (Self-Contained)+ YIC membership | [NAME]
AYP | 2011-08-05 00:00:00 | [NAME] | The subgroups to be included in the [NAME] reports are: All Students (Whole School, LEA or State), Asian, African American, American Indian, Caucasian, Hispanic, Pacific Islander, Economically Disadvantaged, Limited English Proficient, Students with Disabilities | [NAME]
AYP | Updated 8/31/2004 | Modified CRT Tests | Modified tests are any test that [NAME] defines as being modified (separate test file), or have a participation code of modified (2).  Modified tests are used for AYP - However, the validated (AYP) proficiency is set to 1 on ALL TESTS | [NAME]
AYP |  | Out-of-level and Modified tests | Out-of-level (participation code 3)and Modified tests are used in the U-PASS report as they are.  However, the validated_proficiency will be set to 1 (not proficient) for the [NAME] report. | [NAME]
AYP | Updated 8/8/2006 | Participation | For 2003, Participation is defined as  CRT students that matched clearinghouse students and did NOT have a non-participation code of 1 or 2 (Absent & Excused) divided by all matching students.  There must be at least 40 students in a subgroup to count for the 95% rule. For 2004  Missing tests will be handled by the testing process.  Same as 2003 with the exception that participation percentage can be averaged over the previous two years, if necessary.  If this does not help, the current year participation percentage will be used.  There must be at least 40 students in a subgroup to count for the 95% rule.  The current year's participation % will be published in the report.  If the averaging pushes the group over the 95% minimum it will be footnoted. For 2005 and beyond  Same as 2004 AND all non-participation codes of 2 (Excused) will no longer be removed from the numerator for participation percentage (they will count as participants) | [NAME]
AYP | Updated 8/8/2006 | Non-participation | 2003 - Tests marked with a non-participation code of 1 or 2 (absent & excused) AND a overall score > 0 will have the non-participation code deleted.  2004 - Tests marked with a non-participation code of 1 or 2 (absent & excused) AND a response count > 0 will have the non-participation code deleted.  2005 and beyond - Same as 2004 for removing the non-participation code.  2007 - Tests marked with a non-participation code of 1 or 2 (absent & excused) AND a response count > 0 will have the non-participation code deleted.  Non-Participating students will not count against the school in the Academic Achievement column -- Students with a 1 or 2 in non-participation (Absent/Excused) are dropped from Academic Achievement calculations. 2009 -  Students with Non-Participation code of 1 - Absent, or 2 - Excused will no longer be removed if there are responses.  The only Non-Participation code that will be removed is Unknown student.  Unknown student will only be removed if there are answers on the test and the student has an SSID in the school where the test was taken. | [NAME]
AYP |  | Academic Achievement | Non-Participation will not count against the school in the Academic Achievement column -- Students with a 1 or 2 in non-participation (Absent/Excused) were dropped from Academic Achievement calculations A Minimum  of 10 students are required to have the subgroup count in the [NAME] calculation. | [NAME]
AYP |  | 3-8th grade | Schools without a twelfth grade will use grades 3-8 for language arts and math.  The 3-8 Annual Measurable Objective (AMO) will be used to determine Pass/Fail for AYP | [NAME]
AYP |  | 12 grade | Schools that have a twelfth grade will use 10th grade language arts and 10th-12th grade elementary algebra or geometry.  The 12th grade Annual Measurable Objective (AMO) will be used to determine Pass/Fail for AYP | [NAME]
AYP | 2003-12-01 00:00:00 | Multiple Tests | If a student has multiple tests in the same subject area, the test that matches the grade level of the student will be used (if one exists).  If one does not exist in grade level, the highest level test will be used (above grade level or below).  See U-PASS business rules U-PASS report | [NAME]
AYP | 2004-08-31 00:00:00 | UAA Tests | Definition - UAA tests are those with a participation code of UAA (4) listed on the test and those tests that [NAME] gives us separately designated as UAA by the file.   Rules - If we receive a UAA test for a subject other than Language Arts or Math, we will code that test as ??? (not valid).  If we receive a test with a participation code of UAA (4) and do NOT receive a UAA test through the normal channel, we will use the proficiency (both proficiency and validated proficiency) on the UPASS and [NAME] reports respectively.  If we DO receive a UAA test, through [NAME]'s process, we will code the first UAA test (received through the standard testing file) as not to be used in any reporting or profiles.
AYP | 2006-05-04 00:00:00 | 1% UAA tests  (2005) | UAA tests are included up to 1% - need rules for how to set the line ? … This will be implemented in the 05/06 school year 2005 - LEA's will be able to appeal if the school does not pass based on Students with Disabilities subgroup proficiency ONLY - based on the 2% rule.  The 2% rule does not apply to Safe Harbor or the confidence interval. 2008 - Proficiency on the Utah Alternate Assessment will be limited to 1% of the total state enrollment. (from the [NAME]) | [NAME] | Language Arts –   by grade level  Math - by grade level through 7th grade    - 8th graders will be combined with 7th grade math   - 9th – 12th graders will be combined with Geometry Science -- by grade level through 7th grade   - 8th graders will be combined with 7th grade science   - 9-12th graders will be combined with Biology
AYP | 2006-08-11 00:00:00 | District AYP Pass/Fail | An LEA will receive a report based on both 3-8th and 10-12th grade AMO's.  An LEA must fail at both the 3-8 AND the 10-12 grade levels to fail [NAME].  (It is possible for an LEA to not pass [NAME] and yet not be put into 'Improvement' because 'Improvement' considers 'subject' in addition to grade levels whereas 'not making [NAME]' does not. | [NAME]
AYP | 2007-07-10 00:00:00 | District AYP | If LEA has two grade spans that meet the minimum n, if the LEA fails for both 3-8 and 10-12 the LEA fails [NAME]. If LEA has only one grade span that meets the minimum n, if the LEA fails, the LEA fails AYP
AYP | 2006-08-11 00:00:00 | District AYP Program Improvement | An LEA is identified for improvement only when it misses [NAME] in the same subject and in all grade spans for two consecutive years, or the other academic indicator in all grade spans for two consecutive years. | [NAME]
AYP | 2003-11-14 00:00:00 | LEP Subgroup | 2004 ELL students will count in the LEP subgroup for two years past their exit of the ELL program.  This is determined by the lep_exit_date in the student_lep table of the warehouse. 2007 Revised to include students for 2 school years past the school year in which they exit. | [NAME] | 2004 is the first year lep_exit_date has been collected This means that if a student's exit date is sometime in the 2004 school year they will continue to be counted in the 2004 and 2005 school years in the LEP AYP subgroup 2007 - Revision LEP Exit Date is in SY2006.  They student will count for SY2006, SY2007 & SY2008
AYP | 2004-09-20 00:00:00 | [NAME] | The Attendance Rate must be >= 93% to pass [NAME]  or any improvement from the previous year.  If there is no previous year attendance rate or the N is less than 40 (current OR previous year), this condition is automatically met. [NAME] = (Total days_attended) /  (days_membership + special_ed_membership + yic_membership_days) | [NAME]
AYP | 2006-08-08 00:00:00 | [NAME] | If a student participated in either a LA test or a MA test then that student will be included in the attendance rate  calculation.  2008 - Attendance rate includes all students enrolled in the school for any period of time. | [NAME]
AYP | 2006-08-08 00:00:00 | Graduation Rate | Graduation Rate must be >= 85.7% to pass [NAME].  Used in the Whole School subgroup for schools with a 12th grade only. The grad_rate_ayp_status column is set to N/A if the cohort size is less than 40, No if the rate is < 85.7 or does not show improvement from the previous year, and Yes otherwise.  2008 - Graduation Rate will be used as the Additional Indicator for all student groups (subgroups) where the group meets the minimum N (40).  If the rate is below 85.7% for a group that does not have a previous year to compare to (all groups except Whole School), then attendance rate will be used in it's place. | [NAME]
AYP | 2006-08-08 00:00:00 | Safe Harbor – Achievement Calculation | 10 or more students will be needed in each of the two years to perform the computation and apply the confidence interval (standard error of measure).  If less then 10 in either year then, “group too small to require to meet standard”. | [NAME]
 |  | STATUS Confidence Interval | See AYP documentation or programming terms spreadsheet | [NAME]
AYP |  | Safe Harbor (Achievement) | Computed variable called safe_harbor_perc = ((100- 2003 % Proficient)* 0.90)   SAFE HARBOR is Yes, if  (100- 2004 % Proficient) is <= safe_harbor_perc | [NAME]
AYP | 2007-07-10 00:00:00 | Program Improvement Report | Change question from Is the school/district in Program Improvement to    Is the school/district in Title I program Improvement?   Change statement Year in Program Improvement to    Year in Title I Program Improvement  In answer to the question at the bottom of the report, Is the district/school in Title I Program    Improvement?      Not Title I  (Eliminate statement, Year in Program Improvement)    No (Show year of program improvement for language arts and math - 0)    Yes (Show year of program improvement for language arts and math)
AYP | 2007-07-10 00:00:00 | Program Improvement (School) | If school fails AYP for 2nd year in same subject area (for any reason) they are in program    improvement for 1st year.  A school must pass AYP for 2 consecutive years in the same subject that caused them to be    in program improvement to get out of program improvement  If school was in program improvement last year, pass the same subject area that caused them    to be identified as program improvement for this year, then year in program    improvement for that subject area stays the same  If school was in program improvement last year, fail in same subject this year, then    year in program improvement increases by 1.  If school was in program improvement two years ago, pass in same subject that caused them    to fail for two consecutive years, then year in program improvement in that subject area is    0.  Schools that change from Title I school to not Title I school – are no longer in program    improvement  Schools that change from not Title I school to Title I school begin as year one for [NAME].
AYP | 2006-10-12 00:00:00 | Program Improvement (School) | A school enters 'program improvement' for the purposes of Title I regulations when it does not make AYP in the same subject for two consecutive years.  Each following year that the school does not make AYP in that same subject it advances one more year in program improvement status.   If the school makes AYP in that subject for one year, after having been identified, it remains at the same program improvement status level as the previous year. To exit program improvement, the school must make AYP in that subject for two consecutive years.  An appeal is considered making AYP in all subjects.
AYP | 2007-07-10 00:00:00 | Program Improvement (District) | If district has two grade spans with a minimum n for each grade span   Language Arts Pass = a pass in language arts for 3-8 or 10-12   Math Pass = a pass in math for 3-8 or 10-12  If district has one grade span with a minimum n for the grade span   Language Arts Pass = a pass in language arts for the grade span   Math Pass = a pass in math for the grade span  If district fails AYP for 2nd consecutive year in same subject area for all grade spans in which    they have a sufficient n they are in program improvement for 1st year.  A district must pass AYP in the same subject area that caused them to be in program    improvement for 2 consecutive years in at least one grade span to get out of program    improvement.  If district was in program improvement last year, but pass the same subject area that caused    them to be identified as program improvement for this year, in at least one grade span,     then year in program improvement for that subject area stays the same  If district was in program improvement last year, fail in same subject this year, then    year in program improvement increases by 1.
AYP | 2006-10-12 00:00:00 | Program Improvement (District) | A district enters 'program improvement' for the purposes of Title I regulations when it does not make AYP in the same subject, in both grade levels (3-8 & 10-12), for two consecutive years.  Each following year that the district does not make AYP in that same subject, in both grade levels, it advances one more year in program improvement status.   If the district makes AYP in that subject, in both grade levels, for one year, after having been identified, it remains at the same program improvement status level as the previous year. To exit program improvement, the district must make AYP in that subject, in both grade levels, for two consecutive years.  An appeal is considered making AYP in all subjects.
AYP | 2007-07-10 00:00:00 | RT - student refused to test | Tests marked with a participation code of RT AND a response count > 0, then the RT code is    removed and the test is scored for both participation (add to numerator and denominator)    and academic achievement (proficiency calculations)    If the response count is zero then the RT code is retained and the test is included in    participation (add to numerator and denominator) calculations and as non proficient in     academic achievement
AYP | 2006-11-07 00:00:00 | Refused to Test Code (RT) | The "RT" code is designed for students, and/or parents on behalf of students, who refuse to take the assessment.  This student's test WILL be counted for participation purposes but the academic score will NOT be calculated. | [NAME]
AYP | 2007-11-05 00:00:00 | To be added | If any CRT score is present, then all UAA scores (math, language arts, science) are set to non-proficient.  If any test (CRT, UBSCT, DWA,) is modified, then the scores are set to non-proficient and a new report will be sent to the LEA with their other reports.  If any CRT is out-of-level, then the scores are set to non-proficient and a new report will be sent to the LEA with their other reports.  Science UAA scores for grades kindergarten through grade 3 are not used in AYP or U-PASS  Language arts and math UAA scores for kindergarten through grade 2 are not used for U-PASS
AYP | 11 | To be added | Proposal to report schools with a single year of data as passing - [NAME] page 47 (Safe Harbor applied)
AYP | 2008-06-24 00:00:00 | Same Student Safe Harbor | For student groups that do not meet the status AMO and do not meet the standard safe harbor requirement, a Safe Harbor Same Student Calculation will be applied.  This approach compares the performance of students in the student group enrolled for a full academic year that did not meet either the status or safe harbor targets with the performance of these same students in the prior year (as long as they were tested anywhere in Utah) to determine if there was a 10% reduction in the percentage of these matched students scoring below proficient.  This calculation will not include a confidence interval,  and will only be applied when there is a 95% match rate for the student group. | [NAME] | 2008 [NAME] 27
AYP
AYP
AYP
School Program Improvement Rules divider
School Program Improvement Rules | 2007-07-10 00:00:00 | Individual School Rules
U-PASS Divider
U-PASS | 2008-07-01 00:00:00 | [NAME] Level of Performance | Schools achieve if:  1) Whole school and subgroups attendance percentage = 95% or greater, AND 2) whole school status is >= 77% or whole school progress is >= 176 (with 95% confidence interval), AND 3) subgroups status is >= 77% or subgroups progress is >= 176 (with 95% confidence interval). | [NAME] | The numbers for passing changed from 80% to 72% for proficiency and from 190 to 176 for progress in the 2008-09 school year
U-PASS | 2008-07-01 00:00:00 | High Schools Achieved State Level of Performance | Schools achieve if:  1) Whole school and subgroups attendance percentage = 95% or greater, AND 2) whole school status is >= 72% or whole school progress is >= 167 (with 95% confidence interval), AND 3) subgroups status is >= 72% or subgroups progress is >= 167 (with 95% confidence interval). | [NAME] | The numbers for passing changed from 75% to 72% for proficiency and from 180 to 167 for progress in the 2008-09 school year
U-PASS (HS) | 2007-07-10 00:00:00 | Status - High School | Separate document
U-PASS (HS) | 2007-07-11 00:00:00 | Status - High School | 30% language arts, 25% math, 20% science, 10% attendance, 15% graduation rate.  [Note: If any of these components are missing or N/A, the weight of the missing component is split equally between the remaining components being calculated]
U-PASS (N-HS) | 2006-02-17 00:00:00 | Status - Non-High School | 35% language arts, 35% math, 20% science, 10% attendance
U-PASS (HS) | 2006-02-17 00:00:00 | High School (HS) | Any school with a 12th grade.
U-PASS (N-HS) | 2006-02-17 00:00:00 | Non-High School (N-HS) | Any school that does not have a 12th grade.
U-PASS | 2006-02-17 00:00:00 | Subgroups | If a student is identified as belonging to any of the following classifications, their proficiency score will be used in the school’s Subgroups' status and progress calculations: • African American • American Indian • Asian • Hispanic • Pacific Islander • Economically Disadvantaged • Limited English Proficient • Students with Disabilities If a student is identified in more than one of the classifications their proficiency score will only be used once.
U-PASS | 2006-08-08 00:00:00 | Individual Subgroup | Each of the following individual subgroups will be reported on the front page of the U-PASS report as having met, or not met, proficiency standards for status and progress: • African American • American Indian • Asian • Caucasian • Hispanic • Pacific Islander • Economically Disadvantaged • English Language Learners • Students with Disabilities Although this information is reported by individual subgroup, it is not calculated individually (see 'Subgroups') | [NAME]
U-PASS | 2006-08-11 00:00:00 | Progress - CRT's | Progress is a longitudinal measure comparing the achievement levels of the same student from one year to the next year.  The following grades and subjects are included:  language arts (grades 3-11); math (grades 3-7, Pre-algebra, Algebra, Geometry, Applied Math I, Applied Math II); science (grades 4-8, Earth Systems, Biology, Chemistry, Physics).  [NAME] is two year's consecutive CRT scores.  If a student has two scores in one year, the comparison will use the highest score.  Progress is calculated for any student that can be appropriately identified within the Utah State Educational system.  The progress score will be assigned to the school which has the student for the current (full) year.
U-PASS | 2006-08-08 00:00:00 | Progress - not calculated | Progress is not calculated on the DWA.  [NAME] will not be calculated on course titles (such as calculus, trigonometry, etc.) for the school years ended 2005 and 2006.  [NAME] is not calculated for 3rd grade.
U-PASS | 2006-02-17 00:00:00 | 2005 Reports - not available | For the school year ending 2005, high schools will not be reported.  Other components related to a high school such as graduation rate, course trends, etc. will also not be reported.
U-PASS | 2006-08-08 00:00:00 | 2006 Reports - not available | For the school year ending 2006, high schools will not be reported.  Other components related to a high school such as graduation rate, course trends, etc. will also not be reported. | [NAME]
U-PASS | 2006-02-17 00:00:00 | Progress Categories - High School | 30% language arts, 25% math, 25% science, 10% attendance, 10% graduation rate.
U-PASS | 2006-02-17 00:00:00 | Progress Categories - Non-High School | 35% language arts, 35% math, 20% science, 10% attendance.
U-PASS | 2006-08-08 00:00:00 | Progress Levels of Achievement | Low = 0 – 189, medium = 190 – 214, high = 215 – 400 | [NAME]
U-PASS | 2006-04-12 00:00:00 | Progress Table
U-PASS | 2006-02-17 00:00:00 | Attendance - Status | Percentage of students absent fewer than 15 days per year.  Related to membership days - the formula reads:  If membership is >10 then calculate attendance.
U-PASS | 2006-08-08 00:00:00 | Attendance - Progress Table | School average based on per student year-to-year calculations: | [NAME]
U-PASS | 2006-08-08 00:00:00 | Confidence Interval | A confidence interval of 95% will be applied to calculate 1) whole school, 2) subgroups, and 3) individual subgroups. | [NAME]
U-PASS | 2006-08-11 00:00:00 | Confidence Interval Formula - Status |  | [NAME]
U-PASS | 2006-08-08 00:00:00 | Confidence Interval Formula - Progress |  | [NAME]
U-PASS | 2011-06-16 00:00:00 | Criterion-referenced Tests (CRT's) | ELA grades 3-11; Math grades 3-7, Pre-algebra, Algebra I and II, Geometry, Science grades 4-8, Earth Systems, Biology, Chemistry, Physics.
U-PASS | 2009-08-11 00:00:00 | CRT Percent Proficient | The number of students proficient (levels 3 or 4) divided by the number of students who met the attendance criteria for the year and took that particular CRT test. Students who are not Full Academic Year students or who are withdrawn, or unknown students are excluded from the proficient calculation. |  | The students whose Language Arts test is marked as "ELL First Year in U.S. Before April 15" or students whose clearinghouse records indicates a first enroll in U.S. date between July 1st and April 14th of the reported school year are excluded from the proficiency calculation for Language Arts.
U-PASS | 2007-07-10 00:00:00 | CRT Retakes | If the student takes the same test more than once the 2nd and any subsequent test will not be used in accountability Exception -- UAA
U-PASS | 2007-07-10 00:00:00 | Earth Systems Science CRT | Any student grades 9-12 taking this course and [NAME] will be included in participation and academic achievement
U-PASS | 2011-06-16 00:00:00 | Direct Writing Assessment (DWA) | Administered to 5th and 8th grade students.  It is used for the status calculations for schools with a 6th and/or 9th grade.  The DWA results will be reported by the four proficiency levels.  If a school does not have a DWA test calculated for their report, the ELA CRT's counts for 35% of the total.  If a DWA test was administered, the DWA score counts for 5% and the ELA CRT's count for the other 30%.  If a school has both a 5th and a 8th grade, the DWA scores will be combined to achieve the 5% 'DWA' portion of the total ELA score.  FAY rules apply when deciding which student's DWA scores are to be calculated for the school's report.  Any students taking the DWA test will also be counted in the school's participation calculation. | [NAME]
U-PASS | 2006-08-08 00:00:00 | English Language Learners (ELL) - Status | Also referred to as Limited English Proficient (LEP).  For the 2005 and 2006 U-PASS calculations, CRT proficiency is used for ELL students.  Students who have achieved Level D are counted as ELL for two additional years. | [NAME]
U-PASS | 2006-08-08 00:00:00 | English Language Learners (ELL) - Progress | For the 2005 and 2006 U-PASS calculations, CRT proficiency and progress is used for ELL students.  Students who have achieved Level D are counted as ELL for two additional years. | [NAME]
U-PASS | 2006-02-17 00:00:00 | English Language Learners (ELL) - Participation | 2008 - If a student’s “first year in U.S.” date is prior to April 15, that student will participate in the math and science portion of year-end testing but is exempt from participating in the language arts.  Neither their math, science, nor their language arts test scores will be used for academic calculations.    If the student’s “first year in U.S.” date is April 15, or later, the student is exempt from participating in testing through the end of the school year.  That student will participate in the math and science portion of  year-end testing the following year (their first full academic year), but is exempt from participating in the language arts the following year (first full academic year).  Neither their math, science, nor their language arts test scores will be used for academic calculations during that first  academic year following the first year in U.S.  UBSCT scores are included in academic calculations including first year in U.S.  2006 - If a student’s “first year in U.S.” date is prior to April 15, that student will participate in the math portion of  year-end testing but is exempt from participating in the language arts and science tests.  Neither their math, science, nor their language arts test scores will be used for academic calculations.    If the student’s “first year in U.S.” date is April 15, or later, the student is exempt from participating in testing through the end of the school year.  That student will participate in the math portion of  year-end testing the following year (their first full academic year), but is exempt from participating in the language arts and science tests the following year (first full academic year).  Neither their math, science, nor their language arts test scores will be used for academic calculations during that first full academic year.  2007 -  April 15th or later – not required to participate in assessments, however, if an answer document is received, it is scored but not included in accountability First year in US and/or prior to April 15th – required to take math CRT for participation but not included in Accountability for achievement; not required to take language arts CRT, however, if an answer document is received, it is scored but not included in accountability  U-PASS same as [NAME] except for U-PASS progress, the 1st year test if in US less than one year is not included in calculation.  Clearinghouse – beginning 08   Yes – ELL; replaced by UALPA proficiency code/score of current year, previous year if there is no current year proficiency code/score, leave a Y as an untested student.  If  previous year score is used, the file will so indicate.   U – ELL & [NAME] – not ELL   Proficiency Codes – A, F  Warehouse – beginning 07   Proficiency Codes – P, E, I, A, F  AYP & U-PASS; ELL subgroup all students with a UALPA proficiency code/score or Y or U, A or F  AMAO enrollment – all ELL students  AMAO Proficiency & Progress Calculations - only use students with a UALPA proficiency code/score for current year   If student has a clearinghouse data element that identifies him/her as LEP, but no UALPA scaled scored, then the UALPA proficiency score will be left blank.  If student has a UALPA scaled score, but no LEP information then parent or primary  language or instructional type is marked as unknown. LEP will be marked as Y.    If a student has a UALPA code or an ELL code from the clearinghouse, they are counted as ELL in AYP and UPASS.
U-PASS | 2011-06-16 00:00:00 | Utah Academic Language Proficiency Assessment (UALPA) | UALPA proficiency levels are: Pre-emergent (Level P) / "IPT Level A", Emergent (Level E) / "IPT Level B", Intermediate (level I) / "IPT Level C", Advanced (Level A) / "IPT Level D", Fluent (Level F) / "IPT Level E".  Beginning in 2007, the UALPA proficiency will replace CRT proficiency for Levels Pre-Emergent (P), Emergent (E), & Intermediate (I) if the student has been in the United States for less than three years.  For the school year ending 2006 the IPT codes will be used Beginning in school year 2010-11, the UALPA proficiency levels are 1, 2(a & b), 3(a & b), 4, 5 | [NAME]
U-PASS | 2006-08-08 00:00:00 | Graduation Rate - Status & Progress | The graduation rate is applied to high schools only and will not be calculated for the 2005 and 2006 reports. | [NAME]
U-PASS | 2006-02-17 00:00:00 | "N" Size | Participation N>=40, [NAME]
U-PASS | 2006-02-17 00:00:00 | Out of Level | Out-of-Level tests will be included in the grade level of the test | [NAME] | Ex.  If a 4th grade student takes a 3rd grade test, the proficiency of the test is counted in the percentages for the 3rd grade
U-PASS | 2006-02-17 00:00:00 | Participation | Missing tests will be handled by the testing process.  Same as 2003 with the exception that participation percentage can be averaged over the previous two years, if necessary.  If this does not help, the current year participation percentage will be used.  There must be at least 40 students in a subgroup to count for the 95% rule.  The current year's participation % will be published in the report. | [NAME]
U-PASS | 2007-07-10 00:00:00 | Blank Answer Document | Blank answer documents are always given a score of zero.  Any special codes are maintained as reported by the LEA. 2007-08 -- default to absent
U-PASS | 2006-02-17 00:00:00 | Non-participants | Non-Participation codes 1 & 2 are excluded from the numerator and denominator for % proficient | [NAME]
U-PASS | 2006-02-17 00:00:00 | Accommodated & Modified | 2003 - Modified tests were not included 2004 - Modified tests will be included in the U-PASS report.  Accommodated tests are also included. | [NAME]
U-PASS | 2006-02-17 00:00:00 | Utah Alternate Assessment (UAA) | UAA tests are included | [NAME] | Language Arts –   by grade level  Math - by grade level through 7th grade    - 8th graders will be combined with 7th grade math   - 9th – 12th graders will be combined with Geometry
U-PASS | 2006-02-17 00:00:00 | UAA Tests | Definition - UAA tests are those with a participation code of UAA (4) listed on the test and those tests that [NAME] gives us separately designated as UAA by the file.   Rules - If we receive a UAA test for a subject other than Language Arts, Math, or Science, we will code that test as (not valid).  If we receive a test with a participation code of UAA (4) and do NOT receive a UAA test through the normal channel, we will use the proficiency (both proficiency and validated proficiency) on the UPASS and [NAME] reports respectively.  If we DO receive a UAA test, through [NAME]'s process, we will code the first UAA test (received through the standard testing file) as not to be used in any reporting or profiles. | [NAME]
U-PASS | 2007-07-10 00:00:00 | UAA | UAA tests are included as proficient for up to 1% in the state. | [NAME]
U-PASS | 2006-08-08 00:00:00 | 1% UAA tests  (2005 and 2006) | UAA tests are included up to 1% | [NAME] | Language Arts –   by grade level  Math - by grade level through 7th grade    - 8th graders will be combined with 7th grade math   - 9th – 12th graders will be combined with Geometry
U-PASS | 2006-04-25 00:00:00 | UAA Proficiency | The UAA tests are scored with proficiency levels of 1, 2, 3, and 4.  Unlike the CRT's, the UAA results do not have a scaled score.  For U-PASS purposes of 1a, 1b, 2a, and 2b, the UAA scores will be interpreted to mean UAA 1 = U-PASS 1b, UAA 2 = U-PASS 2b. UAA Progress was not used in the 2004-2005 reports but will be used in the 2005-2006 reports. | [NAME]
 | 2006-04-25 00:00:00 | UAA Progress Table
U-PASS | 2006-02-17 00:00:00 | Scores used in the UPASS percentages | 2003 Any Test with a 0 score was dropped and not included in the percentage 2004 Tests with a participation code of "Attempted" will be counted even if the response count is 0.  Otherwise, 0 response counts will be dropped (with the exception of UAA tests which also have a response count of 0). | [NAME]
U-PASS | 2006-02-17 00:00:00 | Per-K and [NAME] tests | Pre-K and [NAME] tests are NOT Loaded into the warehouse
U-PASS | 2006-02-17 00:00:00 | Class [NAME] | 2004 Class [NAME] is based on students in membership on October 1 for specific course codes.  The number of classes is determined by a distinct count of course-section/class period/teacher within a specific course code; i.e. [NAME] or [NAME]. | [NAME], [NAME], [NAME],  [NAME],  [NAME] | See spreadsheet for how course codes are grouped in the report Ex.   Course Section - Class Period - Teacher  - Students Ele Grade 4      -        01         -   97052   -    20 Ele Grade 4      -        01         -   93456   -    21 Ele Grade 4      -        01         -   96123   -      5  # of Students  46 # of Classes    3 Avg Class Size 15
U-PASS | 2006-02-17 00:00:00 | Out-of-level and Modified tests | Out-of-level (participation code 3) and Modified tests are used in the U-PASS report as they are.
U-PASS | 2009-02-17 00:00:00 | Mobility | A student who spends less than a full 180 days, or its equivalent, (days in membership * days in school year / 180) in one school.   SY2009 - change 180 to 160
U-PASS | 2006-02-17 00:00:00 | Appeals | Results will be available for a district appeal, not to exceed 30 days.  The District Superintendent will review the data and determine whether an appeal is appropriate.  Appeals must be based on documented evidence.  Documentation of the appeal will be kept at the district office.  The District Superintendent will notify the USOE in writing of the decision to appeal a particular school(s) during the appeal period.  The USOE will provide written verification that the appeal is received.  Following the appeal period, U-PASS will be released to the public.
U-PASS | 2007-07-10 00:00:00 | Full Academic Year (FAY) | 160 days or more of membership
U-PASS | 2006-11-07 00:00:00 | Full Academic Year (FAY)  Student Membership | Student membership >=160    Student membership = School Membership +            Special Ed Membership (Self-Contained)+ YIC membership
U-PASS | 2006-02-17 00:00:00 | Confidence Interval - Status | meansclscore = weighted school status score (Math, ELA, Science & Attendance) nELAtests= the number of ELA test scores for the school of interest. *This is calculated for both total school and subgroup
U-PASS | 2006-02-17 00:00:00 | Confidence Interval - Progress | meanvtscoreschool = weighted value table score for the school (Math, ELA, Science & Attendance) ELAvtscorestudent = ELA value table score for the student meanELAvtscoreschool  = average ELA value table score for the school to which the student belongs nELAtests= the number of ELA test scores for the school of interest nschools = the number of schools *This is calculated for both total school and subgroup In the rare case where a subgroup has a 'low' score based on the raw calculation but, because the n size is small enough, the confidence interval would allow a 'high' possibility - the report will reflect 'medium' as the progress result.
U-PASS | 2006-02-17 00:00:00 | ADA | See Data Dictionary for definition | [NAME]
U-PASS | 2006-02-17 00:00:00 | [NAME] | See Data Dictionary for definition | [NAME]
U-PASS | 2006-02-17 00:00:00 | Academic Tests Counted (2005) | LA - 3RD, 4TH, 5TH, 6TH, 7TH, 8TH, 9TH, 10TH, 11TH. MA - 3RD, 4TH, 5TH, 6TH, 7TH, PRE-ALG, APP MA I, APP MA II, ELEM ALG, GEO. SCI - 4TH, 5TH, 6TH, SCI GRADE 6, 7TH GRADE SCI, 7TH GRADE INTEG SCI, 8TH, 9TH GRADE SCI, BIO, CHEM, PHYS.
U-PASS | 2006-08-08 00:00:00 | Academic Tests Counted (2006) | LA - 3RD, 4TH, 5TH, 6TH, 7TH, 8TH, 9TH, 10TH, 11TH. MA - 3RD, 4TH, 5TH, 6TH, 7TH, PRE-ALG, ELEM ALG, GEO. SCI - 4TH, 5TH, 6TH, SCI GRADE 6, 7TH GRADE SCI, 7TH GRADE INTEG SCI, 8TH, 9TH GRADE SCI, BIO, CHEM, PHYS. | [NAME]
U-PASS | 2006-02-17 00:00:00 | Rounding of Results | For the purposes of calculating results, scores are aggregated and then the sum is rounded according to common practice, i.e. .5 and above is raised to the next whole number. | [NAME]
U-PASS | 2006-08-08 00:00:00 | Graduation Rate | The grad_rate_ayp_status column is set to A if the cohort size is less than 40, N if the rate is < 85.7 or does not show improvement from the previous year, and Y otherwise.
U-PASS | 2004-10-20 00:00:00 | Grad Rate Calculation | The graduation rate is equal to the number of regular high school graduates divided by the sum of regular high school graduates + the 12th grade dropouts for the same year + the 11th grade dropouts for the prior year + the 10th grade dropouts for the year before the prior year. |  | The following formula may clarify the description.     grad rate = regular diploma students / ( regular diploma students + 12th grade dropouts from same year + 11th grade dropouts from prior year + 10th grade dropouts from the year before the prior year)
U-PASS | 2006-04-12 00:00:00 | [NAME] | If a school is labeled with a code of "A" or "S" (meaning they either have no data or the data is incomplete) the U-PASS web report will show an information screen explaining that this school has unique circumstances
U-PASS | 2006-08-21 00:00:00 | Algebra / Geometry Two-year courses | A school may choose to offer students with special needs the ability to take specifically designed courses allowing two years to complete the normally-paced one year course.  The school must use the state approved course codes.  Students are tested on the CRT exams at the end of the two year period.  Students will not be tested on any content at the end of the first year | [NAME]
U-PASS | 2007-07-10 00:00:00 | Refused to Test Code (RT) | The "RT" code is designed for students, and/or parents on behalf of students, who refuse to take the assessment.   Tests marked with a participation code of RT AND a response count > 0, then the RT code is  removed and the test is scored for both participation (add to numerator and denominator)  and academic achievement (proficiency calculations)   If the response count is zero then the RT code is retained and the test is included in  participation (add to numerator and denominator) calculations and as non proficient in academic achievement. | [NAME]
U-PASS | 2007-07-10 00:00:00 | Student takes test in a different school than resident school | Student participation and academic achievement resides in resident school.  Resident school is the school in which the attendance of the student is tracked, recorded and submitted.   ADDENDUM: 2007  Granite School District shall be an exception with regards to the students reported under the school number 800. This rule will apply to the 2007 reporting year only.
U-PASS | 2007-07-11 00:00:00 | Late Answer Documents | Traditional schools:  Prior to, and including, June 25th, tests will be scanned, scored, and included in accountability. Year-round schools:  Prior to, and including, July 6th, tests will be scanned, scored, and included in accountability. Tests received after these dates will not be scored and will be counted as 'absent'.
U-PASS | 2007-07-11 00:00:00 | Multi-level Classrooms | If approved by a State Assessment Director, student receives achievement and participation for the test that they take. |  | This is defined as a combination of students from multiple grades into one class, with the curriculum being rotated through the years. This occurs when one teacher instructs students of multiple grade levels but desires to administer only one grade level CRT.
U-PASS | 2007-07-11 00:00:00 | Students with Disabilities (SWD) | Students who have exited the special education program are counted as SWD for two additional years following the year in which they exited.  (To be applied beginning Aug. 2008) | [NAME]
U-PASS | 2007-07-11 00:00:00 | Unreturned Answer Documents | Documents submitted for the preprint that are not returned for scoring will be counted as 'absent'.
U-PASS (HS) | 2007-07-11 00:00:00 | Pre-algebra | Any student in grade 9 or higher taking this test will be included for participation but the score will be deemed 'not proficient'.
U-PASS (HS) | 2007-07-11 00:00:00 | Minimum School Size | In order for a school to generate a U-PASS report it must have a minimum of 40 students participate in either math, language arts, or science.  The school must also have a minimum of 10 students' scores count in all of the three subjects.
U-PASS (HS) | 2007-07-11 00:00:00 | Use of 'Null' | When there are no students in BOTH the numerator and the denominator of a calculation, or a cell is otherwise empty for a legitimate reason, the indicator will be considered 'null' and will not be used in the composite calculation.
U-PASS (HS) | 2007-07-11 00:00:00 | Participation | CRT/UAA:  The number of students attempting a test divided by the total number of validated warehouse students with CRT/UAA tests. DWA:  The number of 9th graders attempting the DWA (or UAA) divided by all enrolled, validated warehouse 9th graders with DWA tests. Composite:        Schools with a 9th grade = (CRT*.90)(DWA*.10)      Schools without a 9th grade = (CRT*1.00) UBSCT:  Participation is not used
U-PASS (HS) | 2006-08-08 00:00:00 | Utah Basic Skills Competency Test (UBSCT) | For the school years ending 2005 and 2006, high schools will not be reported.  Other components related to a high school such as graduation rate, course trends, etc. will also not be reported. | [NAME]
U-PASS (HS) | 2007-07-11 00:00:00 | Utah Basic Skills Competency Test (UBSCT) - Status | Math:  The number of 10th grade FAY students passing the 10th grade administration of math divided by the number of non-UAA 10th grade FAY students enrolled. Reading:  The number of 10th grade FAY students passing the 10th grade administration of reading divided by the number of non-UAA 10th grade FAY students enrolled. Writing:  The number of 10th grade FAY students passing the 10th grade administration of writing divided by the number of non-UAA 10th grade FAY students enrolled.
U-PASS (HS) | 2007-07-11 00:00:00 | Criterion-referenced Tests (CRTs) - Status | Multiple tests for one student:  A CRT score may only count the first time a student participates in a specific assessment except for students participating in UAA.  A student participating in multiple assessments in one subject may have multiple scores counted as long as they are not the same assessment. Math:  The number of students proficient (levels 3 or 4) on any math [NAME] (and UAA) divided by the number of warehouse validated FAY students with math CRT scores.  [Note: in 2008 and beyond, this will include Intermediate Algebra] Language Arts:  The number of students in grades 9, 10, & 11 proficient (levels 3 or 4) on any language arts CRT (and UAA) divided by the number of warehouse validated FAY students with language arts CRT scores.   Science:  The number of students proficient (levels 3 or 4) on any science CRT (and UAA) divided by the number of warehouse validated FAY students with science CRT scores - minus legitimate leavers plus walk-ins.
U-PASS (HS) | 2007-07-11 00:00:00 | Course Credits - Math (Additional Academic Engagement Indicator) | 2008 The number of 10th and 11th grade FAY students earning one or more credits in an approved course beyond geometry divided by all 10th and 11th grade FAY students not enrolled in a CRT math course (as defined by July 15th enrollment data).  [The approved math courses are listed on a separate worksheet of this document] The Math additional academic indicator counts for 30% of the math score
U-PASS (HS) | 2011-06-16 00:00:00 | Composite Scores (Math, LA, and Science) | Math:  (math UBSCT status *.20) + (math CRT status *.50) + (math additional indicator *.30)   [Note: If any of the three indicators are missing or N/A, the weight of the missing indicator is split equally between the remaining components being calculated] Language Arts - Schools with an 8th grade:  (UBSCT reading status *.10) + (UBSCT writing status *.10) + (language arts CRT status *.75) + (DWA status *.05)  [Note: If DWA is missing, use the calculation for 'schools without an 8th grade] Language Arts - Schools without an 8th grade:  (UBSCT reading status *.10) + (UBSCT writing status *.10) + (language arts CRT status *.80) Science:  (science CRT status * 1.00) |  | Update for the 2010-11 school year: The Math CRT status will receive full weight for both High schools and [NAME] schools. The Language Arts CRT will receive 95% weight for schools who administered the Direct Writing assessment.
U-PASS (HS) | 2007-07-11 00:00:00 | Attendance | 100% less the number of FAY students with 15 or more absences divided by the total number of FAY students in the school as determined by the July 15th data submitted
U-PASS (HS) | 2007-07-11 00:00:00 | Graduation Rate | For the school year 2006-2007 the calculation used for AYP will also be used for U-PASS
U-PASS (HS) | 2007-07-11 00:00:00 | Progress - UBSCT | UBSCT Progress is the difference between the school's pass rate of students after their initial assessment in 10th grade and their final opportunity in 12th grade. 1) Number of FAY (non-UAA, plus early graduate) students in 12th grade who have passed all three portions of UBSCT 2) divided by the total number of FAY (non-UAA, plus early graduate) students in 12th grade, minus the number of FAY (non-UAA, plus early graduate) students two years prior who had passed all three portions of UBSCT divided by the total enrollment of 10th grade students two years prior [UBSCT status from two years prior]. 3) Re-scaled UBSCT Score.  The following formula is used on this number to re-scale the UBSCT score to be comparable to the progress table composites:      (UBSCT progress score * 1.65) + 167
U-PASS (HS) | 2007-07-11 00:00:00 | Progress Table (HS)
U-PASS (HS) | 2011-06-16 00:00:00 | Progress Table - Description (HS) | Language Arts:        Schools with a 9th grade = Changes from grade 8 to grade 9, grade 9 to grade 10, and grade 10 to grade 11 language arts CRTs      [NAME] without a 9th grade = Changes from grade 9 to grade 10, and grade 10 to grade 11 language arts CRTs Math:        Schools with a 9th grade = Changes from grade 8 to grade 9, grade 9 to grade 10, and grade 10 to grade 11 math CRTs      Schools without a 9th grade = Changes from grade 9 to grade 10, and grade 10 to grade 11 math CRTs      Math progress will be calculated based on any math assessment in the first year and any other math assessment in the second year. Science:        Schools with a 9th grade = Changes from grade 8 to grade 9, grade 9 to grade 10, and grade 10 to grade 11 math CRTs      Schools without a 9th grade = Changes from grade 9 to grade 10, and grade 10 to grade 11 science CRTs      Science progress will be calculated based on any science assessment in the first year and any other science assessment in the second year. [Note:  For students completing two or more unique CRTs in a given content area in the same year, the low score  from the first year will be compared to the high score of  the second year.]
U-PASS (HS) | 2007-07-11 00:00:00 | Attendance - Progress Table (HS) | School average based on per student year-to-year calculations: | [NAME]
U-PASS (HS) | 2007-10-30 00:00:00 | Include in Upass Summary | The include_in_upass_summary flag is set to "Y" for all tests except when the non-participation code is 1 (absent),2 (excused),3 (unknown student),4 (officially withdrawn),5 (ELL first year in U.S April 15 or later),8 (refused to [NAME] (multple bubble) or when the overall response count is 0 with a participation code of 0 (normal participation)
U-PASS | 2007-10-30 00:00:00 | Include in Upass Summary | The include_in_upass_summary flag is set to "Y" for all tests except when the non-participation code is 1 (absent),2 (excused),3 (unknown student),4 (officially withdrawn),5 (ELL first year in U.S April 15 or later),8 (refused to [NAME] (multple bubble) or when the overall response count is 0 with a participation code of 0 (normal participation)
U-PASS | 2007-07-11 00:00:00
U-PASS | 2007-07-11 00:00:00
U-PASS
U-PASS
Profile Divider
Student Profiles |  | Summary rows for districts | Summary rows include matched tests (CRT=clrhouse) from the student_test table ONLY |  | Matched on first name, last name, birth date, gender, district & school
Student Profiles |  | Printing Profiles | All profiles that have a valid district number should be printed (including home school, private, etc.). |  | Validated profiles will be printed from the student_test table.  Non-matched tests will be printed from the crt8_raw_data table.
Student Profiles |  | Summary rows for private schools | Private Schools (995) use the teacher number or class identifier to summarize the school -- the same is true for home schools (990)
Student Profiles
ACT SAT Divider
ACT/SAT/AP |  | Query for determining graduating class. | 2003 - total_tested /(sch_x_cd  in('GR','Q1','Q2','Q3','T1','T2','11'))  or (gradelvl='12' and sch_x_cd='' or sch_x_cd in('GR','SG')) 2004 - ACT tests were matched to graduating students
UBSCT Divider
UBSCT | 2004-09-14 00:00:00 | Total first time test takers passing all tests | The percentage of first time test takers that took all tests is equal to the number that passed all tests divided by the number of first time test takers that took all tests.
UBSCT | 2004-09-24 00:00:00 | 1st time test takers | Students who took the test and have a raw score > 0 and do not have an entry in the UBSCT history table | [NAME]
UBSCT | 2004-09-24 00:00:00 | Participation | % Proficient includes all tests with non-0 raw score and non-participation code <> 1,2,3,4 | [NAME]
UBSCT | 2004-09-24 00:00:00 | Students taking all 3 tests | Students who have a raw score > 0 on all three tests | [NAME]
Concurrent Enrollment
Concurrent Enrollment | 2005-01-21 00:00:00 | College Credit | A student will be said to have received college credit if the grade they received for the course is not one of the following: a. “000”,“0.0”,“0.00”,“F”,“FAI”,“N”,“NG”, or “NOG”. The no - grade codes "N","NG", and "NOG" cdes should already be filtered out. | [NAME]
Concurrent Enrollment | 2005-04-19 00:00:00 | Total Courses | The course must be an concurrent enrollment course(13 in 7 and 8 or the core code). The concurrent enrollment flag must be "Y" in the course table. The grade given must not be a "N", "NG" or a "NOG" meaning that the course was dropped. | [NAME]
Concurrent Enrollment | 2005-04-19 00:00:00 | Distinct Students | The student must have taken at least one concurrent enrollment course(13 in 7 and 8 or the core code). The concurrent enrollment flag must be "Y" in the course table. The grade given must not be a "N", "NG" or a "NOG" meaning that they dropped the course. | [NAME]
Course Taking Patterns
Course Taking Patterns | 2005-01-21 00:00:00 | Senior | A student that is in the 12th grade. | Brett Moulding
Course Taking Patterns | 2005-01-21 00:00:00 | Number of Students | The distinct number of students that have taken a concurrent enrollment course during the year. | [NAME]
Course Taking Patterns | 2005-01-21 00:00:00 | Number Receiving College Credit | ? | [NAME]
Course Taking Patterns | 2005-03-10 00:00:00 | Student | A student who was enrolled by Oct 1 | [NAME]
Course Taking Patterns | 2005-03-10 00:00:00 | Percentage of students taking a couse | The number of distinct students enrolled in a list of courses in a subject area divided by the total number of distinct students enrolled. | [NAME]
Course Taking Patterns | 2005-03-10 00:00:00 | Percentage of Seniors | The number of distinct current year seniors who took 2, 3, or 4 years of classes in the specified subject area divided by the total number of distinct current year seniors. | [NAME] | The classes could have been taken in the same year.
Biennial Report
LEP Biennial Report | 2005-02-02 00:00:00 | Proficiency Calculations | Proficiency calculations are calculated like [NAME] | [NAME]
LEP Biennial Report | 2005-02-02 00:00:00 | Test Grade | If a student has more than 1 test for a given school year, then only use the test that is for the studen'ts grade.
LEP Biennial Report | 2005-02-02 00:00:00 | Title III | Title III students are LEP students with an English proficiency of 'A', 'B', 'C', 'D'.  Non-Title III students are LEP students with an English proficiency of E (or non A-D.)
LEP Biennial Report | 2005-02-02 00:00:00 | Transitioned Students | A transitioned student is a student who's LEP changed from 'A' - 'D' to an 'E'
LEP Biennial Report | 2005-02-02 00:00:00 | State Reports | Entries in the summary tables for state reports are identified as district_id = 99
LEP Biennial Report | 2005-02-02 00:00:00 | Report Ranges | Reports with grade, grade span (or cohort) will use the following groupings: grades 3-8 (ayp_test_area = MS, MA, LA) and grades 10-12 (ayp_test_area = MS) + 10 (ayp_test_area = LA).  Grades 9 and PK - 2 are not reported.
LEP Biennial Report | 2005-02-02 00:00:00 |  | AMAO (Annual Measurable Achievement Objectives) lookup 'code table' (ct_eng_lang_amao) will contain target values for the following: school year for target, target % making english progress, and target % attaining the proficient english level.
LEP Biennial Report | 2005-02-02 00:00:00 | General Percentages | Unless a report specifies otherwise, all percentage calculations will be: number of students reaching specified goal divided by the total number of students in the LEP program for the district for the given year.
LEP Biennial Report | 2005-02-02 00:00:00 | Generating state reports | Unless a report specifies otherwise, state level reports will be derived by aggregating the district level summary data in the summary table.  Count/Number report columns will sum wheras percentage report columns will be averaged.  The resulting state aggregated data will be inserted back into the summary table with district_Id = 99 |  | For school year 2004 the state average is incorrect
LEP Biennial Report | 2005-02-02 00:00:00 | Proficiency Reports | If a report is a proficiency type report, then only students that have been in the district all year long will be used in the aggregate calculations.
LEP Biennial Report | 2005-02-02 00:00:00 | 'E' Proficiency | Students with a code of 'E' for limited English are considered to have left the Title III program and entered classrooms not designed for Title III students. They are also considered to be monitored title III students.
LEP Biennial Report | 2005-02-02 00:00:00 | Report Due | The due date for the report is November 30 by 11:59 p.m. EST
LEP Biennial Report | 2005-02-02 00:00:00 | Federal Report | Report generated for the Feds are generated every other year, and should be executable for individual districts. All tables in this report are aggregated by state. Report tables will be provided in PDF format to [NAME].
LEP Biennial Report | 2005-02-02 00:00:00 | Report Narrative | [NAME] will handle the narrative sections of the report.
LEP Biennial Report | 2005-02-02 00:00:00 | Included Districts | Only districts that have reported LEP students will be included in the summary table and in the State aggregate report to the Feds
LEP Biennial Report | 2005-02-02 00:00:00 | Proficiency Levels | Proficiency levels are as follows: Beginning & pre emergent = 'A', Emergent = 'B', Intermediate = 'C', Advanced = 'D', Fluent = 'E'
LEP Biennial Report | 2005-02-02 00:00:00 |  | Report will be provided in electronic format using the provided RTF file as well in hard copy.
 | Table 2.2a
LEP Biennial Report | 2005-02-04 00:00:00 | Making Progress | A student that advances 1 'step or row' in their English prificiency scores is considered to have made progress.
LEP Biennial Report | 2005-02-04 00:00:00 |  | There should be a code table that will define the ESOL IPT scores and if a student has advanced 1 level, 1/2 level, 1/4 level or 1/5 level.
LEP Biennial Report | 2005-02-04 00:00:00 |  | Any rules that discuss English language proficiency profress and using fractional increment movements will be calculated using full level moving increments. (See prior above.)
LEP Biennial Report | 2005-02-04 00:00:00 | Progress Calculation exclusions | When evaluating student English proficiency progress, students that don't have 2 consecutive years of data will be trown out of the progress calculations.
LEP Biennial Report | 2005-02-04 00:00:00 | Progress Tracking | If a student has progressed in any of the three areas (oral, read, write) then they will be marked as having progressed.
LEP Biennial Report | 2005-02-04 00:00:00 |  | The performance columns are calculated using CRT data (State assessment tests found in student_test) for Language arts tests (awy_test_area = 'LA'.)
LEP Biennial Report | 2005-02-04 00:00:00 |  | When comparing two years looking for progress, only the second year must be within the cohort range. (i.e. [NAME] is Ok when grade 3 is for the target year.)
LEP Biennial Report | 2005-02-04 00:00:00 | AMAO Calculations A | Only students with 2 consecutive years in the same district will be considered.
LEP Biennial Report | 2005-02-04 00:00:00 | AMAO Calculations B | Only full academic year students for both years being compared will be considered.
LEP Biennial Report | 2005-02-04 00:00:00 | AMAO Calculations C | Only students with a LEP proficiency of 'A', 'B', or 'C' in the first year of the two consecutive years will be considered.
LEP Biennial Report | 2005-02-04 00:00:00 | AMAO Calculations D | Only students wit a LEP proficiency of 'A', 'B', 'C', or 'D' in the second of the two consecutive years will be considered.
LEP Biennial Report | 2005-02-04 00:00:00 | AMAO Calculations E | Only students in grades 3-8 or 10-12 in the second year of the two consecutive years will be included.
LEP Biennial Report | 2005-02-04 00:00:00 | LEP [NAME] | When calculating AMAOs, if one of the LEP grade fields (oral, read, write) are left blank then the values on the LEP [NAME] worksheet will be used to fill in the blanks |  | Click here to go to the LEP [NAME]
 | Table 2.2b
LEP Biennial Report | 2005-02-04 00:00:00 | Baseline | The baseline columns will be the # proficiency level of d & E students reported for 2003, and what % they are of all LEP students reported for 2003.
LEP Biennial Report | 2005-02-04 00:00:00 | Target | The AMAO target columns for 2004 will be the # proficiency level of D & E students reported for 2004, and what % they are of all LEP students reported for 2004.
LEP Biennial Report | 2005-02-04 00:00:00 | Performance Data | The performance Data columns will be the # proficiency level of D & E students that scored 3 or 4 on the Language Arts (LA) test for 2004, and what % they represent of all proficiency level D & E students.
LEP Biennial Report | 2005-02-04 00:00:00 | E' level students to include | Proficiency level E students will be included only if they have no exit date, their exit date is 1/1/1900, or their exit date is within the prior two school years.
 | Table 2.3a
LEP Biennial Report | 2005-02-04 00:00:00 |  | The projected % columns will come from the [NAME] table "ct_z_amo_ci"
LEP Biennial Report | 2005-02-04 00:00:00 |  | Only students flagged as having been in the district the entire year will be included.
LEP Biennial Report | 2005-02-04 00:00:00 |  | Only Title III students will be included ('A' - 'D')
LEP Biennial Report | 2005-02-04 00:00:00 |  | "test_program.ayp_test_area" in ('[NAME], 'MS') will be used to identify the Math test for grades 3-8 and 'MS' for grade 10-12.
 | Table 2.3b
LEP Biennial Report | 2005-02-04 00:00:00 |  | The projected % columns will come from the [NAME] table "ct_z_amo_ci"
LEP Biennial Report | 2005-02-04 00:00:00 |  | Only students flagged as having been in the district the entire year will be included.
LEP Biennial Report | 2005-02-04 00:00:00 |  | Only Title III students will be included ('A' - 'D')
LEP Biennial Report | 2005-02-04 00:00:00 |  | "test_program.ayp_test_area" = 'LA" will be used to identify the Language Arts test for grades 3-8 and 10 as the secondary cohort.
 | Table 7.1
LEP Biennial Report | 2005-02-04 00:00:00 |  | Only students flagged as having been in the district the entire year will be included.
LEP Biennial Report | 2005-02-04 00:00:00 |  | [NAME] students will be identified by a LEP Code = 'E' , and a LEP exit date <= 2 school years. |  | i.e. For the 2004 report, that means students with an exit date of 7/1/01 or greater will be included in the count.  7/1/01 - 6/1/02 is for school year 2002 which is <= 2 school years
 | Table 7.2a
LEP Biennial Report | 2005-02-04 00:00:00 |  | Only students flagged as having been in the district the entire year will be included. |  | Use the full_academic_year_dist = 'Y' restriction
LEP Biennial Report | 2005-02-04 00:00:00 |  | Simply count all proficiency 'E' students with an exit date <= 2 school years ago. |  | i.e. For the 2004 report, that means students with an exit date of 7/1/01 or sooner will be included in the count.  7/1/01 - 6/1/02 is for school year 2002 which is <= 2 school years
LEP Biennial Report | 2005-02-04 00:00:00 |  | Student test scores will only be included if they are marked "include_in_ayp" = 'Y'
LEP Biennial Report | 2006-03-06 00:00:00 |  | For the percentage, use the number of 'E' proficiency students achieving a validated proficiency of a 3 or 4 divided by the total number or 'E' proficiency students
LEP Biennial Report |  |  | State percentages are not derived from district numbers and percentages.
 | Table 7.2b
LEP Biennial Report | 2005-02-04 00:00:00 |  | Only students flagged as having been in the district the entire year will be included. |  | Use the full_academic_year_dist = 'Y' restriction
LEP Biennial Report | 2005-02-04 00:00:00 |  | Simply count all proficiency 'E' students with an exit date <= 2 school years ago. |  | i.e. For the 2004 report, that means students with an exit date of 7/1/01 or sooner will be included in the count.  7/1/01 - 6/1/02 is for school year 2002 which is <= 2 school years
LEP Biennial Report | 2005-02-04 00:00:00 |  | Student test scores will only be included if they are marked "include_in_ayp" = 'Y'
LEP Biennial Report | 2006-03-06 00:00:00 |  | For the percentage, use the number of 'E' proficiency students achieving a validated proficiency of a 3 or 4 divided by the total number or 'E' proficiency students
LEP Biennial Report |  |  | State percentages are not derived from district numbers and percentages.
 | Table C1
LEP Biennial Report | 2005-09-29 00:00:00 |  | Since we do not use assessment, we use a survey to identify LEP students, we do not have the results of the survey therefore,  the number of students assessed is equal to the total number of LEP students that are at levels A, B, C or D
LEP Biennial Report | 2005-09-29 00:00:00 |  | The percentage of students assessed is calculated using the total number of LEP students divided by the total fall entollment count of students in the state.
LEP Biennial Report | 2005-09-29 00:00:00 |  | The number of students identified as LEP students are those students with the LEP flag set in the clearinghouse and have a lep code of A, B, C, D |  | This is the same as the total number of LEP students because we don't have data on the results of the survey that determines if a student should take the IPT
LEP Biennial Report | 2005-09-29 00:00:00 |  | The percentage of students identified as LEP is the number of students identified as LEP divided by the total fall enrollment count of students in the state |  | "students identified" / "total students"
LEP Biennial Report | 2005-09-29 00:00:00 |  | The number of students at basic or level 1 is defined as LEP students who had an 'A' in the lep code.
LEP Biennial Report | 2005-09-29 00:00:00 |  | The number of students at intermediate or level 2 is defined as LEP students who had an 'B' in the lep code.
LEP Biennial Report | 2005-09-29 00:00:00 |  | The number of students at advanced or level 3 is defined as LEP students who had an 'C' in the lep code.
LEP Biennial Report | 2005-09-29 00:00:00 |  | The number of students at proficient or level 4 is defined as LEP students who had an 'D' in the lep code.
LEP Biennial Report | 2005-09-29 00:00:00 |  | The percentage of students at any of the 4 levels (1-4) are calculated using the number of students at level that level as the numerator and the identified LEP students as the denominator
 | Table C2
LEP Biennial Report | 2005-09-29 00:00:00 |  | The total number of students identified as LEP who participated in Title III programs is (as defined above) LEP students who have a proficiency of A, B, C or D
LEP Biennial Report | 2005-09-29 00:00:00 |  | The percentage of students identified as LEP who participated in Title III programs is calculated using the count of these students (as defined above) as the numerator, and the total count fall enrollment count of students in the state
LEP Biennial Report | 2005-09-29 00:00:00 |  | The total number of students who transitioned for 2-year monitoring is a count of all students who were at a level other than 'E' last year, and who are now at a level 'E'
LEP Biennial Report | 2005-09-29 00:00:00 | Transitioned LEP Students | The percentage of students who transitioned for 2-year monitoring is calculated using the count of the transitioned students divided by the total count of LEP students A-D |  | The lep_exit date in student_lep indicates the date that these transitioned students left the LEP program.
LEP Biennial Report | 2005-09-29 00:00:00 |  | The number of students at basic or level 1 is defined as LEP students who had an 'A' in the lep code. |  | This is defined as for Table C1
LEP Biennial Report | 2005-09-29 00:00:00 |  | The number of students at intermediate or level 2 is defined as LEP students who had an 'B' in the lep code. |  | This is defined as for Table C1
LEP Biennial Report | 2005-09-29 00:00:00 |  | The number of students at advanced or level 3 is defined as LEP students who had an 'C' in the lep code. |  | This is defined as for Table C1
LEP Biennial Report | 2005-09-29 00:00:00 |  | The number of students at proficient or level 4 is defined as LEP students who had an 'D' in the lep code. |  | This is defined as for Table C1
LEP Biennial Report | 2005-09-29 00:00:00 |  | The percentage of students at any of the 4 levels (1-4) are calculated using the number of students at level that level as the numerator and the identified LEP students as the denominator |  | This is defined as for Table C1
LEP Biennial Report | 2005-09-29 00:00:00
LEP Biennial Report | 2005-09-29 00:00:00
CSPR Report
CSPR Report | 2006-03-09 00:00:00 | 2005 - 1.6.11.1a | The number of students to report for each grade level is the number of students who transitioned from any level other than 'E' to an 'E' during the course of the school year and achieved a proficiency > 2. 07/01/<prioryear> - 06/30/<schoolYear>. For example for 2005, the date span for lep_exit_date is from 07/01/2004 to 06/30/2005. | [NAME]
CSPR Report | 2006-03-09 00:00:00 | 2005 - 1.6.11.1b | The percentage is calculated using the students identified in rule 2005 - 1.6.11.1a divided by the total number of students who trasfered from any level to an 'E' during the same period of time, regardless of proficiency level. | [NAME]