GO      

Michael J Fay - Chief Technology Officer    (315) 433 - 8372        -    6075 E Molloy Road, PO Box 4866   Syracuse, NY 13221 (315) 433 - 8300
admin services
  Resources
      CNYRIC > Datawarehouse > Resources
  CNYRIC news - Several new and updated links have been added to the Resources link on the data warehouse page. Please review verification reports in nySTART, >> more

 
Critical Information
CNYRIC Data Warehousing team is dedicated to keeping you up to date with the latest news and information. Below are all the available Data Warehouse Presentations, Documents and Templates.
SIS User's Documentation
SIS Status Codes, Enrollment In and Out Codes for 2007-2008 - Please refer to this document to verify enrollment transactions have correct student status and state enter and exit/transfer codes (Student Biographical Student Enrollment screen in SIS).
SIS User's CTE Help Document - Use this help document when entering program service data for students who enroll in Career Technical Education and Tech Prep/Career Pathways (Student Biographical Special Programs screen in SIS).
SIS User's GED Help Document - Use this help document for students who transferred to an Alternative High School Equivalency Preparation Program (AHSEPP) or High School Equivalency Preparation Program (HSEPP) approved under Section 100.7 of the Regulations of the Commissioner of Education. Such students must be reported with an AHSEPP or HSEPP enrollment record until they earn the high school equivalency diploma, transfer to a diploma-granting program, or leave the AHSEPP or HSEPP.
SIS User's LEP Help Document - Use this help document for coding Limited English Proficient students in the Student Biographical Special Programs screen in SIS.
SIS User's Summer School Help Document - Use this help document when entering program service data for students who enroll in Summer School (Student Biographical Special Programs screen in SIS).
Data Analysis
Data Analysis Tools - This tool gives users a description of several data analysis tools, such as Cognos PowerPlay, ReportNet, DataMentor, and nySTART.
Data Wise Improvement Process from CNYDIG presentation - This is the datawise presentation offered by Lori DeForest on using the DataWise process to have discussions and dialogues in your districts on data.
Data Wise Improvement Process Powerpoint - Powerpoint presentation from the CNYDIG meeting on using the Data Wise process with district personnel.
Growth Model Presentation by Ira Schwartz - DATAG(Data Analysis Technical Assistance Group), consisting of educational professionals involved in supporting the use of data to support instruction, invited Ira Schwartz to present on the Growth Model for enhanced accountability at their Summer 2008 Conference in Albany.
Documents
Account Requests Document - This document was created by Cheryl Covell and Lori DeForest to provide users with a brief overview of how to access data analysis sites like nySTART, Cognos ReportNet, Cognos PowerPlay, and DataMentor.
Approved/Non-Approved CTE CIP Codes Cayuga BOCES 2007-08 - This document contains codes used in reporting to the data warehouse endorsed and non endorsed CTE classes.
Approved/Non-Approved CTE CIP Codes OCM BOCES 2007-08 - This document contains codes used in reporting to the data warehouse endorsed and non endorsed CTE classes.
Approved/Non-Approved CTE CIP Codes Oswego BOCES 2007-08 - This document contains codes used in reporting to the data warehouse endorsed and non endorsed CTE classes.
Approved/Non-Approved CTE CIP Codes TST BOCES 2007-08 - This document contains codes used in reporting to the data warehouse endorsed and non endorsed CTE classes.
Changes for Demographic and Program Service Data 2007-2008 - Changes in regards to homeless indicator, CTE students, and summer school.
Cognos and ReportNet User Account Application - Fill out this application and fax to Data Warehouse at 315.433.2221 for Cognos Powerplay Cubes and Cognos ReportNet Reports access.
Cognos Powerplay Manual - Cognos Powerplay Manual created by Cheryl Covell at TST BOCES.
Data Dictionary of Reporting Elements 2007-2008 - New York State Statewide Data Warehouse Dictionary of Reporting Data Elements for use in 2007-2008.
Data Validation Chart - Use this chart/matrix to monitor monthly Report Net usage and updates.
Definitions of Levels of Program Intensity - Use this matrix to determine students' level of program intensity.
Directions for Uploading Level 0 data into Level 1 - This document discribes the upload process for assessment extracts from Level 0 into Level 1 Data Warehouse.
Guidelines for Extracts 2007-2008 - The purpose of this document is to provide definitions of the data sets to be submitted to SIRS and of the individual data elements in those sets, to provide the business rules and basic edits that apply to those elements, and to outline the formats and layouts required for submissions. The audience for this document is vendors of information systems, individual local educational agencies (LEAs) and those responsible for creating and/or extracting student data.
Level 0 Electronic Import Document - Use this document for importing data files in Level 0.
Level 0 Manual Input Document - Use this document for assistance when entering student data in Level 0.
Level 0 Orientation Document - Please review this document before submitting applications for Level 0, NYSSIS, Cognos/ReportNet and FTP Upload.
Location Map for Henry B DLC - Use this resource for locating Henry B building on Henry Campus.
NYSAA 2007-2008 Age Ranges - All students in the following age ranges who are eligible to take NYSAA must be tested in 2007-08. Students with severe disabilities are assessed according to chronological ages aligned with grade levels as indicated in the attachment.
NYSAA 2007-2008 Incomplete Datafolio Document - Complete this form for each NYSAA student for whom you have a missing or incomplete datafolio by checking the term that describes the reason that the student's datafolio is missing or incomplete. Submit this form with the student demographic data sheet to the score site coordinator.
nySTART account administration job aid - Job aid for assisting with nySTART account provisioning.
Preschool Special Education Providers - BEDS Codes and Addresses of Approved Private Schools for Students with Disabilities, Special Act School Districts, State Supported Schools (Under Section 4201), State Operated Schools, Out of State Schools with Emergency Interim Placements, Counties that Provide Preschool Special Education Services, and State Agencies that Provide Educational Services.
Recommendations from SED for NyStart Navigation Document - This might help with irregularities on attempts to view NyStart Total Cohort Reports.
Reconciling nySTART and ReportNet Reports - This document will assist you in understanding how to reconcile reports and determine if you have inconsistent data by comparing information submitted from student management systems including enrollment and test results.
Source of District Data Matrix  - This Excel spreadsheet contains data source information for student information management.
Special Education Data Required for 2007-2008 School Year June 19, 2008 Memo - Please refer to this memo from Rebecca H. Cort for guidance on reporting students with disabilities.
Student Information Repository System User Manual for 2007-2008  - This manual offers information on the accountability rules for k-12 as they relate to the data warehouse, and also provides information on reporting and certification time lines, and information on program service categories.
Summary of Reporting Responsibility for Students with Disabilities - The table attached provides a summary of which district/school/agency has CSE or CPSE responsibility, accountability responsibility and reporting responsibility in these cases.
The 2006-07 Total Cohort Instruction Letter - Use this document for interpreting data contained in the cohort reports.
User ID Application - NYSSIS - This is the application for the New York State Student Identification System (NYSSIS). This authorization is needed if you are to do 'near match' resolution for your district.
User ID Application - ToolKit and Upload - The application for requesting a User ID and Password for the Data Warehouse ToolKit/Level0 and/or Upload.
Important Data Warehouse Websites and Info
Inni Barone's Special Ed Data Collection Update - Inni's presentation from Driver's Village on June 6th, 2008
SED Data Warehouse Documentation - Important documentation regarding administration of NYSTP
SED NYSTART Info - Important documentation regarding Grownet's nyStart application
Special Education Data Collection in 2007-2008 School Year - PowerPoint presentation given by Inni Barone hosted by OCM BOCES at Driver's Village November 28, 2007.
Presentations
District Superintendents - Original Data Warehouse presentation for District Superintendents.
New DW Data Administrator Training - PowerPoint presentation developed for people new to the data warehouse.
The Grow Network and New York State - Presentation to 4th Annual Conference on Best Practices Using Data at White Plains, NY (November 2, 2005)
Unique Student ID - New York State Student Identification System (NYSSIS)
Templates
Programs Fact  - Programs Fact template shows template layout and sample transactions.
School Enrollment - Template information for School Enrollment data and sample transactions.
Student Lite - Template information for Student Demographic data and a sample transaction.
Meeting Minutes
Contact CNYRIC Data Warehouse Team at dwinfo@cnyric.org
 
This site is supported and maintained by staff from the Central New York Regional Information Center.©2006.Webmaster