excel

BCO117Finaltaskbriefandrubrics-2021.docx

Home >Computer Science homework help >excel

BCO117 IT Software for Business Final Assessment Task brief & rubrics

Task

The individual assignment contains 3 computational questions based on the excel file called “FINAL ASSESSMENT 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 calculations and knowledge of spreadsheets studied in class to the scenarios provided.

· PART 2: In the written part, refer 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 1 and part 2

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

Part 1:

1. What is highest profit in each region? Create a graph to prove it.

2. Demonstrate what hour of the day is the one with higher revenues. Create a graph to prove it.

3. Find the final amount accumulated investing for 5 years the total revenue of the region with the highest revenue paid with PayPal, at an annual interest of 9% compounded monthly. Create a formula to calculate it.

Part 2:

The diagram below shows the processes involved in the acquisition of goods for Mercury Company.

4. Describe the IT software that might be used to check the stock at the Storehouse by this young company. Explain the software and the method to use it.

5. Enumerate and describe the main challenges Mercury Company might face when implementing an ERP. Evaluate the advantages/disadvantages of this implementation.

Formalities:

· Font: Arial 12,5 pts.

· Text alignment: Justified.

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

Submission: July 18th, 2021. 23:59 CEST.

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

It assesses the following learning outcomes:

Learning Outcome 1: demonstrate a working level and familiarity with practical spreadsheet software formulae.

Learning Outcome 2: identify and describe how companies are able to accurately measure corresponding IT infrastructures to suit their own needs and purposes.

Learning Outcome 3: understand the impact Word Processing software platforms have on a business's overall profitability and success.

Learning Outcome 4: illustrate an awareness of how spreadsheet software optimizes business operations.

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.