Final test & Certificate

Choose the best answer for each question.

To pass: at least 8 of 10 correct.

1. Question 1. Why do most HR reports lead to no action?

   ABecause the report doesn't answer any specific question someone actually needsBBecause there isn't enough dataCBecause leadership doesn't care about HR

2. Question 2. What three questions should you answer before adding a metric?

   AWho uses it, what would they do differently if it worsened, who is accountable for itBIs the data available, is it hard to calculate, does it look goodCDo competitors track it, is there an industry standard, does the boss like it

3. Question 3. Which kind of metric gives you time to act?

   ALeading metrics, e.g. 90-day attrition by sourcing channelBOutcome metrics, e.g. full-year attritionCActivity metrics, e.g. training sessions delivered

4. Question 4. Why do most HR metrics only become useful once segmented?

   AAggregates conceal the problem — 12% company-wide can be one department at 35% and the rest at 8%BBecause leadership likes seeing more tablesCBecause reporting rules require it

5. Question 5. What is the key principle for organising a data table?

   AOne row per record, one field per column, no merged cells and no subtotalsBGroup by department so it prints nicelyCOne column per month for easy comparison

6. Question 6. Why should you never join data by name?

   ANames repeat, appear with and without accents, vary in case, and can changeBBecause names are personal dataCBecause Excel can't join on text

7. Question 7. How is attrition for a period calculated?

   ALeavers in the period divided by AVERAGE headcount for the periodBLeavers divided by closing headcountCLeavers divided by opening headcount

8. Question 8. Why is 'attrition 12%' not yet usable?

   AIt has no context: versus the prior period, versus target, or versus another groupBBecause percentages are always confusingCBecause it needs a chart to be clear

9. Question 9. How many layers should a dashboard file have?

   AThree: raw data — calculation — displayBOne sheet, for simplicityCTwo: data and charts

10. Question 10. What structure should you use when presenting to leadership?

    AFinding — hypothesis — proposal — decision neededBRead through the dashboard metrics in orderCExplain the calculation method, then the results