BTEC HND CSD (Level 5) Work Based Experience Report

This report details a student's work based experience in various organizations, including research, negotiation, constraints, tasks prioritization, plan production, benefits analysis, and performance evaluation.

BTEC HND CSD (Level 5) Student Name:
Student ID:
WORK BASED EXPERIENCE
1

BTEC HND CSD (Level 5) Student Name:
Student ID:
Table of Contents
Task 1...............................................................................................................................................3
P1.1..................................................................................................................................................3
P1.2..................................................................................................................................................5
P1.3..................................................................................................................................................7
Task 2...............................................................................................................................................8
P2.1..................................................................................................................................................8
P2.2..................................................................................................................................................9
P2.3................................................................................................................................................11
Task 3.............................................................................................................................................13
P3.1................................................................................................................................................13
P3.2................................................................................................................................................13
P3.3................................................................................................................................................17
P3.4................................................................................................................................................18
Task 4.............................................................................................................................................20
P4.1................................................................................................................................................20
P4.2................................................................................................................................................22
P4.3................................................................................................................................................24
P4.4................................................................................................................................................24
Reference List................................................................................................................................26
2

BTEC HND CSD (Level 5) Student Name:
Student ID:
Task 1
P1.1 –Research and evaluate suitable organisations that could provide industry experience
Variables Amazon.com Bank of
England
Jefferies and
Company
Veolia Marriot International
Travel No No No Yes No
Salary/year £35,000 £40,000 £25,000 £26,000 £23,000
Flexible No Yes Yes Yes Yes
Type of job Business
Analyst
Business
Analyst-
Technology
Division
Junior
Business
Analyst-
Wealth
Management
London
Junior
Business
Analyst
Junior Bartender
What are
the
technical
skills that
are
expected?
MS Excel
SQL
Database
MS Excel
SQL Database
Microsoft
Power BI
experience
MS Office
Suite
MS
Office
Suite
SQL
Database
Clean and
professional
appearance
Managing heavy
loads of bottles
Interacting with
customers in a
pleasing manner
What are
the soft
skills that
are
expected?
Strong
Analytical
Skills
Operations
Excellence
Time
Management
Process
Collaboration
Decisive
Documentation
Excellent
Stakeholder
Understanding
of the Software
Development
Develop and
analyse
Management
Information
Providing
support to
the
International
Producing
Analytics
tools
Improve
standard
and
service
levels
Polite
Driven
Enthusiastic
Ready to please
3

BTEC HND CSD (Level 5) Student Name:
Student ID:
Streamlining Cycle Wealth
Department
Monitor
risks and
control
Data
entry
Job benefits Highly
talented team
Job growth
Unique office
space
Performance
based pay
Leave- 25 days
Flexible
benefits
Flexible
Working
environment
Job Growth
Equal and
Inclusive
workplace
Equal and inclusive
workplace
Table 1: Suitable organisations
(Source: created by the learner)
Company Ratings Evidence
Amazon.com - 8/10 This is an excellent company with a solid worldwide reputation.
The job offer is very challenging and the job growth is excellent.
Yet no financial benefits have been implied, thus work may not
be incentivised.
Bank of England - 9/10 This is the most reputable company. Government experience will
also be gained in such a company. The pay is the best, while the
benefits that are being offered make the job a very attractive
prospect.
Jefferies and Company -
8/10
This role suits all my needs; the prospect for growth is excellent.
This job is also very geographically viable and I will be able to
work and thrive at such a place.
Veolia - 5/10 This company is not very reputed, their requirements are
challenging and they are the furthest from my place of
occupation. Work hours many not be flexible and this job may
put a great toll on me.
Marriot International – As this was a backup job for me, I did not have much interest in
4

BTEC HND CSD (Level 5) Student Name:
Student ID:
2/10 pursuing it any further or in any more detai.
Table 2: Company Ratings
(Source: created by the learner)
P1.2 – Negotiate with work and academic supervisors a proposal for the work experience
Aims and
Objectives
Outcome Scope and Time Duration Resources
Create and
curate a
website
which can
maintain and
provide the
latest
business data
and analytics
about the
company
Website was
created, but
the data was
somewhat
mismanaged
and the
statistics were
misrepresented
The project was hoped to be
extended across three more
departments and completed in 6
months.
Project management team
Internet
Computer terminals
JIRA
Data tabulation Software
Name Mudia Ojo
Job Title Business Analyst- Technology Division
Duties  Develop deep understanding of business
functions
 Document business requirements
 Establish agreements between customers and
solution providers
Soft skills Highly motivated
Driven
5

BTEC HND CSD (Level 5) Student Name:
Student ID:
Hard working
Effective Team building skills
Technical skills MS Project
One Trust
JIRA
Word
Excel
PowerPoint
Visio
SharePoint
Brief introduction to your self I am a business analyst with practical experience
in the industry. I am very hard working and
possess an extensive portfolio of inter personal
skills which have allowed me to collaborated and
work effectively with team members. I believe in
the strength of positivity and organisation that has
been my guiding philosophy in my professional
and personal life.
Reason for the work experience Maslow’s hierarchy of needs states that there are
several needs that must be fulfilled for an
individual to gain satisfaction (Lester, 2013). My
reasons for work have always been as my self-
actualisation needs. The work that I have done in
the business analysis industry has provided me
with an understanding of how I can learn and
grow.
Future plan I aim to climb the corporate ladder and take up a
role, which is challenging and fulfilling. I aim to
continue work in this industry while expanding
my portfolio of skills and becoming an asset for
any company in which I work.
6

BTEC HND CSD (Level 5) Student Name:
Student ID:
Supervisors: roles and responsibilities of
academic and industrial mentors
Table 3: Proposal for the work experience
(Source: created by the learner)
P1.3 – Recognise the business constraints on the work experience offered
Constraints for the business Explanations How do I manage?
I need further training and
development
I did not have the required
skills to manage my time or
project costs
Work in the given time frame
and reduce budget per task.
Total Quality Management TQM procedures will ensure
that tasks are effective and
operational (Calvo-Mora et
al., 2013).
I will undergo managerial
training to ensure that I am
able to meet up to the required
needs.
Managing supervision Supervision must be done
effectively to ensure that the
project is meeting the
required goals and objectives.
I will build up my
communication and team work
skills to ensure that I able to
communicate goals and
objectives effectively.
Increased customer
satisfaction
Customer satisfaction being
low means that the website is
not able to perform
effectively.
Assigning teams to deal with
front end customer issues,
while back end teams are able
to sort out any backlogs.
Table 4: Business constraints on the work experience offered
(Source: created by the learner)
7

BTEC HND CSD (Level 5) Student Name:
Student ID:
Task 2
P2.1 – Agree and prioritise the tasks and responsibilities involved in the work experience
Bank of England- Business Analyst: Technology Division
Duties
 Assisting with the business case
 Planning and monitoring
 Translating any requirements and simplifying the same
 Analysis of requirements
 Development of model and cost/benefit analysis
Responsibilities (MoSCoW rules)
Tasks Must Should Could Would Reason for
this
rationalisation
Assisting
with the
business case
Providing
data analysis
for any
business
cases that are
presented
It is most
important that I
am able to
prioritise
business cases
as this will
present the
company with
work
management
options.
Planning and
monitoring
Database
management
Translating
8

BTEC HND CSD (Level 5) Student Name:
Student ID:
any
requirements
and
simplifying
the same
Analysis of
requirements
Providing
content
management
to databases
Development
of model and
cost/benefit
analysis
Create
required
backups.
Table 5: Tasks and responsibilities
(Source: created by the learner)
P2.2- Produce a plan for the work experience
Weekly Duties
Day Time What
are
the
activi
ties?
Evalu
ation
after
one
week
Review
Date
provided
by the
manager
Proposed
action plan
and date of
completion
Reviewing
the action
points
Review
date
provide
d by
the
supervi
sor
Actions
after the
review
Date of
completi
on.
Mo
nda
y
10-1 Cond
uct
SQL
queri
es for
I was
very
quick
with
my
02/02/201
8
I will work
on more
complex
datasets to
improve my
This will
provide me
with
complex
and large
12/02/2
018
Implemen
t this way
of work
in daily
plans.
9

BTEC HND CSD (Level 5) Student Name:
Student ID:
new
websi
te
work
but I
need
to
impro
ve my
accura
cy, as
there
were
many
errors
that
were
found.
accuracy by
07/02/2018
datasets
and I can
conduct
business
analysis
from the
same.
Tue
sda
y
12-3 Monit
or
real
time
updat
es of
data
sets
I feel
that I
worke
d to
the
best of
my
ability
and
was
review
er my
work
extrem
ely
stringe
18/02/201
8
I must learn
to evaluate
different
operations
simultaneous
ly.
22/02/2018
This will
give my
work a
greater
scope and
allow me
to be a
greater
asset in
terms of
my
monitoring
skills.
25/02/2
018
Monitor
complex
data sets
and their
results
10

BTEC HND CSD (Level 5) Student Name:
Student ID:
ntly
We
dne
sda
y
5-8 Devel
oping
and
curati
ng
websi
tes
for
data
publi
cation
I was
not
work
as per
my
expect
ations
as my
work
was
slow
and
riddled
with
errors
03/03/201
8
I must study
current web
analytics and
learn website
publishing
and drafting
09/03/2018
This will
help me
perfect my
webpage
building
skills and
provide me
with an
understand
ing of
corporate/
business
aesthetics
23/03/2
018
Implemen
t creative
ways to
create
and
curate
statistics
and data
related
corporate
sites
Table 6: Plan for the work experience
(Source: created by the learner)
P2.3- Analyse the benefits of the proposed activities to the business and the learner
Benefits experience
by the business
Explanation Benefits
experienced by the
learner
Explanation
Detailed task
development
This will mean that
the business will be
able to rely on a
more robust systems
architecture which
will provide better
Business operation
understanding
increases
I will be able to use this to
improve my technical
skills and information
technology skills.
11

BTEC HND CSD (Level 5) Student Name:
Student ID:
customer
experiences
Better system
responsiveness
Customer experience
will be better.
Improve time
management
I will be able to devote my
time to other tasks.
Lower operational
costs
As systems
downtimes and
servicing needs will
decrease, the
business will incur
less costs.
Refine all sorts of
problem solving
skills
I can devote my time in
technical project which
are attracting more
investment.
Work efficiency
increases
Better systems
architecture
Learn new IT
techniques
I will have more time to
work on my skills.
Table 7: Benefits of the proposed activities to the business and the learner
(Source: created by the learner)
12

BTEC HND CSD (Level 5) Student Name:
Student ID:
Task 3
P3.1- Learner is required to fulfil the specified requirements of placement conforming to
all related codes of practice.
Codes of conduct
that the learner must
follow
Additional
comments
Laws/
Regulat
ions
Additional
comments
Links
Following dress
code rules
I must ensure
that I follow all
the rules and
regulation levied
upon employees
to maintain a
professional
demeanour
Health
and
Safety
Act
1974
The
implementation
of this means
that I am able
to ensure my
safety as well
as that of my
co-workers
http://www.hse.gov.uk/
legislation/hswa.html
https://
www.legislation.gov.uk/
ukpga/1999/26/contents
Maintaining a
proper work-
personal time
schedule
My break times
must be as per
employer
norms, while
ensuring that I
can stay on task
and remain
effective.
Employ
ee
Relatio
ns Act
1999
By following
these
regulations, I
can ensure that
I am able to
maintain the
standards agree
upon by the
employer and
myself.
Table 8: Specified requirements of placement
(Source: created by the learner)
P3.2- Learner is required to produces systematic records of the work undertaken
Week Day Time Planned What Actual What What Week
13

BTEC HND CSD (Level 5) Student Name:
Student ID:
numb
er
Activities are the
resource
s that
are
required
?
Activities are the
resourc
es
require
d?
are the
resourc
es that
have
been
provide
d?
end
evaluati
on
1 Monda
y
10-3 Decipheri
ng data
sets
Compute
rs
Data
Software
Reading
data
Decipheri
ng codes
Comput
er
Data
Software
Comput
er
Data
Software
Wednes
day
3-5 Running
codes and
cleaning
datasets
Compute
rs
Data
Software
Trimming
data
Data
software
Data
software
I was
very
prompt
with my
work
and
accurate
ly
decipher
ed all
the data
[provide
d to me
2 Monda
y
10-3 Website
developm
ent
Creative
software
Compute
r
Creating
and
curating
websites
with data
specific
Creative
software
Comput
er
Creative
software
Comput
er
14

BTEC HND CSD (Level 5) Student Name:
Student ID:
output
Wednes
day
3-5 Updating
website
with latest
data and
figures
Data
tabulatio
n
software
Compute
r
Updating
tables and
figures,
making
sure of
accurate
data
analysis
Data
tabulatio
n
software
Comput
er
Data
tabulatio
n
software
Comput
er
I was
able to
add
creative
ouput to
the team
and
provide
prompt
updates
to the
website
3 Monda
y
10-3 Developin
g cost
models for
the
company
Company
financials
QuickBo
oks
Reading
financial
data and
creating
effective
models
and
analysis of
the same
Compan
y
financial
s
QuickBo
oks
Compan
y
financial
s
QuickBo
oks
Wednes
day
3-5 Tallying
cost
models
with
previous
year’s
performan
ce
Company
financials
QuickBo
oks
Matching
performan
ce in this
financial
year and
quarter
with
previous
years and
Compan
y
financial
s
QuickBo
oks
Compan
y
financial
s
QuickBo
oks
I feel
that
there is
a vast
amount
of
improve
ment
that can
15

BTEC HND CSD (Level 5) Student Name:
Student ID:
quarters be
achieve
d in this
section.
My
perform
ance
has not
matche
d my
persona
l goals
as I
found
myself
send in
inaccur
ate and
clumsy.
This
meant
the
compan
y
suffered
and
may
have
seen a
lower
amount
16

BTEC HND CSD (Level 5) Student Name:
Student ID:
of
profitab
ility.
Table 9: Systematic records of the work undertaken
(Source: created by the learner)
P3.3- Learner is required to revise the initial plan as required
Day Time Planned
activities
Actual
activities
performed
New
activities
planned
Justification
Monday 10-3 Deciphering
data sets
Reading data
Deciphering
codes
Entering data
into excel and
ensuring
faster
computerised
data
tabulation
Faster and
more
effective
work
Lower cost of
operations
Wednesday 3-5 Running
codes and
cleaning
datasets
Trimming
data
Running data
through excel
and cross
checking
during final
results
More work
efficiency
Table 10: Revised plan
(Source: created by the learner)
P3.4 – Learner is required to make suggestions for improvement and review these with the
supervisor
17

BTEC HND CSD (Level 5) Student Name:
Student ID:
Variables Improvement
Plan
Supporting activities for the
improvement
Managing time Creating a
timetable and
strictly adhering
to the same.
Setting aside
only 30 minutes
for lunch and 5
minutes for other
breaks
 Create a timetable on excel
 Setting alarms and timers to
measure hours taken away from
work
Dealing with pressure Maintain a calm
attitude and deal
with each
situation once at
a time.
 Yoga exercises
 Listen to relaxing music at work
Prioritising tasks Set deadlines for
each task.
Take small
breaks to
recuperate when
work is finished
 Work as per the given timetable
 Reach work early and understand
daily tasks beforehand.
Technical skills Work on Excel
and SAS
analytics
Take out time to work on smaller
online courses to develop skills
regarding the same.
Team Work Communicate
with team
members and
keep open
channels of
communication.
Adopt a self-assured and approachable
demeanour at work.
18

BTEC HND CSD (Level 5) Student Name:
Student ID:
Table 11: Suggestions for improvement
(Source: created by the learner)
19

BTEC HND CSD (Level 5) Student Name:
Student ID:
Task 4
P4.1 – Learner is required to monitor progress against original proposal
Week
number
1 2 3
Day Monday Wednesday Monday Wednesda
y
Monday Wednesday
Time 10-3 3-5 10-3 3-5 10-3 3-5
Planned
Activities
Deciphering
data sets
Running
codes and
cleaning
datasets
Website
development
Updating
website
with latest
data and
figures
Developing
cost models
for the
company
Tallying
cost models
with
previous
year’s
performance
What are
the
resources
that are
required
Computers
Data
Software
Computers
Data
Software
Creative
software
Computer
Data
tabulation
software
Computer
Company
financials
QuickBooks
Company
financials
QuickBooks
Actual
Activities
Reading data
Deciphering
codes
Trimming
data
Creating and
curating
websites
with data
specific
output
Updating
tables and
figures,
making
sure of
accurate
data
analysis
Reading
financial
data and
creating
effective
models and
analysis of
the same
Matching
performance
in this
financial
year and
quarter with
previous
years and
quarters
What are
the
Computer
Data
Data
software
Creative
software
Data
tabulation
Company
financials
Company
financials
20

BTEC HND CSD (Level 5) Student Name:
Student ID:
resources
required?
Software Computer software
Computer
QuickBooks QuickBooks
What are
the
resources
that have
been
provided?
Computer
Data
Software
Data
software
Creative
software
Computer
Data
tabulation
software
Computer
Company
financials
QuickBooks
Company
financials
QuickBooks
Week end
evaluation
I was very prompt with my
work and accurately
deciphered all the data
provided to me
I was able to add creative
output to the team and
provide prompt updates to
the website
I feel that there is a vast
amount of improvement
that can be achieved in this
section. My performance
has not matched my
personal goals as I found
myself send in inaccurate
and clumsy. This meant
the company suffered and
may have seen a lower
amount of profitability.
Action
plan
Managing data
accordingly
Creating appropriate
websites
Developing financial
models
Action
review
I was able to carry out my
work appropriately
My work was creative,
while ensuring effective
and timely work
My work was not accurate
enough and there were
several errors.
Manager
review
My manager was pleased
with the accuracy of my
work.
My manager needed more
creative input into the
tasks as he felt that these
were not pleasing to the
eye
My manager was not
impressed and insisted that
I improve my statistics and
calculation skills
Manager
action
N.a. Increase Photoshop
abilities
Improve excel adaptability
21

BTEC HND CSD (Level 5) Student Name:
Student ID:
plan
Manager
action
review
N.a. My manager was
impressed with the speed
and dexterity with which I
learned
My manager needed me to
learn and work faster with
excel
Table 12: Monitoring progress
(Source: created by the learner)
P4.2 – Learner is required to evaluate the quality of own performance
Week
number
1 2 3
Day Monday Wednesday Monday Wednesda
y
Monday Wednesday
Time 10-3 3-5 10-3 3-5 10-3 3-5
Planned
Activities
Deciphering
data sets
Running
codes and
cleaning
datasets
Website
development
Updating
website
with latest
data and
figures
Developing
cost models
for the
company
Tallying
cost models
with
previous
year’s
performance
What are
the
resources
that are
required
Computers
Data
Software
Computers
Data
Software
Creative
software
Computer
Data
tabulation
software
Computer
Company
financials
QuickBooks
Company
financials
QuickBooks
Actual
Activities
Reading data
Deciphering
codes
Trimming
data
Creating and
curating
websites
with data
specific
output
Updating
tables and
figures,
making
sure of
accurate
Reading
financial
data and
creating
effective
models and
Matching
performance
in this
financial
year and
quarter with
22

BTEC HND CSD (Level 5) Student Name:
Student ID:
data
analysis
analysis of
the same
previous
years and
quarters
What are
the
resources
required?
Computer
Data
Software
Data
software
Creative
software
Computer
Data
tabulation
software
Computer
Company
financials
QuickBooks
Company
financials
QuickBooks
What are
the
resources
that have
been
provided?
Computer
Data
Software
Data
software
Creative
software
Computer
Data
tabulation
software
Computer
Company
financials
QuickBooks
Company
financials
QuickBooks
Week end
evaluation
I was very prompt with my
work and accurately
deciphered all the data
provided to me
I was able to add creative
output to the team and
provide prompt updates to
the website
I feel that there is a vast
amount of improvement
that can be achieved in this
section. My performance
has not matched my
personal goals as I found
myself send in inaccurate
and clumsy. This meant
the company suffered and
may have seen a lower
amount of profitability.
Action
plan
 Managing data
accordingly
 Trim data and clean it
up more effectively
 Use more tables and
figures
 Creating appropriate
websites
 Improve website user
interface
 More customer
responsiveness in the
websites
 Developing financial
models
 Use more trend lines to
depict how yearly
performance is
represented
23

BTEC HND CSD (Level 5) Student Name:
Student ID:
Action
review
 I was able to carry out
my work appropriately
 I need to ensure that
my excel skills were
updated
 My work was creative,
while ensuring
effective and timely
work
 I needed more
customer surveys to
understand how they
would respond to the
websites
 My work was not
accurate enough and
there were several
errors.
Table 13: Monitoring progress and updating skills
(Source: created by the learner)
P4.3 – Learner is required to analyse the learning, which has taken place during the work
experience using suitable reflections
New learning Specific examples Additional Comments
Building interpersonal skills More self confidence
Better communication
Better team management
This would help me improve my
team management and effective
work output
Improve web designing Take up courses on Udemy
Improve Photoshop skills
This will help me improve
website management and
customer engagement
Table 14: Suitable reflections
(Source: created by the learner)
P4.4- Learner is required to make recommendations on how the experience could have
been enhanced
Criteria Comments
New geographical location This would help me expand the scale
24

BTEC HND CSD (Level 5) Student Name:
Student ID:
and size of my project
Clearer brief on database
management
This would help me communicate in a
more effective
Better time management This would help me save the costs for
my company and ensure that I
achieved my goals and objectives
more effectively.
Table 15: Recommendations
(Source: created by the learner)
25

BTEC HND CSD (Level 5) Student Name:
Student ID:
Reference List
Lester, D., 2013. Measuring Maslow's hierarchy of needs. Psychological Reports, 113(1), pp.15-
17.
Calvo-Mora, A., Picón, A., Ruiz, C. and Cauzo, L., 2013. The relationships between soft-hard
TQM factors and key business results. International Journal of Operations & Production
Management, 34(1), pp.115-143.
26