Data Pipeline Town Hall February 23 rd 2017

Data Pipeline Town Hall February 23 rd, 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 2/23/2017 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/23/2017 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 2/23/2017 3 3

What is PII? Federal and state laws require CDE to collect data that may include Personally Identifiable Information (PII). Ø Name, address, personal identifier Ø Other indirect identifiers (e. g. , date or place of birth) • Student PII is defined by the Colorado Student Data Transparency and Security Act as information that, alone or in combination, personally identifies an individual student or the student's parent or family, and that is collected, maintained, generated, or inferred by a public education entity, either directly or through a School Service, or by a School Service Contract Provider. • PII is also defined by FERPA as information that, alone or in combination, is linked or linkable to a specific student that would allow a reasonable person in the school community, who does not have personal knowledge of the relevant circumstances, to identify the student with reasonable certainty; or information requested by a person who the educational agency or institution reasonably believes knows the identity of the student to whom the education record relates. 2/23/2017 4

How to Share Data üCheck local policies for restrictions üUse secure-file transfer protocols üCall CDE with questions about how to transmit PII securely X Do not send PII over e-mail or fax X Do not use PII in trainings X Do not share PII with unauthorized individuals X Do not share passwords For more information http: //www. cde. state. co. us/dataprivacyandsecurity 2/23/2017 5

Today’s Agenda • Open Collections in Data Pipeline • Report Card March • RITS • Student End of Year • Civil Rights Data Collection (CRDC) • SBD 2/23/2017 6

Introductions

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. 2/23/2017 9 9

Planned System Outage for Database Maintenance March 7, 2017

Planned System Outage – Database Maintenance Who is Affected: Pipeline Users Purpose of Activity: Database patching and updating of underlying systems Maintenance Time Frame: 3/7/2017 at 5 PM – 3/8/2017 at 7 AM Database patches are routinely applied to fix software bugs and stay up to date with the latest in security. Applying these patches regularly keeps our applications running smoothly and keeps CDE data safe. After consulting with the collection calendar and other key stakeholders, IMS staff scheduled our next patching exercise for the winter of 2017. Our ongoing plan will be to patch twice a year, once in the winter and once in the summer. The Production Database Patching will occur Tuesday 3/7/2017 after business hours from 5 PM to Wednesday morning 3/8/2017 at 7 AM. During the patching windows, all single sign on applications, such as Pipeline, RANDA, LACES, and Growth Model will be unavailable. If you have any questions, please contact David Rapp in IMS at rapp_d@cde. state. co. us 2/23/2017 11 11

Open Collections in Data Pipeline

Open Data Pipeline Collections Year Round • Directory (4 Day School Week and School Code Changes) • RITS • EDIS Periodic Interchanges • Staff • Student • Special Education December Count IEP • TSDL 2/23/2017 13 13

Open Data Pipeline Collections Snapshots • Teacher Student Data Link (TSDL) • Student End of Year for 2016 -17 (February Soft Opening) Coming Soon • Report Card March (March 1 st Opening) • Access for ELLs SBD (March 13 th Opening) 2/23/2017 14 14

Report Card March

Report Card March 2016 -17 • The Report Card March will open Wednesday, March 1 st 2017 and will remain open until April 7 th 2017. • IDM Roles DISTRICT PIPELINE-NNNN-RCM~LEAAPPROVER Approver Role DISTRICT PIPELINE-NNNN-RCM~LEAUSER Submit and Modify Role DISTRICT PIPELINE-NNNN-RCM~LEAVIEWER Read-Only Role 2/23/2017 16

Report Card March 2016 -17 • There are two ways of submitting your data in the Report Card March Collection. • Form Submission • File Submission • You may find the file layouts and definitions at: • http: //www. cde. state. co. us/datapipeline/per_report-march • I will have training materials available on the above link by March 1 st. 2/23/2017 17

Report Card March 2017 -18 • If you chose to not report the following items in 201617 you will need to report a “Y” or “”N”. (or file submission of “ 0”/” 1”) Last year there was a value of 2 or NA which will not be valid and using it will cause an error. Blended Learning Flag Flexible Schedule Flag Immediate Progress Towards Graduation Flag Newcomer Center Flag Work-Based Education Experience Flag Bullying Policy Flag 2/23/2017 18

Report Card March Changes for 2016 -17 New Fields • Defines bullying. Legislative definition: • Any written or verbal expression, or physical or electronic act or gesture or a pattern thereof intended to coerce, intimidate, or cause any physical, mental, or emotional harm to any student. • Including but not limited to any such behavior that is directed toward a student on the basis of his or her academic performance or against whom federal and state laws prohibit discrimination upon any bases described in section 22 -32 -109(1)(11)(I). • 22 -32 -109(1)(11)(I): The schools and districts are subject to all federal and state laws and constitutional provisions prohibiting discrimination on the basis of disability, race, creed, color, sexual orientation, national origin, religion, ancestry, or need for special education services. 2/23/2017 19 19

Report Card March Changes for 2016 -17 • Bullying is prohibited against any students for any reason. Prohibited on district/school property and at school-sponsored activities. • Students engaged in bullying or students who retaliate against a student who has reported bullying will be appropriately disciplined. 2/23/2017 20 20

Report Card March Changes for 2016 -17 • The superintendent has developed a comprehensive bullying plan/program: • Bullying will not be tolerated • Train staff and students to prevent • Implement procedures for immediate intervention, investigation and discipline for students who bully • Make efforts to change behavior of bullies • Partner with parents and community to maintain a bully-free environment • Support victims of bullies • Consistently recognize and praise positive supportive student behaviors 2/23/2017 21 21

Report Card March Changes for 2016 -17 Does your school use any of the following evidence-based bullying programs: Bully Prevention in Positive Behavioral Interventions and Supports (BP -PBIS) Flag Bully Proofing Your School (BPYS) Flag Olweus Bully Prevention Program (BPP) Flag Promoting Alternative Thinking Strategies (PATHS) Flag Second Step Flag Steps to Respect Flag Home Grown Flag If Home Grown (specify if patterned after existing program (s)) Other Flag If Other (specify) 2/23/2017 22 22

Report Card March • Phones will be unmuted for a moment and questions can be asked. • If you prefer type in your questions in the chat box. 2/23/2017 23 23

RITS

RITS guidance has been updated. The new guidance addresses: ØLegal documentation needed to obtain SASIDS ØHow to enter student data into RITS Web ØThe differences between RITS Web, RITS Match Tool, and RITS batch ØGuidance for obtaining SASIDS for various types of students For more information: http: //www. cde. state. co. us/datapipeline/yr_rits Contact: Genevieve Hale at hale_g@cde. state. co. us or at 303 -866 -6612 2/23/2017 25 25

RITS Assessment time is fast approaching! To ensure you have SASIDS in time please: ØSubmit your SASID requests early ØFollow up with CDE SASID consultant if it’s been a couple of days and you are missing a SASID(s) ØBe sure to follow the RITS guidance on how to properly request SASIDS so that the SASIDS are issued quicker ØUse comments box for commonly used names or if there is a potential for a match ØDo a search for your new students as there is a strong possibility that they may already have a SASID Contact: Genevieve Hale at hale_g@cde. state. co. us or at 303 -866 -6612 2/23/2017 26 26

RITS • Phones will be unmuted for a moment and questions can be asked. • If you prefer type in your questions in the chat box. 2/23/2017 27 27

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 2/23/2017 29

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. 2/23/2017 30 30

Civil Rights Data Collection

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

2015 -16 CRDC Q: Can districts see information that was prepopulated from CDE? A: Yes. Before entering any data an LEA can run a Submission Review Report. The Submission Review Report provides a compressed zip file containing the following: • LEA form data in a pdf format • Individual school form data for all schools within the LEA, each one in a separate pdf • A separate pdf providing Key Definitions for the report 2/23/2017 Jan Rose Petro 303 -866 -6838 petro_j@cde. state. co. us 33

form data in a PDF format. 2015 -16 CRDC Q: Can districts see information that was prepopulated from CDE? A: (cont. )This report represents a snapshot of the data submitted at the time an LEA launches the report. • Each pdf contains • an entire LEA or school form with all questions, instructions, and data elements shown, whether submitted or not, • any comments or reason codes associated with the data elements or tables. • Data elements that have yet to be submitted are shown as "NS" for Not Submitted, while data elements that are skipped by the system display as "N/A" for Not Applicable. • For purposes of calculated table totals, both "NS" and "N/A" are counted as 0 2/23/2017 Jan Rose Petro 303 -866 -6838 petro_j@cde. state. co. us 34

Commenting on 2017 -18 CRDC • The Federal Register 96446, the U. S. Department of Education announced the proposed 2017 -18 Civil Rights Data Collection (CRDC) for public comment under the federal Paperwork Reduction Act. Comments are due February 28, 2017. One of the items of interest is the proposed data collection of a new data element that asks for the bandwidth at the school. (see A 2 -69). • 2/23/2017 Jan Rose Petro 303 -866 -6838 petro_j@cde. state. co. us 35

2015 -16 CRDC THANK YOU!!! 2/23/2017 Jan Rose Petro 303 -866 -6838 petro_j@cde. state. co. us 36

CRDC • Phones will be unmuted for a moment and questions can be asked. • If you prefer type in your questions in the chat box. 2/23/2017 37 37

SBD

Student Assessment Data Cycle PRE-ID EXTRACT 1. Districts upload data to Data Pipeline 2. CDE downloads data from Data Pipeline to submit to vendor system 3. CDE submits data to vendor system STUDENT TESTING 1. Districts can update data in vendor system before, during, or after testing* *Not applicable for all assessments 39 2/23/2017 SBD REVIEW 1. Vendor provides data to CDE 2. CDE loads data into Data Pipeline 3. Districts download and update data 4. Districts submit and approve data 5. CDE returns data to vendor 6. Vendor merges student demographic data with score data and provides files and reports to districts and schools through vendor system Assessment ∙ Melissa Mincic ∙ mincic_m@cde. state. co. us or 303 -866 -6281 39

Student Assessment Data Cycle: Before Testing Pre-ID Extract & Student Testing Prep (CMAS Example) Cycle Activity Pre-ID extract Task Districts update data in Data Pipeline CDE downloads data from Data Pipeline, validates file for accuracy and completeness, and submits to vendor system Preparing Districts work in vendor system to: for student • Assign student test accommodations testing in • Confirm testing format (i. e. , online or paper) vendor system Districts complete student transfer requests 40 2/23/2017 Expected 20162017 Date(s) December 16 th – January 6 th January 9 th – January 27 th January 9 th – April 28 th Vendor creates labels for testing booklets January 27 th Districts update student demographic data in vendor system (can be done in vendor system and/or during SBD) January 9 th – May 17 th Assessment ∙ Melissa Mincic ∙ mincic_m@cde. state. co. us or 303 -866 -6281 40

Student Assessment Data Cycle: During Testing Student Testing (CMAS Example) Cycle Activity Student testing Task Districts conduct testing Districts update demographic data and not tested/void codes in vendor system (can be done in vendor system and/or during SBD) Expected 20162017 Date(s) April 10 th – April 28 th* Prior to May 17 th *Some districts may begin testing online ELA/math as early as March 17 th and high school science as early as March 27 th. 41 2/23/2017 Assessment ∙ Melissa Mincic ∙ mincic_m@cde. state. co. us or 303 -866 -6281 41

Student Assessment Data Cycle: After Testing Student Testing & SBD Review (CMAS Example) Cycle Activity Task Data clean up in Vendor receives all scorable paper tests* vendor system Districts update demographic data and not tested/void codes in vendor system (can be done in vendor system and/or during SBD) SBD review Expected 20162017 Date(s) May 5 th Prior to May 17 th Vendor provides data to CDE May 19 th CDE loads data into Data Pipeline May 22 nd Districts download and update data (demographic data and void/invalidation codes can be updated in vendor system and/or during SBD) May 22 nd Districts submit and approve data June 1 st CDE validates data and returns data to vendor Immediately after closes *If scorable materials are not picked up by May 3 rd, there is no guarantee that records for. SBD these PBT students will be included in SBD or scored. 42 2/23/2017 Assessment ∙ Melissa Mincic ∙ mincic_m@cde. state. co. us or 303 -866 -6281 42

Student Assessment Data Cycle: After Testing Release of Results (CMAS Example) Cycle Activity Creation of score file, data validation and quality control processes Task Vendor merges student demographic data with score data, validates data, and provides student level data files to CDE Expected Timeline Immediately upon receipt of SBD data from CDE validates student level score Immediately upon receipt of score files from vendor Embargoed CDE releases embargoed student • ELA/math – Paper scores may release of student- level data files to districts and be available after online results level data files schools through vendor system • Preliminary rolling file: Early June • Final student data file: Early July • S/SS student data file: Mid June 43 2/23/2017 Assessment ∙ Melissa Mincic ∙ mincic_m@cde. state. co. us or 303 -866 -6281 43

2016 -2017 SBD Reviews Assessment Tentative SBD Review Window ACCESS for ELLs 03/13/17 -03/24/17 CO PSAT 10/CO SAT* 05/15/17 -05/24/17 CMAS • Science/social studies • Co. Alt science/social studies • ELA/math (PARCC ) • CSLA 05/22/17 -06/01/17 DLM 06/19/17 -06/27/17 *Will count for accountability reporting beginning in 2017 44 2/23/2017 Assessment ∙ Melissa Mincic ∙ mincic_m@cde. state. co. us or 303 -866 -6281 44

2016 -2017 SBD Reviews SBD T/TA resources Resource Date Available/Scheduled 2016 -2017 SBD manual Friday 02/24/17 COB SBD training webinars Tuesday Wednesday 03/07/17 03/08/17 1: 00 -2: 00 pm 9: 00 -10: 00 am Please provide us your feedback by Friday, 02/17! • 2015 -2016 SBD manual: http: //www. cde. state. co. us/assessment/2016 sbdmanual • 2015 -2016 SBD training webinar: https: //enetlearning. adobeconnect. com/p 76 tesubo 6 b /? launcher=false&fcs. Content=true&pb. Mode=normal 45 2/23/2017 Assessment ∙ Melissa Mincic ∙ mincic_m@cde. state. co. us or 303 -866 -6281 45