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.
-
Create this from scratch as an advanced list.
-
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
-
-
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.
-
-
From Filters, select :
-
where the field School Year, Current Year is True.
-
and the field User Role, Role is any of Student.
-
-
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
-
-
Select Save & Exit.