The Claned platform collects comprehensive learning activity and results data. While some selected analysis examples are available in the board analytics tab, the Data Export Tool (hereafter abbreviated as DET) allows you plenty of freedom to export the data that you require to the analysis tools that you prefer to use. In short, the DET is the middleware that enables custom analytics at your end.
The exported data is tabular and saved to your computer as a CSV file i.e., a plain text file with comma-separated values per row. Most spreadsheet software, such as Microsoft Excel, can easily import CSV files. In the typical Python environment, e.g., JupyterLab, you can easily use the Pandas data analysis library to load these CSV files.
If you need a more comprehensive explanation about the specifics of the tool, please click here.
1. Navigate to the Organization Admin page
2. Click on the "Advanced" tab
3. Scroll down to the "Download data" section
4. Click on "Select Data"
5. Navigate to the list of datatypes in the "Select the type of data" menu
6. Select the needed data from the list
For this specific data export, we want to see how users are doing on our boards. The following data type selections provides a holistic view of users' overall progress.
-
Board score (shows users' overall scores)
-
Assessment completion (shows if a user as completed a given assessment)
-
Assessment score (shows a user's score for a given assessment)
-
Media resource progress (a calculation of how much of the board's content a user has viewed, expressed in %)
-
Content view (shows what content a user has viewed on a board)
You can, of course, remove these selections or add others from the list according to your data needs.
7. Click on the calendar icons in the "Select time period" and adjust the timeframe for the data export as needed
8. The "Filter users" section allows you to include only specific groups into the data export
To be able to fetch data from specific groups of users we recommend using filters. You can choose any existing group(s) in your organization. Doing so will only include data from users who are members of the selected groups. You can filter either by group name, labels, or both.
9. In the "Filter content" section, you can choose to fine-tune your data by filtering by a board, content type, or content labels
Filter by board:
You can choose any boards you want to fetch the data from. You can choose any, none or just one. The default is no filter, meaning all boards will be included in the report dependent on any other filters you may have chosen. The board name will be displayed in the report so you can easily see the differences between the groups.
Filter by content type:
You can choose which content types you want to include. By default, it will show data from all content types but you can choose combinations of any items.
Filter by labels:
You can choose which specific content items you want to include based on their labels. If no labels exist, then no data will appear in the selection list.
10. In the "Group the data" section, you can choose to group the data in the export spreadsheet to whatever row/column format you desire
Groupings are an easy way to help with organization of the data file. The grouping section of the data export tool has two primary elements, 1. grouping (column and row, both can be selected), and 2. a calculation type. When a grouping option is selected from either the column or row menus, the calculation menu will appear (“Select how data will be calculated”). Data will be condensed into just one row (e.g. each user has only one row) or column (e.g. each board shared to your organization has its own column). The data value in each cell will be aggregated based on what calculation you select in the “Select how data will be calculated” menu. You can choose to calculate data by Sum, Average, Count, Minimum value, or Maximum value.
Use cases: For most cases, we recommend using grouping for the sake of easier parsing of the data report file. However, if you want, for instance, track all login events from all users of a group, then select the login datatype, filter by the relevant group, and do not apply any grouping. This will return each login event as a row. Alternatively, if you want to see the total number of logins for each user in a group, then follow the first two steps mentioned above, but this time select “Each user as a row” grouping, and the “Count” calculation. The value shown in the data file is a number reflecting the total number of logins. Of course, we recommend experimenting with the different groupings to find the one that best suits your needs.
11. Note: please select the "Group users (rows)" if you chose the "Board score" datatype from step 6, as the calculation requires this.
12. Click on "Select how data will be calculated" to choose the data value aggregation method
Average will calculate the data to average. For example, average media resource progress or average skill rating for an item, if user had 0.5, 1, 0.75 and 0.1 as the reported media resource progress it would display value of 0.5875 as the average.
Sum will group the data to a sum of the values it has received. If user has scored 56, 21,17 and 80 for assessment if using sum as the calculation type it would be reported as 174.
Count will provide the total count of event disregarding the value of the item. For example each login event is reported as “1”, so count would provide each row with a login event and provide the value or rating events of 5,3,2,4 would be 4.
Max will report only the largest value.
Min will report only the smallest value.
13. Click on the "Filter preset" menu
We recommend saving your most frequently used exports as presets so you can easily run them again without having to select the data, filtering, and groupings.
14. Add a name for the preset and click "Save preset"
15. Generate the data export file by clicking "Generate file (CSV)"
17. A notification will be sent to your notifications center (the bell icon in the top right side of Claned). Click the text "Download the data here!" to download your export
