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

[Jean-Francois Leveque]

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