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

[Neal Caidin]

What do you think of the enclosed chart (PDF)? 

I normalized with respect to site info, where site info is 100% and everything else is a proportion relative to it. I made the cutoff 5%, rounded up (Kaltura is 4.8%).

I'll change the title.

Thanks,
Neal


-------------- next part --------------
A non-text attachment was scrubbed...
Name: tools_normalized.pdf
Type: application/pdf
Size: 45890 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai2-tcc/attachments/20130714/838a336e/attachment-0001.pdf 
-------------- next part --------------

On Jul 12, 2013, at 8:23 AM, Jean-Francois Leveque <jean-francois.leveque at upmc.fr> wrote:

> In tools deployed, I would normalize sakai.siteinfo to 100% because it 
> would make the percentages more realistic.
> 
> Cheers,
> J-F
> 
> On 12/07/2013 13:07, Neal Caidin wrote:
>> Okay, so since I've not heard any additional feedback, I'll publish the
>> survey graphs as-is, and I'll publish the raw summary data and notify
>> the community. Still not 100% sure about how to use the comments, but I
>> should go back and consider them more (possibly following with specific
>> institutions, etc).
>> 
>> It might be useful, also to have another discussion about the data and
>> what we think it shows. One thing that came out of this is some momentum
>> to possibly include the Yale Sign up tool, the #1 used Contrib tool
>> according to the survey.
>> 
>> :-)
>> 
>> Cheers,
>> Neal
>> 
>> 
>> 
>> On Wed, Jul 10, 2013 at 4:51 PM, Neal Caidin <neal.caidin at apereo.org
>> <mailto:neal.caidin at apereo.org>> wrote:
>> 
>>    At the TCC - CLECC meeting on Tuesday, I was hearing that I should
>>    publish the graphs pretty much as they are. Any objections?
>> 
>>    I'm also thinking I could publish the raw aggregate data from the
>>    SQL, in addition to, not instead of, the charts I've produced, on
>>    the off chance someone may want to play with the information to
>>    visualize it in a different way.
>> 
>>    Any objections?
>> 
>>    Thanks,
>>    Neal
>> 
>> 
>>    On Jul 9, 2013, at 11:37 AM, Neal Caidin <neal.caidin at apereo.org
>>    <mailto:neal.caidin at apereo.org>> wrote:
>> 
>>> 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
> _______________________________________________
> sakai2-tcc mailing list
> sakai2-tcc at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai2-tcc