SSRA SCH and FTE Dashboard

Part of Student Success Hub

maintained by Student Success Research and Analytics

SCH FTE reports is a set of following reports: 

SCH FTE Report

SCH FTE reports provide SCH and FTE information for 10 years at the latest benchmark. These reports enable leadership to visualize, slice and dice the data and facilitate with strategic planning. 

SCH FTE All Benchmarks

SCH FTE all benchmarks reports provide SCH and FTE information for 5 years for all benchmarks. 

Data Source: SID
Refresh schedule:  Data is refreshed for all three semesters for all four benchmarks. The “Data as of” field on the bottom right of the page indicates when the data was last refreshed from SID database.  The "Data updated" field on the top of the report indicates when the report was last published. These two dates are often different because a report update could be change in visuals or navigation etc. and not necessarily a data refresh.

Report pages
SCH FTE Report
  • Quick Facts: USF The tab displays the USF summary of both SCH (Student Credit Hours) and FTE (Full-Time Equivalent) for the selected academic year. This tab only shows data for one academic year at a time. To view the data for specific semester, use the Semester filter in the filter panel.  The visuals on this page has SCH and FTE information:
    • By college
    • By campus
    • By semester
    • By gender
    • By race/ethnicity
    • By course level
  • Quick Facts: College The tab displays the college level summary of both SCH (Student Credit Hours) and FTE (Full-Time Equivalent) for the selected academic year and for the selected college. This tab only shows data for one academic year at a time, for the selected college. To view the data for specific semester, use the Semester filter in the filter panel. The visuals on this page has SCH and FTE information:
    • By department
    • By campus
    • By semester
    • By gender
    • By race/ethnicity
    • By course level
  • Trend by Diversity → The tab displays a ten-year trend of SCH (Student Credit Hours) and FTE (Full-Time Equivalent) broken down by race/ethnicity and gender, along with a slicer to toggle between the SCH and FTE views.
  • Trend by College → The tab displays a ten year trend of SCH (Student Credit Hours) and FTE (Full-Time Equivalent) broken down by College,  along with a slicer to toggle between the SCH and FTE views.
  • Trend by Campus & Course Level → The tab displays a ten year trend of SCH (Student Credit Hours) and FTE (Full-Time Equivalent) broken down by Campus and Course Level, along with a slicer to toggle between the SCH and FTE views.
  • Details by Campus & Course Level → The tab displays ten years of data for SCH (Student Credit Hours) and FTE (Full-Time Equivalent) broken down by Campus and Course level in a tabular format, along with a slicer to toggle between the SCH and FTE views.
  • Details by College & Course Level → The tab displays ten years of data for SCH (Student Credit Hours) and FTE (Full-Time Equivalent) broken down by College and Course Level in a tabular format, along with a slicer to toggle between the SCH and FTE views.
  • SCH : Change From Prior → The tab displays ten years of SCH (Student Credit Hours) data by level and shows the change from the prior year.

                 The "Diff SCH" column shows the difference in SCH from the previous year for that level. The calculation is (SCH for the year - SCH for the previous year).

SCH FTE All Benchmarks

  • SCH/FTE By Term → The tab displays the data of SCH (Student Credit Hours) and FTE (Full-Time Equivalent) broken down by term and benchmark. This tab only shows data for one term of the year at a time.
  • SCH/FTE By Benchmark → The tab displays the data of SCH (Student Credit Hours) and FTE (Full-Time Equivalent) broken down by benchmark, campus and course level for the past five years in a tabular format, along with a slicer to toggle between the SCH and FTE views.

Filters on the Filters Panel

There is a filter panel on the right which can be expanded or collapsed using the >> button.  The filter panel has following filters:

  • Budget Entity
  • Academic Year
  • Campus
  • College
  • Course Group
  • Course Level
  • Department
  • Gender
  • Health/Non-Health
  • In/Out-of-State
  • Instructional Method
  • On/Off Campus
  • Race/Ethnicity
  • Semester
Glossary

Data Element

Data Source (underlying data field)

Description

Report Pages

Academic YearSID → SID_TERMID→ TERMIDTerm such as Summer, Fall All Pages
SemesterSID → SID_TERMID → TERMIDSemester such as Fall, Spring or SummerAll Pages
CampusSID → SID_COURSES_TAKEN→ CAMPUS_FThe Funding Campus of the courseAll Pages
CollegeSID → SID_COURSES_TAKEN → GLOBAL_COLLEGEThe Global College funding the courseAll Pages
DepartmentSID →SID_COURSES_TAKEN → GLOBAL_DEPTThe Global Department funding the courseAll Pages
Course Level GroupSID → SID_COURSES_TAKEN → CRS_LEVEL_GROUPCourse level group such as Undergraduate or GraduateAll Pages
Course LevelSID → SID_COURSES_TAKEN → CRS_LEVELCourse level such as Lower, Upper, Grad I (Masters) and Grad II (Doctoral)All Pages
Instructional MethodSID → SID_INSTRUCTIONAL_ACTIVITY→ DELIVERY_METHD_INDDelivery Method such as Hybrid, Online, Traditional
All Distance Learning and Partial Distance Learning has been combined as Online
All Pages
CIP SID → SID_CIP_TITLES→ CIP_CRSCourse CIPAll Pages
CIP TitleSID → SID_CIP_TITLES→ CIPTITLETitle for each CIPAll Pages
Budget EntitySID → SID_COURSES_TAKEN→ BE_CD_CRSFunded by Budget Entity - E&G, Auxiliary and HealthAll Pages
SCHSID → SID_COURSES_TAKEN→STU_SECTN_CREDStudent Credit HoursAll Pages
FTESID → SID_COURSES_TAKEN→STU_SECTN_CRED

If the Course is an Undergraduate Level Course then FTE=SCH/30;

If the Course is an Graduate Level Course then FTE=SCH/24;

All Pages


Tips

Filter Panels

Filters are listed on top panel of the report.

Notes:

  • Click the down arrow to select from options in the filters and narrow down your results. 
  • To deselect an item, click on the option again. 
  • Some filters are radio buttons and you can select only one item. The items in these filters are indicated as round buttons.
  • Some filters allow multiple selections. To select multiple values in a filter, hold the Ctrl key as you check the square boxes .
  • Filters for the report may not have Blank as an option. 

Data Panel

This panel displays the filtered results. To work with data in this panel:

  • Select an individual row in the table to highlight the item/row. Select it again to return to the full table view.
  • You can sort the data by column values, if the sorting is available for that column. Hover your mouse over the last row item in the column header and if a small black triangle appears Black Triangle PNG, Free HD Black Triangle Transparent Image - PNGkit ,  you can sort that column in ascending or descending order by clicking on your mouse. 

Options for the Data Panel

Export Data to Excel

To export the data results to Excel, hover your mouse over the upper right hand side corner of the data table and a horizontal menu bar  will pop up. Click the  in the top right corner . 

A drop down menu will appear with 'Export data' as one of the options.  Select Export Data to work with the data in Excel.

Note : The exported data in Excel may not look exactly like the screen. 


Focus Mode

To see the data in Focus Mode, hover your mouse over the upper right hand side corner of the data table and a horizontal menu bar  will pop up. Click the option for Focus Mode   It allows the visual to take the entire space in the report canvas. Full screen mode will persist until you exit out or click on   on the top left hand side.
When in Focus Mode, click the  in the top right corner and a drop down menu will appear with the following options:

You can export data, or see the data in a table by selecting the appropriate option.  

Spotlight

Spotlight causes all other visuals on the page to fade so the selected visual is highlighted. To highlight a visual, click on more action  and select 

Drill Up and Drill Down

If the visual has the hierarchy, the  menu will appear when you hover on the top left side of the visual.  Turn on drill down first by selecting the downward arrow. The grey background  lets you know that drill down is active. Selecting  will expand another level of hierarchy. Selecting the double arrow icon for drill all levels at oncedrill-down icon takes you to the next level in the hierarchy.  Selecting  will take you one level up in hierarchy.  The arrows will be greyed out if the option is not available. 

Reset to Default

If you have made any changes, such as implementing filters or sorting the table, you have the ability to return the sorting and filtering to the report creator's default view. Click the Reset to Default image above the report in the Report Header: