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
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.
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).
Once logged in, the database will look like this
Select a project from the table on the left to view an overview of the project.
Click on the
Data tab to view the data associated with the project you selected
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.
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.
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.
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:
Submit and run yourself in the study. It should take 2-3 minutes.
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.
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 the
Exclude 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!
Downloading data is pretty straightforward, just click the
Export data as CSV button at the bottom of a project's data table!
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.