...
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.
...
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.
...
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.
...
Tab 3: Gross Tuition ComponentdetailDetail TOT |
---|
This tab displays the components of Gross Tuition for the selected terms by campus. The data can be filtered by college and department.
...
...
Report : Net Tuition Comparison-Year Over Year |
---|
This report shows the net tuition, exemption, and gross tuition trends over the selected academic years for all USF campuses, with options to filter for colleges and departments.
...
This tab displays the Net Tuition, Net Tuition Variance, and Net Tuition Variance % for the selected academic years by campus. The data can be filtered by college and department.
Filters
Org Unit College College Group
Report Elements
...
This report shows the composition of tuition 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
Tab1: Net Tuition Instate vs Out of State |
---|
This report shows the composition of tuition 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:
...
...
Report : Net Tuition Trending Academic Year By Campus/College/Department |
---|
...
- 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 new tuitionNet Tuition.
Filters
Report Elements
...
Tab 2: Net Tuition by College |
---|
This tab displays the net tuition Net Tuition by College, grouped by the respective campuses for the current and five previous academic years.
...
This tab displays the breakdown of Net Tuition for a selected campus. The dollar 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 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 collegeyear. 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
Report Elements
...
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 displays calculates the Gross Tuition, Total Exemptions, and Net Tuition by Campus, College, and Department. Each department's tuition dollars are then split out dollar amounts of Gross and Net Tuition (as well as Total Exemptions) by Course Delivery Method . The report provides totals by Department and by Campusfor 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
...
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, Undergraduate and Graduate levels, ) and display how each group contributes to the total.
The table displays calculates the dollar amounts of Gross Tuition, Total Exemptions, and Net Tuition grouped by Campus, College, and Department. Each department's tuition dollars are then split out by Course Level. The report provides totals by Department and by Campusand 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
...
...
Report : RCM Exemption Details |
---|
...
(RCM = Responsibility Centered Management; RMA = Resource Management & Analysis)
Prompts: N/A
Tab1: Exemption Details |
---|
This report shows the various tuition exemption components displayed by Academic Year and USF Campus. Totals are provided 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
...
(RCM = Responsibility Centered Management; RMA = Resource Management & Analysis)
Prompts: N/A
Tab1: RCM Tuition Details |
---|
...
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
...
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).
...
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 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 the exemption trend over the years for each campus, college and department in a tabular format as well as in a bar chart
Filters
Report Elements
Course Campus (Drills down to Course College and Course Department )
Tab 2: Total Exemption by Department |
---|
This tab displays the % breakdown of total exemption between the departments for a college within a campus in a pie chart.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
Report Elements
Course Campus (Drills down to Course College and Course Department)
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
Report Elements
...
Report : 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 typetrend 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 tab shows the exemption trend over the years for each campus, college and department broken down by residency type in a tabular formreport shows the trend 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
...
Tab 2: Total Exemption by ResidencychartChart |
---|
This tab displays the exemption trend over the years for each campus, college and department broken down by residency type in a bar graph.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
Report Elements
(Chart)
...
Anchor | ||||
---|---|---|---|---|
|
...
Element | Source | Description | ||||||
---|---|---|---|---|---|---|---|---|
| Cube: TuitionStudentCourse | Term Title of record. | ||||||
| Cube: TuitionStudentCourse | Grouping to identify Health vs non-Health colleges. | ||||||
| Cube: TuitionStudentCourse | Campus unit that is funding the course. | ||||||
| Cube:TuitionStudentCourse | College that is funding the course. | ||||||
| Cube: TuitionStudentCourse | Department that is funding the course. | ||||||
| Cube: TuitionStudentCourse | [Gross Tuition] - [Total Exemptions] | ||||||
| Computed Column | Net Tuition of a year - Net Tuition of Previous Year | ||||||
| Computed Column | ((Net Tuition of a year - Net Tuition of Previous Year)/Net Tuition of Previous Year)*100 | ||||||
| Cube: TuitionStudentCourse | Any non-statutory waivers (a.k.a., funded waivers) that paid tuition. | ||||||
| Cube: TuitionStudentCourse | Any non-statutory waivers (a.k.a., funded waivers) that paid the Out-of-State fee. | ||||||
| Cube: TuitionStudentCourse | Any statutory waivers waivers that paid tuition. | ||||||
| Cube: TuitionStudentCourse | Any statutory waivers that paid tuition differential tuition. | ||||||
| Cube: TuitionStudentCourse | Any statutory waivers that paid tuition - just LKL students. | ||||||
| Cube: TuitionStudentCourse | Any statutory waivers that paid the Out-of-State fee. | ||||||
| Cube: TuitionStudentCourse | [Exemption EG] + [Exemption EGOOS] + [Exemption Statutory] + [Exemption Statutory Differential] + [Exemption Statutory Lakeland] + [Exemption Statutory OOS] | ||||||
| Cube: TuitionStudentCourse | Graduate Assitant Assistant Out-of-State Fee Waiver - : A psuedo-waiver that is created to reduce the Out-of-State Fee fee amount for Graduate Assistants; Should should be applied against Revenue OOS OOS. | ||||||
| Cube: TuitionStudentCourse | Differential tuition revenue generated by undergraduate students. | ||||||
| Cube: TuitionStudentCourse | Out-of-State fee revenue. | ||||||
| Cube: TuitionStudentCourse | Programmatic tuition revenue; , generated by Nursing, Business, and Engineering graduate students. | ||||||
| Cube: TuitionStudentCourse | Tuition revenue less into INTO and self-funded waiver amounts. | ||||||
| Cube: TuitionStudentCourse | [Revenue AGOS] + [Revenue Differential] + [Revenue OOS] + [Revenue Programmatic] + [Revenue Tuition] | ||||||
| Cube: TuitionStudentCourse | Academic year as identified by Summer + Fall + Spring | ||||||
| Cube: TuitionStudentCourse | For 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-of-State Residents. | ||||||
| Cube: TuitionStudentCourse | Course level identified as undegraduate undergraduate or graduate level. Undergraduate course have a course number <= 4999. Graduate courses have a course number >= 5000. | ||||||
| Identifies the level of the course. Values include Upper Level; , Lower Level; , Grad I, & Grad II. | |||||||
| Cube: TuitionStudentCourse | A classification of a course based on the delivery of direct instruction. Full Distance Learning Course. Full Distance Learning Course - 100% of the direct instruction of the course is delivered using some form of technology when where the student and instructor are separated by time, space, or both. All special course components (e.g., exams, internships, practica, clinicals, labs, etc) that cannot be completed online can be completed off-campus. Primarily Classroom Course - Primarily Classroom Learning Course - Less than 50% of the direct instruction of the course is delivered using some form of technology when where the student and instructor are separated by time, space, or both. This designation can include activities that do not occur in a classroom (ie, labse.g., exams, internships, practica, clinicals, labs, etc). Hybrid Course - 50-79% of the direct instruction of the course is delivered using some form of technology when 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 the directechnology 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. | ||||||
| Cube: TuitionStudentCourse | [Exemption EG] + [Exemption EGOOS] | ||||||
| Cube: TuitionStudentCourse | [Exemption Statutory] + [Exemption Statutory Differential] + [Exemption Statutory Lakeland] + [Exemption Statutory OOS] |
...