1 / 30

Webcast outline

demetria-orr
Download Presentation

Webcast outline

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Civil Rights Data Collection (CRDC) Data SupportWebcast date: September 24, 2012Information valid until: November 3, 2012Wisconsin Department of Public InstructionWebcast Presenters:Jennifer Wegner, Civil Rights Compliance CoordinatorMelanie McCalmont, Data Support Technical ManagerKen Syke, IT Communications Coordinator

  2. Webcast outline 1. Federal CRDC Survey • What is the collection? • Focus for SY2011-12 2. DPI Data Support Project • What data support will DPI provide? • Shared responsibilities 3. September-October Steps to Do • Review materials and data matrix • Gather local data 4. November-December Steps to Do • Receive DPI files • Complete the survey

  3. What is the CRDC? Federal CRDC survey Sept-Oct Steps to Do Nov-Dec Steps to Do DPI Data Support What is the Civil Rights Data Collection? The purpose of the U.S. Department of Education (ED) Civil Rights Data Collection (CRDC) is to obtain data about how well the nation's public school districts and their schools are doing in fulfilling their obligation to provide equal educational opportunity.

  4. What is the CRDC survey? Federal CRDC survey Sept-Oct Steps to Do Nov-Dec Steps to Do DPI Data Support Civil Rights Data Collection (CRDC) Survey history The Dept of Education’s Office of Civil Rights (OCR) began collecting the CRDC in 1968. It’s authorized under the Civil Rights Act of 1964, Title IX gender equity, Section 504 for disabilities, and other statutes. States and districts that receive federal funding have a legal obligation to provide data for the survey. The regulations implementing these provisions can be found at 34 CFR 100.6(b); 34 CFR 106.71; and 34 CFR 104.61.

  5. CRDC final database Federal CRDC survey Sept-Oct Steps to Do Nov-Dec Steps to Do DPI Data Support ocrdata.ed.gov Includes data for survey years: 2000, 2004, 2006, and 2009

  6. the CRDC focus this year Federal CRDC survey Sept-Oct Steps to Do Nov-Dec Steps to Do DPI Data Support Focus for SY 2011-12 data survey Equity between racial/ethnic groups Equity in college readiness Equity in career readiness Equity between districts and between states

  7. Data Support Project Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do Project summary • DPI will supply partial survey data to districts (approx 60% of questions) • Data will come from your existing collections (ISES, Coursework, Staff, Directory) • Data will be delivered in 4 files • LEA must collect remaining data • LEA uploads 8 data files to survey • LEA must check all data cells

  8. Data collection this year Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do 4 parts of 2011-12 CRDC Survey LEA Part 1 form SCH Part 1 form LEA Part 2 form SCH Part 2 form • USE FALL 2011 DATA Enrollment and placement data Cumulative and year-end data

  9. CRDC terminology Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do Terminology we will use DPI data • Questions marked YES on Data Support Matrix Local data • Questions marked NO on Data Support Matrix Web interface • Online CRDC survey forms • Use for file uploads and screen typing Pre-collection tools • Online CRDC data collection templates (Excel) • Use for gathering local district data

  10. Data Sources Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do What data will be used? • ISES Third Friday • ISES Child Count • ISES Discipline • ISES Year End (key date Oct 28) • Coursework Completion • School Directory • Fall Staff Report Pull from ISES YE will use Oct 28 key date, please make sure your ISES coordinator is aware

  11. Data Support Matrix Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do Data Matrix shows by survey question what DPI will send and what districts must collect

  12. Data Support disclaimers Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do Disclaimers • Responsibilities: DPI can only provide partial survey data. LEA provides remainder. In the survey web interface, the CRDC help desk should be consulted for all survey assistance. • Delivery: The data DPI provides is only as good as the quality of your ISES and Coursework collections. We cannot revise the data files we send to you. • Quality checks: LEAs are the final authority of quality data. Check all the survey answers to make sure the data is correct. You can always overwrite DPI numbers sent to you. • Use of data: The DPI data files should not be used for any other purpose. • Full list of disclaimers is on the project homepage

  13. Key websites Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do How to get survey help Help with DPI data files • Melanie McCalmont (608) 267-9162 • DPI project homepage • dpi.wi.gov/ lbstat/ crdc-support.html Help with pre-collection tools and web interface • CRDC help desk 1-855-320-6459 • crdc.ed.gov

  14. Sept-Oct Step 1 Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do Step 1 to get ready for the survey • DISTRICT: Submit ISES YE on time • The DPI data files depend on locked collections in ISES YE (year end) on Oct 28 key date. • All other data is already finished for 2011-12.

  15. Sept-Oct Step 2 Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do Step 2 to get ready for the survey • DPI: Download the Data Support Matrix • Go to project website • Download the Data Support Matrix • Shows survey question number and table • DPI will provide data? See column C (YES/NO) • WATCH FOR questions that are PARTLY answered by DPIand PARTLY answered by district

  16. Sept-Oct Step 2 Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do Districts must collect data in pre-collection tools that DPI will not provide (DPI = NO)

  17. Sept-Oct Step 2 Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do Complete survey will show answers from both sources Local districts will create 4 partial data files DPI will send 4 partial data files to districts in early November

  18. Sept-Oct Step 3 Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do Step 3 to get ready for the survey • FEDS: Download the Excel pre-collection tool • Go through the CRDC website crdc.ed.gov • Download the 02 pre-collection tool Excel folder • Read the Table Layouts (PDF of survey questions) • Compare to DPI Data Matrix • Fill out the Excel templates

  19. Sept-Oct Step 3 Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do Pre-collection tool contains 4 spreadsheets for the 4 survey parts Review training modules

  20. Sept-Oct Step 2 Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do Table Layouts .pdf in the pre-collection folder show question numbers and table names These match the Data Matrix A complete set of gender & race data is called a TABLE

  21. Sept-Oct Step 3 Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do Excel pre-collection tool blank FILL If data matrix shows that DPI will provide the data, district must leave cell BLANK

  22. Sept-Oct Step 3 Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do Excel pre-collection tool Blank, DPI does table 3,4,5,6 Fill, District does table 1,2,7,8,9 DPI blanks apply to TABLES and to single question sub-parts

  23. Sept-Oct Step 3 Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do Excel pre-collection tool • The Excel sheets have skip logic that will turn some cells red so that you SKIP them (like a branching survey) • WATCH OUT • SCH-0031 is missing • SCH-0032 is stuck in the middle of 34 and 35

  24. Sept-Oct Step 3 Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do Excel pre-collection tool Each school is entered in a separate column

  25. Sept-Oct Step 3 Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do 55 LEAidform name5 version • 5506600LEA1STATE01.csv 5506600LEA2STATE01.csv • 5506600SCH1STATE01.csv • 5506600SCH2STATE01.csv • 5506600LEA1MAPLE01.csv • 5506600LEA2MAPLE01.csv • 5506600SCH1MAPLE01.csv • 5506600SCH2MAPLE01.csv CRDC Survey 8 total files DPI data file Local data

  26. Sept-Oct Step 4 Federal CRDC survey DPI Data Support Sept-Oct Steps to Do Nov-Dec Steps to Do Step 4 to get ready for the survey • WAIT for 4 DPI files to arrive • Keep your 4 local .csv files • Wait for 4 DPI .csv files in early November • LEAs can upload their 4 files but error checks will NOT run properly (needs SCH-0005 data found in DPI file) • Live webinar on file submittal in early November

  27. Next steps in November Federal CRDC survey Sept-Oct Steps to Do Nov-Dec Steps to Do DPI Data Support BASIC STEPS in the web interface • Login at crdc.ed.gov • Upload DPI files • Best to do DPI files first • Upload LEA files • Files process overnight • Web – Fill in any blanks • Web – Run error checks (xls error reports) • Web – Make corrections • Certify survey, and print copies

  28. Web interface potential issues Federal CRDC survey Sept-Oct Steps to Do Nov-Dec Steps to Do DPI Data Support When in the survey web interface, here’s some tips to avoid data corruption or wasted time • Do not use ENTER key • Only one user at a time in app • “Refresh the page” frequently • Do not double-click buttons • Run error checks AFTER the DPI files are uploaded • Always phone CRDC for help

  29. How to get help How to get survey help Help with DPI data files • Melanie McCalmont (608) 267-9162 • DPI project homepage • dpi.wi.gov/ lbstat/ crdc-support.html Help with pre-collection tools and web interface • CRDC help desk 1-855-320-6459 • crdc.ed.gov

  30. Civil Rights Data Collection (CRDC) Data SupportWebcast date: September 24, 2012Information valid until: November 3, 2012Wisconsin Department of Public InstructionWebcast Presenters:Jennifer Wegner, Civil Rights Compliance CoordinatorMelanie McCalmont, Data Support Technical ManagerKen Syke, IT Communications Coordinator

More Related