To create this list navigate to:
  1. Lists > More Lists
  2. Select Create an Advanced List from the drop down
  3. Within the Select Objects Tab select the following objects:
  4. Under Constituent Information
  • User Base
  • User Role
  1. Under Academic Group
  • Course Enrollment
  • Course Group
  • Course Base
  • Course Term
  1. Under School
  • School Level
  • School Year
  1. Under Grading
  • Enrollment Grade
  • Grade Plan Grade
  • Grade Plan
User-added image


  1. Select the Display Fields Tab
  2. Click Select Fields, mark the following fields:
  • User Base.First Name
  • User Base.Last Name
  • Course Base.Course Title
  • Enrollment Grade.Grade
  • Grade Plan.Grade Plan
User-added image


  1. Select the Filters tab 
  2. Within Global Filters (Where Clause) click + to add the following global filters:
  • Where User Role.Role is any of Student
  • And School Year.School Year is any of the school year you're looking for (for example 2015-2016) 
  • And School Level.School Level is any of the school level you're looking for (for example Upper School) 
  • And (Enrollment Grade.Grade Contains C-
  • Or Enrollment Grade.Grade Contains D+
  • Or Enrollment Grade.Grade Contains D
  • Or Enrollment Grade.Grade Contains D-
  • Or Enrollment Grade.Grade Contains F)
  • And Grade Plan.Grade Plan is any of ...(select all grade plans to include, for example Quarter 1 Grade)
​Note: School Year Filter and School Level Filter can be changed to pull a list for other school years and school levels within these grading parameters.

User-added image


  1. Select Preview to make sure the list displays the correct information 
  2. Name the list and add place in a Category if desired
  3. Click Save or Save & Exit