4. Working with lab data

Learn how to work with data in the lab

By the end of this section, you should:

  • Have access to the lab's database via two-factor authentication

  • Know how to view, update, and download lab data

Prerequisites

  • To view or download lab data, you'll need to an invitation to the lab's database. Ask Katie to grant you permission when you are ready to start this part of the tutorial.

Step 1: View data

Two-factor authentication

To view data in the lab's database, you'll choose sign-in with google. You'll be prompted to enter your code from your authenticator app (we use Google Authenticator).

Enter your code from Google Authenticator on your phone

If this is your first time, you'll be prompted to set up this authentication. First, install Google Authenticator on your phone and follow the steps to set it up.

View a project

Once logged in, the database will look like this

Screenshot of our database landing page

Select a project from the table on the left to view an overview of the project.

Note that you won't be granted access to view projects in the database until you have been added to the lab's IRB protocol for that project. If you only see training-project that means you have not yet been granted permission to view other data.

View data for a project

Click on the Data tab to view the data associated with the project you selected

Select Data tab to view the project's data

View a specific run

Each run of an experiment is a row in the data table. Click on the View button in the Actions column of the data table to view that particular run in more detail.

Raw Data for one run in an experiments

Click on the Recordings button for a particular run to see any recordings associated with that run (usually audio or video files). Recordings, if available, will appear in a table as below.

Recordings for this run of an experiment

Note that not all experiments will have recordings

Step 2: Update data

Now that you know how to view the data for a project, let's practice updating a run of an experiment. Research assistants will sometimes be asked to do this to indicate notes about a run. For example, if you ran a child in a study and their mom picked them up early, you could note it this way.

Run in the training study

To get a sense for how this works, run yourself in the training study! Visit training.childlanglabexperiments.org and fill and make the following selections:

Make these choices and run yourself in the training study

Hit Submit and run yourself in the study. It should take 2-3 minutes.

View your run

When you've finished, you should see your data in the training-project data table. You can tell by checking the daterun column. If you don't see your run, hit the reload button at the bottom of the table.

Use the reload button (bottom left) to refresh the table

Click on your run to view the details. Again, make sure it is indeed your run — the daterun column should match the day and time you ran in the study.

Practice updating data in the database by marking your run excluded with theExclude this run button. Then leave a note in the box to let us know it was your training run (e.g. "[Yourname]'s training run."). Press Update run to ensure your changes save!

Use the Notes box to update the run

Step 3: Download data

Download all data

Downloading data is pretty straightforward, just click the Export data as CSV button at the bottom of a project's data table!

Download some data

However, sometimes you might want to only get *some* of a project's data. To do that, you can use the filter button at the bottom left of the table.

This will allow you to filter the data based on the available columns. If you have a filter applied and your click Export data as CSV, you will only export the *filtered* data.

Wahoo! You've finished the fourth part of the Onboarding Tutorial. For some of you, this was your last step! For others, you'll also be asked to complete the advanced moves.