-
Excel workbook preview
Recruitment and Selection
Job Analysis Worksheet (O*NET tasks, skills and work context)
3 downloads per free account, no card needed.
Who this is for
An HR adviser asked to define a new or changed role, or to show which functions are essential when an accommodation or selection test is questioned.
What is inside
- Tasks sheet: 11 sample tasks from O*NET 43-4051.00 and an SME panel, rated 1 to 5 for frequency and importance
- Live formulas: criticality = frequency x importance, Essential or marginal flag, total share of time turns red unless 100%
- KSAs sheet: 9 knowledge, skill, ability and work style rows with a calculated criterion type (essential, desirable, train in post)
- Work Context sheet: 8 factors with frequency dropdown and adjustments already available
- Dropdowns on ratings, sources and types; 16 blank rows per sheet, freeze panes and filters
- How to use sheet with the six-step method and the O*NET CC BY 4.0 credit
How to use it: Ask 2 to 4 job holders and the manager to rate each task, then copy the essential tasks into the job description and the essential KSAs into the person specification.
Files & formats
- XLSXjob-analysis-worksheet-template.xlsx15 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves. These templates are original working documents built on the public law or guidance named here. They are not legal advice and are not endorsed by the government body or publisher.

