Honors College Reports
- Sunitha Balasubramanian (Deactivated)
- Lise Venning
- Jayakumar Unnikrishnan
College reports
The Honors College at USF provides transformative educational opportunities that prepare highly motivated, intellectually curious, service-oriented, and academically accomplished students to become active and engaged thought leaders. The BIA creates a series of reports, shown below, that showcase the requirements of these students, their appointment trends, their graduation rates, and their advisors' efforts. These reports highlight the success of the Honors College at USF.
Report : Honors_Completion Summary |
|---|
The Honors Completion Summary report provides a summary of the overall status of the active students (those with status of H%A and H%P) as to where they stand in terms of requirements completion. It also provides the individual breakdown of the requirements. The breakdowns include community engagement completion, global requirements completion, and course requirement completion. This report displays data in three tabs: Completion Summary, Course Requirements Details, and Global Experience Details.
Tab 1: Completion Summary
The display on this tab shows the overall completion percentage and the individual completion percentages. Users can click the "View Detail" link under the main gauge to view details of the students in the selected cohort. This view opens in a separate browser tab.
Filters
USFID (filter is available when the View Detail tab is open)
Report Elements/Visualizations
The gauges display the overall completion percentage and the individual completion percentages.
Cohort Requirements Completion %/ Completion Count
Community Engagement Req Completion %
Global Requirements Completion %
Course Requirements Completion %
Tab 2: Course Requirements Details
The display on this tab provides the details for the count and percentage of all active students (those with status of H%A and H%P) in completing their course requirements. The course requirements are met by taking four (4) honors courses. The research track comprises the Honors Thesis, Honor Capstone, Engineering Capstone, and Departmental Thesis tracks. The visualization provides the completion details (Accepted, Denied, Pending, or Unavailable) along with the totals for each of the tracks.
Filters
Report Elements/Visualizations
The visualization provides total counts of students in each track and the counts of the completion status within each track.
Tab 3: Global Experience Details
The display on this tab provides details on what global activities the active students (those with status of H%A and H%P) are doing as part of fulfilling the requirements. The students have to complete two (2) global activities to satisfy this requirement. The visualization displays the counts of the students in each of the seven different activity types and the completion status within each type. The activity types are FL (Foreign Language) , HI (Honors International Day), IN (Internship), MI (Minor or Certificate), OT (Other Experience) , RE (Research), and SA (Study Abroad).
Filters
Report Elements/Visualizations
Report : Honors_Student Detail |
|---|
The Honors Student Detail report provides a detailed view of the active Honors students (those with status of H%A and H%P). The table lists students by USF ID with a count of their activities toward the Honors College curriculum requirements for Community Engagement, Global Experience, and Courses taken.
Tab 1: Student Detail
Filters
Report Elements/Visualizations
Community Engagement Activities
Community Engagements Accepted
Report : Honors_Global Experience Detail |
|---|
The Honors Global Experience Detail report showcases the students in the Honors College (those with status of H%A and H%P) and their coursework taken toward fulfilling the Global Experience requirement. The display shows the total number of students, based on the selected filters, and the distribution among the curriculum requirements, such as Foreign Language, Study Abroad, Research, or Other Experience.
Tab 1: Global Experience Details
Filters
Elements/Visualizations
Global Experience
Report : Honors_Appointments Profile |
|---|
The Honors Appointments Profile report showcases the details on advisor appointment trends of active students (those with status of H%A and H%P). This report can be used to understand the total appointments and unique (distinct) appointments handled at the Honors College during the selected time range, appointment load of advisors, average wait time of students, slow and busy days and times, and the distribution of the types of appointments made by students.
Tab 1: Appointments Profile
Filters
Elements/Visualizations
Non-Unique Appointments by Time
Report : Honors_Advisor Detail |
|---|
The Honors Advisor Detail report shows the advisor efforts and details in working with active Honors College students (those with status of H%A and H%P). The report displays in two tabs. Tab 1, Advisor Details, shows the requirements completion percentage of all the advisors' active students. Tab 2, Advisor Details-All Appointments provides details on all appointments made by the active students with any advisor.
Tab 1: Advisor Detail
The Advisor Detail tab displays a dashboard with metrics on advisor appointments for active Honors College students. The displays can be filtered using the fields at the top of the display to show details by cohort, campus, college, department, and student major.
The top visual in the dashboard shows the progress of the advisors' students in fulfilling the course requirements of Community Engagement, Global Requirements, and Course Requirements. The visuals include the percentage completion as well as a count of students who have completed the requirement. Overall completion of all requirements display in the Advised Students Completion % progress chart.
The bottom visual in the dashboard shows the Advisor Caseload by academic term in bar charts. Each of the term visuals can be drilled down; that is, by clicking the down arrows in the visual 
, you can view how appointments are distributed among advisors over the terms shown. Further, if you select a specific term, such as Fall 2019, you can drill down to see how appointments are distributed among advisors for that particular term. Note that the progress charts above adjust to show data for the selected term. Click the up arrow to return to the full display.
The Student Profile table at the bottom of this report lists the students matching the selected filters, such as a particular advisor, college, or term. Click the link icon in the table to view a full profile of the student.
Filters
Report Elements /Visualizations
Community Engagement Completion %
Global Requirements Completion %
Course Requirements Completion %
Student profile table:
Student Profile
You can view the full details of a student by clicking the link icon 
in the Student Profile table at the bottom of the Honors_Advisor screen. The profile opens in a new browser tab and displays information for the selected student to include campus/college/dept/major information, demographics, and honors requirements for courses, global experience, and community engagement.
Filters
-
Report Elements/Visualizations
Global Experience Section
Courses Section
Community Engagements Section
Tab 2: Advisor Details - All Appointments
The Advisor Details-All Appointments tab has a table listing the students in the Honors College with their advisor appointments. Details in the table include student name, email, college major, status, primary advisor, and advisor appointment date(s). This report can be used by leadership to understand advisor caseload and can help advisors view their students' appointment history.
Filters
Report Elements /Visualizations
Report : Honors_Graduation |
|---|
The Honors Graduation report provides graduation details of the Honors College students (those with a status of H%). It provides 4-year, 6-year, and greater than 6-year graduation rates for the cohorts graduating with the honors degree, as well as for those who started at Honors College but graduated from USF without completing the Honors College requirements. Note that the "Graduated at USF" numbers in this report are completely different and will not match numbers reported by the institution for state and federal reporting. This report uses Honors College cohorts, which include FTIC and transfer students, both full-time and part-time.
The report displays in two tabs: Graduation Rate Details and Graduation Rate Trends.
Tab 1: Graduation Rate Details
The display on this tab, Graduation Rate Details, shows a dashboard of with graduation rates of students by cohort who started with the Honors College curriculum. The metrics provide a total count of students in the cohort and show the numbers of students who have graduated at the Honors College and those who have graduated at USF but not in the Honors College. The remaining students in the cohort are counted as either leaving USF or remain active students.
Filters
Report Elements/Visualizations
Cohort Graduated at Honors College 4 year rate
Cohort Graduated at Honors college 6 year rate
Cohort Graduated at Honors college >6 year rate
Cohort Graduated at USF 4 year rate
Cohort Graduated at USF 6 year rate
Cohort Graduated at USF >6 year rate
Tab 2: Graduation Rate Trends
The display on this tab, Graduation Rate Trends, provides the 4-year and 6-year graduation rate trends over time for cohorts that graduated from Honors College and for cohorts that graduated from USF (including all that started at Honors College irrespective of whether they completed the requirements or not). Note that the 6-year graduation rate trends will not match back to state and federal reported numbers for the institution. This report uses Honors College cohorts, which include FTIC and transfer students, both full-time and part-time.
Filters
Elements/Visualizations
Cohort Graduated at Honors College 4-year Rate
Cohort Graduated at Honors College 6-year Rate
Cohort Graduated at USF 4-year Rate
Cohort Graduated at USF 6-year Rate
Report : Honors_Attrition |
|---|
The Honors Attrition report provides details on attrition rates in the Honors College broken down by college and department. It provides details on how many honors courses that students complete before they leave the program, the length of time taken to complete those courses, and the reasons for leaving the program. It includes students who have been dismissed or left the program (those with status of H%D and H%L). It does count students with 0 credits in IDH courses.
There are three visuals and a table on this page that can provide insight into students who have left the Honors College:
- Attrition Breakdown shows the attrition by college. You can select the down arrow in the visual to drill down to department and major. Additionally, you can select a bar in the visual, e.g., Business, and the other charts adjust to show data for that area of study. Select the bar again to return to the full display.
- Student # by Courses Taken shows the count of students by the number of courses they have taken in the Honors College curriculum. You can select a bar slice in the display to adjust the other visuals in the report.
- Length of Time Taking Courses is a pie chart showing the length of time taken to complete the courses taken.
- Reason for Leaving is a table showing comments from students who have left the program stating their reasons for leaving the program.
In the filter to the left, you can select a student USFID. which can help identify students who need to be deleted from Honors College records. If a student has taken no IDH courses, then he or she should not be considered an Honors College student at all, and can be deleted from the database, not just marked as leaving the program.
Tab 1: Honors_Attrition
Filters
Report Elements/Visualizations
Student Count by Courses Taken
Report Elements Glossary
The table below lists all the elements used in the reports.
| Element | Source (System->Table->Column) | Description | Frequency of Update |
|---|---|---|---|
Active Student @USF | Computed dbo.SID_Honors_ActiveDegreeStudents_Vw->studentstatus ='Active' | This includes students who were a part of the Honors Program but have not graduated, may still be in the honors program. or left/were dismissed from honors. This is a list of students who are currently enrolled in some program at USF. | Latest Benchmark |
Advisor Caseload | Honors_College->Student | The advisor caseload is the count of students assigned to an advisor. | Hourly |
| Advisor Name | Honors_College->All_Admin->Name | Indicates the primary advisor assigned to the student. | Hourly |
| Advisor Seen | Advisor Seen is the name of the advisor seen at the time of the appointment, which may be different from the student's assigned advisor. | Hourly | |
Advisors by Appointments # | Honors_College->Checkin_Applicant->Advisor and Honors_College->-All_Admin->Name (Calculated) | List of advisors with the number of appointments (not unique) handled by each one. | Hourly |
Appointment Topic | Honors_College-AUINote->ApptCategory | Count of appointments by category. All categories, except those included in Appointment Type, are displayed here. | Hourly |
| Honors_College-AUINote->ApptCategory | Count of appointments by category, which can include Appointment, EM, Email, Group, Group Advising, Phone, and Walk In. | Hourly |
Attrition Breakdown | Computed SID->SID_Honors_Vw->College_Rpt ((Students who left+students who were dismmised)/(All Students who were a part of the Honors Program in the Honors program))*100 | This provides the attrition percentage of Honors College students broken down by college and department. | Latest Benchmark |
Average Wait Time | Honors_College->Checkin_Applicant->TimeIn Honors_College->Checkin_Applicant->TimeSeen (Calculated) | Indicates the average waiting time for students after checking in for their advisor appointment. | Hourly |
Campus | SID->SID_Honors_Vw->Homecampus | Student's home campus, based on their most recent enrollment record. | Latest Benchmark |
Cohort | Honors_College->Student->Term | The term student was admitted into the Honors program as recorded in the Honors College database. | Hourly |
Cohort graduated at honors college 4 year rate | Computed(Graduated @Honors/ Total Count)*100 and using the graduation SID_Honors_ActiveDegreeStudents_Vw->DegreeTerm SID_Honors_ActiveDegreeStudents_Vw->studentstatus ='Degree' | This includes the cohort that graduated from Honors College within 4 years. | Hourly |
Cohort graduated at honors college 6 year rate | Computed (Graduated @Honors/ Total Count)*100 SID_Honors_ActiveDegreeStudents_Vw->DegreeTerm SID_Honors_ActiveDegreeStudents_Vw->studentstatus ='Degree' | This includes the cohort that graduated from Honors College within 6 years. | Hourly |
Cohort graduated at honors college > 6 year rate | Computed(Graduated @Honors/ Total Count)*100 and using the graduation SID_Honors_ActiveDegreeStudents_Vw->DegreeTerm SID_Honors_ActiveDegreeStudents_Vw->studentstatus ='Degree' | This includes the cohort that graduated from Honors College in greater than 6 years. | Hourly |
Cohort graduated at USF 4 year rate | Computed (Graduated@USF/ Total Count)*100 SID_Honors_ActiveDegreeStudents_Vw->DegreeTerm SID_Honors_ActiveDegreeStudents_Vw->studentstatus ='Degree' | This includes students who were a part of the Honors Program and graduated from USF within 4 years, irrespective of whether they completed the requirements. | Latest Benchmark |
| Cohort graduated at USF 6 year rate | Computed (Graduated@USF/ Total Count)*100 SID_Honors_ActiveDegreeStudents_Vw->DegreeTerm SID_Honors_ActiveDegreeStudents_Vw->studentstatus ='Degree' | This includes students who were a part of the Honors Program and graduated from USF within 6 years, irrespective of whether they completed the requirements. | Latest Benchmark |
Cohort graduated at USF > 6 year rate | Computed (Graduated@USF/ Total Count)*100 SID_Honors_ActiveDegreeStudents_Vw->DegreeTerm SID_Honors_ActiveDegreeStudents_Vw->studentstatus ='Degree' | This includes students who were a part of the Honors Program and graduated from USF in greater than 6 years, irrespective of whether they completed the requirements. | Latest Benchmark |
Cohort Requirements Completion % | Computed | The cohort requirements completion % is calculated as met if the community engagement, global requirement, and course requirement are met. | Hourly |
Cohort Type | Honors_College->Student->Term | Indicates the term of the cohort, Fall, Spring, Summer | Hourly |
College | SID->SID_Honors_Vw->College_Rpt | Student's college, based on their most recent enrollment record. | Latest Benchmark |
Community Engagements Accepted | Honors_College->CommunityEngagement->Status (Count of Accepted Status) | Count of the number of Community Engagement Activities that were accepted. | Hourly |
Community Engagement Completion % | Computed | The Community Engagement requirement is counted as met if the student has a record with the status of Accepted in the CommunityEngagement table. | Hourly |
Completion Count | Computed | The count of all active Honors College students who have completed all of the program requirements (Community Engagement, Global, and Course requirements). | |
Course Count | SID->SID_Honors_Courses_Vw (Count of courses completed by the student) | Count of the number of Honors College courses that the student has completed. | Latest Benchmark |
Course ID | SID->SID_Honors_Courses_Vw->CourseInfo | ID of the Course from Banner. | Latest Benchmark |
Course Name | SID->SID_Honors_Courses_Vw->Course_Title | Name of the Course from Banner. | Latest Benchmark |
Community Engagement Activities | Honors_College->CommunityEngagement (Calculated) | Count of the number of Community Engagement Activities submitted by the student. | Hourly |
Community Engagement Status | Honors_College->CommunityEngagement->Status | Indicates the status of the Community Engagement as Accepted, Denied, or Pending. | Hourly |
Course Requirement Status | Honors_College->AcademicCompletion->PStatus | Indicates the status of the Course Requirement as Accepted, Denied, or Unavailable. | Hourly |
Course Requirements Completion % | Computed | The Course requirement is counted as met if the latest record of the student (Max Decision Date) has the status of Accepted in the AcademicCompletion table. | Hourly |
Date | System calendar | Date range can be picked using the calendar in the filter. | |
Date Refreshed on | Indicates the date the data was refreshed. This date displays on the bottom right of each report. | ||
Day of the Week | Indicates the day of the week (Monday through Friday) that the appointments took place. | ||
Department | SID->SID_Honors_Vw->dept | Student's department, based on their most recent enrollment record. | Latest Benchmark |
Dismissed | Computed (Honors_College->Student->Status) | This includes students who were dismissed from the Honors Program (Honors Status - H%D). | Hourly |
Ethnicity | SID->SID_Honors_Vw->Ethnic | Race/Ethnicity of the student. | Latest Benchmark |
Experience Description | Honors_College->Global_Exp-> [FL_Language],[FL_LangType],[SA_Program],[SA_Duration] ,[SA_Courses] ,[SA_URL] ,[SA_Faculty] ,[SA_Email] ,[HI_Date] ,[IN_Company] ,{IN_Supervisor] [,[N_Email] ,IN_Activity] ,[IN_Duration] ,[IN_Focus] , ,[RE_Department] ,[RE_Faculty] ,[RE_Email] ,[RE_Activity] ,[RE_Focus] ,[MI_Program] | Description of the Global Experience type. | Hourly |
Experience Status | Honors_College->Global_Exp->Status | Indicates the status of the Global Experience as Accepted, Denied, or Pending. | Hourly |
Experience Type | Honors_College->Global_Exp->ExpType | Type of Global Experience. The types are:
| Hourly |
Gender | SID->SID_Honors_Vw->Gender | Gender of the student. | Latest Benchmark |
Global Experience Accepted | Honors_College->Global_Exp->Status (Count of Accepted Status) | Count of the number of Global Experience Activities that were accepted. | Hourly |
Global Experience Activities | Honors_College->Global_Exp (Calculated) | Count of the number of Global Experience Activities submitted by the student. | Hourly |
Global Experience Status | Honors_College->Global_Exp->Status | Indicates the status of the specific Global Experience as Accepted, Denied, or Pending. | Hourly |
Global Requirements Completion % | Computed | The Global requirement is counted as met if the student has at least 2 records with the status of Accepted in the Global_Exp table | Hourly |
Grade Awarded | SID->SID_Honors_Courses_Vw->GRADE_AWARDED | Grade obtained by the student in the course (Banner). | Latest Benchmark |
Graduated @Honors | Computed (Honors_College->Student->Status) | This includes students who graduated from the Honors College (Honors Status - H%G). | Hourly |
Graduated@USF | Computed dbo.SID_Honors_ActiveDegreeStudents_Vw->studentstatus ='Degree' | This includes students who were a part of the Honors Program and graduated from USF, irrespective of whether they completed the requirements. | Latest Benchmark |
Latest Appointment | Computed | This is the latest/most recent appointment made by the student with his or her advisor. | |
Left Honors College | Computed (Honors_College->Student->Status) | This includes students who left the Honors Program (Honors Status - H%L). | Hourly |
Left USF | Computed | This includes students who were a part of the Honors Program but left USF without a degree. | Latest Benchmark |
Length of Time Taken Courses | Computed SID ->SID_Honors_Courses_Vw->termid | This provides the time taken (in years) by the students who left or were dismissed from the Honors Program in completing the honors courses before they left. This is computed by calculating the time between their first IDH course and last IDH course. Each term is considered as a third of a year. | Latest Benchmark |
Major | SID->SID_Honors_Vw->Major | Identifies the student's primary major, based on their most recent enrollment record. | Latest Benchmark |
Name | Honors_College->Student->LastName Honors_College->Student->FirstName | Student name concatenated with First Name and Last Name from the database. | Hourly |
Non-Unique Appointments by Time | Honors_College->Checkin_Applicant->AppointmentDate (Calculated) | Count of non-unique appointments during by hour of the day. | Hourly |
Reason for Leaving | Computed Honors_College ->Exit ->ReasonCodes | Students can pick one or more of the 7 reasons for leaving this program in the exit form when leaving the Honors College program:
| Latest Benchmark |
Status | Honors_College->Student->Status | The 4-letter code indicating the status of the student. The Status is represented by four codes:
H - Honors College
2 - 2 year/Continuing USF or Transfer Admit
N - None
A - Active | Hourly |
Student Admission Type | SID->Student->Status | This uses the 2nd letter of the 4-letter Status code in the status column of the student table. A 2 indicates 2-year/Continuing USF or Transfer, and a 4 indicates 4-year/Admitted as FTIC. | Hourly |
Student Count by Courses Taken | Computed SID ->SID_Honors_Courses_Vw->CourseInfo | The number of Honors Program classes taken by the students who left or were dismissed from the Honors Program, calculated and grouped under course count. | Latest Benchmark |
Student Email | Honors_College->Student->EMail | Email address of the student. | Hourly |
Student Type | SID->SID_Honors_Vw->StudentType | Identifies students as graduate, undergraduate, or non-degree. | Latest Benchmark |
Submitted Date | Honors_College->CommunityEngagement->SubmitDate | Date of submission of the Community Engagement form. | Hourly |
Term | SID->SID_Honors_Courses_Vw->termid | Term that the course was taken (Banner). | Latest Benchmark |
Time of Day | Time of appointment broken down by hour to see the concentration of advisor appointments. | ||
Total Appointments | Honors_College->Checkin_Applicant-> | Count of total student appointments (non-unique) at Honors College. Non-unique means that the count can include appointments that fit more than one category, topic, or type. | Hourly |
Total Count | Computed (Honors_College->Student->Status) | The count of all active Honors College students. It is calculated by counting all students in the student table with the status of H%A or H%P. | Hourly |
Unique Appointments | Honors_College->Checkin_Applicant (Calculated) | Count of total unique student appointments at Honors College. | Hourly |
URL | Honors_College->Global_Exp->SA_URL | URL of the global activity. | Hourly |
USFID | SID->SID_Honors_Vw->uid | Student University Identification number. | Hourly |