The General Settings tab contains the set up for the dates and many of the code values used in the Civil Rights Data Collection calculations. Some code values will use default options. The information for these fields will need to be reviewed/updated prior to processing the Civil Rights report.
User-Defined Codes and Locations
Use the dropdowns to select the table, field and value for LEP and any alternate table, field and values for the 504 Plan and GATE codes. If you are familiar with the table and field names used in Query you can type the information into each dropdown and press the TAB key to move to the next one. Please see the description below to determine if your district needs to set up any additional table and field locations.
- LEP - Limited English Proficient or English Learner - the STU.LF field is used to identify students as English Learners. Enter the code value used to designate English Learner students. NOTE: multiple field values can be entered for districts that have more than one code to identify Limited English Learners.
- 504 Plan - The CRDC calculations will first use the 504 Plans (FOF) table to identify any students that had an active 504 record during the 2017-18 school year. If no FOF records can be found for the student, then it will also use the information defined in this area to identify the 504 students. Typically the Programs table with Code value 101 (PGM.CD = 101) is the alternate table that stores 504 program records. NOTE: FOF and PGM tables and fields will always be evaluated in conjunction with their dates. In order to include the student in the 504 count, the alternate table/field record will need to meet the defined condition and be active as of the Fall Reporting Date
- GATE - The CRDC calculations will first use the Gate (GTE) table to to identify any students that had an active GATE record during the 2017-18 school year. If no GTE records can be found for the student, then it will also use the information defined in this area to identify the GATE students. Typically the Programs table with Code value 127 (PGM.CD = 127) is the alternate table that stores GATE program records. NOTE: GTE and PGM tables and fields will always be evaluated in conjunction with their dates. In order to include the student in the GATE count, the alternate table/field record will need to meet the defined condition and be active as of the Fall Reporting Date
The Student Next Grade (STU.NG) field can be used to identify if a student was retained at the end of the 2017-18 school year, or the Retentions (RET) table code values can be used.
If retained students are identified through the Student Data Next Grade (STU.NG) field, then select this option in the Retention Codes setting. The Civil Rights calculations will compare the grade (STU.GR) to the next grade (STU.NG) to determine if the students were retained at the end of the school year.
All Retention codes set up in the Code (COD) table (where COD.TC = 'RET' and COD.FC = 'CD' ) will be available to choose from. Select the code(s) used to tag students as Retained. The Civil Rights calculations will use the Retention records that fall within the 2017-18 school year to determine if students were retained during the school year.
NOTE: Either the STU.NG field or the Retention codes can be used as the method to identify the retained students, both methods cannot be used at the same time.
No Show Codes
The Student Tag (STU.TG) field is used to identify the student's status. All Student Tag codes set up in the Code (COD) table (where COD.TC = 'STU' and COD.FC = 'TG' ) will be available to choose from. Select the code(s) used to identify the No Show students. These student records will not be included in any Civil Rights calculations.
The Reporting Dates section contains all dates needed to run the report. It includes the Reporting Dates for Fall and Spring, the Term End Dates for Fall and Spring, and the Special Ed Reporting Date.
- Per CRDC Guidelines the Fall snapshot date must be a date when schools were in session on or near October 1.
- The Spring date will only be used if there are sections with Block Scheduling (MST.BL > 1). Per CRDC Guidelines the Spring snapshot date must be a date when schools were in session near March 1.
- The End dates for Fall and Spring are used to determine the Algebra I student enrollment counts. The dates need to be a date near the end of each term when all schools were in session.
- The Special Ed Reporting Date is used to determine if a student was enrolled in the Special Ed program on that date. If so, they are included in the Special Ed counts.
Clicking on the Info button on the Reporting Dates header will display information about the Reporting Dates.
NOTE: Please review the information available on the CRDC Resource Center for more information on the Reporting Dates and any other reporting requirements/definitions.
Single-Sex Academic Class Definition
The Civil Rights calculations will use either the Master Schedule Sex (MST.SX) field or the Courses Traditional Gender (CRS.TGN) field that is selected on the General Settings tab to determine the number of Single-Sex academic classes offered at the schools.
Per CRDC guidelines Transitional Kindergarten students can be included in either the Kindergarten counts or the Preschool counts depending on the TK program (CRDC Data Tip: Reporting Transitional Kindergarten Students in the CRDC). By default the TK students will be counted in the Kindergarten counts. Select the Preschool option if they need to be included in the Preschool counts in your district.
After all selections have been made on the General Settings tab click on the Save General Setting button. A green message will display in the upper right corner once the settings are saved. Click on the Next button to go to the Courses tab.