Identify relevant technological applications to make business processes more efficient in an organisation

HBS Assessment Brief

Module Title:

Technology in Business

Module Code:

4BUS1152

 

 

 

 

Assignment Format & Maximum Word count

There are 2 parts;

 

Part1

Excel worksheet only

 

Part2

Report of 550 words

 

 

 

 

Assignment Weighting:

 

 

 

 

70%

 

Coursework Submission:

Time:23:59 Date:25/02/2021 Method: via StudyNet

Coursework return Date returned to students:

:4 weeks from submission

Module leader

Yamaya Ekanayaka

First marker

Yamaya Ekanayaka

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/GroupAssessment

Assignment Title: Data Analysis using Excel

Description of the assignment: This assignment has two parts.

Part1

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;

 

 

Total absences recorded

 

April

May

Monday

21

16

Tuesday

17

9

Wednesday

16

18

Thursday

18

21

Friday

25

30


  1. Enter the data onto an Excel worksheet and name it as “Absences”.
  2. At the foot of each April and May columns, display the average for each month by using a formula.
  3. 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.

  1. 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.
  2. Ensure that your graph/chart has appropriate title, scales, labels and legend.

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 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.

(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 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 550 words (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”.

 

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 2).

/15

 

Presentation

Clear presentation and structure of the report. At least 2 academic sources should be used and referenced using Harvard style.

/10

 

 

Total

/50

 


                             

Email: [email protected]

100% Plagiarism Free & Custom Written, Tailored to your instructions

Our Giveaways

Plagiarism Report

for د.إ50 Free

Formatting

for د.إ32 Free

Title page

for د.إ20 Free

Bibliography

for د.إ36 Free

Outline

for د.إ19 Free

Limitless Amendments

for د.إ38 Free

Get all these features for
د.إ195.00 FREE

ORDER NOW
assignment bank giveaways

Our Ratings