1 / 40

Oh, The Things You Can Think!

Oh, The Things You Can Think!. How to Really See Your Assessment Data CS-150 (Strand 5) Monday, December 9, 2013 3:00 – 4:00 p.m. Robin Logan & Dr. Glenn James University of the Incarnate Word, San Antonio TX. Today. Identify some strategies for data setup

oprah-stafford
Download Presentation

Oh, The Things You Can Think!

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. Oh, The Things You Can Think! • How to Really See Your Assessment Data • CS-150 (Strand 5) • Monday, December 9, 2013 • 3:00 – 4:00 p.m. Robin Logan & Dr. Glenn James University of the Incarnate Word, San Antonio TX

  2. Today • Identify some strategies for data setup • Build interactive tables in MS Excel • Demo interactive graphics in Tableau BIG Idea: we’ll share our process for visualizing data for diverse users

  3. After our session, you should be able to . . . Recognize and use basic file structures that make your data analysis easier. Build MS Excel filters and pivot tables. Use interactive graphics in Tableau Software worksheets and dashboards. Advise colleagues on steps to use interactive tools to visualize your data.

  4. What we all have… • A lot of data from varying sources • Diverse business processes • Constant requests for our time and our data • Both internally and externally • An unyielding demand for current, accurate and complete information • AND… constantly changing questions

  5. What we all need… • Analysis of university data • Federal, state and internal reporting • Consistent answers • Clean data • Reliable and documented definitions • Systematic and nimble reporting processes • Conversations with consumers of information

  6. What most of us actually have… • Limited staff and time • Limited funding • Decent computer skills • Support for improving our processes • A rough idea where we want to go

  7. For Today’s Attendees . . . • Can you author your own queries from your university data? • Do you have access to directly query your university data? • Can you build a pivot table in MS Excel? • Have you worked with Tableau Software?

  8. Let’s Start Something! • Census Data • Survey Data • Degrees Conferred Data

  9. Census Enrollment Data • Characteristics: • Snapshot from the 12th class day • One line per student • Variety of demographic-style elements about each student

  10. < show Census data in MS Excel > • < demonstrate filters and Pivot Tables >

  11. Let’s Start Something! • Census Data • Survey Data • Degrees Conferred Data

  12. < show SURVEY data in MS Excel > Additional Resources from the Tableau Knowledge Base Preparing your MSExcel data: http://kb.tableausoftware.com/articles/knowledgebase/preparing-excel-files-analysis Installing the Tableau Add-In for data reshaping: http://kb.tableausoftware.com/articles/knowledgebase/addin-reshaping-data-excel

  13. Survey Data • Characteristics: • Content only from those surveyed • One line per student • Some blank entries • Survey responses can be grouped and displayed different ways

  14. Let’s Start Something! • Census Data • Survey Data • Degrees Conferred Data

  15. Degrees Conferred Data • Characteristics: • From the student degree table in BANNER • One line per student • Variety of demographic-style elements about each student

  16. < demonstrate interaction in TABLEAU >

  17. MS Excel and Tableau MS Excel: Delivery and Security • .xslx file on Intranet • Sharepoint Sustainable reporting Cost Tableau Software: Delivery and Security • .twbx files on intranet • Public and Digital • Server Cost

  18. Report Examples • Daily Enrollment Report • *The reports refresh each morning at 7 am.

  19. Report Examples • Census • *The reports are ready for proofing the afternoon of the Census pull.

  20. Report Examples • Course Schedules

  21. Report Examples • Funnel of New-Student Applications

  22. Report Examples • Retention • *Your data should tell a story… easily.

  23. Report Examples • NSSE

  24. Report Examples • Degrees Conferred

  25. Report Examples • Peer Reviews • *From IPEDS Data

  26. What is great about both tools • Interactivity with data can be built for end user • Can be used to improve data quality • Smart setup and time spent on the front end = gain of precious time

  27. Other Considerations:Where’s the Data? Variety of connection options available when developing reports, so consider: • Size and source of data • Scope • Speed of connection to data • Scripting • Sustainability • Security (protection of contents) • Use

  28. Other Considerations:Where’s the Report Going? • Change in approach to data • Initial users, both to develop and to consume • Delivery of information • Purpose of report • Need for interactivity • Home location of raw data • Security (who gets permission to use report) • Storage of reports / access locations

  29. Of course, it doesn’t hurt to have a celebrity endorsement... Garrison Keillor of The Prairie Home Companion

  30. Contact Us Dr. Glenn James Associate Provost and Director of Assessment University of the Incarnate Word gjames@uiwtx.edu Robin Logan Director of Institutional Research University of the Incarnate Word rlogan@uiwtx.edu

More Related