CPI Web 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 will 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 CPI Scale is used when the students/CIs enter the ratings using CPI Web.
- 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/CCCEs, along with the performance data for the students.
Note: To count the number credentialed CIs in Excel, you may 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. To find the number of CIs that weren't credentialed, for example, replace "Yes" with "No" in the above formula. If there were 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.
Instrument Scale Key
|3||Advanced Beginner Interval|
|7||Advanced Intermediate Interval|
|9||Entry Level Interval|
|10||Beyond Entry Level|
|CPI 2.0 (21 pt Scale)||Description|
|6-8||Advanced Beginner Interval|
|14-16||Advanced Intermediate Interval|
|18-20||Entry Level Interval|
|21||Beyond Entry Level|