Structured Interview Question Bank for Hospitality Positions: Behavioural and Situational Interview Questions with Scoring Anchors and Candidate Comparison
Full description
For hospitality managers and HR leads who hire service, host and cashier, kitchen, banquet, room service and supervisor staff and want interviews that can be compared. The bank holds 240 behavioural, situational and technical questions, 40 for each position family, mapped to ten competencies. Each question has an anchor for a strong, adequate and weak answer, and a follow-up probe. Two interviewers score each candidate from 1 to 5, and the workbook weights the competencies by position, finds the lowest competency, flags score gaps and returns Recommend, Hold, Decline or Incomplete, with decision timing and a hiring funnel. The Word guide gives the method, an interview plan, fair-question rules, a reference script and print-ready forms.
What is inside
- Interview_Question_Bank_and_Candidate_Scorecard.xlsx: 7 tabs, 1,299 formulas, 2 native charts, 21 drop-down and input rules, 8 integrity checks
- Question Bank: 240 questions, 40 for each of 6 position families, with 10 competencies, 91 behavioural, 100 situational and 49 technical, each with anchors for 5, 3 and 1 and a follow-up probe; 72 core questions marked; 20 spare rows
- Settings: thresholds, weights for 10 competencies by family, hiring funnel and core set coverage. Interview Scores: 35 sample scoring rows plus 25 spare rows with score gaps and row status calculated
- Candidate Comparison: 18 sample candidates plus 12 spare rows; averages by competency, weighted score, lowest competency, gaps, result, rank, decision timing and decision check calculated
- Dashboard with 8 tiles, results by position family, the top five candidates, scores by competency and 2 charts
- Interview_Guide.docx and PDF: 7 pages with the method, scale, interview plan, sample question cards, fair question table, reference script, scorecard and decision forms, a worked example and common mistakes
- README.txt and LICENSE-and-Terms.txt
How it works
- Set the thresholds and the competency weights for each position family on Settings.
- Filter the bank by family and mark the core questions to use for every candidate.
- Enter each interviewer scores for each candidate after the interview.
- Read the result and the score gaps, record the decision and review the dashboard.
Details
- Formats: 1 Excel workbook (.xlsx), 1 guide in Word (.docx) and PDF, English
- Software: Excel 2016 or later, or LibreOffice Calc 7 or later
- No macros, no external links, no data tables, no array formulas
- 3 files plus README and license; instant digital download
Good to know
- Sample candidates and scores are illustrative and shown by code only. Replace them with your own.
- Weights, thresholds and anchors are examples. This is a management tool, not legal advice: check your local employment rules and take advice from your HR adviser or legal counsel.
- Single-user license. Do not redistribute.
FAQ
How many questions are included?
240 questions: 40 for each of 6 position families, with 91 behavioural, 100 situational and 49 technical.
What are the score anchors?
Each question describes what a strong (5), adequate (3) and weak (1) answer sounds like. Scores 2 and 4 sit between them.
How is the result worked out?
It averages the two interviewers for each competency, applies the family weights and compares the total with the hire and hold thresholds, with a minimum score for any competency.
Can I add my own questions and positions?
Yes. There are 20 spare question rows and 12 spare candidate rows, and the weights on Settings can be changed for each family.
Do I need macros?
No. Every result is a standard worksheet formula.
