Submission Deadline

Marks and Feedback

Before 10am on:

20 working days after deadline (L4, 5 and 7)
15 working days after deadline (L6)
10 working days after deadline (block delivery)

Unit title & code

Using Data to Build Business Practice - BSS004-1

Assignment number and title

Referral Assignment 2 –CIPD  data analysis

Assessment type

Report + Excel file

Weighting of assessment

75%

Size or length of assessment

2500 word report + Excel file

Unit learning outcomes

1. Identify data requirements and the appropriate data collection instruments required for effective business decision making
2. Conduct appropriate analysis and clearly communicate findings to a stated audience

What am I required to do in this assignment?

You have been provided with an edited subset of survey data collected and analysed by YouGov plc. for The Chartered Insititute of Personnel and Development and The Adecco Group.  The data was collected between the dates of 25/03/2020 to 07/04/2020. 

The research department of a university business school has undertaken some consultancy work for the Government.  The Government is interested in assessing the impact of Brexit on UK organisation’s recruitment processes and making a comparison between the education sector and the healthcare sector. 

The Government is therefore interested in examining whether organisations are planning to grow or shrink their workforce, where the potential markets for new staff are seen to be, and whether a new points based immigration system would be seen as problematic in operation.

Your tasks:

1. Analyse data on both education sector and the healthcare sector. 
   1. Explore the data provided in order to gain an understanding of the information required by the Government.
   2. Select the questions you wish to analyse to provide the information required.
   3. Analyse the data for your selected questions using appropriate summary statistic in a spreadsheet.
   4. Highlight interesting findings.
   5. Make recommendations to the Government about the possible impact of Brexit and the proposed new immigration system on organisations.

1. Present your work in the form of a report in Word.  Submit your analysis in an Excel file which could be used for further investigation.

Suggested steps:

• Extract the required data and place it a new Excel file.
• Familiarise yourself with the data by using Excel’s facilities like sorting, filtering, pivot table, etc.
• Pick particular aspects that you want to conduct further, more detailed analysis on.
• Conduct a visual examination of the data by plotting appropriate charts.
• Calculate some standard statistics (e.g., mean, median, mode, range, standard deviation, etc.).
  • Conduct additional analysis that you feel is appropriate to address the tasks

What do I need to do to pass? (Threshold Expectations from UIF)

• Demonstrate competence in a range of skills in Excel including charting and use of functions
• Select  appropriate techniques to explore and summarise  a given dataset
• Highlight and communicate results to the relevant audience

How do I produce high quality work that merits a good grade?

We will be filling this section in together in class onClick or tap to enter a date.make sure you have downloaded/printed out the Assignment Brief and bring it to the session with you.

How does assignment relate to what we are doing in scheduled sessions?

Every week we will be using Excel in the workshop sessions to enhance your skills in Excel.  We will cover Excel facilities like sorting, filtering, pivot tables, charting, etc.  We will also use Excel’s functions such as Sum, Average, Min, Max, etc.   In addition, we will practice creating formulae in Excel.

How will my assignment be marked?

Your assignment will be marked according to the threshold expectations and the criteria on the following page.

You can use them to evaluate your own work and consider your grade before you submit.

3^rd Class – 40-49%

Lower 2^nd – 50-59%

Upper 2^nd – 60-69%

1^st Class – 70%+

1

Analysis and recommendations

(60%)

Limited analysis of the data provided. Some of the analysis is not relevant /appropriate.  There is no evidence of the analysis in the spreadsheet.

Recommendations are poor/missing/not based on analysis of data conducted in the Excel file and presented in the report.

Good analysis of the data provided. Some aspects of the data analysis is missing.  There is limited evidence of the analysis in the spreadsheet.

Recommendations are poor and loosely based on analysis of data conducted in the Excel file and presented in the report.

Thorough and relevant analysis of the data provided.Evidence of the analysis is not clearly highlighted in the spreadsheet.

Good recommendations based on analysis conducted in the Excel file and presented in the report.

Excellent, systematic and relevant analysis of the data provided.  Evidence of all the analysis is clearly highlighted in the spreadsheet.

Excellent, practical recommendations based on analysis conducted in the Excel file and presented in the report.

2

General skills/knowledge of using Excel (20%)

Limited evidence of using Excel to plot Chart Some functions are not appropriate.  Some Excel formulae are missing or incorrect.

The spreadsheet is poorly laid-out.

Good skills in Excel.  Good charts and appropriate functions. Some Excel formulae are missing or incorrect.

The spreadsheet could be better laid-out.

Good skills in Excel.  Good charts and appropriate functions. All Excel formulae are exhibited properly.

The spreadsheet is well laid-out but could be easier to navigate.

Excellent skills in Excel.   Excellent charts and appropriate functions.  All Excel formulae are exhibited properly.

The spreadsheet is very well laid-out and easy to navigate.

3

Report writing and presentation of report (20%)

The report missed some elements according to the requirements.

Use of language and/or grammar is poor but does not hinder the understanding of the target audience. 

The report covered all the elements according to the requirements.

Use of language and/or grammar is poor but does not hinder the understanding of the target audience.

The report covered all the elements according to the requirements.

Use of language and grammar is good, but structure and organisation of the report could be improved.  Report appropriate for the target audience.

The report covered all the elements according to the requirements.

Use of language and grammar is good. The report is well organised with good coherence and appropriate for the target audience.