Spreadsheet: 32340d1228444355-workbook-stripped-of-format-after-its-saved-mastertemplate_standard-calc-november-2008v4_corrupt-corrected
Sheet: CAF WorkSheet

CAF Worksheet for Shared or Mutliple Course Teaching/MHEC Hour Calculations (Attached to Operations Copy of the CAF)
Course Number: |  |  |  |  |  | CRN: |  |  |  | Term:
Credit Course Number: |  |  |  |  | Credit CRN: |  |  |  | Credit Term:
Gradable Course?
 | Day 1: |  |  |  | Start/End Date: |  |  |  |  |  | Start/End Time:
 | Day 2: |  |  |  | Start/End Date: |  |  |  |  |  | Start/End Time:
 | Day 3: |  |  |  | Start/End Date: |  |  |  |  |  | Start/End Time:
 | Day 4: |  |  |  | Start/End Date: |  |  |  |  |  | Start/End Time:
 | Arranged/Online: |  |  |  | Start/End Date: |  |  |  |  |  | Total Teaching Hrs:
Teaching Time per Session
 | Determine the exact number of minutes for each day the course will run.  At least a 15 minute break must be built in when the Teaching time is more than three hours.
 | 0 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  | 0
 | Day |  |  | Minutes/Session |  | Minus | Breaks |  | = | Teaching Minutes/Session |  |  |  |  | Teaching Hrs/Session
 | 0 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  | 0
 | Day |  |  | Minutes/Session |  | Minus | Breaks |  | = | Teaching Minutes/Session |  |  |  |  | Teaching Hrs/Session
 | 0 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  | 0
 | Day |  |  | Minutes/Session |  | Minus | Breaks |  | = | Teaching Minutes/Session |  |  |  |  | Teaching Hrs/Session
 | 0 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  | 0
 | Day |  |  | Minutes/Session |  | Minus | Breaks |  | = | Teaching Minutes/Session |  |  |  |  | Teaching Hrs/Session
Total Teaching Minutes for Each Class Day
 | Multiply the number of sessions for each day
 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | Number of Class Days |  |  | X | Teaching Minutes/Session |  |  |  | = | Total  Teaching Minutes |  |  |  |  | Total Teaching Hrs
 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | Number of Class Days |  |  | X | Teaching Minutes/Session |  |  |  | = | Total  Teaching Minutes |  |  |  |  | Total Teaching Hrs
 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | Number of Class Days |  |  | X | Teaching Minutes/Session |  |  |  | = | Total  Teaching Minutes |  |  |  |  | Total Teaching Hrs
 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 | Number of Class Days |  |  | X | Teaching Minutes/Session |  |  |  | = | Total  Teaching Minutes |  |  |  |  | Total Teaching Hrs
Online Class Information |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | = | Total  Teaching Minutes |  |  |  |  | Total Teaching Hrs
Calculating Total Teaching Hours & 20% Minutes/Hours
 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Teaching Min/Sess |  | + | Teaching Min/Sess |  | + | Teaching Min/Sess |  |  | + | Teaching Min/Sess |  |  | + | Online Minutes
 | 0 |  |  |  |  |  | 0 |  |  |  | 20% Date  Calculations: |  |  | 0 |  | 0
 | Total Teaching Minutes |  |  | Divided by 60 |  | = | Total Teaching Hours |  |  |  |  |  |  | 20% Hours |  | 20% Minutes
 |  |  |  |  |  | (Include up to 3 decimal places)
MHEC Hour Calculation
 | 0 |  |  | X | 1.2 | = | 0
 | Total Teaching Hours |  |  |  |  |  | MHEC Hours
 |  |  |  |  |  |  | (Include up to 3 decimal places - never round up to a whole number)
CEU Calculation
 | 0 |  |  | X | 0.1 | = | No CEUs Given
 | MHEC Hours |  |  |  |  |  | CEUs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Updated July 2008