Systems and Programming (SysProg), a department within the NERIC, offers an array of products and services designed to ease the burden of collecting, analyzing, and acting upon, data

Whether your position is educational, administrative, or clerical in nature, SysProg is able to provide a solution, either right out of the box, or designed from scratch according to your specifications.

Systems & Programming occasionally holds training sessions to introduce an offering to a new customer, or to introduce new features of existing services to our existing customers. Please check the NERIC Calendar and Training Schedules Page for regular updates on sessions that may interest you.

The Systems and Programming Unit is comprised of 12 talented individuals. Our experience falls into the categories of software design and development, database design and development, report development, and OLAP data mining.

Our programming staff has experience with various programming languages, including COBOL, C, Visual Basic, and Java.

We have developed databases using Microsoft Access and Microsoft SQL Server to store data for software as simple as a single-user desktop application, and as complex as an n-tier application with many users spread over multiple geographical regions.

Our customers need quick and accurate output of their data. To accomplish this, our staff has advanced knowledge of the use of such powerful reporting tools as Crystal Reports and the Cognos Business Intelligence suite of OLAP tools.

New York State school districts are about to enter the information age with a very successful concept from the business world: Data Warehousing. In a data warehouse, large volumes of data that may come from different sources are collected in a single electronic repository. When so organized, decision-makers can study relationships among data that would be difficult to examine were the data stored in separate places.

In schools are many forms of data – including student records, human resources records, standardized test data, transportation records, financial records, progress reports, and grade book records. Finding relationships among them can be difficult. Assembling these data sources in a data warehouse makes it easier for educators to determine relationships using electronic search tools available in the warehouse. From patterns that emerge in these relationships through electronically-assisted data analysis, educators can then develop new insights, or confirm already existing ones, into teaching and learning in their classrooms, schools and districts.

The Cognos Corporation provides several tools to search within a warehouse. Cognos tools create data "cubes" based on the desired output. This user-friendly interface provides rapid descriptive information that would otherwise require some understanding of a database query language to accomplish. The "cube" presorts data to allow multiple dimensions (variables) to be examined at one time. Cognos PowerPlay enables you to analyze data directly from your web browser -- you need no special software to access the cube.

The Systems and Programming department occasionally holds training sessions and user group meetings for the products and services we offer.

This information is also available on the general Training Schedules Page which has details on on wide variety of training and professional development sessions offered by NERIC's Instructional Services.

Events are categorized by the service to which they pertain.    Active Event Links provide more information.     Register links to email

Schedule last updated 7/8/03

Systems and Programming offers a variety of services to help you manage your data. We perform a key role in scanning and scoring tests; and provide you with tools that allow you to analyze the performance of your students and schools. We enable you to manage class sizes, track student attendance and disciplinary infractions, and produce report cards. We can help you integrate all of your student data and help you make data-driven decisions. We even provide a complete service to manage your school district tax collection.

In addition to our standard products and services, we offer the ability to create custom software solutions that address your unique needs. Our team of software engineers will work with you to design and develop software that will help you simplify your responsibilities. From database design, user-interface design, programming, and report development, we can provide a complete solution for managing your mission-critical information.