As the CCMR Early Warning System evolves we will periodically be pushing out updates to ensure that districts are reviewing the most accurately represented data possible. These updates are in direct relation to system tickets input by districts notifying us of areas that need to be addressed. 

It is important to remember that the CCMR EWS report is different than the district Domain 1 CCMR calculation as it is not bound to the restrictions of the manual. This allows for the review of students possible CCMR points outside of the grade 12/graduate restrictions.

All data in this report should reflect the correlation between the PEIMS data files to the manually updated college board, ACT, TSIA and IB files. 

This log is intended to provide our clients with a list of items that have been changed in the system in between scheduled system wide version updates. 

Sections below this point will reflect any changes made for the 2020-21 year. 

Changed all listed College Career and Military Ready labels to say CCMR. We had removed the military “M” from the titles in all reports in early 2021 but upon further review of released TEA guidance still referring to CCMR to include the ‘M’ we updated the system.

CCMR EWS Supplemental File has been updated to add several new fields.
https://kb.ondatasuite.com/knowledge-base/ccmr-ews-supplement-files/ 

Updated logic to include combination of TSIA1 and TSIA2 to include diagnostic scores for both ELAR and Math

Removed the following columns and calculations from the CCMR EWS report as per the specifications of TEA’s ‘On-Pager’ 2021 Academic Accountability System Overview 

CCMR was updated to exclude two previously used indicators:
1. Enlist in the U.S. Armed Forces (pending data receipt)
2. Complete CTE coherent sequence coursework and earn credit aligned with approved industry-based certifications

2021 ACCT One Pager Jan 2021

Updated CCMR EWS report to add ACT Composite score to both the report and the export file. 

TSIA2 Diagnostic scores for both the Mathematics and ELAR sections have been removed from the calculation of overall TSI scores as per TEA FAQ guidance released 8/5/2021

This values will still be displayed in the columns for informational purposes but will NOT be used in calculating overall TSI Score

TEA FAQ release 03/05/21
The following is a correction to the FAQ shown in the February 12, 2021 bulletin:

Based on feedback from divisions within TEA, diagnostic results from the Texas Success Initiative assessment (TSIA) 2.0 will not be evaluated for college readiness in the College, Career, and Military Readiness (CCMR) components.

Updates were made to incorporate the TSIA2 scores into the CCMR EWS reporting system.

• Added TSIA2 file center location to accept the file
• Added TSIA2 Scores to student dashboard section under assessment section
• Added TSIA2 report center
• Incorporated ELAR CRC TSIA2 Score values into TSIA calculations
• Incorporated ELAR CRC TSIA2 Diagnostic values into TSIA calculations
• Incorporated ELAR CRC TSIA2 WritePlacer values into TSIA calculations
• Incorporated MATH CRC TSIA2 Score values into TSIA calculations
• Incorporated MATH CRC TSIA2 Diagnostic values into TSIA calculations

Updates made to College Prep ELA and College Prep Math now include PEIMS Extended Year submission. Before, it was just looking at PEIMS Summer submission.

Updates made to calculation of the Advanced Degree Plan SPED Indicator

Updates made to calculation of the College Prep PEIMS

Added “AND Pass/Fail Credit Indicator Code (C136) = 01 or 08”

Updates made to calculation of the Dual Credit PEIMS Indicator

Removed E0948 Course Sequence Code (C135) = 0, 2, 5, 9, D0, D2, D5, D9
Added E0949 PASS/FAIL-CREDIT-INDICATOR-CODE = 01

Updates made to calculation of the Advanced Degree Plan SPED Indicator

Exclusion of AP/IB subscore in CCMR point value

An adjustment was made to the counting of AP/IB subscores. TEA confirmed that subscores are not considered for accountability, only overall scores

• Updated issue that was affecting some districts combined ELA and Math TSIA calculation. For some districts it was inaccurately reporting a combined ELA and Math TSIA Met when only one value was present for either ELA or Math. 
• Updated the CCMR College Prep indicator to add indicator E0949 (Indicates Pass/Fail)

Updates reflected in the CCMR compare to TEA reporting feature

• Updated parser to accommodate changes in new CCMR Verifier file
• Added column TEA ACT Super Composite Scores ELA
• Added column TEA ACT Super Composite Scores Math
• Removed OnRamps Hours Column
• Updated match from ODS to TEA for following imported variables to match TEA no variable
  • ‘-‘ = No alpha field reported by TEA
  • ‘.’ = No numeric field reported by TEA
• All values are not ‘Y’ , ‘N’ , ‘-‘, ‘.’ depending on data type (excluding CTE)
• Grouped like columns with dark line (only works in light mode)
• Removed TEA only button

Some updates to the titles and color shading:

TSI Criteria Section:

• Changed ‘CP PEIMS’ titles under ELA/Reading and Mathematics to ‘College Prep PEIMS’
• Changed ‘ELA’ title to ‘ELA Met Any Criteria’
• Changed ‘MATH’ to ‘MATH Met Any Criteria’
• Changed colors on ELA/Reading and Mathematics to differentiate between the two sections
• Removed color coding on all ‘SCR’ (score) elements
• Added color coded headers on ‘ELA Met Any Criteria’ and ‘MATH Met Any Criteria’ that matched the appropriate section (ELA/Reading or Mathematics)
• Added light green shading to the ‘ELA Met Any Criteria’, ‘MATH Met Any Criteria’, and ‘ELA and MATH TSIA’ columns for rows with Y

Printable Cards:

• Corrected ‘ELA Mets Any Criteria’ to ‘ELA Met Any Criteria’
• Corrected ‘MATH Mets Any Criteria’ to ‘MATH Met Any Criteria’

Sections below this point will reflect any changes made for the 2019-20 year. 

Updated CCMR EWS Supplemental sheet to now include the following items:

• OnRamps (Added 07/20)
• Level I/II Certification (Added 07/20)

Added excel template for CCMR EWS supplemental file
Please use the linked excel template to ensure your data file format is aligned to our parser.
ODS CCMR EWS Supplemental Excel Template

Updated printable cards

Shows overall CCMR count/credit

Color change to differentiate between TSI Criteria ELA/Reading & Math

Indicator to show BOTH ELA Reading and Math if met

Added ability for supplemental OnRamps and Level 1 or 2 Certification to show ‘S’ value

Updated Dual Credit Course Sequence Codes

Prior to Update:
E0948 Course Sequence Code (C135) = 0, 2, 5, or 9

Updated To:
E0948 Course Sequence Code (C135) = 0, 2, 5, 9, D0, D2, D5, D9

Removed OnRamps Indicator

Prior to Update: 
E1597 OnRamps Dual Enrollment Indicator Code (C088) = 1
This value is reported by the UT systems for accountability. We are showing students who have an OnRamps code in PEIMS for review only. We are not checking for pass/fail or college credit hours at this time since the data will be pulled from an external source.

Updated To:
Field is now blank and does not reference any item in PEIMS file.
This value is determined through an external data source and is not coded in PEIMS. At this time we are not populating this value.

Updated CTE Coherent Sequence code to remove .5 point value

The chart TEA provided said that the ½ point carries through 2019 and 2020 and then its gone for 2021 and beyond.

Last years 12th graders (2018-19) will affect the upcoming 2019-20 (2020 accountability) – Last year to use .5

This years 12th graders (2019-20) will affect the next accountability 2020-2021 (2021 Accountability)

(See pages 15-16 of TEA 2019 Accountability Manual below)

Temporary Removal of Level I or II Certification (PEIMS)

We have temporarily removed the Level I and II Certification values from the column. We are seeking guidance from TEA to determine what PEIMS codes can be associated to the released 2019-2020 Approved List of Industry-Based Certifications.

https://tea.texas.gov/sites/default/files/2019-2020%20Industry-based%20Certification%20List%20for%20Public%20School%20Accountability%202.pdf

Sections below this point will reflect any changes made for the 2018-19 year

Uploading of CCMR data file updated to accommodate different file format

Districts can now upload the following CCMR files provided by TEA. When uploading these files districts will be required to select Prelim 1, Prelim 2, or Final from a drop down selector. For more information on the upload of the file please visit the manual link here: CCMR File Center Upload

Prelim file 1 – Provided late April 2019 – Only contained TSI data

Prelim file 2 – Provided late May 2019 – Provided additional assessment data but did not include TSI

Final CCMR file – Date of release TBD – This will be the final file provided by TEA via TEAL account access 

Uploading of CCMR data file to be temporarily disabled
In light of the new CCMR file provided by the state on May 31, 2019, we have disabled the ability to upload any CCMR data file into OnDataSuite. We will provide a notification to all clients once this option has been reactivated.

Explanation of why
Earlier today (May 31, 2019) TEA provided districts with a secondary CCMR PREVIEW file. This file layout differs significantly from the initial PREVIEW file provided to districts in late April that were used to in the development of both the A-F accountability system as well as the the CCMR EWS / TEA toggle fields option.

In addition to this file layout being different, the contents of this new file do not represent a continuation of the initial file values but rather creates a continuation of the fields and values that were not included in the initial PREVIEW 1 file.

We had anticipated that this new file would provide a wipe/replace option for prelim file 1 but now that we have seen the file, we are working toward a solution that will merge the data from both prelim file 1 and prelim file 2.

Example of both files that shows the change in file layout structure

The following updates have been applied to the CCMR EWS system as of update 11.2

1. Creation of CCMR Folder to contain CCMR EWS report along with companion reports

2. Integration of improved TEA upload CCMR file (Preview and Final)

This update will allow districts to compare their CCMR EWS report to the latest TEA provided CCMR spreadsheet when uploaded into the file center. For more information on the upload of the CCMR file please visit the following link:  CCMR File Upload Instructions

Once your CCMR file has been loaded you will be able to toggle ON/OFF the comparison view between CCMR and your CCMR EWS report. Values found in your TEA file will match against your CCMR EWS related PEIMS file.  (Note: There will be student found within the TEA file that will not match to your PEIMS file. Districts are urged to export from their CCMR EWS report and filter to confirm total students matched)

Toggle view (Off)

Toggle view (On)

3. Addition of CCMR Supplemental File Viewer Report

When districts have uploaded a CCMR supplemental file we have now provided a searchable method of viewing all student upload files. For more information about the supplemental file and what it does please visit this location of the manual:  CCMR supplemental file

4. Addition of CCMR PEIMS Checklist Report

This report displays the PEIMS elements that affect the CCMR area of state accountability. Detailed report information can be found in the report notes of this report located under the Tools/Report Information link

Usage: Use this report to review accuracy of PEIMS reporting which significantly impacts state accountability ratings.

April 2019

• Added CCMR EWS Supplement section to file center. This provides districts with a method to upload ‘place holder’ values for the following PEIMS items that may not currently be coded into the current year PEIMS files. For detailed information about this upload process and what it affects in the report please visit the OnDataSuite Manuals CCMR EWS Supplemental Files section.
  • Industry Certification
  • IEP
  • Armed Forces

• Added Printable Cards Printout- Creates a printable document of each students overall CCMR EWS point accumulation.
• Updated CCMR EWS Report notes to include CCMR EWS File Dependency Crosswalk

• Added Multi Select Graduation Status filter to include the following codes
  • All Grad Statuses
  • Has Not Graduated or Left for any reason
  • 01 – Student Graduated
  • 02 – Died while enrolled/Summer Break
  • 16 – Return to Home Country
  • 24 – College, Pursue Degree
  • 60 – Home Schooling
  • 66 – Removed by CPS
  • 81 – Enroll in TX Private School
  • 82 – Enroll in School Outside Texas
  • 83 – Administrative Withdrawal
  • 87 – Enroll in University High School Diploma Program
  • 88 – Court Ordered to a GED program – has not earned a GED
  • 89 – Incarcerated in state jail or federal penitentiary
  • 98 – Other

January 2019

• Added focus list filter to choose specific group of students
• Changed logic so that .5 displays under CCMR Met if the only condition met is ‘Coherent Aligned IBC CTE’
• Added PEIMS heading to blue area
• Added Gender column
• Added PEIMS Summer Career and Technology Code column
• Changed headers for clarification:
  • Ind Cert to Indst Cert
  • AP/IB to AP/IB Exam
  • Aligned CTE to Coherent Aligned IBC CTE

December 2018

• Changed CTE Coherent Sequence Coursework Aligned with Industry-Based Certifications to look at all years instead of the last 4
• Adjusted SPED calculation to look at current year and not prior year.
  • This is how the bound/restricted CCMR for A-F works and needed to be adjusted to reflect the current year.
• Fixed issue for SAT where it was not properly marking the student for both if they had scored for English and Math.
• Fixed issue for Dual Credit that was marking students as met when in fact they had not.

As the CCMR EWS evolves we will place items that will need to be addressed in the section below.

April 2019

Possible incorporation of On-Ramps column value
We are waiting until further confirmed guidance from the 2019 State Accountability Manual before this can be implemented.

December 2018

Military Connected Issue – RESOLVED 11.1 Update
Currently the military connected students are being populated and calculated from the Military Enlistment reported in the Leaver record in Fall PEIMS. Since these students will not be coded into PEIMS until the following year, they will not show up on the current EWS report.

Current Calculation used to determine 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)

Issue Response
We are aware of districts wanting to ‘add’ these indicators into the EWS report and are working on a solution. The current OnDataSuite system by design has never allowed independent entry fields as all data is derived from official data files but with the new EWS requirements for districts who want to keep a running tally we have been looking into a way that will allow districts to add fields such as this for the EWS report in the absence of a related PEIMS file.

Completed IEP and workforce readiness Issue – RESOLVED 11.1 Update
Currently the IEP and workforce readiness items are populated and calculated from the XXXXXX reported in the Leaver record of the Fall PEIMS submission. Since these students will not be coded into PEIMS until the following year, they will not show up on the current EWS report.

Current Calculation used to determine Completed IEP and workforce readiness Component
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)

Issue Response
We are aware of districts wanting to ‘add’ these indicators into the EWS report and are working on a solution. The current OnDataSuite system by design has never allowed independent entry fields as all data is derived from official data files but with the new EWS requirements for districts who want to keep a running tally we have been looking into a way that will allow districts to add fields such as this for the EWS report in the absence of a related PEIMS file.

Industry Based Certification Issue – RESOLVED 11.1 Update
Currently the Industry Based Certification items are populated and calculated from the XXXXXX reported in the Leaver record of the Fall PEIMS submission. Since these students will not be coded into PEIMS until the following year, they will not show up on the current EWS report.

Current Calculation used to determine Completed IEP and workforce readiness Component
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

Issue Response
We are aware of districts wanting to ‘add’ these indicators into the EWS report and are working on a solution. The current OnDataSuite system by design has never allowed independent entry fields as all data is derived from official data files but with the new EWS requirements for districts who want to keep a running tally we have been looking into a way that will allow districts to add fields such as this for the EWS report in the absence of a related PEIMS file.