STAAR 110 Percent Report

This report finds all current year students coded in PEIMS as At-Risk that had a failing grade in the prior year STAAR assessment file. The listed report will provide columns to show the previous year associated failed assessment values

Immediately following the previous year column values, the list will report any new test value that has been uploaded into the system by associated tested subject.

Example: If a student failed EOC Biology in Spring and Fall of 2016 it will list the last fail score value of the previous year as Failed Month: Fall. It will then look at the latest test scores available to determine if the student tested in the subject again.

NOTE: In cases where the assessment instrument differs from the previous year the associated new test score will be matched by assessment instrument.

Example: If a student failed STAAR 3-8 Reading and passed Eng 1 EOC the next year they get a Y for meet

 

110% Prior to current year association crosswalk

Attention: The 100% report has been updated to now reflect a students 110% met value only if a student has two records which align with the “110% Prior to current year association crosswalk” chart which can be found in the report notes.

Example: Prior to the release of the 11.8 update, a student that tested in writing in grade 4 would be matched against their grade 3 reading exam scores to determine if they met at 110%. If the students reading score was failed and the students writing was met at 110% this would create an indicator that the student met the 110% criteria. This would be in error.

As of update (11.8) a student that tests in grade 4 writing that fails will stay on as at risk and will have to wait until they test in grade 7 to determine if they passed at 110%.

 

How to view prior year to current year assessment results in report.

This report contains a lot of extra information about both the prior year and current year tested subject for informational purposes only.

The prior year met/not met references the final score for the student and will be semi-highlighted in orange. Not all current year ‘At Risk’ students failed an assessment the prior year so this report will list students with both ‘Y’ and ‘N’ score values.

For those students that have a ‘N’ in the prior year assessment met/not met column follow the line across to the current year met 110 percent column to see if they met the 110% requirement. If there is a ‘Y’ this means they failed the prior year but met the current year at 110%. If there is an ‘N’ that means they failed the prior year and they did not meet the 110% for the current year. Even if they passed the current year, the needed to pass at 110%

Current Year Met 110 Percent Column
The current year met 110 percent column will show a value for all students who are on the list regardless of prior year status. It is just there to confirm if the student passed at 110%.

Filter Options
This report may be filtered at the campus level

 

Items to consider if you feel you are missing associated test results
If you are not seeing an associated reported value either for the previous year or the current test cycle, please revisit your file center files to ensure that the most updated assessment values have been uploaded into your database.

 

Consider Exporting Table for further extraction
This report can be exported to an excel file and from there you can filter by all the prior year met/not met column to all ‘N’ values and then filter the current year met 110 percent column to either ‘Y’ or ‘N’  or you can just filter by the last column value and look for all the ‘Y’ values to see who failed the prior year but met at 110% for the current year.

 

 

The following are required file uploads into your OnDataSuite file center that are used to calculate A-F report values:

Local SIS Files
(Requires five (5) historical PEIMS/TSDS uploads as per TEA Appendix H page 129 requirements.)
PEIMS – TSDS
PEIMS – Legacy

TEA TEASE/TEAL Files
These files are derived from district TEASE/TEAL accounts

Cohort Preliminary
Cohort Longitudinal (4,5 & 6 Year used in A-F to determine Grad Rate) 
For more information in the manual: About Longitudinal Cohort Files

CCMR
For more information in the manual: About CCMR Files

 

State Assessment Files
Please load at a minimum the last two years and include all updated files.
Alt files are uploaded into the appropriate 3-8 or EOC section.

STAAR 3-8
STAAR 3-8 ALT
EOC
EOC ALT
TELPAS

College Board Files
These data are derived directly from the college board data files and adhere to the latest college board specified data file format requirements.  For more information on these files you can refer to our manual here: OnDataSuite SAT and AP manual items
SAT

AP
NOTE: AP file issue for 2019
We are currently aware that the file provided by the college board as a download to districts is generated as an excel (XLS / XLSX). However the file is actually mislabeled by the college board as it is a CSV file saved as an XLS file. We have made adjustments in our file center upload to accept the current XLS file. Please download this file locally to your computer and DO NOT attempt to open or change it. Just upload it directly into the file center. 

 

Other Files
ACT

NOTE: ACT required upload date selection
Due to annual changes in the ACT data file format, OnDataSuite requires users to specify an associated testing year during the upload process. The year ranges the ACT file provides are specified within a date range that may not correspond to a districts calendar year.  Please use caution when assigning an associated year.

For more information about the ACT file requirements refer to our manual here:
https://manuals.ondatasuite.com/index.php/users-manual/#loading-act-files

TSIA
This file requires that you build it using the College Board report builder. We have a specific data file format here: OnDataSuite TSIA file format requirements

IB
This file is a Comma Separated Value (CSV)  Specific information on the expected column format here:
OnDataSuite IB File layout

 

CCMR EWS Supplement
This will be a locally created excel spreadsheet file that will allow districts to indicate students eligibility for Industry Based Certification, IEP and Armed Forces in the absence of these coded values in the current year PEIMS file.

The following columns displayed in the CCMR Early Warning System are dependent upon a future PEIMS upload files to determine if a student is eligible for CCMR point accumulation:

• Industry Certification
• IEP
• Armed Forces

As these files are typically uploaded and confirmed by the following years October PEIMS submission, these areas may not form an association in time for districts to have a preliminary view of their upcoming affect on accountability.

OnDataSuite has developed an other ( ‘S’ ) alternative file upload procedure for districts who would like to create an indicator to show preliminary point accrual for these areas.

 

The uploading of this file will only affect the CCMR EWS report. Upon its upload it will create an column indicator value of ‘O’  to signify that the district has uploaded a place holder value other than the standard Yes (‘Y’) or No (‘N’) column value associated with a PEIMS confirmed record on file.

For detailed information on the creation of this file and all that it will affect please visit this section of the manual:  CCMR EWS Supplemental File

 

Testing Issues Roster
During the 2017-18 testing year, there were several districts throughout the state that were affected by online testing issues. As a result, many of the students that were affected were not counted in last years accountability values. Districts were notified and provided with an excel list of their students that were affected.

Due to the exclusion of these students, OnDataSuite’s preliminary A-F and PBMAS calculations were not accurate. As a temporary remedy, ODS allowed districts to upload their excel file into the testing issue roster file center and the upload of this list removed the students from both numerator and denominator aggregates resulting in far more accurate values.

While we do not anticipate this happening again this upcoming year, if it does, districts will need to upload the list provided to them from the state once again.

 

 

ODS Calculated Values (Used in absence of TEA CCMR upload file):
This component combines uploaded PEIMS, AP, IB, SAT, ACT, and TSIA (Accuplacer) data files of all graduates to check who MET any of the listed requirements below.

*** Items annotated below are calculated values derived from PEIMS files that will require five (5) historical PEIMS / TSDS uploads into the system (2016-17, 2015-16, 2014-15, and 2013-14 School Years) as per TEA Appendix H page 129.

College & Career Components

• CTE Criteria – Requires PEIMS Summer uploads – current and past 5 years***
• Industry Based Certification – Requires PEIMS Fall upload
• Completed IEP and workforce Readiness – Requires PEIMS Fall upload

Military Component

• Enlists in US Armed Forces – Requires Fall PEIMS upload

DEFINITIONS:

College Components

• AP Met – Values derived from AP data file from The College Board
  A graduate meeting the criterion score on an AP examination in any subject area. Criterion score is 3 or more for AP.
• IB Met – Values derived from IB scores from International Baccalaureate
  A graduate meeting the criterion score on an IB examination in any subject area. Criterion score is 4 or more for IB.

 

• *SAT Met – Values derived from SAT data file from The College Board
  ELA/Reading Met SAT – Score must be >= 480 on Evidence Based Reading and Writing (EBRW)
  Math Met SAT – Score must be >= 530 on Mathematics
• *ACT Met – Values derived from ACT data file from ACT
  ELA/Reading Met ACT – Score must be >= 19 on English and >= 23 Composite
  Math Met ACT – Score must be >= 19 for Mathematics and >= 23 Composite
• *TSIA Accuplacer Met – Values derived from Accuplacer data file from The College Board
  ELA/Reading Met – Score must be >= 351
  Math Met – Score must be >= 350
• *College Prep Met –Values derived from PEIMS summer submission***
  Searches for service id codes of CP110100 (ELA) or CP111200 (Math) who met criteria.
  • Interchange Student Transcript
    • 43415 Course Completion>CourseTranscriptExtension Complex
      • E0724 Service ID = CP110100 or CP111200 (C022)
      • E0948 Course Sequence Code = 0, 2, 5, or 9 (C135)

• TSI Met
  • ‘Y’ in the AP or IB column OR
  • ‘Y’ – Both in the SAT, ACT, Accuplacer (TSIA), or College Prep columns OR
  • Combination of ‘Y’-Math and ‘Y’-ELA/Reading’ in the SAT, ACT, Accuplacer (TSIA), or College Prep columns (must have both ‘Y’ if no other previous conditions met)

• Dual Credit Met***
  A graduate completing and earning credit for at least three credit hours in ELA or Mathematics or at least nine credit hours in any subject.
  • Interchange Student Transcript
    • 43415 Course Completion>CourseTranscriptExtension Complex
      • E1011 Dual Credit Indicator Code = 1 (C088)
      • E0948 Course Sequence Code = 0, 2, 5, or 9 (C135)
      • E1081 College Credit Hours
    • Internal service id code table to determine ELA/Mathematics/Other Subject courses
• Associates Degree Met
  A graduate earning an associate’s degree while in high school
  
  • Interchange Student
    • 40100 Student Basic Information>StudentExtension Complex
    • E1596 Associate Degree Indicator Code = 1 (C088)

Career Components

• CTE Criteria Met***
  A CTE coherent sequence graduate who has completed and received credit for at least one CTE course aligned with an industry-based certification. (1/2 point awarded if only indicator met)
  
  • Interchange Student Program
    • 40110 Enrollment>StudentProgramExtension
    • E0031 Career and Technical Ed Ind Cd = 2 (C142)
  • Interchange Student Transcript
    • 43415 Course Completion>CourseTranscriptExtension Complex
    • E0724 Service ID=85 CTE courses aligned with industry-based certifications (end of Chapter 2)
    • .5 to 1 point value will stay same for 2020 and then change in 2021
      
• Industry Based Certification Met***
  A graduate earning an industry-based certification under 19 TAC 74.1003.
  • Interchange Student Enrollment
    • 48011 Student Graduation Program>StudentGraduationProgramExtension Complex
    • E1586 First Post Secondary Certification Licensure = values in code table C214
• Completed IEP and workforce Readiness Met
  A graduate receiving a graduation type code of 04, 05, 54, or 55 which indicates the student has completed his/her IEP and has either demonstrated self-employment with self-help skills to maintain employment or has demonstrated mastery of specific employability and self-help skills that do not require public school services.
  • Interchange Student Enrollment
    • 40203 School Leaver>SchoolLeaverExtension Complex
    • E0806 Graduation Type Code = 04, 05, 54, or 55 (C062)

Military Ready Component

• Enlists in US Armed Forces Met
  A graduate enlisting in the U.S. Army, Navy, Air Force, Coast Guard, or Marines.
  • Interchange Student Enrollment
    • 40203 School Leaver>SchoolLeaverExtension Complex
    • E1589 Military Enlistment Indicator Code = 1 (C088)

CCMR Met
If any one item is met from the aggregate of this list the student will be included in the Number of Graduates Who Accomplished at Least One of the CCMR Indicators total. The students who only meet the CTE Criteria Met indicator are counted as .5.

Graduation Rate

• Requires Final Graduation 4, 5, and 6 year Longitudinal files found in TEAL>ACCT – Accountability>Final Graduation and Dropout Information>RES-Research and Analysis tab to be uploaded in the File Center under ‘TEA Cohort List’.

A-F Overall Summary
Provides an overall summary of all domain results (Student Achievement, School progress, Closing the Gaps) used to calculate the overall district or campus score.

Chapter 1 – 2019 Accountability Overview posted 7/19/2019

For File Dependency Information refer to internal link
A-F File Requirements and Definitions

Domain 1 Student Achievement Summary and Detail Reports

STAAR Component Details

• Overview of assessment level totals for all subjects combined at the approaches, meets and masters levels.
• Achieved STAAR raw score, associated scaled score and calculated weighted point value.

CCMR Component Details

• Achieved CCMR raw score, associated scaled score, calculated weighted score, minimum size requirement, method used to achieve value.
• Method will be listed as ‘TEA’ only if TEA CCMR files have been uploaded into the file center
• Method will be listed as ‘ODS’ if values are derived from calculations using independently uploaded data files in lieu of CCMR files.

Graduation Rate Component Details

• Achieved Grad Rate raw score, associated scaled score, calculated weighted score, minimum size requirement, method used to achieve value.
• Method will be listed as ‘GRAD’ only if TEA 4,5 and 6 year longitudinal cohort files have been uploaded into the file center
• Method will show as blank and calculated annual dropout rate will be used in lieu of TEA 4,5 and 6 year supported data.
• The better rate of the last 3 years from TEA will be used

Final Scoring

• Domain scaled score determined by total weighted points to scale score conversion
• Performance rating reflective of state scale score to grade conversion

Domain 1 Detail Report

STAAR Component Details

• Breakdown by subject, number of assessments, not met, approaches or above, meets or above and masters or above
• Total percentage points achieved value
• Calculated achieved RAW score

CCMR Component Details

• Number of graduates without any CCMR Indicators
• Number of graduates who accomplished at least one of the CCMR indicators
• Number of annual graduates
• All CCMR results are calculated from independent raw data files uploaded into the file center UNTIL you upload your TEA CCMR file. After you have uploaded your CCMR file, all CCMR related calculations will be superseded by the state list values.
• Prior to uploading the state CCMR file, you will only see one box titled “(CCMR) College, Career, Military Ready From: ODS-Raw Data Files”
• After uploading the state CCMR file, you will see a secondary box titled “(CCMR) College, Career, Military Ready From: TEA”

Graduation Rate Component Details

• The better of available three year graduation or dropout rates will be displayed
• Number of graduates in the class
• Number of students in the class
• All student percentage

Total Student Achievement Domain Calculation

• Overall component STAAR, CCMR, Grad Rate display
• Weighted point values
• Calculated scale score value
• Calculated associated domain rating

Domain 1 CCMR Drill Down Detail Report

To see the detailed report click on the Total Graduate count in the CCMR summary section

 

• Drill down to lists of students who have accomplished at least one of the CCMR indicators
• Drill down to lists of number of graduates without ANY CCMR indicators
• Column values will return a ‘Y’ or ‘N’ value for the following items:
  SPED
  Former SPED
  Continuously Enrolled
  NOT Continuously Enrolled
  Grad Status
  CCMR-Achieved at least 1 Indicator
  ELA TSIA
  ELA ACT
  ELA SAT
  ELA CP
  ELA-Achieved at least one
  Math TSIA
  Math ACT
  Math SAT
  Math CP
  Math-Achieved at least one
  ELA & Math-Achieved at least one in both ELA and Math
  AP/IB
  Dual Credit Courses
  Industry Certification
  Associates Degree
  IEP
  Armed Forces
  Aligned CTE

For detailed information about calculations please refer to the TEA Manual
Chapter 2-Student Achievement Domain, posted 7/19/2019

For File Dependency Information refer to internal link
A-F File Requirements and Definitions

For File Dependency Information refer to internal link
A-F File Requirements and Definitions

A-F Domain 3 Closing the Gaps Summary and Detail Reports

CCR EWS File Dependency Crosswalk (Updated 11/08/2021)
Click crosswalk link below for a detailed listing of each CCMR EWS column element and its required file upload. This will open up in a new tab.

 

CCMR EWS Crosswalk as of 11082021

 

 

System Update Log
As this report continues to evolve it may be periodically subject to changes.
CCMR EWS System Update Log

Summary:
The CCMR EWS report calculates the CCMR status of ALL students at your LEA as derived from your PEIMS file uploads. It performs the following tasks:

• Duplicates the reporting capabilities of Domain 1 A-F CCMR report but allows for search throughout all grade levels
• KEY differences between A-F CCMR report and CCMR EWS system
  • Removed the binding 12th grade restrictions required by the TEA manual to allow search for all grades
  • Search through all found students for ANY CCMR indicator achieved by student regardless of grade or year
• Provides a yes ‘Y’ OR no ‘N’ value in its respective column when there are supporting data files associated a student ID
• Provides a CCMR Met value of ‘Y’ for students that have met at least 1 of the CCMR criteria
  • Note: Beginning with the 2019-2020 class, we have removed the .5 value from the Coherent Aligned IBC CTE PEIMS column as specified in the 2019 Accountability manual (pages 15-16).
• Provides an ‘S’ value in its respective column when a CCMR EWS Supplemental file has been associated with the students ID. This value serves as a place holder for future student codes of any Industry Certification, IEP or Armed Forces. For detailed information about this click this link: https://manuals.ondatasuite.com/index.php/users-manual/#loading-ccmr-ews-supplement-files

File Association and Definitions:
This report will depend heavily on all required files to be uploaded into the system. It relies on PEIMS, AP, IB, SAT, ACT, and TSI (Accuplacer) data files to check who MET any of the listed requirements.Missing files will result in a value of ‘N’ for items which have no association.

• 4 Year Grad Rate
  • Requires Final Graduation 4 year longitudinal files found in TEAL>ACCT – Accountability>Final Graduation and Dropout Information>RES-Research and Analysis tab to be uploaded in the File Center under TEA>Cohort Longitudinal area.

2019 Appendix H / Table 7.3 Texas Success Initiative (TSI) Criteria Graduates Chart for reference

Special Notes:

• Excludes Fall and Summer Student Attribution Codes (E1000) = 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28

Features:

• Filter Options:
  • Year
  • Campus
  • Grade
  • Graduation Status
    • Note: If choosing 01 – Student graduated., this list might not equal leaver ad hoc querying since the logic is different. For this report, graduates included have:
      • Leaver Reason Code (E1001) = 01
      • Fall or Summer Enrollment record for the year of the graduate
      • No Fall or Summer Enrollment records for the subsequent year
  • CCMR
    • All CCMR – Show all students with and without CCMR points
    • CCMR Met – Only students that have a met value greater than zero ( 0 )
    • CCMR Not Met – Students that have not achieved any CCMR points to date
  • Filter by Criteria to filter on individual columns
  • Focus List
• Compare to TEA Button
  • Requires upload of current year TEA released CCMR Preliminary and Final spreadsheet files acquired through LEA TEAL Account
  • When selected a TEA Column will appear next to the ODS column allowing you a comparison between your preliminary individual data file results to those of the state released spreadsheet.
• Printable Cards
  • Provide an option to print out 4 students per sheet cards from filtered found sets of CCMR EWS data
  • Has been formatted to fit the following Avery Postcard style sheet:
    Avery Printable Postcards for Inkjet Printers, 4.25″ x 5.5″, 200 White Cards (8387)

 

Related TEA Links

• CTE Course Alignment
  • https://tea.texas.gov/academics/college-career-and-military-prep/career-and-technical-education
  • 2018 Accountability – CTE Courses Aligned with Industry-Based Certifications (TEA PDF Link)
  • 2019-2020 Approved Industry-Based Certifications for Public School Accountability.
    2019_20-TEA_IBC Approved Vendor Crosswalk_final

• This report provides a visual representation of all files uploaded that are associated with your CCR EWS report.
• It will pull a list of all files uploaded for the latest year of upload.
• If files appear to be missing from this list, please visit your file center to make sure that the file was actually uploaded into the correct location or that the file was uploaded in the correct format required.

2021 Predicted Alternate Evaluation Report Summary – Lists Campuses
2021 Predicted Alternate Evaluation Campus Details – Details Components

This report will only list campuses whose prior year rating was a ‘D’ or ‘F’ or ‘Required Improvement’
Campuses listed in this report can be drilled down to the detail view to review individual component totals.

2021 Participation Rate: All Students, All Subjects
Calculated current year participation rate for each campus to determine if the preliminary participation rate was greater than or equal to 95%. This calculation uses the TEA released 2021 Alternative Evaluation FAQ (July 2021) methodology shown in item 6 on page 2 of the following FAQ document.

2021-alternative-evaluation-faqs-july-2021

Eligible for 2021 Alternative Evaluation?
Calculated participation must be >=95% and prior year 1365 Eligible Rating must be D,F or RI

2021 Student Achievement Domain Scaled Score
Calculated following TEA manual specifications for 2021

2021 Relative Performance Domain Scaled Score*
* As determined by 2019 manual guidance.

Average of 2021 Student Achievement and Relative Performance Scaled Scores
Example:
2021 Student Achievement Domain Scaled Score = 58
2021 Relative Performance Domain Scaled Score* = 57
———————————————————————
Average (58, 59) = 57.5 ——————> Rounded up = 58