Implementing Regulation (IR) C-20:
Instructions and Table Templates
This Excel workbook (XLS, 105KB) was developed to serve as a template for providing the data required by Implementing Regulation (IR) C-20 "Student Admissions, Outcomes, and Other Data" in a clear and consistent format. There are five additional worksheets in this file, each composed of tables required for each of the outcomes in the IR. These tables have been copied directly from the most recent version of the IR, approved by the Commission on Accreditation in May 2014.
To complete each table, simply enter the appropriate figures in each of the blank cells. Any table that includes percentages will have these figures automatically calculated based on the raw data that is entered. Once you complete all of your data entry, you can export the tables as a PDF, save each separate table as an image or have your web designers recreate them in the format that they require. It is critical that you keep the row and column labels from these tables. Your program will be considered out of compliance with the IR if they are not consistent with this document.
Please note that some of the worksheets have conditional formatting. If you enter numbers that will cause the percentages in a table to exceed 100 percent, the appropriate cells will turn red. This indicates that the raw data you've entered is incorrect.
More complete information on what to include in the tables is provided in the full text of the IR. Please review the IR and its requirements before utilizing this template.
If you have any questions about the format or content of this IR, please feel free to contact the APA Office of Program Consultation and Accreditation at (202) 336-5979 or by email.