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 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 all USF campuses, with options to filter for colleges and departments.
Prompts
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.
Filters
Report Elements
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.
Filters
Report Elements
Exemption Statutory Differential
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.
Filters
Report Elements
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.
Prompts:
Tab1: Net Tuition Comparison for Years |
---|
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
Report Elements
Tab 2: Exemption Component Detail YOY |
---|
This tab displays the Exemption components for the selected academic years by campus. The data can be filtered by college and department.
Filters
Report Elements
Exemption Statutory Differential
Tab3: Gross Tuition Component Detail YOY |
---|
This tab displays the components of Gross Tuition for the selected academic years by campus. The data can be filtered by college and department.
Filters
Report Elements
Report : Net Tuition In-State vs Out-of-State |
---|
This report shows the composition of tuition by Residency Type (Instate and Out-of-State) and Academic Year for all USF campuses.
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 total Net Tuition by Residency Type for the prior six Academic Years.
The table displays the components of Gross and Net Tuition (as well as Total Exemptions) by Residency Type, grouped by Campus, College, and Department for each Academic Year. Totals are tallied by Campus and by Academic Year for all campuses.
Filters:
Report Elements
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
Report Elements
Table 1
Table 2
Tab 2: Net Tuition by College |
---|
This tab displays the net tuition for each college
Filters
Report Elements
Tab 3: Net Tuition by Department |
---|
This tab displays the net tuition % breakdown between the departments for each college
Filters
Report Elements
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
Report Elements
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
Report Elements
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
Report Elements
Total Non-Statutory Exemptions
Exemption Statutory Differential
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
Report Elements
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
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 exemotion between the departments for a college within a campus in a pie chart.
Filters
Report Elements
(Chart)
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 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 form.
Filters
Report Elements
Course Campus (Drills down to Course College and Course Department )
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.
Filters
Report Elements
(Chart)
The table below lists all the elements used in the Tuition Mart reports
Element | Source | Description |
---|---|---|
Term Title | Cube: TuitionStudentCourse | Term Title of record. |
Org Unit College Group | Cube: TuitionStudentCourse | Grouping to identify Health vs non Health colleges |
Course Campus | Cube: TuitionStudentCourse | Campus unit that is funding the course. |
Course College | Cube:TuitionStudentCourse | College that is funding the course. |
Course Department | Cube: TuitionStudentCourse | Department that is funding the course. |
Net Tuition | Cube: TuitionStudentCourse | [Gross Tuition] - [Total Exemptions] |
Net Tuition Variance | Computed Column | Net Tuition of a year- Net Tuition of Previous Year |
Net Tuition Variance % | Computed Column | ((Net Tuition of a year- Net Tuition of Previous Year)/Net Tuition of Previous Year)*100 |
Exemption EG | Cube: TuitionStudentCourse | Any non-statutory waivers (a.k.a. funded waivers) that paid tuition |
Exemption EGOOS | Cube: TuitionStudentCourse | Any non-statutory waivers (a.k.a. funded waivers) that paid the Out-of-State fee |
Exemption Statutory | Cube: TuitionStudentCourse | Any statutory waivers that paid tuition |
Exemption Statutory Differential | Cube: TuitionStudentCourse | Any statutory waivers that paid tuition differential tuition |
Exemption Statutory Lakeland | Cube: TuitionStudentCourse | Any statutory waivers that paid tuition - just LKL students |
Exemption Statutory OOS | Cube: TuitionStudentCourse | Any statutory waivers that paid the Out-of-State fee |
Total Exemptions | Cube: TuitionStudentCourse | [Exemption EG] + [Exemption EGOOS] + [Exemption Statutory] + [Exemption Statutory Differential] + [Exemption Statutory Lakeland] + [Exemption Statutory OOS] |
Revenue AGOS | Cube: TuitionStudentCourse | Graduate Assitant 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 |
Revenue Differential | Cube: TuitionStudentCourse | Differential tuition revenue generated by undergraduate students |
Revenue OOS | Cube: TuitionStudentCourse | Out-of-State fee revenue |
Revenue Programmatic | Cube: TuitionStudentCourse | Programmatic tuition revenue; generated by Nursing, Business, and Engineering graduate students |
Revenue Tuition | Cube: TuitionStudentCourse | Tuition revenue less into and self-funded waiver amounts |
Gross Tuition | Cube: TuitionStudentCourse | [Revenue AGOS] + [Revenue Differential] + [Revenue OOS] + [Revenue Programmatic] + [Revenue Tuition] |
Academic Year | Cube: TuitionStudentCourse | Academic year as identified by Summer + Fall + Spring |
Residency Type | 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 |
Course Level Group | Cube: TuitionStudentCourse | Course level identified as undegraduate or graduate level. Undergraduate course have a course number <= 4999. Graduate courses have a course number >= 5000 |
Course Level | Identifies the level of the course.Values include Upper Level; Lower Level; Grad I & Grad II | |
Course Delivery Method | 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 the student and instructor are separated by time, space, or both. All special course components (exams, internships, practica, clinicals, labs, etc) that cannot be completed online can be completed off-campus.Primarily Classroom Course - Primarily Classroom Course - Less than 50% of the direct instruction of the course is delivered using some form of technology when the student and instructor are separated by time, space or both. This designation can include activities that do not occur in a classroom (ie, labs, internships, practica, clinicals, labs, etc).Hybrid Course - 50-79% of the direct instruction of the course is delivered using some form of technology when the student and instructor are separated by time, space or both.Primarily Distance Learning Course - 80-99% of the direc |
Total Non-Statutory Exemptions | Cube: TuitionStudentCourse | [Exemption EG] + [Exemption EGOOS] |
Total Statutory Exemptions | Cube: TuitionStudentCourse | [Exemption Statutory] + [Exemption Statutory Differential] + [Exemption Statutory Lakeland] + [Exemption Statutory OOS] |