Reports that include "Proficiency" in the title compute mastery scores across all courses. They are useful to view trends across content areas, standard types, and broader views than when narrowed to an individual course.
"Crosstab" reports are grouped reports similar to a pivot table. Column groups are formed on the listed fields identified by the keyword "across" in the specific report title.
There are some important things to keep in mind when viewing crosstab reports.
- Crosstab reports are always based on a "core data type" that is named in the report title.
- Unless otherwise noted within the report, grouped values and aggregates above this core data type layer are always simple (unweighted) averages.
- Values at or below the core data type layer will honor custom calculations and weights as per your school & district configuration in JumpRope.
- Filters applied in the left-side option menu are applied before aggregation, even if the value you are filtering on isn't visible in the crosstab.
- If you see 0.00 in a grouped cell, it could be because no values exist in that group.
To help illustrate this, let's look at the "Parent Standard Proficiency across Student Current Grade Level" report as an example.
- The core data type of this report is Parent Standard Proficiency data (the middle layer of the proficiency calculation hierarchy). You can view the raw, un-grouped data being fed into this crosstab by finding the Parent Standard Proficiency report, which is a flat table without additional aggregation.
- The totals per content area and per grade level are simple averages of the value found in the Parent Standard Proficiency table, which is a row per student per parent standard.
- At and below the Parent Standard Proficiency level:
- Child Standard calculation methods, such as the Power Law, Weighted Average, or Decaying Average are honored
- Child Standard weights (if applicable) are honored
- Assessment weights (if applicable) are honored
- If you filter on a field not visible in the report itself (Grading Period, Student Current Grade Level) and apply the filter, the report will recompute based on the selected filters. Any row groups (content area and/or parent standard title) or column groups (grade level) that are completely empty will not be included in the report.
- Any cells that say 0.00 have no values for that particular combination of row and column group.
Some Proficiency Crosstab reports include:
- Parent Standard Proficiency across School - This report shows a row per parent standard with an individual column per school. The average score per school for the parent standard is displayed.
- Parent Standard Proficiency across Student Current Grade Level - This report displays a row per parent standard with an individual column per student grade level. Filters can be applied to display only the desired grade levels and content areas. Displayed is the average score per grade level for the given parent standard.
- Parent Standard Proficiency across Student Gender - This report display a row per parent standard with individual columns for gender (gender identifiers come from data imported from your SIS). Filters can be applied to student current grade level and content area. Displayed is the average score per gender level for the given parent standard.
- Child Standard Proficiency grouped by Content Area across School - This report displays a row per child standard with an individual column per school. Child standards are grouped by parent standard and by content area. Filters can be applied to school, student current grade level and content area.