Assesment tool in Excel..!
I just wanted to create a self-assesment tool in excel with an easy user-interface. The basic features I wanted are
i. The user should have a list of dimensions and attributes against them to select
ii. He should be able to select the set of attributes, he fits in by just double-clicking on it and get the final score.
iii. As a evaluator, I should be able to add any number of dimensions with any number of attributes against them.
iv. I should also be able to scale the scoring to anything I want.
In the Example (provided in the downloadable sheet), I’ve taken a self-evaluation of a Software-tester. I’ve chosen the following dimensions
Years of Experience(10)
Time/Job Ratio(6)
Testing Concepts(5)
Domain Knowledge(4)
Analytical Ability(5)
Automation Tools(5)
Perl Scripting(9)
Shell Scripting(7)
Certifications(4)
Soft-Skills(5)
Each dimension is available with different number of stages as given above. I’ve chosen the scale as 10 for all the dimensions. For example, if you rate yourself in the 4th stage in ‘Testing Concepts’ you will score 8 in scale of 10. Please feel free to use this sheet for your evaluation purpose..Download the sample here…
In my next post, I’ll explain how to add a dimension and the code behind.
Please note, I developed the above in MS Excel 2007…. 
Tags: Analysis, Assesment tool, Markish, Project Management, VBA
