The Graduation Rate Report provides Florida districts a comprehensive tool for monitoring and analyzing student progress towards graduation by allowing users to track whether students are "On Track" or "Behind" in their journey, as indicated by status columns that reflect each student's current standing based on their accumulated credits and GPA.
The Graduation Rate Report determines a student's status based on their GPA and cumulative credits, not directly on specific graduation requirements like course completion. This is important because it could explain why some students are marked as "On Track" even if they are missing required courses.
1. In the Grades menu, click Graduation Rate Report.
2. Select the Cohort year from the pull-down.
3. Select the Schools you'd like to include in the report from the pull-down. The pull-down defaults to All schools. You can run the report for All schools, select multiple schools, or select one school for which to run the report.
You will only be able to select schools you have permissions to view.
4. Click Submit.
The report displays the School and Graduation Rate. The Behind, Dropout, EOY Error, Graduated, Missing, Non-Graduate, On Track, and Transfer Out of Cohort columns indicate the number of students who meet each status. This view is designed to give administrators a quick snapshot of how each school is performing in terms of graduation readiness, helping to identify which schools may need additional support or intervention.
Below is the logic used to calculate the number of students flagged as Behind and On Track:
Behind: If the Student has a student_gpa_calculated.gpa < 2.0 AND if in a 24-credit program:
grade 09: student_gpa_calculated.cumulative_credits < 6.0
grade 10: student_gpa_calculated.cumulative_credits < 12.0
grade 11: student_gpa_calculated.cumulative_credits < 18.0
grade 12: student_gpa_calculated.cumulative_credits < 24.0
Otherwise:
grade 09: student_gpa_calculated.cumulative_credits < 4.5
grade 10: student_gpa_calculated.cumulative_credits < 9.0
grade 11: student_gpa_calculated.cumulative_credits < 13.5
grade 12: student_gpa_calculated.cumulative_credits < 18.0
On Track: If the Student has a student_gpa_calculated.gpa >= 2.0 OR any student_gpa_calculated.cumulative_credits
5. Click Pivot to add additional fields to the report, including Grade Level, Drop Code, 504 status, Race, ELL (English Language Learner) status, ESE (Exceptional Student Education) status, and more.
These additional fields allow for a deeper analysis of student progress by filtering and grouping students based on various attributes. It's particularly useful for understanding how specific student populations are performing and identifying trends or disparities that might require targeted interventions.
a. From the Pivot pop-up window, select the additional columns that you'd like to include in the report by selecting the applicable check boxes.
b. Click the four dots icon and drag the column to re-arrange the order of the columns that are being added to the report.
c. Click Done to apply changes.
d. Click Submit to run the pivoted report.
The new report displays the additional columns selected and their application per School, Grade Level, ELL, etc. depending on the columns selected and the number of students Behind, On Track, etc.
e. Click Pivot again to edit or remove the additional columns/information. Click Submit to refresh the report.
6. Click the School name to view a detailed report of all students at the school and the statistics.
The detailed school report displays the student ID, Student name, Grade Level, Drop Code, Race, ELL, ESE, 504, Graduation Program, Credits, GPA, Weighted GPA, Passed ELA, Passed Alg 1, Diploma Type, Cert. of Completion, and the student's Status.
a. You can view the school report for All students or students who meet a certain status by clicking the corresponding filter buttons at the top of the report.
b. Click the Student name to open the student's record in Student Info.
c. Click the white X to close the student report.
If there are multiple pages of data, click the Prev and Next buttons to navigate through pages. You can also enter a number in the Page text box to jump to a page.
Click the Excel icon in the Export section to export the table of data to an Excel spreadsheet, which can then be saved to your computer.
Click the Printer icon to print the table of data.
Click Filters to filter data and apply filter rules.
a. To add more than one filter to a column, click on the green plus sign.
b. To delete an added filter, click on the red minus sign.
c. Select the gray arrow for additional filtering rules.
For more information, see Filters.
You can also sort data by clicking on any of the headers. Click once for ascending results; click twice for descending results.
Use the Filter text box located in the Schools pull-down to quickly find a selection. Begin typing the name of the school to locate it in the list.
a. Select the Exact filter check box to filter the results based on the text entered exactly.
Click Check all to select all options in the pull-down. Click Clear to remove any selections made in the pull-down.
The Page Size defaults to 20 meaning that 20 lines of data are displayed. To change the number of data lines displayed, enter the Page Size desired, such as 10.
