oh, the things you can think! how to really see your assessment data cs-150 (strand 5) monday,...
TRANSCRIPT
![Page 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/1.jpg)
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 JamesUniversity of the Incarnate Word, San Antonio TX
![Page 2: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/2.jpg)
Today
1. Identify some strategies for data setup
2. Build interactive tables in MS Excel
3. Demo interactive graphics in Tableau
BIG Idea: we’ll share our process for visualizing data for diverse users
![Page 3: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/3.jpg)
After our session, you should be able to . . .
1. Recognize and use basic file structures that make your data analysis easier.
2. Build MS Excel filters and pivot tables.
3. Use interactive graphics in Tableau Software worksheets and dashboards.
4. Advise colleagues on steps to use interactive tools to visualize your data.
![Page 4: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/4.jpg)
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
![Page 5: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/5.jpg)
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
![Page 6: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/6.jpg)
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
![Page 7: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/7.jpg)
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?
![Page 8: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/8.jpg)
Let’s Start Something!
1. Census Data
2. Survey Data
3. Degrees Conferred Data
![Page 9: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/9.jpg)
Census Enrollment DataCharacteristics:•Snapshot from the 12th class day•One line per student•Variety of demographic-style elements about each student
![Page 10: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/10.jpg)
< show Census data in MS Excel >• < demonstrate filters and Pivot
Tables >
![Page 11: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/11.jpg)
Let’s Start Something!
1. Census Data
2. Survey Data
3. Degrees Conferred Data
![Page 12: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/12.jpg)
< show SURVEY data in MS Excel >
Additional Resources from the Tableau Knowledge BasePreparing 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
![Page 13: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/13.jpg)
Survey DataCharacteristics:•Content only from those surveyed•One line per student•Some blank entries•Survey responses can be grouped and displayed different ways
![Page 14: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/14.jpg)
Let’s Start Something!
1. Census Data
2. Survey Data
3. Degrees Conferred Data
![Page 15: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/15.jpg)
Degrees Conferred DataCharacteristics:•From the student degree table in BANNER•One line per student•Variety of demographic-style elements about each student
![Page 16: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/16.jpg)
< demonstrate interaction in TABLEAU >
![Page 17: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/17.jpg)
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
![Page 18: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/18.jpg)
Report ExamplesDaily Enrollment Report
*The reports refresh each morning at 7 am.
![Page 19: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/19.jpg)
![Page 20: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/20.jpg)
![Page 21: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/21.jpg)
Report ExamplesCensus
*The reports are ready for proofing the afternoon of the Census pull.
![Page 22: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/22.jpg)
![Page 23: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/23.jpg)
![Page 24: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/24.jpg)
Report ExamplesCourse Schedules
![Page 25: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/25.jpg)
![Page 26: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/26.jpg)
Report ExamplesFunnel of New-Student
Applications
![Page 27: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/27.jpg)
![Page 28: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/28.jpg)
Report ExamplesRetention
*Your data should tell a story… easily.
![Page 29: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/29.jpg)
![Page 30: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/30.jpg)
Report ExamplesNSSE
![Page 31: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/31.jpg)
![Page 32: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/32.jpg)
Report ExamplesDegrees Conferred
![Page 33: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/33.jpg)
![Page 34: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/34.jpg)
Report ExamplesPeer Reviews
*From IPEDS Data
![Page 35: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/35.jpg)
![Page 36: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/36.jpg)
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
![Page 37: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/37.jpg)
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
![Page 38: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/38.jpg)
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
![Page 39: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/39.jpg)
Of course, it doesn’t hurt to have a celebrity
endorsement...
Garrison Keillor of The Prairie Home Companion
![Page 40: 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](https://reader034.vdocuments.us/reader034/viewer/2022050714/56649cf45503460f949c18bf/html5/thumbnails/40.jpg)
Contact Us
Dr. Glenn JamesAssociate Provost and Director of AssessmentUniversity of the Incarnate [email protected]
Robin LoganDirector of Institutional ResearchUniversity of the Incarnate [email protected]