{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Main","Instructions","Table 3-1","Setup"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":19,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"SCHOOL NAME:","Sample University"]
[]
[null,"MEASURE USED FOR FACULTY SUFFICIENCY:"]

{"sheet":"Instructions","index":1,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Instructions for Using the AACSB Table 3-1 Macro Enabled Workbook"]
[]
[null,"Generally, Excel automatically disables all macros, so you may need to enable them to use this template. To run macros, you must either \"unblock\" the file, or move it to a \"trusted folder\" (or \"trust\" the folder the file is in). For more info and details on workarounds, see: https://exceloffthegrid.com/unblock-macros-downloaded-from-the-internet/ ",null,null,"Enabling Macros Images"]
[]
[null,"Adding a new Discipline"]
[null,"1. Enter the name of the discipline in the \"Enter Discipline:\" field."]
[null,"2. Indicate if a degree or major is offered in this discipline. Enter \"Yes\" if a degree/major is offered, or \"No\" if not."]
[null,"3. In the \"Faculty:\" field, enter the number of faculty members associated with this discipline."]
[null,"4. After you have entered these details, press the \"Add Discipline\" button. "]
[null,"5. The macro will add a new data-entry block in the Faculty Data sheet with the details you provided. It will prompt you to fill the required information about each faculty member including their names, field of specialty, highest degree earned, year earned, and their responsibilities and qualifications."]
[]
[null,"Understanding the Table 3-1 Sheet:"]
[null,"On the Table 3-1 sheet, you will find various fields such as:"]
[]
[null,"Faculty Member Name: Enter the name of the faculty member."]
[null,"Specialty Field: Enter the specialty field of the faculty member."]
[null,"Specialty Field (Other): If the faculty has a specialty field that isn't listed, please enter it in this field."]
[null,"Highest Degree: Enter the highest degree of the faculty member."]
[null,"Year Earned: Enter the year when the highest degree was earned."]
[null,"Participating Faculty Teaching Productivity (P) and Supporting Faculty Teaching Productivity (S): Fill these according to the school criteria for each category."]
[null,"Year Earned: Enter the year when the highest degree was earned."]
[null,"Normal Professional Responsibilities:  Indicate the normal professional responsibilities of each faculty member using the following guide: UT for undergraduate teaching; MT for master’s-level teaching, DT for doctoral-level teaching/mentoring, ADM for administration, RES for research, ED for non-degree executive education, and SER for other service and outreach responsibilities. A faculty member may have more than one category assigned.  "]
[null,"Classification of faculty (Scholarly Academic (SA), Practice Academic (PA), Scholarly Practitioner (SP), Instructional Practitioner (IP), Additional Faculty (A)): Indicate the classification of each faculty member with respect to their time devotion to the mission."]
[]
[null,"Please note: Always save your workbook after making any changes. The data you enter is not automatically saved."]
[]
[null,"Reviewing the Totals:"]
[null,"At the bottom of the sheet, you will see a \"Grand Total of All Disciplines\" row that summarizes the total faculty members and their classifications. This is updated every time you add a new discipline or clear the data. The \"Ratios of All Disciplines\" rows provide the calculated ratios according to your school's criteria."]
[]
[null,"Last Updated:  December 17, 2024"]

{"sheet":"Table 3-1","index":2,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,9,12,13],[5,2,5,5],[11,6,11,7],[11,9,11,13],[3,1,3,8],[7,14,8,14],[7,1,7,5],[7,6,7,7],[7,9,7,13],[3,18,3,20],[3,15,3,17]]}
[null,"Instructions:  Start by entering your first discipline name, whether degrees or majors are offered in this discipline, and then how many faculty members you have in that discipline."]
[null,"Then click the \"Add Discipline\" button.  The spreadsheet will create that discipline for you.  Enter all the rest of your disciplines the same way.  If necessary, you can use the \"Clear"]
[null,"Last Discipline\" button to completely erase the last discipline you added. This cannot be undone. You may have to zoom out to see the rows that are added."]
[null,{"$f":"Main_SchoolName&\"\"","v":"Sample University"},null,null,null,null,null,null,null,null,"Last Update: ",null,null,null,null,"WARNING: Clicking this button will ERASE the last discipline from the table!"]
[null,"Data Date Range:","Month Day, 202# - Month Day, 202#"]
[null,"Enter Discipline:",null,null,null,null,null,null,null,"Degree or major offered in this discipline?",null,null,"Number of Faculty in this discipline"]
[]
[null,"Faculty Portfolio by Discipline",null,null,null,null,{"$f":"\"Faculty Sufficiency Related to Teaching (\" & Main_MeasureUsed & \")\"","v":"Faculty Sufficiency Related to Teaching ()"},null,null,"Faculty Qualifications With Respect to Percent of Time Devoted to Mission ",null,null,null,null,"Brief Description of Basis for Qualification (Enter brief quantitative and/or qualitative information corresponding to the school criteria for each category.)"]
[null,"Faculty Member Name","Specialty Field","Specialty Field (Other)","Highest Degree","Year Earned","Participating Faculty  Teaching Productivity (P) SCH","Supporting Faculty  Teaching Productivity (S) SCH","Normal Professional Responsibilities ","Scholarly Academic (SA)","Practice Academic (PA)","Scholarly Practitioner (SP)","Instructional Practitioner (IP)","Additional Faculty (A)"]
[]
[null,"Grand Total of All Disciplines",null,null,null,null,{"$f":"SUMIF($F$9:OFFSET($F11,-1,0),\"<>X\",G$9:OFFSET(G11,-1,0))","v":0},{"$f":"SUMIF($F$9:OFFSET($F11,-1,0),\"<>X\",H$9:OFFSET(H11,-1,0))","v":0},null,{"$f":"SUMIF($F$9:OFFSET($F11,-1,0),\"<>X\",J$9:OFFSET(J11,-1,0))","v":0},{"$f":"SUMIF($F$9:OFFSET($F11,-1,0),\"<>X\",K$9:OFFSET(K11,-1,0))","v":0},{"$f":"SUMIF($F$9:OFFSET($F11,-1,0),\"<>X\",L$9:OFFSET(L11,-1,0))","v":0},{"$f":"SUMIF($F$9:OFFSET($F11,-1,0),\"<>X\",M$9:OFFSET(M11,-1,0))","v":0},{"$f":"SUMIF($F$9:OFFSET($F11,-1,0),\"<>X\",N$9:OFFSET(N11,-1,0))","v":0}]
[null,"Ratios of All Disciplines",null,null,null,"P >= 75%:",{"$f":"IFERROR(G11/SUM(G11:H11),\"\")","v":""},null,"SA >= 40%:",{"$f":"IFERROR(J11/SUM(J11:N11),\"\")","v":""}]
[null,"Ratios of All Disciplines",null,null,null,null,null,null,"SA+PA+SP+IP >= 90%:",{"$f":"IFERROR(SUM(J11:M11)/SUM(J11:N11),\"\")","v":""}]

{"sheet":"Setup","index":3,"n_rows":46,"n_cols":16,"rows_kept":46,"cut":false,"hidden":true,"merged":[[6,11,6,15],[7,11,7,15],[6,8,7,9]]}
[]
[null,"SPECIALTIES",null,"TEMPLATES:"]
[null,"Accounting",null,"Discipline #1: [ENTER NAME]",null,null,null,null,null,"Degrees or major are offered in this discipline"]
[null,"Accounting-Assurance services",null,"Enter Faculty Member #1"]
[null,"Accounting-Financial reporting",null,"Totals for [DISCIPLINE NAME]",null,null,null,"X",{"$f":"SUM(I4:I4)","v":0},{"$f":"SUM(J4:J4)","v":0},null,{"$f":"SUM(L4:L4)","v":0},0,0,0,0]
[null,"Accounting-Forensic accounting",null,null,null,null,null,"X",{"$f":"IFERROR(IF(I5=0,\"\",I5/SUM(I5:J5)),\"\")","v":""},{"$f":"IFERROR(IF(J5=0,\"\",J5/SUM(I5:J5)),\"\")","v":""},null,{"$f":"IFERROR(IF(L5=0,\"\",L5/SUM(L5:P5)),\"\")","v":""},{"$f":"IFERROR(IF(M5=0,\"\",M5/SUM(L5:P5)),\"\")","v":""},{"$f":"IFERROR(IF(N5=0,\"\",N5/SUM(L5:P5)),\"\")","v":""},{"$f":"IFERROR(IF(O5=0,\"\",O5/SUM(L5:P5)),\"\")","v":""},{"$f":"IFERROR(IF(P5=0,\"\",P5/SUM(L5:P5)),\"\")","v":""}]
[null,"Accounting-Governmental accounting",null,"[DISCIPLINE NAME] Ratios",null,null,null,"X",{"$f":"IF(SUM(I5:J5)=0,\"\",\">=60% requirement\"&CHAR(10)&\"for P \"&IF(AND(I6<>\"\",I6>=0.6),\"met (\",\"NOT met (\")&TEXT(IF(I6=\"\",0,I6),\"0.00%\")&\")\")","v":""},null,null,{"$f":"IF(SUM(L5:P5)=0,\"\",\"SA >= 40% \"&IF(AND(L6<>\"\",L6>=0.4),\"met (\",\"NOT met (\")&TEXT(IF(L6=\"\",0,L6),\"0.00%\")&\")\")","v":""}]
[null,"Accounting-Accounting Information systems",null,null,null,null,null,"X",null,null,null,{"$f":"IF(SUM(L5:P5)=0,\"\",\"SA+PA+SP+IP >= 90% \"&IF(AND(COUNT(L6:O6)<>0,SUM(L6:O6)>=0.9),\"met (\",\"NOT met (\")&TEXT(IFERROR(SUM(L6:O6),0),\"0.00%\")&\")\")","v":""}]
[null,"Accounting-Internal auditing"]
[null,"Accounting-Managerial accounting"]
[null,"Actuarial Science",null,"Next Discipline Number:",1]
[null,"Arts Administration"]
[null,"Behavioral Science/ Organizational Behavior"]
[null,"Business Communication"]
[null,"Business Education",null,"PROFESSIONAL RESPONSIBILITIES"]
[null,"Business Ethics - incl Corporate Social Responsibility",null,"UT"]
[null,"Business Law/ Legal Environment",null,"MT"]
[null,"CIS/ MIS",null,"DT"]
[null,"Consulting",null,"ADM"]
[null,"Data Analytics",null,"RES"]
[null,"E-Business - incl E-commerce",null,"ED"]
[null,"Economics/ Managerial Economics",null,"SER"]
[null,"Energy Management"]
[null,"Entrepreneurship/ Small Business Admin"]
[null,"Finance - incl Banking"]
[null,"General Business"]
[null,"Health Services/ Hospital Admin"]
[null,"Hotel/ Restaurant/ Tourism"]
[null,"HR Mgt - incl Personnel & Ind/Labor Relations"]
[null,"Insurance"]
[null,"International Business"]
[null,"Leadership"]
[null,"Management"]
[null,"Manufacturing and Technology Management"]
[null,"Marketing"]
[null,"Operations Research"]
[null,"Production/ Operations Mgt"]
[null,"Public Administration"]
[null,"Quantitative Methods"]
[null,"Real Estate"]
[null,"Sports Management"]
[null,"Statistics"]
[null,"Strategic Management"]
[null,"Supply Chain/ Transport/ Logistics"]
[null,"Taxation"]
[null,"Other Specialty Field"]