MetronicMetronic

دليل

نموذج تقييم المهارات: ملف CSV جاهز للاستخدام ومقياس فعال حقًا

يحول نموذج تقييم المهارات قائمة غامضة من الكفاءات إلى شبكة مسجلة يمكنك اتخاذ إجراء بناءً عليها. إليك ملف CSV مجاني يحتوي على الأعمدة الهامة، ومقياس من 0 إلى 4 مع واصفات سلوكية، وصف مثال عملي.

What a skills assessment template is for

A skills assessment template is a structured sheet for scoring the capabilities a role needs against the capabilities the people in that role currently demonstrate. The goal is not a number for every person; the goal is a short, ranked list of gaps worth closing.

Most templates fail because they mix too many ideas in one row, use a 1-5 scale with no behavioural descriptors, or leave the evidence column blank. The template below fixes all three: one competency per row, a 0-4 scale with plain-language levels, and a required evidence method.

The 0-4 competency scale

Five levels, 0 to 4, with behavioural descriptors. Resist half-points; the precision is imaginary and it slows scoring down.

LevelNameWhat it means in practice
0NoneNo exposure. Would not know where to start.
1AwareKnows the concept exists and where to look it up. Cannot do it unaided.
2AssistedCan do it with a checklist, a template, or someone to check the work.
3IndependentDoes it unaided at the expected quality and speed. The target for most roles.
4TeachesHandles the edge cases, improves the process, and trains others.

The template columns

One row per skill. The weighted-gap column does the prioritising for you: gap × criticality. Keep the skill list between six and twelve per role.

ColumnWhat goes in it
Skill or competencyOne observable capability, phrased as something a person does
Behavioural definitionThe specific behaviour that proves the skill
Criticality (1-3)How much the business hurts when this skill is weak
Required level (0-4)Target for this role
Current level (0-4)Evidenced where possible
GapRequired minus current, never below zero
Weighted gapGap × criticality — your sort column
Evidence methodAssessment, call review, work sample, observation
Evidence sourceWhere the current level came from
ActionTrain, coach, document, hire or accept
OwnerThe person accountable for the action
Re-assess dateWhen you will measure the same skill again

هل تريد أن يُقاس عمود المستوى الحالي نيابة عنك؟ يحوّل Metronic مستنداتك الخاصة إلى تقييمات قصيرة ويُبقي النتائج محدّثة.

ابدأ مجاناً — 200 رصيد مجاني

A worked example row

The row below shows how the template works for a support team. The weighted gap of 6 tells you this skill outranks others even when the raw gap is the same size.

SkillDefinitionCriticalityRequiredCurrentGapWeightedEvidenceAction
Handles a refund dispute without escalationResolves the dispute within policy, keeps the customer, and documents the outcome33126Q3 assessment — 41% correctTrain with spaced repetition

How to keep the assessment honest

  • Score one skill at a time across all people, not one person at a time across all skills. The comparison set stays fixed and the scores become more consistent.
  • Back critical skills with evidence, not manager impression. A short assessment, work sample, or observation produces a number someone else could reproduce.
  • Record the evidence source in the sheet. A current level without a source becomes a guess within one quarter.
  • Re-assess the same skill with the same instrument. A different question or different rater makes improvement impossible to prove.

From the template to continuous assessment

A spreadsheet is the right place to start, but the current-level column ages quickly. Metronic turns the template into a living score: upload the material a role depends on, generate questions from it, and the platform keeps asking the questions that matter until people reach mastery.

The result is the same grid, except the current level refreshes itself instead of waiting for the next survey round.

حمل نموذج تقييم المهارات

ملف CSV جاهز للتعبئة بمقياس 0-4، واثني عشر عمودًا، وصف مثال واحد مملوء ليكون التنسيق واضحًا. لا يتم تخزين أي شيء ولا يتطلب الأمر بريدًا إلكترونيًا.

ماذا يوجد في الداخل

  • Skill, behavioural definition and criticality columns
  • Required and current level columns with the 0-4 scale
  • Auto-calculated gap and weighted gap for sorting
  • Evidence method, evidence source, action, owner and re-assess date
  • One worked example row across a support scenario

الأسئلة المتكررة

What should a skills assessment template include?

At minimum: skill, behavioural definition, criticality, required level, current level, gap, weighted gap, evidence method, evidence source, action, owner and re-assess date. The downloadable template on this page includes all of these plus the 0-4 scale.

What scale should a skills assessment use?

A 0-4 scale with behavioural descriptors. It has a real midpoint, avoids false precision, and makes scoring almost mechanical once the descriptors are agreed.

How many skills should be assessed per role?

Six to twelve. Beyond twelve, managers cannot hold the model in their heads and scoring quality drops.

Who should score the current level?

For low-criticality skills, the line manager. For critical skills, use an objective instrument such as a short assessment, work sample or structured observation.

Can I use this template in Excel or Google Sheets?

Yes. The CSV opens in any spreadsheet. The columns are plain text so you can sort, filter and share without reformatting.

جرّبه باستخدام المواد الخاصة بك

يحوّل Metronic مستندًا أو إجراءً تشغيليًا معياريًا (SOP) أو موقعًا إلكترونيًا إلى تقييم منظم ومُصنف ضمن إطار الكفاءات الخاص بك — ثم يستمر في طرح الأسئلة المهمة حتى يتذكرها الأشخاص.

ابدأ مجانًا

أدلة ذات صلة

كتبه فريق Metronic. هل لديك ملاحظات حول هذا الدليل؟ info@metronic.ai