Tuition Mart provides a series of reports that capture collections information along with the relevant details associated with student tuition. These reports provide the ability to drill down to various campus, college and department levels for both courses and students. It also provides the ability to do trend analysis across time. The major data points include gross tuition and its components, exemptions and its components and net tuition along with major student and course attributes. Resource Management and Analysis is the functional owner of this data mart.
| Table of Contents | ||
|---|---|---|
|
Report Elements Glossary Table
Report : Net Tuition Comparison-Term Over Term |
|---|
This report shows the net tuition/exemption/gross tuition trends over the terms for the campuses/colleges/departments
Prompts
Tab 1:Net Tuition Comparison for Terms |
|---|
This tab displays the Net Tuition, Net tuition variance and net tuition variance % of the campus/college/dept for the selected terms
Filters
Report Elements
Tab 2:Exemption Component Detail TOT |
|---|
This tab displays the Exemption components of the campus/college/dept for the selected terms
Filters
Report Elements
Exemption Statutory Differential
Tab 3:Gross Tuition Component detail TOT |
|---|
This tab displays the gross tuition components of the campus/college/dept for the selected terms
Filters
Report Elements
Report : Net Tuition Comparison-Year Over Year |
|---|
This report shows the net tuition/exemption/gross tuition trends over the years for the campuses/colleges/departments
Prompts:
Tab1: Net Tuition Comparison for Years |
|---|
This tab displays the Net Tuition, Net tuition variance and net tuition variance % of the campus/college/dept for the selected years
Filters
Report Elements
Tab 2: Exemption Component Detail YOY |
|---|
This tab displays the Exemption components of the campus/college/dept for the selected years
Filters
Report Elements
Exemption Statutory Differential
Tab3: Gross Tuition Component detail TOT |
|---|
This tab displays the gross tuition components of the campus/college/dept for the selected years.
Filters
Report Elements
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
Prompts: N/A
| Tab1: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
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 DegreeWorks database contains metrics for USF degree-seeking students with reference to their school achievement and progress toward graduation. DegreeWorks data are displayed in three reports: Student Degree Completion Report for Advisor, Students Over 120 Credit Hours–Advisor Report, and Students within Specified Credits for Selected Blocks.
Student data is initially accessed from the DegreeWorks database. The population of students pulled from DegreeWorks are:
- Degree-seeking undergraduates
- Post-baccalaureate degree-seeking students
- Pre-majors or undeclared degree-seeking undergraduates
The population of students that are NOT pulled from DegreeWorks are:
- Non-degree-seeking undergraduates
- COPH students
- Graduate students
This population of students from the DegreeWorks database are then mapped to Benchmark data to match with those students who have been enrolled in at least one of the last three terms. For example, in November, the three terms are Summer, Spring, Fall, and in March, the three terms are Fall, Summer, Spring.
The DegreeWorks Cube is then updated, which results in a composition of active, degree-seeking students.
Database updates: Cubes are updated on the 1st Monday of every month. In May, August, and December, cubes are updated every Monday.
| Table of Contents | ||
|---|---|---|
|
Report Elements Glossary Table
...
Report : Student Degree Completion Report for Advisor |
|---|
This report shows Student Degree Completion status for an advisor. It helps them to identify students close to graduation and what their different statuses are within DegreeWorks.
The report displays data in three tabs: Student Advisor Report, Completion Bar Graph, and Completion Pie Chart.
Prompts
Enter value(s) for Student Home Campus (Mandatory): Student Home Campus
Enter value(s) for Student College (Mandatory): Student College
Enter values for Student Department (Optional): Student Department
Enter minimum for DGW Completion Percentage (Optional): DGW Completion Percentage
Enter maximum for DGW Completion Percentage (Optional): DGW Completion Percentage
Select DGW Requirement Blocks to display (Optional): DGW Requirement Blocks to display
| Tab 1: Student Advisor Report |
|---|
The report on this tab displays a list of students in tabular format, based on the filters selected in the prompts. The degree completion blocks display the credits or requirements needed for graduation.
Filters
Student Institutional Classification
Report Elements
Other columns vary with the required blocks for the audit. For degree completion blocks: if shaded green then all requirements for that block are complete; if shaded red, some credits or requirements are still missing.
The report displays the date the report is run along with the date the data was last refreshed in the database.
| Tab 2: Completion Bar Graph |
|---|
The report on this tab displays a bar graph showing the count of students grouped by degree Completion Groups.
| Tab 3: Completion Pie Chart |
|---|
The report on this tab displays a pie chart showing the count of students and percentages relative to the whole, grouped by degree Completion Groups.
...
Report : Students Over 120 Credit Hours-Advisor Report |
|---|
This report shows the students who are already exceeding the normal number of credit hours needed to graduate in their program so their department can get them to graduate ASAP and avoid penalties for excess hours. The added filter of Institutional Classification (Junior or Senior) can help judge the student's risk of impacting the 4-year-graduation-rate metric.
Prompts:
Enter value(s) for Student Home Campus (Mandatory): Student Home Campus
Enter value(s) for Student College (Mandatory): Student College
Enter values for Student Department (Optional): Student Department
| Tab 1: Student Over Specified Hours |
|---|
Filters
Student Institutional Classification
Report Elements
...
Report : Students within Specified Credits for Selected Blocks |
|---|
This report shows active students within specified credits for selected blocks (typically blocks without overlapping credit).
Prompts:
Enter value(s) for Student Home Campus (Mandatory): Student Home Campus
Enter value(s) for Student College (Mandatory): Student College
Enter values for Student Department (Optional): Student Department
Select blocks to determine Credits needed (Mandatory): DGW Requirement Blocks to display
| Tab 1: Student All Blocks |
|---|
This report displays a table listing students in the selected campus, college, and (optional) department. Based on the clocks selected in the prompts, it shows the active students and the credits needed for each student.
Filters:
Student Institutional Classification
Report Elements
Other columns displayed vary with the blocks selected at the prompts. For degree completion blocks: if shaded green, then all requirements for that block are complete; if shaded red, some credits or requirements are still missing.
...
| Anchor | ||||
|---|---|---|---|---|
|
The table below lists all the elements used in the Tuition Mart reports DegreeWorks reports.
| Element | Source | Description | ||||||
|---|---|---|---|---|---|---|---|---|
| Term Title | Term Title | Term TitleCube: TuitionStudentCourse | Term Title of record. | ||||
| Anchor | Org Unit College Group | Org Unit College Group | Org Unit College GroupCube: TuitionStudentCourse | Grouping to identify Health vs non Health colleges | ||||
| Anchor | Course Campus | Course Campus | Course||||||
| Cube: | |||||||
| EIS DegreeWorks- DegreeWorks | Identifies the student's home campus. | |||||||
| ||||||||
| ||||||||
| ||||||||
Student College | Cube: | |||||||
| EIS DegreeWorks- DegreeWorks | Identifies the student's college of registration. | |||||||
| ||||||||
| ||||||||
| ||||||||
Student Department | Cube: | Department that is funding the course. | ||||||
| Anchor | Net Tuition | Net Tuition | Net TuitionCube: TuitionStudentCourse | [Gross Tuition] - [Total Exemptions] | ||||
| Anchor | Net Tuition Variance | Net Tuition Variance | Net Tuition VarianceComputed Column | Net 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 EGCube: TuitionStudentCourse | Any non-statutory waivers (a.k.a. funded waivers) that paid tuition | ||||
| Anchor | Exemption EGOOS | Exemption EGOOS | Exemption EGOOSCube: TuitionStudentCourse | Any non-statutory waivers (a.k.a. funded waivers) that paid the Out-of-State fee | ||||
| Anchor | Exemption Statutory | Exemption Statutory | Exemption StatutoryCube: TuitionStudentCourse | Any statutory waivers that paid tuition | ||||
| Anchor | Exemption Statutory Differential | Exemption Statutory Differential | Exemption Statutory DifferentialCube: TuitionStudentCourse | Any statutory waivers that paid tuition differential tuition | ||||
| Anchor | Exemption Statutory Lakeland | Exemption Statutory Lakeland | Exemption Statutory LakelandCube: TuitionStudentCourse | Any statutory waivers that paid tuition - just LKL students | ||||
| Anchor | Exemption Statutory OOS | Exemption Statutory OOS | Exemption Statutory OOSCube: TuitionStudentCourse | Any statutory waivers that paid the Out-of-State fee | ||||
| Anchor | Total Exemptions | Total Exemptions | Total ExemptionsCube: TuitionStudentCourse | [Exemption EG] + [Exemption EGOOS] + [Exemption Statutory] + [Exemption Statutory Differential] + [Exemption Statutory Lakeland] + [Exemption Statutory OOS] | ||||
| Anchor | Revenue AGOS | Revenue AGOS | Revenue AGOSCube: 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 | ||||
| Anchor | Revenue Differential | Revenue Differential | Revenue DifferentialCube: TuitionStudentCourse | Differential tuition revenue generated by undergraduate students | ||||
| Anchor | Revenue OOS | Revenue OOS | Revenue OOSCube: TuitionStudentCourse | Out-of-State fee revenue | ||||
| Anchor | Revenue Programmatic | Revenue Programmatic | Revenue ProgrammaticCube: TuitionStudentCourse | Programmatic tuition revenue; generated by Nursing, Business, and Engineering graduate students | ||||
| Anchor | Revenue Tuition | Revenue Tuition | Revenue TuitionCube: TuitionStudentCourse | Tuition revenue less into and self-funded waiver amounts | ||||
| Anchor | Gross Tuition | Gross Tuition | Gross TuitionCube: TuitionStudentCourse | [Revenue AGOS] + [Revenue Differential] + [Revenue OOS] + [Revenue Programmatic] + [Revenue Tuition] | ||||
| Anchor | Academic Year | Academic Year | Academic YearCube: TuitionStudentCourse | Academic year as identified by Summer + Fall + Spring | ||||
| Anchor | Residency Type | Residency Type | Residency TypeCube: 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 | ||||
| Anchor | Course Level Group | Course Level Group | Course Level GroupCube: TuitionStudentCourse | Course level identified as undegraduate or graduate level. Undergraduate course have a course number <= 4999. Graduate courses have a course number >= 5000 | ||||
| Anchor | Course Level | Course Level | Course LevelIdentifies the level of the course.Values include Upper Level; Lower Level; Grad I & Grad II | |||||
| Anchor | Course Delivery Method | Course Delivery Method | Course Delivery MethodCube: 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 | ||||
| Anchor | Total Non-Statutory Exemptions | Total Non-Statutory Exemptions | Total Non-Statutory ExemptionsCube: TuitionStudentCourse | [Exemption EG] + [Exemption EGOOS] | ||||
| Anchor | Total Statutory Exemptions | Total Statutory Exemptions | Total Statutory ExemptionsCube: TuitionStudentCourse | [Exemption Statutory] + [Exemption Statutory Differential] + [Exemption Statutory Lakeland] + [Exemption Statutory OOS]|||||
| EIS DegreeWorks- DegreeWorks | Identifies the student's department of registration. | |||||||
| Cube:EIS DegreeWorks- DegreeWorks | Shows DegreeWorks completion percentage progress towards completion of the credit requirements for the student according to the catalog hours. | ||||||
| Cube:EIS DegreeWorks- DegreeWorks | These are the blocks selected when requesting the report that provides details on a student's completion toward his or her degree program, including major requirements, minor requirements, and concentrations, | ||||||
| Cube:EIS DegreeWorks- DegreeWorks | The categorization of a student's progress, as defined by the institution, at the beginning of a term. | ||||||
| Cube:EIS DegreeWorks- DegreeWorks | Identifies the student's type of admission to the university, based on the following values:
| ||||||
| Cube:EIS DegreeWorks- DegreeWorks | DegreeWorks catalog year for the degree being sought. Catalog year is determined by the year a student begins at USF for as long as he or she maintains continuous enrollment. A catalog year is defined by the academic year in which a student enters USF. | ||||||
| Cube:EIS DegreeWorks- DegreeWorks | Last Name of person. | ||||||
| Cube:EIS DegreeWorks- DegreeWorks | First Name of person. | ||||||
| Cube:EIS DegreeWorks- DegreeWorks | The student's university identification number. | ||||||
| Cube:EIS DegreeWorks- DegreeWorks | Email address of the student. | ||||||
| Cube:EIS DegreeWorks- DegreeWorks | Most recent enrollment term. | ||||||
| Cube:EIS DegreeWorks- DegreeWorks | DegreeWorks catalog year for the degree being sought. Catalog year is determined by the year a student begins at USF for as long as he or she maintains continuous enrollment. A catalog year is defined by the academic year in which a student enters USF. | ||||||
| Cube:EIS DegreeWorks- DegreeWorks | Degree that the student may qualify towards, according to DegreeWorks. | ||||||
| Cube:EIS DegreeWorks- DegreeWorks | Primary major in which the student can get a degree, according to DegreeWorks, concatenated with a secondary major that the student can get, according to DegreeWorks | ||||||
| Cube:EIS DegreeWorks- DegreeWorks | DegreeWorks credits needed towards the degree program. | ||||||
| Cube:EIS DegreeWorks- DegreeWorks | Total applied GPA towards the specific degree that the student may qualify towards, according to DegreeWorks. | ||||||
| Cube:EIS DegreeWorks- DegreeWorks | DegreeWorks credits applied towards the degree program. |
...