Here are the steps I took to produce the analysis:

  1. Obtain and Clean the Data: I started with the raw data from the “Raj Data Sheet” and then cleaned it for analysis.
  2. Count CPC Topics: For each course, I counted the number of CPC (Common Professional Component) topics covered. For example, BUS 1300 covers four ACC CPC topics.
  3. Calculate Total Topics: I created a new column to show the total number of CPC topics covered by each course by summing the values in each row.
  4. Estimate Instructional Hours: I converted the number of CPC topics into estimated instructional hours. I assumed an equal amount of time is spent on each topic within a given course.

Calculation Example

The calculation for BUS 1300 for ACC is as follows: (4 / 46) × 4 × 15 × 1.5 = 8 instructional hours

The calculation follows Table 6.4.c. Example.

Important Note

The Template for CPC Compliance lists 12 categories of CPCs, but the Raj Data Sheet only includes 11. The missing category appears to be Information Systems (IS). Therefore, my analysis does not include the IS topic.

Number of CPC Topics per Course

course acc com eth fin pol_comp econ glo law mgt mkt qt_stat total
BUS 1300_Digital Information Technologies 4 4 4 2 7 0 2 3 10 4 6 46
BUS 2000_Financial & Managerial Accounting 12 0 0 4 0 0 0 0 1 0 0 17
BUS 2200_Management and Decision Making 0 2 7 0 0 0 1 0 11 0 0 21
BUS 2300_Business Writing and Presenting 0 9 0 0 0 0 0 0 0 0 0 9
BUS 1100_Introduction to Marketing and Sales 0 0 1 0 0 0 1 0 0 9 0 11
BUS2100_Introduction to Finance 0 0 0 3 0 0 0 0 0 0 0 3
BU 1400_Principles of Economics 0 0 0 0 2 11 3 0 0 2 3 21
MGM 4900_Strategy & Sustainable Competitive Advantage 0 0 0 0 10 0 3 0 0 0 0 13
MKT 4230_Marketing Management 0 0 0 0 9 0 0 0 0 0 0 9
BUS 1200_Business Law 0 0 0 0 0 0 0 6 0 0 0 6
MA 2210_Finite Math with Business Statistics 0 0 0 0 0 0 0 0 0 0 10 10

Number of Sememster Instructional Hours per CPC and per Course

course number course name credit acc com eth fin pol_comp econ glo law mgt mkt qt_stat total
BUS 1300 Digital Information Technologies 4 8 8 8 4 14 0 4 6 20 8 12 90
BUS 2000 Financial & Managerial Accounting 4 64 0 0 21 0 0 0 0 5 0 0 90
BUS 2200 Management and Decision Making 4 0 9 30 0 0 0 4 0 47 0 0 90
BUS 2300 Business Writing and Presenting 4 0 90 0 0 0 0 0 0 0 0 0 90
BUS 1100 Introduction to Marketing and Sales 4 0 0 8 0 0 0 8 0 0 74 0 90
BUS2100 Introduction to Finance 4 0 0 0 90 0 0 0 0 0 0 0 90
BU 1400 Principles of Economics 4 0 0 0 0 9 47 13 0 0 9 13 90
MGM 4900 Strategy & Sustainable Competitive Advantage 4 0 0 0 0 69 0 21 0 0 0 0 90
MKT 4230 Marketing Management 4 0 0 0 0 90 0 0 0 0 0 0 90
BUS 1200 Business Law 4 0 0 0 0 0 0 0 90 0 0 0 90
MA 2210 Finite Math with Business Statistics 4 0 0 0 0 0 0 0 0 0 0 90 90
Total NA NA 72 107 46 115 182 47 50 96 72 91 115 NA