Skill Matrix with various Technology
I am creating a skill matrix for my team in a excel sheet. My team consists of Developers & Testers.
I've included Technologies (like Phyton, cobol etc), Testing, Tools (jira) & Methodology (Agile) and asked my team to provide rating against their name from 1 to 3 (1=no knowledge;2=intermediate;3=Expert). I am also planning to take overall score at the end.
Question: A developer maybe not require to complete testing skills right likewise a tester maybe not required to have computer language skills. How shall I calculate average & overall skill score due to gap in skills based on role?
Update: Definitely, this is not a homework assignment I am working as a PM and want to create a skill matrix so I could prepare & build required skills for my team as we're about to start on a new project.
If someone rate him/her as 4 in any of skill, he/she may train others. Team had provided me data with their rank. I want to understand how to visualize & reveal weakness or strength.
Are there any standard practice? Does it make any sense now?
What is the value of an overall score? Why degrade a person's skill score by averaging other lower or non-existent skill scores that have little to no bearing on that person's tasks. What value does an overall, and apparently averaged, score provides?
Let's use pilots as an example. One pilot is scored flying fixed-wing because he's rated in fixed-wing and another in rotary-wing because that is her rating. What does it tell us if we lowered their skill rating vis-a-vis a mean average in their respective aircraft due to their non-existent skill, and rating, in the other aircraft?