Student Demographic Reporting

You can import student demographic data, such as ethnicity, economic status, and special education status, into Schoology and view managed assessment results aggregated and filtered by those attributes from within the platform. 

These reports will help educators identify need areas, set goals, and measure proficiency of sub-populations of students using managed assessment results.

Creating Demographic Attributes

To get started, Administrators with the ability to Manage Users can import attributes into the Demographics area.

 

Manage_Demographic_Attributes.png 

To add a new attribute to your Organization:

  1. Click the +Attribute button.
  2. Enter a name in the Attribute Name field.
  3. Click Create to complete.
Note: Attribute Names can be up to 256 characters long

Importing Demographic Associations

Once Demographics are created, students can have one associated value with each of the created demographics. In order to associate a student with demographic values, the user must upload a CSV file containing the associations. 

Note: Each student can have only one demographic value for each demographic attribute. For example, a student may not be associated with more than one Ethnicity. Instead, a student would need to be associated with an Ethnicity value of “Two or More.”

Step 1 — Select file

The CSV for the import must have a header row. Each subsequent row will represent a student.

The following columns must be included:

  • User Unique ID
  • Attribute Names to match those in the Manage Users area

Step 2 — Match Columns

Once the file has been attached, click Continue to match the columns of your file. You must map the Demographics created in Schoology with the header row of the file. For example, enter User Unique ID and the name of each attribute into the text box to the right of the corresponding fields. 

Note: If there is no value in the student's row for an attribute column, the student will not have an associated value with that demographic.

 

Import_Demographics.png

 

Step 3 — Status Log

You can monitor the progress of your import in the Status Log area. Process times are displayed in your organization's local time.

Note: Schoology is optimized to process imports and exports (auto or manual) most quickly between the hours of 7pm to 6am Eastern Time (ET)/11pm to 10am Greenwich Mean Time (GMT) from Monday to Sunday. Imports or exports that are run outside of this window will be slower to complete. Schoology strongly recommends performing or scheduling all imports, exports, and bulk deletions during this time frame, including manual imports as well as scheduled auto-imports, for optimal performance.

Viewing Performance by Demographics

All viewers of the Assessment Results can view the Demographics report for Managed Assessment results. The students included in the report will be shown according to the AMP Administration Permissions.

Performance_by_Demographics.png

 

Above the demographics report, the average score and total number of students who were assessed is displayed. 

Using the Demographic Attribute dropdown menu, the report viewer can choose from any of the demographic attributes that have been created in Manage Users with associated students.

When an attribute is selected, each demographic is displayed in alphabetical order. The number of students is displayed next to the demographic value in parentheses, and the average assessment score of those students is shown.

  • The bar is red if the average of the students for a demographic value is below the average of all students.
  • The bar is green if the average of the students for a demographic value is above the value of all students. 

Performance_by_Demographics.png

 

Filtering Overall Results & Mastery Results by Demographics

You can also filter by demographics when viewing the Overall Results and Mastery Results by Student, Instructor, Section, and School.

Filter_Overall_Results_by_Demographic.png

You can use the +More Filters option to filter results by score range, demographic attribute, and demographic value.

You can filter by multiple demographic values for the same demographic attribute. For example, you can select both male and female under the gender attribute. This filters the results to display all students who are male or female.

You can also filter by multiple demographic values for different demographic attributes. For example, you can select male and Hispanic under the gender attribute and race/ethnicity attribute. This filters the results to display all students who are male and Hispanic.

Note: There is a limit to the number of selections you can make in this area: You can select up to 5 values per demographic attribute for up to 5 attributes.

Once the filters are applied, the report will now be filtered to display only students who match the criteria.

 

Powered by Zendesk