Analyzing rubric results using Excel

Once you have entered your rubric scores in Excel, you'll need to summarize them to get a sense of how students are performing on a given learning outcome, or dimension of an outcome. At the link below you can find a guide to analyzing rubric scores using Excel pivot tables:

And the Excel file below contains mock rubric data that can be used for practice with the pivot table guide, or as a template for entering your own rubric data:

For questions about the guide, or for additional guidance and tips on analyzing and interpreting rubric results, please feel free to contact our office at assessment@lmu.edu.

Next: Example rubrics Return to Rubrics home page