heading
Follow us on twitter Follow us on pintrest Follow us on linkedIn Follow us on instagram Follow us on Flickr
log in Events
Data Warehouse
Jeremy Dodds
Project Manager
jdodds@cnyric.org
315-433-2217
Lori DeForest
Supervisor of Data Analysis Services
ldeforest@cnyric.org
315-433-2247
Data Warehouse Home
Test Scoring
CNYRIC Services
Documents
Important Websites
Data Tools
FAQs
RtI
Meet the Team
 
Documents & Resources
Meeting Handouts
Find documents that have been distributed during Data Warehouse and CNYDAC meetings.
Data Documents
Important documents such as Data Administrator Tools, Codes and Definitions, Templates and more.
Websites
Resourceful websites including Information and Reporting Services, NYS Report Cards, NYSTP Assessment Tools, DATAG and more.
Data Tools
Popular links to tools such as Cognos, NYSSIS, SEDREF, Level 0 and more.
FAQs
Answers to the most commonly asked Data Warehouse Questions.
Response to Intervention (RtI)
Help Documents, RtI Websites, Digital Tools, AIMSweb, RTIM, StarPresentations, and more.
About Data Warehouse
Overview of the Data Warehouse team
 
Recent Updates  
Find details about recent updates
5/9/17 The Common Data Views - ELA and Math 3-8 reports have been modified to prevent them from running for 2017 until the data has been released by SED.
5/9/17 Cognos: The District - Location Table Validation report has been modified to include an optional prompt for open or closed locations.
5/5/17 Cognos: The Student Achievement cube has been updated for 2017 marking period 5 of 6.
5/2/17 Cognos: The Medicaid cube has been updated for the 4/17/17 remittance.
4/25/17 Cognos: The BOCES Assessment - Summary by Standard Met report and its drill through report have been modified to group and list by enrollment BOCES/location, rather than by home BOCES/district.
4/21/17 Cognos: L2RPT - SEDDAS updates applied. Added a new column to SIRS-301 Tested/Not Tested Confirmation Report and SIRS-302 Tested/Not Tested Confirmation All Assessments Report for Refusal Counts. Added the ability to run to Excel Data for SIRS-103 NYSESLAT Participation for Recently Arrived ELL Students Report.
4/7/17 Cognos: L2RPT - SEDDAS update applied. Added a new column to SIRS-308 Annual Graduation & Post Graduation Plans Report for seal of biliteracy.
4/6/17 Cognos: The Medicaid cube has been updated for the 3/20/17 remittance.
3/31/17 Cognos: The Student Achievement cube has been updated for 2017 marking period 3 of 4.
3/27/17 Cognos: The Demographics - Invalid Home Language report has been removed, as it is no longer needed due to Level 0 checks or SIS defined parameters.
3/27/17 Cognos: The "Scatter Plots" folder and its two reports have been replaced by the "Common Data Views - Scatter Charts" folder and one combined report, "Scatter Charts: School Report Card Scores".
3/23/17 Cognos: The BOCES CRDC reports have been updated to exclude ELEARNING and to count program service data based on district rather than BOCES data.
3/9/17 Cognos: The Medicaid cube has been updated for the 2/20/17 remittance.
2/22/17 Cognos: The Student Achievement cube has been updated for 2017 marking period 4 of 6.
2/15/17 Cognos: The NYS Secondary Assessments cube has been updated for mid-year 2017 (Cohort Year 2014).
2/14/17 Cognos: There are now two sets of BOCES CRDC Reports. One can be run by BOCES. The other can be run by Location. One set or the other is to be used, depending on how each BOCES needs to report their data in the CRDC application.
2/10/17 Cognos: The Student Achievement cube has been updated for 2017 marking periods 2 of 4 and 3 of 6.
2/8/17 Cognos: L2RPT - SEDDAS update applied. Added new report SIRS-330 Student Class/Course Instructor Summary Report into the Course folder, along with two detail reports.
2/6/17 Cognos: The CRDC reports are now available for the 2015-16 Civil Rights Data Collection.
2/1/17 Cognos: L2RPT - SEDDAS update applied. Revalidated and saved the reports due to issues with some drill downs on the SIRS-320 report. Model updates for future SIRS-330 Student Class/Course Instructor Summary Report.
1/31/17 Cognos: The Medicaid cube has been updated for the 1/16/17 remittance.
1/24/17 Cognos: Modified the Assessment Response Analysis report to display either response given or points earned, based on a new prompt. This eliminated the need for the Assessment Response Analysis with ones report, which has been removed.
1/23/17 BARS: Applied an update to fix a potential error when running the Released Questions Performance report
1/18/17 BARS has been updated to the latest release. This update includes the following 2016-17 August Regents (all subjects) reports: Group Item Analysis, Individual Extended Response, Individual Item Analysis. The 2016-17 data will be available on 1/23.
1/13/17 Cognos: L2RPT - SEDDAS update applied. Modified Footnotes on SIRS-315, SIRS-320, SIRS-313 and SIRS-313.1. Added a new report in the Annual Outcomes folder called SIRS-335 Career Pathways Verification Summary Report. Updated the model for the new SIRS-335 Career Pathways Report. Added Diploma Type Description to the Career Pathways Detail.
1/6/17 Cognos: The Medicaid cube has been updated for the 12/19/2016 remittance.
1/6/17 Cognos: Corrected the location of the image files for the L2RPT reports, so that the Score Reports display properly.
12/22/16 Cognos: Cognos has been updated to version 10.2.2 (fix pack 7).
12/20/16 Cognos: L2RPT - SEDDAS update applied. Updated the SIRS-301, 302 and 104 Tested / Not Tested Detail reports to be ELL instead of LEP.
12/20/16 Cognos: Modified the Enrollment - Missing PK/UPK Program report to run for all years >= 2012.
12/19/16 Cognos: L2RPT - SEDDAS update applied. Added the SIRS-701 Unique Identifier Audit System Summary and Detail reports.
12/16/16 Cognos: The Student Achievement cube has been updated for 2017 marking period 2 of 6.
12/8/16 Cognos: L2RPT - SEDDAS update applied. Updated the L2RPT-SEDDAS model to include tables for the new SIRS-370 Day Calendar Summary Report; Updated footnotes on SIRS-315 and SIRS-201 detail reports; Added the new SIRS-370 Day Calendar Summary Report into the Attendance folder; Renamed the SIRS-103 NYSESLAT Participation for Recently Arrived ELL Students Report, to remove "LEP".
12/8/16 Cognos: The Medicaid cube has been updated for the 11/21/16 remittance.
12/2/16 BARS has been updated to the latest release. Reports updated: 2015-16 NYS ELA and Math: Comparison of Performance. 2015-16 Regents (all subjects): Frequency Distribution All Districts Detail. 2016-17 August Regents (all subjects): Frequency Distribution; Rank List. The 2016-17 data will be available on 12/5.
11/28/16 Cognos: The Student Achievement cube has been updated for 2017 marking period 1 of 4.
11/17/16 Cognos: Updated the Regents cubes to include 2016 data, now that the embargo has been lifted. There is a new Regents Common Core Algebra II Item Analysis cube.
11/1/16 Cognos: Updated the Medicaid cube for the 10/17/2016 remittance.
10/31/16 Cognos: L2RPT - SEDDAS update applied. Added Out of District Placement version of NYSAA Score Report; Added Out of District Placement version of NYSESLAT Score Report; Added SIRS-503 Score Report - NYSESLAT; Fixed column headings on SIRS-325 Staff Evaluation Rating Verification Detail Report; Added footnote to SIRS-102 Elementary/Middle-Level Accountability Data Verification Report; Columns containing estimated calculations will only be populated if the user chooses "All Grades".
10/28/16 Cognos: The Student Achievement cube has been updated for 2017 marking period 1 of 6.
10/21/16 Cognos: Renamed the Program Service - Summary LEP  report to Program Service - Summary ELL and modified to handle new program types.
10/19/16 Cognos: Cognos has been upgraded to version 10.2.2 (fix pack 6). The new Cognos website is:   https://cog1022.cnyric.org
10/7/16 Cognos: Modified the NYS Assessment Item Responses per Student report to correct the totals.
10/6/16 Cognos: Updated the Medicaid cube for the 9/19/2016 remittance.
10/3/16 Cognos: L2RPT - SEDDAS update applied. Updated Many reports to rename [LEP] Limited English Proficient headers to be [ELL] English Language Learners; Fixed the School_Year prompt sort order on SIRS-324, SIRS-360, and SIRS-361; Updated the SIRS-405 report to make the school year in the footer dynamic; Added the NYSAA Score Report. This report requires images be copied to your application and web servers.; Updated the Static Choices for the District and Location Prompts on the reports to use -99 instead of 0 as the default value.
9/28/16 BARS has been updated to the latest release. Reports updated: NYS Frequency Distribution by Teacher report for ELA and Math 3-8.
9/26/16 Cognos: The College Tracking Top Schools report has been modified to page break by District, when All CNYRIC or All … BOCES is selected.
9/26/16 Cognos: The Preliminary/Embargoed cubes for Science 4 and 8 Scores and Item Analysis have been updated to include 2016 data.
9/15/16 BARS has been updated to the latest release. Reports updated:  Extended Response Analysis; Group Item Analysis; Group Item Analysis All Tested. The 2015-16 data will be available on 9/19.
9/14/16 Cognos: The BOCES Assessment - Summary by Standard Met report and it's drill through have been rewritten to include all NYS, NYSAA, NYSESLAT, and Regents exams.
9/14/16 Cognos: The following reports have been modified to exclude the 2016 dropped items (Math 5 Item 30 and Math 6 Item 24):  Item Difficulty and Response Gap Analysis; Longitudinal Item Difficulty Gap Analysis; NYS Assessment District Item Distracter Report; NYS Assessment Item Responses per Student; NYS Assessment School Item Distracter Report; NYS Assessment Skills Analysis per Student; NYS Content Strand Analysis.
9/1/16 BARS has been updated to the latest release. Reports updated:  2015-16 Regents Frequency Distribution by Teacher (all subjects).  The 2015-16 data will be available on 9/5.
8/30/16 Cognos: Updated the Medicaid cube for the 8/15/2016 remittance.
8/25/16 BARS has been updated to the latest release. Reports updated: 2015-16 NYS ELA: Individual Item Analysis; Student List; Student Profile.  2015-16 NYS Math:  Individual Item Analysis; Student List; Student Profile.  2015-16 NYS Science: CDV p-Value Comparison Report; Constructed Response Distribution of Points Awarded; Extended Response Analysis; Frequency Distribution; Frequency Distribution (by Subgroup; by Teacher; by Teacher Subgroup); Group Item Analysis; Group Item Analysis All Tested; Individual Extended Response; Individual Item Analysis; Individual Student Performance Report; Learning Standards Analysis; Performance Report with Gap Analysis; Performance Skills Analysis; Performance Station Detail; Rank List; Student List; Student Profile.  2015-16 Regents (all subjects): Student Profile.  2015-16 NYSAA: Frequency Distribution; Individual Score Report; Student Profile.  2015-16 NYSESLAT:  English Proficiency Levels; NYSESLAT Summaries; Student Labels; Student Profile. 

The 2015-16 data will be available on 8/29, after the next Sunday refresh.
8/15/16 Cognos: Updated the Medicaid cube for the 7/18/2016 remittance.
8/15/16 BARS has been updated to the latest release. This update includes the following: 2015-16 NYS ELA and Math: Rank List, Frequency Distribution.  2015-16 NYS Science: Parent Letter.
8/15/16 Cognos: L2RPT - SEDDAS update applied.  Fixed the drill through filter on SIRS-102 Elementary/Middle-Level Accountability Data Verification Report for the last 3 NYSAA Columns.
7/27/16 Cognos:  L2RPT - SEDDAS update applied.  Added the SIRS-501 Score Report - NYSTP for the 2016 School Year in anticipation of the data release.
7/25/16 Cognos:  L2RPT - SEDDAS update applied. Added an Overall Total to the SIRS-322 Staff Tenure Summary Report; Updated the footnote on SIRS-309 Annual Regents Summary Report; Updated the footnote on SIRS-202 Total Cohort - Assessment Summary Report.
7/11/16 Cognos:  A new Assessment Tested/Not Tested Report, is now available in the Data Analysis Reports folder.
7/8/16 Cognos: The NYS Secondary Assessments cube has been updated for year-end 2016 (Cohort Year 2013).
7/8/16 Cognos: The Student Achievement cube has been updated for year-end 2016.
7/8/16 Cognos: Updated the Medicaid cube for the 6/20/2016 remittance.
6/30/16 Cognos:  The 2016 Math 5 and 6 Item Map cubes and the Common Data View reports have been updated to eliminate grade 5 item 30 and grade 6 item 24, which have been dropped for scoring purposes by SED.
6/28/16 BARS has been updated to the latest release. This update includes the following: 2015-16 NYS ELA and Math Common Core State Standards Analysis report; 2015-16 Regents (all subjects) Frequency Distribution by Subgroup report; Added Engage NY question Links to the following 2015-16 NYS (ELA and Math) reports:  CDV p-Value Comparison Report; Constructed Response Distribution of Points Awarded; Performance Report with Gap Analysis; Released Questions Performance Report.
6/17/16 Cognos: L2RPT - SEDDAS: Released the SIRS-324 Staff Attendance Summary Report
6/8/16 BARS has been updated to the latest release. Reports will be available on Monday 6/13/16. Report updates: 2015-16 NYS (ELA and Math) - Common Data View p-Value Comparison Report, Constructed Response Distribution of Points Awarded, Individual Student Performance Report, Performance Report with Gap Analysis, Released Question Performance Report.
6/2/16 Cognos: Updated the Medicaid cube for the 5/16/2016 remittance.
5/31/16 Cognos: The Common Data View reports are now available for 2016 ELA. Running the reports for Math will return no data until June 3.
5/17/16 Cognos: The Student Achievement cube has been updated for 2016 marking period 5 of 6.
5/12/16 Cognos: L2RPT - SEDDAS update applied. Added back in the NYSITELL changes that got lost when reverting back to 10.2.
5/12/16 BARS has been updated to the latest release. Report updates: 2014-15 NYS ELA and Math - Frequency Distribution by Teacher Subgroup; 2014-15 Regents (all subjects) - Frequency Distribution by Teacher Subgroup; 2015-16 Regents (all subjects)- CDV p-Value Comparison Report, Constructed Response Distribution of Points Awarded, Group Item Analysis, Individual Extended Response, Individual Item Analysis, Individual Student Performance Report, Performance Report with Gap Analysis.
5/9/16 Cognos: Updated the Medicaid cube for the 4/18/2016 remittance.
5/3/16 Cognos: L2RPT - SEDDAS update applied. Reverted back to using cognos version 10.2; Modified footnote on SIRS-102; Fixed SIRS-351 Student Atttendance; when "All Locations" was selected; Moved the Chronic Absenteeism reports into the Attendance folder.
4/22/16 Cognos: The Student Achievement cube has been updated for 2016 marking period 3 of 4.
4/20/16 Cognos: L2RPT - SEDDAS update applied. Added Chronic Absenteeism Reports: SIRS-360 Attendance Absence Summary Report and SIRS-361 Year to Date Attendance/Absenteeism Summary Report
4/19/16 Cognos: The College Tracking All Students report was updated to include 'Q = 3/4 Time' and 'G = Graduated' in the Status Key line at the top of the report.
3/31/16 Cognos: The Student Achievement cube has been updated for 2016 marking period 4 of 6.
3/30/16 Cognos: Updated the Medicaid cube for the 3/14/2016 remittance.
3/28/16 Cognos: L2RPT - SEDDAS update applied. Updated SIRS-104 NYSITELL Reports for the changes to level descriptions for 15-16.
3/23/16 Cognos: L2RPT - SEDDAS update applied. Fixed the SIRS-351 Student Attendance Summary Report "ora-01722" Invalid number error. Updated L2RPT-SEDDAS model to include UIAS tables.
3/4/16 Cognos: Updated the Medicaid cube for the 2/15/16 remittance.
2/23/16 Cognos: Modified the Assessment Score Ranges report  to suppress NYS Std. Met of (61-66: 61: Level 1 off track, 62: Level 1 off track, 63: Level 2 off track, 64: Level 2 off track, 65: Level 3, 66: Level 4) for 2011-2014.
2/22/16 Cognos: L2RPT - SEDDAS update applied. Modified the footnote on SIRS-101 High School Accountability Data Verification Report. Set the NYSAA_CAP column to null for 14-15 School Year.
2/12/16 Cognos: The Student Achievement cube has been updated for 2016 marking periods 2 of 4 and 3 of 6.
2/12/16 Cognos: The NYS Secondary Assessments cube has been updated for mid-year 2016 (Cohort Year 2013).
2/8/16 Cognos: Updated the Medicaid cube for the 1/18/16 remittance.
1/25/16 Cognos: Renamed Assessment or Regents Tests by Standard Achieved Grouped by School to Assessment Levels Grouped by School. Renamed Assessment or Regents Tests by Standard Achieved Grouped by Test to Assessment Levels Grouped by Test.
1/21/16 Cognos: Updated the 4 NYS Science 4 and 8 Scores and Item Analysis cubes to include through 2015. Removed the Preliminary/Embargoed Science Cubes folder.
   

Upcoming Data Admin Meetings for 16-17

Thursday, April 13th –  1:00 - 3:00 PM CNYRIC Ontario and Erie Rooms
Thursday, June 8
th –  1:00 - 3:00 PM CNYRIC Ontario and Erie Rooms

High School Verification Work Session-
Friday, April 28th, 8:30 to 11:30 am, Rodax 8 Onondaga\Oneida Rooms, 6075 E. Molloy Rd.,Syracuse, NY 13211 Please register in MLP/Frontline: Flyer 2017 HighSchoolVerification Workshop.pdf 


Find details about upcoming Data Warehouse events, click here for mylearningplan:https://www.mylearningplan.com/WebReg/Catalog.Asp?D=15882&H=1

Upcoming deadlines & actions:

May 26: 2016-17 Course Instructor Assignment and Student Class Entry Exit Data Due
June 2: 2016-17 Staff Assignment (Principals only) Data Due.  Used for 2016-17 Principal State-provided growth score calculation purposes.
June 2: 2016-17 Staff Student Course (TSDL records) Data Due.  Submit final TSDL (Staff Student Course) and Staff Assignment data, including linkage and duration, for all teachers and principals to be used for 2016-17 teacher and principal State-provided growth score calculation purposes.  Staff Student Course records should be verified using the L2 SIRS-315 Teacher Student Data Linkage (TSDL) Verification Report.
June 9 :  2016-17 Staff Student Course (TSDL) & Staff Assignment Data Statement of Certification.  Certify the accuracy of the data submitted as of the reporting deadline (Certification of Principals only in Staff Assignment.) in the NYSED Business Portal.  Staff Assignment records should be verified using the L2 SIRS-318 Staff Assignment Verification Report.   
July 7: 2016-17 Regents Exam Scores Data Extract.  2016-17 scores for Regents exams (including June 2016 records) and approved alternatives to Regents exams to be used in principal evaluation growth score calculations.  
August 25: 2016-17 Special Education Data Elements Data Due: VR13, VR15, and VR16 through PD Data System.
August 25: All Final 2016-17 SIRS EOY Data Due (except for Special Education Events, Staff Evaluation) Used for federal and State reporting purposes, for State Aid allocations, and to make accountability status determinations.  Data must be submitted to L2 by 11:59pm.
August 25: Start of collection for 2016-17 Evaluation Composite, Category Ratings, and Subcomponent Scores and Ratings for districts implementing and APPR plan under Education Law 3012-d.  Eligibility for 2017-18 State Aid is dependent upon submission of Staff Evaluation data for school districts only.
August 28: Certification of 2016-17 Special Education Data Elements
September 8: 2016-17 SIRS EOY Data Statement of Certification (except for Special Education Events, Staff Evaluation)
September 19: NYS ESSA Application Submission Date
September 22: 2016-17 Data Due Special Education Data Elements: VR11 – 12 and VR 14 through the PD Data System.
September 25: 2016-17 Certification Due Special Education Data Element: VR11-12 and VR14
October 27: 2016-17 Data Due Staff Evaluation scores and ratings to fulfill data reporting requirements under ED Law 3012-d.  Eligibility for 2017-18 State Aid is dependent upon submission of Staff Evaluation data for school districts only.
November 3: 2016-17 Statement of Confirmation via SED Monitoring in NYSED’s Application Business Portal at portal.nysed.gov to Certify the accuracy of Staff Evaluation Rating data submitted on 10/27 deadline. 
November 10: Submission of August 2017 diplomas for students in the 2011 and 2012 total cohorts for reporting 2011 and 2012 total cohort graduates as of August 31, 2016, for the 2016-17 graduation release

  

 
NYSED's google calendar:

Proudly serving 50 school districts in the Cayuga-Onondaga, Onondaga-Cortland-Madison, Oswego, and Tompkins-Seneca-Tioga BOCES regions
READ
Data Warehouse to host several opportunities for educators and administrators:
Save the dates for the following opportunities hosted by the CNYRIC's Data Warehouse team. eDoctrina Presentation June 6 – 8:30-10:00 a.m. – Educator Suite demonstration ... more >>

Meet our Featured Teacher: Kristy Townsend:
  "Using technology effectively has created a classroom culture of collaboration."    Kristy Townsend ... more >>

CNYRIC team members participate in Earth Day Litter Cleanup:
The outdoor space surrounding the CNYRIC received special attention on Saturday, April 22, thanks to several team members. Together, Joe Napoli, Teresa Fragola, Tammy Mahady, Shelly McConnell, ... more >>

Meet our Featured Teacher: Justin Ashworth:
    "The students must own the learning. The tools and partnerships that are available today can help empower students to control their ... more >>

Is your district's website ADA compliant?:
In recent months, several school districts in New York State have been contacted by the Office of Civil Rights (OCR) regarding website compliance violations of  section 508 of the Rehabilitation ... more >>

Meet our Featured Administrator: Mr. Andy Eldridge:
    "The technology isn't the star of the show, but a means to ensure high-level learning is occurring." ... more >>

More Stories >>        
FOLLOW
INSPIRE
...
Quicklinks
Services
About Us
Directions
Contact
Staff Directory
Districts / BOCES
Help Desk
Events
News
Staff Only
Vendors


Privacy
Departments
AV Repair
Data Center
Data Warehouse
Disaster Recovery/Information Security
e-Communications
Financial Services
Food Service Management
Instructional Technology
Local Government Service
Managed Technical Support
Network/Telecom/E-Rate
Printing
Student Services
Test Scoring
Central New York Regional Information Center
6075 East Molloy Road
PO Box 4866
Syracuse, NY 13221

Phone: 315.433.8300
Fax: 315.433.8368

CNYRIC Help Desk
Phone: 315.433.8345
Email: helpdesk@cnyric.org
give us feedback
soc audit
Developed by CNYRIC