NAIS - Student Diversity Report

National Association of Independent Schools (NAIS) requires schools to supply a Student Diversity report that shows (by grade) a list of how many male and female students are listed for each ethnicity.

  1. Create this from scratch as an advanced list.

  2. From Select Objects, expand Constituent Information and choose User Base:

    • User Detail

    • User Role (select Inner join)

    • User Register (select Inner join)

      • School Year (select Inner join)

      • Grade Level (select Inner join)

    • User Ethnicity

  3. From Display Fields and select Enable grouping options. Then set up how these fields should display:

    • User Detail, Gender should display as Gender in column 3.

    • Grade Level, Grade Level Description should display as Grade in column 1.

    • User Ethnicity, Ethnicity should display as Ethnicity in column 2.

    • User Ethnicity, User ID should display as Student Count in column 4 and group it by Count.

  4. From Filters, select :

    • where the field School Year, Current Year is True.

    • and the field User Role, Role is any of Student.

  5. From Order By, select to order these fields in Ascending order.

    • order by Grade Level, Grade Level Description

    • then by User Ethnicity, Ethnicity

    • then by User Detail, Gender

  6. Select Save & Exit.