April 26th Student October

1. April 26th Student October • Purpose • Goal – Review Student Interchange and Student October issues and fixes Support at: datapipeline.support@cde.state.co.us 1

2. Webinar Etiquette • Mute Your Phone (*# Mutes and Unmutes Individual Phones) • Enter your Name and your District when logging into the webinar (no password will be needed) • If you have a question or comment either: • Type it in the Chat Box for a response OR • Raise Your Hand: • A presenter will call your name • After your name is called, unmute 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

3. Login issues You are not authorized to use this application! Contact administrator and provide message: <ERROR CODE> • This error indicates problem with identity management. • Please email to screen shot to • datapipeline.support@cde.state.co.us 3

4. Beginning in 2013-14, we will use the Title I Data Interchange for reportingTitle I Targeted Assistance (TA) Data

5. Title I interchange • Group name is TI1 LEAUSER • <district name> PIPELINE-xxxx-TI1~LEAUSER Submit and Modify Role • This interchange is used to identify Targeted Assistance students • Used to set the title I status in the Student October interchange • Not used for the school wide students. These are set based on information from Federal Programs 5

6. Title I interchange Elements 6

7. These all will be collected through the Title I Interchange 7

8. If you have TA schools and want to participate in the pilot, get the form at: http://www.cde.state.co.us/rise/ADEReplacement-Participation.asp If you have TA schools and want to learn more about the Title I Data Interchange, feel free to join any of the following webinars next week (call-in number: 1-866-684-8605) April 26, 1 pm, http://connect.enetcolorado.org/r4rx1z1lzx7/ 8

9. Questions? Donna Morganstern303-866-6209morganstern_d@cde.state.co.us 9

10. File loading order • Files need to be loaded in order • Student Demographics • Student School Association • Advanced Course Completion • Title I file – Targeted Assisted students • Home School form • Link to access system: • https://cdx-test.cde.state.co.us/pipeline/login.action 10

11. Common File loading issues • Open spreadsheet and error on the file upload. - (Fix close spreadsheet before loading) • Blank rows in spreadsheet – (Convert to CSV and use note pad) • Extension Important – text file must end in .txt, comma separated - .csv 11

12. Common issues • Unable to find a record with error in edit screen – Use the go to standard view button or reports. • Make sure to set the primary school flag 12

13. New items April 26th • Snapshot was not pulling students enrolled on Count Date – Fixed • Exception processing need to include warning sp180 - Student does not follow logical sequence for ELL. Last year they were marked as being in an ELL program and this year they are marked as Not Applicable. 13

14. New items April 26th • Problem on Student October Snapshot records report – not all schools are choices • Work around – do not select any schools and press finish • File extract download for Student October matches the documentation now. Columns were in wrong format. 14

15. New items April 26th • File extract download for Student October matches the documentation now. Columns were in wrong format. • Expelled students will need entry date for when the start receiving services and exit date for when those services end or the student comes back to school 15

16. Rules not working correctly • Problem with rule sp373 and the primary school flag. • Student may only contain one primary school in a district. • Changed to a warning 16

17. Rules not working correctly • Rule OC14 is firing and shouldn’t be – Changed this to a warning. • At least one school within your district has been approved to provide online education services as a single district online program, but none of the students in your district have been reported funding code 91 (Full Time On-line - Single District On-line Program) or 94 (Part Time On-line - Single District On-line Program). 17

18. Rules not working correctly • Rule OC68 - If language proficiency is 4 or 5, then prior's year language background needs to be eng. Or be the same as this years language background 18

19. Rules not working correctly • Rule OC11 – Duplicate SASID reported incorrectly. • Rule OC1 – Not working correctly for students with third party contracts. This is not identifying public schools correctly. (4/23/12) 19

20. PowerSchool users • With this we then realized the extract is truly not formatting properly.  Long story short I exported data on my own and it is working fine.  We will get with Pearson to resolve the issue with the built in extract. (This was done on MAC) • Free and reduced lunch codes • Leading zeros not coded correctly on school code 20

21. Issues identified • Language background “ach” is missing from language table. - Fixed • Error message incorrect – rule SP66 - Fixed 21

22. District Feedback 4/23 When I do Format Checker and click upload.....the file hangs.... If I click upload again it goes through. The same thing seems to happen when I do the Data File upload also. FYI....I am working on a MAC. Don't know if that matters.... 22

23. District Feedback • Edit screen is not user friendly on large data sets. • Cognos emailing of reports is not working. – Please send issue to me. If seeing this. 23

24. District Feedback • Cognos report and export to excel does not work. Just spins. • This is more than likely a browser configuration issue. Please email datapipeline.suport@cde.state.co.us and we will email configuration for broswer 24

25. District Feedback • PL/SQL error taking snapshot. • Title I does not appear correct – Defect on preschoolers not getting marked for Schoolwide title I. This will be corrected by including the title I schools with preschool programs. 25

26. How long will pilot run? • Until September. • We will not have daily webinars, but I will support districts who would like to pilot. Support at: datapipeline.support@cde.state.co.us 26

27. Questions??? Thank you 27

28. Changes in file values • Free and reduced lunch values are now • 00 – Not eligible • 01 – Free • 02 – Reduced • No longer a valid code • 03 – No longer valid (used to be not eligible) 28

29. Changes in file values • All race/ethnicity field values • 0 – False for this race/ethnicity • 1 – True for this race/ethnicity 29

30. Changes in file values • Primary school flag needs to be set • 0 – False this is not student’s primary school • 1 – True this is the student’s primary school 30

31. Page Not Found – Need IP address • This error indicates a problem with IP address • Go to www.whatismyip.org and email to • datapipeline.support@cde.state.co.us 31

32. Not a lot to report • Not a lot to report because people were unable to login. • New group available for the title I interchange. • PowerSchool files do not have free and reduced lunch value coded to new format. • Error report may not return with 100,000 errors • Use summary report or validation screen 32

33. Good news • Multiple districts loaded data • Respondents are able to login • Districts are creating snapshots • Seeing good performance on loads • Districts are using Cognos reports 33

34. Demo of loading files • Review file upload • Creating snapshot • Review reports • Link to access system: • https://cdx-test.cde.state.co.us/pipeline/login.action 34

35. Questions??? Thank you Town Hall Tomorrow Next Webinar: Friday, April 26th 9:00 – 10:00 35

36. Information slides Slides after this are for examples and problems which existed prior to the pilot 36

37. Login error OIDSY0001 You are not authorized to use this application! Contact administrator and provide message: OIDSY0001 • This error indicates the groups have not been assigned to your • account • Please work with your local access manager in your district to • assign the following roles to your account. • <district name> PIPELINE-xxxx-STD~LEAUSER Submit & Modify role • <district name> Pipeline-xxxx-OCT~LEAAPPROVER Approver role 37

38. Login error OIDAR005R You are not authorized to use this application! Contact administrator and provide message: OIDAR005R • This error indicates an invalid group is assigned to your account • Please work with your local access manager to remove the • pipeline groups associated with CBD or EOY 38

39. Login error OIDAR003O You are not authorized to use this application! Contact administrator and provide message: OIDAR003O • This error indicates a problem with the group configuration • Please email this datapipeline.support@cde.state.co.us 39

40. Introductions • Kevin Smith Support at: datapipeline.support@cde.state.co.us 40

41. Page Not Found – Need IP address • This error indicates a problem with IP address • Go to www.whatismyip.org and email to • datapipeline.support@cde.state.co.us 41