Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tuition Mart provides a series of reports that captures details associated with student tuition at USF. These reports provide the ability to drill down to various campus, college, and department levels for both courses and students. They also provide the ability to do trend analysis over time. The major data points include gross tuition and its components, exemptions and its components, and net tuition, as well as major student and course attributes. Resource Management and Analysis (RMA) is the functional owner of this data mart.

...

Report Elements Glossary Table

...


Report : Net Tuition Comparison-Term Over Term

This report shows the net tuition, exemption, and gross tuition trends over the terms for the all USF campuses, with options to filter for colleges and departments.

...

Enter values for Term Title


Tab 1: Net Tuition Comparison for Terms

 This tab displays the Net Tuition, Net Tuition Variance, and Net Tuition Variance % for the selected terms by campus. The data can be filtered by college and department. 

...

Net Tuition Variance

Net Tuition Variance %

 

Tab 2: Exemption Component Detail TOT

 This tab displays the Exemption components for the selected terms by campus. The data can be filtered by college and department.

...

Exemption Statutory OOS

Total Exemptions

 

detail

Tab 3: Gross Tuition Component

Detail TOT

This tab displays the components of Gross Tuition for the selected terms by campus. The data can be filtered by college and department.

...

 Gross Tuition

 Net Tuition

...

Report : Net Tuition Comparison-Year Over Year

This report shows the net tuition/, exemption/, and gross tuition trends over the selected academic years for the campuses/colleges/departmentsall USF campuses, with options to filter for colleges and departments.

Prompts:

Select Academic Year


Tab1: Net Tuition Comparison for Years

 This tab displays the Net Tuition, Net tuition variance and net tuition variance % of the campus/college/dept Tuition Variance, and Net Tuition Variance % for the selected years

Filters

Org Unit  College academic years by campus. The data can be filtered by college and department. 

Filters

Org Unit College Group

Report Elements

Academic Year

...

Net Tuition Variance

Net Tuition Variance %

 

Tab 2: Exemption Component Detail YOY

This tab displays the Exemption components of the campus/college/dept for the selected yearscomponents for the selected academic years by campus. The data can be filtered by college and department.

Filters

Course Campus

Course College

...

Exemption Statutory OOS

Total Exemptions

 

detail TOT

Tab3: Gross Tuition Component

Detail YOY

This tab displays the gross tuition components of the campus/college/dept for Gross Tuition for the selected academic years .

Filters

by campus. The data can be filtered by college and department.

Filters

Course Campus

Course College

...

Report Elements

Academic Year

 Revenue AGOS

 Revenue Differential

 Revenue OOS

 Revenue Programmatic

 Revenue Tuition

 Gross Tuition

 Net Tuition

...

 

Report : Net Tuition In-State vs Out-of-State

This report shows the residency in-state/out of state composition of tuition of campus/college/department broken down by academic year by Residency Type (Instate and Out-of-State) and Academic Year for all USF campuses for the current and five previous academic years. 

Prompts: N/A


In-State --
Tab1: Net Tuition
Instate vs Out
of
State

This report shows the residency in-state/out of state composition of tuition of campus/college/department broken down by academic year 

Filters:

Academic Year

Course Campus

Course College

Course Department

Residency Type

Course Level Group

Course Level

Course Delivery Method

Report Elements

Academic Year

Course Campus

Course College

Course Department

Residency Type

 Gross Tuition

Total Exemptions

 Net Tuition

 

 

Report : Net Tuition Trending AcademicYear By Campus/College/Department

This report shows the net tuition trend over the years for each campus, college and department 

Prompts: N/A

Tab1: Net Tuition by Campus

This tab displays the gross tuition, total exemption and net tuition of the campuses in a tabular  format as well as displays the % breakdown between the campuses for a particular year.

Filters

 Org Unit  College Group

Report Elements

Table 1

Academic Year

Net Tuition

Table 2

Academic Year

Course Campus

Gross Tuition

Total Exemptions

 Net Tuition

 

Tab 2: Net Tuition by College

This tab displays the net tuition for each college

Filters

Course Campus

Report Elements

Course College

Academic Year

Net Tuition

Tab 3: Net Tuition by Department

This tab displays the net tuition % breakdown between the departments for each college

Filters

Course Campus

Report Elements

Course Department

Academic Year

Net Tuition

Report : Net Tuition: Delivery Method

This report shows the delivery method composition of tuition of campus/college/department broken down by academic year 

Prompts: N/A

Tab1: Net Tuition: Delivery Method

This report shows the delivery method composition of tuition of campus/college/department broken down by academic year 

Filters

Org Unit College Group

Academic Year

Course Campus

Course College

Course Department

Residency Type

Course Level Group

Course Level

Course Delivery Method

Report Elements

Academic Year

Course Campus

Course College

Course Department

Course Delivery Method

Gross Tuition

Total Exemptions

 Net Tuition

Report : Net Tuition: Undergraduate vs Graduate

This report shows the undergraduate and graduate composition of tuition of campus/college/department broken down by academic year 

Prompts: N/A

Tab1: NetTuition: Undergraduate vs Graduate

This report shows the undergraduate and graduate composition of tuition of campus/college/department broken down by academic year

Filters

Org Unit College Group

Academic Year

Course Campus

Course College

Course Department

Residency Type

Course Level Group

Course Level

Course Delivery Method

Report Elements

Academic Year

Course Campus

Course College

Course Department

Course Level Group

Gross Tuition

Total Exemptions

 Net Tuition

Report : RCM Exemption Details

This report shows the exemption components of  campus/college/dept by academic year 

Prompts: N/A

Tab1: Exemption Details

This report shows the exemption components of  campus/college/dept by academic year 

Filters

Org Unit College Group

Course Level Group

Course Level

Residency Type

Course Delivery Method

Report Elements

Academic Year

Course Campus

Exemption EG

Exemption EGOOS

Total Non-Statutory Exemptions

Exemption Statutory

Exemption Statutory Differential

Exemption Statutory Lakeland

Exemption Statutory OOS

Total Statutory Exemptions

Total Exemptions

Report : RCM Tuition Details

This report shows the tuition components of campus/college/dept by academic year 

Prompts: N/A

Tab1: RCM Tuition Details

This report shows the tuition components of campus/college/dept by academic year 

Filters

Org Unit College Group

Course Level Group

Course Level

Residency Type

Course Delivery Method

Report Elements

Academic Year

Course Campus

Revenue AGOS

Revenue Differential

Revenue OOS

Revenue Programmatic

Revenue Tuition

Net Tuition

Report : Total Exemption Trending Academic Year By Campus/College/Department

This report shows the exemption trend over the years for each campus, college and department 

Prompts: N/A

Tab1: Total Exemption Trending Academic Year By Campus/College/Department

This tab displays the exemption trend over the years for each campus, college and department  in a tabular format as well as in a bar chart 

Filters

Org Unit College Group

Report Elements

Course Campus (Drills down to Course College and Course Department )

Academic Year

Total Exemptions

Tab 2: Total Exemption by Department

This tab displays the % breakdown of total exemotion between the departments for a college within a campus in a pie chart.

Filters

Course Campus

Report Elements

(Chart)

...

by Residency Type (Instate and Out-of-State). The report displays tuition data in a bar chart and in a table and can be filtered by Academic Year, Campus, College, and Department. 

  • The bar chart displays Net Tuition totals by Residency Type for the prior six Academic Years. 
  • The table calculates the dollar amounts of Gross and Net Tuition (as well as Total Exemptions) by Residency Type for each college department at USF. The table runs chronologically by Academic Year, listing every department by college at each of the USF campuses. Totals are calculated for each Department, College, Campus, and Academic Year. 

Filters:

Academic Year

Course Campus

Course College

Course Department

Residency Type

Course Level Group

Course Level

Course Delivery Method

Report Elements

Academic Year

Course Campus

Course College

Course Department

Residency Type

Gross Tuition

Total Exemptions

Net Tuition

...

 

Report : Net Tuition Trending Academic Year By Campus/College/Department

This report shows the trend for Net Tuition by Academic Year for each USF Campus, College, and Department.  The report has several components, which are detailed below. 

Prompts: N/A


Tab1: Net Tuition by Campus

This tab displays a table with data for total Net Tuition by Campus for the current and five previous academic years. When you select a row value in the table (Academic Year/Net Tuition), the two dependent report elements update with values for the year selected. 

  • The table updates with tuition data for the selected Academic Year by USF Campus: Gross Tuition, Total Exemptions, and Net Tuition.
  • The pie chart updates with a display of percentages by Course Campus and how each campus contributes to the total Net Tuition.

Filters

Org Unit  College Group

Report Elements

Table 1

Academic Year

Net Tuition

Table 2

Academic Year

Course Campus

Gross Tuition

Total Exemptions

Net Tuition

 

Tab 2: Net Tuition by College

This tab displays the Net Tuition by College, grouped by the respective campuses for the current and five previous academic years. 

Filters

Course Campus

Report Elements

Course College

Academic Year

Net Tuition


Tab 3: Net Tuition by Department

This tab displays the breakdown of Net Tuition for a selected campus. The values default to USF Tampa, but you can change the filter to show the numbers for other USF campuses. 

The first chart to the left shows the Net Tuition for all colleges at the campus, in ascending dollar totals for the selected year. Hover over the green dots to see the total dollar values.

The table to the right displays the Net Tuition by Academic Year for the current and five previous years. The first chart to the left updates when you select a row value in the table (Academic Year/Net Tuition) for a different year.

The pie chart in this display shows a breakdown of total Net Tuition by college department. When you select a College in the first chart (hover over and click the green dot) and an Academic Year in the table (select a row), the pie chart updates to show the tuition breakdown by the Departments in that College for that year. For example, when you select Engineering in the top chart and the 2017-2018 row in the table, the pie chart updates to display the percentages each Engineering department contributes to the total Net Tuition for the College of Engineering in 2017-2018. 

Filters

Course Campus

Report Elements

Course Department

Academic Year

Net Tuition

...

Report : Net Tuition: Delivery Method

This report shows the composition of Net Tuition by Course Delivery Method for all USF campuses for the current and the five previous academic years. 

Prompts: N/A


Tab1: Net Tuition: Delivery Method

This tab displays a bar chart of Net Tuition for the current and five previous academic years. The bars are proportionally distributed by Course Delivery Method, such as Classroom, Distance Learning, or Traditional, and display how each method contributes to the total. 

The table calculates the dollar amounts of Gross and Net Tuition (as well as Total Exemptions) by Course Delivery Method for each college department at USF. The table runs chronologically by Academic Year, listing every department by college at each of the USF campuses. Totals are calculated for each Department, College, Campus, and Academic Year. 

Filters

Org Unit College Group

Academic Year

Course Campus

Course College

Course Department

Residency Type

Course Level Group

Course Level

Course Delivery Method

Report Elements

Academic Year

Course Campus

Course College

Course Department

Course Delivery Method

Gross Tuition

Total Exemptions

 Net Tuition

...

Report : Net Tuition: Undergraduate vs Graduate

This report shows the composition of Net Tuition by Course Level (Undergraduate, Graduate) for all USF campuses for the current and the five previous academic years. 

Prompts: N/A


Tab1: NetTuition: Undergraduate vs Graduate

This tab displays a bar chart of Net Tuition for the current and five previous academic years. The bars are proportionally distributed by Course Level Group (Undergraduate, Graduate) and display how each group contributes to the total. 

The table calculates the dollar amounts of Gross and Net Tuition (as well as Total Exemptions) by Course Level Group for each college department at USF. The table runs chronologically by Academic Year, listing every department by college at each of the USF campuses. Totals are calculated for each Department, College, Campus, and Academic Year. 

Filters

Org Unit College Group

Academic Year

Course Campus

Course College

Course Department

Residency Type

Course Level Group

Course Level

Course Delivery Method

Report Elements

Academic Year

Course Campus

Course College

Course Department

Course Level Group

Gross Tuition

Total Exemptions

Net Tuition

...

Report : RCM Exemption Details

This report shows the various tuition exemption components displayed by Academic Year and USF Campus. 

(RCM = Responsibility Centered Management)

Prompts: N/A


Tab1: Exemption Details

This report shows the various tuition exemption components displayed by Academic Year and USF Campus. Totals are calculated for Total Non-Statutory Exemptions, Total Statutory Exemptions, and Total Exemptions. 

The data can be filtered to show exemption details for the following:

  • Course Campus
  • Course College
  • Course Level Group: Undergraduate, Graduate
  • Course Level: Grad I, Grad II, Upper Level, Lower Level
  • Residency Type: Instate, Out-of-State
  • Course Deliver Method: All Distance Learning, Classroom, Distance learning, Hybrid Blend, Primarily Distance Learning, Traditional

Filters

Org Unit College Group

Course Level Group

Course Level

Residency Type

Course Delivery Method

Report Elements

Academic Year

Course Campus

Exemption EG

Exemption EGOOS

Total Non-Statutory Exemptions

Exemption Statutory

Exemption Statutory Differential

Exemption Statutory Lakeland

Exemption Statutory OOS

Total Statutory Exemptions

Total Exemptions

...

Report : RCM Tuition Details

This report shows the various gross tuition dollar components displayed by Academic Year and college Department. 

(RCM = Responsibility Centered Management)

Prompts: N/A


Tab1: RCM Tuition Details

This tab shows the various gross tuition dollar components displayed by Academic Year and Course Department. Total Gross Tuition by Department is a sum of its components: Revenue AGOS, Revenue Differential, Revenue OOS, Revenue Programmatic, and Revenue Tuition. 

The data can be filtered to show gross tuition details for the following:

  • Course Campus
  • Course College
  • Course Level Group: Undergraduate, Graduate
  • Course Level: Grad I, Grad II, Upper Level, Lower Level
  • Residency Type: Instate, Out-of-State
  • Course Deliver Method: All Distance Learning, Classroom, Distance learning, Hybrid Blend, Primarily Distance Learning, Traditional

Filters

Org Unit College Group

Course Level Group

Course Level

Residency Type

Course Delivery Method

Report Elements

Academic Year

Course Campus

Revenue AGOS

Revenue Differential

Revenue OOS

Revenue Programmatic

Revenue Tuition

Net Tuition

...

Report : Revenue Summary

This report shows a summary of tuition dollars (Gross, Net, and Exemptions) by Academic Year and Course Campus. 

Prompts: N/A


Tab1: Revenue Summary

This tab shows a summary of tuition dollars (Gross, Net, and Exemptions) by Academic Year and Course Campus, broken down by Residency Type (Instate, Out-of-State) and Course Level (Grad I, Grad II, Lower Level, Upper Level). 

The data can be filtered by College and Department.

Filters

Course College

Course Department

Report Elements

Time Unit Year Academic

Course Campus

Person Residency Type

Course Level

Gross Tuition

Total Exemptions

Net Tuition

...

Report : Total Exemption Trending Academic Year By Campus/College/Department

This report shows trend for Total Exemptions by Academic Year for each USF Campus, College, and Department. The report has several components, which are detailed below.

Prompts: N/A


Tab1: Total Exemption Trending Academic Year By Campus/College/Department

This tab displays a bar chart showing Total Exemptions by Course Campus for the current and five previous academic years.

You can select a bar element in the chart to drill down to colleges in the campus and again to departments within the college. The bar chart and the dependent report table below update with exemption dollar amounts for the element selected. For example, if you select the USF Tampa/2018-2019 bar element, the chart updates to graphically display amounts by Academic Year for each Course College. The table also details the dollar amounts by year for each college. 

To drill up to Campus, click the Course College label on the x-axis of the chart. To drill down to Course Department, select the desired element in the bar chart. 

Filters

Org Unit College Group

Report Elements

Course Campus (Drills down to Course College and Course Department)

Academic Year

Total Exemptions


Tab 2: Total Exemption by Department

This tab displays a pie chart showing the percentage breakdown of total exemption dollars by Course Department.

The table to the right displays Total Exemptions by Academic Year. When a year row is selected, the dependent tables update to display Total Exemption dollars:

  • The chart to the left shows the amounts by Course College. Hover over the green dots to see the total dollar values for that Academic Year. 
  • The pie chart below shows the breakdown of exemption dollars by Course Department within a college. When you select a college in the chart to the left (hover over and click the green dot), the values change to reflect the selected college. For example, if you select Medicine in the chart to the left, the pie chart updates to display the percentages each department contributes to the Total Exemptions for the College of Medicine. 

Filters

Course Campus

Report Elements

(Chart)

...

Report : Total Exemption Trending Academic Year By Campus/College/Department and Residency

This report shows trend for Total Exemptions by Academic Year for each USF Campus, College, and Department, grouped by Residency Type. The report has several components, which are detailed below.

Prompts: N/A


Tab1: Total Exemption Trending Academic Year By Campus/College/Department and Residency

This report shows the exemption trend over the years for each campus, college and department broken down by residency type

Prompts: N/A

Tab1: Total Exemption Trending Academic Year By Campus/College/Department and Residency

This tab shows the exemption trend over the years for each campus, college and department broken down by residency type in a tabular formtrend for Total Exemptions by Academic Year for each USF Campus, College, and Department, grouped by Residency Type.

You can select a Course Campus to drill down to Course College and again select Course College to drill down to Course Department. The exemption dollars display for the current and previous five academic years, grouped by Residency Type.

Filters

Org Unit College Group

Report Elements

Course Campus (Drills down to Course College and Course Department )

Residency Type

Academic Year

Total Exemptions


chart

Tab 2: Total Exemption by Residency

Chart

This tab displays the exemption trend over the years for each campus, college and department broken down by residency type in a bar graph.the Total Exemptions trend for the current and previous five Academic Years for each Course Campus by Residency Type.

You can select an element in the bar graph to drill down to exemptions by College and again select an element to drill down to exemptions by Department. Click the label on the x-axis to drill up to College/Campus. 

 Filters

Org Unit College Group

Report Elements

(Chart)

 

...

   

Anchor
Report Elements Glossary
Report Elements Glossary

The table below lists all the elements used in the Tuition Mart reports 

 

 waivers Assitant - Fee Should OOS ; into of state residents undegraduate ; ; instruction. Full Distance Learning Course when , etc Course - Primarily Classroom when ie, labs clinicals, labs, etc).Hybrid Course - 50-79% when Primarily Distance Learning Course - 80-99% of the direc
ElementSourceDescription
Anchor
Term Title
Term Title
Term Title
Cube: TuitionStudentCourseTerm Title of record.
Anchor
Org Unit College Group
Org Unit College Group
Org Unit College Group
Cube: TuitionStudentCourseGrouping to identify Health vs non-Health colleges.
Anchor
Course Campus
Course Campus
Course Campus
Cube: TuitionStudentCourseCampus unit that is funding the course.
Anchor
Course College
Course College
Course College
Cube:TuitionStudentCourseCollege that is funding the course.
Anchor
Course Department
Course Department
Course Department
Cube: TuitionStudentCourseDepartment that is funding the course.
Anchor
Net Tuition
Net Tuition
Net Tuition
Cube: TuitionStudentCourse[Gross Tuition] - [Total Exemptions]
Anchor
Net Tuition Variance
Net Tuition Variance
Net Tuition Variance
Computed ColumnNet Tuition of a year - Net Tuition of Previous Year
Anchor
Net Tuition Variance %
Net Tuition Variance %
Net Tuition Variance %
Computed Column((Net Tuition of a year - Net Tuition of Previous Year)/Net Tuition of Previous Year)*100
Anchor
Exemption EG
Exemption EG
Exemption EG
Cube: TuitionStudentCourseAny non-statutory waivers (a.k.a., funded waivers) that paid tuition.
Anchor
Exemption EGOOS
Exemption EGOOS
Exemption EGOOS
Cube: TuitionStudentCourseAny non-statutory waivers (a.k.a., funded waivers) that paid the Out-of-State fee.
Anchor
Exemption Statutory
Exemption Statutory
Exemption Statutory
Cube: TuitionStudentCourseAny statutory
waivers that paid tuition.
Anchor
Exemption Statutory Differential
Exemption Statutory Differential
Exemption Statutory Differential
Cube: TuitionStudentCourseAny statutory waivers that paid tuition differential tuition.
Anchor
Exemption Statutory Lakeland
Exemption Statutory Lakeland
Exemption Statutory Lakeland
Cube: TuitionStudentCourseAny statutory waivers that paid tuition - just LKL students.
Anchor
Exemption Statutory OOS
Exemption Statutory OOS
Exemption Statutory OOS
Cube: TuitionStudentCourseAny statutory waivers that paid the Out-of-State fee.
Anchor
Total Exemptions
Total Exemptions
Total Exemptions
Cube: TuitionStudentCourse[Exemption EG] + [Exemption EGOOS] + [Exemption Statutory] + [Exemption Statutory Differential] + [Exemption Statutory Lakeland] + [Exemption Statutory OOS]
Anchor
Revenue AGOS
Revenue AGOS
Revenue AGOS
Cube: TuitionStudentCourseGraduate
Assistant Out-of-State Fee Waiver
: A psuedo-waiver that is created to reduce the Out-of-State
fee amount for Graduate Assistants;
should be applied against Revenue
OOS.
Anchor
Revenue Differential
Revenue Differential
Revenue Differential
Cube: TuitionStudentCourseDifferential tuition revenue generated by undergraduate students.
Anchor
Revenue OOS
Revenue OOS
Revenue OOS
Cube: TuitionStudentCourseOut-of-State fee revenue.
Anchor
Revenue Programmatic
Revenue Programmatic
 Revenue Programmatic
Cube: TuitionStudentCourseProgrammatic tuition revenue
, generated by Nursing, Business, and Engineering graduate students.
Anchor
Revenue Tuition
Revenue Tuition
Revenue Tuition
Cube: TuitionStudentCourseTuition revenue less
INTO and self-funded waiver amounts.
Anchor
Gross Tuition
Gross Tuition
Gross Tuition
Cube: TuitionStudentCourse[Revenue AGOS] + [Revenue Differential] + [Revenue OOS] + [Revenue Programmatic] + [Revenue Tuition]
Anchor
Academic Year
Academic Year
Academic Year
Cube: TuitionStudentCourseAcademic year as identified by Summer + Fall + Spring
Anchor
Residency Type
Residency Type
Residency Type
Cube: TuitionStudentCourseFor students, this denotes the student's domicile, within or outside of the State of Florida, identified for the purpose of assessing fees at the institution. Values include - I- Instate Residents and O-Out
-of-State Residents.
Anchor
Course Level Group
Course Level Group
Course Level Group
Cube: TuitionStudentCourseCourse level identified as
undergraduate or graduate level. Undergraduate course have a course number <= 4999. Graduate courses have a course number >= 5000.
Anchor
Course Level
Course Level
Course Level
 Identifies the level of the course. Values include Upper Level
, Lower Level
, Grad I, & Grad II.
Anchor
Course Delivery Method
Course Delivery Method
Course Delivery Method
Cube: TuitionStudentCourseA classification of a course based on the delivery of direct
instruction. Full Distance Learning Course - 100% of the direct instruction of the course is delivered using some form of technology
where the student and instructor are separated by time, space, or both. All special course components (e.g., exams, internships, practica, clinicals, labs
) that cannot be completed online can be completed off-campus. Primarily Classroom
Learning Course - Less than 50% of the direct instruction of the course is delivered using some form of technology
where the student and instructor are separated by time, space, or both. This designation can include activities that do not occur in a classroom (
e.g., exams, internships, practica,
clinicals, labs). Hybrid Course - 50-79% of the direct instruction of the course is delivered using some form of technology where the student and instructor are separated by time, space, or both. Primarily Distance Learning Course - 80-99% of the direct instruction of the course is delivered using some form of technology
where the student and instructor are separated by time, space, or both.
All special course components (e.g., exams, internships, practica, clinicals, labs) that cannot be completed online can be completed off-campus.
Anchor
Total Non-Statutory Exemptions
Total Non-Statutory Exemptions
Total Non-Statutory Exemptions
Cube: TuitionStudentCourse[Exemption EG] + [Exemption EGOOS]
Anchor
Total Statutory Exemptions
Total Statutory Exemptions
Total Statutory Exemptions
Cube: TuitionStudentCourse[Exemption Statutory] + [Exemption Statutory Differential] + [Exemption Statutory Lakeland] + [Exemption Statutory OOS]

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

...