IT software for business

BCO117 IT Software for Business Assignment 2 Task brief & rubrics

Task

The individual assignment contains 3 computational questions based on the excel file called “ASSESSMENT 2 DATASET” that must be solved using spreadsheet software, and 2 written (open) questions that evaluate application of theory. Each question counts a 20% of the assignment.

This task has 2 PARTS:

· PART 1: In the computational part, you are asked to apply the knowledge of spreadsheets studied in class.

· PART 2: In the written part, refers to the theory studied in class and provide examples to support your points.

You must create and submit two files:

· EXCEL file with your workings of Part 1

· WORD file with your explanations and graphs of Part 2

You must upload the two files via Turn-it-in. Save your documents with the filename: Assessment2_xxxx (where xxxx is your last name).

Questions

PART 1 – COMPUTATIONAL PART

Use the data provided in the "ASSESSMENT 2 DATASET" excel sheet.

1. Create a chart so that we can compare the total Revenues per Customer, and another chart showing the proportion (in %) of Revenues per Item Type.

2. Find two problems that the company is facing, explaining them creating a chart per problem, and suggest two possible solutions.

3. Create a table so that we can see the total Revenues per Region on a yearly basis and on a quarterly basis.

(60%)

PART 2 – WRITTEN PART

4. What was the Region with the biggest number of deliveries in 2014? Explain how this comparison could be represented and discuss about the importance of data representation.

5. Discuss about the importance of dashboards.

(40%)

Formalities:

· Wordcount: 2000 max.

· Font: Arial 12,5 pts.

· Text alignment: Justified.

· The in-text References and the Bibliography must be in Harvard’s citation style.

Submission: Week 9 - Sunday 28/11/202123:59 CEST.

Weight: This task is 30% of your total grade for this subject.

It assesses the following learning outcomes:

· Demonstrate a working level and familiarity with practical spreadsheet software formulae.

· Identify and describe how companies are able to accurately measure corresponding IT infrastructures to suit their own needs and purposes.

.

RUBRICS

	Excellent 90-100%	Good 80-89%	Fair 70-79%	Marginal Fail 60-69%	Fail <60%
Knowledge 20%	Student demonstrates thorough understanding of content.	Student demonstrates considerable under- standing of content.	Student demonstrates some understanding of content.	Student demonstrates limited understanding of content.	Student demonstrates no understanding of content.
Critical Thinking 30%	There is good evidence of critical appraisal of ideas and concepts, the insights are outstanding	Evidence of critical analysis is generally weak but is at a reasonable level for this point in IT software for Business	There is some evidence of critical appraisal of ideas and concepts, but the analysis and insights are rudimentary in terms of the IT software for Business	There is very limited evidence of critical appraisal of ideas and concepts and those that are offered are weak	There is limited or no evidence of critical appraisal of ideas and concepts in IT software for Business
Application 30%	Applies knowledge and skills in familiar contexts with a high degree of effectiveness, providing relevant examples that support points.	Applies knowledge and skills in familiar contexts with considerable effectiveness, providing some relevant examples that make a good attempt at supporting points.	Applies knowledge and skills in familiar contexts with some effectiveness, providing examples although some may lack relevance or provide limited support.	Applies knowledge and skills in familiar contexts with limited effectiveness, few/ irrelevant examples provided.	No application of possible knowledge or skills. No examples provided.
Communication 20%	Uses conventions, vocabulary, and terminology of the discipline with a high degree of effectiveness.	Uses conventions, vocabulary, and terminology of the discipline with considerable effectiveness.	Uses conventions, vocabulary, and terminology of the discipline with some effectiveness.	Uses conventions, vocabulary, and terminology of the discipline with limited effectiveness.	Lack of use of conventions, vocabulary, and terminology of the discipline.