If your organisation allows it the Grasple platform offers you the possibility to export
different datasets related to a course in a CSV format. These exports can be found on the dedicated 'Data Export' page. This page can be reached via both the monitor and the test-page for a course. 

If you do not see this option either your organisation does not offer this possibility, or you are not a teacher in the course which you want to export data from.

Available datasets

The data export page currently offers the following datasets, which can be divided into two groups.

Structure datasets:

Progress datasets:

  • Student Progress - the progress (based on activity) of single student within this course
  • Subject Attempts - all practice attempts of all students for all subjects in this course
  • Subject Results - the highest score for all students for all subjects in this course
  • Test Attempts - all attempts of all students for all tests in this course
  • Test Results - the highest score for all students for all tests in this course

Below you can find the column descriptions of each dataset. Please feel free to reach out to us if anything is unclear or if you are missing any data. 

Date filtering:

The export page offers you the possibility to filter the datasets based on a start-date and an end-date. These dates are only taken into account for the progress datasets. Only attempts / answers started after the start-date and before the end-date will be included. 

In addition, the 'finished' status takes into account the end-date. Thus, a test-attempt which is not submitted before the end-date will not be taken into account in, for example, the calculation of the highest score. The goal is to mimic the behaviour of the export page as if you would have exported the data on the specified end-date.

Important considerations

The data export functionality comes with three important notes. 

First, please be aware that the datasets are currently not filtered on, for example, time and content. By offering you detailed datasets we hope to give you the flexibility to analyse the data in the way you desire. 

Secondly, the data is collected in a non-controlled setting. Please take into account the data disclaimer when analysing the data and making conclusions. 

Lastly, the datasets can contain personal information of students. Please take into account the guidelines of your institution when handling and processing this data. When downloading the data it becomes your responsibility.  

Detailed descriptions of the datasets

The following sections each describe the details of a data-set. 

Note: for all datasets we add a column 'student_id' after the other user-related columns if this data is available for your organisation. 

Course Structure

A row represents: a single course element
Available columns:

  • id: the id of the course element
  • type: the type of the course element, either ‘test’ or ‘subject
  • name: the name of the course element’
  • element_index: the index of the element in the module, lower means earlier in the module.
  • module_name: the name of the module this element belongs to
  • module_index: the index of the module in the course structure, lower means earlier in the course

Course Students

A row represents: a single student in the course
Available columns:

  • user_id: the id of the user (can be empty if the user is not registered)
  • name: the name of the user
  • email: the email address of the user
  • registered: whether the user is registered in the course
  • group_name: the name of the course-group a student is in (possibly empty) 

Student Progress

  • user_id: a unique identifier for a user
  • user_name: the name of the user
  • user_email: the email address of the user
  • #exercisesAnswered: the total number of answers given in a subject exercises part or a test
  • #correctAnswers: the total number of correct answers given in the first answer attempt
  • #subjectsCompleted: the number of unique subjects completed by practice in the given context
  • #testsCompleted: the number of unique tests completed in the given context

Note: this dataset is purely based on the activity of a student in the platform. Therefore, the progress of a student does not necessarily correspond to the colours on the level-map as the latter one also changes based on test results.

Subjects

A row represents: a single subject
Available columns:

  • subject_id: a unique identifier for the subject
  • subject_name: the name of the subject
  • #studentsStartedExercises: the total number of students which started the exercises of this subject
  • #studentsFinishedExercises: the total number of students which finished the exercises of this subject
  • hasLesson: boolean indicating whether the subject has a lesson part
  • #exercisesAnswered: the total number of answers given to exercises in this subject 
  • averageScore: the average of the highest score per student that finished an exercise-session in this subject

Subject Attempts

A row represents: a single attempt of a student for the exercises part of a subject
Available columns:

  • subject_id: a unique identifier for the subject
  • subject_name: the name of the subject
  • user_id: a unique identifier for a user
  • user_name: the name of the user
  • user_email: the email address of the user
  • #exercisesAnswered: the total number of answers given to exercises in this attempt
  • score: the score calculated for this attempt (empty if attempt is not finished)
  • finished: a boolean indicating whether the attempt is completed 
  • started_at: the timestamp of when the attempt was started
  • finished_at: the timestamp of when the attempt was completed (empty if attempt is not finished)

Subject Results

A row represents: the (highest) score for a student / subject combination
Available columns:

  • user_id: a unique identifier for a user
  • user_name: the name of the user
  • user_email: the email address of the user
  • subject_id: a unique identifier for the subject
  • subject_name: the name of the subject
  • subject_index: the index of the subject in the complete course
  • max_score: the highest score obtained for this student on this this, '-' if there is no score.

Note: this dataset contains a row for each student / subject combination in the course, not only the rows for students that attempted a given subject.
Also note that this dataset is purely based on the activity of a student in the platform. Therefore, the result of a student does not necessarily correspond to the colours on the level-map as the latter one also changes based on test results.

Options:

  • Create pivot table with subjects as columns:
    When selected output of the dataset will be changed into the following format:
    A row represent:
    all highest scores of a single student
    Available columns:
    -
    user_id: a unique identifier for a user
    - user_name:
    the name of the user
    - user_email: the email address of the user
    - [subject-name]: the highest score of this subject for the student  
    This column is repeated for all subjects in the course.

Tests

A row represents: a single test in the course
Available columns:

  • test_id: a unique identifier for the test
  • test_name: the name of the test
  • #studentsStarted: the total number of students which started this test
  • #studentsFinished: the total number of students which finished this test
  • #exercisesAnswered: the total number of answers given to exercises in this test
  • averageScore: the average of the highest score per student that finished the test

Test Attempts

A row represents: a single attempt of a student for a test
Available columns:

  • test_id: a unique identifier for the test
  • test_name: the name of the test
  • user_id: a unique identifier for a user
  • user_name: the name of the user
  • user_email: the email address of the user
  • score: the score of this attempt (empty if attempt is not finished)
  • finished: a boolean indicating whether the attempt is completed 
  • started_at: the timestamp of when the attempt was started
  • finished_at: the timestamp of when the attempt was completed (empty if attempt is not finished)

Test Results

A row represents: the (highest) score for a student / test combination
Available columns:

  • user_id: a unique identifier for a user
  • user_name: the name of the user
  • user_email: the email address of the user
  • test_id: a unique identifier for the test
  • test_name: the name of the test
  • test_index: the index of the test in the complete course
  • max_score: the highest score obtained for this student on this this, '-' if there is no score.

Note: this dataset contains a row for each student / test combination in the course, not only the rows for students that attempted a given test.

Options:

  • Create pivot table with tests as columns:
    When selected output of the dataset will be changed into the following format:
    A row represent: all highest scores of a single student
    Available columns:
     -
    user_id: a unique identifier for a user
     - user_name: the name of the user
     - user_email: the email address of the user
     - [test-name]: the highest score of this test for the student
       This column is repeated for all tests in the course.
Did this answer your question?