Welcome! We will begin the webinar shortly. - PowerPoint Presentation

Slide1

Welcome!We will begin the webinar shortly.Dial in number is 1-866-764-6750Please use *# to mute your phone. You can unmute your phone using *#.Support at: datapipeline.support@cde.state.co.us Goal: Provide a weekly forum to answer LEA questions on Data Pipeline and inform LEA’s on any upcoming news and updates.

October 10th Town Hall

1Slide2

Webinar EtiquetteMute Your Phone (*# Mutes and Un-mutes Individual Phones)Enter your Name and your District when logging into the webinar (no password will be needed)For today’s event, we will hold the Q&A session at the end of the presentation:Type it in the Chat Box for a response ORRaise Your Hand:A presenter will call your nameAfter your name is called, un-mute your phone and speak your question/commentPlease be respectful of others time; we may need to have a separate conversation later to best help you

2Slide3

CDE Staff IntroductionsIntroductions 3Slide4

Interchange StatisticsFinance ReportsTSDL SnapshotStaff InterchangeStudent October Count RITS Contact List demoAgenda4Slide5

Interchange Statistics5Slide6

 Oct-3 - LEAs with RespondentsOct-3 - Number of Respondents

Oct-10 - LEAs with RespondentsOct

-10

- Number of Respondents

LEAs Submitted Files

RITS

Web

202

859

EDIS

Web

168

403

RITS

Pipeline169346171347  EDIS Pipeline164291164300  Directory171286172288  Student Interchange186427189423113 Staff Interchange18535419237411 Title I Interchange11722412222523 TSDL Interchange85160851591 Student October19046119345431 HR December175308177305ESSU IEP6012112

Number of Respondents and Submissions

6Slide7

Finance Reports7Slide8

Finance Reports – As Is8Slide9

Finance Reports – Enlarged Using Automatic Zoom9Slide10

Click the Print Icon:Click on Properties: Enlarging with Printing10Slide11

On the Printing Shortcut Tab select the appropriate Paper size and OrientationEnlarging with Printing (continued)11Slide12

On the Effects Tab select the appropriate percentageEnlarging with Printing (continued)12Slide13

 Printing ShortcutsEffectsReport Name

Paper Size

Orientation

% of Actual Size

Auditors Integrity

Letter

Landscape

113%

Bolded Balance Sheet

Legal

Landscape

100%

Charter School Auditors Integrity

Letter

Landscape

113%

Charter School Bolded Balance Sheet

LegalLandscape100%Child Nutrition Program OperatingLetterLandscape113%Finance December Error Detail LegalLandscape100%Finance December Error Detail Report - RollupLegalLandscape100%Grant ReconciliationLegalLandscape95%Indirect CostLetterLandscape108%Print Selections Recommendations13Slide14

Teacher Student Data Link Snapshot14Slide15

TSDL snapshot is now in the Pilot PhaseIf your district is interested in participating in this pilot (testing the TSDL Snapshot), please contact either:Chris Vance at vance_c@cde.state.co.us (303) 866–4383Lisa Bradley at bradely_l@cde.state.co.us (303) 866-4902To pilot the TSDL Snapshot, you will need to submit TSDL Interchange files, Staff Interchange files and Student Interchange Files for the 2012-2013 school year within the testing environment (QA).Teacher Student Data Link (TSDL) Snapshot15Slide16

Staff Interchange16Slide17

Excel, CSV or Text File all acceptedNeed 2 separate files:Staff File (similar to current Header File)Staff Assignment File (similar to current Detail File)1st record of data must be field names/titlesFile Layouts are different from last year- please review file layouts at: http://www.cde.state.co.us/datapipeline/inter_staff

Staff Interchange Slide18

Staff Interchange – Staff Profile18

Staff Profile File

Admin Unit/SOP Code

Staff's Race: American Indian or Alaska Native

Years of Prior Pre/K-12 Teaching Experience Out-of-State

Subject Area of Degree 3

Teacher Quality Standard 4: Reflect on Practice

School District/BOCES Code

Staff's Race: Asian

Years of Prior Pre/K-12 Education Experience In-State

Subject Area of Degree 4

Teacher Quality Standard 5: Demonstrate Leadership

Social Security Number

Staff's Race: Black or African American

Years of Prior Pre/K-12 Education Experience Out-of-State

Subject Area of Degree 5

Teacher Quality Standard 6: Student Growth

EDIDStaff's Race: WhiteYears Principal at any school Passed Paraprofessional TestPerformance Ratings Principal Overall Performance RatingStaff's First NameStaff's Race: Native Hawaiian or Other Pacific IslanderTeacher Probationary Status Passed NCLB HQ Approved Out Of State Elementary Or Early Childhood Core Content TestPrincipal Quality Standard 1: Stategic LeadershipStaff's Middle NameStaff's District of ResidenceHighest Level of Education CompletedState Approved Content Test Adminstered (outside of Colorado)Principal Quality Standard 2: Instructional LeadershipStaff's Last NameBeginning (start) Date at School DistrictInstitution Code of DegreeTeacher or Other Licensed Personnel Overall Performance Evaluation Rating from the Prior YearPrincipal Quality Standard 3: CultureStaff's GenderEnding (end) Date at School DistrictState Code of DegreeTeacher Quality Standard 1: Knowledge of ContentPrincipal Quality Standard 4: Human Resource LeadershipStaff's Date of BirthReason for Exiting District/Admin UnitSubject Area of Degree 1Teacher Quality Standard 2: Establish EnvironmentPrincipal Quality Standard 5: Management LeadershipStaff's Ethnicity: Hispanic or Latino Years of Prior Pre/K-12 Teaching Experience In-StateSubject Area of Degree 2Teacher Quality Standard 3: Faciliate LearningPrincipal Quality Standard 6: External DevelopmentPrincipal Quality Standard 7: Student GrowthSlide19

Staff Interchange – Staff Association File19

Staff Association File

Admin Unit/SOP Code

Job Classification Code

Grant/Project Funding Source

Grade Level - 6th

School District/BOCES Code

Start Date

Years Principal at this school

Grade Level - 7th

Special Education Assignment Flag

End Date

Grade Level - Infant

Grade Level - 8th

EDID

Employment Status Code

Grade Level - PreK

Grade Level - 9thStaff's First NameNumber of Contract DaysGrade Level - KGrade Level - 10thStaff's Last NameHours Worked per DayGrade Level - 1stGrade Level - 11thStaff's GenderHourly Rate of PayGrade Level - 2ndGrade Level - 12thStaff's Date of BirthBase Salary or WageGrade Level - 3rd24 Semester Hours Of Content Coursework In Teaching AreaSchool CodeTeaching Subject AreaGrade Level - 4thNumber of Classes Taught in SubjectSPED Staff Program CodeAdministrator/Instructional AreaGrade Level - 5thSlide20

Who will be submitting the staff files for Special Education Staff?District?District & Administrative Unit?Just the Administrative Unit?How will you address snapshot level errors?Staff Interchange Process PlanSlide21

The Staff Interchange opened on September 1We strongly urge you to begin submitting Staff Interchange FilesStaff Interchange SubmissionsSlide22

Afternoon sessions will cover all topics related to staff data collections:Staff InterchangeHuman Resources SnapshotSpecial Education December Count (Staff) AND Highly Qualified Online SystemPlease register if you have not already done so to attend! http://www.cde.state.co.us/datapipeline/train_scheduleIf not feasible to attend in person, webinars will be offered for each topic separatelyUpcoming Staff Training22Slide23

23Student October and Data Pipeline Count Challenges, Notes, Enhancements, and CelebrationsSlide24

Cognos reports: cannot export to Excel using Internet ExplorerWe are troubleshooting thisWork-around is to use Firefox to export Errors when non-primary (Primary School = 0) enrollment records with the same start and/or end date existsWe have a fix submitted to allow this (only for non-primary enrollment records)Student October Challenges24Slide25

Error sp384 has logic issues and is not working correctlyFELL students are triggering this errorDeleting a batch and appending dataIf using delete batch and append, duplicate errorsPlease use replace to work around this issueStudent October Challenges25Slide26

File upload in FireFox fails when using different file typesFireFox appears to store last file type loaded. This is causing problems when districts change file types on loadsPlease try a different browser or close and reopen the browserCognos reports modified fieldThe modified field indicates the last time a developer modified the report.Please ignore this fieldStudent October Challenges

26Slide27

New Cognos Report “Student October Contact List”This contains staff members with a role of LEAAPPROVERImportant: Each district needs a LEAAPPROVERStudent Interchange Error Detail and Error Summary Cognos Reports now contain an option to select a specific tag“Student Profile” ->“Edit Record” in Pipeline now has an option to search by Last NameStudent October Enhancements27Slide28

Exception requestsELL exceptionsWork with Morgan Cox, Title III Coordinator: 303-866-6784 or cox_m@cde.state.co.us First check student history – how was student reported in past and did the student take ACCESS for ELLs?All other exceptionsDemographicPlease provide SASID, District Code, Error Code (ex: SP111), and reason you are requesting the exceptionStudent School Association Please provide SASID, District Code, School Code, Error Code (ex: SP111), and reason you are requesting the exceptionStudent October Notes28Slide29

System continues to improveData Pipeline Celebrations29Slide30

RITS Contact List Demo30Slide31

How to locate RITS and EDIS contact listsSlide32
Slide33
Slide34
Slide35
Slide36
Slide37

303-866-6613Pulscher_D@cde.state.co.us Debbie Pulscher, RITS/EDIS Consultant, CDESlide38

38Data Pipeline – SupportSlide39

Thanks for sending your questions!Be sure to submit Data Pipeline area InterchangeSnapshot Year-round PeriodicReply to the help desk e-mail ticketPlease do not send separate e-mail on same topicCDE working to clear current back logContact us if not getting timely response

DataPipeline.Support@cde.state.co.us

39Slide40

40Website resourceshttp://www.cde.state.co.us/datapipelineSlide41

Thanks for joining us today! Have a great day! Next Town Hall: October 17th October 10th Town Hall

41