Export a list of all recording files: Daily CSV, all children, all dates

A Daily CSV for all Children, all dates is a master record of all recording files for all active children in your LENA database.  It should be exported prior to performing any data merge, move, or cleanup.  

Note: The resulting export will contain data for active child records only.  If you are preparing for a supported database merge or reprocessing, first check to see whether you have any inactive child records.  If you do, please contact LENA Support for next steps.

The CSV export presents the LENA Core Report, AVA, and Developmental Snapshot measures in tabular format, including:

  • Adult Words - actual counts, plus projected counts and percentiles where applicable (i.e., at the Daily or Monthly resolution for files containing >10 hours within a calendar day)
  • Conversational Turns - actual counts, plus projected counts and percentiles where applicable
  • Child Vocalizations - actual counts, plus projected counts and percentiles where applicable
  • Audio Environment summary information (percent “Meaningful,” “Distant,” “TV & Electronic Sounds,”, “Silence & Background,” and “Noise”)
  • AVA Report Data - standard scores and percentiles, daily and averaged where applicable
  • Snapshot Report Data - developmental age, standard score, and percentile

Tip: The following instructions can be adapted to meet other export goals.  Simply adjust the time resolution, select a specific date or date range, select a specific child or children, and/or deselect any of the specific reports.  

1. In Client Manager of LENA Pro, double click on any child record to get to the Reports screen.

In Client Manager of LENA Pro, double click on any child record to get to the Reports screen.

2. Click the Excel icon at the bottom left of the screen to pull up the Export Data window.

Click the Excel icon at the bottom left of the screen to pull up the Export Data window.

3. Select desired elements (resolution), dates, children, and reports.

The following instructions are specific to a daily CSV for all children, all dates as required prior to a data move or merge.  

To customize this export to suit other needs, adjust the time resolution, select a specific date or date range, and/or select a specific child or children.  

3.1. Under Report Elements, click the Daily radio button.

  • This will export a .csv with one row per recording day per child selected (as long as data exist in the system for that child).
  • Each row will display the child's child key, ID, last name, first name, birthdate, age on recording date, gender, and the DLP and filename associated with that recording date.
Under Report Elements, click the Daily radio button.

3.2. Select the All Dates radio button.

Select the All Dates radio button.

3.3. Click Select All to include all individuals in your LENA Pro database.

Click Select All to include all individuals in your LENA Pro database.

3.4. See that all Reports are selected.

See that all Reports are selected.

4. Click the CSV button to initiate the export.

Click the CSV button to initiate the export.

5. Save to a convenient location of your choice.

Save to a convenient location of your choice.

If the export is in preparation for a database merge, move, or clean-up, remember to save it to a location that will be accessible during that activity - perhaps a network location or external hard drive.

LENA will automatically name the exported file in the following way:

LENA Export (Time resolution) YYYMMDD HHMMSS.filetype

Example: LENA Export (Daily) 20140320 083436.csv

  • Date in YYYYMMDD format indicates the date of the export (March 20, 2014 in this example)
  • Time in HHMMSS 24-hour format indicates the time of the export (8:34:36 a.m. in this example)

If the CSV export is in preparation for a database merge please alter the filename to identify the source computer.

For example,

LENA Export (Daily) 20140320 083436_LanguageLab.csv

Column definitions

Column
Definition
Type
Time resolution of this export (Daily, Hourly, 5-Minute)
ChildKey Auto-generated unique identifier for this child
Id Child ID, auto-generated or user input
Lastname Child's last name
Firstname Child's first name
Birthdate Child's date of birth
Age Child's age at the beginning of the recording file, in months and days
Sex Child's sex
DLP Serial number of the recorder used to collect this information
ProcessingFile File name
Timestamp Beginning date or time of the interval displayed in this row
Duration Length of the data in this row, in HH:MM:SS
Meaningful Quantity of data in this time interval (row) which is meaningful, in HH:MM:SS
Distant Quantity of data in this time interval (row) which is distant/overlap, in HH:MM:SS
TV Quantity of data in this time interval (row) which is TV/Electronic media, in HH:MM:SS
TV.Pct Percent of the total data in this time interval (row) attributed to TV/Electronic media
Noise Quantity of data in this time interval (row) which is noise, in HH:MM:SS
Silence Quantity of data in this time interval (row) which is silence, in HH:MM:SS
AWC.Actual Actual number of adult words detected in this time interval (row)
AWC.Proj 12-hour projected value for adult words (daily and monthly exports only)
AWC.Pct Percentile ranking for adult words (daily and monthly exports only)
CTC.Actual Actual number of conversational turns detected in this time interval (row)
CTC.Proj
12-hour projected value for conversational turns (daily and monthly exports only)
CTC.Pct
Percentile ranking for conversational turns (daily and monthly exports only)
CVC.Actual Actual number of child vocalizations detected in this time interval (row)
CVC.Proj 12-hour projected value for child vocalizations (daily and monthly exports only)
CVC.Pct Percentile ranking for child vocalizations (daily and monthly exports only)
AVA_StdScore Automated Vocalization Assessment standard score
AVA_StdScore_Pct Automated Vocalization Assessment percentile rankings
AVA_AvgScore Automated Vocalization Assessment average standard score of most recent 3 eligible recordings
AVA_AvgScorePct Automated Vocalization Assessment percentile for average standard score of most recent 3 recordings
SS_DevAge Snapshot developmental age (shows on the daily export only)
SS_StdScore
Snapshot standard score (shows on the daily export only)
SS_StdScore_Pct Snapshot percentile (shows on the daily export only)