Understand the contents and structure of a program activity Excel report in PEARS.
Individual program activity Excel reports contain data from a single activity. This is different from program activity exports (available through the Analyze menu), which include multiple activities with expanded details such as site information and session data.
TIP: Download the Excel report from the program activity detail page before performing your analysis.
Report Contents
A program activity Excel report contains three types of sheets:
Export Details
Information about when the export was run and by whom, how many survey instruments are attached, and when the program activity was last updated. One sheet per file.
Overview & Demographics
All details from the General Information section of the program activity, plus custom section data and demographic information. One sheet per export.
Data Tabs
Raw survey response data as entered in PEARS. One sheet per attached survey instrument. Individual responses generate separate rows; aggregate data produces a single row.
TIP: Use the data tabs for further statistical analysis in external applications such as Excel or Google Sheets.
