Analyze a Program Activity Excel Report
Understand the contents and structure of a program activity Excel report in PEARS.
Last updated
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.
A program activity Excel report contains three types of sheets:
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.
All details from the General Information section of the program activity, plus custom section data and demographic information. One sheet per export.
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.
Last updated