Rep9o
Summary
Use DR00 - Dropout Summary worksheet in the (NC) Dropout Data Collection report to review dropout counts, Month 1 membership, and state dropout rates by grade band.
Review the summary alongside DR01 - Reported Dropout Detail. Reported Dropout Detail contains record level rows; Dropout Summary counts students by reporting school. Multiple reportable records for one student can therefore result in more Reported Dropout Detail rows than students counted in Dropout Summary.
Purpose
Dropout Summary summarizes the student population identified as reportable by the current data load. It provides:
- Dropout counts for the Overall and State populations
- Month 1 PMR membership counts
- State dropout rates
- Counts by grade band and by male and female subgroups
The Overall and State populations differ. Overall counts include CCAHS and Expulsion classifications. State counts exclude those classifications and are used in the state dropout rate calculation.
Severity
Information
What to Review
Run the (NC) Dropout Data Collection report and open the DR00 - Dropout Summary worksheet in Excel output.
- Confirm the reporting year and SummaryLevel, PSU, and school identifiers.
- Review the grade band values for Month 1 membership, Overall dropouts, and State dropouts.
- Compare the Dropout record's PSU and school with the reporting PSU, school, and grade.
- Compare the Dropout Summary State counts with the corresponding reported detail and investigate unexpected differences.
- Confirm the State rate using the matching grade band values: State Rate = State Dropouts ÷ (Month 1 MLD + State Dropouts) x 100
- At the PSU level, review the PSU totals and school rows. PSU rates are recalculated from the summed PSU counts and membership; they are not averages of school rates.
Report Content
The grade band suffixes identify the grades included in each value:
- g113 = grades 01-13
- g713 = grades 07-13
- g913 = grades 09-13
| Column | How to use it |
|---|---|
| SummaryLevel, ReportEndYear, PSUCode, PSUName, schoolCode, schoolName | Identify the reporting year and summary row. At the PSU level, the summary includes a PSU total row followed by school rows. |
| MLD_g113, MLD_g713, MLD_g913 | Month 1 PMR membership values for each grade band. These values use the verified Month 1 PMR memLastDayNVIO counts. |
| Overall_All_g113, Overall_All_g713, Overall_All_g913 | All student dropout counts for each grade band, including CCAHS and Expulsion classifications. |
| State_All_g113, State_All_g713, State_All_g913 | State population dropout counts for each grade band. These exclude CCAHS and Expulsion classifications and are used in the State Rate calculation. |
| StateRate_g113, StateRate_g713, StateRate_g913 | State dropout rate for each grade band, calculated from the matching State dropout count and Month 1 MLD value. The result is expressed as a percentage. |
| Overall_Male_g113, Overall_Male_g713, Overall_Male_g913 | Overall dropout counts for students whose sex value is M, by grade band. |
| State_Male_g113, State_Male_g713, State_Male_g913 | State population dropout counts for students whose sex value is M, by grade band. |
| Overall_Female_g113, Overall_Female_g713, Overall_Female_g913 | Overall dropout counts for students whose sex value is F, by grade band. |
| State_Female_g113, State_Female_g713, State_Female_g913 | State population dropout counts for students whose sex value is F, by grade band. |
The Male and Female subgroup values use the M and F values in the report data. Records with blank or other values are included in the All totals but not in those two subgroup counts.
The summary counts students by reporting school, not Dropout records. Multiple Reported Dropout Detail records for one student in the same reporting school do not increase the Dropout Summary student count.
Recommended Action (does this need expansion?)
- Review the g113, g713, and g913 values for each row.
- Confirm the Month 1 MLD values against the corresponding verified PMR data.
- Compare the Dropout Summary dropout counts with the students and reporting grades shown in the Reported Dropout Detail. Compare student counts by reporting school rather than counting Reported Dropout Detail rows.
- Review the difference between Overall and State counts. CCAHS and Expulsion classifications are included in Overall counts and excluded from State counts.
- Recalculate the State Rate using the State dropout count and MLD value for the same grade band.
- For PSU Summary, confirm that the totals reflect the school counts and that the PSU rate is calculated from PSU level totals.
- If a value appears unexpected, review the relevant Edit Checks and source records before making a correction.
- Rerun the report after the nightly refresh and confirm the updated summary.
Use the current Dropout Data Manual for policy questions about reporting classifications and requirements. The summary shows the result of the current data load; it does not replace source data review or policy guidance.
NEXT: Continue to Complete the Final Dropout Review. Return to Dropout Reporting.
