Exporting Evaluation Results
Overview
APTA Clinical Performance Instruments allows you to export your raw evaluation data into a CSV or Excel file. To export data:
- Navigate to the Evaluations tab and click Export Evaluation Results.
- Select the checkboxes for the evaluation(s) you'd like to export, then click Create Export.
- Enter a name for your export in the Export Name field.
- Choose your file type. You can export the data in a .csv (Comma Separated Values) file, or .xls (Excel spreadsheet). We recommend selecting Comma Separated Values, as exporting to Excel can cause numbers to be treated as text.
- Select either APTA Formatted or CPI 2.0 Formatted from the Instrument Scale drop-down. The keys for these scales are listed below.
- Note: the APTA Clinical Performance Instruments Scale is used when the students/CIs enter the ratings using APTA Clinical Performance Instruments.
- Select the evaluation type (Student or CI), evaluation status (In Progress or Completed), and the evaluation part (Midterm or Final) to export.
- Select either the rating checkbox, comment checkbox, or both for all of the criteria that you want to export.
- Click the Run Export link.
- The export takes a few minutes to run. If desired, you may continue working in other tabs, then return to the Downloads tab to download the file.
The downloaded file contains information about the CIs/SCCEs, along with the performance data for the students.
Note: to count the number of credentialed CIs in Excel, you can use a formula like this one: =countifs(N2:N245, "Yes")
- The "N" information relates to the column you are trying to count.
- “2-245” represents the range of cells you are counting in the column.
- "Yes" represents the non-numerical value that you are counting. For example, to find the number of CIs that weren't credentialed, replace "Yes" with "No" in the above formula. If there are two CIs evaluating one student, you can substitute “No, No”; “No, Yes”; “Yes, No”; and “Yes, Yes” as both CIs credentials will appear on the same row.