How to use pivot tables to analyze a MAP Growth data export

Document created by Community User on Jul 29, 2016Last modified by Community User on Jun 6, 2017
Version 13Show Document
  • View in full screen mode
Introduction
This article provides two examples of how you can use pivot tables in Excel to analyze your MAP Growth comprehensive or combined data files (CDF).

Steps
The following instructions and examples are provided as a courtesy to assist you in getting the most out of your data exports. NWEA Partner Support cannot assist in troubleshooting pivot tables in Excel. For in-depth assistance and troubleshooting, contact support for Microsoft Excel.

 
To begin a pivot table:

  1. Open a MAP Growth export CSV file (AssessmentResults.csv or ComboStudentAssessment.csv).
  2. From the Insert tab, select PivotTable.
    Screenshot of the Insert Pivot Table button in the Insert tab in Excel.
  3. In the Create PivotTable window, verify that all of your data has been selected. The default settings are usually sufficient. Click OK.
    Screenshot of the Create Pivot Table dialog in Excel with default settings selected.
A blank pivot table should appear, with the PivotTable Fields section on the right. You can drag and drop fields from the top section to the Filters, Columns, Rows, or Values sections at the bottom.

Screenshot of Excel with a blank pivot table and various options on the right.

 
Example table: How many assessments were given at each school?

  1. Drag SchoolName from PivotTable Fields to Rows.
  2. Drag Discipline to Columns.
  3. Drag TestRITScore to Values.
  4. Under Values, select the drop down menu Sum of TestRITScore and select Value Field Settings...
    Screenshot of menu after clicking Sum of TestRITScore.
  5. Under Summarize Values By choose Count. Click OK.
You should now have a pivot table showing how many tests were administered in each subject in each school, as well as totals.

Pivot table in excel with a row for each school and a column for each subject, showing how many tests were taken.

Example table: What is the average RIT score by grade, school, and subject?

This example requires a combined data file (instead of comprehensive).
  1. Drag SchoolName to Rows.
  2. Drag Grade to Rows, below SchoolName.
  3. Drag Discipline to Columns.
  4. Drag TestRITScore to Values.
  5. Under Values, select the drop down menu Sum of TestRITScore and select Value Field Settings... (see screenshot in previous example).
  6. Under Summarize Values By, choose Average. Click OK.

You should now have a pivot table showing the average RIT score for each grade and subject at each school.

Screenshot of pivot table with a row for each school and grade, and a column for each subject, showing the average RIT scores.

For more information about pivot tables, see Overview of PivotTable and PivotChart reports at Office.com.

Article Number
3137

Outcomes