We are about to get started! Housekeeping notes:

We are about to get started! Housekeeping notes:

We are about to get started! Housekeeping notes: Please mute your phones. If you have questions, type them into the chat box. If you would like to view the narration transcript, click the NOTES tab on the sidebar to the right. AEC Collections Webinar 3: Collection Window 2 Overview April 12, 2018 Accountability & Data Analysis Agenda Collection Window 2 Overview Collections & Timeline About the Collections Collections Checklist

Pipeline Basics Actual Measures & Data for 2018 AEC SPF Collection Collection Basics Resources Submitting Your Data Error Logic Status Dashboards Collection Opt Out Sign Off Sheets 2/29/20 Planned Measures For 2019 AEC SPF Collection

Collection Basics Resources Submitting Your Data Error Logic Status Dashboards Collection Opt Out Resources, Trainings & Contacts Questions 3 Collection Window 2 Overview Collections & Timeline

About the Collections Collection Checklist Pipeline Basics Collection Window 2 Overview Collections & Timeline Timeline: Month Selection of Measures Collection (Planned and Actual) Renewal/Application Designation Collection January

Training webinar 1 (1/18/18) Notify B Sanders of new schools seeking AEC designation by 1/31/2018 Training - office hours February Training webinar 2 (2/15/18) Training office hours Training office hours March

Renewal/Application collection opens 3/1/2018 Office hours for Renewal/Application collection will be available Planned measures for 2018 AEC SPF collection opens 3/1/2018 Office hours for Selection of Measures Renewal/Application collection closes 5/4/2018 Planned measures for AEC SPF closes 5/4/2018 Training webinar 3 (4/12/18)

Planned measures for 2019 AEC SPF collection opens 5/7/2018 Actual measures for 2018 AEC SPF collection opens 5/7/2018 Office hours for Selection of Measures April May June 2/29/20 Planned measures for 2019 AEC SPF collection closes 6/29/2018 Actual measures for 2018 AEC SPF collection closes 6/29/2018

Office hours for Selection of Measures 5 Collection Window 2 Overview About the Collections Actual Measures and Data Voluntary 2018 AEC SPF Submitting measures and data Cannot propose new measures through this collection window Requires a sign off form

2/29/20 6 Collection Window 2 Overview About the Collections Actual Measures and Data Voluntary 2018 AEC SPF Submitting measures and data Cannot propose new measures through this collection window Requires a sign off form

2/29/20 Planned Measures 2019 Voluntary 2019 AEC SPF Submitting measures only (no data) Use this collection to propose a new measure to CDE and begin measure negotiations Does not require a sign off form 7

Collection Window 2 Overview Collections Checklist Collections Checklist Review the file layout and definitions document and other resource documents Decide how you will submit your data OR decide if you will opt out of data collection Download your submission sign off form Complete your data submission OR opt out of data collection Gather necessary signatures If data is submitted check submission for errors Finalize data submission Email completed sign off form to B Sanders ( [email protected]) 2/29/20 8 Collection Window 2 Overview Pipeline Basics Accessing Data Pipeline: https:// cdeapps.cde.state.co.us/index.html

If you are managing the AEC Collections for your district/BOCES in part or in whole then you will need to work with your local area manager (LAM) to receive data pipeline permissions Role for collections: AEC~LEAAPPROVER Grants ability to sign into Alternative Education tab in Data Pipeline Ability to download/upload extracts to AEC collections Ability to edit records for Renewal/Application Collection Ability to add and edit records for Planned Measures for 2018 AEC SPF Collection Ability to opt out of AEC collections You cannot participate in the AEC Collections unless your LAM has assigned you to the AEC~LEAAPPROVER role! 2/29/20 9 Collection Window 2 Overview Pipeline Basics This is where you will start for all AEC Collections.

When all errors are resolved, use this to submit your data to CDE for review. Add records for both collections in this window. Edit records for both collections in this window. Opt a school, or schools, out of either collection in this window. Download file extracts for each collection. 2/29/20 10 Collection Window 2 Overview Pipeline Basics Errors in Data Pipeline: Invalid codes Missing data in required fields Incorrect codes in a given field Data that breaks a logic rule in a given field

Data errors will need to be resolved before submitted data can be finalized. 2/29/20 11 Collection Window 2 Overview Pipeline Basics Records added with errors will still be submitted to the Data Pipeline system, but you will receive a notice that they are an error, and they will be flagged in RED. 2/29/20 12 Collection Window 2 Overview Pipeline Basics When you load an edit record screen for a given collection, any errors will

be flagged in RED. 2/29/20 13 Collection Window 2 Overview Pipeline Basics The Pipeline Error Report is useful for file downloads/uploads. This will tell you how many errors and what types of errors an uploaded file contains. The View Details button will take you to those specific rows and let you edit them with the Edit Record screen. 2/29/20 14 Actual Measures & Data for 2018 AEC SPF Collection

Collection Basics Resources Submitting Your Data Error Logic Status Dashboard Collection Opt Outs

Sign Off Sheets Actual Measures & Data for 2018 Collection Collection Basics Actual Measures: Measures submitted with the intent of inclusion in the next AEC SPF cycle (2018 AEC SPF) VOLUNTARY for any school that has received or is planning to receive AEC designation Collection data is aggregated; not student level Data is included here, otherwise the measures are unable to be incorporated into the AEC SPF Can only choose from previously approved measures, or new measures which were negotiated during the Planned Measures 2018 collection (ends May 4th) May opt out of collection, but must do so formally using the opt out feature 2/29/20 16 Actual Measures & Data for 2018 Collection Resources What do you need?

Why do you need it? Where do you get it? File Layout and Definitions (Actual) Understand fields needed for data submission http://www.cde.state.co.us/datapipelin e/aec-application-renewal-filelayout-18 19 Confirmation that you have access to the AEC Collections in Pipeline Cannot submit data without access to Data Pipeline Local Area Manager grants AEC~LEAAPPROVER role permission Sign off sheets for Actual Measures Collection downloaded

Data submission is not considered final until sign off sheets are submitted http://www.cde.state.co.us/datapipelin e/aec-selection-measures-signoff Calculation Guidance for AEC Measures Can provide ideas for the kinds of optional measures to submit and standard calculation procedures http://www.cde.state.co.us/accountabi lity/calculation_guidance_for_aec_mea sures_4_24_17 Optional Measures Cut Point Lookup Document Can look up optional measure cut points and measure rating bands for previously approved measures

http://www.cde.state.co.us/datapipelin e/aec-cutpoint-lookup Indicator Measures Valid Combination Sheet Able to see what measures are associated with which indicators and metrics http://www.cde.state.co.us/datapipel ine/aec-indicators-valid-combinations 2/29/20 17 Actual Measures & Data for 2018 Collection Submitting Your Data Add/Edit Records Use Add/Edit Records to complete if: You do not want to map numeric codes to indicator, subindicator, category, and metric names You do not want to reference a separate document to track which subindicators match which categories and

which subindicators match which indicators One person will be doing the majority of the data entry and submission for all of the measure records You will be entering data measure by measure 2/29/20 18 Actual Measures & Data for 2018 Collection Submitting Your Data Add/Edit Records Select File Type: Actual Assessment Measure for AEC School Year: 2017-18 Organization/LEA: Your District/BOCES Hit Add New Record 2/29/20 19 Actual Measures & Data for 2018 Collection

Submitting Your Data Add/Edit Records Select File Type: Actual Assessment Measure for AEC School Year: 2017-18 Organization/LEA: Your District/BOCES Hit Add New Record 2/29/20 Select School Code Choose Measure Details from dropdowns AEC Indicator Assessment Category Metric Enter data Students meeting measure (numerator) Total students (denominator) Rate (final value)

Hit Submit/Add Record 20 Actual Measures & Data for 2018 Collection Submitting Your Data Add/Edit Records Select Actual Assessment Measures for AEC 2017-18 Your LEA Hit Search 2/29/20 21 Actual Measures & Data for 2018 Collection Submitting Your Data Add/Edit Records Select Actual Assessment Measures for AEC 2017-18

Your LEA Hit Search 2/29/20 You can delete or modify any of these records in this screen. You can edit multiple records at once, then SAVE. 22 Actual Measures & Data for 2018 Collection Submitting Your Data File Upload Use File Download/Upload to complete if: You have several AECs in your district/BOCES, and you are planning to submit several optional measures for each The staff completing the Actual Measures Collection are comfortable using and working with excel spreadsheets You have reviewed and have on hand all the additional resources you need for working with the file extracts http://www.cde.state.co.us/datapipeline/per-aec

Upload completed files to Data Pipeline for CDE review Download blank files from Data Pipeline to submit 2/29/20 23 Actual Measures & Data for 2018 Collection Submitting Your Data File Upload Select Actual Assessment Measures for AEC 2017-18 Preferred File Content Type (rec: Excel) Hit Download Standard Extract 2/29/20 24

Actual Measures & Data for 2018 Collection Submitting Your Data File Upload Select Actual Assessment Measures for AEC 2017-18 Preferred File Content Type (rec: Excel) Hit Download Standard Extract Add in the codes for: AEC Indicator AEC Subindicator AEC Subindicator Category AEC Subindicator Category Metric Add in the data for: Students meeting measure (numerator) Total students for measure (denominator) Rate/final value

2/29/20 25 Actual Measures & Data for 2018 Collection Submitting Your Data File Upload 2/29/20 Select Alternative Education Campus in Dataset Actual Assessment Measures for AEC in File Type 2017-18 in School Year Your LEA Choose your file Replace/Append in Upload Type depends on data youre submitting 26 Actual Measures & Data for 2018 Collection Error Logic Fields to Complete Field AEC Indicator

Code or Data? Code Null Values Permitted? No AEC Subindicator Code No AEC Subindicator Category Code No AEC Subindicator Category Metric Code No AEC Students Meeting Subindicator

Data Yes, if metric is not percentage or growth score AEC Total Students for Subindicator Data No AEC Final Subindicator Value Data No 2/29/20 27 Actual Measures & Data for 2018 Collection Error Logic Embedded Field Logic

Error Logic Reason If AEC Indicator is Academic Achievement, Postsecondary N of 16 is minimum for these and Workforce Readiness, or Student Engagement, then indicators AEC Total Students for Subindicator cannot be less than 16 If AEC Indicator is Academic Growth, then AEC Total Students for Subindicator cannot be less than 20 N of 20 is minimum for this indicator If AEC Subindicator Category Metric is Percentage or Growth Score, then the AEC Final Subindicator Value cannot be greater than 1 Rate-based metrics must be entered as a decimal (ex: .50) If AEC Subindicator Category Metric is Percentage or Growth Score, then AEC Student Meeting Subindicator cannot be null Rate-based metrics must include

both denominator and numerator If AEC Subindicator Category Metric is MGP or Percentile Rank, then AEC Final Subindicator Value must be between 1 and 99 MGP and Percentile Rank valid values are only between 1 and 99 If AEC Students Meeting Subindicator is not null, then Likely an error; cannot have more this value cannot be greater than AEC Total Students for students in numerator than Subindicator denominator 2/29/20 28 Actual Measures & Data Collection Status Dashboard Select Actual Assessment Measures for AEC 2017-18 Your Organization/LEA

Hit Search 2/29/20 29 Actual Measures & Data Collection Status Dashboard Select Actual Assessment Measures for AEC 2017-18 Your Organization/LEA Hit Search Check your Validation Errors. When Validation Errors are 0, and you have no changes left to make on your data, hit Submit to CDE. When you hit Submit to CDE, you have submitted your collection data! 2/29/20

30 Actual Measures & Data for 2018 Collection Collection Opt Out Mark option 1 for any school not submitting actual measures and data. 2/29/20 Remember to hit SAVE when you are done! 31 Actual Measures & Data for 2018 Collection Sign Off Sheet http://www.cde.state.co.us/datapipeline/per-aec Scroll down to this section: 2/29/20 32

Actual Measures & Data for 2018 Collection Sign Off Sheet Complete all fields. Please print legibly. All signatures are needed 2/29/20 33 Actual Measures & Data for 2018 Collection Sign Off Sheet Print form Add necessary information Gather needed signatures Your AEC Collection data is not considered complete and final until we receive your sign off form! 2/29/20

Scan completed form Email signed form to B Sanders ( [email protected]) 34 Planned Measures for the 2019 AEC SPF Collection Collection Basics Resources Submitting Your Data Error Logic

Status Dashboard Collection Opt Outs Planned Measures for the 2019 AEC SPF Collection Basics Planned Measures: Measures that you are expecting to use for an upcoming AEC SPF cycle (2019 AEC SPF) VOLUNTARY for any school that has received or is planning to receive AEC designation No data is included, only the measure names Information submitted in this collection is to tell CDE the measures that the school intends to include on the 2019 AEC SPF May opt out of collection, but must do so formally using the opt out feature 2/29/20

36 Planned Measures for the 2019 AEC SPF Collection Basics What do you need? Why do you need it? Where do you get it? File Layout and Definitions (Planned) Understand fields needed for data submission http://www.cde.state.co.us/datapipelin e/aec-application-renewal-filelayout-18 19 Confirmation that you have access to the AEC Collections in Pipeline Cannot submit data without access to Data Pipeline

Local Area Manager grants AEC~LEAAPPROVER role permission Calculation Guidance for AEC Measures Can provide ideas for the kinds of optional measures to submit and standard calculation procedures http://www.cde.state.co.us/accountabi lity/calculation_guidance_for_aec_mea sures_4_24_17 Indicator Measures Valid Combination Sheet Able to see what measures are associated with which indicators and metrics http://www.cde.state.co.us/datapipel ine/aec-indicators-valid-combinations

2/29/20 37 Planned Measures for the 2019 AEC SPF Collection Basics How to submit a new measure for consideration: Field Code Label 1 Academic Achievement 2 Academic Growth 3 Student Engagement

4 Post-Secondary and Workforce Readiness AEC Subindicator 999 New Subindicator AEC Subindicator Category 9999 New Category 1 Percentage 2 Percentile Rank

3 Growth Score 4 MGP 6 Mean Score AEC Indicator AEC Subindicator Category Metric To propose a measure that has not been previously approved, choose the indicator you believe it should fall into, New Subindicator and New Category, and whichever metric seems most appropriate. B Sanders will reach out for specifics about the Subindicator and Category once submitted; negotiations will open between the district/BOCES and CDE 2/29/20 38

Planned Measures for the 2019 AEC SPF Submitting Your Data Add/Edit Records Select Planned Assessment Measures for AEC 2018-19 Your LEA Hit Add New Record 2/29/20 Select School Code Choose Measure Details from dropdowns AEC Indicator Assessment Category Metric Hit Submit/Add Record 39

Planned Measures for the 2018 AEC SPF Submitting Your Data Add/Edit Records Select Planned Assessment Measures for AEC 2018-19 Your LEA Hit Search 2/29/20 You can delete or modify any of these records in this screen. You can edit multiple records at once, then SAVE. 40 Planned Measures for the 2019 AEC SPF Submitting Your Data File Upload Select Planned Assessment Measures for AEC

2018-19 Preferred File Content Type (rec: Excel) Hit Search 2/29/20 Add in the codes for: AEC Indicator AEC Subindicator AEC Subindicator Category AEC Subindicator Category Metric 41 Planned Measures for the 2019 AEC SPF Submitting Your Data File Upload 2/29/20 Select Alternative Education Campus in Dataset Planned Assessment Measures for AEC in File Type 2018-19 in School Year

Your LEA Choose your file Replace/Append in Upload Type as needed 42 Planned Measures for the 2019 AEC SPF Error Logic Field AEC Indicator Code or Data? Code Null Values Permitted? No AEC Subindicator Code No AEC Subindicator Category

Code No AEC Subindicator Category Metric Code No Error logic: submitted data must conform to valid combinations between indicator, subindicator, category, and metric 2/29/20 43 Actual Measures & Data Collection Status Dashboard Select Planned Assessment Measures for AEC 2018-19 Your Organization/LEA

Hit Search Check your Validation Errors. When Validation Errors are 0, and you have no changes left to make on your data, hit Submit to CDE. When you hit Submit to CDE, you have submitted your collection data! 2/29/20 44 Planned Measures for the 2019 AEC SPF Collection Opt Out Mark option 1 for any school not submitting planned measures. 2/29/20 Remember to hit SAVE when you are done! 45

Planned Measures for the 2019 AEC SPF No sign off form! No sign off form for Planned Measures! Informal planning collection Sign off sheets only required for Renewal/Application and Actual Measures and Data collections You are done when you: Upload data and submit your data to CDE, or Opt out of the collection 2/29/20 46 Resources, Trainings, and Contacts Resources AEC Collections Information Page http://www.cde.state.co.us/datapipeline/per-aec AEC Accountability Resource Page https:// www.cde.state.co.us/Accountability/StateAccount abilityAECs

2/29/20 48 Trainings AEC Collections Webinar Schedule: FOR REFERENCE: Webinar 1: Collections Overview deck and chat transcript Webinar 2: Collection Window 1 Details Deck, chat transcript, recording AEC Collections Office Hours: Weekly office hours on Tuesday afternoons from 1pm to 3 pm are available. You can sign up for a half hour phone slot to chat with B Sanders about any questions you may have about the AEC collections here: http:// www.signupgenius.com/go/5080c4ca5af2eabf94-aecc ollections 2/29/20 49

Modules In order to view the narration while the video is playing, click on the Notes tab in the sidebar in the player. Video Module 1 Overview & Timelines (9:59): https://enetlearning.adobeconnect.com/pi1md74k0rhw Video Module 2 Access to Pipeline (5:30): https://enetlearning.adobeconnect.com/pds83bvi0bka Video Module 3 Opting Out of Collections (7:21): https://enetlearning.adobeconnect.com/p4akh8y057nt Video Module 4 Sign Off Sheets (11:10): https://enetlearning.adobeconnect.com/p7lcn4j7j302 Video Module 5 Resources (10:30): https://enetlearning.adobeconnect.com/paii0l5a6d2h Video Module 6 Edit Records vs File Upload (12:24): https://enetlearning.adobeconnect.com/pjxifyl076br Video Module 7 Errors (9:12): https://enetlearning.adobeconnect.com/pqbkrtgu2l70 2/29/20 50 Contacts AEC Collection Questions B Sanders, AEC and Accountability Senior Consultant [email protected]

303.866.2685 Jessica Watson, Accountability and Policy Principal Consultant [email protected] 303.866.6778 Identity Management Questions Rich Morris, Systems Administrator [email protected] 303.866.6713 2/29/20 51 Reminder: Please use chat box to ask questions and keep phone muted.

Recently Viewed Presentations

  • Mesopotamia - Richmond County School System

    Mesopotamia - Richmond County School System

    Greek word meaning: "between the rivers" ... Economics. based on agriculture. large-scale system of water control, crops could be grown on a regular basis. traded for stone, wood, and metal from other societies to build empires . Culture. cities formed.
  • Analysis KO Analysis Defined Be able to select

    Analysis KO Analysis Defined Be able to select

    Triplets . Repetition . Sibilance . Alliteration . General term to show word or sound patterns in language . Creating a list of ideas . Listing three ideas close together or using three ideas. Saying something more than once across...
  • Care Management for ALL In 2011, Governor Andrew

    Care Management for ALL In 2011, Governor Andrew

    Outpatient Blood Services. Outpatient - Medically Supervised Withdrawal- Substance Abuse . Outpatient Mental Health . Outpatient Rehabilitation (OT, PT, Speech) Outpatient Substance Abuse . Outpatient Surgery . Palliative Care . Pap Smear and Pelvic Exams . Partial Hospitalization (Medicaid) Partial...
  • 19.1 Phylogenetic and Metabolic Diversity of Archaea  Archaea

    19.1 Phylogenetic and Metabolic Diversity of Archaea Archaea

    19.1 Phylogenetic and Metabolic Diversity of Archaea Archaea share many characteristics with both Bacteria and Eukarya Archaea are split into two major groups (Figure 19.1)
  • Dynamic Term Structure Modelling BDT & other One-factor

    Dynamic Term Structure Modelling BDT & other One-factor

    Dynamic Term Structure Modelling BDT & other One-factor Models Investments 2005
  • TGI Ice Breakers - Training Games, Inc.

    TGI Ice Breakers - Training Games, Inc.

    The longest bone in the human body is, on average, almost 20 inches long. It is the thighbone also called….? The Ulna. The Humerus. The Femur. B. Ready for some great trivia! There are 25 fun trivia slides in this...
  • Title 1

    Title 1

    register (by the instruction length) - decode the instruction (in the control unit) - fetch operands, if any, usually from registers - perform the operation (in the data path); this may modify the PC register - store the results, usually...
  • Office of Aviation Safety Heli-USA Airways Aerospatiale AS350BA

    Office of Aviation Safety Heli-USA Airways Aerospatiale AS350BA

    Heli-USA Airways Aerospatiale AS350BA Haena, Hawaii Survival Aspects Nicole L. Charnon Passenger Safety Safety briefing video Personal Flotation Device (PFD) Seatbelt Headset PFD Donning Procedures Remove headset Don PFD Do not inflate PFD inside helicopter PFD Inflated Pilot and one...