Pivot Table

Description: This is an abstract for the Pivot Table report, which can compare student, teacher, course and/or site results over 2 years of testing. This report also utilizes assigned performance band colors by default for Illuminate Assessments. There is a “Show Colors” option to disable color display should the bands be too light for the page.

Purpose: Identifies which students went up, down or did not change performance levels on the SBA/CST/CELDT/CMA/Illuminate Assessments and how this impacts AYP.

Navigation: Reports > List Reports > Prebuilts > Pivot Table


Who is the intended audience?

Teachers and Administrators.

What data is reported?

Example: SBA or CELDT performance levels for limited cohorts (the same group of students who earned scores in both of the 2 years featured), or SBA vs. CELDT performance for limited cohorts (students who took both tests).

You can compare any combination of SBA, CST/CMA, CELDT and Illuminate Assessments.

Reading the Performance Level Pivot Table

Total students for row/column run along the outside. The bold blue number reports the number of students who stayed the same. Red numbers are students that dropped from data year 1 to data year 2. Green numbers are students who gained from data year 1 to data year 2. You can click on these numbers to see which students dropped/stayed the same/gained.

How is the data reported?

Each separate report section/page belongs to an individual teacher, course, or site, and performance for all chosen fields combined is reported at the end.

The Band Jumper Data Table shows:

Gain(+): Students who increased a PL from the first dataset selected to the second dataset selected. In this example, 7 students were FBB in 2015 and moved up 1 or more Performance Levels by 2016.

No Change: No change in PL from the first dataset selected to the second dataset selected.

Decline(-): Students decreased a PL from the first dataset selected to the second dataset selected. In this example, 31 students went from Basic in 2015 to either BB or FBB in 2016.

PRE and POST labels indicate which data belongs to which result set.

Performance Level Pivot

Band Jumper Pivot


This report does not show “growth” on the CST. CST tests differ from 1 level/grade to the next (e.g., the 3rd Grade English-Language Arts (ELA) CST is harder for 3rd graders than the 4th Grade ELA CST is for 4th graders). Thus CST improvement in terms of accountability does not necessarily mean growth in achievement. See the STAR Cohort Growth Report if you are interested in growth in achievement. Also, CELDT proficiency is not meant to equate to proficiency on the CST (i.e. state content standards).