50-01 Annex E - Applicant Scores Excel Spreadsheet Template
Cadets and Junior Canadian Rangers Group Instruction (CJCR Gp Inst)
CAN PROTECTED B (when completed)
Annex X to: REO O-XXXXX Selection Board Report
5323-3 (J1 staff officer / J1 Employment)
| Applicant: | Applicant 1 |
|---|---|
| Date: | 03-Nov-21 |
| Does the applicant meet the essential requirements for this REO: | Yes |
Applicant Review Phase
Required Experience and Qualification
| Competency Remarks | Eval Method | Points | Weight | Total Potential Points | Points allocated by each Board Member (BM) | Total Score | ||
|---|---|---|---|---|---|---|---|---|
| Total BM 1 | Total BM 2 | Total BM 3 | (BM 1 + BM 2 + BM 3) / 3 | |||||
| 2G1 | Application | 5 | 1 | 5 | 3 | 3 | 4 | 3.33333 |
| 2G2 | Application | 5 | 2 | 10 | 9 | 9 | 6 | 8 |
| 2G3 | Application | 5 | 3 | 15 | 13 | 13 | 15 | 13.6667 |
| etc. | Application | 5 | 2 | 10 | 7 | 6 | 7 | 6.66667 |
| Subtotal (A) | 31.6667 | |||||||
| Percentage | 79.17% | |||||||
Secondary Requirements & Past Performance
| Competency Remarks | Eval Method | Points | Weight | Total Potential Points | Points allocated by each Board Member (BM) | Total Score | ||
|---|---|---|---|---|---|---|---|---|
| Total BM 1 | Total BM 2 | Total BM 3 | (BM 1 + BM 2 + BM 3) / 3 | |||||
| 3A | Application | 5 | 1 | 5 | 5 | 4 | 3 | 4 |
| 3B | Application | 5 | 2 | 10 | 8 | 7 | 7 | 7.33333 |
| 3C | Application | 5 | 3 | 15 | 7 | 10 | 8 | 8.33333 |
| etc. | Application | 5 | 2 | 10 | 2 | 4 | 5 | 3.66667 |
| Past Performance | Application | 25 | 1 | 25 | 20 | 20 | 20 | 20 |
| Potential Ranking | Application | 25 | 1 | 25 | 20 | 22 | 21 | 21 |
| Subtotal (B) | 64.3333 | |||||||
| Percentage | 71.48% | |||||||
Interview
| Competency Remarks | Eval Method | Points | Weight | Total Potential Points | Points allocated by each Board Member (BM) | Total Score | ||
|---|---|---|---|---|---|---|---|---|
| Total BM 1 | Total BM 2 | Total BM 3 | (BM 1 + BM 2 + BM 3) / 3 | |||||
| Q1 | Interview | 5 | 1 | 5 | 5 | 5 | 5 | 5 |
| Q2 | Interview | 5 | 2 | 10 | 8 | 7 | 8 | 7.66667 |
| Q3 | Interview | 5 | 3 | 15 | 10 | 12 | 11 | 11 |
| Performance potential | Assignment | 25 | 0.25 | 6.25 | 5 | 5 | 5 | 5 |
| Subtotal (C) | 28.6667 | |||||||
| Percentage | 79.08% | |||||||
Applicant: Applicant 1
| Total Weighted Score | Score | Weight | Weighted Score |
|---|---|---|---|
| Required Experience and Qualification (A) | 79.17% | 50% | 39.58% |
| Secondary Requirements & Past Performance (B) | 71.48% | 20% | 14.30% |
| Interview (C) | 79.08% | 30% | 23.72% |
| Total Score | 77.60% | ||