đź“‹
Professional Development
  • Welcome to Professional Development at Code Your Future
  • Professional Development Modules
    • Ice-breakers
      • Connect me
      • Move together
      • Cooperative counting
      • Conversation starters
      • Problem solving
      • Gesture relay
    • Fundamentals
      • Week 1 - Introspection
        • Fundamentals W1 coursework
      • Week 2 - Feedback
        • Fundamentals W2 coursework
      • Week 3 - Presentations
        • Fundamentals W3 coursework
    • Welcome and Induction
      • Session 1: Goals and Expectations
      • Session 2: What do developers do?
      • Session 3: SDOT analysis
        • Induction coursework
    • HTML / CSS
      • Week 1 - Developer communication
        • HTML/CSS W1 coursework
      • Week 2 - Active listening
        • HTML/CSS W2 coursework
      • Week 3 - Delivering tutorials
        • HTML/CSS W3 coursework
      • Week 4 - Presentations
        • HTML/CSS W4 coursework
    • JavaScript 1
      • Week 1 - Agile development
        • JS1 W1 coursework
      • Week 2 - Dealing with conflict in teams
        • JS1 W2 coursework
      • Week 3 - Critical thinking
        • JS1 W3 coursework
      • Week 4 - Asking good questions
        • JS1 W4 coursework
    • JavaScript 2
      • Week 1 - Setting up the team
        • JS2 W1 coursework
      • Week 2 - Gathering requirements
        • JS2 W2 coursework
      • Week 3 - Delivery
        • JS2 W3 coursework
      • Week 4 - Presentations
        • JS2 W4 coursework
    • JavaScript 3
      • Week 1 - Difficult Workplace Conversations
        • JS3 W1 coursework
      • Week 2 - How to give and receive feedback effectively
        • JS3 W2 coursework
      • Week 3 - Resilience
        • JS3 W3 coursework
      • Week 4 - Growth Mindset
        • JS3 W4 coursework
    • React
      • Week 1 - Building confidence
        • React W1 coursework
      • Week 2 - Futurespective
        • React W2 coursework
      • Week 3 - SMART goal setting
        • React W3 coursework
      • Week 4 - Guest speaker about career in tech
    • Node
      • Week 1 - Professionalism
        • Node W1 coursework
      • Week 2 - Diversity and inclusion
        • Node W2 coursework
      • Week 3 - 5 Whys Problem Solving
      • Week 4 - Leadership compass
    • SQL
      • Week 1 - Competency-based interviews
        • Databases W1 coursework
      • Week 2 - Learning to sell yourself
        • Databases W2 coursework
      • Week 3 - CVs and transferable skills
        • Databases W3 coursework
      • Week 4 - Applying for jobs
        • Databases W4 coursework
  • Volunteer Roles
    • đźš§The following pages are currently under revision
    • Professional Development Volunteer Onboarding Guide
    • Who are our trainees?
      • Common challenges for trainees seeking Asylum
    • Regional Welfare Lead
      • How to be a great regional welfare lead
    • Professional Development Buddy Role
      • PD Buddy Training
        • Using the GROWS Model for coaching
          • 42 Best GROWS Model Coaching Questions
        • How to form Buddy Groups
        • Buddy Session Plan
        • Individual Buddy Session
          • Buddy Meetings
        • Example PD Buddy Schedule
          • PD Buddy Sessions - Reflective Journalling
            • Wellbeing Task
            • Brag Diary Template
            • Brag Diary Presentations in Buddy Groups
        • Coursework Review
    • Career Mentor Role
      • Career Mentor Timeline
    • Career Mentor Training
      • Career Mentoring- Managing Issues
      • Career Mentoring - Establishing Rapport
      • Career Mentoring- Your 1st meeting
      • Career Mentoring - Ending the Relationship
    • Employment Readiness
    • Professional Development Syllabus Team
  • Additional Resources for Trainees
    • đźš§The following pages are currently under revision
    • Additional Resources for Trainees
    • Adults : ADHD Foundation
      • Reasonable Adjustments for trainees
      • Resources for trainees with ADHD
    • Dyslexia and Coding
      • Changing Your Learning Environment
      • Dyslexia videos
    • English Resources for trainees
      • English Language Guide for Trainees and Graduates
        • Required English Language Level
          • English Language Assessment
        • English Learning Resources
          • English for the Workplace
    • FindYourVoice - Empowerment Storytelling Workshops
      • FindYourVoice - Empowerment Storytelling Workshop 1
      • FindYourVoice Empowerment Storytelling Workshop 2
      • FindYourVoice Empowerment Storytelling Workshop 3
      • FindYourVoice Empowerment Storytelling Workshop 4
    • Reflective Journalling
    • Introspection - Resilience
    • Growth Mindset
    • Working in Teams
      • Break Into Project Teams - Start Team Canvas
      • Resources: Buddy Groups Project
        • Agile Resources
        • Roles in Tech
        • Introspection - Team work
    • Project planning using Kanban
    • 4 L's Retrospective
    • Retro - Challenges of Working in Teams Futurepective
      • Ways to run a Futurespective
    • Pitches and Presenting
      • Presentation session plan
    • Preparing for the Job Market
      • Understanding how the CYF job process works
      • Job Application Workshop
      • Social Media and Self Marketing
    • Tech Industry Tips
    • Skills for in demand jobs
    • CV Tips and Tricks
      • CV Template
      • CV Workbook
    • Applying for jobs
    • Interview Tips and Tricks
    • Interviews
    • Preparing for the Workplace
      • Futurespective
    • Difficult Workplace Situations
    • Leadership Compass
    • đźš«Previous coursework
      • Fundamentals coursework
      • Applied Digital Skills class coursework
      • Induction coursework
      • HTML / CSS coursework
      • JS1 coursework
      • Preparing for the workplace session coursework
      • Interview prep session coursework
      • PD Day 1 coursework
      • PD Day 2 coursework
  • Volunteer Awareness Training
    • Community Safety Training
    • Dyslexia Awareness Training
    • Neurodiversity Training
Powered by GitBook
On this page

Was this helpful?

  1. Professional Development Modules
  2. SQL

Week 1 - Competency-based interviews

PreviousSQLNextDatabases W1 coursework

Last updated 2 years ago

Was this helpful?

Session: Competency-based interviews

Session objective: This session explores the competency-based interview concept, and the STAR framework.

Exercise (5 min)

Exercise objective: To observe implementation of STAR framework for competency-based interviews

Two volunteers pair up. One of them acts as an interviewer, and the other one as interviewee. Interviewer asks the following question: What’s your greatest strength?

Interviewee answers badly. They rush and don't listen, so give the wrong answer and talk about what they would do rather than what they have done. They don't give any examples.

Discuss as a class. What did you think? What did the interviewee do well? What did they do badly?

Exercise (5 min)

Exercise objective: To analyse the implementation the STAR framework for competency-based interviews.

Two volunteers pair up. One of them acts as an interviewer, and the other one as interviewee. Interviewer asks the following question: Can you give me an example of how you’ve dealt with the frustration of things not working.

This time, whenever the interviewee starts doing something wrong, shout STOP! Then explain to the interviewee what they should be doing differently and the interviewee will then try again until they’ve got it right.

Competency-based interviews slides