Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Honors College reports

...

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 

Cohort

Campus

College

...

Student Admission Type

Student Type

Report Elements/Visualizations

The gauges display the overall completion percentage and the individual completion percentages. 

Total Count

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 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 

Cohort

Campus

College

...

Student Admission Type

Student Type

Report Elements/Visualizations

The visualization provides total counts of students in each track and the counts of the completion status within each track.

...

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).

...

Student Admission Type

Student Type

 

...


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

...

Student Admission Type

Student Type

Report Elements/Visualizations

USF ID

Name

Student Email

Community Engagement Activities

...

Global Experience Accepted

Course Count

Course Status

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

USFID

Name

Campus

College

Department

Major

Gender

Ethnicity

Student Level

Student Admission Type

Student Type

Admit Term

Recent Enrolled Term

Global Experience Section

Experience Type

Experience Description

URL

Experience Status

Courses Section

Course ID

Course Name

Term

Grade Awarded

Community Engagements Section

Submitted Date

Community Engagement Status

 

...

 

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 

Cohort

Campus

College

Department

...

Tab 1: Appointments Profile

Filters 

Date

Day of Week

Time of Day

...

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 

Cohortthe 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 

Cohort

Campus

College

Department

Major

Advisor Name

Report Elements /Visualizations

Advisor Caseload

Advised Students Completion %

Community Engagement Completion %

Global Requirements Completion %

Course Requirements Completion %

Student profile table:

USF ID

Name

Student Email

Cohort

Campus

College

Major

Status

# Appointments

Latest Appointment

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

USFID

Name

Campus

College

Department

Major

Advisor Name

Report Elements /Visualizations

Advisor Caseload

Advised Students Completion %

Community Engagement Completion %

Global Requirements Completion %

Course Requirements Completion %

Student profile table:

USF ID

Name

Student Email

Cohort

Campus

College

Major

Status

# Appointments

Latest AppointmentGender

Ethnicity

Student Level

Student Admission Type

Student Type

Admit Term

Recent Enrolled Term

Global Experience Section

Experience Type

Experience Description

URL

Experience Status

Courses Section

Course ID

Course Name

Term

Grade Awarded

Community Engagements Section

Submitted Date

Community Engagement Status


Tab 2: Advisor Details - All Appointments

...

Element

Source

(System->Table->Column)

DescriptionFrequency of Update

Active Student @USF

Anchor
Active Student at USF
Active Student at 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

Anchor
Advisor Caseload
Advisor Caseload

Honors_College->StudentThe advisor caseload is the count of students assigned to an advisor.Hourly
Advisor Name
Anchor
Advisor Name
Advisor Name
Honors_College->All_Admin->NameIndicates the primary advisor assigned to the student.Hourly
Advisor Seen
Anchor
Advisor Seen
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 #

Anchor
Top 5 Advisors by Appointments
Top 5 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

Anchor
Appointment Topic
Appointment Topic

Honors_College-AUINote->ApptCategoryCount of appointments by category. All categories, except those included in Appointment Type, are displayed here.Hourly


Appointment Type

Anchor
Appointment Type
Appointment Type

Honors_College-AUINote->ApptCategoryCount of appointments by category, which can include Appointment, EM, Email, Group, Group Advising, Phone, and Walk In.Hourly

Attrition Breakdown

Anchor
Attrition Breakdown
Attrition Breakdown

Computed

SID->SID_Honors_Vw->College_Rpt
SID->SID_Honors_Vw->dept

((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

Anchor
Average Wait Time
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

Anchor
Campus
Campus

SID->SID_Honors_Vw->HomecampusStudent's home campus, based on their most recent enrollment record.Latest Benchmark

Cohort

Anchor
Cohort
Cohort

Honors_College->Student->TermThe term student was admitted into the Honors program as recorded in the Honors College database.Hourly

Cohort graduated at honors college 4 year rate

Anchor
Cohort graduated at honors college 4 year rate
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

Anchor
Cohort graduated at honors college 6 year rate
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

Anchor
Cohort graduated at honors college > 6 year rate
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

Anchor
Cohort graduated at USF 4 year rate
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
Anchor
Cohort graduated at USF 6 year rate
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

Anchor
Cohort graduated at USF > 6 year rate
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 %

Anchor
Cohort Requirements Completion %
Cohort Requirements Completion %

ComputedThe cohort requirements completion % is calculated as met if the community engagement, global requirement, and course requirement are met.Hourly

College

Anchor
College
College

SID->SID_Honors_Vw->College_RptStudent's college, based on their most recent enrollment record.Latest Benchmark

Community Engagements Accepted

Anchor
Community Engagements Accepted
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 %

Anchor
Community Engagement Completion %
Community Engagement Completion %

ComputedThe 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

Anchor
Completion Count
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

Anchor
Course Count
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

Anchor
Course ID
Course ID

SID->SID_Honors_Courses_Vw->CourseInfoID of the Course from Banner.Latest Benchmark

Course Name

Anchor
Course Name
Course Name

SID->SID_Honors_Courses_Vw->Course_TitleName of the Course from Banner.Latest Benchmark

Community Engagement Activities

Anchor
Community Engagement Activities
Community Engagement Activities

Honors_College->CommunityEngagement

(Calculated)

Count of the number of Community Engagement Activities submitted by the student.Hourly

Community Engagement Status

Anchor
Community Engagement Status
Community Engagement Status

Honors_College->CommunityEngagement->StatusIndicates the status of the Community Engagement as Accepted, Denied, or Pending.Hourly

Course Requirement Status

Anchor
Course Requirement Status
Course Requirement Status

Honors_College->AcademicCompletion->PStatusIndicates the status of the Course Requirement as Accepted, Denied, or Unavailable.Hourly

Course Requirements Completion %

Anchor
Course Requirements Completion %
Course Requirements Completion %

ComputedThe 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

Anchor
Date
Date

System calendarDate range can be picked using the calendar in the filter.

Date Refreshed on

Anchor
Date Refreshed on
Date Refreshed on


Indicates the date the data was refreshed. This date displays on the bottom right of each report.

Day of the Week

Anchor
Day of the Week
Day of the Week


Indicates the day of the week (Monday through Friday) that the appointments took place.

Department

Anchor
Department
Department

SID->SID_Honors_Vw->deptStudent's department, based on their most recent enrollment record. Latest Benchmark

Dismissed

Anchor
Dismissed
Dismissed

Computed (Honors_College->Student->Status)This includes students who were dismissed from the Honors Program (Honors Status - H%D).Hourly

Ethnicity

Anchor
Ethnicity
Ethnicity

SID->SID_Honors_Vw->EthnicRace/Ethnicity of the student.Latest Benchmark

Experience Description

Anchor
Experience Description
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

Anchor
Experience Status
Experience Status

Honors_College->Global_Exp->StatusIndicates the status of the Global Experience as Accepted, Denied, or Pending.Hourly

Experience Type

Anchor
Experience Type
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)
  • SA (Study Abroad)
Hourly

Gender

Anchor
Gender
Gender

SID->SID_Honors_Vw->GenderGender of the student.Latest Benchmark

Global Experience Accepted

Anchor
Global Experience Accepted
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

Anchor
Global Experience Activities
Global Experience Activities

Honors_College->Global_Exp

(Calculated)

Count of the number of Global Experience Activities submitted by the student.Hourly

Global Experience Status

Anchor
Global Experience Status
Global Experience Status

Honors_College->Global_Exp->StatusIndicates the status of the specific Global Experience as Accepted, Denied, or Pending.Hourly

Global Requirements Completion %

Anchor
Global Requirements Completion %
Global Requirements Completion %

ComputedThe Global requirement is counted as met if the student has at least 2 records with the status of Accepted in the Global_Exp tableHourly

Grade Awarded

Anchor
Grade Awarded
Grade Awarded

SID->SID_Honors_Courses_Vw->GRADE_AWARDEDGrade obtained by the student in the course (Banner). Latest Benchmark

Graduated @Honors

Anchor
Graduated at Honors
Graduated at Honors

Computed (Honors_College->Student->Status)This includes students who graduated from the Honors College (Honors Status - H%G).Hourly

Graduated@USF

Anchor
Graduated at USF
Graduated at 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

Anchor
Latest Appointment
Latest Appointment

ComputedThis is the latest/most recent appointment made by the student with his or her advisor.

Left Honors College

Anchor
Left Honors College
Left Honors College

Computed (Honors_College->Student->Status)This includes students who left the Honors Program (Honors Status - H%L).Hourly

Left USF

Anchor
Left USF
Left USF

ComputedThis includes students who were a part of the Honors Program but left USF without a degree.Latest Benchmark

Length of Time Taken Courses

Anchor
Length of time Taken Courses
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

Anchor
Major
Major

SID->SID_Honors_Vw->MajorIdentifies the student's primary major, based on their most recent enrollment record.Latest Benchmark

Name

Anchor
Name
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

Anchor
Non-unique appointments by Time
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

Anchor
Reason for Leaving
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:

  1. I do not see benefit to staying
  2. There are too many requirements
  3. I don't want to can't complete cultural experienced (Foreign language or study abtoad)
  4. I don't want to or can't complete thesis
  5. I do not anticipate being able to meet the 3.25 GPA requirement to graduate with Honors distinction.
  6. I currently have below a 3.25 GPA and am not receiving scholarship money
    Unavailable

 

Latest Benchmark

Status

Anchor
Status
Status

Honors_College->Student->Status

The 4-letter code indicating the status of the student. The Status is represented by four codes:

  • Student Type:

H - Honors College
N - Non Honors

  • Admission Type (to Honors College)

2 - 2 year/Continuing USF or Transfer Admit
4 - 4 year/ Admitted as an FTIC

  • Special Programs

N - None
S - Scholar (Holc/Jenk)
P - Provost's Scholar
B - Both

  • Status

A - Active
P - Probation
D - Dismissed
L - Left

Hourly

Student Admission Type

Anchor
Student Admission Type
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

Anchor
Student Count by Courses Taken
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

Anchor
Student Email
Student Email

Honors_College->Student->EMailEmail address of the student.Hourly

Student Type

Anchor
Student Type
Student Type

SID->SID_Honors_Vw->StudentTypeIdentifies students as graduate, undergraduate, or non-degree.Latest Benchmark

Submitted Date

Anchor
Submitted Date
Submitted Date

Honors_College->CommunityEngagement->SubmitDateDate of submission of the Community Engagement form.Hourly

Term

Anchor
Term
Term

SID->SID_Honors_Courses_Vw->termidTerm that the course was taken (Banner).Latest Benchmark

Time of Day

Anchor
Time of Day
Time of Day


Time of appointment broken down by hour to see the concentration of advisor appointments.

Total Appointments

Anchor
Total 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

Anchor
Total Count
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

Anchor
Unique Appointments
Unique Appointments

Honors_College->Checkin_Applicant

(Calculated)

Count of total unique student appointments at Honors College.Hourly

URL

Anchor
URL
URL

Honors_College->Global_Exp->SA_URLURL of the global activity.Hourly

USFID

Anchor
USFID
USFID

SID->SID_Honors_Vw->uidStudent University Identification number.Hourly

...