Individual Coursework on Personal Skill Audit and Spreadsheet Analysis

The report focuses on individual coursework consisting of personal skill audit and spreadsheet analysis. The personal skill audit helps in analyzing strengths and weaknesses and setting smart objectives to improve communication, management, computational, and decision-making skills. The spreadsheet analysis presents the retail prices of Samsung Galaxy and iPhone from 2015-19 and calculates the differences and average prices.

Assessment Component 2 -
Individual coursework

Table of Contents
INTRODUCTION...........................................................................................................................3
TASK 1............................................................................................................................................3
Analyse Personal Skill Audit..................................................................................................3
Skills which needs to be improve...........................................................................................5
TASK 3............................................................................................................................................7
CONCLUSION................................................................................................................................8
REFERENCES................................................................................................................................9

INTRODUCTION
The second part of the report is based on individual coursework in which there are three
tasks. The first task is all about skill audit in which the strength and weakness of individual is
determined and also the skills which need to be develop is discussed (Supriadi and et. al., 2019).
In second task, the skills which must need to improve and also the mart objectives are developed
in order to improve the skills. In third task, spreadsheet is created in by presenting the data and
analysis of iphone and Samsung galaxy.
TASK 1
Analyse Personal Skill Audit
Skills Self assessed Score from others Outcome
Leadership skills 6 8 -2
Management Skills 9 7 2
Computational skills 8 6 2
Communication skills 9 6 3
Time management
skills
7 9 -2
Listening skills 7 8 -1
IT Skills 6 8 -2
Decision making skills 8 7 1
Problem solving skills 7 9 -2
It is being identified from the above Personal Skill Audit that there are two types of skills
such as positive and negative. From the above information it is being analyzed that individual
have positive as well as negative skills in which they have to focus on improving it (Cajiao and
Burke, 2016). In order to make successful career it is important to focus on improving the skills
in which individual is weak (Teoli, Sanvictores and An, 2019).
Strength Weaknesses

 From the above analysis, it is being
determined that my leadership skills is
strong due to which I’m able to handle
and lead the team in effective and
efficient manner. I also have an ability
to encourage and provide clear vision
to my team members due to which it
helps in maintaining good relations
with fellow members (Roussy, Barbe
and Raimbault, 2020).
 One of the skill in which I am good is
time management skills. I have an
ability to manage the time and meet the
targets on deadline. For my effective
time management skills, I also get
appreciated from my fellow members. I
focus on setting my goals correctly and
also prioritize them wisely in order to
gain better results.
 My listening skill is also good as I pay
attention to hear and interpret what
other people are saying. I can
understand the matter and also open to
accept the ideas and information. I also
focus on rephrasing and summarizing
the ideas and thoughts of speaker.
 I have basic knowledge of IT which
helps in boosting my confidence while
using emerging technology (Cottrell,
2015). Through having IT skills I can
save my time and money and focus on
 It is being identified that my management
skills are not so strong due to which I have
to face difficulties regarding maintaining
strong bond with my team members and
also I face problem in making decision
related to management.
 I face difficulty in calculating the basic
numerical data which reduces my morale
and confidence to determine the correct and
quick answer of the data (Philbrick and
Cleveland, 2015). I use calculator in order
to compute the digits and answer the
questions.
 My Communication skill is not so effective
due to which I face problem while
interacting and communicating with other
people. In order to convey the clear
message and information it is important to
have good communication skill.
 I face problem in making effective decision
for the betterment of individual or
organization. Decision making skill is
important for effective leadership and
management so I have to focus on
improving my decision making skill so that
I can make better decision (Sarsby, 2016).

solving the technical issue
independently. My problem solving skill is good as I
have an ability to solve the issues in
effective and quick manner so that a
positive environment can be
maintained.
TASK 2
Skills which needs to be improve
Smart objectives:
 To improve communication skills, I will participate in effective meetings and public
speaking.
 To improve management skills I will focus on strengthening my decision making ability
so that I can make effective decision related to management.
 To enhance my computational skill, I will focus on improving my calculation skills.
 For improving my decision making skills, I will participate in decision making process
and group activities.
Requirements Personal
audit
(rating
scale: 0-
10)
GAP Remedial
action/strategy
Goals
Personal/Pr
ofessional
Developmen
t Plan
Activity
(use
SMART
target)
Management Skills
9 I have to work on
improving my
management skills
as it helps in
building strong
In order to improve
my management
skills, I have to
focus on
Medium term
goals
(6 month)

relations with my
fellow team
members and also
it helps me in
providing better
career
opportunities.
strengthening my
decision making
ability and
complete my
management
training in order to
gain better results.
Computational skills 8 I have to enhance
my computational
skill as it helps me
to solve the
problems without
getting dependent
on any other person.
In order to make my
computational sills
strong I have to
focus on calculating
mathematical
problems.
Short term
goals
(3 months)
Communication skills 9 I have to focus on
improving my
communicational
skills as it reduces
the level of morale
and confidence due
to which I feel shy
to interact with
By getting
indulge in
discussion and
interacting with
new people in
order to
communicate
Medium
term goals
(5 months)

other people. effectively.
Decision making skills 8 It becomes difficult
for me to make
effective decision. I
have to pay more
attention on making
good decision.
Must participate in
group activities and
decision making
process.
Long term
(1 year)
TASK 3
 List the retail prices for the Samsung Galaxy and iPhone from 2015-19.
The above is the list of prices of iphone 6S and Samsung galaxy S in UK from the year
2015-2019.
2) State the differences between the prices of the mobile phone.
Interpretation: From the above differences calculated it can be analysed that, in 2015,
there was a huge difference of $100 but as the demand decreases, the difference in the prices also
diminishes.

 Difference of percentage between the prices.
Interpretation: Form the above table, it can be evaluated that the difference in 2015 was
15.41, taking iPhone price as the basis. In 2016, the deviation increased then it continuously
decreased from 2017. The formula used here is =Difference in prices / iphone 6S.
4) Calculate the average price of the phones in excel and share the screenshot.
Interpretation: The above table shows the average price of iPhone 6S and Samsung
galaxy S. The formula used is =AVERAGE(B2:B6) for iphone and =AVERAGE(C2:C6) for
Samsung galaxy.
CONCLUSION
It is being concluded from the information that there are various skills which require for
achieving the career goals and objectives. The individuals are good in few skills and for other
skills they have to focus on improving so that they can grab career objectives. It is important for
an individual to focus on enhancing their skills and knowledge in order to remain competitive in
corporate world. A person can only achieve success when they have an ability to fulfill their
dreams in effective and efficient manner.

REFERENCES
Books and Journals
Asai, D., 2019. To learn inclusion skills, make it personal. Nature. 565(7737). pp.537-538.
Assiter, A., 2017. Transferable skills in higher education. Routledge.
Cajiao, J. and Burke, M .J., 2016. How instructional methods influence skill development in
management education. Academy of Management Learning & Education, 15(3),
pp.508-524.
Cottrell, S., 2015. Skills for success: Personal development and employability. Macmillan
International Higher Education.
Dominici, G., 2017. Systems thinking research in the twenty-first century: a SWOT
analysis. International Journal of Systems and Society (IJSS). 4(1). pp.10-18.
Philbrick, J. L. and Cleveland, A. D., 2015. Personal branding: building your pathway to
professional success. Medical reference services quarterly. 34(2). pp.181-189.
Puyt, R and et. al., 2020. Origins of SWOT Analysis. In Academy of Management
Proceedings (Vol. 2020, No. 1, p. 17416). Briarcliff Manor, NY 10510: Academy of
Management.
Roussy, M., Barbe, O. and Raimbault, S., 2020. Internal audit: from effectiveness to
organizational significance. Managerial Auditing Journal.
Sarsby, A., 2016. SWOT analysis. Lulu. com.
Supriadi, T and et. al., 2019. Influence of auditor competency in using information technology
on the success of E-audit system implementation. EURASIA Journal of Mathematics,
Science and Technology Education. 15(10). p.em1769.
Teoli, D., Sanvictores, T. and An, J., 2019. SWOT analysis.