Overview
The Teacher Student Data Link (TSDL) Snapshot combines the course instructor and course enrollment TSDL interchange files in each course instructed during the reported school year. The link shows the instructional relationship between educators and the students that are in their classrooms. The data can be used to inform LEAs to inform course participation patterns, help improve Educator Effectiveness, and advise on the effectiveness of educator preparation programs.
2018-2019:
The 2018-19 Teacher Student Data Link is open and available for reporting data for districts with migrant students. All other districts are also able to report TSDL data, however it is not required. To clarify, all districts do not need to submit the course instructor file. For districts with migrant students: 1) local courses codes must be mapped, 2) course enrollment file must be uploaded for any 8th-12th grade migrant student receiving partial or full credit and 3) the snapshot must be created and finalized for migrant students. For districts without migrant students: 1) local courses codes do not need to be mapped, 2) No TSDL data file is required to be uploaded and 3) the snapshot does not need to be created or finalized.
2019-2020:
The 2019-20 Teacher Student Data Link will open in fall 2019 for the 2019-2020 school year reporting period. Beginning in 2019-2020, all districts are required to report TSDL data for students in grades 6 – 12 only. To clarify, all districts need to participate in the TSDL collection in school year 2019-2020 and must include both non-migrant and migrant students who are enrolled in grades 6 – 12. Please be aware that the collection is still able to accommodate data submitted for students in grades K – 5 for those districts finding it easier to submit data for all students than to restrict the data to middle and high school students, but it is not a requirement to submit data for K – 5 students due to a legislative change in 2018 (please see H.B. 18-1379).
Deadlines
- The 2018-19 Teacher Student Data Link Snapshot Soft Deadline Date: August 30, 2019
- 2018-2019 Teacher Student Data Link Timeline (updated 02/05/2019)
File Layouts and Definitions
2018-2019
- 2018-2019 Course Enrollment File Layout and Definitions (PDF) (posted 03/19/2018)
- 2018-2019 Course Instructor File Layout and Definitions (PDF) (posted 03/19/2018)
2019-2020
- 2019-2020 Course Enrollment File Layout and Definitions (PDF) (updated 05/20/2019)
- 2019-2020 Course Instructor File Layout and Definitions (PDF) (updated 05/20/2019)
Business Rules
- 2018-2019 Business Rules Course Enrollment (posted 01/24/2019)
- 2018-2019 Business Rules Course Instructor (posted 01/24/2019)
Template
- 2018-2019 Course Enrollment File (XLS) (posted 01/24/2019)
- 2018-2019 Course Instructor File (XLS) (posted 01/24/2019)
Training
- 2018-19 TSDL Training (PPTX) (posted 03/06/2019)
- 2017-18 Overall Training (PPTX) (posted 03/06/2019)
Additional Resources
- Email from Commissioner Anthes (PDF) (posted 02/05/2019)
- TSDL Snapshot Cognos Reports (06/20/2018)
- Teacher Student Data Link Authority (PDF) (11/4/2015)
- Process and Checklist of Steps (updated 8/10/2016)
- Migrant Regional Directory (PDF) (1/25/2017)
- 2017-2018 TSDL Summary of Updates (posted 03/23/2017)
Contact: Annette Severson at severson_a@cde.state.co.us
