Examine the technology industry, trends, challenges and applications;
HBS Assessment Brief
|
Module Title:
|
Technology in Business
|
Module Code:
|
4BUS1152
|
|
Assignment Format & Maximum Word count
|
There are 2 parts;
Part 1
Excel worksheet only
Part 2
Report of 550 words
|
Assignment Weighting:
|
70%
|
|
Coursework Submission:
|
|
Coursework return
Date returned to students:
|
:4 weeks from submission
|
|
Module leader
|
|
First marker
|
|
|
Internal Moderator
|
Approved ü Date:28/01/21
|
Module Board name
|
|
|
External Examiner
|
Approved ☐
Date:
|
Module Board date
|
|
|
Assessment Criteria
|
|
Learning Outcomes: Knowledge and Understanding tested in this assignment:
|
- Examine the technology industry, trends, challenges and applications;
- Explain the impact of technology applications for enterprises;
|
|
Learning Outcomes: Skills and Attributes tested in this assignment:
|
- Identify relevant technological applications to make business processes more efficient in an organisation
|
|
Feedback /Marking criteria for this Assignment
|
- Performance will be assessed using HBS Grading Criteria and Mark scheme.
Guidance for improvement will be given in writing on the Assessment Feedback Form on the StudyNet Feedback Form within 4 weeks of submission.
- Assignments submitted up to one week late will receive a maximum numeric grade of: Levels 4, 5 and 6 (UG) – 40
- Plagiarism offences will receive standard penalties.
|
|
Detailed Brief for Individual/Group Assessment
|
|
Assignment Title: Data Analysis using Excel
Description of the assignment: This assignment has two parts.
Part 1
Assume 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;
|
|
- Enter the data onto an Excel worksheet and name it as “Absences”.
- At the foot of each April and May columns, display the average for each month by using a formula.
- 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 two extra columns showing the ‘number of working days’ (for each day of the week) separately for April and May respectively. For example, based on the given information, the number of Tuesdays worked in April and May respectively will be 4 and 4.
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.
- Create an appropriate chart/graph (consider column/bar charts) to show the monthly averages for each day, so that the months can be compared easily. Embed this chart in the same worksheet.
- Ensure that your graph/chart has appropriate title, scales, labels and legend.
- 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 Information
Part 1 of Assignment - All submissions should be made via the Module Page on StudyNet
Each 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”.
|
|
|
Total absences recorded
|
|
|
April
|
May
|
|
Monday
|
21
|
16
|
|
Tuesday
|
17
|
9
|
|
Wednesday
|
16
|
18
|
|
Thursday
|
18
|
21
|
|
Friday
|
25
|
30
|
|
|
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.
|
/10
|
|
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 address
Assume 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)
- Title Page (Module Code, Assignment Name, Date). Use an appropriate structure (please check
and include references in Harvard style.
- Use page numbering, appropriate headings and captions for figures/charts. When explaining refer to figure numbers within your explanation. For example, “according to figure 1, …
Word Count
Maximum excluding figures/tables and title page)
Submission Information
Part 2 of Assignment - All submissions should be made via the Module Page on StudyNet
Part 2 should be presented as a word document. The submission file should be named as “ExcelPart2”.
Mark scheme: Part 2
|
Criteria
|
Description
|
Marks
|
|
Data Selection
|
Select appropriate data for analysis
|
/10
|
|
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
|
/15
|
|
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 3).
|
/15
|
|
Presentation
|
Clear presentation and structure of the report. At least 3 academic sources should be used and referenced using Harvard style.
|
/10
|
|
|
Total
|
/50
|
Student Support and Guidance
· For further help, contact your module leader in their drop-in hours or by email.
- Use the Grading Criteria and Mark Scheme to help improve your work.
- Go to CASE workshops, use the CASE website and drop-in hours www.studynet.herts.ac.uk/go/CASE/
- Academic English for Business support is available through daily drop-ins from the CASE office. See the CASE workshop timetable on the CASE main website page for details.
+2016+USER+GUIDE.pdf/$FILE/TURNITIN+FOR+STUDENTS+2016+USER+GUIDE.pdf
100% Plagiarism Free & Custom Written,
tailored to your instructions