St. Olaf College Faculty FTE Spreadsheet Definitions: 2003-04 - current

Note: while this version of the spreadsheet represents a new layout of columns and rows, there have been no definition changes of categories since the 2001-02 revision.

Page 1 of the spreadsheet details the teaching FTE, both according to where facutly teach and according to faculty members' home departments. The first column on page 1 Teaching FTE shows how teaching faculty are distributed by academic programs, while the final column Total Teaching shows how teaching FTE is distributed to home departments. Each column produces the same total after appropriate adjustments have been made. The bottom rows 59-68 on page 1 summarize the non-teaching FTE of the faculty, which is detailed on page 2.

Page 2 begins by repeating the Total Teaching by Home Department column from page 1. The following columns detail non-teaching responsbilities and leave FTE, including the appropriate adjustments to home departments in the "import/export" columns. The sum of these non-instructional FTEs is in the column entitled Total Support & Scholarship (AQ). Total StO Paid (AR) shows the total FTE funded through St. Olaf; Total Ext/Unpaid (AV) shows the total FTE release for externally funded grants/leaves as well as unpaid leaves. The column AW entitled Department Totals, displays the total of all faculty assigned to each department and Faculty, combining both instructional and non-instructional assignments.

The final section of the spreadsheet indicates the type of appointments held by the faculty in each home department: tenured, tenure-track, or short-term.

Definitions of each column and the subtotals follow:

Page 1 - Teaching FTE

AD Total Teaching: The sum of columns D, Y, and AC, representing the total FTE assigned to teaching by members of each department. The column total matches the teaching subtotal in column D (where it is distributed to departments and programs).
D
 Teaching FTE: Total teaching within a department or program, including courses taught by members of other departments. First subtotal gives total teaching for the whole faculty (further elaborated on page 1). Second subtotal summarizes faculty time assigned to other service and scholarship (elaborated on page 2). Totals show both St. Olaf paid FTE and total FTE.
Y
 ID Prg Total: Teaching FTE assigned to non-departmental programs. (sum of E-W - Teaching FTE assigned in column C to non-departmental programs is redistributed to departments that provide that teaching. Negative and positive entries total to 0.)
AC
 Total Transfer: FTE assigned to faculty who teach in departments outside their home department (sum of Y-AB - Balancing entries: negative for imports, positive for exports)

Page 2 - Support & Scholarship

AW Department Totals: (Total FTE of all faculty by home departments)
  AR Total StO Paid (Total FTE paid from the Faculty budget line, incl. endowed chairs)
    AE Total Teaching (column repeated from AD on page 1)
    AQ Total Support & Scholarship
      AH Total Ensembles & Athletics
      AF Ensembles & Athletics: FTE assigned to extra-curricular student-oriented programs such as musical or dance organizations, athletics, or theatrical productions.
      AG Import/Export E&A: Balancing entries for faculty who supervise ensembles or athletics outside their own department.
      AL Total Administration
      AI Department/Program Administration: Faculty FTE assigned to administration of the department or program.
      AJ Import/Export Admin: Balancing entries for faculty who are administrators of departments or programs outside their home department.
      AK Other Administration: Faculty FTE assigned to administration in a department or program not specifically listed on the spreadsheet.
      AP Total Internal Leaves
      AM Semester I Sabbaticals: College-paid first-term sabbaticals (.50 for academic year sabbaticals, .25 for calendar sabbaticals).
      AN Paid Sem. II Sabbaticals: College-paid sabbatical supplements for those taking a full year sabbatical (.20 for academic year sabbaticals, .10 for calendar sabbaticals).
      AO StO-Paid Leaves: Other leaves paid from college funds (operating or endowment). Primarily for professional purposes, but may also include other special paid leaves.
  AV Total External/Unpaid (Faculty FTE not compensated from the Faculty budget line.)
      AS Externally Funded: Faculty time paid for by external research or curriculum development grants (e.g. Lilly, NSF) or by external teaching assignments (e.g., at Gustavus or in ACM programs).
      AT Unpaid Sabbatical Leaves: Faculty time on the second term of a full-year leave that is not paid for by the college. Typically .30 for academic year sabbaticals or .15 for calendar sabbaticals.
      AU Unpaid Leaves: Various unpaid leaves including reduced loads, special leaves for teaching or research at another institution, extended parental leaves. (If salary for external assignments flows through St. Olaf, the FTE is in column AO; if not, then in column AU.)

Page 2 - Faculty Appointment Type

BA Long Term
AY
 Tenured Faculty: FTE of tenured faculty, excluding those who have resigned tenure as part of a pre-retirement agreement. 1.0 for tenured full-time, .50 for tenured part-time (i.e., contracted FTE, not paid FTE).
AZ Tenure-Track: FTE of faculty on tenure-track appointments. 1.0 for tenure-track full-time, .50 for tenure-track part-time (i.e., contracted FTE, not paid FTE).
BB Short Term: Difference between total faculty (col. AW) and long term faculty (col. BA).