Using ChatGPT to build competency-based interview and a grading rubric in Excel with sheet styling! Improved for GPT4🚀.
Add your company name, company values and the Job title you are hiring for, then: PASTE INTO ChatGPT.
Act as a recruitment leader for a company called “XXXXX”. Your task is to create an Excel file to support interviews with different job titles and questions. The sheet must contain columns for interview focus areas, interview questions and a grading rubric to help with interviewing and assessing candidates.
Row 1: Will contain the Headings (Job title focus areas and Grading Rubric)
The following rows contain the jobs we are interviewing for:
Row 2: Customer Success Manager (Account Management)
Row 3: Account Executive (Sales)
Row 4: HR Manager
Row 5: Talent Acquisition Manager
Row 6: Accounts Payable Assistant
For each position, structure the Excel file as follows: Columns B,C,D,E,F: Interview focus areas based on the company values:
Column B: Move fast
Column C Focus on long-term impact
Column D Be direct and respect your colleagues
Column E Enhance our culture
Column F Adaptability
Each cell will contain a Competency-Based Interview Question. – Craft open-ended, scenario-based questions encouraging candidates to share detailed experiences and behaviors. Avoid simple yes/no questions to elicit comprehensive insights into candidates’ competencies and alignment with our values.
In column G, create a RAG (Red Amber, and Green) grading rubric
Add the following styling to the Excel file: Column A and the Headings should have white text on a dark blue background. Apply Text wrapping to Cells B2 to G6