This lesson will guide a Charter Organization with multiple LEA's, through the steps to set up and use the CRDC tool in order to export your files for submission to the Office of Civil Rights. These extracted files can be submitted to the Office of Civil Rights using their data collection site. This workflow is unique for organizations that have a separate or different LEA from the District.
You can submit the whole file at one time, or submit pieces of the file one at a time. You will have 75 days from the opening of your state’s window to gather and submit all the required data.
This lesson is for Charter Organizations with multiple LEA's only. If you do not have multiple LEA's, please stop and review Civil Rights Data Collection Tool.
Submission Window
For the submission window opening in February of 2018 states have been staggered as shown below:
You will not be able to login for submission until the date the window opens for your region.
Where to Start
1. Click on Reports.
2. Select Civil Rights Data Collection (CRDC)
Civil Rights Data Collection Tool Overview
Landing on the tool's overview page, there is a subnavigation panel with tabs or steps to using the tool most efficiently.
The tool is broken down into four sections.
- LEA Information pairs with the data updated in Site Management to fill out the necessary data for the LEA Extract.
- Data Setup input screen for selecting various courses, behavior violations, etc to populate the School Extract
- LEA Extract Page where you can choose all or part of the LEA file to submit based on your filtered choices in the scope selector.
- School Extract Page where you can choose all or part of the School File to submit based on your filtered choices in the scope selector.
- CRDC Website Link to the U.S. Department of Education site where you can find information about the CRDC.
- Home to be returned to the CRDC Overview page.
Ideally, your District has already completed the tool as described in Civil Rights Data Collection Tool. For Charter Organization with multiple LEA's, you have to complete the process again, but with a few manual tricks to submit your files accordingly.
Great question! Each school that has its own LEA code and is technically, it’s own district. This means that if you operating with more than one LEA within your Charter Management Organization, you are operating more than one distinct district within your CMO.
As such, each LEA has it’s own NCES id’s and must report individual LEA files with the necessary NCES ID code populated. This falls into the category of “man we wish we had a sandbox site to play with before the submission window opened up!” that Illuminate continues to beg for from the Civil Rights Department.
It is highly advised to work on one site at a time when doing this process. Please make sure that the only NCES IDs that are populated are the District NCES ID and actual school you are generating these extracts for.
Temporarily, enter your CMO/LEA NCES ID Number for your charter organization in place of the District's. Don't worry, this is temporary and you will change this back.
1. Go to Cog Wheel, then select Site Management.
2. Click to Edit, to be able to enter the temporary information.
3. Scroll down to the CIvil Rights Data Collection (CRDC) Fields section to enter the charter site's District NCES ID Number.
4. Press Save.
If the School NCES ID Number is not entered, now you will enter it in Site Management for the first site you are working on.
5. Then, go to the charter site you are working on.
6. Scroll down to the Civil Rights Data Collection (CRDC) Fields, to either:
- A) Confirm the correct Site NCES ID number is correct, or
- B) Enter the correct site NCES ID number as appropriate
7. Select SAVE.
Only if Contact Information is different or unique to that of the School Site will you update this area.
If ANY of information doesn't change, then leave this portion alone and skip to the next step.
This page, in conjunction with the updated selections in the Civil Rights Data Collection (CRDC) Fields of site management will be all the data needed for the LEA Flat File.
The LEA Information page defaults to the District Name because the LEA file refers to district information, not specific site information, that is setup is found under Data Setup.
These fields do not tie to a specific table within the Illuminate database and therefore must be answered on this page.
- Who is responsible for coordinating your Title IX information in the district? Record this person’s contact information will need to be filled in here.
- Who is responsible for coordinating your Title VI information in the district? Record this person’s contact information will need to be filled in here.
- Who is responsible for coordinating your Section 504 and/or Title II information in the district? Record this person’s contact information will need to be filled in here.
From here to the end of the page you will be answering a series of yes/no questions. Please remember to save every so often. Once this data is populated about your organization, the LEA Flat File will be ready for submission.
Please see the CRDC FAQ for information regarding the Equivalency Exam Program prior to filling in this option.
Only if the following Information is different or unique to that of the School Site will you update this area.
If ANY of information doesn't change, then leave this portion alone and skip to the next step.
During your data setup process, please make sure to SAVE your changes often. Once you have set this page up, the data will remain held until you change it.
Elementary Schools do not need to fill in this section, unless they have a course catalog similar to secondary.
Courses is where you align the appropriate courses to each area.
- This set of multi-select boxes will allow you to search by at least 1 character for the appropriate courses that fall within each subject matter.
- We suggest working with whomever manages your course catalog to make sure that all courses that were taught in the submission year are added to the correct subject matter area.
Civil Rights Data Collection is also an area also located on Course Details. However the two are not connected. For available prebuilt reports and custom reporting, continue to record courses as appropriate with CRDC Details.
Available selections are typically created and stored within User Management under Credentials. Feel free to visit User Management FAQ to add or manage necessary fields.
Teacher Credentials
- Selections available pull from User Management
- Need assistance to mass import successfully? Visit http://www.illuminateed.com/State_Export_Formats/User_Credentials_Import_spec.xls
- Once file is populated, send to help@illuminateed.com as a database update and CC your Implementation Manager
Check out the CRDC FAQ for more information.
Behavior Consequences as created in your Code Managmeent will be available here. Map your consequences values as appropriate. The scope selector is designed to look at the specific code table that the data is drawing from.
Behavior Bullying Categories are coming from your Behavior Motivations. Visit Code Management to manage your current selections.
Behavior Violations are coming from your Behavior Violations. Visit Code Management to manage your current selections.
Graduation Status refers to the exit codes that are applied on the student demographics page (below). Which exit codes are being used is dependent on the organization.
This is why you temporarily changed the District NCES ID Number.
Now that the data setup has been placed, it is time to prepare and create the LEA Extract required for submission.
You are creating a .csv file to be uploaded to the OCR, please do not open this file prior to submitting it. Opening a .csv file in the wrong program can cause the data quality to change, which will make the data that much harder to upload. If this does happen, please just regenerate the file and submit as you normally would.
- Site will default to the organization name you placed a NCES ID number. There should only be one available in this menu.
- Academic year will default to the current submission window.
- Start Date needs to be set to the organization's start date for the 2015 2016 school year.
- End Date needs ot be set to the organization's end date for the 2015- 2016 school year.
- Fall Snapshot Date is suggested to be 10/01/2015. While the organization can choose their fall snapshot date, this is Illuminate's recommended practice. Please see the CRDC FAQ for further explanation on Snapshot Days.
- Sections allows you to select to create one section using the scope selector, or all of the sections at one time. To remove a section simply click on the “x,” to add the section back in simply click on the box and the available sections will reappear as dropdowns. Select the section you’d like to return to the scope selector and submit when ready to generate the file.
- Submit will create the file and download in your devices downloads.
Only sites with a NCES ID number populated, will appear on the dropdown.
Now that the LEA Extract is complete and ready, it is time to create the School Extract.
- Select the Site(s) to run this extract for within your organization that is required to report data.
- Academic year will default to the current submission window.
- Start Date needs to be set to the organization's start date for the 2015 2016 school year.
- End Date needs to be set to the organization's end date for the 2015- 2016 school year.
- Fall Snapshot Date is to be set to 10/01/2015; some sections of the school file will calculate based on either the full year, or Fall Snapshot Date.
- Spring Snapshot Date is to be set to 03/01/2016; some sections of the school file will calculate based on either the full year, Fall Snapshot Date or Spring Snapshot Date.
- Sections allows you to select to create one section, or all of the sections at one time. To remove a section simply click on the “x,” to add the section back in simply click on the box and the available sections will reappear as dropdowns. Select the section you’d like to return to the scope selector and submit when ready to generate the file. Unsupported Elements can be found on the CRDC FAQ
- Select Submit for each School Extract or site file you are creating, which will download into your devices downloads.
Lather, Rinse, Repeat
Now that you have completed the first (or your only) school site, if there are additional LEA's, you will repeat steps 1-5 for each organization.
Next Steps
Great work! You did it!
Take a look at our Civil Rights Data Collection FAQ!