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.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 the net tuition/exemption/gross tuition trends over the terms for the campuses/colleges/departmentsshows 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 Completion Percentage (Optional): DGW Completion Percentage
Enter maximum for DGW Completion percentage 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
42 Hours of Upper Level Courses
48 Hours of Upper Lvel Courses
Conc in Anthropology ISSOther 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
Prompts: N/A
Filters
Report Elements
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 the residency in-state/out of state composition of tuition of campus/college/department broken down by academic year
Prompts: N/A
This report shows
Filters:
Report Elements
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 | ||||||
---|---|---|---|---|---|---|---|---|
| Cube:EIS DegreeWorks- DegreeWorks | Identifies the student's home campus. | ||||||
| Cube:EIS DegreeWorks- DegreeWorks | Identifies the student's college of registration. | ||||||
| Term Title | Term Title | Term TitleCube: TuitionStudentCourse | Term Title of record|||||
Cube: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. |
...