FIF reports document some of the elements in USF's efforts to raise the 4-year graduation rate for students. With USF embarked upon a path to preeminence, this finish in four goal will benefit students, their families, and USF. The reports developed help the Provost, Senior Executives, and Advisors achieve this goal.
Report Elements Glossary Table
Report : FIF_Summary |
---|
The FIF_Summary report recaps the metrics for the selected cohort pertaining to the Finish in Four objectives. The report displays the data in two tabs described below: FIF Scorecard and FIF Matrix.
Tab 1: FIF Scorecard
The FIF Scorecard provides a summary of the Finish in Four metrics. The displays on this page include:
- The number and percent of students in the cohort that have graduated to date within a 4-year window
- The number and percent of students estimated to graduate within the 4-year window
- The number of students either over or under the goal of 60% of the total cohort
- The anticipated 4-Year graduations by term (Fall, Spring, Summer)
Note: Only those students who get a degree from the same campus in which they started are being counted as a successful graduate for FIF reports.
Filters
Report Elements
Estimated 4-Year Graduation % (Includes Actual)
Anticipated 4-Year Graduations by Term
Tab 2: FIF Matrix
The display on this tab provides the estimated 4-year graduation matrix by original college and current college. The values in each cell of the Estimated 4-Year Graduation % Matrix table represent the percent of students in the selected cohort who started in the original college and are now in the current college (Original College is by row and Current College is by column).
Note: Only those students who get a degree from the same campus in which they started are being counted as a successful graduate for FIF reports.
Selecting the individual cells in the matrix adjusts the visualizations below the table to show the number of students who have graduated and the number of students who have an estimated graduation date.
Filters
Report Elements
Estimated 4-Year Graduation # (Includes Actual)
Anticipated 4-Year Graduations by Term
Report : FIF_Status |
---|
The FIF-Status report displays the metrics of the student population and the likelihood of these students that they will graduate within the four-year window. The report displays in two tabs: Four-Year Non-Completions and Four-Year Completions.
Tab 1: Four-Year Non-Completions
This tab displays the details of the students who are not expected to graduate in 4 years. Details include:
- The left panel displays the total number and percent of students who are not expected to graduate and includes the number of students who are not expected to return to the university.
- The center panel consists of two displays for those students not expecting to graduate: number of years to graduate, degree plans available, and hours left to graduate.
- The right panel shows the anticipated term of graduation, such as Spring 2019 or Fall 2021.
Note: Only those students who get a degree from the same campus in which they started are being counted as a successful graduate for FIF reports.
Filters
Report Elements
Anticipated Graduations By Term
Tab 2: Four Year Completions
This tab displays the details of the students who are estimated to graduate in 4 years.
- The left panel displays the total number and percent of students who are expected to graduate and includes the number of students currently working toward graduation.
- The center panel consists of two displays for those students expecting to graduate in 4 years: potential years to graduate, degree plans available, and hours left to graduate.
- The right panel shows the anticipated term of graduation, such as Spring 2019 or Fall 2021.
Note: Only those students who get a degree from the same campus in which they started are being counted as a successful graduate for FIF reports.
Filters
Report Elements
Anticipated Graduations By Term
Report : FIF_Detail |
---|
The FIF_Detail report is a table listing students in the selected cohort (along with other available filters, such as department or major). Details in the table include the student's graduation status, anticipated graduation term, whether the student is returning, and the number of hours students have left to graduate.
Note: Only those students who get a degree from the same campus in which they started are being counted as a successful graduate for FIF reports.
Filters
Report Elements
Graduation Application Status Date
Report : FIF_Progress Report |
---|
The FIF_ Progress Report showcases the efforts of advisors on working with the students in helping them complete their degree. Data are for students in their current college and delineate between those who have been in the current college the whole time vs those who have changed to their current college.
Note: Only those students who get a degree from the same campus in which they started are being counted as a successful graduate for FIF reports.
Filters
Report Elements
Students Addressed Distribution: Internal vs External
Report : FIF_Major_Changes |
---|
The FIF_Major Changes report displays the details of students in the selected cohort who have changed their majors.
Note: Only those students who get a degree from the same campus in which they started are being counted as a successful graduate for FIF reports.
Filters
Report Elements
Report : FIF_Advisor |
---|
The FIF_Advisor report displays the list of advisors for students in the selected cohort. Users can filter by selecting a college and department, then select an advisor in the Advisor Details table to see his or her students and their progress toward graduation. The report includes detailed metrics for both advisors and students such as Students with a Degree Plan for the advisors and Hours Left to Graduate for the students.
Note: Only those students who get a degree from the same campus in which they started are being counted as a successful graduate for FIF reports.
Filters
Report Elements
Estimated Graduates in 4 Years %
Report : FIF_PlannerDiscrepancyReport |
---|
The FIF-Planner Discrepancy report identifies students in the selected cohort who did not register for courses that match courses in their DegreeWorks Planner for the current and future registration terms.
Note: Only those students who get a degree from the same campus in which they started are being counted as a successful graduate for FIF reports.
Filters
Report Elements
Report : FIF_FinalGradesReport |
---|
The FIF_Final Grades report identifies students in the selected cohort who did not satisfactorily complete a course (after grades roll) that was in their DegreeWorks planner or who were on academic probation after end-of-term processing.
Note: Only those students who get a degree from the same campus in which they started are being counted as a successful graduate for FIF reports.
Filters
Report Elements
The table below lists all the elements used in the FIF Reports.
Element | Source (System->Table->COLUMN) | Description | Frequency of Update |
---|---|---|---|
Select Cohort | Banner-> Sgrchrt | Students listed in Banner with an FTICFT<YY>08 cohort, e.g., FTICFT1408, FTICFT1508. Note that these Banner cohorts FTICFT<YY>08 are translated to FIF20<YY>, for example FTICFT1408 translates to FIF2014 in these reports. FIF2014 - This cohort includes First Time In College (FTIC) students who started in Summer 2014 and continued on to Fall 2014 as a full-time student along with students who started in Fall 2014 as full-time students. | Annual |
Campus Original | SID-> Sid_Enrollments-> HOMECAMPUS | The campus where the student was enrolled when he or she first entered the cohort. | Annual |
College Original | SID-> Sid_Enrollments-> COLLEGE | The college where the student was enrolled when he or she first entered the cohort. | Annual |
Department Original | SID-> Sid_Enrollments-> DEPARTMENT | The department where the student was enrolled when he or she first entered the cohort. | Annual |
Major Original | SID-> Sid_Enrollments-> MAJOR | The major the student selected when he or she first entered the cohort. | Annual |
Campus Current | Banner-> Sgbstdn-> SGBSTDN_CAMP_CODE | The campus of the student's most recent enrollment. | Daily |
College Current | Banner-> Sgbstdn> SGBSTDN_COLL_CODE_1 | The college of the student's most recent enrollment. | Daily |
Department Current | Banner-> Sgbstdn-> SGBSTDN_DEPT_CODE | The department of the student's most recent enrollment. | Daily |
Major Current | Banner-> Sgbstdn-> SGBSTDN_MAJR_CODE_1 | The student's most recently selected major. | Daily |
Gender | Banner→ Spbpers->SPBPERS_SEX | The gender of the student. This is used as a filter to view data for males only or females only. | Daily |
Actual Graduated | Banner-> Shrdgmr | Graduation status of Awarded for Bachelor level degrees in Banner within a 4-year window from the time of the cohort start. Only those students who get a degree from the same campus in which they started are being counted as a successful graduate for FIF reports. | Daily |
Actual Graduated % | Computed | Actual Graduated students as a percentage of the FIF Cohort within a 4-year window from the time of the cohort start. Only those students who get a degree from the same campus in which they started are being counted as a successful graduate for FIF reports. | Daily |
Actual Gap | Computed | The number of students who need to graduate within 4 years, in addition to those who have graduated, so that the cohort can meet the target graduation rate. | Daily |
Estimated 4-Year Graduation # | Computed | Number of students who have graduated or are working towards graduation in the specified time. | Daily |
Estimated 4 Year Graduation % | Computed | Estimated number of graduates as a percentage of the total FIF cohort. | Daily |
Estimated Gap | Computed | The number of additional students who need an anticipated graduation term before the end of the fourth year to meet the target graduation rate. | Daily |
Anticipated 4 Year Graduations by Term | Banner-> Advisor_TrackStudent-> ANTICIPATEDGRADTERM | Students listed in SSM-FIF with an anticipated graduation term on or before the end of their fourth year, but who are not documented as graduated in the Banner database. For FIF2014 this would be Fall 2017, Spring 2018, and Summer 2018. | Daily |
Not Expected to Graduate in 4 Years | Computed | Students listed in SSM-FIF with an anticipated graduation term after the end of the fourth year. For FIF2014 this would be Fall 2018 or after. | Daily |
Not Expected to Graduate in 4 Years % | Computed | The number of students who are not expected to graduate in 4 years as a percentage of the FIF cohort. | Daily |
Working Towards Graduation | Computed | The number of students listed in SSM-FIF with an anticipated graduation term on or before the end of their fourth year, but who are not documented as graduated in the Banner database. For FIF2014 this would be Fall 2017, Spring 2018, and Summer 2018. | Daily |
Return Status | Banner-> Advisor_TrackStudent-> ISSTUDENTNOTRETURNING | The status of students indicated as Returning, Not Returning, or Pending Review as identified by users in SSM-FIF. | Daily |
Potential Years to Graduate | Banner-> Advisor_TrackStudent-> POTENTIALYEARTOGRAD | The number of years estimated for the student to graduate, as recorded in SSM-FIF. Available selections are 3, 4, 5, 6, 7+, and Pending Review. | Daily |
Anticipated Graduation Term | Banner->Advisor_TrackStudent->ANTICIPATEDGRADTERM | The student's anticipated term for graduation as listed in SSM-FIF. This is computed based on the highest term in the DegreeWorks plan as identified by the "FIF%" header for each student. | Daily |
Certification Status | The status of certification toward the FIF requirement. Selections are:
| Daily | |
Degree Plan Available | Banner->Advisor_TrackStudent-> HASFIFGRADPLAN | Avaliable options are: Yes, No, and Pending Review No indicates the FIF plan exists in DegreeWorks but is either unlocked or inactive. Pending Review indicates that no FIF plan exists in DegreeWorks. | Daily |
Degree Awarded | Banner-> Shrdgmr | This shows a value of Yes or No based on graduation status of Awarded for Bachelor Level degrees in Banner within a 4-year window from the cohort start date. Only those students who get a degree from the same campus in which they started are being counted as a successful graduate for FIF reports. | Daily |
Student Active | Banner-> Sgbstdn-> SGBSTDN_STST_CODE | This field displays values of Yes or No based on whether the student is considered actively enrolled. The student is considered Active if he or she is enrolled in any of the latest 3 semesters. | Daily |
Student UID | SID-> SID_Enrollments-> UID | USF ID of the student. | Daily |
Last Name | SID-> SID_Person_Demo-> NAME_LAST | Last Name of student. | Daily |
First Name | SID-> SID_Person_Demo->NAME_FIRST | First Name of student. | Daily |
Hours Left to Graduate | Banner-> Advisor_TrackStudent-> HOURSLEFTTOGRADUATE | The number of hours remaining to graduate for the students in the cohort based on the selected filters. | Daily |
Current Cohort # | Computed | The number of students in the cohort based on the selected filters. | |
Students Addressed % | Computed | Students are considered addressed if they:
| |
Students Addressed Distribution: Internal vs External
| Computed | Internal vs External is the ratio of addressed students who have been in the college the whole time (internal) versus those who have changed college (external). | |
Total Records Returned | Computed | Number of records returned in the report. | |
Data Refreshed on | Date that the report data was refreshed overall. | Daily | |
Last Refreshed Date | Date that the student record was last updated. | Daily | |
Advisor Name | Banner->Sgradvr Banner->Spriden->SPRIDEN_FIRST_NAME Banner->Spriden->SPRIDEN_LAST_NAME | The advisor's first name concatenated with last name | Daily |
Advisor Type | Banner->Sgradvr->ADVR_CODE | Restricted to only Priority 1 Assigned Advisor and Priority 2 Assigned Advisor. | Daily |
Student Count | Banner->Sgradvr | Count of the number of students who have been assigned to the specific advisor. | Daily |
Student Name | SID-> SID_Person_Demo-> NAME_LAST SID-> SID_Person_Demo-> NAME_FIRST | Student's last name concatenated with first name. | Daily |
Major Change | Computed | The value (Yes or No) is based on the student's major having changed from when he or she first entered the cohort. | Daily |
Advisor Assigned Date | Banner->Sgradvr->ACTIVITY_DATE | Date when the student was most recently assigned to a particular advisor. The Advisor Assigned Date is a scroll bar in the FIF_Advisor report and captures students who have had an advisor assignment within the dates selected. | Daily |
Graduation Application Status | Banner->Shrdgmr->SHRDGMR_DEGS_CODE | A flag in the database indicating the status of the student's application for graduation. Available options are: Applied (Advisor), Applied (Student), Awarded, Denied, and None. | Daily |
Recent Major Change Date | The date of the student's most recent change of major. | Daily | |
SSM Activity Date | The last date that any of the fields in the FIF tab in SIS have been changed. | Daily | |
Advisor UID | The UID of the advisor. | Daily | |
Students with Degree Plan % | Computed | The percentage of students who have been assigned to that specific advisor who have a degree plan in DegreeWorks as identified by the "FIF%" header. | Daily |
Estimated Graduates in 4 Years % | Computed | The number of students working towards graduation in the specified time and the number of actual graduated students as a percentage of the number of students the specific advisor has been assigned. | Daily |
Graduation Application Status Date | Banner-> Shrdmgr-> SHRDGMR_APPL_DATE/ Banner-> Shrdmgr-> SHRDGMR_GRAD_DATE/ Banner-> Shrdmgr-> SHRDGMR_ACTIVITY_DATE | The date the student or advisor applied for graduation. Notes:
| Daily |
Planner Term | DegreeWorks->Dap_Plancrs_Dtl->DAP_TERM | The course term as listed on the DegreeWorks Planner. | Daily |
Registration Open | Computed | Indicates whether or not a student can register for the term based on the registration start and end dates (SFRWCTL). | Daily |
Hold | Computed | The student's concatenated list of holds from Banner. | Daily |
Degree | DegreeWorks->Dap_Plancrs_Dtl->DAP_DEGREE | The student's degree as shown on the DegreeWorks Planner. | Daily |
Planned Hours | DegreeWorks->Dap_Plancrs_Dtl->DAP_CREDITS | The total planned credit hours for the term per degree for the student as listed on the DegreeWorks Planner. | Daily |
Course Credit Hours | DegreeWorks->Rad_Class_Dtl->RAD_CREDITS | Total credit hours taken by the student for the term | Daily |
Reg Begin Date | Banner->Sfrwctl->SFRWCTL_BEGIN_DATE | First date the student is eligible to register for the term | Daily |
Reg End Date | Banner->Sfrwctl->SFRWCTL_END_DATE | Last date the student is eligible to register for the term | Daily |
Academic Standing | Banner->Shrttrm->SHRTTRM_ASTD_CODE_END_OF_TERM | Academic standing of the student as of the end-of-term | Daily |
Course Term | Banner->Shrtckn->SHRTCKN_TERM_CODE | Term when the student completed the course | Daily |
Subject | Banner->Shrtckn->SHRTCKN_SUBJECT_CODE | Subject code of the course taken | Daily |
Course Number | Banner->Shrtckn->SHRTCKN_CRSE_NUMB | Course number of the course taken | Daily |
Final Grade | Banner->Shrtckg->SHRTCKG_GRDE_CODE_FINAL | Final grade the student earned for the course | Daily |
Section Number | Banner->Shrtckn->SHRTCKN_SEQ_NO | Section number of the course taken | Daily |
Concentration1 | Banner-> Sgbstdn-> SGBSTDN_MAJR_CODE_CONC_1 | Concentration Code1 of the student's primary curriculum on the most recent enrollment | Daily |
Concentration1_2 | Banner-> Sgbstdn-> SGBSTDN_MAJR_CODE_CONC_1_2 | Concentration Code1_2 of the student's primary curriculum on the most recent enrollment | Daily |
Student Email | Banner->Goremal->GOREMAL_EMAIL_ADDRESS | Preferred email (If preference has been set by student) concatenated with usf email. Business Logic - By default every student is assigned a '@mail.usf.edu' account which is shown in the data. If students have further set a 'preffered' account then it will be pulled in as well to go along with the default '@mail.usf.edu' account. In certain cases, if the student has set their '@mail.usf.edu' account then it will be duplicated and listed for complete coverage of communication options. | Daily |