Wednesday, December 19, 2012

Evaluation Performance Graph in Excel

I have created an Excel file which provides a visual of standard and scale scores for evaluations.  I have a lot of parents who find all the scores from tests confusing, so I made this to help them understand. All you have to do is enter the student information and then enter the test name and standard or scale score and Excel will graph the score beside it. The student's age will be automatically calculated from the date of birth and report. You can download this file DxGraph.xlsx from ge.tt here. Comment if you have any suggestions. 



12 comments:

  1. This is just what I've been needing! Thanks!

    ReplyDelete
  2. omgosh! this is amazing! thank you for sharing this!

    ReplyDelete
  3. So, SO wonderful. Thanks! I have a paper version that I just draw lines all over, which ends up almost as confusing. This will be a significant improvement.

    ReplyDelete
  4. Thank you - looking forward to trying it out! I have been playing around trying to find a visual that helps when reviewing test results with parents. This looks like it will be a step up from what I have come up with so far. :) I usually highlight the "average range" on the graph to help parents zero in on (remember) what is 'normal limits'. -Cassandra

    ReplyDelete
  5. I like it! Going to have to see how it works --- I have 3 reports I need to type and 2 more evaluations I need to do.

    ReplyDelete
  6. Mahalo nui loa for this! I, too, have reports to try this out on and will let you know how the SLP with techno-itis does! Aloha from the Big Island! (Word Press called me "Anonymous"--how rude!)

    ReplyDelete
  7. He mea iki (hopefully that is your welcome). :-) Let me know any problems and I should be able to fix it with a new version.

    ReplyDelete
  8. What a great visual for parents - can't wait to try it out.

    ReplyDelete
  9. I shared another version of this file with an adjustable highlighted region in my post today.

    ReplyDelete
  10. This is exactly what I need, but it won't open correctly. HELP! What am I doing wrong?

    ReplyDelete
  11. Found it on your new blog! =) Thanks!!!

    ReplyDelete