Metashot Interview Report

MetaShot
NIT Volvo Intern
Date and Time

Kartik for NIT Volvo Intern

Candidate Overview

The candidate demonstrates enthusiasm and a basic understanding of Excel’s capabilities, includ-
ing data cleaning and visualization. However, their technical knowledge is limited, lacking details
on advanced features and coherent explanations. While they attempt to explain complex concepts
and emphasize main points, their communication is repetitive and unclear, with frequent filler words.
Improving technical depth and clarity in communication are essential for their development.

Candidate Insights

To succeed in the next interview, prioritize improving technical knowledge, particularly in using pivot
tables and data validation in Excel, and focus on delivering clear and concise explanations using
structured responses. Acknowledge your understanding of data cleaning and visualization but work
on reducing filler words and organizing your thoughts before speaking.

Metashot Technologies
admin@metashot.org
kartik_m241057me@nitc.ac.in
POC email
Overall Performance

Final Band Score 2.9/9

Category Scores

Category Weight Band Score

Technical Knowledge 50% 2.7/9

Communication 50% 3.0/9

Technical Knowledge Evaluation

Strengths:
• Experience in using Excel for various tasks.
• Evidence of practical experience in the automotive sector.
• Currently pursuing M. Tech in a relevant area.
• Experience with taking up and completing projects.
• Quick learner.

Weaknesses:
• Did not demonstrate in-depth technical knowledge relevant to the job description.
• Lacked examples of specific technical achievements or projects.
• Did not relate technical background to the job responsibilities.
• Lack of specific technical skills mentioned.
• Candidate skipped 4 questions, indicating knowledge gaps in certain areas

Improvement Suggestions:
• Learn about and utilize pivot tables for summarizing large datasets.
• Improve the structure and clarity of explanations.
• Research specific initiatives
• Provide specific examples of technical projects.
• Relate technical skills to job requirements.

Communication Evaluation

Strengths:
• Clear articulation of their background education and career progression.
• Chronological and logical presentation of past experiences.
• Good use of concise language to convey career history.
 • Honesty about weaknesses.
• Expresses a willingness to learn quickly.

Weaknesses:
• Lacked a clear and logical structure in explanations.
• Lacked detail in explaining roles and achievements, particularly in previous jobs.
• Did not connect previous experiences with potential contributions to the prospective job.
• Limited elaboration on skills developed and how they pertain to the internship role.
• Lack of detailed examples to support claims.

Improvement Suggestions:
• Practice delivering clear and concise explanations.
• Organize your thoughts before speaking.
• Structure responses more clearly.
• Provide more details on job roles and achievements.
• Link past experiences to potential job contributions.

Metashot Technologies
admin@metashot.org
kartik_m241057me@nitc.ac.in
POC email
MS Office

Question 1:How would you use Excel to analyze and visualize large datasets in your field of ex-
pertise?

Expected Answer:I would use Excel to clean, filter, and sort large datasets efficiently. Pivot tables
help summarize and extract key insights, while charts like histograms, scatter plots, and trendlines
visualize patterns. Additionally, conditional formatting and data validation ensure accurate interpre-
tation of the data.

Candidates Answer:So Excel definitely helps in analysing the data. So once we get the data in a
raw excel format, we need to clean the data. So that can be done using excel and there are lot
of tools MATLAB and many more. Then in excel we can plot we can plot the data then we can by
plotting the data data we can get the key understandings of the data and we can. In the VBA to
there is a VBA tool in Excel which can be which leverages the capacity of the XA.

Question Evaluation

Band Score: 5.5/9

Category Band Score

Technical Knowledge 6.2/9

Communication 4.7/9
Question 2:Can you explain the use of pivot tables and VLOOKUP in Excel?

Expected Answer:Pivot tables allow dynamic summarization of large datasets by grouping, filtering,
and aggregating values, making analysis faster. VLOOKUP is used for searching specific data in a
table by matching values from a reference column. Together, they enhance data retrieval, compar-
ison, and decision-making processes.

Candidates Answer:So I basically have a 3 years of experience in Tata Motors RLD. So there I have
used excel, have used some of the tools like we look up. Then I used to use some formulas to do
mathematical calculations. Then I used formulas in excel the to calculate some design require-
ments. Apart from that plotting of the graphs the use charts, scatter plots. There's where some
of the tools that I use in the Excel. Yes pivot tables. Once we have our data we can put up pivot
table. So with the help of pivot table we can get the key understandings of the data. So like you can
arrange the data as a pivot table in terms of rows or columns. Then you can sum up the data. Then
you can count the data. With the help of pivot table we can summarise the data then we look up if
we did we. Data in 2 different sheets. Then we can compare the 2 different data sheets. Then we
can merge or we can get the required. We can get the data required from one sheet to the other
considering one of them as one of the column as a reference column, yes.

Question Evaluation

Band Score: 5.3/9

Category Band Score

Technical Knowledge 5.7/9

Communication 5.0/9
General Company Questions

Question 1:What is Volvo’s approach to sustainability and electric vehicles?

Expected Answer:Volvo is committed to becoming a fully electric car company by 2030 and aims to
be climate-neutral by 2040. They have introduced models like the Volvo XC40 Recharge and EX30,
emphasizing recycled materials, sustainable production processes, and reduced carbon footprints
in their supply chain.

Candidates Answer:Show Volvo is one of the top automobile manufacturer company in the world.
Now it's moved towards sustainability. As the world is moving towards sustainability and electric
vehicles, Volvo is taking a lead in electric vehicles and in sustainability. Currently I'm not aware of
specific initiatives. Definitely I will look on that.

Question Evaluation

Band Score: 5.6/9

Category Band Score

Technical Knowledge 4.7/9

Communication 6.5/9
Self Evaluation

Question 1:Can you tell me about yourself?

Expected Answer:

Candidates Answer:Yes, so I am Karthik Kulkarni. I am basically from North Karnataka Kulbhar

ka district. I completed my schooling from there itself. Then I moved to Hubli to pursue my BE
specialized in mechanical engineering. Then through placement I worked for 3 years on site Tata
Motors Pune in automotive sector in commercial vehicle specifically. Then in 2023 I cracked the
gate then now I am pursuing. M Tech in NIT, Calicut.

Question Evaluation

Band Score: 6.0/9

Category Band Score

Technical Knowledge 0.0/9

Communication 6.0/9
Question 2:What are your three strengths and three weaknesses?

Expected Answer:

Candidates Answer:Strength is if I took up, if I take a project by hook or crook, I will complete it
then I like R&D roles because I am interested in research. Then I'm a quick learner. My weaknesses
include. I think these are only 2

Question Evaluation

Band Score: 5.2/9

Category Band Score

Technical Knowledge 5.0/9

Communication 5.3/9
Extracurricular

Question 1:What are your hobbies? Which is your favourite and why?

Expected Answer:

Candidates Answer:Samay hobbies include playing sports than travelling. Time travelling. So trav-
elling helps me to explorer my thoughts, engaging with nature and explorer different areas, different
traditions, different culture. So this would be really this which I'm very fond of.

Question Evaluation

Band Score: 4.5/9

Category Band Score

Technical Knowledge 1.0/9

Communication 4.5/9
Basic Mechatronics

Question 1:What is the role of sensors and actuators in a mechatronic system?

Expected Answer:Sensors detect environmental changes and convert them into signals, while ac-
tuators respond to control signals by performing mechanical actions. For example, a temperature
sensor in an HVAC system detects temperature changes, and an actuator adjusts the air con-
ditioning accordingly. Together, they form the foundation of automation and intelligent control in
mechatronic systems.

Candidates Answer:Skill skipped by candidate

Question Evaluation

Band Score: 0.0/9

Category Band Score

Technical Knowledge 0.0/9

Communication 0.0/9
Question 2:Explain the working of a PID controller and its applications in automation.

Expected Answer:A PID (Proportional-Integral-Derivative) controller continuously calculates an er-

ror value and applies corrections to stabilize a system. The proportional term responds to present
errors, the integral term corrects past errors, and the derivative term anticipates future errors. It is
widely used in robotics, motor control, and process industries for precise control.

Candidates Answer:Skill skipped by candidate

Question Evaluation

Band Score: 0.0/9

Category Band Score

Technical Knowledge 0.0/9

Communication 0.0/9
Basic Electronics

Question 1:Explain the difference between analog and digital circuits with practical applications.

Expected Answer:Analog circuits process continuous signals, while digital circuits work with dis-
crete binary signals (0s and 1s). Analog circuits are used in applications like audio amplification,
whereas digital circuits are found in computers and microcontrollers. Digital systems offer better
noise resistance and are more scalable in modern electronics.

Candidates Answer:Skill skipped by candidate

Question Evaluation

Band Score: 0.0/9

Category Band Score

Technical Knowledge 0.0/9

Communication 0.0/9
Question 2:Explain the significance of power factor correction in industrial applications.

Expected Answer:Power factor correction improves the efficiency of electrical systems by reducing
reactive power and minimizing power losses. Low power factor leads to increased electricity costs
and inefficient power usage, so capacitors or active PFC circuits are used to improve it. Industries
benefit from reduced energy bills and enhanced performance of electrical equipment.

Candidates Answer:Skill skipped by candidate

Question Evaluation

Band Score: 0.0/9

Category Band Score

Technical Knowledge 0.0/9

Communication 0.0/9
Candidate Improvement Guide

Pivot Tables

Focus Area: Technical Knowledge

Learn about Pivot Tables

Watch a tutorial on creating and utilizing pivot tables in Excel.
https://www.youtube.com/watch?v=6m9qPxm7e8A

Practice Pivot Tables

Create a sample dataset and use pivot tables to summarize the data.

Resources:
Excel Pivot Tables Tutorial: https://www.excel-easy.com/data-analysis/pivot-tables.html

Clarity and Structure

Focus Area: Communication Skills

Watch a Tutorial on Clear Communication

Watch a video on how to deliver clear and structured communications.
https://www.youtube.com/watch?v=1KZGF4EpGJg

Practice Structured Responses

Write down responses to common interview questions, focusing on clarity and structure.

Resources:
Harvard Communication Tips: https://hbr.org/2015/08/how-to-improve-your-communication-skills
Data Validation and Conditional Formatting

Focus Area: Technical Knowledge

Learn Data Validation

Read an article on data validation in Excel.
https://www.contextures.com/xlDataVal01.html

Practice Conditional Formatting

Follow a tutorial and apply conditional formatting to a sample dataset.
https://www.youtube.com/watch?v=2By9yKNnDbo

Resources:
Excel Conditional Formatting: https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-informa-
tion-ef9c9e1d-9f0d-4d0d-9da7-6cc3f6d76c3e

Basics of Mechatronics

Focus Area: Technical Knowledge

Study Fundamentals of Mechatronics

Read an introductory guide on mechatronics.
https://www.engineeringenotes.com/mechatronics/mechatronics-introduction/36530

Review Key Concepts

Create a summary of key concepts and terms in mechatronics.

Resources:
Mechatronics Guide: https://www.efunda.com/DesignStandards/mechatronics/mechatronics_intro.cfm

Reducing Filler Words

Focus Area: Communication Skills

Learn Techniques to Minimize Filler Words

Watch a video on reducing filler words in speech.
https://www.youtube.com/watch?v=GJz66wm95-M

Practice Speaking Without Fillers

Record yourself answering interview questions and identify any filler words used.

Resources:
Reducing Filler Words Guide: https://www.scienceofpeople.com/filler-words/
Basics of Electronics

Focus Area: Technical Knowledge

Study Fundamentals of Electronics

Read an introductory article on basic electronics.
https://www.electronics-tutorials.ws/

Review Key Concepts

Create a summary of key concepts and components in basic electronics.

Resources:
Basic Electronics Tutorials: https://www.electronics-tutorials.ws/

Focus Area: Technical Knowledge & Communication Skills

Research Job-Specific Technical Skills

Identify and research key technical skills required for the job.

Prepare Examples
Prepare specific examples of past projects or coursework that demonstrate these skills.

Resources:
Job Skills Research: https://www.careerbuilder.com/advice/how-to-identify-your-job-skills

Final Tips

Consistency: Practice consistently each day to build and reinforce your skills.

Feedback: Seek feedback from peers or mentors to identify areas of improvement.

Mock Interviews: Set up mock interviews to practice and refine your responses.

Keep up the hard work and stay focused on your improvement areas. With dedication and practice, you'll see significant
progress in your interview performance. Good luck!

Metashot Technologies
admin@metashot.org
kartik_m241057me@nitc.ac.in
POC email