On August 17, 2020 TEA announced that they would be providing two CCMR related files to districts via the TEAL system. Of the two reports made available to districts, OnDataSuite is now accepting the College, Career, and Military Readiness (CCMR) Verifier file as an upload.  Please review the instructions in this manual to learn what file and file type we are accepting and how its upload will affect different locations in the system.  

In order to obtain your  CCMR Verifier File you must have access to the TEAL system or have a designee at your district that can log onto a TEAL account to pull the file.

Special thanks to Dr. Monica Uphoff at Birdville ISD for providing the TEAL images

Step 1. Log into your TEAL Account
https://tealprod.tea.state.tx.us/

Step 2. Go to the Accountability Tab in TEAL.
If you do not have this tab you will need to find someone in your LEA that has access to this section.

Step 3. Locate and click on the College, Career, and Military Readiness (CCMR) Tracker and Verifier link (posted August 17, 2020)

Step 4.  You will see two items: CCMR Tracker and CCMR Verifier. Click on the CCMR Verifier.
Note: OnDataSuite does NOT utilize the tracker at this time.

Step 5.  Click on the 2020 Preliminary CCMR Student Listing (Excel)
Download this file to a local location on  your computer and DO NOT OPEN IT. The file must be an EXCEL document.

We are aware that the file has headers and has multiple tabs and the file will load.

Remember where you stored this file as you will need to point to its location from the OnDataSuite File Center to upload it

If you have your CCMR Verifier file downloaded locally you can now upload the file into your file center by following these steps

 

Step 1. Log into your OnDataSuite account and Click on the File Center button at the top of the screen

 

Step 2. Click on the blue CCMR button to enter the CCMR file center location listed under the Data Sources Sub Menu

Step 3. Click on the green ‘Click to upload CCMR Files’ button

Note: In order to load data files into your OnDataSuite you must have ‘file upload’ privileges assigned to your account. If you do not see a green button then you will not be able to upload the file and will need to find your local system administrator for further assistance.

 

Step 4. A popup box should have opened asking you to locate your file. Search for your file, select it and click the open button.
TEA has specified that the CCMR file will be available as an ‘Excel’ download but does not specify if the available file will be in xlsx format.  For the purpose of uploading into the OnDataSuite CCMR file center location please do not attempt to change the format but rather search for the file that you have downloaded locally and load the file in the format that was provided.

 

Finding the file for upload

If you cannot see the file that you downloaded to your local location please make sure to check for all file types in your location as shown in the examples below:

 

On a PC you can use the drop down to select ‘All Files’ shown next to the file name open field

 

On a Mac you can use the drop down to select ‘All Files’ shown next to the file name open field

 

Step 5. Assign Year: 2019-20 (Corrected 08/21/20)
(You will need to assign the year as 2019-20 because the list that TEA provided to you was provided in 19-20 but the graduate information is associated with your 2019 Graduates)

Step 6. Assign as Final
In prior years TEA provided three separate files to districts with three separate data file format structures. The current file TEA has provided as of 08/17/20 has a data format that matches last years FINAL file. 

 

Step 7. Click the green ‘Start Upload’ button to upload the files into your file center

Once data from the verifier file has been uploaded into your OnDataSuite system you can view individual student CCMR data from within the student dashboard by clicking on the CCMR tab. This requires that you have access to student level data.

To get to any student level dashboard it requires that you click on the student from within a found list set. In the example below we performed a search for a specific student to get to a returned list value that we could click on, but you can also get to a student dashboard if they are in any returned list.

 

Once you are within a student dashboard location, you will see the CCMR button on the far right hand side of the screen. The CCMR data is specific to the student you selected.

 

This dashboard report has three columns.

• CCMR EWS – This represents the students as they are shown in the CCMR EWS report. There are not any exclusions and it includes all students even non accountability subset.
• ODS – This represents the students as they are shown in the A-F domain 1 model and may or may not include students based on accountability subsets or exclusions based on annual accountability manual declarations.
• TEA – This represents the student as reported to districts via the TEAL Verifier account.

The data that is affected by the CCMR Verifier upload will be reflected in the last column on the right and will correlate to the year drop down selected.

 

Once TEA has released their final manual revisions, districts can monitor their CCMR (ODS) progress from within the Accountability , Domain 1 – Student Achievement detail section of the software. Once the TEA released CCMR file is released its values are then represented in the column next to the ODS column to provide a side by side comparison of predicted vs final CCMR point accumulation.

TEA released CCMR data can be compared side by side to your preliminary OnDataSuite CCMR EWS reported data through the State Accountability CCMR College, Career, Military Ready Early Warning System (EWS)

Once in the report click the ‘Show/Hide Filters’ button 

Then you will need to have the following selections made:

Year 2018-19 ( The list you received in 2020 represents the 2019 graduates)
All Campuses
Grade 12
All Grad Statuses
All CCMR

Select green ‘Compare to TEA’ button and hit Submit

 

Once the report has run you will be able to see your ODS results side by side with the TEA file you just uploaded.

 

If you wish to export this report you can then click on the ‘tools’ menu in the top right hand corner and export the list to excel.