Reporting Data exports: Reading Minutes
The Reporting Data screen shows several export options. This article covers the exports related to participant Reading Minutes.
1. Select the highest organization or group of interest in the context menu.
If you select an organization (bold header in the hierarchy), the export will pull Reading Minutes records for all children in that organization and in any nested suborganizations within it.
To access data for an inactive/completed group or child, select the organization the group or child was in. You will be able to filter to see just the desired group or participants in later steps.
2. From the main menu, expand the Data section and select Data Exports.
3. Choose the Reporting Data tab.
4. Filter by date range and/or participant (optional)
Leave both Database Insert Date and Transaction Date blank to export data for all dates for the selected context and/or participant.
5. Click Reading Minutes button at bottom of screen.
The CSV file that downloads can be opened in Excel or other spreadsheet program for analysis.
List of exported fields and descriptions
|DateCompleted||Date the caregiver reported the minutes|
||Child's chronological age on date completed, expressed in months|
|ExcludedFromStarCalcs||FALSE = Regular reading minutes, included in star calculations
TRUE = Reading minutes from Snapshot, not included in star calculations
|ProgramType||LENA program the child is in (Grow, Home, Snapshot, SP, Start)|
|OrgID||LENA database ID number for participant’s organization|
|GroupID||LENA database ID number for participant’s functional group|
|RMGroupID||LENA database ID number for the group the participant was in when these minutes were reported.
Usually = GroupID; will differ if child has been moved between groups.
|ParticipantID||LENA database ID number for participant|
||Participant External Reference ID|
||LENA database ID number for these reported minutes|
|DatabaseInsertDateTime||Local date and time the minutes info was committed to LENA Online database; aligned to time zone of participant’s organization|