USING REPORTING TO MANAGE THE ENROLLMENT AND GRADUATION FUNNELS – AND OTHER FUN DATA TOPICS

1. USING REPORTING TO MANAGE THE ENROLLMENT AND GRADUATION FUNNELS – AND OTHER FUN DATA TOPICS Helen Norris, Associate Vice President, Technology Services CSU Sacramento

2. Agenda for today’s presentation • Sac State Overview • Data Warehouse Background • Enrollment and Graduation Challenges • Solutions Implemented for Enrollment & Graduation • Other Cool Reports • Next Steps

3. Sac State Overview • One of the larger campuses in the 23-campus California State University system • Approximately 21,700 FTE comprised of approximately 28,000 students, mostly undergraduate; • 60% of newly-enrolled students are transfer students • “Non-traditional” students – working adults with families; first generation college • Declining State resources over the last several years

4. Sac State Overview

5. Sac State Overview

6. Sac State Overview

7. Sac State Overview

8. Data Warehouse Overview • CSU uses the Peoplesoft suite for Student Administration, as well as Finance and HR • In 2008, Sac State implemented a self-service Data Warehouse, using the Cognos tool • Data Marts include Finance, Student, Advance and HR • Moved focus of efforts to student reporting in Fall 2009 • Sophisticated security model for student data • About 400 users across campus • 20,000+ reports are run monthly • Collaborative approach to report development • Initial report rollout focused on operational reports

9. Enrollment Challenges • Changing enrollment targets • Impacted Programs • Budget challenges • Data needs at campus/college/department level

10. Solution • Admissions Analytics Reporting • Aggregate Counts for the progressive funnel of Admissions Activity • Timing; used by campus from Application Through Matriculation • Online or Export Options • Flexible Summary Total Options • Graduate (PostBac) and Undergraduate perspectives • Campus, College or Department Level Perspectives through drills

11. Data Warehouse Access

12. Data Warehouse Access

13. Data Warehouse Access

14. Admissions Analytics Filtering

15. Admissions Analytics By College

16. Admitted Applicants by College/Department

17. Graduation challenges • Changing enrollment targets – need to have students graduate in a more timely fashion • Recently moved to an online graduation application process

18. Solution • Don’t really have one! • Future - build on our operational reporting to look at true graduation analytics • Some reporting – Graduation Funnel • Aggregate Counts for the progressive funnel of graduation Processing • Timing; used by campus throughout the semester • Online or Export Options • Flexible Summary Total Options • Graduate (PostBac) and Undergraduate perspectives • Campus, College or Department Level Perspectives through drills

19. Graduation Funnel Selection

20. Graduation Funnel By Term

21. Graduation Funnel By Term and College

22. Graduation Funnel By Term, College, Department and Plan

23. Other Cool Reports Delivered • Mostly Operational • Often were added as part of another project • May have been in response to a campus request for data from multiple areas • Some have a dashboardy feel

24. Enrolled Major

25. Schedule Of Classes

26. Faculty Workload

27. Textbook Compliance Report

28. ITE – Summary Of Reason with Detail

29. Orientation Department Students by Major By Major Orientation Report Student Group Orientation Report

30. Impaction Report By Impacted Program

31. Grade Reports

32. Grade Reports

33. General Ed. Requirements Report

34. Advising Report

35. What’s Next • Focusing on more analytical reporting, especially in support of our graduation initiative • Data needs are driving business processes, for example degree planning • Need to integrate other data; external data, space data etc.

36. Questions? • Helen Norris, helen.norris@csus.edu