Success Programs

Apply Filters In Starfish

Success begins with Starfish at CSU
Faculty Button Staff Button
 

Step-By-Step Instruction Guide To Applying Filters When Searching For Students In Starfish: FILTERING (PDF Version)

STARFISH FILTERS

Starfish allows faculty and staff to find students that meet certain criteria. Oftentimes, users have the ability to download this list in an EXCEL file or take action from this list within Starfish (outreach, intervention strategies, etc.). 

ATTRIBUTES

Cleveland State University displays certain attributes in the 'Overview' section of a Student's Folder within Starfish. Please note that you may not have access to this due to limitations placed on your role.

GUIDELINES AND BEST PRACTICES FOR FILTERING

Filtering in Starfish uses AND when constructing SQL statements, which means that you will only be shown students that meet ALL the criteria you have selected in your filtering options. For example, if you would like pull a list of Dance Majors and Minors, you would need to create two lists: (1) Dance Majors Only, (2) Dance Minors Only. If you attempted to use the Dance Major filter AND the Dance Minor filter together, you would only see students that have a Dance Major AND a Dance Minor.

Also, a filter will remain in place until you clear it, even if you log out and log back in again.

Avoid enter in a TERM value when filtering by attributes. Values of No Term or All should be used.

As with any filtering in Starfish- attribute filters will only return students for whom you have permission to view.

Attribute Types and Values

When filtering an attribute that is a STRING value, it is recommended that you use a wildcard (*) to assist with returning students that meet that specific criteria. For example, if you use the attribute College (Description) to find all Dance majors, it is recommended that you enter *dan*  as the Specific Value. Doing so will produce a list of all students with the value Dance.'

When filterning an attribute that is a NUMERIC value, you can use symbols to narrow your list. For example, if you would like to return all students with a Cumulative GPA below 2.500, you can select a (<) and enter in 2.500 as a Specific Value. This will produce a list of all students that have a GPA less than 2.500. Please note that this WILL NOT produce a list less than or equal to 2.500, but simply values less than 2.500.

Symbols used in filtering numeric values include:
(<)  "Less than"
(>) "Greater than" 
(<>)  "Not equal to"
(=) "Equal to"

Attributes with the types BOOLEAN and ENUMERATION will allow users to select from a set of pre-defined values. 
 

Cumulative GPA- (Numeric)
Search Examples What is returned in Starfish?
>2.00 Students with a cumulative GPA of 2.01 or greater
<2.01 Students with a cumulative GPA of 2.00 or lower

Note: It is recommended that 'All ' should be selected for TERM.

Hours Completed- (Numeric)
Search Examples What is returned in Starfish?
>100 Students with completed hours greater than, but not equal to 100
< 75.9 Students with completed hours less than, but not equal to 75.9

Note: It is recommended that 'All ' should be selected for TERM. 


Majors (Description)- (String)
Search Examples What is returned in Starfish?
Dance* All students with a Dance major
*Health* All students, such as "preHealthScience/OccThpyPrep', that have 'Health' in the name of the major.

Note: It is recommended that 'All ' should be selected for TERM. Users that want a list of students that are Active and/or enrolled should create an additional filter for 'Program Status'>No Term Present> Specified Value '%AC%'. This will return all active students. For identifying 'enrolled' students, please select 'Enrolled' Attribute>No Term/Leave Blank>Specified Value 'TRUE'.

Majors (Code)- (String)
Search Examples What is returned in Starfish?
COMM* All students that have a Communication major code
PSC  All students that have a Political Science major code

Note: It is recommended that 'All ' should be selected for TERM. Users that want a list of students that are Active and/or enrolled should create an additional filter for 'Program Status'>No Term Present> Specified Value '%AC%'. This will return all active students. For identifying 'enrolled' students, please select 'Enrolled' Attribute>No Term/Leave Blank>Specified Value 'TRUE'.

Minors (Description)- (String)
Search Examples What is returned in Starfish?
*Religion* All students with a minor with 'Religion', such as Comparative Religion
* All students with a minor

Note: It is recommended that 'All ' should be selected for TERM. Users that want a list of students that are Active and/or enrolled should create an additional filter for 'Program Status'>No Term Present> Specified Value '%AC%'. This will return all active students. For identifying 'enrolled' students, please select 'Enrolled' Attribute>No Term/Leave Blank>Specified Value 'TRUE'.

Minors (Code)- (String)
Search Examples What is returned in Starfish?
SOC* All students with a Sociology minor
REL1 All students with a Comparative Religion minor

Note: It is recommended that 'All ' should be selected for TERM. Users that want a list of students that are Active and/or enrolled should create an additional filter for 'Program Status'>No Term Present> Specified Value '%AC%'. This will return all active students. For identifying 'enrolled' students, please select 'Enrolled' Attribute>No Term/Leave Blank>Specified Value 'TRUE'.


Other Plans (Description)- (String)
Search Examples What is returned in Starfish?
Dance* All students with a Dance major
*Health* All students, such as "preHealthScience/OccThpyPrep', that have 'Health' in the name of the major.

Note: It is recommended that 'All ' should be selected for TERM. Users that want a list of students that are Active and/or enrolled should create an additional filter for 'Program Status'>No Term Present> Specified Value '%AC%'. This will return all active students. For identifying 'enrolled' students, please select 'Enrolled' Attribute>No Term/Leave Blank>Specified Value 'TRUE'.

Other Plans (Code)- (String)
Search Examples What is returned in Starfish?
COMM* All students that have a Communication major code
PSC All students that have a Political Science major code

Note: It is recommended that 'All ' should be selected for TERM. Users that want a list of students that are Active and/or enrolled should create an additional filter for 'Program Status'>No Term Present> Specified Value '%AC%'. This will return all active students. For identifying 'enrolled' students, please select 'Enrolled' Attribute>No Term/Leave Blank>Specified Value 'TRUE'

Program Status - (String)
Search Examples What is returned in Starfish?
CA*AC All active students in CLASS
BULK*AC Active students in the Lakeland Partnership for Business

List of possible status values (Program Status):

  • AC (Active)
  • LA (Leave of Absence)
  • DC (Discontinued)
  • CM (Complete)
  • DM (Dismissed)

Please visit the following link for a listing of the various program codes. '

Note: It is recommended that 'All ' should be selected for TERM. Users that want a list of students that are Active and/or enrolled should create an additional filter for 'Program Status'>No Term Present> Specified Value '%AC%'. This will return all active students. For identifying 'enrolled' students, please select 'Enrolled' Attribute>No Term/Leave Blank>Specified Value 'TRUE'


Academic Standing- (String)
Search Examples What is returned in Starfish?
*warning* All students that have been assigned any of the five categories of warning
*prob*  All students that are on the seven categories of probation

List of possible values (Academic Standing):

  • Good Academic Standing
  • Good Standing
  • Academic Warning
  • Academic Warning - GPA
  • Academic Warning - Continuing Percentage
  • Academic Warning- GPA and Compleition
  • Academic Warning - Continuing Completion 
  • Academic Probation
  • Academic Probation - GPA
  • Academic Probation - Continued 
  • Academic Probation - GPA and Compleition
  • Academic Probation - Completion 
  • Probation
  • Probation Continued
  • Academic Suspension - GPA
  • Academic Suspension - Completion
  • Academic Suspension - GPA and Completion
  • Academic Separation
  • Academic Dismissal

Note: It is recommended that 'All ' should be selected for TERM. Users that want a list of students that are Active and/or enrolled should create an additional filter for 'Program Status'>No Term Present> Specified Value '%AC%'. This will return all active students. For identifying 'enrolled' students, please select 'Enrolled' Attribute>No Term/Leave Blank>Specified Value 'TRUE'.

Academic Standing-Term- (String)
Search Examples What is returned in Starfish?
*Spring* All students with a Academic Standing of Spring regardless of year
Fall 17 All students with the Academic Standing Term of Fall 2017

Note: It is recommended that 'All ' should be selected for TERM. Users that want a list of students that are Active and/or enrolled should create an additional filter for 'Program Status'>No Term Present> Specified Value '%AC%'. This will return all active students. For identifying 'enrolled' students, please select 'Enrolled' Attribute>No Term/Leave Blank>Specified Value 'TRUE'.

SAP- (String)
Search Examples What is returned in Starfish?
Failed* All students that have failed SAP for any reason
Failed*GPA* Students who have failed SAP and GPA was at least one of the reasons

List of possible values (SAP):

  • Passed
  • Passed -Near MTF
  • Failed - Percentage Earned
  • Failed - MTF
  • Failed - GPA
  • Failed
  • Failed - GPA and Percentage Earned
  • Failed - Percentage Earned and Near MTF
  • Failed - Percentage Earned, GPA, and Near MTF

Note: It is recommended that 'All ' should be selected for TERM. Users that want a list of students that are Active and/or enrolled should create an additional filter for 'Program Status'>No Term Present> Specified Value '%AC%'. This will return all active students. For identifying 'enrolled' students, please select 'Enrolled' Attribute>No Term/Leave Blank>Specified Value 'TRUE'.

Enrolled- (Boolean)
Search Examples  What is returned in Starfish?

There are limited options to select. These options include:

  • True
  • False

Users will be presented one of the two values listed in 'Search Examples' Column.

Note: It is recommended that 'All ' should be selected for TERM.

Current Load- (Numeric)
Search Examples What is returned in Starfish?
<20 Students with a current load less than and not equal to 20
=18 Students with a current load equal to 18

Note: It is recommended that 'All ' should be selected for TERM. Users that want a list of students that are Active and/or enrolled should create an additional filter for 'Program Status'>No Term Present> Specified Value '%AC%'. This will return all active students. For identifying 'enrolled' students, please select 'Enrolled' Attribute>No Term/Leave Blank>Specified Value.

Cohort- (Enumeration)
Search Examples What is returned in Starfish?

There are limited options to select. These options include, but aren't limited to:

  • FF11
  • FF12
  • FF13
  • FF14
  • Much more...

Users will be presented one of the five values listed in 'Search Examples' Column.

Note: It is recommended that 'All ' should be selected for TERM.

Note: It is recommended that 'All ' should be selected for TERM. Users that want a list of students that are Active and/or enrolled should create an additional filter for 'Program Status'>No Term Present> Specified Value '%AC%'. This will return all active students. For identifying 'enrolled' students, please select 'Enrolled' Attribute>No Term/Leave Blank>Specified Value 'TRUE'.


Admit Type- (String)
Search Examples What is returned in Starfish?
First* All students with the admit type First Year Undergraduate
Transfer* All students with the admit type of transfer

Note: It is recommended that 'All ' should be selected for TERM. Users that want a list of students that are Active and/or enrolled should create an additional filter for 'Program Status'>No Term Present> Specified Value '%AC%'. This will return all active students. For identifying 'enrolled' students, please select 'Enrolled' Attribute>No Term/Leave Blank>Specified Value 'TRUE'.

Graduation Application- (String)
Search Examples What is returned in Starfish?
Ur*Fall 15* All Urban student with a grad app submitted for Fall 2015
Engineering Degree Seeking 4+1*Fall 15* Only students seeking the Engineering 4+1 degree for Fall 2015

List of possible values (Graduation Application):

  • Urban Affairs Degree
  • Urban Affairs Degree Seeking
  • Lib Arts & Soc Sci Deg Seeking
  • Lib Arts & Soc Sci Deg
  • Lib Arts & Soc Sci Post-Bac
  • Lib Arts & Soc Science Cert
  • Science Degree Seeking
  • Science Post-Baccalaureate
  • Business Degree Seeking
  • Business Post-Baccalaureate
  • Engineering Degree Seeking
  • Engineering Degree Seeking 4 +1
  • Engineering Degree
  • Engineering Post-Baccalaureate
  • Engineering Post-BacC 4+1
  • Education Degree Seeking
  • Education Post-Baccalaureate
  • Nursing Degree Seeking
  • Nursing Post-Baccalaureate
  • Summer 15
  • Fall 15
  • Spring 16
  • Other terms...(Fall 16, Fall 17, etc.)

Note: You must include a space between the semesters and year.Additionally, It is recommended that 'All ' should be selected for TERM. Note: It is recommended that 'All ' should be selected for TERM. Users that want a list of students that are Active and/or enrolled should create an additional filter for 'Program Status'>No Term Present> Specified Value '%AC%'. This will return all active students. For identifying 'enrolled' students, please select 'Enrolled' Attribute>No Term/Leave Blank>Specified Value 'TRUE'.

Success Score- (Enumeration)
Search Examples What is returned in Starfish?

There are only five options to select:

  • Very High
  • High
  • Moderate
  • Low
  • Very Low

Users will be presented one of the five values listed in 'Search Examples' Column.

Note: It is recommended that 'All ' should be selected for TERM.

Note: It is recommended that 'All ' should be selected for TERM. Users that want a list of students that are Active and/or enrolled should create an additional filter for 'Program Status'>No Term Present> Specified Value '%AC%'. This will return all active students. For identifying 'enrolled' students, please select 'Enrolled' Attribute>No Term/Leave Blank>Specified Value 'TRUE'.

MyMajors- (String)
Search Examples What is returned in Starfish?

Users can check to see which students have completed a MyMajors Assessment using this attribute.

Users will need to select 'Assigned to Student' in the 'VALUE' section of filters and will get a report of students that have completed the MyMajors Assessment.

Note: It is recommended that a value NOT be entered into TERM. TERM should stay 'FILTER BY TERM'.

List of all starfish attributes
Name                                 Type       
Cumulative GPA Numeric
Hours Completed Numeric
Majors (Description) String
Majors (Code) String
Minors (Description) String
Minors (Code) String
Other Plans (Description) String
Other Plans (Code) String
Program Status String
Academic Standing String
Academic Standing-Term String
SAP String
Enrolled Boolean
Current Load Numeric
Cohort Enumeration
Admit Type String
Graduation Application String
Success Score Enumeration
MyMajors Report String/URL

*Please note: If you are are an employee of the university and would like more data on students for reporting purposes, you may benefit from having access to the 'Student Data Lanyard'. For access and questions, contact Heike Heinrich at h.heinrich@csuohio.edu.


STARFISH ASSISTANCE AND SUPPORT
Contact Us