1. Home
  2. Final Grad and Dropout

Final Grad and Dropout

Final Grad and Dropout – Accepted Data File Layout
This file is an Excel format (.XLS) or (.XLSX)

Files loaded in this area are used for:

  • OnPoint>Student>Student Report Center>General
    • 4-Year Longitudinal Student Listing
    • 5-Year Longitudinal Student Listing
    • 6-Year Longitudinal Student Listing
  • OnPoint>Accountability
    • State: Accountability Report Center
      • A-F Rating System>Graduation Rates
      • OnTAPR>Cohort Longitudinal Rates
    • Results Driven Accountability>Graduation Rate Indicators
    • Data Validation Monitoring>Leaver Data Analysis>Leaver Records Data Validation Indicator #8
  • OnBoard > Dashboard > 4 Year Graduation Cohort Collection

Locate and Retrieve the files from the Accountability Application via TEAL – posted first of June

  • Select Final Graduation and Dropout Information
  • Click the “+” to open the Final Grad & Dropout Info
  • Click the ” Four Year Longitudinal Information” first
  • Select the EXCEL option for “Class of 2019 Four-Year Longitudinal Student Listing“. (see screen shots below for example)
  • Click “Continue” to download
  • NOTE: Do NOT open the file

Repeat for “Class of 2019 Five Year Longitudinal Student Listing

     NOTE: Do not open the file before uploading to OnDataSuite.
     Opening the file and then saving it causes some changes that do not allow it to upload properly.

NOTE: Graduation Rate calculation:

Statuses used in TEA Longitudinal Files

  • Numerator (Graduates) ‘GRADUATED’
  • Denominator (Class) ‘GRADUATED’, ‘RECEIVED GED’, ‘CONTINUED H.S.’, ‘DROPPED OUT’

Load files into OnDataSuite

         In order to load files into OnDataSuite, user must have “File Upload” access.

1. Log into OnDataSuite using Chrome as your browser

2. Locate the “File Center” in the top black menu bar

3. Click the “Data Sources” tab

4. Select the blue “Final Grad and Dropout” button under the TEAL section

5. Click on the green upload button to upload the files (must have “File Upload” access)

6. Browse to location of the files and ‘Open’ (Multi select all files at once)

7. Select the appropriate “year” from the Listing years drop-down box ( 4, 5, or 6 Year Longitudinal)

8. Select green “Start Upload” tab to continue or “Cancel Upload” or Delete the file (click the X far right side)

9. When the data upload is finished, scroll down to confirm that the process completed correctly

10. Click the “Info”, located at the end of the row for a loaded file

Updated on 11/04/2021

Was this article helpful?