PAEA Suite of Dashboards for Physician Assistant Programs: What files do I need to send?
When to send |
How to send |
As soon as you have new files available. For PACKRAT: If you have a new class where only partial data (first test) is available, go ahead and send us both of the initial files. Then send us subsequent files as they become available. |
You should be submitting your files through your Enflux BOX account. Please remember:
|
PANCE: Physician Assistant National Certifying Examination
For PANCE, You will upload two (2) files per year. "Program Performance Report by Class" and "Score Report." Both of these should be .xls files
- Please use the following matrices to guide the upload of files to the PANCE folder in your Enflux BOX folder.
- Enflux must receive the Roster spreadsheet and the ‘Program Performance Report by Class’ spreadsheet for each class year.
- For these files, each class will have one Score Report, and one Program Performance Report by Class.
Refer to pages 20-23 in this link from the NCCPA for a detailed explanation of how to download these reports. https://www.nccpa.net/wp-content/uploads/2021/06/Program-Portal-User-Manual.pdf
Below is an example of what the file output should look like:
Performance Report 2020.xlsx
This report will have two tabs.
Sheet 1 contains this summary table containing the Class Overview
Sheet 2 contains three parts.
First the program identification information.
The program summary Table
and the PANCE Content Area Feedback
Score Report 2020.xlsx
This report will have 1 tab.
The report header will include:
- Print date
- Page count
- Program Name (your university)
- Program Number (your id number)
- Class Name
- Students (All Students)
Listed fields in the Score Report:
- Class
- Type, which may include First-Time Takers and Repeat Takers
- Name
- Exam Date
- Result
- Score
- Organ System (14 areas)
- Knowledge and Skills (8 areas)
Things we notice about the files
When sending PANCE files, please be sure of the following:
- The Program Performance Report is by class. It will have four rows in the heading, the second of which will clearly state “Program Performance by Class.”
- The Program Performance Report by Class has Sheet1 and Sheet2. Sheet1 contains descriptive text and the Class Overview table. Sheet2 contains the Program Summary Table and PANCE Content Area Feedback.
-
- We have seen a couple of 2022 reports that have changes to this format. We’re not sure if they’re standard reports. Differences we’ve noticed include:
- All three tables showing up on one worksheet
- The label #NOT_SUPPORTED# between the text and the tables
- No labels identifying First Time Exams and All Exams mean and s.d. Columns in the PANCE Content Area Feedback table. The columns exist but are not labeled properly.
-
- Select All Students when sending the score report if you want to see the results for repeat takers as well as first time takers.
- For both the Program Performance Report and the Score Report, you may send us updated files if you have students who need to repeat the exam. Upon receipt of the updates, we will update the dashboards to reflect the additional attempts.
Matrix to help you know that you have submitted all of your files in .xls format. You should be sending both types of files for each year
Year |
Program Performance Report by Class |
Score Report |
2019 |
.xls |
.xls |
2020 |
.xls |
.xls |
2021 |
.xls |
.xls |
2022 |
.xls |
.xls |
(indicate your year) |
.xls |
.xls |
PACKRAT: Physician Assistant Clinical Knowledge Rating and Assessment Tool
For PACKRAT, You will upload two (2) files per year. "Composite Score Report" and "Performance Report by Class"
Enflux must receive the PACKRAT Composite Score Report spreadsheet for each "class of" or "cohort." Additionally, we must receive a Performance Report by Class report in the form of an HTML file. Please generate the HTML files directly from the PAEA portal. We are unable to process files originally saved as PDF and converted to HTML.
If you have a new class where only partial data (first test) is available, go ahead and send us both of the initial files. Then send us subsequent files as they become available.
Below is a list of example files for a single year:
2019 Composite Score Report PACKRAT.xlsx
This file will have two tabs: Class Scores and Keys.
The file header identifies that it is PACKRAT Composite Score Report, Your Institution, and the Class of.
The listing will be by student name and provide:
- Form Name
- Exam Date
- Score Released (True/False)
- Raw Score
- % Correct
- % for each Specialty Area (1- 13; columns G through S)
- % for each Task Area (A-G; columns T through Z)
2019 Performance Report by Class (PACKRAT).html
The .html file will contain two sections:
- Summary with comparison to National Scores
- Content Area Feedback
- Task Areas
- Specialties
Please generate the HTML files directly from the PAEA portal. We are unable to process files originally saved as PDF and converted to HTML.
Matrix to help you know that you have submitted all of your files in .xls and .html format. You should be sending all types of files for each year
Class Year |
Performance Report by Class* |
Composite Score Report |
|
2019 |
.html |
.html |
.xlsx |
2020 |
.html |
.html |
.xlsx |
2021 |
.html |
.html |
.xlsx |
2022 |
.html |
.html |
.xlsx |
(indicate your year) |
.html |
.html |
.xlsx |
*Performance Report by Class: One (1) .html file per class and exam. In most cases you will send more than one file. Example: Class of 2020 - PACKRAT 024; Class of 2022 - PACKRAT 025
PA EoC: End of Course
Enflux must receive the Composite Score Report in a spreadsheet and the Performance Report by Class in HTML format.
Below is a list of example files for a single year:
Composite Score Report EOC2020.xlsx - one row for each student in the cohort/class
This file will have two tabs: Class Scores and Keys.
The file header identifies that it is the End of Curriculum Composite Score Report, Your Institution, and the Class of.
The listing will be by student name and provide:
- Form Name
- Exam Date
- Score Released (True/False)
- Student Score
- Scale Score for each Content Categories (1- 13; columns F through R)
- Scale Score for each Task Area (A-G; columns S through Y)
- Scale Score for EPAs (1-4; columns Z through AC)
- Scale Score for Setting (A-D; columns AD through AG)
- Scale Score for Life Course (1-3; columns AH through AJ)
- Scale Score for Bloom’s Taxonomy (A-C; columns AK through AM)
Performance Report by Class EOC 2020.html - summary data for the "class" and "all programs"
The .html file will contain three sections:
- Summary with comparison to National Scores
- Class of Performance Levels
- Class of Summaries for
- Content Categories
- Tasks
- Entrustable Professional Activity
- Key Dimension: Setting
- Key Dimension: Life Course
- Key Dimension: Bloom’s Taxonomy
Please generate the HTML files directly from the PAEA portal. We are unable to process files originally saved as PDF and converted to HTML.
Matrix to help you know that you have submitted all of your files in .xls and .html format. You should be sending both types of files for each year
Year |
Composite Score Report |
Program Performance Report by Class |
2019 |
.html |
.xlsx |
2020 |
.html |
.xlsx |
2021 |
.html |
.xlsx |
2022 |
.html |
.xlsx |
(indicate your year) |
.html |
.xlsx |
PA EoR: End of Rotation
Enflux must receive one Composite Score Report spreadsheet file per rotation. Additionally, we must receive one Performance Report HTML file per rotation.
Below is a list of example files for a single year:
Excel files have one row for each student in the cohort/class
- 2021 CompositeScoreReport Emergency Medicine EOR.xlsx
- 2021 CompositeScoreReport Family Medicine EOR.xlsx
- 2021 CompositeScoreReport General Surgery EOR.xls
- 2021 CompositeScoreReport Internal Medicine EOR.xlsx
- 2021 CompositeScoreReport Pediatrics EOR.xls
- 2021 CompositeScoreReport Psychiatry EOR.xlsx
- 2021 CompositeScoreReport Women’s Health EOR.xlsx
The files each contain two tabs:
- Class Scores post
- Keys post
HTML:
- 2021 Performance Emergency Medicine EOR.html
- 2021 Performance Family Medicine EOR.html
- 2021 Performance General Surgery EOR.html
- 2021 Performance Internal Medicine EOR.html
- 2021 Performance Pediatrics EOR.html
- 2021 Performance Psychiatry EOR.html
- 2021 Performance Women’s Health.html
These .html files will have two sections:
- Summary of scores
- Class of scores for:
- Content Categories
- Tasks
Please generate the HTML files directly from the PAEA portal. We are unable to process files originally saved as PDF and converted to HTML.
Matrix to help you know that you have submitted all of your files in .xls and .html format. You should be sending both types of files for all areas for each year
Composite Score Report.xls
Class Year |
|||||
2023 |
2022 |
2021 |
2020 |
2019 |
|
Emergency Medicine |
.xlsx |
.xlsx |
.xlsx |
.xlsx |
.xlsx |
Family Medicine |
.xlsx |
.xlsx |
.xlsx |
.xlsx |
.xlsx |
General Surgery |
.xlsx |
.xlsx |
.xlsx |
.xlsx |
.xlsx |
Internal Medicine |
.xlsx |
.xlsx |
.xlsx |
.xlsx |
.xlsx |
Pediatrics |
.xlsx |
.xlsx |
.xlsx |
.xlsx |
.xlsx |
Psychiatry |
.xlsx |
.xlsx |
.xlsx |
.xlsx |
.xlsx |
Women’s Health |
.xlsx |
.xlsx |
.xlsx |
.xlsx |
.xlsx |
Performance Report.html
Class Year |
|||||
2023 |
2022 |
2021 |
2020 |
2019 |
|
Emergency Medicine |
.html |
.html |
.html |
.html |
.html |
Family Medicine |
.html |
.html |
.html |
.html |
.html |
General Surgery |
.html |
.html |
.html |
.html |
.html |
Internal Medicine |
.html |
.html |
.html |
.html |
.html |
Pediatrics |
.html |
.html |
.html |
.html |
.html |
Psychiatry |
.html |
.html |
.html |
.html |
.html |
Women’s Health |
.html |
.html |
.html |
.html |
.html |