July 30, 2020 The BMS lab

Metrics and export data

Quick guide

Metrics and Exporting Data

Step 1.

On the left menu go to metrics. Your data metrics will consist of the responses and information your participants provide during their answering of your modules. The metrics page will show you an overview of data for all the participants in your study.

Participants are indicated by an ID number, which has replaced participants’ email address. The email address will thus not be shown in the overview or downloaded data. 

You can use the Intervention and Module dropdown fields to filter your participants by either Intervention or Module.

You can also check the ‘Show Timings’ checkbox and it will show you the length of time it took each participant to answer in a box to the right of the item.  

The items will be organized by Module, which are in the yellow bars. 

Step 2.

You can also export your data, on the top click on download. Here you can download the data from each intervention.

Importing Data in Excel

Step 1.

Open Excel. Open excel, go to the Data tab, in the Get & Transform Data group, click From Text/CSV. This will open a preview screen. Look for your data file and click on ‘import’.

Step 2.

In the preview screen the delimiter should be set to a comma. Select load to import the data into a new worksheet.

Importing Data in SPSS

Step 1.

Open SPSS. Go to file –> open –> data. This will open a new window. Make sure your files type is set to CVS. Find your data, select your data and open. This will open the ‘Text import Wizard’ with six steps.

Step 2.

Step 1. Going through the steps of the import wizard, don’t change any of the settings in the first step.
Step 2. Set the variables arranged to ‘delimited’, set the question ‘are variable names included at the top of your file’ to ‘yes’. Click on next.
Step 3. Set ‘the first cases of data begins on which line number’ to ‘2’.
Step 4. Set the delimiter to a Comma. Click on next.
Step 5. Here you can change the variable names, this can also be done on a later time.
Step 6. Don’t change any of the settings. Click on ‘finish’ and your data will appear in a new SPSS worksheet.