> _^ g2ɀ\pPatti's Ba==<<$'8X@"1Geneva1Geneva1Geneva1Geneva1Geneva1Geneva1Geneva1QTahoma1QTahoma1Geneva1$Geneva1QTahoma1QTahoma1Geneva1Arial1Arial1Arial1Arial1Arial1Arial1 Arial1Arial14Arial1 Arial1Arial1Arial1,>Arial1>Arial1>Arial1>Arial14Arial1<Arial1?Arial1h>Cambria1Arial1
Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* ""_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* ""_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* ""??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* ""??_);_(@_)"$"#,##0.00
"$"#,##0
00000 ff + ) , * P P
` ! " # a $ L) ! L ! ! ! H+ H) H+ H YABc}<}
00\);_(*ef_)?_);_(}<}
00\);_(*ef_)?_);_(}<}
00\);_(*ef_)?_);_(}<}
00\);_(*ef_)?_);_(}<}
00\);_(*ef_)?_);_(}<}
00\);_(*ef _)?_);_(}<}
00\);_(*L_)?_);_(}<}
00\);_(*L_)?_);_(}<}
00\);_(*L_)?_);_(}<}
00\);_(*L_)?_);_(}<}
00\);_(*L_)?_);_(}<}
00\);_(*L _)?_);_(}<}
00\);_(*23_)?_);_(}<}
00\);_(*23_)?_);_(}<}
00\);_(*23_)?_);_(}<}
00\);_(*23_)?_);_(}<}
00\);_(*23_)?_);_(}<}!
00\);_(*23 _)?_);_(}<}"
00\);_(*_)?_);_(}<}#
00\);_(*_)?_);_(}<}$
00\);_(*_)?_);_(}<}%
00\);_(*_)?_);_(}<}&
00\);_(*_)?_);_(}<}'
00\);_(* _)?_);_(}<}(
00\);_(*_)?_);_(}})
}00\);_(*_)?_);_(
}}*
00\);_(*_)?_);_(??? ??? ???
???}(}/
00\);_(*}<}1
a00\);_(*_)?_);_(}<}2
00\);_(*_)?_);_(}<}3
00\);_(*?_)?_);_(}<}4
00\);_(*23_)?_);_(}(}5
00\);_(*}}7
??v00\);_(*̙_)?_);_(
}<}8
}00\);_(*_)?_);_(}<}9
e00\);_(*_)?_);_(}x};00\);_(*_)?_);_(
}}<
???00\);_(*_)?_);_(??? ??? ???
???}}>
00\);_(*}P}?
00\);_(*_)?_);_( }(}@
00\);_(*
20%  Accent1H
20%  Accent1ef
20%  Accent2H"
20%  Accent2ef
20%  Accent3H&
20%  Accent3ef
20%  Accent4H*
20%  Accent4ef
20%  Accent5H.
20%  Accent5ef
20%  Accent6H2
20%  Accent6 ef
40%  Accent1H
40%  Accent1L
40%  Accent2H#
40%  Accent2L渷
40%  Accent3H'
40%  Accent3L
40%  Accent4H+
40%  Accent4L
40%  Accent5H/
40%  Accent5L
40%  Accent6H3
40%  Accent6 Lմ
60%  Accent1H
60%  Accent123
60%  Accent2H$
60%  Accent223ږ
60%  Accent3H(
60%  Accent323כ
60%  Accent4H,
60%  Accent423
60%  Accent5H0
60%  Accent523!
60%  Accent6H4
60%  Accent6 23"Accent1<Accent1O#Accent2<!Accent2PM$Accent3<%Accent3Y%Accent4<)Accent4d&Accent5<Accent5K'Accent6<1Accent6 F(Bad4Bad)CalculationCalculation} *
Check Cellz
Check Cell????????? ???+ Comma,( Comma [0]&Currency..Currency [0]/Explanatory TextB5Explanatory Text0 : Followed Hyperlink 1Good6Gooda2 Heading 1B Heading 1I}O3 Heading 2B Heading 2I}?4 Heading 3B Heading 3I}235 Heading 44 Heading 4I}6( Hyperlink
7InputpInput̙??v 8Linked CellFLinked Cell}9Neutral<Neutrale"Normal!:Normal_Chemistry Spreadsheet ;Noteb
Note <OutputrOutput???????????? ???=$Percent
>Title1TitleI}%
?TotalHTotalOO@Warning Text:Warning TextXTableStyleMedium2PivotStyleLight168dq:F3ffff̙3f3fff3f3f33333f33333\`%2Page 1 Instruc Costs per Hour%QePage 2 Annual Cost Comparison8rj0*)*3A@@
e'Instructional Costs per Hour % devoted to instructionContact hours for courseTotal hours
Cost per hourTAs/GAsGRAND TOTALTotal # of studentsCost per student'% devoted to one section of this courseAdjunct/PartTime FacultySalary and benefits!Total cost of course coordinationTotal cost of other personnelProfessional/Support StaffOutofclass hours%ANNUAL COST OF THE TRADITIONAL COURSE Total cost of direct instructionFaculty (TenureTrack)Faculty (NonTenure Track)TenureTrackUndergraduate AssistantsInstitution:Course:"Cost of one section of this course
$ per hour!Inclass contact hours for course$ANNUAL COST OF THE REDESIGNED COURSESectionsNonTenure
Track Faculty FacultyAdjunct/
PT Faculty'# of sections taught in fall and springCost of one sectionYNOTE If you insert or delete columns, you must adjust the formulas that calculate totals.Cost of instruction by type*.)/00P1ccB
g2ɀ&8BlD
dMbP?_*+%&?'?(?)?MBrother MFC6490CWC
odLetterDINU"A7ISMTJxBrother MFC6490CWInputBinLOWERRESDLLUniresDLLMediaTypePlainOrientationPORTRAITSlowDryingPaperNormalInkjetQualityNormalResolutionOption3PaperSizeLETTERThicknessAUTOHalftonePatternERRDIFFBiDirAUTOMirrorPrintNormalShortGrainNormalColorModeColorENGINEA3_ENGINEMODELTYPEBHM"dXX??&U}`"A}
A}`A}`"A}
A} A}A}@
A&\\
XDDDD
XDDDDDDDDD
NDDDDDDDDD
EF
F
EFEFFEF
F
FF
FF
F
GF
FG
F
GF
F
G
F~
H
F
F'
HDDD FFFFF
F
IF
FI
F
I
F
F
I
F#I
%
/
F
F#I
%
/
J"FD
D
F
J"FD
DFFFFF
E
FF
EFEFFEF
F
FF
FH
F
GFOG
F
GF
FI
F'HADDDF
FIFFF
F#I
%/
FI
F
J"FF
DD
FI
F
FD
F#I
%/
F
FD
J"L
DD
F
FDDDDDDDFDDD
E
MO
E
M
E
M
OD
M
D l >444_4>xv>>,>[EZ4QP X !"#$% OFOOD
!B!
"B"
#B
#
$B
$
%C
%
%C
%Xd (& (
B(
XPP? ]4@
IVLO*u+D
<The average annual salary in the department of a tenuretrack faculty member plus the average value of his/her annual benefits.<
BP
XPP?w
]4@
baM3vɶ
<The average annual salary in the department of a nontenuretrack faculty member plus the average value of his/her annual benefits.
<
l
4R
B
XPP?wI]4@
$MȘFow/
<The average salary of an adjunct (parttime) faculty member to teach one section of the course. (If adjuncts are paid benefits, calculate the value of his/her annual benefits for teaching one section.)
<
cg
B
XPP?t]4@
QlnB椖g
z<{The percentage of the average faculty member's professional obligation that is devoted to instruction on an annual basis.
<yz
B
XPP?]4 @
mp7W u@CJ
<The percentage of an average faculty member's instructional time that is devoted to one section of this particular course on an annual basis
<
t0$
B
XPP?F]4
@
hCcOoQl
i<jThe average annual salary in the department of a TA/GA plus the average value of his/her annual benefits.<
[i
B(
XPP?t]4@
5טH;
q<rThe percentage of the average TA/GA's professional obligation that is devoted to instruction on an annual basis.
<p
q
BP
XPP?]4@
5uDLT3
<The percentage of an average TA/GA's instructional time that is devoted to one section of this particular course on an annual basis
<
t0$
B
XPP?]4
@
[t3Bh/
z<{The percentage of the average faculty member's professional obligation that is devoted to instruction on an annual basis.
<yz
B(w[
XPP?w]4@
&h@oljl@
7ggD
g2ɀEjs
dMbP?_*+%&?'?(?)?MHP LaserJet IIPC
od,,LetterDINU"dSMTJHP LaserJet IIPInputBinFORMSOURCERESDLLUniresDLLOrientationPORTRAITResolutionOption1PaperSizeLETTERHalftoneHT_PATSIZE_AUTO"U,,??&U},}}}
\\
X
N%KKKKK
XKKKKKKKKKKKKKK
P
QK
N!
KKK
R
S
N
N"
KKN
N
N
N
N
KK
NNNNNNNNDDDDFF
D#
T
T
T
T
KK
D$ UUUUKK
D&"
DU
DD "
DU DD "
DU
DD "
DU
DD #
EU
%
@
DDDFFFV
K
N#FF
%
@DKDV
K
N
TDKDDD
N "DD
DD
DKDDDKKKKKKKKKKKKKK
NDDDDFFNDDDDFF
D#
T
T
T
T
KK
D$UUUUKK
D&"DUDD"DU
DD"DUDD"DUDD#EU
% @
DDDDDDV
K
N#FD
%ȾDKDV
K
NTDKD
WK
N "DDDDDKDDD
DKKKKKKKKKKKKKKKKKKKK> 00$LPP$T$$U$H$T$$U8H$
K8 (
By[
XPP?t]4@
45E,
<Enter the total number of traditional sections taught in fall and spring by each type of instructor in Column B, C, D and E in the yellow highlighted cells. Do not include sections taught in summer.
<
0
By[
XPP?
+]4@
Ԗ\Msbm
<The CPT will sum the total cost of all instruction by multiplying the cost of each type of section by the number of each type of section offered in fall and spring.
<
x
Bz[
XPP?
#]4@
ue*CCV
<Enter the total cost of course coordination during the fall and spring.
If one person functions as a course coordinator, enter the percentage of salary and benefits of that person devoted to this course(s) during fall and spring.
For some, that percentage may be 100%.
For others, that may be a percentage of total salary and benefits since coordination may be only part of his/her responsibilities.
If more than one person functions as a course coordinator, enter the combined salaries and benefits.<4b o
B(z[
XPP?
U]4@
lI9yJvzO
<Enter the total amount of salaries and benefits paid to other course personnel (e.g., undergraduate assistants, professional staff, tutors, etc. ) during fall and spring.
< nge
BPz[
XPP?%]4@
,jy6uIoWhB
7<8Enter the total course enrollment for fall and spring.
<
$67
Bz[
XPP?# !]4@
@X#Ki
<Enter the total cost of course coordination during the fall and spring.
If one person functions as a course coordinator, enter the percentage of salary and benefits of that person devoted to this course(s) during fall and spring.
For some, that percentage may be 100%.
For others, that may be a percentage of total salary and benefits since coordination may be only part of his/her responsibilities.
If more than one person functions as a course coordinator, enter the combined salaries and benefits.<4b o
Bz[
XPP?E#5]4@
ZC@+
<Enter the total cost of one section of the course taught by a tenuretrack faculty member. This total should be the same as the cost of one section shown on page 1 and page 2 in the blue cell for a tenuretrack faculty member.<
Bz[
XPP?#]4@
TGD 4T
<Enter the total cost of one section of the course taught by a nontenuretrack faculty member. This total should be the same as the cost of one section shown on page 1 and page 2 in the blue cell for a nontenuretrack faculty member.<
+
B{[
XPP?#]4
@
mY[yDm ؖ
<Enter the total cost of one section of the course taught by a TA or GA. This total should be the same as the cost of one section shown on page 1 and page 2 in the blue cell for a TA or GA.
<

B({[
XPP?v#T]4@
x?gAM3i
<Enter the total cost of one section of the course taught by an adjunct faculty member. This total should be the same as the cost of one section shown on page 1 and page 2 in the blue cell for an adjunct faculty member.
<
)
BP{[
XPP?/z]4@
@GE>Q
<Enter the total cost of one section of the course taught by a tenuretrack faculty member. This total should be the same as the cost of one section shown on page 1 and page 2 in the blue cell for a tenuretrack faculty member.<
B{[
XPP?/z]4@
a}rM?i
<Enter the total cost of one section of the course taught by a nontenuretrack faculty member. This total should be the same as the cost of one section shown on page 1 and page 2 in the blue cell for a nontenuretrack faculty member.<
+
B{[
XPP?/]4@
aW5#FV
<Enter the total cost of one section of the course taught by a TA or GA. This total should be the same as the cost of one section shown on page 1 and page 2 in the blue cell for a TA or GA.
<

B{[
XPP?/g]4@
bZ8IhL:
<Enter the total cost of one section of the course taught by an adjunct faculty member. This total should be the same as the cost of one section shown on page 1 and page 2 in the blue cell for an adjunct faculty member.
<
)
B[
XPP?#56]4@
pO߾Nm21
7<8Enter the total course enrollment for fall and spring.
<
$67
B([
XPP?/6]4@
h@%ѭ
<Enter the total amount of salaries and benefits paid to other course personnel (e.g., undergraduate assistants, professional staff, tutors, etc. ) during fall and spring.
< nge
BP[
XPP? #v
]4@
,O
k@T+'
<The CPT will sum the cost of instruction for each instructional type by multiplying the cost of each type of section by the number of each type of sections
offered in fall and spring.
<
B[
XPP?#v]4@
N_CH"FQ
<The CPT will sum the cost of instruction for each instructional type by multiplying the cost of each type of section by the number of each type of sections
offered in fall and spring.
<
B[
XPP?#]4@
lΝvD)%Rz
<Enter the total number of redesigned sections taught in fall and spring by each type of instructor in Column B, C, D and E in the yellow highlighted cells. Do not include sections taught in summer.
<
;0
B[
XPP?#
#]4@
}X7LHǥ
<The CPT will sum the total cost of all instruction by multiplying the cost of each type of section by the number of each type of section offered in fall and spring.
<
xCarol A. Twigga Carol A. Twigga Carol A. Twigga
Carol A. Twigga Carol A. Twigga
Carol A. Twigga
Carol A. TwiggaCarol A. TwiggaCarol A. Twigga
Carol A. TwiggaCarol A. TwiggaCarol A. TwiggaCarol A. TwiggaCarol A. TwiggaCarol A. TwiggaCarol A. TwiggaCarol A. TwiggaCarol A. TwiggaCarol A. TwiggaCarol A. Twigga>@oljl7ggD
Oh+'0HPhx
Carol A. TwiggPatti'sMicrosoft Excel@[@ibƆ@hƃ՜.+,0 PXdlt
NAPage 1 Instruc Costs per HourPage 2 Annual Cost ComparisonWorksheets
!"#$%&'()*+,./0123456789:;<=>?@ABCDEFGHIJKLMOPQRSTUWXYZ[\]Root Entry FWorkbookSummaryInformation(NDocumentSummaryInformation8V