To create this list navigate to:
  1. Navigate to Lists > Manage Lists.
  2. Click the Manage basic and advanced lists block under List Actions.
  3. Select Create an Advanced List from Add the drop down in the upper left. 
  4. Within the Select Objects Tab select the following objects:
  5. 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.