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 Instituteof Personnel and Development and The Adecco Group. The data was collected between the dates of 25/03/2020 to07/04/2020.The research department of a university business school has undertaken … Continue reading “survey data | My Assignment Tutor”
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 Instituteof Personnel and Development and The Adecco Group. The data was collected between the dates of 25/03/2020 to07/04/2020.The research department of a university business school has undertaken some consultancy work for the Government. TheGovernment is interested in assessing the impact of Brexit on UK organisation’s recruitment processes and making acomparison between the public sector and the private 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 seenas problematic in operation. Submission DeadlineMarks and FeedbackBefore 10am on:14/05/202120 working days after deadline (L4, 5 and 7)15 working days after deadline (L6)10 working days after deadline (block delivery)14/06/2021 Unit title & codeUsing Data to Build Business Practice – BSS004-1Assignment number and titleAssignment 2 – CIPD data analysisAssessment typeReport + Excel fileWeighting of assessment75%Size or length of assessment2500 word report + Excel fileUnit learning outcomes1. Identify data requirements and the appropriate data collection instruments required foreffective business decision making2. Conduct appropriate analysis and clearly communicate findings to a stated audience 2 Your tasks:1. Analyse data on both private sector and the public sector.a. Explore the data provided in order to gain an understanding of the information required by the Government.b. Select the questions you wish to analyse to provide the information required.c. Analyse the data for your selected questions using appropriate summary statistic in a spreadsheet.d. Highlight interesting findings.e. Make recommendations to the Government about the possible impact of Brexit and the proposed newimmigration system on organisations.2. Present your work in the form of a report in Word. Submit your analysis in an Excel file which could be used for furtherinvestigation.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 tasksWhat 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 audienceHow do I produce high quality work that merits a good grade?We will be filling this section in together in class on Click or tap to enter a date. make sure you have downloaded/printed out theAssignment Brief and bring it to the session with you.Week commencing 3rd May 2021How 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 likesorting, filtering, pivot tables, charting, etc. We will also use Excel’s functions such as Sum, Average, Min, Max, etc. Inaddition, we will practice creating formulae in Excel. 3 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. 3rd Class – 40-49%Lower 2nd – 50-59%Upper 2nd – 60-69%1st Class – 70%+1Analysis andrecommendations(60%)Limited analysis of the dataprovided. Some of the analysisis not relevant/appropriate.There is no evidence of theanalysis in the spreadsheet.Recommendations arepoor/missing/not based onanalysis of data conducted inthe Excel file and presented inthe report.Good analysis of the dataprovided. Some aspects of thedata analysis is missing. Thereis limited evidence of theanalysis in the spreadsheet.Recommendations are poor andloosely based on analysis ofdata conducted in the Excel fileand presented in the report.Thorough and relevant analysisof the data provided. Evidenceof the analysis is not clearlyhighlighted in the spreadsheet.Good recommendations basedon analysis conducted in theExcel file and presented in thereport.Excellent, systematic andrelevant analysis of thedata provided. Evidenceof all the analysis is clearlyhighlighted in thespreadsheet.Excellent, practicalrecommendations basedon analysis conducted inthe Excel file andpresented in the report.2Generalskills/knowledge ofusing Excel (20%)Limited evidence of using Excelto plot Chart Some functionsare not appropriate. SomeExcel formulae are missing orincorrect.The spreadsheet is poorly laidout.Good skills in Excel. Goodcharts and appropriatefunctions. Some Excel formulaeare missing or incorrect.The spreadsheet could bebetter laid-out.Good skills in Excel. Goodcharts and appropriatefunctions. All Excel formulaeare exhibited properly.The spreadsheet is well laid-outbut could be easier to navigate.Excellent skills in Excel.Excellent charts andappropriate functions. AllExcel formulae areexhibited properly.The spreadsheet is verywell laid-out and easy tonavigate.3Report writing andpresentation ofreport (20%)The report missed someelements according to therequirements.Use of language and/orgrammar is poor but does nothinder the understanding of thetarget audience.The report covered all theelements according to therequirements.Use of language and/orgrammar is poor but does nothinder the understanding of thetarget audience.The report covered all theelements according to therequirements.Use of language and grammaris good, but structure andorganisation of the report couldbe improved. Reportappropriate for the targetaudience.The report covered all theelements according to therequirements.Use of language andgrammar is good. Thereport is well organisedwith good coherence andappropriate for the targetaudience.