We write, we don’t plagiarise! Every answer is different no matter how many orders we get for the same assignment. Your answer will be 100% plagiarism-free, custom written, unique and different from every other student.
I agree to receive phone calls from you at night in case of emergency
Please share your assignment brief and supporting material (if any) via email here at: [email protected] after completing this order process.
HBS Assessment Brief
NOTE: Kindly share your UPDATED exam paper to the LIVE EXPERT with an updated Case Study (if any)
Module Title:
Technology in Business
Module Code:
4BUS1152
Assignment Format & Maximum Word count
There are 2 parts;Part1Excel worksheet only
Part2Report of 550 words
Assignment Weighting:
70%
Assessment Criteria
Learning Outcomes: Knowledge and Understanding tested in this assignment:
Learning Outcomes: Skills and Attributes tested in this assignment:
Feedback /Marking criteria for this Assignment
Guidance for improvement will be given in writing on the Assessment Feedback Form on the StudyNet Feedback Form within 4 weeks of submission.
Detailed Brief for Individual/GroupAssessment
Assignment Title: Data Analysis using Excel
Description of the assignment: This assignment has two parts.Part1Assume you are working as a Human Resources Assistant in an organisation. There are concerns about staff absence through sickness and it is suspected that there are excessive sickness absences on Mondays and Fridays. Data has been provided by the HR department and you are to create a one page document on the subject for your manager.The following information has been given;
Total absences recorded
April
May
Monday
21
16
Tuesday
17
9
Wednesday
18
Thursday
Friday
25
30
You will now add two further columns. Add a column for the ‘average number of absences’ on each day of the week in April and a column for the average number of absences on each day of the week in May.Enter formulae to calculate these numbers and show the results correct to one decimal place.
6. Add to your worksheet a comment on the absence statistics (no more than 80 words) and make sure your sheet is suitable for presenting a printed version to your manager. The comment is to be made using the chart/graph created and should address whether the statistics confirms that there are more absences on Mondays and Fridays of each month.In order to make it presentable, you could format the sheet so that the data and comment are displayed clearly.
Submission InformationPart 1 of Assignment - All submissions should be made via the Module Page on StudyNetEach student will submit Part 1 as an Excel file. This file will include the relevant worksheet including the relevant comment (within Excel). The submission file should be named as “ExcelPart1”.
Mark scheme: Part 1
Criteria
Description
Marks
Enter data to a worksheet and name the sheet (not the file) “Absences”.
Condone minor errors, max 8 if they don’t rename the sheet
/10
At the foot of each of the number columns use a formula to calculate the average of the five numbers in the column correct to one decimal place.
Deduct 2 if they are not to 1 dp
/4
In April there were five Fridays and four of the other days and in May there were five Thursdays and four of each of the other days but two of the Mondays were bank holidays when nobody was expected to work. Add a column for the average number of absences on each day of the week in April and a column for the average number of absences on each day of the week in May. Enter formulae to calculate these numbers and show the results correct to one decimal place.
Give 4 if the correct day numbers are seen.
Check that the numbers from HR have been divided by the correct number of days in every case.
Deduct 2 if the results are not to one dp.
/15
Create a bar chart or column graph showing the results of these calculations so that the months can be compared to be embedded in the same worksheet.
Give ten if there is a chart of some sort which shows data from the calculations in pairs for each of the five days.
Ensure that your graph or chart has appropriate title, scales, labels and legend and suitable for presenting to the manager.
Deduct 1.5 for the title, 1.5 for the scales and labels 1.5 for the legend.
Appropriate formatting - 1.5
/6
Based on the analysis., add to your worksheet a comment on the absence statistics
A reasonable comment will receive full marks
/5
Total
/50
Part 2
Problem to addressAssume you are working for an organisation which is going to open an on-line business of selling smart watches and smart earbuds. In order to make decisions related to the new business, the management have decided to use market research data carried out by Mintel Corporation.Your management has asked you to address the following questions based on available data.(1) The organisation wishes to purchase more stock of brands which are most popular. Identify the three most popular brands of smart watches and smart earbuds (select the appropriate data from the Mintel Work Sheet). Use an appropriate chart to illustrate the findings.(2) The management also have requested you to analyse the purpose of using “smart” earbuds by 16-34 male and female age groups (select the appropriate data from the Mintel Work Sheet). Compare the male and female age groups using a suitable chart/graph and interpret it highlighting the similarities and differences.(3) “The Covid-19 outbreak is encouraging the use of smartwatches for contactless payment, regardless of the gender.” Is there evidence to support this statement? Explain your answer with justifications (Refer to the data given on Mintel Worksheet and present it graphically, which will help to compare the gender data easily).(4) Based on secondary research carried out comment whether there is evidence to support your claims presented in part 3 (use at least 3 external sources). The sources should be cited and referenced.The Mintel Report can be accessed via https://reports-mintel-com.ezproxy.herts.ac.uk/display/990136/
Structure of the report (Part 2)
Word CountMaximum 550 words (excluding figures/tables and title page)
Submission InformationPart 2 of Assignment - All submissions should be made via the Module Page on StudyNetPart 2 should be presented as a word document. The submission file should be named as “ExcelPart2”.
Data Selection
Select appropriate data for analysis
Produce appropriate charts/graphs
Each selected data set should be depicted using an appropriate graph/chart. Clarity of graphs/charts with appropriate title, scales, labels and legend
Analysis
Relevance and accuracy of the analysis with reference to produced charts/graphs. Evidence of investigation whether similar trends exists in retail industry/organisations and support your analysis by using supplementary articles (at least 2).
Presentation
Clear presentation and structure of the report. At least 2 academic sources should be used and referenced using Harvard style.
The quoted price covers up to 3000 words. For custom requirements Live Chat or Whatsapp ← Click Here
Email: [email protected]
Plagiarism Report
Formatting
Title page
Bibliography
Outline
Limitless Amendments
Get all these features for د.إ195.00 FREE
Check Out Our Original Reviews