SSRA Undergraduate Goal To Enroll Weekly Report





Part of Student Success Hub

maintained by Student Success Research and Analytics

Undergraduate Goal to Enroll Weekly Report 

This set of operational reports provide Undergraduate admissions cycle funnel and First-Time-In-College incoming profile for the current week and final week of cycle. The historical data is available for the past 5 years. These reports enable leadership to report, track, and plan admissions on a weekly basis. 

Data Source: ADM
Refresh schedule:  Data is refreshed every week. The “Data Refreshed” field on the top right of the page indicates when the data was extracted from ADM. 

Report Pages
  • Weekly Summary Undergraduate Admissions Report – Homepage presents First-Time-In-College (FTIC) and Transfers Admissions cycle for the current week based on the most recent year displayed and final week of each cycle year.

   Filters included: Term (Summer/Fall/Spring), Campus, Origin (In-State/Out-Of-State/International), Gender and Ethnicity (IPEDS).

  • Freshmen Admissions Profile – Page presents the FTIC incoming academic profile (SAT/ACT/High School GPA) for Admits, Deposited, and Enrolled current week based on the most recent year displayed and final week of each cycle year.

   Filters included: Term (Summer/Fall/Spring), Campus, Origin (In-State/Out-Of-State/International), Gender and Ethnicity (IPEDS).

  • Admissions by Origin -Page presents First-Time-In-College (FTIC) and Transfers Admissions cycle for the current week based on the most recent year displayed and final week of each cycle year for In-State, Out-of-State and International prospective students. Featured as a crosstab with Admissions cycle year and Term as Summer/Fall and Spring.

   Filters included: Term (Summer/Fall/Spring allows for disaggregation of the Summer + Fall row), Campus, Gender, Ethnicity (IPEDS), Applicant Type (Freshmen/ Transfer type).

  • Admissions by Distinct Applicants- Page presents distinct counts of (counts of applicants instead of counts of applications) First-Time-In-College (FTIC) and Transfers applicants for the current week based on the most recent year displayed and final week of each cycle year. Featured as a crosstab with Admissions cycle year and Term as Summer/Fall and Spring. Summer + Fall Term has also been split to present Fall separate from Summer.

   Filters included: Campus, Gender, Origin (In-State/Out-Of-State/International), Ethnicity (IPEDS), Applicant Type (Freshmen/ Transfer type).

Filter Definition

Filter

Data Source (underlying data field)

Description

Report Pages

Term

SQLDWPRO.mart.Term_DIM

The Summer, Fall and Spring

All Pages

Campus

SQLDWPRO.mart.Campus_DIM

The campus in which student applied

All Pages

Origin

SQLDWPRO.mart.Residency_DIM

A student shall be classified as In-State, Out-of-State, International or Unknow using residency and citizenship status

All Pages

Gender

SQLDWPRO.mart.Person_Demo_DIM

The gender of applicants

All Pages

Ethnicity

SQLDWPRO.mart.Person_Demo_DIM

Categories align with Federal IPEDS definitions of ethnicity

All Pages

Tips

Filter Panel

Filters are listed on top 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.
  • 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 dropdown 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   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  drill-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: