Student Record-Course (D01) Report and Content Completer
(From the Tech Note dated April 25, 2014)
(FY16 – Content Completer is required for grades 0-8 only)
Resolution: The Course D01 report logic associated with Content Completer has become more robust. Outlined here are the changes made and the report logic update.
- A new data entry checkbox field is available for Courses: “Course does not provide opportunity to learn entire course content (Content Completer = N)”.
- A new data entry checkbox field is available for Sections: “Section does not provide opportunity to learn entire course content (Content Completer = N)”.
- A new run-time report parameter is available, labeled “Content Completer for K-5”, which is used only for elementary school students, with the following options:
- Set all values to ‘P’
- Use Percent
- Use Alpha Grade
- The existing run-time report parameter, labeled “Value for Numeric Grade”, keeps the options:
- Percent
- Alpha Grade
The report output of the Content Completer field value is determined based on a student’s grade level, course, section, and stored grade as follows:
- When [S_GA_SGR_X]ContentCompleter is not null the field’s value is returned (P/F/N). This will override any values calculated below.
- When the “does not provide opportunity to learn entire course content” box is checked on an associated course or section, the Content Completer value of ‘N’ is returned. This will override any values calculated below.
- When the “does not provide opportunity to learn entire course content” box is not checked on an associated course or section, the Content Completer value is calculated based on a student’s grade level as described below.
For Elementary Schools students (grade levels K-5)
- The run-time “Content Completer for K-5” parameter chosen will affect which report logic is used.
- When ‘Set all values to P’ is chosen output Content Completer as P.
- When Content Completer is calculated from ‘Use Percent’ the calculation is based on [StoredGrades]Percent as follows:
- [StoredGrades]Percent is 0 output P
- [StoredGrades]Percent is >0 and < 70 output F
- [StoredGrades]Percent is >= 70 output P
- [StoredGrades]Percent is null output blank
- When Content Completer is calculated from ‘Use Alpha Grade’ the calculation is based on [StoredGrades]Grade as follows:
- StoredGrades]Grade is (A, B, C, D, E, M, P) output P
- [StoredGrades]Grade is (F, N) output F
- [StoredGrades]Grade is not (A, B, C, D, E, F, M, N, P) output blank
For High Schools students (grade levels 9-12)
- The run-time “Value for Numeric Grade” parameter chosen will affect which field is used by the report logic. The calculation is as follows:
- [StoredGrades](Numeric Grade) is 0 output P
- [StoredGrades](Numeric Grade) is >0 and < 70 output F
- [StoredGrades](Numeric Grade) is >= 70 output P
- [StoredGrades](Numeric Grade) is null output blank
- [StoredGrades](Numeric Grade) is not a number output blank
For Middle School students (grade levels 6-8)
Note: Grade levels 6-8 are handled as a combination of elementary and high school logic because some districts assign only alpha grades while other districts assign numeric grades and earned credits. The middle school Content Completer logic checks stored grade values in the following order:
- [StoredGrades]Grade is (A, B, C, D, E, M, P) output P
- Check “Value for Numeric Grade” parameter
- [StoredGrades](Numeric Grade) is 0 output P
- [StoredGrades](Numeric Grade) is >0 and < 70 output F
- [StoredGrades](Numeric Grade) is >= 70 output P
- [StoredGrades]Grade is (F, N) output F
- If Content Completer not yet assigned then output blank
Action Required (usually associated with grades 6 and higher):
For districts that teach the full content of a course as one section there is no data entry required. A student’s grade level and stored grade will determine the Content Completer value.
For districts that teach the full content of a course as two sections there is required data entry. The first portion of the course, or section(s) of the course, needs a check mark. The first portion of the course must be Content Completer=N and the second portion of the course will be calculated using a student’s grade level and stored grade to determine the Content Completer value.