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%