[ned] Re: Statistics&Scripts
- From: Melissa Yamson <melissa.yamson@xxxxxxxxx>
- To: ned@xxxxxxxxxxxxx
- Date: Mon, 1 Oct 2012 17:04:40 +0800
Hi
Would like to suggest the following:
1. In the NED Admin Console (NED server management), include advance
filtering of the statistics database (view the result, and exportable to
excel, csv, pdf or other format). Please see propose setup below.
a. Date from and Date to: (From DD/MM/YYYY to DD/MM/YYYY)
b. Username
c. Device ID
d. Type / activities: (user_logged, browse, download, play item,
app_exit, library add, delete)
2. In terms of the statistics database
Current setup:
Id
username
deviceid
type
details
time
812
afi
358272043146623
USER_LOGGED
afi
Tue Mar 20 13:45:03 GMT+08:00 2012\par
813
afi
358272043146623
LIBRARY_ADD
Id=test;Title=test;Ver=1;
Tue Mar 20 13:45:41 GMT+08:00 2012\par
814
afi
358272043146623
BROWSE_LIBRARY_OPEN
Id=test
Tue Mar 20 13:45:48 GMT+08:00 2012\par
824
afi
358272043146623
DOWNLOAD_COMPLETED
Url=
http://203.177.165.52:8080/test/nokiaecd/videos/EE8001.mp4Progress=100.00;Status=Completed
;
Tue Mar 20 14:07:24 GMT+08:00 2012\par
825
afi
358272043146623
PLAY_ITEM_START
Id=EE8001;Type=Video;Title=EE8001 New Student;
Tue Mar 20 14:07:49 GMT+08:00 2012\par
12305
mindanao
358272044865874
PLAY_ITEM_START
Id=FT-EE8051;Type=Video;Title=FT-EE8051;
Wed Sep 19 16:32:29 GMT+08:00 2012\par
12306
mindanao
358272044865874
PLAY_ITEM_END
Id=EE56;SUCESS;
Wed Sep 19 16:33:00 GMT+08:00 2012\par
Comments:
a. Same with Matt, change the date and time format. And date and time
should be in separate fields.
Propose format for date is Day DD/MM/YYYY
Propose format for time is HH:MM (24-hours format)
b. Include in the play item if the video is played using the TV-out
feature of the phone
3. In the NED client,
Current setup:
The video titles are listed in the statistics, regardless if it is full or
partial viewed.
Propose setup:
a. The videos are listed in the statistics that are full viewed only
(from the start to end)
b. A counter should be included. For example:
Verb 1
Noun 2
Ecosystem 6
Addition 9
c. Include also last video fully viewed (include time and date), and
video downloaded (include time and date) and updated (include time and
date). (are these possible?)
Thanks. Melissa
On Wed, Sep 26, 2012 at 7:18 PM, Matthew Wennersten <matt@xxxxxxxxxxx>wrote:
> Dominik,
>
> Thanks for your invitation to comment.
>
> We work with the current stats log in Excel, as follows:
> *id username deviceid (IMEA) Action_type Action_details timestamp*
>
> Requests for statistical changes, if possible:
>
> - Parse the "details" field so that data elements like
> "Id=E103a;Type=Video;Title=E103a-Prepositions;" or "Url=
> http://bridge-it.in:8080/Bridgeit/nokiaecd/videos/E141a%2DSven%20Said%20Ten%20Tents.mp4Progress=100.00;Status=Completed;";
> appear in separate columns (i.e. "E103a", "Video", "E103a-Prepositions", or
> "http://...";, "Completed" and put this field on the end so that we don't
> have to worry about variable line length (or add spacers to the other
> fields so that data appears in consistent columns)
>
> - Change the formatting of the timestamp so that it is easier to parse in
> Excel or databases (e.g. 08/01/12 11:32:40 instead of Wed Aug 01 11:32:40
> GMT+05:30 2012) NOTE: please don't remove the time from the time stamp, as
> the difference between PLAY_ITEM_START and PLAY_ITEM_END allows us to
> observe how many minutes of video watching a class experiences
>
> - Update NED server stats download to include a date range, so we don't
> have to download all the stats every time
>
> - Add a filter to download stats for a range of users, e.g. only
> ap01-ap99, ideally, a dialog/check box (with select all) to download stats
> for selected users
>
> We run two pivot table reports in Excel from the NED stats - number of
> videos downloaded by user per month and number of videos played by user per
> month. To generate the reports, we apply formulas to parse the month and
> then check whether the Action_type field is either "DOWNLOAD_COMPLETED" or
> "PLAY_ITEM_END".
>
> We're also interested in figuring out "total time used during the school
> day", which we can calculate by formula, but it's tricky (first you have to
> sort to get the login and exit time for each user together, then you have
> to calculate the time difference) . If it would be possible to record
> "total time logged in" when we app_exit that would be useful.
>
> A sample is enclosed, with the three pivot tables (Play, Download,
> TimeLoggedIn) and the statistics.csv raw data with the formulas used to
> create the tables.
>
>
> Finally, we'd LOVE to get a stat showing us whether or not a TV-out cable
> is connected when a video is played.
>
> Cheers,
>
> Matt
>
> P.S. Please let me know if you would like me to enter any of these as
> tickets in http://projects.developer.nokia.com/NED
>
> On 25-Sep-2012, at 1:03 PM, Dominik Frankowski wrote:
>
> Hi,
>
> Analyzing statistical data from NED is very important part of the whole
> program. Most likely you have already prepare some reports, to check if NED
> really helps and make a difference in both teaching and learning.
> I guess, that some of you, over the year(s) prepare nice set of scripts and
> macros.
> Maybe, you would like to contribute to NED with those? If so please send it
> to this mailing list or directly to me.
> You work will be included into the next release.
>
>
> From the other hand maybe there is something missing in statistics? Maybe
> you would like to collect some other data, events?
> Right now is a good moment to express your expectation about those?
>
>
> Cheers,
> Dominik
>
>
>
>
>
> Matt Wennersten
> Head - Scalability in Education
> +91 95000 35312
> matt@xxxxxxxxxxx
>
>
>
>
>
Other related posts:
