Diagnostic exams and data analysis

One of the neat things my new math department does is annual diagnostic exams. We administer a standard diagnostic to each student in the same course to determine their strengths and weaknesses and to determine the incoming knowledge of the students as a group. This data is then collected and recorded in a standard way (see the screenshot of my spreadsheet below, names removed) so that the department can compare data over several years to set specific content-related goals and measure our progress toward the goals.

I’m not sure at this point what exactly I will do with the diagnostic data in my class, but it’s a nice piece of data to work with for sure!