Welcome New DW Users

1. Welcome New DW Users WNYRIC Data Warehouse 2013 – 14 Webinar

2. Welcome So let’s get started with the tour…

3. Agenda • Data Flow • What is the WNYRIC DW vs. SED DW • Log On, Security, Change Password • Who can see What in WNYRIC DW Output? • Cognos Navigation, List/Detail View • WNYRIC DW Output List – How To… • Recommended Reports for All Users • Reports vs. Cubes • Downloads (PDF, CSV & Excel), IE 10.0 • What setting ensures a successful download • Log Off/Log On again • User Documentation – LDAP and Cognos Upgrade • Support – Who and Where to find more information

4. Data Flow

5. The WNYRIC Dataview Portal https://Dataview.wnyric.orgWhat is the WNYRIC DW vs. SED DW? • L2RPT – Level 2 Reports • Reporting against Level 2 / SIRS DW which is the Student Information Repository System used by the State for Verification Reporting related to Accountability, BEDS, Teacher/Course/Student Data • Statewide Reporting by Unique Student NYSSIS ID • Also used for Data Collection for Reporting to US Dept. of Education (USDOE) • Uses IBM Cognos Reporting Software • SEDDAS Security is needed for access *see your SEDDAS Administrator for your District (usually the Superintendent of your District) • WNYRIC Data Warehouse Reports • Also known as Level 1 • Used for District & Regional Reporting and Analysis as defined by District Requirements • Also Used to collect data needed by NYSED for State & Federal Reporting • Uses IBM Cognos Reporting Software • Used for pre-printing scannable assessment answer sheets • Series 7 Log On • Security is Administered by WNYRIC

6. Reporting available from the WNYRIC Level 1 Data Warehouse • What type of output is available from WNYRICs Level 1 Data Warehouse? • Reports to help you verify student data (demographic, enrollment, program service, assessment data etc.) • 3-8 assessment performance level and item analysis reports and cubes. • Regents assessment performance level and item analysis reports and cubes. • High School 9th grade entry date reports including graduate and other outcomes. • . . . and more. . .

7. Reporting Cont’d. • Keep in mind, wherever you see the term "Regional Success Rate" or "Gap to Region", it refers to all the data we house in the WNYRIC Data Warehouse. Included are (as appropriate by assessment administered)… Buffalo City , Rochester City, Charter schools, Diocese – Buffalo, Diocese – Rochester and the BOCES component districts for Catt Alley, Erie 1, Erie 2, Genesee Valley, GST, Monroe 1 &2, O/N, Wayne Finger Lakes and Non – Public Schools.

8. New 2013 “Released Question” Analysis Reports Engage NY site

9. WNYRIC Data Warehouse Cognos Log On To log into the WNYRIC Data Warehouse, click on the ‘WNYRIC’ Data Warehouse button. Enter your User ID and Password as sent to you from the WNYRIC Security Officer. Press the ‘OK’ button to confirm your entry. Follow prompts should you LOCK your access OR wish to change your password.

10. Security & Change Password WNYRIC Districts To change your Password you will need to contact the WNYRIC Network Security Officer with your request at: nsage@e1b.organd cc: trussell@e1b.org (make sure to e-mail both as Tim Russell is the back up to Nancy Sage (Security Officer) when she is out of the office.

11. Whocan see Whatin the WNYRIC Regional DW output? RIC – A RIC User sees all of the District and Charter Schools associated with that specific RIC Region. BOCES – A BOCES User sees all of the Component District and Charter Schools for that specific BOCES. DISTRICT – A District or Charter School User sees all of the specific District or Charter School data.

12. Navigation of Reports & Cubes Let’s get started with a Demo navigation of Reports & Cubes https://Dataview.wnyric.org click WNYRIC Data Warehouse

13. List View vs. Detailed View

14. WNYRIC Data Warehouse Output List To assist users with navigation of the many Reports and Cubes the DW team has compiled an output index. Each Path (Breadcrumb) is outlined and the Name, Description and either an Open Report link button to view the Report OR directions guiding you to opening a Cube.

15. New 3-8 Reports listed on the Output List

16. Data Ready Reports Data Ready Reports Reports placed in this folder are identified as important for all district to review for one of the following reasons: • General confirmation that data locked in Level 0 was loaded to Level 1. • Summary status reports for specific deadlines. • 3. Potential exception conditions, which would require research by the district. E.g. Demographic without Enrollment.

17. Recommended Reports for ALL Users Demographic Enrollment Program

18. Student Enrollment Verification Report

19. Student Enrollment (Cont’d) The first page of the Report provides for Counts based on your selection. Scroll to view the rest of the pages within the report – the remaining pages show detailed student information by district, selected building(s) and grade(s). To return to the Report selection menu click the ‘Return Arrow’ in the Cognos menu bar

20. Student Inquiry Report by Local ID

21. Student Inquiry (cont’d)

22. Program Participation Detail Report by Program Type

23. Program Participation (cont’d)

24. Program Participation Detail Report by State Program

25. Program by State Program (cont’d) Report Results – includes the Program Type, State Program Code and State Program (Title) The resulting report above contains information for ALL State Programs chosen in your prompt screen

26. Reports vs. Cubes Cubes – The output enables the user to display data from multiple viewpoints, similar to a Rubik’s Cube. These do NOT refresh automatically, as Cubes are rebuilt (various schedules – weekly/monthly) by the Data Warehouse Tech Team using fresh data. Reports – The output is a two dimensional one view file. Reports run using data refreshed from the most recent Level 0 update or Scanned input. Data updates are an overnight process.

27. Cube Example The following shows initial view for the ‘NYS Assessments (2006-07 to present)’.

28. Cube with/without folders view

29. Cube Example – NYS Assessments • Public Folders > Student Summary Cubes > NYS Assessments (2006-07 to present) Note: This slide shows the ‘drag drop’ action to view the measure Average Score. Each row comes from the various folders on left. You have the option to change view based on row and/or column selection. For more information on using Cubes see the WNYRIC DW (a.k.a. Level 1) DW User Guide.

30. Cube Example - Student Enrollment Cube The Student Enrollment Cube is available from the following path(breadcrumb) Public Folders > Student Summary Cubes > Student Enrollment Hint – Turn ON Wrapping to assist with using the cube.

31. Cube Example - Student Enrollment Cube Cont’d • Dimensions Viewer is hidden (no folders) • ‘Wrap’ Dimensions Bar is turned on • Filtered • Erie 1 BOCES • All Genders

32. Downloads for Reports(PDF, CSV & Excel) Report View Icon is located in the top menu bar, allows the user to download and view in other formats such as Excel (various versions). Views for Cubes(PDF, CSV & Excel) Cube View Icon is located in the bottom menu bar, allows the user to download and view in other formats such as Excel.

33. What settings ensure a successful download? Internet Explorer 9 And lesser IE Versions – Preferences should be set up prior to using Dataview Reports/Cubes. Go to User Documentation and pull the step by step instruction that apply to your version of IE. Dataview (Cognos) preferences for viewing the Reports in PDF format can be set up using ‘My Preferences’.

34. What settings ensure a successful download? Internet Explorer 10.0 Compatibility view enables users with the upgraded IE 10 to successfully work with Reports and Cubes. The icon is located within the URL bar located at the top of the browser window.

35. Log Off / Log On Again Series 7

36. Documentation & Support

37. User Documentation & How to find Report Information… From the Dataview website select the Documentation fly out ‘User Documentation’. The screen refreshes with the DW Support Place. Each DW Module contains links to documents and step by step directions for Reports and Cubes .

38. WNYRIC DW (a.k.a. Level 1) DW User Guide From the WNYRIC (http://www.e1b.org/wnyric) click on the Data Readiness tab; the page refreshes with the Data Warehouse and Test Scoring Overview Scroll down the page and under the Data Warehouse heading (left side of page find the gold icon “Support Place” and click on it. The page refreshes with DW Support Place. Scroll down on the left side of the page find the “DW User Documentation” click to open the DW Level 1 User Guide.

39. Regional DW Liaisons & Trainers

40. Support - dataview@e1b.org Note: The DW and L2RPT Support link sends an email to the WNYRIC DW support staff: Maggie Maloney, Denny Atkinson, Bonnie Fosbury & Sally King

41. What’s Coming this year… The introduction of LDAP security is due to begin in November with Cognos User audits. The Cognos Upgrade will begin around the same time and you will notice changes to where you will click to view Reports and where you click to work with Cubes.

42. Workspace Advanced Cube Views With the upgrade there will be changes to how you view Reports and work with Cubes. New look and feel with more options when working with data. Here are some examples of Cube Views. Cube views for Regents Item Analysis for Best Practice in .pdf format

43. Communication & Training • Communications will be sent via e-Mail and shared in DDC Meetings • Training is coming • More Communications watch your e-Mail • Support – Dataview@e1b.org

44. Your WNYRIC DW Level 1 Support Team dataview@e1b.org Sally A. King Training Coordinator 716-821-7165 Bonnie L. Fosbury Specialist 716-821-7189 Margaret L. (Maggie) Maloney Coordinator 716-821-7466

45. Q & A Thank You for your participation today!