Data Warehouse/State Reporting February 9, 2018 Upcoming Data - - PDF document

2/12/2018 1

Data Warehouse/State Reporting

February 9, 2018

Upcoming Data Deadlines

Thursday, February 22  Data pull for Personnel Master File (PMF) purposes. Districts should verify data in SIRS‐320 Staff Snapshot and SIRS‐318 Staff Assignment. Friday, February 23 CEO Certification due on TAA for ePMF at https://eservices.nysed.gov/taa Thursday, March 22 The 2nd BEDS Day Student Enrollment Reports data pull  ELL counts data pull for Ed Facts for Federal USDOE Reporting (tentative)

2

2/12/2018 2

ePMF / TAA Reminders

Staff Assignment (SIRS‐318)

The data from this template is pulled 2 times a year: 1. Will be pulled on February 22 for Personnel Master File (PMF BEDS information ‐ all nonteaching staff (admins, directors, chairpersons, etc…) 2. Will be pulled again on June 14 to verify building principals for APPR. It links building principals to students enrolled in their buildings for APPR Staff Evaluation (growth score) purposes.

Certification of ePMF on TAA

1. The certification button is now available for administrators in TAA if your data is complete and accurate. 2. Administrators will have access to review and change data until February 22. 3. Superintendent SEDDAS account is the only account that can certify the ePMF data.

3

2nd Data Pull for Student BEDS Enrollment Reports

• March 22 is the second data pull that SED will prepare and send

the counts to State Aid and other agencies.

• Districts have until August 2018 to certify the accuracy of the

data.

• Districts should compare the snapshot reports (.1) in January to

the current reports to see if anything changed

• SED will use the counts pulled on March 22 to submit FRPL data

to the Feds for use in EDFacts. *SIRS‐323 Free and Reduced Price Eligible Students enrolled on BEDS Day *SIRS‐313 Location of Enrollment and Subgroup – Check accountability subgroups. Students in a subgroup for 1 day get counted.

4

2/12/2018 3

L2RPT BEDS DAY VERIFICATION REPORTS

SIRS‐313 BEDS Enrollment Verification Report by Location of Enrollment and Student Subgroup

• Determines State Aid by Total Enrollment counts
• Also shows totals for accountability subgroups
• No PS, GED, homebound, home schooled, or OOD students

SIRS‐316 BEDS Enrollment Verification Report for District Pre‐K

• Shows counts for Pre K and UPK and Other Universal Pre‐K grant funding

SIRS‐323 Free and Reduced Price Lunch Eligible Students Enrolled on BEDS Day

• Shows which students were eligible for FRPL on BEDS Day

SIRS‐314 BEDS Enrollment Verification Report by District of Residence

• Shows Total Enrollment counts by District of Residence, so you can see which students your district may be

able to charge for tuition.

SIRS‐312 BEDS Enrollment Verification Report for State Aid

• Shows in more detail which of your students are enrolled out of district – (you pay for their transportation

and textbooks)

• Shows which students are from other districts (tuition paid to your district)

SIRS‐319 BEDS Enrollment in Public and Charter Schools

• Shows in more detail which of your students are enrolled out of district – (you pay for their transportation

and textbooks)

• Shows which students are from other districts (tuition paid to your district)

5

Example of a (.1) BEDS Day Snapshot Report

• The SIRS‐323 report displays the most recent data, which

includes any changes or updates since the last data pull. This report will continue to refresh throughout the year, as you make your corrections.

• The SIRS‐323.1 will be the data pulled on the January 4

“Snapshot Date” and sent to State Aid.

• After March 23, the SIRS‐323.1 will be updated with the counts

from the March 23 data pull.

6

Current Data Snapshot Data

2/12/2018 4

QUESTIONS ON DEADLINES??

7

Level 0 Updates

• 1. Inoculation Date, Country of Origin, Date of Entry to US

removal from demographics template.

• 2. Changed PS3129 Information message to: CARRYOVER

eligibility is only available for the first 30 days of the school year or for 30 days after a student transfers from a CEP to a non‐CEP school – Please review.

• 3. The NYSITELL V2 records are not being accepted with this

release, into Assessment or Assess/Mod/Fact. You will receive a message upon import (manual) of any records ignored, in the Import/Validation Messages. It is anticipated that V2 records will be allowed to be imported in the 13.02 release due out in mid‐March.

2/12/2018 5

Level 0 Historical

• Grand opening of level 0 Historical

for 2016‐2017 data is February 6

9

Creating Level 0 User

• Creating a account for ASAP in level 0 for the new NYSITELL test

10

2/12/2018 6

EVER ELL / FORMER ELL

SIRS‐401 Reasonableness: ELL Eligibility Codes 0232 & 0233?!

0232 :: Former ELL Student & 0233 :: Ever ELL Student are SED‐calculated fields.

These codes are not submitted by LEAs and are not subject to LEA verification &/or

• certification. They are based upon historical data (previously certified by LEAs).

12

2/12/2018 7

SIRS‐401 Reasonableness: ELL Eligibility Codes 0232 & 0233?! (cont’d)

13

M2L1C Review

14

2/12/2018 8

M2L1C Report – Tips & Tricks

• 1. DM prefix: Demographics | Student Data Domain in M2L1C Error Reporting
• 2. DM0003: State Student ID is Blank ‐‐ No current year NYSSIS ID in L1 or L2…yet.
• 3. DM0007: *Warning* LV1 NYSSIS_ID ≠ LV2 NYSSIS_ID – There is a current year

NYSSIS ID in LV2 (often associated with another LEA) and the NYSSIS ID in LV 1 is null/ blank. OR, there is an updated NYSSIS ID in LV2, via (another LEA or SED) Unlink action that has not been processed locally (much less common).

• 4. Want to limit the # of DM0003 & DM0007 errors? Submit Student & School

Entry Exit data to LV1 prior to Thursday, when possible.

• 5. Recurring DM errors week‐to‐week? Check your NYSSIS queue and/or EE (?)

errors.

15

M2L1C Report – Tips & Tricks (cont’d)

SS‐Special Ed Staff Snapshot DA‐Student Daily Attendance (Stud_Attend_Day)

These are basically the same type of error. Reworded in newer templates, e.g., Student Daily Attendance (DA) Such errors are usually indicative of: A) No NYSSIS ID. Just a compounding of previous DM0003 or DM0007 errors. B) Missing or Invalid Enrollment record.

16

2/12/2018 9

M2L1C error logs

Here are some typical error that are found in the staff snapshot.

• The SN0008 is the result of a invalid staff id. Please check the TEACH

system for the correct id.

• The SN7313 is because an BEDS # is not active or valid in SEDREF.

CIA typical error

• Staff must be Teacher in the Teacher title.
• In staff snap the status is set to delete and have associated CIA records.

17

M2L1C Error Logs

Typical errors in staff tenures

• ST8111 Prob. End date not permitted with Deleted status
• ST8120 invalid tenure area code is usually that the staffsnap

have teacher in title

18

2/12/2018 10

M2L1C Error Logs

Warnings sometimes point to another data type or trickle down effect

19

M2L1C Error Logs

20

2/12/2018 11

NYSED Updates

1. Data Quality Discussion 2. Homeless Indicator

• Homeless indictor will be going away starting in 18‐19, and a

program service code will be used. If a student is assigned this PS code at any time on the school year, they will be considered as part of the homeless subgroup. 3. McKinney‐Vento

• NYSED was audited by the Federal Gov’t for MV. Some of the

findings indicate that districts must document the process of how the district identifies these students. NYSED is required to add a section to the SIRS manual and create business rules. NYSED will also create technical assistance documents and post it on the website. 4. PS code 8271 – “Working toward a CDOS Credential”

• The wording needs to be changed to “Working towards CDOS

Eligible Coursework” that may be used towards a stand‐alone credential.

21

NYSED Updates

5. Data Reporting for Military Children

• “…principal of the New York school shall accept any

corresponding alternative end of course local examination for such course(s), where the principal from the school in the sending state attests in writing that the student has achieved a score on such exam that meets the proficiency standards for the course assessed in the sending state…”

• See our website for FAQ

6. Immigrant Data Collection Changes

• “…Districts are instructed, effective immediately, to cease collecting and

reporting to NYSED data about students’ dates of entry into the United

• States. Prior school enrollment (including the length of time within the United

States school system) will be used in lieu of ‘date of entry’ to facilitate NYS’s immigrant student count under Title III.”

• “…Districts are instructed, effective immediately, to cease collecting and

reporting to NYSED data about students’ countries of origin…”

• What they are trying to determine is the about the amount of education the

student has received in the US. You can ask that question, to determine if the student has had 3 years of education in a US school.

• You will not get an error if your system still exports this information. It simply

will not load into Level 0, it will not error.

22

2/12/2018 12

Immigrant Data Collection continued…

• B3. How should districts collect data for purposes of determining Title III immigrant children and

youth program eligibility and providing information for within‐state allocations under Title III? To determine whether or not a student meets the Title III definition of an immigrant child and youth, a school and/or district should not ask about a student, parent, guardian, or sponsor’s citizenship or immigration status or date of entry into the United States. Such information has no bearing on whether or not the student meets the definition of immigrant child or youth for Title III purposes, and may create a chilling effect that could discourage students and families from enrolling in school. Rather, for purposes of determining if a student meets the definition of immigrant children and youth under Title III, a school should request only information about a student’s date of birth, place of birth, and prior school enrollment.

• First, in seeking such information, the school and/or district should note in writing that providing the

information is not required and that the requested information will only be used to determine whether the child may be eligible for programs offered in the district that provide enhanced instructional

• pportunities for immigrant children and youth.
• Second, the school and/or district should determine whether a student meets the first two criteria of

the definition of immigrant child or youth (confirming age and birth outside the United States). In collecting such information, schools and/or districts should pose the same question of all students and ensure that the information is not used to discriminate against students in any way.

• Finally, only after determining that a student meets the initial criteria for Title III eligibility should the

school and/or district then ask questions to determine the total cumulative number of months that the student has attended schools in the United States. *See memo and fact sheet on our website for more information

23

NYSED Updates

• 7. Updates to FRPL
• Clarifications
• Carryover is only reported when the prior year eligibility is

NOT known. If the student was eligible, you can keep them as eligible for 30 days.

• Every time an eligibility changes, it does not be reported.
• What Does Need to be Reported :

1. When a student becomes DCMP. Schools need to report this. But after this, they do not need to know any other changes. 2. Student moves from carryover to non‐carryover eligibility. Report only 1 carryover. 3. If a student begins the year as carryover and turns to application, then you only need to show these 2 changes. 4. If a student begins the year as carryover and turns to application, then also goes to DCMP, then you need 3.

24

2/12/2018 13

NYSED Updates

• 8. Out of School Suspensions

(OSS)

OSS will be collected on the SIRS‐351 Student Daily Attendance Report and will provide baseline data for an accountability indicator under ESSA.

25

Questions?

26

2/12/2018 14

NYSED PUBLIC DATA RELEASES

27

• 1. Reward Schools
• 2. Graduation Rate

Identification Methodology for Reward Schools based on 2016‐17 Assessments http://www.p12.nysed.gov/accountability/ESEAM aterials.html

28

First, read and understand the methodology and calculations behind it

2/12/2018 15

The Basics for a Reward School

To be identified as a Reward School, a school must: 1. Be among the top 20 percent of schools in the state for English language arts (ELA) and math performance for both the 2015‐16 and 2016‐17 school years or be among the top ten percent of schools in terms of gains in ELA and math performance in the 2016‐17 school year; 2. Have made Adequate Yearly Progress for the 2015‐16 and 2016‐17 school years for all groups of students on all measures for which the school is accountable, including the requirement that 95 percent of all groups participate in the English language arts and mathematics assessments; and 3. Not have unacceptably large gaps in student performance

• n an accountability measure between students who are

members of an accountability group (e.g., low‐income students) and students who are not members of that group.

• http://www.nysed.gov/news/2018/commissioner‐identifies‐

155‐high‐achieving‐and‐high‐progress‐schools‐reward‐ schools

29

Can’t be a Reward School if you do not have the 95% Participation Rate for 2 years

30

Then, you must decipher a spreadsheet with columns that go up to AW

2/12/2018 16

Reward Schools – Why Not My High School?

• 1. First, look at the NYS School Report Card for your

High School at https://data.nysed.gov/reportcard.gov

• 2. Click on School Report Card, and select Secondary

ELA and math

31

Reward Schools – Why Not My High School?

• 1. ELA comes up first.
• 2. Next comes Mathematics
• 3. Why do think this is?
• 4. Let’s check the SIRS‐101 HS AVR Report

32

2/12/2018 17

SIRS 101 HS AVR Report – High School Building Only – Math 2016‐17

*Lets look at level 2 and level 3 from last year.

33

SIRS 101 HS AVR Report – High School Building Only – Math 2015‐16

*16 students in one year dropped from a Level 3 down to a Level 2. Why?

34

2/12/2018 18

Assessments That Can Be Used To Fulfill the Performance Criterion in Secondary‐Level Math for 2016‐17

35

April 2017 http://www.p12.nysed.gov/irs/accountability/home.html

36

How Assessments Are Used To Fulfill the Performance Criterion in Secondary‐Level Math 2015‐16

The highest performance level a student receives on an assessment, regardless of when it is taken, is counted in the PI calculations. Students who do not take an assessment are counted as performing at Accountability (Acc) Level 1.

Assessments Eligible Students Accountability Level/Score Regents Examinations in Mathematics All students (general education & students with disabilities) Acc Level 4 (90–100) Acc Level 3 (80–89) Acc Level 2 (65–79) Acc Level 1 (0–64) Regents Common Core Examinations in Algebra I and Algebra II* All students (general education & students with disabilities) Acc Level 4 (85–100) Acc Level 3 (74–84) Acc Level 2 (65–73) Acc Level 1 (0–64) Regents Common Core Examinations in Geometry* All students (general education & students with disabilities) Acc Level 4 (85–100) Acc Level 3 (80–84) Acc Level 2 (65–79) Acc Level 1 (0–64) Approved Alternatives to Regents Examinations in Mathematics All students (general education & students with disabilities) Acc Level 3 (Pass) Acc Level 1 (Fail) Regents Competency Test in Mathematics (and Approved Alternatives) Students with disabilities Acc Level 1 (Pass/Fail) New York State Alternate Assessment in Mathematics (Secondary Level) Students with severe cognitive disabilities Acc Level 4 (Level 4) Acc Level 3 (Level 3) Acc Level 2 (Level 2) Acc Level 1 (Level 1) *Common Core Regents examinations have 5 performance levels for annual reporting but 4 Accountability performance levels for accountability determination. For more information, see the SIRS Manual at http://www.p12.nysed.gov/irs/sirs/home.html.

36

2/12/2018 19

Math Accountability Levels Comparison 15‐16 /16‐17

37

NYSED’s Graduation Rate Press Release

38

2/12/2018 20

L.I. vs Rest of State (ROS) Grad Rates

39

Long Island school districts are graduating students above the rest of the state.

2/12/2018 21

2016‐17 Graduation Rate Press Release

• 1. Where do I find it?
• HS Graduation Rate will be displayed for the public
• n the https://data.nysed.gov/ site.
• 2. Where does the data come from?
• This data comes from the SIRS‐201 Total Cohort

Report that your district certified in August 2017.

• 3. This data is frozen at this point and cannot be

changed.

• 4. The HS Grad Rate defaults to 4‐year June Cohort. Can

go into “Filter this data” to see 5 and 6 year Cohorts.

41

Report Card Filters

• The HS Grad Rate defaults to 4‐year June Cohort.
• Click on Filter this data to get August or 5 & 6 Year

Cohorts.

42

2/12/2018 22

• 2. Where does the data come from?
• This data comes from L2RPT the SIRS‐201 Total Cohort Report that

your district certified in August 2017.

• Column (b) Cohort Enrollment as of June – at this point in time, check this

column on your current report to make sure all 12th graders are listed here.

43

One or two incorrect kids make a difference

Which Diplomas are Included in the Graduation Rate?

Graduates

Include students who received a local diploma or a local diploma with Regents endorsement (Regents diploma). All students who received a Regents diploma (with or without Advanced Designation or CTE Endorsement) are included in the number of students with Regents diploma.

44

(C= D+E+F) Total Number of Graduates = Local Diplomas + Regents Diplomas + Regents Diplomas with Advanced Designation IEP Diplomas CDOS credentials are not included in the Graduation Rate

2/12/2018 23

Reports That Count Graduates in L2RPT

1. Total Cohort Summary – SIRS‐201 Run This Now

• Displays counts of who is included in the cohort.
• Someone who is familiar with graduating students

should verify that this count includes only your current 12th graders.

• Can also run this list for 11th graders.
• Is your Press Release Graduation Rate for next year

2. Total Cohort Assessment Summary – SIRS‐202

• Run this to see 10th, 11th and 12th graders missing

regents assessments in L2. Can give this list to principals or guidance. Missing Regents affect your PI, which may affect your Reward School status.

45

The Importance of Data Teams and Verifying Data

NYS Data State Aid Federal Gov’t Reporting Reward School TSI / CSI NEWSDAY

Level

L2RPT

Verify Verify Verify

NYSED

46

2/12/2018 24

Any Questions?

• Press release for 2013 Cohort Graduation Rate

http://www.nysed.gov/news/2018/state‐education‐department‐ releases‐2013‐cohort‐high‐school‐graduation‐rates

• Determining AYP in 2016‐17

http://www.p12.nysed.gov/irs/accountability/home.html

• SIRS Manual Chapter D: New York State Accountability

http://www.p12.nysed.gov/irs/sirs/

47

ESSA and Accountability Updates

48

• 1. Climate Survey
• 2. ESSA Update
• 3. T.E.D. Reports

2/12/2018 25

Climate Survey‐ Update

• Nassau has 4 districts piloting the survey to parents, students,

teachers and non‐teachers.

• West Hempstead, Rockville Centre, Glen Cove and Merrick – THANK YOU
• 2018‐2019 open to all‐ no date as to “mandate” yet.
• Using USDOE platform may have vendor options as well.
• Information www.nassauboces.org/statereporting ‐ School Climate

Survey page.

49

ESSA update

• All Opt outs will be counted as level 1.
• New ESSA PI Calculation

(L2+L3*2+L4*2.5)* 100 = numerator 95% of Continuously Enrolled Students Or Continuously Enrolled Tested Students whichever is higher

• f Nassau it will be 95% or Continuously Enrolled Students.

ELA

50

2/12/2018 26

ESSA update

• All Opt outs will be counted as level 1.
• New ESSA PI Calculation

(L2+L3*2+L4*2.5)* 100 = numerator 95% of Continuously Enrolled Students Or Continuously Enrolled Tested Students whichever is higher of Nassau it will be 95% or Continuously Enrolled Students.

Math

51

ESSA Combines ELA & Math to create the new Performance Index

Accountabil ity Group Subject # of Continuousl y Enrolled Students # of Continuousl y Enrolled Tested Students # Level 1 # Level 2 # Level 3 # Level 4 Numerator Denominator PI All‐Students ELA 199 69 5 21 37 6 110.00 189.05 58.1856 All Students Math 199 81 4 17 27 31 148.5 189.05 78.5506 All Students 398 150 9 38 66 37 258.50 378.10 68.3681 52

2/12/2018 27

2018 Parent Letter Service Changes

• All color one price with all letters in one envelope

53

T.E.D. Reports

Tailored Educational Data Reports

• Continuous enrollment – diploma type report ‐
• Longitudinal regents exam pass and performance rates
• ELL growth matrix reports‐
• NTPP reports‐ non‐teaching professional profile
• ESSA outlook reports – Long term goals‐ MIP reports
• Comparison reports
• Just ask…

54

2/12/2018 28

T.E.D. Longitudinal Graduation Reports

• Here is and example of one report that is included in a full suite of

reports that BOCES offers in the TED report package.

• District Continuous Graduation report
• County Continuous Graduation report

55

Customized L2 Report Training

• Principals (Elementary, Secondary), Guidance staff
• Accountability data, attendance data, graduation requirement data
• Data Teams
• Provide clarification of report interpretation
• Taking requests for reports and trainings for 2018‐2019

56

2/12/2018 29

QUESTIONS??

57

We need you!

Nassau BOCES is looking for full and part time data personnel – consultants welcome. Please contact Audre Midura @ amidura@nasboces.org for more information

58

2/12/2018 30

• Phil DeGrazia: 832‐2815

pdegrazia@nasboces.org

• John Cahill: 832‐2860

jcahill@nasboces.org

• Vivian Tripi: 832‐2794

vtripi@nasboces.org

• Mona Baldauf: 832‐2768

mbaldauf@nasboces.org

• Ted DeRidder
• Audre Midura: 832‐2718

amidura@nasboces.org

• Margarita Pieri: 608‐6673

mpieri@nasboces.org

59

Nassau BOCES DW Contacts