Data Submissions - General Resources

Data Pipeline is a streamlined approach to efficiently move required education information from school districts to the Colorado Department of Education. Data Pipeline reduces data redundancy, captures closer to real-time data, streamlines the data collection process and allows districts to exchange information on transferred students.

Resources for Importing, Reviewing, and Securely Sharing Data
Using Excel for Importing and Reviewing Data (12 minutes): Overview of how to import a .csv file into Excel and keep the proper formatting (PDF) (practice .csv file)
Converting the .csv File to Excel
Securely Sharing Data with CSI (10 minutes): Overview of how to protect personally identifiable information and how to use FileZilla, CSI’s secure file transfer system (PDF)

SIS/Plan Management System Resources
Using your SIS for Reviewing Data

-Infinite Campus users: Please see Campus Community for resources related to Colorado state reporting

-Power School users: Please see PowerSource for resources related to Colorado state reporting
16-17 PowerSchool Common State Reporting Field Screenshots

-Alpine users: (for SPED submissions): Please see CSI/Alpine recorded trainings [look under the SPED EOY submissions link]

2016-2017 Data Submissions Overview Memo (PDF) Updated 02/06/2017
Submissions Timeline (end of the Overview Memo PDF)

General Data Submissions Training Modules
CSI Data Submissions Overview (12 minutes): Overview of the CSI data submissions process, including key process updates for the 16-17 year (PDF)
File Layout and Definition Document Guided Tour (13 minutes): Overview of how to use CDE’s File Layout and Definition Documents to support your work in data submissions (PDF)

Pupil Membership
CSI Running Pupil Membership Counts By Grade

16-17 Spring Regional Meeting Materials
Data Submissions Unit - Improvements Session (Slides)
17-18 State Reporting Prep Session (Slides)
Using Excel for Reviewing Data Session (paper copies of handouts will be available at the meeting) 
    Download practice files
           CSV to Import to Excel_PracticeFile.csv
October Count Audit Work Session (paper copies of CDE slides will be available at the meeting)