200 likes | 303 Views
Teacher Student Data Link. http://ge.dsisd.net/GenEd/SchoolImprovement/TSDL.htm. Definitions:. CEPI Center for Educational Performance and Information MSDS Michigan Student Data System Data reporting system used by CEPI to collect student level data
E N D
Teacher Student Data Link http://ge.dsisd.net/GenEd/SchoolImprovement/TSDL.htm
Definitions: • CEPI • Center for Educational Performance and Information • MSDS • Michigan Student Data System • Data reporting system used by CEPI to collect student level data • Several collections during year, TSDL is just one • REP • Registry of Educational Personnel • Another collection system used by CEPI to collect information on school employees • Teacher of record • Certified teacher responsible for the instruction the student received and providing the grade • May not be District employee • Can report up to 3 per student/course
Definitions: • NCES • National Center for Educational Statistics • Part of US Department of Education • Produced lists of common course codes – SCED • School Codes for the Exchange of Data • Secondary and prior-to-secondary versions • Schema • List of data fields (characteristics) in a data file & what rules each characteristic must follow • Data rules • Business rules • XML • Extensible Markup Language • Very flexible format for transferring data files • Difficult to display compared to flat files • Particular data fields can be present, absent, or present many times
TSDL Student Course ComponentData Characteristics • Subject Area Code (from SCED) • Course Identifier Code (from SCED) • Local Course ID • Local Course Title • Local Course Section ID • Course Type • Academic Year • Credits Granted • Course Grade (grade student received in class, not student’s grade level) • Completion Status • PIC (from REP) • Virtual Delivery • Mentor Teacher Some of these data elements may or may not be required for your building and/or grade levels These are NOT the actual field names
Important Codes Student ID Teacher ID • UIC (Unique ID Code) • From MSDS • PIC (Personnel ID Code) • From REP • SCED (School Code for Exchange of Data) • Z:\TSDL\Assignment Code Crosswalk.xlsx • Z:\TSDL\CTE Assignment Code Crosswalk.xlsx • Z:\TSDL\REP_crosswalk_346317_7.xlsx Course ID
SCED Code Structure Subject Area Code (2-digits) Course Code (3-digits) Secondary 04 151 = 04151 Social Sciences U.S. Govt.and History Comprehensive 52 031 = 52031 Mathematics Grade 1 Prior-to-Secondary
Prior-to-SecondaryOne grade-various subjects 73 033 = 73033 Non-subject Grade 3 Specific
Comprehensive Course Code StructureU.S. Government 04 151 H 1.00 1 1 Social US Govt. Honors One 1 of 1 Sciences Comprehensive CreditHistory 04 151 G 0.05 1 2 Social US Govt. General One-half 1 of 2 Sciences Comprehensive Regular CreditHistory Available credit Course Description Course Level Sequence
PowerSchool State Reporting New releases provided regularly to meet state reporting requirements.
XML Notepad TSDL Schematic
WARNING! • Error free is not the same as accurate! • Pay attention to the reports for errors, know reasons for discrepancies • Be ready to defend your report • DON’T WAIT!!
Remember http://ge.dsisd.net/GenEd/SchoolImprovement/TSDL.htm Tammy Hereau Data Technology Consultant Delta Schoolcraft ISD 906-786-9300 ext. 115 906-280-5977