[sakai2-tcc] Wrapping up Tools Survey/SQL Data

[Neal Caidin]

Hi TCC !

One of the items I was hoping to discuss at our meeting today at 1 pm Eastern ( 5 pm GMT) is wrapping up the Tools Survey/ SQL Data effort.  If you were at the Open Apereo Conference, or if you've been checking the updates on Dropbox, this will not be completely new to you.

SQL queries at - https://confluence.sakaiproject.org/display/TCC/CLE+Tool+Use+Queries


The enclosed files represent:

* Tools_Survey_Results_2013 (pdf) is the same chart as you saw at the Open Apereo Conference except that I've stacked the tools from highest to lowest percent and included the percent of "yes" votes in parenthesis (thanks to Aaron for part or all of this suggestion) .  

* SQL_data_summary_pdf - has charts representing the aggregation of the Sakai Tool Events query and the Sakai Tools Placement query.  The data for each institution was converted to a percentage and then aggregated, each institution's results counting for the same weight.  Specific tools did end up getting weighted in that a tool might be used at one institution but not another, no normalization technique was attempted.

* events_sql_aggregation.csv   - the Sakai Tool Events aggregation - raw summary data 

* events_summary_ranking.csv - same data as events_sql_aggregation but rolling up a summary on the event "prefix", the portion of the event id that is to the left of the first period. For example asn.read.submission and asn.grade.submission would roll up under one entry - "asn"  . Data visualized in SQL_data_summary_pdf

* tool_sql_aggregation.csv - the Sakai Tools Placement query aggregation. Data visualized in SQL_data_summary_pdf

Thoughts/Feedback
------------------------------
I'm mostly happy with the Tools_Survey_Results_2013 and will publish if you are happy with that too.

I'm not confident that the SQL_data_summary_pdf charts actually "say" anything meaningful. I was thinking maybe just releasing the raw aggregate data instead. Or maybe someone in the Community (or TCC) will come up with a better way to visualize. 

What do you think?

Thanks,
Neal Caidin

Sakai CLE Community Coordinator
Apereo Foundation


 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: SQL_data_summary_pdf.pdf
Type: application/pdf
Size: 185709 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai2-tcc/attachments/20130709/410c04e0/attachment-0002.pdf 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Tools_Survey_Results_2013.pdf
Type: application/pdf
Size: 29827 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai2-tcc/attachments/20130709/410c04e0/attachment-0003.pdf 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: events_sql_aggregation.csv
Type: text/csv
Size: 15627 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai2-tcc/attachments/20130709/410c04e0/attachment-0003.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: events_summary_ranking.csv
Type: text/csv
Size: 1059 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai2-tcc/attachments/20130709/410c04e0/attachment-0004.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: tool_sql_aggregation.csv
Type: text/csv
Size: 7029 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai2-tcc/attachments/20130709/410c04e0/attachment-0005.bin