LibraryDashboard-Long-CIL2014

How to create a dashboard of library statistics using Zoho Creator, Sheetsee.js, and Foundation HTML5 framework.

Transcript

1. what does the dashboard tell us? Amy Deschenes
2. making data behave It doesn’t have to be hard. (And might even be fun!)
3. In 3 Easy Steps
4. #1
5. Data Collection Process Define a
6. #2
7. Best Tool Implement the
8. #3
9. Online Presentation Create an
10. Data Collection Process Define a
11. who wants to know? And what do they care about?
12. College Administration Student Researchers Benchmarking Surveys Accreditation Reports Library Director Provost’s Office
13. Collections Interlibrary Loan Requests Budget Website Statistics Reference Transactions Circulation E-Resources Usage Information Literacy Presentations Course Reserves Gate Count & Hours Open
14. when do they need it?
18. how do we get the data?
24. That’s Me!
25. where do we store it?
26. where do we store it? And how does it stay organized?
27. Best Tool Find the
30. Excel is GOOD for SMALL DATASETS and is FAMILIAR and FLEXIBLE. http://schoolofdata.org/2013/11/07/sql-databases-vs-excel/
31. Excel is BAD at ANSWERING DETAILED QUESTIONS and enabling COLLABORATION. http://schoolofdata.org/2013/11/07/sql-databases-vs-excel/
32. Collections Interlibrary Loan Requests Budget Website Statistics Reference Transactions Circulation E-Resources Usage Information Literacy Presentations Course Reserves Gate Count & Hours Open
33. Relational Database We Need a
34. MySQL versus Zoho Creator versus Google Docs
35. MySQL versus Zoho Creator versus Google Docs
41. what we did...
42. Setup a fixed SCHEDULE for data collection and entry.
43. Entered questions into the database for CURRENT and PREVIOUS years.
44. TRAINED STAFF on how to enter data in the new system.
45. And communicated SCHEDULE EXPECTATIONS.
46. results
48. 3 Years of Data that is •reliable, •searchable, •easy-to-read, •accessible anywhere.
49. Established a repeatable process for the ongoing collection of statistics.
50. Online Presentation Create an
51. helpful tools For Building the Dashboard
52. Sheetsee.js Visualize Statistics with
53. Jessica https://github.com/jlord
59. Using SHEETSEE.JS, we created a simple Library Statistics Dashboard
61. https://docs.google.com/a/ simmons.edu/spreadsheet/ccc? key=0AiyNu1silQeAdDMxYXI2V HEzXzVsVGNtdVc5TnlZTXc&usp= drive_web#gid=0
62. https://docs.google.com/a/ simmons.edu/spreadsheet/ccc? key=0AiyNu1silQeAdDMxYXI2V HEzXzVsVGNtdVc5TnlZTXc&usp= drive_web#gid=0
63. <script type="text/javascript"> document.addEventListener('DOMContentLoaded', function() { var dashboard var URL = "0AiyNu1silQeAdDMxYXI2VHEzXzVsVGNtdVc5TnlZTXc" Tabletop.init( { key: URL, callback: showInfo, simpleSheet: true } ) }) function showInfo(data, tabletop) { dashboard = data console.log("here is data", dashboard)
64. <script type="text/javascript"> document.addEventListener('DOMContentLoaded', function() { var dashboard var URL = "0AiyNu1silQeAdDMxYXI2VHEzXzVsVGNtdVc5TnlZTXc" Tabletop.init( { key: URL, callback: showInfo, simpleSheet: true } ) }) function showInfo(data, tabletop) { dashboard = data console.log("here is data", dashboard)
68. We wanted our data to TELL A STORY. (And look super cool)
69. Goals for the DASHBOARD Interactive Visual Student-Focused
70. Responsive Framework Find a
71. What’s an HTML5 framework?
72. Freely available set of HTML, CSS, JS files that provide a basis for RAPID Web Development.
75. http://designinstruct.com/web-design/ responsive-css-grid/ Compare ‘Em!
76. http://designinstruct.com/web-design/ responsive-css-grid/ Compare ‘Em! Learn More! http://talks.ns4lib.com/future-friendly/
77. Download the files and CUSTOMIZE to match your institutional branding and POPULATE with content.
78. Using the Foundation Framework AND our data from Zoho Creator
79. We created the Library Year-In-Review
81. It is: Interactive Visual Student-Focused
82. On Hover
83. Links On Hover
84. Links On Hover Quantitative
85. Links On Hover Quantitative Qualitative
86. Easy-to-Understand
89. Let’s Recap
90. 3 Easy Steps
91. #1
92. Data Collection Process Defined a
93. #2
94. Best Tool Implemented the
95. #3
96. Online Presentation Created an
97. See it in action beatleyweb.simmons.edu/assessment Amy Deschenes deschene@simmons.edu