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 |