1 / 39

Ivy Tech Region 6 Introductory Data D ay

Ivy Tech Region 6 Introductory Data D ay. Ryan R. Johnson Director of Institutional Research. Topics. Introduction Central Office Reports/Online Data Discoverer Basics Discoverer Standard Reports Overview of ODS Excel Basics Resources for Additional Discoverer Training. Introduction.

cianna
Download Presentation

Ivy Tech Region 6 Introductory Data D ay

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Ivy Tech Region 6 Introductory Data Day Ryan R. Johnson Director of Institutional Research

  2. Topics • Introduction • Central Office Reports/Online Data • Discoverer Basics • Discoverer Standard Reports • Overview of ODS • Excel Basics • Resources for Additional Discoverer Training

  3. Introduction • Ryan R. Johnson, MBADirector of Institutional Research765-289-2291, x1725email: rjohnson176@ivytech.edu • IR Bouncelistemail: r6-ir@lists.ivytech.edu

  4. Role of Institutional Research • Provide information on students, faculty, programs and financial aspects of the community college. • Culture of Evidence • “…refers to each college’s ability to know and show how their students move through the institution, from their first day on campus through graduation, to reach their educational goals. Ideally, the data and information derived from transactions with students is used to improve institutional processes, drive decision-making and provide accountability to external and internal stakeholders, including those students themselves.”From Association for Institutional Research Data & Decisions Academy Course

  5. Central Office Reports/Online Data • Central Office sends out standardized reports, primarily on census dates, detailing headcounts/FTE, student outcomes • http://www.ivytech.edu/institutional-research/ • http://wwwcc.ivytech.edu/employee/infonet/institutional-research/

  6. http://www.ivytech.edu/institutional-research/

  7. Regional Data • A wealth of Region 6 data is available • Discoverer Reports • Custom IR Data Requests • Discoverer reports include detailed information on many topics, including: • Enrollment • Student outcomes • Advising • Class lists • Compass scores • Demographics • VA • WED Programs

  8. Submit requests to IR Bouncelistemail: r6-ir@lists.ivytech.edu • IR Data Request Form – Region 6 • IR Survey Request From – Region 6

  9. Discoverer Reports – AR LibraryWith Description when Available

  10. Discoverer Reports – Financial Aid LibraryWith Description when Available

  11. Discoverer Reports – Financial Aid Library Cont’dWith Description when Available

  12. Discoverer Reports – Financial Aid Library Cont’dWith Description when Available

  13. Discoverer Reports – Financial Aid Library Cont’dWith Description when Available

  14. Discoverer Reports – Student LibraryWith Description when Available

  15. Discoverer Reports – Student Library Cont’dWith Description when Available

  16. Discoverer Reports – Student Library Cont’dWith Description when Available

  17. Discoverer Reports – Student Library Cont’dWith Description when Available

  18. Discoverer Reports – Student Library Cont’dWith Description when Available

  19. Accessing Discoverer Reports • http://www.ivytech.edu/banner

  20. Discoverer Login

  21. Report Selection

  22. Parameters F% used for wildcard

  23. Output

  24. Discoverer Preferences

  25. Operational Data Store (ODS) Defined • Operational Data Store (ODS) • A database designed for queries on transactional data. An ODS is often an interim or staging area for a data warehouse, but differs in that its contents are updated in the course of business, whereas a data warehouse contains static data. An ODS is designed for performance and numerous queries on small amounts of data such as an account balance. A data warehouse is generally designed for elaborate queries on large amounts of data.Source: PC Magazine Encyclopedia at http://www.pcmag.com/encyclopedia_term/0,2542,t=ODS&i=48283,00.asp

  26. Significance of ODS • Limitations • The Ivy Tech ODS is updated nightly with information from the previous day. The data in the ODS will always be current as of the previous day. • The ODS/Banner System is a transactional database. It is important to understand that reports will generate different results when ran on different days, even if the original parameters are unchanged. • A transactional database requires data snapshots and warehousing to produce accurate historical reports. Snapshots are maintained for the region and state by Institutional Research

  27. Excel Filter

  28. Identify Duplicate Values

  29. Remove Duplicates

  30. Pivot Tables

  31. Pivot Tables

  32. Pivot Tables

  33. Pivot Tables

  34. FileDrop • Provides additional layer of security for non-aggregate data • Allows for large file transfer, and helps prevent inbox from becoming too large

  35. FileDrop

  36. FileDrop

  37. Additional Discoverer Training • Future Data Day events will be announced • Online training available via Ivy Tech Training Portal by searching for ODS

  38. Questions?

More Related