Map A to Z Index Search CU Home University of Colorado
 
  Strategic Planning Institutional Research and Analysis Campus Budget and Finances About PBA

PBA Home > Institutional Research & Analysis > Faculty and Staff > Research expenditures and awards by departments

University of Colorado Boulder

Sponsored research expenditures and awards by department, 1968 to present

Click here for the large Excel file that shows awards and expenditures 1968 through fiscal year 2013-2014. It will be updated annually in the fall after release of the Office of Contracts and Grants (OCG) annual report. This report is updated in late August/early September with figures for the previous fiscal year (i.e. report released in 2012 contains data from fiscal year 2011-2012).

Highlights with notes on query methods

  • In fiscal year 2014, 11 PBA units had $10 million or more in sponsored research expenditures, accounting together for $242 million of the total $358 million in expenditures (67%). Four of the 11 units are institutes (CIRES, INSTAAR, JILA, and LASP), plus chemistry, chemical engineering, CVEN, A&S Natural Sciences programs and centers, psychology and VC Student Affairs.
    • See these results using the "top 10" data filter in the "PBA Depts summary" tab with the measure "Exp. in unit, last FY"
  • In the same year, 12 instructional PBA units had $3 million or more in sponsored research expenditures allocated from non-instructional PBA units (i.e. institutes or administrative units) based on the tenure department of the principal investigator (PI) on an individual project. These 11 units accounted for $118 million of the total $130 million in allocated expenditures (91%). These 11 units are APS, atmospheric & oceanic sciences, chemistry, EBIO, english, Engineering Administration, geography, geology, Law, MCDB, physics, and psychology. Click here for more information on allocation methods.
    • See these results using the "top 10" data filter in the "PBA Depts summary" tab with the measure "Exp. allocated from institutes, last FY"
  • 24 OCG units have had sponsored research activity in all 47 fiscal years since 1968
    • "Top 10" data filter, "OCGunits summary", "Yrs w activity FY68+"
  • Sponsored research expenditures over the last five fiscal years (2010-2014) have totaled $1.83 billion. 92% of these have been in A&S natural science units (23%), engineering units (16%), and the research institutes (53%).
    • See tab "Pivot summary"

Format of the Excel file

Data are shown:

  • By "OCG unit," to match listings in OCG reports.
    • With both awards (number and amount, from FY 1968 and on) and expenditures in the unit (from FY 1997 and on). OCG cautions that "the most accurate way to make year-to-year comparisons of data on research and other sponsored program activity is to look at actual expenditures." This is primarily because awards can be multiyear.
  • By PBA Department.
    • Awards are not shown in this, ONLY research expenditures
    • PBA Dept is assigned from the sponsoring department ID of the research project
    • Research expenditures in the unit since FY 2000 from the CIW dataset GL_BUDG_ACT_ENCUMB_LINES_BASE.
    • And with expenditures allocated one department to another, for FY 2000 and later only, based on the tenure department of the PI of a project. Previous versions of this file were done with a gross approximation. Click here for more information on allocation methods and a comparison between the two calculations.
      • See the tab 'Alloc_detail' for a summary of the most recent FY showing how expenditures are being allocated from one PBA Dept to another
      • We are not able to match EXACTLY to the totals in the OCG unit (but within $500k for a given FY)
      • With VC division, college, and A&S cluster shown for each unit in all listings
    • By individual fiscal year
      • And summarized over all fiscal years since 1968, the most recent five fiscal years, and most recent fiscal year
    • In listings which can be further summarized or filtered
      • And in pivot tables of two types: with school, college, cluster, and division results and for reconciling to OCG totals

    The file also includes definitions, and correspondence between OCG and PBA units.

CAUTION: The Excel file is quite large (405 kb). We recommend downloading to your own machine if you intend to do additional queries or manipulations.

Also see sponsored research expenditures by the principal investigator's (PI) job category, code and title.   FY 2006-07 |  FY 2007-08 |  FY 2008-09 |  FY 2009-10 |  FY 2010-11

PBA: L:\datalib\Depts\Rsrch\

Last revision 09/10/14


PBA Home  |   Strategic Planning  |   Institutional Research & Analysis |  Budget & Finances  | 
Questions? Comments? |  Legal & Trademarks |  Privacy
15 UCB, University of Colorado Boulder, Boulder, CO 80309-0015, (303)492-8631
  © Regents of the University of Colorado