cde Automated Data Exchange Documentation
***************************************************

General
ACCESS for ELLs SBD - (Pipeline)
Financial - (Pipeline)
Human Resource - (Pipeline)
Student October - (Pipeline)
Report Card March Collection - (Pipeline)
Record Integration Tracking System - (Pipeline)
Educator Identifier System (EDIS) - (Pipeline)
Safety & Discipline Indicator Collection
Student Biographical Data for TCAP - (Pipeline)
Student Biographical Data for ACT - (Pipeline)
11th Grade Alternate Assessment
Directory - (Pipeline)
Pre-coded Labels
Student End of Year
READ
Mathematics and Science Partnerships
Special Education December Count - (Pipeline)
Special Education End Of Year
Special Education Discipline



GENERAL
Document Last
Updated
Collection Calendar for Automated Data Exchange

2011-12 Student ADE Collection Dates

Dec  17, 2012

Sep 22, 2011

Downloading and Installing Netscape Navigator Jan 3, 2000
Connecting to the Colorado Department of Education Nov 28, 2001
Logging In to the Automated Data Exchange
The User Authorization Error Screen
Nov 15, 1996
Nov 15, 1996
The Automated Data Exchange Main Menu
Sample Main Menu: Expecting Initial File Submission
Sample Main Menu: After a File has Failed Edit Checks
Sample Main Menu: After a File has Passed Edit Checks
Sample Main Menu: After a File has Been Rejected
Sample Main Menu: After a File has Been Approved
Nov 15, 1996
May 13, 1998
May 13, 1998
May 13, 1998
May 13, 1998
May 13, 1998
Downloading or Viewing Reports May 13, 1998
Approve or Reject Data
The Reject Data Screen
The Approve Data Screen
May 13, 1998
Nov 15, 1996
Nov 15, 1996
The Program Failure Screen Nov 15, 1996

Appendix A - District/BOCES Codes
Appendix A.1 - School Building Codes
Appendix A.2 - Districts with Boundaries that Cross Multiple Counties
Appendix A.3 - State Codes
Appendix A.4 - County Codes
Appendix A.5 - Facilities and State Operated Programs

Appendix A.5.1 - Contacts for Facilities and State Operated Programs
Appendix A.6 - Institution of Higher Education Codes

Appendix A.7 - Detention Center Codes

Appendix A.8.1 - Language Codes (Excel File)

Appendix A.8.2 - Deactivated Language Codes (Excel File)

Appendix A.9 - ACT School Codes/CDE District and School Codes

Appendix A.10 - Administrative Unit Codes

Appendix A.11 - Non-Public School Codes

Appendix A.12 - Head Start/Public Agency Codes

Appendix A.13 - Country Codes

(Pipeline)
(Pipeline)
(Pipeline)
(Pipeline)
(Pipeline)
(Pipeline)

(Pipeline)
Oct 25, 2011

(Pipeline)

(Pipeline)

(Pipeline)

Jun  18, 2013

(Pipeline)

(Pipeline)

(Pipeline)

(Pipeline)

Appendix B - File Layouts and Edit Specifications Aug 10, 2001
Appendix C - Report Definitions and Samples Oct 29, 1999
Appendix D - E-Mail Notification Definitions and Samples Apr 24, 2000
Appendix E - Database Structure and Process Flow Nov 15, 1996

 

ACCESS for ELLs SBD
 
Document Last
Updated
ACCESS for ELLs SBD Data Collection Overview Feb 11, 2013
Step-by-step process for submitting a data file to CDE (text format only).
Uploading a ACCESS for ELLs SBD Data File to CDE (with screen display)
Feb 08, 2008
Feb 11, 2013
ACCESS for ELLs SBD Excel Header Template - Save by right clicking and selecting 'save target as' Mar 19, 2013
ACCESS for ELLs SBD Respondent Information Form - Used to request a username and password. Mar 11, 2013
ACCESS for ELLs SBD - File Layout and Edit Specifications Jan 30, 2013
ACCESS for ELLs SBD - Edits, Errors and Warnings Mar 11, 2013
ACCESS for ELLs SBD - User's Guide Feb 20, 2007

 

FINANCIAL
Document Last
Updated
Financial December Data Collection Overview
Sep 30, 2010
Submitting a Data File to CDE for Financial Data Collection
The Upload Statistics Screen for Financial Data Collection
The File Upload Failed Screen for Financial Data Collection
May 13, 1998
May 13, 1998
May 13, 1998
2011-2012 Financial December - File Layout and Edit Specifications July 30, 2012

 

HUMAN RESOURCE
Document Last
Updated
Human Resource December Data Collection Overview
Oct 2, 1997
Submitting a Data File to CDE for Human Resource Data Collection
The Upload Statistics Screen for Human Resource Data Collection
The File Upload Failed Screen for Human Resource Data Collection
Oct 6, 1998
May 13, 1998
Oct 6, 1998
Human Resource December - File Layouts and Specifications 2011-12

Human Resource December - File Layouts and Specifications 2012-13

Apr 6, 2011

Mar 29, 2012

Appendix F - Human Resource Data Elements and Definition 2011-12

Appendix F - Human Resource Data Elements and Definition 2012-13

Detail Job Classification Descriptions 2011-12
 
Detail Job Classification Descriptions 2012-13

 

Jul 18, 2011

Mar 29, 2012

Jul 18, 2011

Oct 8, 2012
 
 
Appendix G - Creating a Human Resource Data File for Submission to CDE
Using Microsoft Excel
Using Microsoft Access
Jun 17, 1998
Apr 6, 2011
Dec 1, 2003

 

STUDENT OCTOBER
Document Last
Updated
Student October  Data Collection Overview
Sept 4, 2003
Submitting a Data File to CDE for Student October Data Collection
The Upload Statistics Screen for Student October Data Collection
The File Upload Failed Screen for Student October Data Collection
Sept 4, 2003
Sept 4, 2003
Sept 4, 2003
Student October File Layout and Specifications 2012-13
Student October Data Elements and Definitions 2012-13
Student October Summary of Changes 2012-13
Non-Public School Codes
Head Start/Public Agency Codes
Country Codes
Student October district summary report logic

Valid Code Combinations 2012-13

Jul 17, 2012
Oct 9, 2012
Jul 16, 2012
(Pipeline)
(Pipeline)
(Pipeline)
Oct 29, 2012

 

Oct 31, 2012

Creating a Student October Data File using Excel
Excel File Layout Example for 2012-13
Directions for Using the File Layout Example
 
Sept 15, 2010
Sept 15, 2010

 

REPORT CARD - MARCH
Document Last
Updated
Creating the Data File:
Report Card March Template User Guide - please read this first!
Excel Template - Save by right clicking and selecting 'save target as'


Mar 16, 2011
Feb 13, 2013

Using the ADE File Submission Process:
Submitting a Data File (Document)
The Upload Statistics Screen (Document)
The File Upload Failed Screen (Document)
Report Card March - File Layout 2011-2012 (Document)
Report Card March - Data Elements and Definitions 2011-2012 (Document)

          ReportCard March - File Laymarchtemplate1marout 2012-2013 (Document)
          Report Card March - Data Elements and Definitions 2012-2013 (Document)

Apr 14, 2008
Apr 14, 2008
Apr 14, 2008
Apr 1, 2011
Apr 12, 2011

(Pipeline)
(Pipeline) 

 

 

SAFETY & DISCIPLINE INDICATOR
Document Last
Updated
System Requirements and Important Information
May 1, 2004
Creating the Data File:
Safety & Discipline Indicator Excel Template User Guide
Excel Template - Available upon request via email: severson_a@cde.state.co.us

Mar 10, 2009
May 09, 2012
Using the ADE File Submission Process:
Submitting a Data File
The Upload Statistics Screen
The Upload Failed Screen
Safe School Choice Policy, Procedures and Definitions.
File Layouts and Edit Specifications 2012-2013
File Layout Field Definitions for 2012-2013
File Layouts and Edit Specifications 2013-2014
File Layout Field Definitions for 2013-2014

Apr 30, 2008
Apr 30, 2008
Apr 30, 2008
Apr 24, 2008
May 22, 2013
Sep 11, 2012
May 22, 2013
Mar 27, 2013

 

STUDENT BIOGRAPHICAL DATA FOR TCAP
Document Last
Updated
Student Biographical Data - An Overview
April 21, 2008
File Layout and Field Definitions for 2012-2013 - Changes from the 2011-2012 collection are highlighted in yellow. Apr 29, 2013
Edits, Errors and Warnings for 2012-2013 Mar 7, 2013
File Layout Headers (Excel format) for 2012-2013 Mar 7, 2013
Using Microsoft Excel to work with the text SBD file from CDE April 21, 2008
Using Microsoft Excel to work with the csv SBD file from CDE April 21, 2008
Using the Automated Data Exchange to Examine Student Biographical Data April 21, 2008
Student Biographical Data - Respondent Information Form April 21, 2008

 

STUDENT BIOGRAPHICAL DATA FOR ACT
Document Last
Updated
ACT Student Biographical Data - An Overview
Jun 17, 2013
ACT Student Biographical Data - File Layout and Field Definitions Jun 11, 2013
ACT Student Biographical Data - Edits, Errors and Warnings Jun 11, 2013
ACT Student Biographical Data - File Layout Headers (Excel format) Jul 5, 2012
Using Microsoft Excel to work with the text ACT SBD file from CDE Jun 20, 2007
Using Microsoft Excel to work with the csv ACT SBD file from CDE Jun 20, 2007
Using the Automated Data Exchange to Examine ACT Student Biographical Data Jun 20, 2007
ACT Student Biographical Data - Respondent Information Form Mar 3, 2010
ACT School Codes/CDE District and School Codes Jun 18, 2013

 

 11th Grade Alternate Assessment
Document Last
Updated
11th Grade Alternate Assessment - Respondent Information Form Apr 11, 2012
Instructions for DACs Apr 25, 2013
11th Grade Alternate Assessment - RELEASE File Layout and Field Definitions Apr 11, 2012

 

DIRECTORY
Document Last
Updated
Directory User Guide
Apr 3, 2012

 

PRE-CODED LABELS
Document Last
Updated

General Information

Pre-coded Labels Overview

Information about the Pre-Coded Labels Collection

Pre-coded Labels -- Respondent Information Form

Nov. 10, 2003
Nov. 10, 2003
Nov. 13, 2006

Using the ADE File Submission Process

Submitting a Data File to CDE for Pre-Coded Labels Collection

The Upload Statistics Screen for Pre-Coded Labels

The File Upload Failed Screen for Pre-Coded Labels


Nov. 10, 2003
Nov. 10, 2003
Nov. 13, 2006

Creating a Data File

Pre-coded Labels - File Layout and Field Definitions

Pre-coded Labels/ELL Errors

Using Microsoft Excel
Using Microsoft Access

 
Nov.21, 2012
Nov.21, 2012
Nov. 4, 2008
Nov. 4, 2008

 

STUDENT END OF YEAR
Document Last
Updated
2012-2013 Student End of Year Data Elements and Definitions - Changes from the 11-12 collection are highlighted in yellow. Feb 20, 2013
2012-2013 Student End of Year Edit Specifications May 6, 2013
Creating the Data File:

Excel Template User Guide - please read this first!

2012-2013 Excel Template - Save by right clicking and selecting 'save target as'  

 

 

Apr 22, 2013

Apr 22, 2013

 

 

 

READ
Document Last
Updated
READ Respondent Information Form Mar 26, 2013
2012-2013 READ Edit Specifications June 10, 2013
2012-2013 READ Data Elements and Definitions June 10, 2013
Creating the Data File:

Excel Template User Guide - please read this first!   

2012-2013 Excel Template - Save by right clicking and selecting 'save target as'  

 

Mar 21, 2013

May 6, 2013

 

 

Mathematics and Science Partnerships System
Document Last
Updated
Data Collection Overview
Dec. 13, 2005
Data Collection User Guide
Nov. 02, 2006
Using the ADE File Submission Process:
Submitting a Data File (Document)
The Upload Statistics Screen (Document)
The File Upload Failed Screen (Document)
Mathematics and Science Partnerships - File Layout (Document)
Mathematics and Science Partnerships - Data Elements and Definitions (Document)

Nov. 02, 2006
Nov. 02, 2006
Nov. 02, 2006
Feb. 27, 2013
Mar. 04, 2013


SPECIAL EDUCATION DECEMBER COUNT
Document Original Post
Date
Last
Updated
STUDENT
Special Education December Student Data Elements and Definitions (2011-2012)
Special Education December Student Data Elements and Definitions (2012-2013)
Special Education December Student File Layouts and Edits (2012)
Special Education December Student Summary of Changes (2012-2013)
Special Education December Student Template (Under 5000 Students)
Special Education December Student Template (Greater than 5000 Students)
Special Education December Student Allowable Setting Codes for Eligible Facilities
Special Education December Student Educational
Environment Code Definitions

Special Education December Educational Orphans
Special Education December 2012 Pupils Attendance Information
December Count Student Grade Level Codes and Edits

Apr 1, 2011
Mar 30, 2012
Nov 1, 2012
Mar 30, 2012
Dec 3, 2010
Dec 3, 2010
Dec 29, 2010
Nov 1, 2012
Dec 9, 2010
Dec 1, 2010
Nov 5, 2010
Jan 18, 2012

Apr 1, 2011
Nov 1, 2012
Dec 11, 2012
Mar 30, 2012
Oct 30, 2012
Nov 14, 2012
Oct 24, 2012

Oct 24, 2012
Nov 20, 2012
Oct 24, 2012
Jan 18, 2012
STAFF
Special Education December Staff Data Elements and Definitions (2011-2012)
Special Education December Staff Data Elements and Definitions (2012-2013)
Special Education December Staff File Layouts and Edits (2012)
Special Education December Staff Summary of Changes (2012-2013)
Special Education December Staff Template
Special Education December 2012 Job Class Codes
Special Education December 2012 Grant Codes Sorted by Name
Special Education December 2012 Grant Codes Sorted by Code

Apr 1, 2011
Mar 30, 2012
Nov 1, 2012
Mar 30, 2012
Dec 3, 2010
Nov 5, 2010
Nov 12, 2010
Nov 12, 2010

May 12, 2011
Nov 1, 2012
Nov 1, 2012
Dec 29, 2011
Oct 30, 2012
Oct 24, 2012
Oct 24, 2012
Oct 24, 2012
Special Education December Counts 2012-2013 Timeline
Non-Public School Codes
Head Start/Public Agency Codes
Special Education December 2012 Respondent Information Form
Administrative Unit and District Codes
Special Education December 2012 Exception Request
SPED December Count Template Training (2011)
SPED December Count Training Presentation (2012)
Statutory Changes to Disability Categories Information
Guidance Parentally Placed Private School
Oct 8, 2012
Aug 1, 2013
Aug 1, 2013
May 13, 2010
Dec 10, 2010
Nov 8, 2011
Dec 29, 2011
Dec 4, 2012
Jun 22, 2012
Dec 5, 2012
Dec 14, 2012
Aug 1, 2013
Aug 1, 2013
Oct 26, 2012
Oct 12, 2011
Dec 12, 2012

Dec 4, 2012
Jun 22, 2012
Dec 5, 2012

 

SPECIAL EDUCATION END OF YEAR
Document Original Post
Date
Last
Updated
Documents and Instructions:

Special Education EOY File Layout & Edits (2012-2013)
Special Education EOY Student Data Elements & Definitions (2011-2012)
Special Education EOY Student Data Elements & Definitions (2012-2013)
Special Education EOY Summary of Changes (2011-2012)
Special Education EOY Summary of Changes (2012-2013)

Apr 8, 2013
Apr 1, 2011
Mar 29, 2012
Mar 29, 2012
Mar 29, 2012

May 16, 2013
Feb 1, 2012
May 16, 2013
Mar 29, 2012
Mar 29, 2012
Templates:
Special Education EOY - Template - Up to 5000 Records (2012-2013)
Special Education EOY - Template - Over 5000 Records (2012-2013)

Apr 8, 2011
Jun 6, 2011

Apr 18, 2013
May 30, 2013
Code Tables and Information:
Special Education EOY Student Administrative Unit & District Codes
Special Education EOY Student Public School Codes
Special Education EOY Student Non-Public School Codes
Special Education EOY Student Head Start/Public Agency Codes
Special Education EOY Student Facility/Detention Center Codes
Special Education EOY Student Code Tables
Special Education EOY Student Respondent Form
Special Education EOY Student Sampling Plan
Special Education EOY Student EIS Fast Facts
Special Education EOY Student IEP Questions and Answers
Special Education EOY Coding Scenarios
Special Education EOY Training Presentation
Special Education EOY Technical Training Presentation (2011-2012)
Special Education EOY Indicator 11 and 12 Webinar Training
Special Education EOY Timeline
Special Education EOY Exception Request
Special Education EOY What Path to Report in Flow Chart
Special Education EOY Student Grade Level Codes and Edits
Special Education EOY Statutory Changes to Disability Categories Information

Apr 15, 2010
Apr 15, 2010
Apr 15, 2010
Apr 15, 2010
Jul 7, 2010
Apr 15, 2010
Apr 15, 2010
Apr 15, 2010
Apr 15, 2010
Apr 15, 2010
Jul 7, 2011
Jun 14, 2011
Jun 6, 2011
Aug 22, 2011
Apr 8, 2011
Mar 3, 2011
Mar 3, 2011
Feb 1, 2012
Jun 8, 2012

Mar 19, 2012
Mar 28, 2013
Mar 28, 2013
Mar 28, 2013
Mar 18, 2013
Mar 15, 2013
Feb 13, 2013
Nov 11, 2011
Apr 15, 2010
Apr 15, 2010
Apr 5, 2013
May 16, 2013
May 31, 2012
Aug 22, 2011
Feb 13, 2013
Feb 4, 2013
Feb 4, 2013
Feb 1, 2012
Mar 28, 2013


SPECIAL EDUCATION DISCIPLINE
Document Original Post
Date
Last
Updated
Documents and Instructions:
Special Education Discipline Data Elements & Definitions (2012-2013)
Special Education Discipline File Layout (2012-2013)
Special Education Discipline Respondent Information Form
Special Education Discipline Timeline

Mar 28, 2012
Apr 11, 2013
May 13, 2010
Mar 29, 2013

Jun 21, 2012
Apr 11, 2013
Mar 6, 2012
May 17, 2013
Templates:
Special Education Discipline Template (2012-2013)
Apr 19, 2013 Jun 12, 2013
Code Tables and Information:
Special Education Discipline Summary of Changes (2012-2013)
Special Education Discipline Administrative Unit & District Codes
Special Education Discipline Public School Codes
Special Education Discipline Non-Public School Codes
Special Education Discipline Head Start/Public Agency Codes
Special Education Discipline Exception Request
Special Education Discipline Webinar Training
Special Education Discipline Reports Webinar Training
Special Education Discipline Grade Level Codes and Edits
Statutory Changes to Disability Categories Information

Mar 28, 2012
Mar 24, 2011
Apr 11, 2013
Apr 11, 2013
Apr 11, 2013
Apr 26, 2011
Apr 30, 2013
Aug 21, 2013
Jan 18, 2012
Jun 22, 2012

Mar 28, 2012
Mar 28, 2012
Apr 11, 2013
Apr 11, 2013
Apr 11, 2013
May 9, 2012
May 1, 2013
Aug 21, 2013
Mar 28, 2012
Mar 28, 2013

 

[ Top ] [ Home ] [ ADE ]

Top | Home | ADE

Automated Data Exchange Documentation - Table of Contents

Last Modified: 08/26/2013
For support or suggestions please contact the administrator at: ademaster@cde.state.co.us