Data Pipeline Town Hall March 23 2017 The

Data Pipeline Town Hall March 23, 2017 The goal of the webinar is to provide updates on the Data Pipeline and current and upcoming collections. These webinars also provide a forum for districts, BOCES, and Administrative Units to have questions answered about Data Pipeline. We will begin the webinar shortly Dial in number is 1 -866 -764 -6750 Data Pipeline support email is datapipeline. support@cde. state. co. us 1

Webinar Etiquette • Mute Your Phone (*# Mutes and Un-mutes Individual Phones); many phones have a mute button on them. • If you receive a call and need to pick up, please disconnect from the webinar. Otherwise, all town hall participants hear your hold music! • We will hold the Q&A session at the end of the presentation: § Type it in the Chat Box for a response OR § Raise Your Hand: • • A presenter will call your name After your name is called, un-mute your phone and speak your question/comment • Please be respectful of others time; we may need to have a separate conversation later to best help you 2 2

Important Reminder • Lists are generated from Id. M groups • LEAs are responsible for maintaining the groups • Please be sure to update accounts for changes including no longer at your LEA, change of email, names, adding phone numbers. • Thank you 3 3

What is PII? • Student Personally Identifiable Information (PII) is defined by state and federal laws as information that, alone or in combination, personally identifies an individual • This includes direct identifiers (i. e. name, SASID, etc. ) • Includes information that when combined is identifiable • Colorado’s new Student Data Transparency and Security Act introduces a number of new requirements for how Student PII is collected, used and shared • CDE has prepared guidance on how to comply with this and other privacy laws which can be found here: http: //www. cde. state. co. us/dataprivacyandsecurity 4

How to Share Data üCheck local policies for restrictions, requirements, etc. üEnsure that you are following local policies when transmitting PII to any third party üUse secure methods to transfer any PII to CDE ü Call CDE (303 -866 -6395) with questions about how to transmit PII securely ü Use Syncplicity to encrypt emails to CDE üAvoid sending PII via unencrypted email or to unsecured faxes when sharing data between or within districts X Do not use PII in trainings, presentations, etc. X Do not share PII with unauthorized individuals X Do not share passwords 5

Introductions

Today’s Agenda • Open Collections in Data Pipeline • Report Card March • Directory • Student End of Year • Student Interchange • READ • Discipline Interchange • Civil Rights Data Collection • SBD 7

Power School Opportunity

Power School Opportunity • Central States Power. School Conference hosted by KSPSUG • DATES: April 3 - 5, 2017 • LOCATION: Hilton Garden Inn, 410 S 3 rd St, Manhattan, Kansas 66502 • PHONE #: 1 -785 -532 -9116. • HOTEL RESERVATIONS: Ask for KSPSUG group rate of $104. 00 plus tax per night or you can click here. • Conference Registration link: https: //goo. gl/forms/F 9 X 9 SVuk. T 16 QPsx 22 • Registration Fee: 1 day - $75, 2 days - $150, 3 days - $200. 00 • Breakfast and Lunch will be provided each day. • Social Night Tuesday evening • Fun game night and networking opportunities. • Who can breakout the quickest? ? ? A breakout challenge room where participants can show their competitive side by working as a team to solve clues to the mystery. You will be completing puzzles and trivia in order to "break out". Race against the clock to break out before time expires. 9 9

Open Collections in Data Pipeline

Open Data Pipeline Collections Year Round • Directory (4 Day School Week and School Code Changes) • RITS • EDIS Periodic • Report Card March (Closes Apr. 7 th) Interchanges • Staff • Student • Special Education IEP • TSDL 11 11

Open Data Pipeline Collections Snapshots • Teacher Student Data Link (TSDL) • Student End of Year for 2016 -17 (Soft Opening) Coming Soon • READ (Open April 3 rd) 12 12

Vendor Contacts

District Vendor Contacts • If you have a contact person for your data vendor system please send me their email so the various collection holders can contact them. This is so we can notify them of any changes for 2017 -18 data collections. • st. hilaire_d@cde. state. co. us 14

Report Card March

Report Card March 2016 -17 • RCMAR open until 4/7/2017! • You may find training videos and file layouts and definitions at: • http: //www. cde. state. co. us/datapipeline/per_report-march • Collection issues and updates • In the text fields avoid using apostrophes. This causes a fatal error when saving the file/form. • Superintendent sign off sheet updated. There were some READ collection information that was mistakenly put on the Report Card March sheets. If you already sent in the superintendent sign off sheet, CDE will accept the old sheets. 16

Report Card March 2016 -17 • So far there have been only a few questions. • If you have any questions please let me know. • st. Hilaire_d@cde. state. co. us • Phone: 303 -866 -6840 • FAX: 303 -866 -6888 • For 2017 -2018 the Report Card March Collection will not have any changes. 17

Directory

Directory 4 Day School Week • 4 Day School Week Application • School districts operating a four-day school week (less than 160 scheduled days per school year) are required to submit a request for approval. Only for schools that include grades 112. To be considered for the of 2017 -2018 school year, please complete the application via Data Pipeline by Friday, May 12. 19

4 Day School Week 20

School Code Changes • Items that require a form to update Directory • • Request a New School Code Closing a School for Grade Changes for Name Changes • http: //www. cde. state. co. us/apps/formcenter/School. Chang e. Forms 21

Directory Changes for 2017 -18 For the 2017 -18 School year Ed. Facts made a change in the Virtual categories. The change is mostly for clarification. Exclusively Virtual was Full Virtual Primarily Virtual was Virtual with Face to Face Primarily Classroom was Supplemental Virtual No Virtual Instruction was Not Virtual 22

Student End of Year

Soft Open Student EOY – Duncan Anderson – Anderson_d@cde. state. co. us • The End of Year Collection is in Soft Open. Districts are able to create snapshots using their Student Interchange Data. • The file formats are the same as you used with Student October. • Only error free interchange records will be pulled into the snapshot. Please work on interchange errors before creating a snapshot 24

Soft Open Student EOY – Duncan Anderson – Anderson_d@cde. state. co. us • New changes: • Inactivated business rules associated with one-day stitching records • The most significant of these rules was SE 099 which required a school to have a one-day enrollment record for a student that transferred schools within a district over the summer • Districts can still submit records using the previous process, it’s just no longer required using the logic checks. • These rules will no longer trigger when a snapshot is created. Snapshots created prior to the change will still have these errors listed in their error reports. • Full list of Business Rules (still being updated during soft open): http: //www. cde. state. co. us/datapipeline/eoysnapshotbusines srules 25

End Of Year • Phones will be unmuted for a moment and questions can be asked. • If you prefer type in your questions in the chat box. 26 26

2017 -2018 Student Interchange

2017 -2018 Student Interchange • EDAC approved the 2017 -2018 Student Interchange files last week • The approved File Layouts and Definitions plus a summary of changes can be found on the Student Interchange website • http: //www. cde. state. co. us/datapipeline/inter_student Morgan Holmgren – Holmgren_m@cde. state. co. us – 303 -866 -6961 28

2017 -2018 Student Interchange • Demographic File Changes • Removed Fields • Migrant • Bilingual • ESL Status • New Fields • Military Connected Students • Language Instruction Program (LIP) • Code/Definition Changes • Postsecondary Enrollment • Language Proficiency Morgan Holmgren – Holmgren_m@cde. state. co. us – 303 -866 -6961 29

2017 -2018 Student Interchange • EL Changes • CDE needs to collect more program types from districts than just Bilingual or ESL • In order to collect this we are eliminating the Bilingual and ESL Status fields and creating a new field Language Instruction Program where districts can report 5 distinct program types • • • ESL / ELD Dual Language / Two-way Immersion Transitional Bilingual / Early-exit Bilingual Content Classes with Integrated ESL Support Newcomer Programs • Or students can be reported with an LIP of • Other • Parental Refusal Morgan Holmgren – Holmgren_m@cde. state. co. us – 303 -866 -6961 30

2017 -2018 Student Interchange • EL Changes • Language Proficiency will incorporate different levels of Fluent English Proficient (FEP) that were captured in ESL/Bilingual categories before. • The process for resdesignation and exiting students is changing NEP / LEP FEP Monitor Year 1 FEP Monitor Year 2 FEP Exited Year 1 FEP Exited Year 2 FELL • Office of Accountability will consider students as EL if they are NEP, LEP or FEP (any designation) • Everyone else at CDE will consider students EL if they are NEP, LEP, FEP M 1, or FEP M 2 • Students changing districts should no longer be automatically moved to FELL Morgan Holmgren – Holmgren_m@cde. state. co. us – 303 -866 -6961 31

2017 -2018 Student Interchange • Military Connected Students • New field required by the Every Student Succeeds Act (ESSA) • Definition: • Student has a parent or guardian that is an active duty member of the Armed Forces or on full-time National Guard duty. • Field is a yes(1)/no(0) field • Does not need to be reset during the school year if status changes • We are aware that many districts have already set up their enrollment forms for 2017 -2018 • Please do your best to report this data Morgan Holmgren – Holmgren_m@cde. state. co. us – 303 -866 -6961 32

2017 -2018 Student Interchange • Postsecondary Enrollment • One character to two character • ASCENT carryforward changing to become: • 09 – ASCENT Carryforward – Full-Time • 10 – ASCENT Carryforward – Part-Time • All ASCENT Carryforward students should be funded as an 87 (Not-Eligible Tuition) • Adding in reporting for P-TECH • 15 – P-TECH – Years 1 -4 • For students in P-TECH schools grades 9 -12 where they have not been retained • 16 – P-TECH – Years 5 -6 • For students who have been retained in 12 th grade to be in years 5 & 6 of P-TECH • No students should have this code in 2017 -18 *This change is also reflected in the 2017 -18 Advanced Course Completion file Morgan Holmgren – Holmgren_m@cde. state. co. us – 303 -866 -6961 33

2017 -2018 Student Interchange • Student School Association File Changes • Removed Fields • • Gifted and Talented Continuous in District Continuous in School Contract Third Party Educator/Program • New Field • Non-School Program • Code/Definition Changes • Retention • Public School Finance Status Morgan Holmgren – Holmgren_m@cde. state. co. us – 303 -866 -6961 34

2017 -2018 Student Interchange • Non-School Program • Contract Third Party Educator/Program was too narrow for the many ways districts may need to report students who participate in programs that do not have school codes • If a student is 100% educated by a program that does not have a school code they should be marked in one of the categories for this field. The categories include: • Single District On-line Program • District-Run Program • This can include programs within an existing school that uses different calendars or bell schedules • Other School District or BOCES Program • Third Party Program • This field will be primarily used by FAST to identify students who need to be included in audit sample Morgan Holmgren – Holmgren_m@cde. state. co. us – 303 -866 -6961 35

2017 -2018 Student Interchange • Retention Code • Retention code = 2 used to be just for retaining students for ASCENT • Now it can be used to retain students for any postsecondary program. Including: • ASCENT • P-TECH • Early College • Students must be in 12 th grade to use this code • Public School Finance Status • CPP definitions altered to include ECARE and acceptable grade levels Morgan Holmgren – Holmgren_m@cde. state. co. us – 303 -866 -6961 36

2017 -2018 Student Interchange • Questions on the 2017 -18 Student Interchange? • The approved File Layouts and Definitions plus a summary of changes can be found on the Student Interchange website • http: //www. cde. state. co. us/datapipeline/inter_student Morgan Holmgren – Holmgren_m@cde. state. co. us – 303 -866 -6961 37

READ

READ Collection Key Dates • April 3: READ Collection opens • June 16: Districts complete submission of READ file & budget planning survey by close of business – all submissions are finalized and submissions will be locked • June 30: Districts re-submit data file with duplicates removed by close of business – READ collection closes • Week of August 7: Districts can anticipate distribution of READ funds 3/23/2017 39

Preparing for the 2017 READ Collection • READ is in Soft Open. Districts are able to upload files. Budget planning survey will be available next Wednesday. • Districts will be required to submit budget planning information to CDE prior to receiving funds • CDE is required per statute to review fund usage for the following services: • Summer school literacy programs • Targeted, scientifically or evidence-based intervention services • CDE has been planning for effective implementation of this provision • • Engagement of a representative focus group of districts Feedback from EDAC Communication to districts Informational webinar 40

Budget Planning Survey • The READ Budget Planning Survey will consist of five, Yes or No questions that will be collected at a district level and submitted in addition to the LEP’s READ data file • To access the survey: • User will select “READ Budget Planning Survey” on the initial Pipeline screen for READ • User will select current school year and district 3/23/2017 41

Budget Planning Survey • The survey can be submitted at any time throughout the collection; however, it is encouraged that LEPs submit this survey as soon as possible even if READ data file is not finalized • Survey may not have blank questions, but users will be able to save the survey questions already answered and come back to survey at a later time to complete • User must have REDLEAUSER user role for completing and editing the survey and the REDLEAAPPROVER role to finalize and submit the survey to CDE • If the LEP does not have any students identified as having an SRD for the upcoming budget year, submission of the budget planning survey is not required 3/23/2017 42

Budget Planning Survey Format • The READ Budget Planning Survey will include the following questions: An error message will be presented if user tries to submit the survey without agreeing to both assurances 3/23/2017 43

Budget Planning Survey Format 3/23/2017 44

IDM Roles • Before you do any loads to Data Pipeline, ensure you have the correct roles: • For uploading and editing the READ file: Submit and Modify Role REDLEAUSER • For uploading, editing and submitting READ file: Approve Role REDLEAAPPROVER • Same roles apply to submitting the Budget Planning survey • This is the group of people who will receive all communications for our collection through our list serve • You will need to ask your Local Access Manager (LAM) for the necessary rights if you do not have them • Please contact the READ collection manager (Whitney Westgaard) if you do not know your LAM to obtain this information 3/23/2017 45

Upcoming Trainings 2016 -17 Changes to READ Collection Monday, March 27 th at 2: 00 • Summary of changes to the 2017 collection • Review of Budget Planning survey • Opportunity to ask questions First Year Respondent Training Tuesday, March 28 th at 2: 00 • • • Purpose of the READ data collection Review data elements and coding Submission process through Pipeline Common areas of concern Data privacy and security Please click here to access the webinar links 3/23/2017 46

READ Resources • READ Collection resources can be found at: http: //www. cde. state. co. us/coloradoliteracy/readdatapipeli ne • Upcoming webinars • Data collection timeline • Data elements & definitions • File layout • Business Rules • Additional resources such as FAQ document, assessment cut scores, template for submitting budget planning survey, etc. • Questions? Contact Whitney Westgaard, READ Data Collection Manager • Email: Westgaard_W@cde. state. co. us • Phone: 303 -866 -6421 3/23/2017 47

Discipline Interchange

Discipline Timeline • http: //www. cde. state. co. us/datapipeline/2016 -2017 specialeducationdisciplinetimeline • April 3 rd: Discipline Interchange Available • May 1 st: Special Education Discipline Snapshot Opens • May 8 th: Interchange Files must be uploaded • Discipline, IEP, Student • June 8 th: Admin Units create snapshot • June 22 nd: 90% of the total Discipline Action records must be included in the Discipline Action file • July 12 th: Discipline Action errors resolved • August 15 th: Complete Special Education Discipline Snapshot created • August 16 th August 23 rd: • August 23 rd: Report Review Week Complete Special Education Discipline Snapshot created Submit Data to CDE Upload required reports to Data Management System Discipline (students with disabilities) – Kristi Gleason_k@cde. state. co. us 303 -866 -4620 49

Roles and Responsibilities ADMINISTRATIVE UNITS DISTRICTS Responsible for submitting valid and reliable data on students with disabilities with discipline incidences and actions. Responsible for the Approval and submission of the Special Education Discipline Data Collection. SPECIAL EDUCATION DIRECTORS (in conjunction with Superintendents, Principals, Other School Personnel) Responsible for the overall collection and the authorization of reports. COLLABORATION Discipline (students with disabilities) – Kristi Gleason_k@cde. state. co. us 303 -866 -4620 50

Id. M Groups https: //cdeapps. cde. state. co. us/faqs. html DISTRICT ADMINSITRATIVE UNIT Interchange groups associated with the four digit district code Snapshot groups associated with the five digit administrative unit code SPI DIS • District Name PIPELINE District Number -DIS~LEAUSER Submit and Modify Role • District Name PIPELINE District Number DIS~LEAVIEWER Read-Only Role • AU Name PIPELINE - AU Number SPI~LEAVIEWER Read-Only Role • AU Name PIPELINE –AU Number SPI~LEAUSER Submit and Modify Role • AU Name PIPELINE –AU Number SPI~LEAAPPROVER Approver Role Discipline (students with disabilities) – Kristi Gleason_k@cde. state. co. us 303 -866 -4620 51

RESOURCES INTERCHANGE http: //www. cde. state. co. us/datapipeline/inter_sped -discipline Overview Deadlines File Layouts and Definitions Business Rules Template Trainings SNAPSHOT http: //www. cde. state. co. us/d atapipeline/snap_speddiscipline Overview Deadlines File Layout Business Rules Additional Links Discipline (students with disabilities) – Kristi Gleason_k@cde. state. co. us 303 -866 -4620 52

Interchanges that make up the Special Education Discipline Snapshot INTERCHANGES v. Discipline Action v. Discipline Data v. Student Demographics v. Student School Association v. Grades v. IEP Participation v. Primary Disability SPECIAL EDUCATION DISCIPLINE Discipline (students with disabilities) – Kristi Gleason_k@cde. state. co. us 303 -866 -4620 53

Additional Information • New in 2016 -2017 • New Superintendent Sign Off Form • Webinar Training to be announced soon! • Training Resources • Interchange Training 2015 -16 essentially the same information good place to start • How to Load Discipline Files in Data Pipeline Discipline (students with disabilities) – Kristi Gleason_k@cde. state. co. us 303 -866 -4620 54

Contact Information If you have ANY questions about the Special Education Discipline Data Collection please feel free to contact us. We are just a phone call away! Kristi Gleason 303 -866 -4620 gleason_k@cde. state. co. us Collection Lead Lindsey Heitman 303 -866 -5759 heitman_l@cde. state. co. us Please include the following team members in your email communications gleason_k@cde. state. co. us; heitman_l@cde. state. co. us In the subject line of the email if you would please include the following information: • District Number (four digit code) • Administrative Unit Number (5 digit code) • Subject of the email along with any business rules or name of a report if applicable. In the body of the email: Please include your phone number! Thank you Discipline (students with disabilities) – Kristi Gleason_k@cde. state. co. us 303 -866 -4620 55

Civil Rights Data Collection

2015 -16 CRDC • Deadline is Friday, April 28, 2017 Colorado Progress • 25 certified • 3 100% complete (have not certified) • 34 over 90% complete • AWS (Advance Website) • https: //crdc. grads 360. org/#program • Partner Support: (855) 255 -6901 or crdc@aemcorp. com Jan Rose Petro 303 -866 -6838 petro_j@cde. state. co. us 57

2015 -16 CRDC • CDE provided files to CRDC contacts to correct errors • Section III: Classes, Course Enrollment, and Program Enrollment – Classes in Algebra I and Geometry in High School (Grades 9 through 12 only) • Section VII: Student Discipline - LEP counts • Files were sent securely through SFTP • LEAs may resubmit these files if they have not yet overwritten and/or use for validation purposes Jan Rose Petro 303 -866 -6838 petro_j@cde. state. co. us 58

2015 -16 CRDC contacts are MAGNIFICENT!!! THANK YOU!!! Jan Rose Petro 303 -866 -6838 petro_j@cde. state. co. us 59

CRDC • Phones will be unmuted for a moment and questions can be asked. • If you prefer type in your questions in the chat box. 60 60

SBD

SBD Manual & Webinar • https: //www. cde. state. co. us/assessment Assessment Unit homepage ↓ Trainings ↓ Data Trainings ↓ SBD Manual SBD Webinar *SBD manual page 2* 62

2016 -2017 SBD Review Timeline* Assessment Dates 1 ACCESS for ELLs 03/16 -03/29 2 CO SAT/PSAT 10† 05/15 -05/24 3 CMAS • • 05/22 -06/01 Science/social studies Co. Alt science/social studies ELA/math (PARCC) CSLA 4 Co. Alt: English Language Arts and Mathematics (DLM) 06/19 -06/27 *DACs and data respondents will receive updates about individual collections as needed. †Will count for accountability reporting beginning in 2017 *SBD manual page 2* 63

Data Pipeline Assessment Collections User Role* Description LEA viewer 1. Can only view data and reports LEA user 1. Can view data and reports 2. Can download, edit, and upload data 3. Can approve data† *Assigned by Local Access Manager (LAM). Individuals may be assigned roles in several or all SBD collections but may only have one user role per collection. †Districts can ensure that SBD data have been submitted using the Status Dashboard tab in Data Pipeline. LEA approver *SBD manual page 6* 64

News for ACCESS for ELLs Collection • Duplicate records in file • Reported Record field • If one record has ‘ 1’ and one has ‘ 2’ > Match data • If both records have ‘ 1’ > Include records in failsafe • CDE providing optional calculated values for: • Continuously in District • Continuously in School • Date First Enrolled in U. S. *SBD manual page 35* 65

CDE Optional Calculated Values • File Extract Download • Extract Type • SBD Extract = Vendor file (reflective of pre-ID data) • SBD Extract using Student Profile = File updated with Data Pipeline Student Interchange data • SBD Student and CDE continuous extract = File updated with Data Pipeline Student Interchange data PLUS calculated values 66

Accountability Comparison Report • CDE providing optional calculated values for: • Continuously in District • Continuously in School • Date First Enrolled in U. S. 67 Assessment ∙ Melissa Mincic ∙ mincic_m@cde. state. co. us or 303 -866 -6281 67

Student Location Report *SBD manual page 32* Assessment ∙ Melissa Mincic ∙ mincic_m@cde. state. co. us or 303 -866 -6281 68

2016 -2017 SBD Reviews Contacts § Melissa Mincic § mincic_m@cde. state. co. u s § 303. 866. 6281 § SBDs § Shangte Shen § § shen_s@cde. state. co. u s 303. 866. 6877 § SBD § ACCESS for ELLs § CMAS § DLM § CO PSAT 10/CO SAT Assessment ∙ Melissa Mincic ∙ mincic_m@cde. state. co. us or 303 -866 -6281 69

Thank you for joining us today! Enjoy that Colorado Spring! Next Town Hall: Thursday, March 30 th, 2017 9 a. m. -10 a. m. 70