Data and Tools for ABB Tuition Revenue and Distribution Calculations

FY18 ABB Tuition Files

Detailed ABB files for FY18, including tuition revenue by tuition group, student credit hour distribution, and degree major and major enrollment distribution, are available here:  ABB Tuition Files
 
This FY18 file and files for prior years are available on OPB's Annual Budgets webpage.  
 

ABB Tuition Data Model and Resources

In December 2016, a number of tables were made available that enable campus users to do and see all calculations relevant to the distribution of net operating fee revenue under ABB. Links to a variety of information that will enable users to understand and use the data are provided below.
 
Please note that a number of improvements, including (but not limited to) the ability to include students with exemptions as well as data quality checks, have been made as the data have been moved to AIDB. The budget allocations made through FY16 under ABB represent final allocation decisions; no changes to budgets for prior years will be made on the basis of the data now made available through AIDB. Historical data are included here only to facilitate trend analysis.
 

Data Model Details:

Documentation and code for ABB tuition calculations:
  • Documentation of how to connect to data and perform all necessary calculations.
  • Access database that performs the same calculations (not updated since February)
  • SQL code that performs ABB tuition calculations through FY17, using the old distribution parameters (revised 8/24/2017)
  • SQL code that performs ABB tuition calculations using the new distribution parameters
  • SQL code that provides the basis for projecting tuition revenue pools by campus, tuition category, and residency. This code is used in the Excel-based “ABB Tuition Files” to provide projections. The general approach to projections is outlined in the Introductory PowerPoint available on this page.

Excel Tools

Excel files are available that perform the ABB tuition calculations. These files each are based on SQL queries that use the code made available above. If you wish to see more details about underlying queries, please click on “Data” on the menu bar. Then click on “Show Queries” to see the queries used.
 

In each file, explanatory information is available on the “Reference” tab. The files currently available are:

  • The FY18 ABB Tuition Table, which includes calculation of the distribution of FY17 actual and FY18 projected tuition revenue using the new distribution parameters
  • The Excel file that provides calculations of years through FY17, using the old distribution parameters. 

Office Hours

Weekly hour-long ABB tuition revenue and distribution office hours were held through August 24, 2017. We will resume office hours, perhaps with a slightly different focus, when Autumn quarter begins.

 
 

OPB