Skip to main content

Skill Deck

Task 1

Create a sample L&D heat map (even with dummy data) showing skill gaps for 3 functions (e.g., Sales, IT, HR).

Task

List 3 core competencies and identify possible training interventions for each.Place 2 employees (real/dummy) into the Skill-Will Matrix and suggest L&D actions.

Task 1

Create a sample L&D heat map (even with dummy data) showing skill gaps for 3 functions (e.g., Sales, IT, HR).

Task

List 3 core competencies and identify possible training interventions for each.Place 2 employees (real/dummy) into the Skill-Will Matrix and suggest L&D actions.

Task

Build an Excel dashboard for 20 employees, showing:Recruitment source mix,Offer-to-join ratio,Attrition rate,Average training hours.Use at least one formula (COUNTIF/AVERAGEIF) and one chart

Task

Import a dataset of 30 employees (dummy HR data – Name, Department, DOJ, Salary, Attrition status).Create a Power BI dashboard with visuals showing:Attrition by department,Gender diversity,Average salary by role.Add at least two slicers (e.g., by Department, by Gender)

Task

Create a Balanced Scorecard for one department (e.g., HR, Sales).Write 1 Objective + 3 Key Results (OKRs) for your own role or team.Identify 3 KPIs for recruitment performance.

Task

Design an appraisal form for one role (include competencies + performance indicators).Choose one appraisal technique (e.g., 360° feedback, BARS) and explain how you’d apply it in your organization.Write one example of a competency-linked KPI (e.g., “Communication competency → % of client calls handled without escalation”).

Task

Create a Balanced Scorecard for one department (e.g., HR, Sales).Write 1 Objective + 3 Key Results (OKRs) for your own role or team.Identify 3 KPIs for recruitment performance.

Task

Design an appraisal form for one role (include competencies + performance indicators).Choose one appraisal technique (e.g., 360° feedback, BARS) and explain how you’d apply it in your organization.Write one example of a competency-linked KPI (e.g., “Communication competency → % of client calls handled without escalation”).