Applied strategies for getting data into the hands of decision-makers Lunch and Learn Online Seminar Series - PowerPoint PPT Presentation

Gabriel
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Applied strategies for getting data into the hands of decision-makers Lunch and Learn Online Seminar Series PowerPoint Presentation
Download Presentation
Applied strategies for getting data into the hands of decision-makers Lunch and Learn Online Seminar Series

play fullscreen
1 / 39
Download Presentation
Applied strategies for getting data into the hands of decision-makers Lunch and Learn Online Seminar Series
349 Views
Download Presentation

Applied strategies for getting data into the hands of decision-makers Lunch and Learn Online Seminar Series

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Applied strategies for getting data into the hands of decision-makersLunch and Learn Online Seminar Series July 21, 2005 Predictive Analytics in Higher Education Administration Hosted by: Bob Valencic, SPSS Higher Education © 2005 SPSS Inc.

  2. Today’s Agenda • Business issues in higher education • Defining the Predictive Enterprise and SPSS Web App Framework • Today’s Case Study with Sherri Sahs • Q & A • Want to learn more? • Upcoming Events

  3. Higher Education Business Issues • Institutional effectiveness • Student learning outcomes assessment • Enrollment management • Marketing • Alumni How can advanced analytical technology help?

  4. CRM Operations Risk Text mining Surveys Studentservice Web mining Enrollmentmgmt Student View Alumnifunding Data at the heart of theThe Predictive Enterprise • Interaction data • - Offers • Results • Context • Click streams • Notes • Attitudinal data • - Opinions • Preferences • Needs • Desires • Descriptive data • Attributes • Characteristics • Self-declared info • (Geo)demographics • Behavioral data • - Courses taken • - Transactions • Test history • - Contributions

  5. SPSS Web App Framework

  6. Getting data into the handsof decision-makers SHERRI L. SAHS Decision Support Systems Manager and Research Analyst © 2005 SPSS Inc.

  7. Overview of Presentation • Background • Dynamic Web-Based Environment • Project Status • Demonstration • Questions

  8. Background • IR office keepers of the “official” data • Data downloaded from several systems/sources • Data analyzed using SPSS products • Static web data views and hard copy reports • 2003-2005 IR Strategic Initiative • Incorporate dynamic data access

  9. Dynamic Web-Based Environment • Easy & immediate access to information • Adaptable to specific user needs • Canned, interactive, and ad-hoc analysis and reports

  10. Dynamic Web-Based Environment • SPSS WebApp Framework • Released June 2001 • Developed with Gallup Organization • Unfilled customer need • Demand easy & immediate access to information • True thin-client • Web browser & Internet connection

  11. Dynamic Web-Based Environment • SPSS WebApp Framework • Data compatibility • Native SPSS (SAV) files • Relational database (MS SQL server, Oracle, IBM DB2)via JDBC & ODBC drivers • Customized applications/interfaces • SPSS syntax, HTML, JavaScript & JSP fundamentals • XML for Metadata • Full power of SPSS analytics

  12. Dynamic Web-Based Environment • Minimum System Requirements • Server • 2GB RAM • 700MB drive space • MS Windows 2000 server or MS Windows 2003 Server; Sun Solaris 2.8 or higher • 2 CPUs with 1GHz processors • Database • MS SQL Server 2000 (included w/SPSS WebApp) or Oracle 9i • Web Client • MS Internet Explorer 5.5 for Windows or Safari 1.2 for Macintosh

  13. Project Status • Implementation • Initial - January 2004 • Upgrades (Hardware & software) - October 2004 • Delay in university-wide deployment • Resources • Need to include dashboard indicators • Focus group feedback • University-wide availability • Fall 2005

  14. Data Distribution – With SPSS WebApp

  15. Scenario #1 • Director of Admissions needs applied, accepted, deposited, and enrolled headcount for current term as of today.

  16. Data Distribution – With SPSS WebApp

  17. Data Distribution – With SPSS WebApp

  18. Scenario #2 • Faculty member from the department of Aeronautical Science wants to know if incoming freshmen who declared Aeronautical Science as their major chose ERAU because of the degree programs offered.

  19. Data Distribution – With SPSS WebApp

  20. Demonstration: Create Frequency Table & Graph

  21. Demonstration: Create Frequency Table & Graph

  22. Demonstration: Publish Document

  23. Demonstration: Publish Document

  24. Scenario #3 • Strategic Planning analyst needs data for the average number of term hours taken in the last 5 years by each major program.

  25. Demonstration: Create Pivot Table

  26. Demonstration: Pivot Table Download

  27. Scenario #4 • Faculty member coordinating CAA Self Study requests 5 years of enrollment data for all programs under the College of Aviation. Break out data for each campus by class level to include: state, country, HS Rank and average ACT and SAT scores.

  28. Demonstration: Create Webcube

  29. Demonstration: Create Webcube

  30. Demonstration: Create Webcube

  31. Scenario #5 • Department of Financial Aid completing Florida Department of Education Eligibility application needs Fall 2004 enrollment data for in-state residents. (1) Number of full-time/part-time students by degree seeking/non-degree seeking by program level. (2) Credit hours for full-time students by program level. (3) Credit hours for full-time degree-seeking students by program level.

  32. Demonstration: Create SPSS Command Syntax

  33. Demonstration: Create SPSS Command Syntax

  34. Demonstration: Save SPSS Command Syntax

  35. Demonstration: Save SPSS Command Syntax

  36. Q & A © 2005 SPSS Inc.

  37. Want to Learn More? • Contact an SPSS data mining expert by calling 800-543-2185 option 2. • http://www.spss.com/webapp • Check out the Knowledge Management/Data Mining Discussion Group: http://www.dmhe.org • People, Processes, and Managing Data, Second Edition by Gerald McLaughlin and Richard D. Howard – www.airweb.org • Bob Valencic rvalencic@spss.com

  38. Events & Workshops • SPSS Directions 2005 – November 16 – 19, Las Vegas, NVhttp://www.spss.com/spssdirections/ • “Hands-on Application of Clementine for Clustering and Predictive Modeling” presented by Dr. Jing Luan • MIDAIR Conference – November 9-11, 2005 Columbia, Missouri • “Hands-on Application of Clementine forClustering and Predictive Modeling” presented by Dr. Jing Luan • Look for other Lunch and Learn online seminars for Higher Education at www.spss.com/lunchandlearn. Other topics included • Data mining’s role in managing student lifecycles • predicting first year retention and key student characteristics • getting data into the hands of decision-makers

  39. Thank you for attending today’s online seminar To contact today’s speakers: Bob Valencic: rvalencic@spss.com Sherri Sahs: sahss@erau.edu © 2005 SPSS Inc.