| 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) Date will be entered before the brief is released to students. |
| Unit title & code | Using Data to Build Business Practice – BSS004-1 |
| Assignment number and title | Assignment 2 – BIS data analysis |
| Assessment type | Report + Excel file |
| Weighting of assessment | 75% |
| Size or length of assessment | 2500 word report + Excel file |
| Unit learning outcomes | Identify data requirements and the appropriate data collection instruments required for effective business decision making 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 data from the research project for the Department for Business Innovation and Skills (BIS) to understand the barriers to take up and use of business support. As the data set is large, it is saved in different tabs. The tab labelled Variables contains the questions. The tab labelled Values contains the possible options for each question. The remaining tabs contain the data itself.
You have just started employment in the Research department of a University Business School. Your tasks: Compare the South East region with the North West region. Analyse the data provided in order to gain an understanding of the pattern of barriers to take up and use of business support. Highlight interesting findings. Make recommendations about areas which require further support. Present your work to the Chief Research Analyst in the form of a report in Word. Submit your analysis in an Excel file which the Chief Research Analyst can use 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, 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 on make sure you have downloaded/printed out the Assignment Brief and bring it to the session with you.
Week commencing 6th May 2020 |
| 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. |
||||
| 3rd Class – 40-49% | Lower 2nd – 50-59% | Upper 2nd – 60-69% | 1st Class – 70%+ | |
| 1 Analysis and recommendations (60%) | Limited analysis of the data provided. Some of the analysis is not relevant/appropriate.
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.
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.
Good recommendations based on analysis conducted in the Excel file and presented in the report. |
Excellent, systematic and relevant analysis of the data provided.
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. | Good skills in Excel. Good charts and appropriate functions. Some Excel formulae are missing or incorrect. | Good skills in Excel. Good charts and appropriate functions. All Excel formulae are exhibited properly. | Excellent skills in Excel. Excellent charts and appropriate functions. All Excel formulae are exhibited properly. |
| 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. |
The post Assignment 2 – BIS data analysis appeared first on My Assignment Online.