Versions Compared

Old Version 4

changes.mady.by.user Zhong Zheng

Saved on

compared with

New Version 5

changes.mady.by.user Sangita Singh

Saved on

Key

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

Live Search
spaceKeyODS
placeholderSearch Within ODS Knowledge Base
typepage
labelsknowledge_base

Part of Student Success Hub

maintained by Student Success Research and Analytics


Section


Column
width5%



Column
width95%


Panel
borderColor#006747
bgColor#F4F5F7

Headcount Reports

These Headcount reports provide headcount information at a glance as well as detail level across the benchmarks. The historical data is available for the past 10 years and is at the Final bench. The data for all the benches is available for past 5 year. These reports enable for 10 years at the latest benchmark.  These reports enable leadership to visualize, slice and dice the data and facilitate with strategic planning.  Data Source: SID
Refresh schedule:  Data is refreshed . These reports are semester based reports. 

Headcount All Benchmarks

Headcount All Benchmarks provide headcount information for all the benches for past 5 year. These reports are semester based reports. 


Data Source: SID
Refresh schedule:  Data is refreshed every benchmark. The “Data Refreshed” field on the bottom right of the page indicates when the data was extracted from last refreshed in SID database.  The "Data Updated" field on the top of the report indicates when the report was publishedlast updated. These two dates are often different.






Panel
titleColorwhite
titleBGColor#006747
titleReport pages



Section 1: Headcount Reports

  • One USF Quick Facts → This tab displays the One USF enrollment information at a glance for any given term. The driver for this tab is Semester and Term filters. Term filter is dependent on the Semester filter.  This report will be blank, when the Semester filter and Term filter are out of sync.
  • Visual 1: Displays enrollment headcount by gender.
  • Visual 2: Displays enrollment headcount by college
  • Visual 3: Displays enrollment headcount by residency.
  • Visual 4: Displays enrollment headcount by race/ethnicity.
  • Visual 5: Displays enrollment headcount by campus.
  • Visual 6: Displays enrollment headcount by full-time status.
    • Visual 7: Displays enrollment headcount by student type The visuals on this page has headcount information:
    • By college
    • By campus
    • By full-time status
    • By gender
    • By race/ethnicity
    • By residency
    • By student type and New/Returning students  (click the + sign in the matrix table to expand student level).
  • College Level Quick Facts → This tab displays the summary of enrollment information for any given term for any college.
  • Visual 1: Displays enrollment headcount by campus.
  • Visual 2: Displays enrollment headcount by gender.
  • Visual 3: Displays enrollment headcount by department.
  • Visual 4: Displays enrollment headcount by full-time status.
  • Visual 5: Displays enrollment headcount by student classification.
    • Visual 6: Displays enrollment headcount by  This report will be blank, when the Semester filter and Term filter are out of sync. The visuals on this page has headcount information:
    • By campus
    • By department
    • By full-time status
    • By gender
    • By race/ethnicity
    • By residency
    • By student classification
    • By student type (click the + sign in the matrix table to expand student level)
    • Visual 7: Displays enrollment headcount by race/ethnicity.
    • Visual 8: Displays enrollment headcount by residency.
  • Trend by Semester → The tab displays the enrollment trend of degree-seeking undergraduate and graduate students by semester.Visual 1:  Displays enrollment headcount of 
  • Trend by Student Type → The tab displays the enrollment trend of degree-seeking undergraduate
    • students by semester.
  • Visual 2:  Displays enrollment headcount of degree-seeking graduate students by semester.
  • Trend by Student Typeand graduate students by student type.
  • Trend by Campus → The tab displays the enrollment trend of either Spring, Summer, or Fall semesters by campus, student level, and student type. It also shows the difference from the previous term.
  • Trend by CampusTrend by Student Level → The tab displays the enrollment trend of degree-seeking students by student type.
  • Visual 1:  Displays enrollment headcount of degree-seeking undergraduate students by student type (FTIC, FCS AA Transfer, Other AA Transfer, Other Undergraduates, and Post-Baccalaureate).
    • Visual 2:  Displays enrollment headcount of degree-seeking graduate students by student type (Masters, Research Doctoral, and Professional Doctoral).the enrollment trend of either Spring, Summer, or Fall semesters by student level, student class level, and race/ethnicity. It also shows the difference from the previous term and the percentage of difference.
  • Trend by College → The tab displays the enrollment trend of either Spring, Summer, or Fall semesters by campus, student level, and student type.Trend by Student Levelcollege and departments (click the + sign in the matrix table to show departments).
  • Trend by Race/Ethnicity and Gender  → The tab displays the enrollment trend of either Spring, Summer, or Fall semesters by student level, student class level, and  race/ethnicity, and gender.
  • Trend by College by Race/Ethnicity → The tab displays the enrollment trend of either Spring, Summer, or Fall semesters by college (click the + sign in the matrix table to show departments)race/ethnicity.
  • Trend by Race/Ethnicity and  by Gender  → The tab displays the enrollment trend of either Spring, Summer, or Fall semesters by student level, race/ethnicity, and gender.Trend by Race/Ethnicitygender.
  • Pell & Access Rate → The tab displays the Pell & Access Rate of undergraduate students in Fall semesters only. 
  • Visual 1: Displays the access rate (percentages of students who are eligible for Pell).
  • Visual 2: Displays the enrollment headcount by gender in a given Fall semester.
  • Visual 3: Displays the enrollment headcount by college in a given Fall semester (click the + sign in the matrix table to show departments).
  • Visual 4: Displays the enrollment headcount by residency in a given Fall semester.
  • Visual 5: Displays the enrollment headcount by campus in a given Fall semester.
  • Visual 6: Displays the enrollment headcount by race/ethnicity in a given Fall semester.
  • Visual 7: Displays the enrollment headcount of self-reported first-generation students in a given Fall semester.
    • Visual 8: Displays the enrollment headcount by students type in a given Fall semester.Trend by Accountability Plan Student Type → The tab displays the enrollment trend of either Spring, Summer, or Fall semesters by race/ethnicity.
    • Visual 1: Displays the enrollment headcount of a given semester by race/ethnicity using a bar chart.
    • Visual 2: Displays the enrollment headcount of a given semester by race/ethnicity and student level using a matrix table.
  • Trend by Gender → The tab displays the enrollment trend of either Spring, Summer, or Fall semesters by gender.
    • Visual 1: Displays the enrollment headcount of a given semester by gender using a bar chart.
    • Visual 2: Displays the enrollment headcount of a given semester by gender and student level using a matrix table.
  • Trend by Accountability Plan Student Type → The tab displays the enrollment trend of degree-seeking students in Fall semesters only by accountability plan student type. 
    • Visual 1: Displays the enrollment headcount of degree-seeking undergraduate and graduate students by AC student type using a matrix table.
    • Visual 2: Displays the enrollment headcount of degree-seeking undergraduate and graduate students by AC student type using a bar chart.
  • degree-seeking students by accountability plan student type in Fall semesters only. 
  • Pell & Access Rate → The tab displays the Pell & Access Rate of undergraduate students in Fall semesters only.  The visuals on this page has headcount information: 
    • By college
    • By campus
    • By gender
    • By race/ethnicity
    • By residency
    • By self reported first generation students
    • By student type

This tab also has the visual by Access Rate. Access Rate Visual is locked for the "Pell Eligible = Yes" and and "Pell Recipient = All" population and will not respond to the "Pell Eligible" and "Pell Recipient" slicers on the tab. 

Section 2: Headcount All Benchmarks

  • Benchmark by Term → The tab displays the undergraduate and graduate enrollment headcount of a given semester by benchmark (First Day, Drop/Add, Preliminary, and Final).

  • Trend by Benchmark → The tab provides a summary of enrollment trend of past 5 Spring, Summer, or Fall semesters of a given benchmark.

    • Visual 1: Displays the enrollment headcount by student level, student type, and new/returning status in a matrix table.
    • Visual 2: Displays the undergraduate enrollment trend in a bar chart.
    • Visual 3: Displays the graduate enrollment trend in a bar chart.
    • Visual 4: Displays the non-degree seeking enrollment trend in a bar chart.
  • Trend All Benchmark → Displays the enrollment trend of past 5 Spring, Summer, or Fall semesters of all benchmark by student level and student type in a matrix table.
  • Benchmark Comparison → Displays the comparison of enrollment trend of past 5 Spring, Summer, or Fall semesters between the Final bench and another bench.


Panel
titleColorwhite
titleBGColor#006747
titleGlossary


Data Element

Data Source (underlying data field)

Description

Report Pages

Age Over 25 SID → SID_PERSON_DEMO → BIRTH_YYYYMM_DTIndicator if a student is above 25 years of ageTen Year Trend 
BenchmarkSID → SID_ENROLLMENTS → BENCHBenchmark such as Preliminary or FinalBy Benchmark
Budget Entity SID → SID_ENROLLMENTS → BE_CDBudget entity such as E & G or Health SciencesTen Year Trend 
CampusSID → SID_ENROLLMENTS → HOMECAMPUSThe Campus at the time of EnrollmentAll Pages
CipSID → SID_ENROLLMENTS → CIP_STUDENT
College level and Five Year Trend
CollegeSID → SID_ENROLLMENTS → GLOBAL_COLLEGEThe Global College at the time of EnrollmentAll Pages
DepartmentSID → SID_ENROLLMENTS → GLOBAL_DEPTThe Global Department at the time of EnrollmentAll Pages except Quick Facts
EthnicitySID → SID_ENROLLMENTS→ETHNICThe Ethnicity at the time of EnrollmentAll Pages
Full Time Indicator SID → SID_ENROLLMENTS → CURR_TERM_CRS_LOAD

If the student is full time or part time based on the credit hours for the term. 

For Fall and Spring terms, UG students enrolled in >= 12 credits are considered full-time and GR students enrolled >= 9 credits are considered full-time.

For Summer term, UG students enrolled in >= 9 credits are considered full-time and GR students enrolled >= 6 credits are considered full-time.

All Pages except Ten Year Trend
GenderSID → SID_ENROLLMENTS → GENDERThe Gender at the time of EnrollmentAll Pages
HonorsSID → SID_ENROLLMENTS → HONORSThe Honors Student StatusBy Benchmark
New/ReturningSID → SID_ENROLLMENTS → STU_RECENT_ADM_DTIf the student is a New student or Returning from the previous term. If the Recent admit date is same as the Termid,  then student is New else the student is Returning.Five Year Trend, Ten Year Trend, By Benchmark
ResidencySID → SID_ENROLLMENTS →ETHNIC and FEE_CLASS_RES

The Residency Status at the time of Enrollment.  The logic is below:

When Ethnic = 'O' Then 'International'
When Ethnic ^= 'O' and FEE_CLASS_RES in ('F','R','T') Then 'In-State'
When Ethnic ^= 'O' and FEE_CLASS_RES not in ('F','R','T') Then 'Out-of-State'

All Pages
SemesterSID → SID_TERMID → MONTHSemester such as Fall, Spring or SummerAll Pages
Student ClassificationSID → SID_ENROLLMENTS → STU_CLASS_LEVEL

Student Classification such as Lower Level, Upper Level, Grad I and Grad II.  The logic is below:

When  Stu_Class_Level = 'A' Then 'Grad II'
When Stu_Class_Level = 'B' Then 'Grad I'
When Stu_Class_Level = 'L' Then '1-Lower Level'
When Stu_Class_Level = 'U' Then '2-Upper Level'

Five Year Trend
Student LevelSID → SID_ENROLLMENTS → STU_CLASS_LEVEL

Student level such as Undergraduate or Graduate.  The logic is below:

When  STU_CLASS_LEVEL ='N' Then 'Non-Degree Seeking'
When  STU_CLASS_LEVEL in ('L','U') AND DEG_LEVEL_SOUGHT in( 'B', 'N') Then 'Undergraduate' 
When  STU_CLASS_LEVEL in ('A','B') Then 'Graduate'

All Pages
Student TypeSID → SID_ENROLLMENTS → STU_RECENT_ADM_TYPStudent Type such as FTIC or MastersAll Pages except Student Type
TermSID → SID_ENROLLMENTS → TERMIDTerm such as Fall 2020 or Spring 2018All Pages




Panel
titleColorwhite
titleBGColor#006747
titleTips

Filter Panels

Filters are listed on top or on side 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 Small 25mm Lapel Pin Button Badge Novelty Plain White Badge ... .
  • 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 Image Modified  on the top left hand side.
When in Focus Mode, click the Image Modified in the top right corner and a drop down menu will appear with the following options:

Image Modified

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 Image Modified and select Image Modified

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 Image Modified 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 Image Modified 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: 




Panel
titleColorwhite
titleBGColor#006747
titleYou Might Also Be Interested In...