2010-11 MPS Corrective Action Requirements - PowerPoint by hTb9vBH

VIEWS: 0 PAGES: 30

									Civil Rights Data Collection
       (CRDC) Data Support
                     Webcast date:      September 24, 2012
             Information valid until:     November 3, 2012
    Wisconsin Department of Public Instruction

                                          Webcast Presenters:
           Jennifer Wegner, Civil Rights Compliance Coordinator
            Melanie McCalmont, Data Support Technical Manager
                      Ken Syke, IT Communications Coordinator
                                        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
                                         What is the CRDC?
Federal CRDC survey   DPI Data Support     Sept-Oct Steps to Do   Nov-Dec Steps to Do



 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.
                                             What is the CRDC survey?
Federal CRDC survey                       DPI Data Support                    Sept-Oct Steps to Do           Nov-Dec Steps to Do



  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.
                                         CRDC final database
Federal CRDC survey   DPI Data Support     Sept-Oct Steps to Do      Nov-Dec Steps to Do




                                                              ocrdata.ed.gov

                                                              Includes data for survey
                                                              years:

                                                              2000, 2004, 2006, and
                                                              2009
                              the CRDC focus this year
Federal CRDC survey     DPI Data Support    Sept-Oct Steps to Do   Nov-Dec Steps to Do




      Focus for SY 2011-12 data survey

                  Equity in           Equity in            Equity
                  college             career               between
                                                           racial/ethnic
                  readiness           readiness
                                                           groups




                                    Equity between
                                    districts and
                                    between states
                                         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
                                  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
                             Enrollment and placement data
      SCH Part 1 form

      LEA Part 2 form
                              Cumulative and year-end data
      SCH Part 2 form




      • USE FALL 2011 DATA
                                          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
                                                     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
                                         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
                             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
                                                          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
                                                     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
       1. 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.
                                                     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

       2. 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 DPI
                      and PARTLY answered by district
                                               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)
                                                     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
         DPI   DPI    LEA   LEA    LEA
                                               4 partial data files
         DPI   DPI    DPI    DPI   DPI

         LEA   LEA    LEA    DPI   LEA
                                               DPI will send 4 partial
                                               data files to districts in
         DPI   DPI    DPI    DPI   DPI         early November
         DPI   LEA    DPI   LEA    LEA
                                                      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

       3. 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
                                               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
                                               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
                        A complete set
                        of gender &                    Data Matrix
                        race data is
                        called a TABLE
                                                    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
                                                    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
                                                        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
                                                        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
                                                 Sept-Oct Step 3
Federal CRDC survey   DPI Data Support     Sept-Oct Steps to Do      Nov-Dec Steps to Do


                              55 LEAid form name5 version


     5506600LEA1STATE01.csv        5506600LEA1MAPLE01.csv
     5506600LEA2STATE01.csv        5506600LEA2MAPLE01.csv

     5506600SCH1STATE01.csv        5506600SCH1MAPLE01.csv
     5506600SCH2STATE01.csv        5506600SCH2MAPLE01.csv




      DPI data file                      Local data                    CRDC
                                                                      Survey
                                                                  8 total files
                                                      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

       4. 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
                                       Next steps in November
Federal CRDC survey           DPI Data Support     Sept-Oct Steps to Do   Nov-Dec Steps to Do




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



     When in the survey web interface, here’s some
      tips to avoid data corruption or wasted time

         1.   Do not use ENTER key
         2.   Only one user at a time in app
         3.   “Refresh the page” frequently
         4.   Do not double-click buttons
         5.   Run error checks AFTER the DPI files are uploaded
         6.   Always phone CRDC for help
                                       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
Civil Rights Data Collection
       (CRDC) Data Support
                     Webcast date:      September 24, 2012
             Information valid until:     November 3, 2012
    Wisconsin Department of Public Instruction

                                          Webcast Presenters:
           Jennifer Wegner, Civil Rights Compliance Coordinator
            Melanie McCalmont, Data Support Technical Manager
                      Ken Syke, IT Communications Coordinator

								
To top