PAEA (Physician Assistant Education Association) Monitoring Suite Data Files

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: 

  • Generate the HTML files directly from the PAEA portal. We are unable to process files originally saved as PDF and converted to HTML.
  • You should be sending all designated types of files for each year and/or test area.

 


PANCE

PACKRAT

EoC - End of Curriculum

EoR - End of Rotation


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

Back to top of page


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:

  1. Summary with comparison to National Scores
  2. Content Area Feedback
    1. Task Areas
    2. 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

Back to top of page


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:

  1. Summary with comparison to National Scores
  2. Class of Performance Levels
  3. Class of Summaries for
    1. Content Categories
    2. Tasks
    3. Entrustable Professional Activity
    4. Key Dimension: Setting
    5. Key Dimension: Life Course
    6. 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

Back to top of page


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:

  1. Class Scores post
  2. 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:

  1. Summary of scores
  2. Class of scores for:
    1. Content Categories
    2. 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