Versions Compared

Key

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

Insert excerpt
_DraftNote
_DraftNote
nopaneltrue

Course Demand Reports

The :

  • View 
  • View 
  • Gain 
  • Compare

Intro

  • Features

Note: Security permissions are set to enable sharing of this data to appropriate users, i.e., 

The information below describes each of the IC dashboardsCourse Demand reports, provides tips on navigation, and identifies common tasks you can use to view the data.

...

Report: Course Demand - College Scheduler Details

The 

Tab 1: Advisor Summary


This report 

Filter Panel

The left panel allows you to filter the data information that displays in the data panel. Select to filter by one or more of the following options:

Image RemovedImage Added

  • Advisor College: Select a college to view appointment data for that college; the list is filtered for the advisor.
  • Appointment Outcome: Select an appointment outcome among the following choices:
    • Attended
    • No Show
    • SSP Canceled
    • Student Canceled -  Fault
    • Student Canceled – No Fault
    • Walk-in
  • FIF Cohort: Select from the list of available FIF cohorts.
  • SRKALL Cohort: Select from the list of available SRKALL cohorts.
  • Select Date: Move the slider to select a date range or click in each date field to select from a calendar.
  • Term Code: 
  • Course Prefix: 
  • Course Number: 
  • Course Section: 

Data Panel

The panel on the right is the main workspace and consists of five sections. These sections are described in detail below.Image Removed

Notes:

  • The displays for these sections are interactive; that is, if you select a component in one display, the numbers in the other sections adjust accordingly.
  • To select an item in the display, click the segment of the pie or bar chart. To return to the full display, click the segment again.

Section 1: Number of Appointments

This section (shaded green above) displays the number of advisor appointments and provides comparisons with the advisor’s college. The statistics show the following: 

  • Avg Daily Appts: Represents the average daily appointments for the advisor. The basis for this average is the number of days the advisor holds appointments and is not a daily measure.
  • Total Appts: Represents the total number of appointments for this advisor.
  • Avg. Daily Appts for College: Represents the average daily appointments for advisors in the same college as this advisor. The basis for this average is the following:
    • Each advisor's average daily appointments is calculated (number of appointments / number of working days holding appointments).
    • The average for the college is then calculated for all advisors in the college (sum of advisor averages / number of advisors).
  • Total Appts for College: Represents the number of appointments for all advisors in the same college as this advisor.

For example, Jane Advisor has 74 appointments in March and has nine days on which she holds appointments. Her average daily appointment measure is eight. The advisors in her college have a total of 808 appointments for the month. Based on the calculations using the actual days each of those advisors holds these appointments, the average daily appointment count for the college is 11.

Section 2: Appointments

This section displays the number of appointments for the advisor by month. If you filter by a date range in the Filter Panel, it displays numbers only for that time period. You can drill down using the “drill” buttons at the top left of this section. The default selection displays numbers of appointments by month.

  • Drill down Image Removedto view the days of the month to show appointments on particular dates in the month. 
  • Drill down again to show appointments by hours of the day, such as 7 am or 2 pm. 
  • Drill up Image Removedto show appointments by year.

You can also drill down to select a specific month and show the distribution among the dates for that month. To do this: 

  1. Click the down arrow to the right Image Removed to turn on Drill Down (Tool Tip: Click to turn on Drill Down). 
  2. Click the month you wish to view the appointment distribution.
  3. Optionally click a day to view distribution among hours in the day.
  4. To exit Drill Down mode, click the down arrow again.
  5. Drill upImage Removedto return to the monthly display.

Section 3: Appointment Status

This section displays the status of appointment. Each advisor appointment has one status based on these selections:

  • Canceled
  • Completed
  • Confirmed
  • Scheduled
  • Walk-in

You can click on any segment of the pie chart to adjust the display of data in other sections for that appointment type.

For example, if you select “Canceled” in the pie chart, the other sections display actual numbers for the canceled appointments. This can be helpful, for example, in determining the reasons for the canceled appointments or to see if these appointments fell on particular days of the month. Select “Canceled” again to return to all statuses.

Section 4: Reasons for Appointments

This section lists reasons for the appointments in a bar graph. Each advisor appointment has one reason based on these selections:

  • Academic Dismissal/Reinstatement
  • ACR Petitions
  • Career Advising
  • Change of Major/Major Reselection
  • Form Completion
  • General Advising
  • Holds
  • Minor & Certificates
  • Not Available
  • Pre-Orientation/Transfer Advising
  • Scheduling/Course Planning/Degree Progression

As with the other sections, you can click on one component or selection to adjust the data in the other sections for that appointment reason.

...

  • .

Section 5: Appointments by Student

This table displays a list of students with advisor appointments during the date range selected. The number of students in the display changes depending on the filter(s) you select as well as the refinements you make in the bar and pie charts. The table layout displays the following fields:  

  • Student UID
  • Count of Appts
  • Date Recent Appt
  • Campus
  • College
  • Department
  • Major
  • Full Name
  • Email

You can expand the student listing to a full screen by clicking the “Focus mode” icon. To see this icon, hover over the Appointments by Student section and select the icon on the far right. Your screen changes to display a full list of the appointments. You can sort by any of the columns in the table by clicking the column label in the Header. To return to the previous display, click “Back to Report.”

Sample Tasks

The following are a few examples of ways you can view the data as well as explore the interactivity among the elements in the display.

Student Appointment Records

You can view a list of students for any of the specific metrics in the Appointments, Appointment Status, or Reasons for Appointments sections. For example:

View student names for registration holds:

  1. Right-click on the Holds bar in the Reasons for Appointments section.
  2. Select See Records. The report displays the students requesting advisor appointments for registration holds in table format. 
  3. Select Back to report to return to the dashboard. 

View student names for appointments in June:

  1. Right click on the June bar in the Appointments bar graph.
  2. Select See Records. The report displays a list of students having advisor appointments in June. 
  3. Select Back to report to return to the dashboard. 

Appointments by Calendar Ranges

You can view appointment data through a month to see if appointment reasons are concentrated on particular days. Note that the default view of the Appointments section shows appointments by month.

  1. If desired, select a date range in the Select Date filter.
  2. Drill the data to the day level by clicking the Image Removed button in the header of the Appointments (calendar) section.
  3. Select a particular day of the month to view the reasons for the appointments that day. For example, selecting the 1st of the month may indicate a concentration of scheduling changes.  
  4. Select the day again to return to all appointments.
  5. Select an appointment reason in the Reasons for Appointments section to view how concentrated or spread out those appointments are for the month.

Canceled Appointments

You can focus on appointment cancellations using both the metrics in the Data Panel and the filters in the Filter Panel.

  1. Select “Student Canceled – Fault” in the Appointment Outcome field in Filter panel to view the appointments canceled by students.
  2. View the calendar concentration for the times of the year and times of the month when these cancellations occurred.
  3. View the reasons the appointments were made to see if there are trends in the types of appointments.
  4. Finally, open the Appointments by Student listing (click the Focus mode icon) to view a list of these students and identify any students with multiple cancellations.
  5. To return to the full display, select Back to report, then click the "Student Canceled – Fault" again in the Appointment Outcome field to deselect this option and display all appointments. 

Reasons for Appointments

You can view metrics based on selected appointment reasons, such as students changing majors, to view appointment statuses or calendar concentrations.

  1. For example, select “Change of Major/Major Reselection” in the Reasons for Appointments section.
  2. View the appointment statuses and concentration of this appointment type by month or day.
  3. Right click the bar for “Change of Major/Major Reselection,” then click See Records to view the list of the students looking for advisor help in changing majors.
  4. Select Back to report to return to the dashboard.
Filters

Advisor Name

Advisor College

...

Report: Course Demand - Course Level

The IC – Supervisor Summary dashboard provides metrics of advisor appointment data from a supervisor or coordinator viewpoint. Course Demand - Course Level report provides metrics for

Filters

Campus

College

Department

...

Report: Course Demand - Degree Works


The IC – Supervisor Summary dashboard provides metrics of advisor appointment data from a supervisor or coordinator viewpointCourse Demand - Degree Works report provides metrics for




Filters


Campus



Report: Course Demand - Section Level

The IC – Supervisor Summary dashboard provides metrics of advisor appointment data from a supervisor or coordinator viewpoint. Course Demand - Section Level report provides metrics for

Filters

Campus


...


Anchor
Report Elements Glossary
Report Elements Glossary

...

Note: To sort the table elements, click the up or down arrow in the column header. 

Insert excerpt
_DraftNote
_DraftNote
nopaneltrue


Element

Source

(System->Table->Column)

DescriptionFrequency of Update

Advisor Appointments

Anchor
Advisor Appointments
Advisor Appointments

appiandb.AS_appointment ->appointmentid

Calculated

The number of appointments for the advisor in the selected date range.

Daily

Anchor
Advisor College
Advisor College
Advisor College

appiandb.AS_unitBookingTreeLogic->levelOneDescThe advisor's home college.Daily
Advisor Email(SID.HUB_CIMS_CURR_ID_V_Staging -> NETID) + "@usf.edu"The email address of the advisor.Daily

Advisor Name

Anchor
Advisor Name
Advisor Name

Crete.FIF_SPRIDEN_Staging -> SPRIDEN_LAST_NAME] + Crete.FIF_SPRIDEN_Staging -> SPRIDEN_FIRST_NAME

The name of the advisor.Daily

Advisor UID

Anchor
Advisor UID
Advisor UID

appiandb.AS_attendee  -> attendeeUId where attendeeTypeRefId = 17The advisor's university identification number.Daily

Appointment Outcome

Anchor
Appointments by Outcome
Appointments by Outcome

appiandb.AS_reference  -> displayValue in

 (20,21,22,23,24)

The result of the advisor appointment. Available values for this field are:

  • Attended
  • No Show
  • SSP Canceled
  • Student Canceled – Fault
  • Student Canceled – No fault
  • Walk-In
Daily

Appointment Reason

Anchor
Appointment Reason
Appointment Reason

appiandb.AS_reference -> displayValue in

(6,7,8,9,10,11,12,13,14,15)

The reason the student requested the appointment. Available values for this field are:

  • Academic Dismissal/Reinstatement
  • ACR Petitions
  • Career Advising
  • Change of Major/Major Re-selection
  • Form Completion
  • General Advising
  • Holds
  • Minor & Certificates
  • Not Available
  • Pre-Orientation/Transfer Advising
  • Scheduling/Course Planning/Degree Progression
Daily

Appointment Status

Anchor
Appointment Status
Appointment Status

appiandb.AS_reference -> displayValue in (18,19,25,26,28,29)

The status of the appointment. Available values for this field are:

  • Canceled
  • Completed
  • Confirmed
  • Scheduled
  • Walk-In

The Appointment Status pie chart displays numbers for each of the above appointment statuses based on the filters selected.

Daily

Appointment Type

Anchor
Appointment Type
Appointment Type

appiandb.AS_reference -> displayValue in

(typeRefId=1)
Need values (displays in table)Daily

# Appts

Anchor
Advisor Appts
Advisor Appts

Count of (appiandb.AS_appointment  -> appointmentId) where attendeeTypeRefId = 17The total number of appointments for this advisor.Daily

Attendee UID

Anchor
Attendee UID
Attendee UID

appiandb.AS_attendee  -> attendeeUId where attendeeTypeRefId = 16The appointment attendee is the student attending the appointment with the advisor.Daily

Avg Daily Appts for Advisor

Anchor
Avg Daily Appts Advisor
Avg Daily Appts Advisor

Calculated:

AVERAGE(DISTINCTCOUNT (appiandb.AS_appointment  -> appointmentId)) per day
The average number of appointments for all advisors per advisor working day in the selected time period.Daily

Avg Daily Appts for College

Anchor
Avg Daily Appts College
Avg Daily Appts College

Calculated:
AVERAGE(DISTINCTCOUNT (appiandb.AS_appointment  -> appointmentId)) per College per day

The average number of appointments for advisors within the college. The calculation averages the number of appointments per advisor divided by that advisor's number of working days.Daily

Campus

Anchor
Campus
Campus

SID.IC_StudentList_Vw -> CampusTitle

The student's or advisor's home campus.Daily

Capacity

Anchor
Capacity
Capacity

CalculatedCalculated as a percentage, this value represents the average number of appointments divided by the selected Daily Appointment Capacity target. The Daily Appointment Capacity is set by the user with a maximum of 200.Daily

College

Anchor
College
College

SID. IC_StudentList_Vw -> CollegeTitleThe student's home college.Daily

Contact Method

Anchor
Contact Method
Contact Method

appiandb.AS_appointment ->formatRefId in (2,3,4,5)The method used to set up the appointment, such as Phone or Office.Daily

Count of Appts

Anchor
Count of Appts
Count of Appts

Calculated: DISTINCTCOUNT(appiandb.AS_appointment  -> appointmentId) where attendeeTypeRefId = 16The number of appointment records for this student. This includes all appointment statuses: Confirmed, Scheduled, Walk-In, Completed, and Canceled.Daily

Currently Enrolled Students With No Appointments (count)

Anchor
Currently Enrolled
Currently Enrolled

count(SID. IC_StudentList_Vw->UID ) + Count(appiandb.AS_attendee  -> attendeeUId where attendeeTypeRefId = 16) where Adviser College != Student collegeThe number of students who are currently enrolled who do not have a record of an advisor appointment.Daily

Daily Appointment Capacity

Anchor
Daily Appointment Capacity
Daily Appointment Capacity

Calculated

The targeted capacity for the number of appointments an advisor holds per day, established by the department and college.

The default appointment capacity is set to 100 and can be adjusted by using the slider or by typing in a different value in the field. An upper limit of 200 is hard-coded.

Daily

Date

Anchor
Date
Date

Data Refreshed on this dateThe date on which data has been loaded.Daily

Date Recent Appt

Anchor
Date Recent
Date Recent

appiandb.AS_appointment -> startDateThis date represents the most recent appointment recorded for the student.Daily

Department

Anchor
Department
Department

appiandb.AS_unitBookingTreeLogic->levelTwoDesc

SID. IC_StudentList_Vw -> DepartmentTitle

Department to which the student or advisor belongs.Daily

FIF Cohort

Anchor
FIF Cohort
FIF Cohort

Crete.IC_StudentList_Vw.FIFCohort ->The Finish in Four (FIF) cohort to which the student belongs.Daily

First Name

Anchor
First Name
First Name

SID.IC_StudentList_VwNAME_FIRSTThe first name of the student.Daily

Full Name

Anchor
Full Name
Full Name

SID.IC_StudentList_Vw.NAME_LAST + SID.IC_StudentList_VwNAME_FIRSTThe full name (first name, last name) of the student.Daily

Last Name

Anchor
Last Name
Last Name

SID.IC_StudentList_Vw.NAME_LASTThe last name of the student.Daily

Major 1

Anchor
Major1
Major1

SID.IC_StudentList_Vw -> MAJORTITLEThe student's major or primary major if double-majoring.Daily

Major 2

Anchor
Major2
Major2

SID.IC_StudentList_Vw -> MAJOR2The student's second major, if any.Daily

Select Date

Anchor
Select Date
Select Date

appiandb.AS_appointment->startDateThe date range of appointments, used to filter the number of appointments to display in the data panel.Daily

SRKALL Cohort

Anchor
SRKALL Cohort
SRKALL Cohort

SID. IC_StudentList_Vw -> SRKALLCohortThe SRKALL cohort to which a student belongs.Daily

Student Appointments # Distribution

Anchor
Student Appt Distribution
Student Appt Distribution

DISTINCTCOUNT(IC[appointmentId])

The distribution of advisor appointments across colleges.Daily

Student Email

Anchor
Student Email
Student Email

SID. IC_StudentList_Vw -> GOREMAL_EMAIL_ADDRESSThe student's email address.Daily

Student UID

Anchor
Student UID
Student UID

appiandb.AS_attendee  -> attendeeUId where attendeeTypeRefId = 16The student's university identification number.Daily

Total Appts

Anchor
Total Appts Advisor
Total Appts Advisor

Calculated: DISTINCTCOUNT(appiandb.AS_appointment  -> appointmentId) where attendeeTypeRefId = 17

The total number of advisor appointments for the selected date range. When selecting more than one advisor on the Supervisor Summary report, this represents a sum of the selected advisors' appointments.Daily

Total Appts for College

Anchor
Total Appts College
Total Appts College

Calculated:
DISTINCTCOUNT(appiandb.AS_appointment  -> appointmentId) per College

The total number of appointments for all advisors in the selected college.Daily

# Working Days

Anchor
Working days
Working days

appiandb.AS_appointment ->startDateTimeNumber of days the advisor held advisor appointments.Daily

...