Honors College reportsThe Honors College at Honors 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, and their advisor efforts. The reports attempt to highlight the Honors College students success efforts.
...
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
...
Report Elements/Visualizations
The gauges display the overall completion percentage and the individual completion percentages.
Completion Count
Cohort Requirements Completion %/ Completion Count
Community Engagement Req Completion %
...
Tab 2: Course Requirements Details
The display on this tab provides the details on 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 the 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).
...
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).
...
Report Elements/Visualizations
Community Engagement Activities
...
Student Profile
This displays the selected student's details such as campus/college/dept/major information, demographics, and honors requirements details
Filters
-
Report Elements/Visualizations
...
Global Experience Section
Courses Section
Community Engagements Section
...
Report : Honors_Appointments ProfileGlobal Experience Detail |
|---|
The Honors Appointments Profile Global Experience Detail report showcases the details on advisor appointment trends of active students (students in the Honors College (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 timesand 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 of the types of appointments made by studentsamong the curriculum requirements, such as Foreign Language, Study Abroad, Research, or Other Experience.
Tab 1:
...
Global Experience Details
Filters
Elements/Visualizations
Non-unique Appointments by Time
Elements/Visualizations
Global Experience
...
Report : Honors_ |
|---|
...
Appointments Profile |
|---|
The Honors Appointments Profile report showcases the details on advisor effort and details of the active appointment trends of active students (Status those with status of ' H%A ' and '' H%P') grouped by their advisor. Tab 1 It provides the requirements completion percentage of all the active students of the advisor, the student id, name, email, cohort, campus,college, major, status, number of appointments they have made till date with their advisor and their latest appointment date with their advisor. Tab 2 provides details on all appointments made by the active students with any advisor. 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:
...
This provides the requirements completion percentage of all the active students of the advisor, the student id, name, email, cohort, campus,college, major, status, number of appointments they have made till date with their primary advisor and their latest appointment date with their advisor. This report can be used by leadership to understand advisor caseload and help advisor see the completion statuses of their students and appointments that they have had with them. The Checkin_Applicant table which has data starting Aug 2017 is being used in this report currently.
Filters
Report Elements /Visualizations
Community Engagement Completion %
Global Requirements Completion %
Course Requirements Completion %
Link to student profile
Tab 2: Advisor Details - All Appointments
This tab provides details on all appointments made by the active students with any advisor. It can be filtered by cohort, campus, college, department, major and primary assigned advisor. This report can be used to get the list of students who have never met with their advisor and reach out to them.
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 for the selected filters, such as a particular advisor, college, or term.
Filters
Primary Advisor Name
Report Elements /Visualizations
Report : Honors_Graduation |
|---|
This report provides graduation details of the Honors students (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 requirements. Note that the 'Graduated at USF' numbers in this report is completely different and will not match back to state and federal reported numbers for the institution. This report uses Honors cohorts which includes both FTIC and Transfers as well as Full Time and Part Time student.
Tab 1: Graduation Rate Details
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
This tab provides the 4 year and 6 year graduation trends over time. of cohorts that graduated from Honors College and of 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 cohorts which includes both FTIC and Transfers as well as Full Time and Part Time student.
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 |
|---|
This report provides details on attrition rates in honors college broken down by college and department. It provides details on how many honors courses that students complete before they leave the program, length of time taken to complete those courses and reasons for leaving the program . It includes students who have been dismissed or left the program (Status of 'H%D' and ''H%L'). It does count the 0 credits in IDH Course .This report will Advisor Caseload
Community Engagement Completion %
Global Requirements Completion %
Course Requirements Completion %
Student profile table:
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, users can select a student USFID. which can help identify students who need to be deleted from Honors College records (if they took 0 . If a student has taken no IDH courses, then they he or she should not be considered and Honors students College student at all, and will be deleted from the database, not just marked as left )
...
leaving the program.
Tab 1: Honors_Attrition
...
Filters
...
| Element | Source (System->Table->Column) | Description | Frequency of Update | ||||||
|---|---|---|---|---|---|---|---|---|---|
Cohort
| Honors_College->Student->Term | Term The term student was admitted into the Honors program as recorded in the Honors College database. | Hourly | ||||||
Campus
| SID->SID_Honors_Vw->Homecampus | Student's home campus, based on their most recent enrollment record. | Latest Benchmark | ||||||
College
| SID->SID_Honors_Vw->College_Rpt | Student's college, based on their most recent enrollment record. | Latest Benchmark | ||||||
Department
| SID->SID_Honors_Vw->dept | Student's Departmentdepartment, based on their most recent enrollment record. | Latest Benchmark | ||||||
Major
| SID->SID_Honors_Vw->Major | Identifies the students student's primary major, based on their most recent enrollment record. | Latest Benchmark | ||||||
Gender
| SID->SID_Honors_Vw->Gender | Gender of the student. | Latest Benchmark | ||||||
Ethnicity
| SID->SID_Honors_Vw->Ethnic | Race/Ethnicity of personthe student. | Latest Benchmark | ||||||
Student Admission Type
| SID->Student->Status | This uses the 2nd letter in of the 4-letter code in the status column of the Student student table. The 'A 2 ' indicates 2-year/Continuing USF or Transfer, and 'a 4 ' indicates 4-year/Admitted as FTIC. | Hourly | ||||||
Student Type
| SID->SID_Honors_Vw->StudentType | Identifies students as graduate, undergraduate, or non-degree. | Latest Benchmark | ||||||
Total Count
| Computed (Honors_College->Student->Status) | This is the count of all active Honors College Students (students. It is calculated by counting all students in thew the student table with the status of H%A and or H%P). | Hourly | ||||||
Cohort Requirements Completion %
| Computed | This The cohort requirements completion % is calculated as met if the community engagement, global requirement abnd , and course requirement are met. | Hourly | ||||||
Community Engagement Completion %
| Computed | This The Community Engagement requirement is counted as met if the student has a record with the status of Accepted in the CommunityEngagement table. | 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 | ||||||
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 | ||||||
Course Requirement Status
| Honors_College->AcademicCompletion->PStatus | Status Indicates the status of the Course Requirement - as Accepted/, Denied/, or Unprocessed. | Hourly | ||||||
Global Experience Status
| Honors_College->Global_Exp->Status | Status Indicates the status of the specific Global Experience - as Accepted/, Denied/, or Pending. | Hourly | ||||||
USFID
| SID->SID_Honors_Vw->uid | Student U University Identification number. | Hourly | ||||||
Name
| Honors_College->Student->LastName Honors_College->Student->FirstName | Student name concatenated with First Name and Last Name from the database. | Hourly | ||||||
Course Count
| SID->SID_Honors_Courses_Vw (Count of courses completed by the student) | Number Count of the number of Honors College courses that the student has completed. | Latest Benchmark | ||||||
Global Experience Activities
| Honors_College->Global_Exp (Calculated) | Number Count of the number of Global Experience Activities submitted by the student. | Hourly | ||||||
Global Experience Accepted
| Honors_College->Global_Exp->Status (Count of Accepted Status) | Number Count of the number of Global Experience Activities that were accepted. | Hourly | ||||||
| Honors_College->CommunityEngagement (Calculated) | Number Count of the number of Community Engagement Activities submitted by the student. | Hourly | ||||||
Community Engagements Accepted
| Honors_College->CommunityEngagement->Status (Count of Accepted Status) | Number Count of the number of Community Engagement Activities that were accepted. | Hourly | ||||||
Experience Type
| Honors_College->Global_Exp->ExpType | Type of Global Experience -. The types are:
| Hourly | ||||||
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 | ||||||
| Student Email | Honors_College->Student->EMail | EMail Email address of the student. | Hourly | ||||||
URL
| Honors_College->Global_Exp->SA_URL | URL of the global activity. | Hourly | ||||||
Experience Status
| Honors_College->Global_Exp->Status | Status Indicates the status of the Global Experience - as Accepted/, Denied/, or Pending. | Hourly | ||||||
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 | ||||||
Term
| SID->SID_Honors_Courses_Vw->termid | Term that the course was taken (Banner). | Latest Benchmark | ||||||
Grade Awarded
| SID->SID_Honors_Courses_Vw->GRADE_AWARDED | Grade obtained by the student in the course (Banner). | Latest Benchmark | ||||||
Submitted Date
| Honors_College->CommunityEngagement->SubmitDate | Date of submission of the Community Engagement form. | Hourly | ||||||
Community Engagement Status
| Honors_College->CommunityEngagement->Status | Status Indicates the status of the Community Engagement as Accepted/, Denied/, or Pending. | Hourly | ||||||
Date
| System calendercalendar | Date range can be picked using the calendar in the filter. | |||||||
Day of the Week
| Weekdays (M,T,W,Th,F) | ||||||||
Time of Day
| Time from 7 am-5pm5 pm. | ||||||||
Total Appointments
| Honors_College->Checkin_Applicant-> | Count of total student appointments (non-unique) at Honors Collegeappointments (non-unique) at Honors College. Non-unique means that the count can include appointments that fit more than one category, topic, or type. | Hourly | ||||||
| Honors_College->Checkin_Applicant (Calculated) | Count of total unique student appointments at Honors College. | Hourly | ||||||
| Honors_College->Checkin_Applicant->TimeIn Honors_College->Checkin_Applicant->TimeSeen (Calculated) | Average Indicates the average waiting time for students after checking in for meeting advisorstheir advisor appointment. | Hourly | ||||||
| Honors_College->Checkin_Applicant->Advisor and Honors_College->-All_Admin->Name (Calculated) | List of Advisors along advisors with the number of appointments (not unique) handled by each one of them. | Hourly | ||||||
Non-Unique Appointments by Time
| Honors_College->Checkin_Applicant->AppointmentDate (Calculated) | Count of non-unique appointments during every by hour of the day. | Hourly | ||||||
| Honors_College-AUINote->ApptCategory | Count of appointments by category. They include AP, , which can include Appointment, EM, Email, Group, Group Advising, PHPhone, Phone Walk in and WIand Walk In. | Hourly | ||||||
Appointment Topic
| Honors_College-AUINote->ApptCategory | Count of appointments by category. All categories, except those included in Appointment Type, are used displayed here. | Hourly | ||||||
Advisor Caseload
| Honors_College->Student | This The advisor caseload is the count of students assigned to an advisor. | Hourly | ||||||
Advisor Name
| Honors_College->All_Admin->Name | This is Indicates the primary advisor assigned to the student. | Hourly | ||||||
Advisor Seen
| THis Advisor Seen is the name of the advisor seen at the time of the appointment, which may be different from their "assigned" the student's assigned advisor. | Hourly | |||||||
Status
| Honors_College->Student->Status | This is the The 4-letter code that indicates 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 | ||||||
Latest Appointment
| Computed | This is the latest/most recent appointment made by the student with his /or her advisor. | |||||||
Total Count | Computed (Honors_College->Student->Status) | This includes all Honors College students (Honors Status - H*). | Hourly | ||||||
Graduated @Honors | Computed (Honors_College->Student->Status) | This includes students who graduated from the Honors College (Honors Status - H%G). | Hourly | ||||||
Dismissed | Computed (Honors_College->Student->Status) | This includes students who were dismissed from the Honors program Program (Honors Status - H%D). | Hourly | ||||||
Left Honors College | Computed (Honors_College->Student->Status) | This includes students who left the Honors program Program (Honors Status - H%L). | 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 or not. | Latest Benchmark | ||||||
Left USF | Computed | This includes students who were a part of the Honors Program but left USF without a degree. | Latest Benchmark | ||||||
Active Student @USF
| Computed dbo.SID_Honors_ActiveDegreeStudents_Vw->studentstatus ='Active' | This includes students who were a part of the Honors program 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 | ||||||
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 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 or not. | 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 or not. | Latest Benchmark | ||||||
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 more greater than 6 years. | Hourly | ||||||
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 or not. | Latest Benchmark | ||||||
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 college and Departmentdepartment. | 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 ) for 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 | ||||||
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 )is Honors Program, calculated and grouped under course count. | Latest Benchmark | ||||||
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 | ||||||
Date Refreshed on
| Date that the report data was refreshed overall. |
...