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?