[aplarsen]

At my school, we merge in a bunch of data to create a snapshot of each student for scheduling purposes. We call it the scheduling rubric.

An example is attached below:


Uploaded with ImageShack.us

Each student receives a score on the tests or GPA, and their scores are listed in blue down the left side. The cutscores are listed in a matrix in the middle of the sheet, and the appropriate number of points (1-9) is dropped into the columns on the right. All of the math is done in Excel beforehand. Word is just used to dress it up and create a digestible format for parents.

I'd like to figure out a way to circle the or otherwise identify cutscore that corresponds to the point value that they are receiving on the right side. Otherwise, the 1-9 value appears to come out of thin air. The closest I have come to an idea is to create fields in Excel that are converted into a Wingdings check mark in the appropriate cell. Any other thoughts?