Support

On 5/10/2023 the Civil Rights Data Collection Resource Center announced that the Registration window for the 2021-22 Civil Rights Data Collection will be open from May 15, 2023 through June 30, 2023.  They also provided a video link to learn more about the registration process. Please visit the  Civil Rights Data Collection Resource Center site to learn more about this step.

Per the Civil Rights Data Collection Resource Center, the Office of Civil Rights (OCR) anticipates that the CRDC data submission window will open in Winter 2023 for the 2021-22 collection.

Now that the proposed 2021-22 CRDC has been approved we are scheduling the development of the 2021-22 Civil Right Data Collection pages in Aeries. As a reminder we have already included nonbinary student counts in any tables that disaggregate by student gender. In the 1/19/2023 update we improved system performance while processing the CRDC results.  Please NOTE that at this time the majority of the Aeries CRDC logic and the CRDC Extract still reflects the 2020-21 requirements. We are working on making changes based on the 2021-22 reporting requirements and will release the changes as we complete them.

Please check the CRDC Resource Center website for updates on the status of the 2021-22 CRDC. The proposed 2021-22 changes can be found in this document: https://www.reginfo.gov/public/do/PRAViewDocument?ref_nbr=202111-1870-001 

1/19/2023 - Aeries Revision Notes 01/19/2023

This update includes the following changes:

• Retention counts were inaccurate if a retention date fell outside the student's enrollment dates, fixed
• The retention count extracted for virtual schools had the potential to be different than the count displayed on the page, fixed.
• The section total counts were incorrect for  virtual schools in some cases, fixed.
• System performance when processing the Enrollment, Courses, Discipline, Restraint and Alleged Harassment sections was improved.
  
  

Functionality 

• The CRDC page is functional, but please remember that the majority of the logic is still based on 2020-21 reporting requirements.
• Please remember that the CRDC will be run in the 2021-22 school year.
• General Settings - Reporting Dates - Please remember to update the reporting dates for the 2021-22 reporting period.
• All other CRDC Settings tabs - no changes have been made to these tabs. Review/update the settings to make sure they reflect courses and codes used in the 2021-22 school year.
• File Download - the CRDC Extract has not been updated for the 2021-22 submission. 

Next Updates (2021-22 Collection)

• Results  -  remove Preschool counts from tables ENRL-1  through ENRL-3b, add a count of IDEA students to ENRL-2b
• Results  - for the COUR-13 - Single Sex Academic Classes Details table, remove the Algebra I, Geometry, Algebra II totals, remove the Other Mathematics totals, and add a Mathematics total which will include class counts of all identified Mathematics courses from the CRDC > Courses > Courses > Math tab.
• Results - revert changes from the 2020-21 collection with respect to Preschool Suspensions and Expulsion counts. Add a 504 count column to these tables. This affects tables DISC-1a through DISC-1c.
• Results - add a 504 column to the DISC-4 - Preschool Corporal Punishment, the DISC-2 - Preschool Instances of Suspension, and the DISC-5 - Preschool Instances of Corporal Punishment tables. Adjust the calculation for the IDEA count and the 504 counts in these tables.

03/03/2022 - Aeries Revision Notes 3/3/2022

This update includes the following changes:

• The Advanced Placement Courses (APIB-4) element showed section counts instead of course counts, fixed.
• Several sections required adjustment in order to properly report students who were enrolled in a Virtual school and had the reporting home school field populated, fixed.
  NOTE:  Some "instances" school counts (number of classes, number of courses, instances of suspension, instances of offenses, allegations by offense, etc.)  are overstated for districts with Virtual Schools. Elements of student counts disaggregated by ethnicity, race, LEP, IDEA, 504 are not affected by this issue, just the school counts.
• Also added the table id and a friendly explanation to error messages in the completion email.

Functionality

• Before working in the CRDC page please review the CRDC documentation available at Civil Rights Data Collection Resource Center to become familiar with the reporting requirements. The New User Starter Kit, LEA Form and School Form are good documents to start with. Also the Security and Tables for Civil Rights Data Collection  and  Preparation for Civil Rights Reporting  support documents will be helpful at this stage.
• Please remember to run the CRDC in the 2020-21 (i.e. last school year's) database
• Schools Tab - schools that will be included in the 2020-21 CRDC can be selected and the NCES numbers can be added. 
• General Settings - Reporting Dates - enter the Fall, Spring, Special Ed, Fall End and Spring End reporting dates. Please click on the i (Info) button to learn which dates are recommended by the CRDC. 
• General Settings - User-Defined Codes & Locations, Retention Codes,  Single-Sex Academic Class Definition and Transitional Kindergarten (TK) Counted As (California only) areas can be set up.
• Courses - Subject Areas/Department - The Computer Science selection boxes have been added to the Subject Areas/Department tabs. The Subject Areas/Department tabs help limit the courses available for each area in the Courses tab.
• Courses - Courses - Courses can be selected for each of the categories.   State Course Code (CA) / Service ID (TX) filters have been added to the course boxes. Also the Block Scheduling area has been added to the Courses subtab. Please see  Preparation for Civil Rights Reporting and Civil Rights Setup - Courses Tab  for more information on how to identify the blocked classes.
• Cert. Teachers & Codes - The Certified Teachers tab has been updated to use the Staff Credentials (STC) table to report the number of teachers certified to teach certain subjects. Also, there are new option sets for Type of Certification and Computer Science subject. Please see Civil Rights Setup - Cert. Teachers and Codes Tab
• Cert. Teachers & Codes -  Other Codes -The code definition setup for Discipline, Harassment, Restraint/Seclusion, and Other tabs has been simplified; many of the codes that do not already have settings saved to District Options (DPT) will now populate default values; the AND and OR buttons were removed for all codes except the Disciplined for Harassment or Bullying codes and the Possession of a Firearm or Explosive Device.
• Results - Process Civil Rights Data - this button can be run for purposes of reviewing Overall Student Enrollment counts, program counts and enrollment course counts in the Results tab. Also, the CRDC Extract has been updated for the 2020-21 submission.
• Victims - there is a new, optional for 2020-21,  reporting  category of Allegations of Harassment or Bullying – By Religion Type. If districts wish to report this information they will need to update any 2020-21 Victim records that are flagged as Basis of Religion with the Religion Type. Since Rollover has already occurred, to ensure that the data is also in the 2021-22 school year districts will need to update both school years.
• Algebra I Completion in Texas districts - We have determined that Texas districts can use the current procedures to update the Testing Pass Status (TPS) table for Civil Rights Data Collection purposes. Please see Preparation for Civil Rights Reporting and Algebra I Requirements
• File Download - The CRDC Extract has been updated for the 2020-21 submission.

Next Updates

• Cert Teachers and Codes - Other Codes - for Texas districts, in Edit mode the In-School Suspension (06) and Out of School Suspension (05) descriptions are mixed up in the dropdowns.

Pending Issues

• Extract -  Some "instances" school counts (number of classes, number of courses, instances of suspension, instances of offenses, allegations by offense, etc.)  are overstated for districts with Virtual Schools. NOTE: elements of student counts disaggregated by ethnicity, race, LEP, IDEA, 504 are not affected by this issue, just the school counts.

01/25/2022 

This update includes the following changes:

• On the Cert. Teachers & Codes tab, under Disciplined for Harassment Settings, the AND and OR buttons disappeared when populating a record, fixed. 
• In the Discipline section, the AND and OR buttons were added for Possession of a firearm or explosive device.  

01/18/2022

This update includes the following changes

• General Settings - added a warning message for the 504 Plan and GATE settings, if the FOF or the GTE table are selected. These tables are processed by default and these settings should be used for alternative locations.

• Cert. Teachers & Codes > Other Codes - Added logic for Texas codes translations.

• Cert. Teachers & Codes > Other Codes - Some default value settings in the Allegation of Harassment and Bullying by Religion Type sections were lost if the user modified any value, fixed. 

• Cert. Teachers & Codes > Other Codes - The default values for Expulsion with and without Ed Services did not allow proper editing, fixed. 

• Results - In some instances the Retentions section produced duplicate counts, fixed.

12/16/2021

This update includes the following changes

• Cert Teachers & Codes >Other Codes subtab - The code definition setup for Discipline, Harassment, Restraint/Seclusion, and Other tabs was simplified:
  • Many of the codes that do not have settings saved to District Options (DPT) will now populate default values
  • The AND and OR buttons were removed for all codes except the Disciplined for Harassment or Bullying codes.

12/9/2021

This update includes the following changes

• Extract - Updated the extract for the 2020-21 submission. Minor adjustments were made to comply with the new naming convention of some offense (OFFN) elements.
• Results - The EXAM-1 table was displaying "No Data" when SATI/ACT records existed for the academic year, fixed.
• Results - Updated tables that were not including counts to the Reporting Home School (STU.HS) for students enrolled in only a Virtual School in 2020-21.

11/18/2021

This update includes the following changes

• Courses > Courses subtab - Added a filter to each of the selection boxes to allow for filtering the box by either State Course Code (CRS.C3) for California districts, or by Service ID (CRS.SVC) for Texas districts. Also added a Block Scheduling section to identify the Master Schedule User field (MST.U3) 
• Updated the logic to use a Master Schedule User (MST.U1 - MST.U8) to identify block schedule classes. See  Preparation for Civil Rights Reporting for more information.
• Results - We are updating the Results tables as we make changes to the set up tabs. Removed the three "firearm or explosive device" items in the OFFN-1 table, added table OFFN-4. Updated count logic for HIBS-1a and HIBS-1b tables.

10/28/2021

• The Cert. Teachers & Codes tab has been updated to use the Staff Credentials (STC) table to report the number of teachers certified to teach certain subjects. Also, there are new option sets for Type of Certification and Computer Science subject. The calculations for the Teachers with Certification tables (COUR-9, COUR-14, COUR-16) have been updated.
• The Courses tab has been updated to include Computer Science selection boxes. The Preschool Enrollment (PSCH-1) table as well as calculations for Computer Science tables (COUR-15, COUR-16, COUR-17, APIB-11 and APIB-12) have been added to the Results tab. The Victims Status (VIC.ST) has been removed from the default setup values. Also, other miscellaneous adjustments have been made to comply with the new data requirements.

This update includes changes to the General Settings tab  

• removed No Show selection box and now use No Show Setup to determine the No Show codes in each school
• removed the Next Grade (STU.NG) option from the Retentions selection box and update the logic to only use Retention (RET) records
• removed the Transitional Kindergarten from the General Settings tab for Texas districts.

9/13/2021 

This  update corrected the issue with the Texas single race code counts.  Aeries Revision Notes 9/13/2021.  

1. Text and links on the CRDC pages have been updated to reflect the 2020-21 school year
2. Victims -  A new field has been added to this page for Civil Right Data Collection to select a student's religion type when the Basis of Harassment - Religion is selected. Reporting the Religion Type is optional for the 2020-21 CRDC administration, but may be required for future administrations.

Prior to 8/11/2021

• U.S. Department of Education Office for Civil Rights
• Civil Rights Data Collection Resource Center