Honors College reports
The Honors College reports below showcase the requirements completion of their students, appointment trends and advisor effort. It strives to help with their student success efforts.
Report Elements Glossary Table
Report : Honors_Completion Summary |
---|
This report provides a summary of overall status of the active students (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.
Tab 1: Requirements Completion Summary
This tab display the overall completion percentage and the individual completion percentages. The 'view detail' link under the main gauge can be used to look at the details of the students.
Filters
Report Elements/Visualizations
The gauges display the overall completion percentage and the individual completion percentages.
Cohort Requirements Completion %/ Completion Count
Community Engagement Completion %
Global Requirements Completion %
Course Requirements Completion %
Tab 2: Course Requirements Detail
This tab provides the details on the count and percentage of all active students (Status of 'H%A' and ''H%P') completing their course requirement. The course requirement is met by taking 4 honors courses . The research track comprises of 'Honors Thesis', 'Honor Capstone', 'Engineering Capstone' and 'Departmental Thesis' . This tab provides the completion details (Accepted, Denied or Unprocessed) broken down by 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 Detail
This tab provides the details on what global activities the active students (Status of 'H%A' and ''H%P') are doing as part of fulfilling the requirements. The students have to complete 2 global activities to satisfy this requirement, This tab displays the counts of the students in each of the seven different activity types and the completion status within each type. The 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 |
---|
This report provides a detailed view of the Honors active students (Status of 'H%A' and ''H%P'). The report can be drilled through to the individual student to see their campus/college/dept/major information, demographics and honors requirements details (Student Profile report)
Tab 1: Student Detail
Filters
Report Elements/Visualizations
Community Engagement Activities
Community Engagements Accepted
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 Profile |
---|
This report provides details on appointment trends of active students (Status of 'H%A' and ''H%P'). This report can be used to understand the total and unique appointments handled at the Honors College during the selected time range, appointment load of advisors, average wait time of students, slow-busy days/times and the distribution of the types of appointments made by students.
Tab 1: Appointments Profile
Filters
Elements/Visualizations
Top 5 Advisors by Appointments
Non-unique appointments by Time
Report : Honors_Advisor Detail |
---|
This report provides details on advisor effort and details of the active students (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.
Tab 1: Advisor Detail
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. 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.
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.
Filters
Report Elements /Visualizations
Community Engagement Completion %
Global Requirements Completion %
Course Requirements Completion %
Link to student profile
Report : Honors_Graduation |
---|
This report provides graduation details of the Honors students (Status of 'H%')
Tab 1: Honors_Graduation
Filters
Report Elements/Visualizations
Report : Honors_Attrition |
---|
This report provides details on honors students who leave the program.
Tab 1: Honors_Attrition
Filters
Report Elements/Visualizations
Course Completion Time
Number of Courses
Reason for Leaving
The table below lists all the elements used in the Reports.
Element | Source (System->Table->Column) | Description | Frequency of Update |
---|---|---|---|
Cohort | Honors->Student->Term | Term student was admitted | Hourly |
Campus | SID->SID_Honors_Vw->Homecampus | Student's home campus | Latest Benchmark |
College | SID->SID_Honors_Vw->College_Rpt | Student's college | Latest Benchmark |
Department | SID->SID_Honors_Vw->dept | Student's Department | Latest Benchmark |
Major | SID->SID_Honors_Vw->Major | Identifies the students primary major | Latest Benchmark |
Gender | SID->SID_Honors_Vw->Gender | Gender | Latest Benchmark |
Ethnicity | SID->SID_Honors_Vw->Ethnic | Race/Ethnicity of person | Latest Benchmark |
Student Admission Type | SID->Student->Status | This uses the 2nd letter in the 4 letter code in the status column of the Student table. The '2' indicates 2 year/Continuing USF or Transfer and '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 (It is calculated by counting all students in thew student table with the status of H%A and H%P) | Hourly |
Cohort Requirements Completion % | Computed | This is calculated as met if the community engagement, global requirement abnd course requirement are met. | Hourly |
Community Engagement Completion % | Computed | This 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 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 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 of the Course Requirement- Accepted/Denied/Unprocessed | Hourly |
Global Experience Status | Honors_College->Global_Exp->Status | Status of the specific Global Experience- Accepted/Denied/Pending | Hourly |
USFID | SID->SID_Honors_Vw->uid | Hourly | |
Name | Honors_College->Student->LastName Honors_College->Student->FirstName | Student Name | Hourly |
Course Count | SID->SID_Honors_Courses_Vw (Count of courses completed by the student) | Number of Honors courses that the student has completed. | Hourly |
Global Experience Activities | Honors_College->Global_Exp (Calculated) | Number of Global Experience Activities submitted by the student | Hourly |
Global Experience Accepted | Honors_College->Global_Exp->Status (Count of Accepted Status) | Number of Global Experience Activities that were accepted | Hourly |
| Honors_College->CommunityEngagement (Calculated) | Number of Community Engagement Activities submitted by the student | Hourly |
Community Engagements Accepted | Honors_College->CommunityEngagement->Status (Count of Accepted Status) | Number of Community Engagement Activities that were accepted | Hourly |
Experience Type | Honors_College->Global_Exp->ExpType | Type of Global Experience- The types are FL (Foreign Language) , HI (Honors International Day), IN (Internship), MI (Minor or Certificate), OT (Other Experience) , RE (Research) and SA (Study Abroad) | 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 | Hourly |
Student Email | Honors_College->Student->EMail | EMail of the student | |
URL | Honors_College->Global_Exp->SA_URL | URL of the global activity | Hourly |
Experience Status | Honors_College->Global_Exp->Status | Status of the Experience- Accepted/Denied/Pending | Hourly |
Course ID | SID->SID_Honors_Courses_Vw->CourseInfo | ID of the Course from Banner | Hourly |
Course Name | SID->SID_Honors_Courses_Vw->Course_Title | Name of the Course from Banner | Hourly |
Term | SID->SID_Honors_Courses_Vw->termid | Term that the course was taken (Banner) | Hourly |
Grade Awarded | SID->SID_Honors_Courses_Vw->GRADE_AWARDED | Grade obtained by the student in the course (Banner) | Hourly |
Submitted Date | Honors_College->CommunityEngagement->SubmitDate | Date of submission of the Community Engagement form | Hourly |
Community Engagement Status | Honors_College->CommunityEngagement->Status | Status of the Community Engagement Accepted/Denied/Pending | Hourly |
Date | System calender | 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-5pm | ||
Total Appointments | Honors_College->Checkin_Applicant-> | Count of total student appointments (non unique) at Honors College | 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 waiting time for students after checking in for meeting advisors | Hourly |
| Honors_College->Checkin_Applicant->Advisor and Honors_College->-All_Admin->Name (Calculated) | List of Advisors along 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 hour of the day | Hourly |
| Honors_College-AUINote->ApptCategory | Count of appointments by category. They include AP, Appointment, EM, Email, Group, Group Advising, PH,Phone Walk in and WI | Hourly |
Appointment Topic | Honors_College-AUINote->ApptCategory | Count of appointments by category. All categories except those included in Appointment Type are used here. | Hourly |
Advisor Caseload | Honors_College->Student | This is the count of students assigned to an advisor | |
Advisor Name | Honors_College->All_Admin->Name | ||
Status | Honors_College->Student->Status | This is the 4 letter code that indicates the status of the student Student Type | |
Latest Appointment | This is the latest/most recent appointment made by the student with his/her advisor | ||
Date Refreshed on | Date that the report data was refreshed overall. |