The Cognos Reporting Warehouse is bigger & better for the new school year!

WHAT‘S NEW IN COGNOS?
CST test results for the past 7 years, 2002 through 2008 scores can now be accessed using the Cognos Reporting Warehouse!

THE COGNOS REPORTING WAREHOUSE
The Cognos Reporting Warehouse is a web-based tool intended to provide district staff members the capability to report on a variety of data from various student information systems from ONE place! A diverse set of reports and tools are available via the Cognos Portal.The Cognos Reporting Warehouse currently contains data reported for students who are presently enrolled in a school, including schedule information, grades, absences and test scores. Reports display data at a district, site, classroom, and student level based on user access.

You can access the Cognos Reporting Warehouse at https://cognos.sandi.net/.

In order to help you get started, we have included these Knowledgebase articles;

Article #533 will introduce you to the Cognos portal
Article #534 gives information on system requirements to run Cognos, including supported browsers
Article #535 provides data on how to locate Cognos jobaids
Article #536 indicates how users can submit requests for new reports or additions to existing reports
Article #745 gives information on how to interpret report data and who to contact

Job Aids in the Read & Learn page will help step you through the process of logging in and navigating the portal.

Visit the Cognos Training & Support website today at http://www.sandi.net/cognos

THE COGNOS REPORTING WAREHOUSE CAN BE ACCESSED FROM HOME!

You can access the Cognos Reporting Warehouse outside of the district’s network at https://cognos.sandi.net/. Please be aware that the Cognos Reporting Warehouse will be unavailable nightly from 12:30am - 12:45am to accommodate system and data backups. In addition, starting every night at 2:00am, new and updated data from Zangle, Encore, and PeopleSoft from the prior day will be loaded into Cognos. This may cause slowness in the application until the updates complete.

COGNOS REPORTING WAREHOUSE TRAINING & SUPPORT

The IT Training & Support group has developed an easy to navigate website to provide assistance. If you need additional help, take advantage of Open Labs offered on Fridays at the Fremont Training Center. The Open Lab calendar is available here: http://www.sandi.net/peoplesoft/training/open_lab/practice.asp

This site includes:

• Job Aids
• Knowledgebase Articles
• On-Line Tutorials
  

As additional functionality is made available to you such as ad-hoc query writing, instructor-led training will be available.

Visit the Cognos Training & Support website today at http://www.sandi.net/cognos

New Reports Displaying Student Schedules Available in Cognos

Three new reports are available in the Cognos Reporting Warehouse on August 27, 2007.

Each of the new reports display the selected student’s schedule for all terms for several years. For each class, the report displays the school year, term, class period, school name, building, classroom number, from date, to date, course number, course name, section number, and teacher name. Classes are grouped by year and term and sorted in order of descending school year, ascending term name, and ascending period.

The format of each report will differ based on the school type; Elementary, Secondary, or Extended Day Secondary.

Student Schedule - Elementary (SI06A) - This report is useful for a relatively quick overview of a student's schedule over time and for determining where a student is during a particular period. Please see Knowledgebase Article #773 for more details.

Student Schedule – Secondary (SI06B) - This report is useful for a relatively quick overview of a student's schedule over time and for determining where a student is during a particular period. Please see Knowledgebase Article #774 for more details.

Student Schedule – Extended Day Only – Secondary (SI06C) - This report is useful for a relatively quick overview of a student's extended-day schedule over time and for determining where a student is during extended day. Please see Knowledgebase Article #775 for more details.

New Reports Displaying CST Data Available July 2 in Cognos

Two new reports will be made available in the Cognos Reporting Warehouse on Monday, July 2.

• CST Strand Results by Course/Section for Teacher, Student Strands (SP33SD) - Displays percentages of students by performance level for each test. Data is organized by students scheduled for a section in the master schedule. The aggregate data is displayed in the form of a stacked bar graph. A table showing the number of students at each performance level is included. The data is organized by strand and includes the number of questions, number correct, and percent correct. Please see Knowledgbase Article #732 for more details.
• CST Strand Results by Course/Section for Teacher, Student Demographics (SP34SD) - Displays individual results for each student in a specific section including: current grade level, student ID, name, performance level on CST test, scale score, test subject, and student demographic information. The aggregate data is displayed in the form of a stacked bar graph. Please see Knowledgebase Article #764 for more details.
  

Both reports display last year's test results and filter on the current year and prior school year schedules. This makes them useful for allowing teachers to understand the past performance of both prior and current students.

New Job Aid and OnLine Tutorial; Setting Your Cognos Portal View

Early users of Cognos (those who logged in to Cognos before 9am on Wednesday, June 6th) missed out on one last significant update made to the Cognos User Interface.

When you log in, if your portal displays 2 tabs called Public Folder and My Folder, without any graph at the right, then you may have been an early adopter of Cognos who missed out on this update.

A job aid and corresponding online tutorial have been written that show you how to reset your view to the Cognos Reporting Warehouse portal when you log in.