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: |
|
|
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/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; |
|
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.
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”. |
|
||||||||||||||||||||||
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.
- 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.
- 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.
- “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).
- 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.
- Make full use of Library search to identify relevant academic material and the ‘Subject Toolkit for Business’ which contains links to other Information Databases and the Information Management contact details. (http://www.studynet1.herts.ac.uk/ptl/common/LIS.nsf/lis/4DAF5390094771C2802575ED004212BF)
- Some tutors allow students to test their work using Turnitin. Guidance on submission to Turnitin via StudyNet can be found by using the following link. http://www.studynet1.herts.ac.uk/ptl/common/asu.nsf/resource+library/TURNITIN+FOR+STUDENTS
+2016+USER+GUIDE.pdf/$FILE/TURNITIN+FOR+STUDENTS+2016+USER+GUIDE.pdf