IT Software for Business

BCO117 IT Software for Business Midterm Assessment Task brief & rubrics

Task

The individual assignment contains 3 computational questions that must be solved using spreadsheet and 2 written (open) questions that are related to the

computational questions but 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 workings of part 2

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

Part 1:

1. Our company manufactures and exports medical equipment. The table below shows a series of models and their price in Euros. Cr eate the table in

excel. Create a formula that allows you to see all the prices of the models in dollars; if the dollar rate changes, the dollar rate cell updates all the prices in

the column.

Dollar rate

1,0113

Model Prices

Date Units sold Price in dollars Model Revenue

Model USD

10/11/2015 10 700 GRM

700 GRM 11690

09/11/2015 21 750 GRM

750 GRM 6260

08/11/2015 13 500 CFV

500 CFV 8890

07/11/2015 8 700 MTY

700 MTY 6610

06/11/2015 11 300 MTY

300 MTY 5310

05/11/2015 12 750 CFV

750 CFV 11890

04/11/2015 19 325 RTM

325 RTM 8910

03/11/2015 19 450 GRM

450 GRM 8650

02/11/2015 8 300 MTY

300 MTY 6020

01/11/2015 10 575 MTY

575 MTY 8880

2. Create a column that calculates the total revenue each day.

3. Draw a line chart that shows the evolution of revenue during those 10 days. Add a trendline.

Part 2:

4. Create a memo in Word. Comment on the trend shown in question 3. During the first 5 days, was the revenue rising or falling? And during those 10

days?

5. Most of your exports to the US belong to the model 575 MTY. Is it the model you obtained the highest revenue from during these 10 days? If not, which

model was it? What is the average revenue in these 10 days?

Formalities

For the Word Memo

 Wordcount: 150-word max.
 Font: Arial 12 pt.
 Text alignment: Justified

Submission: June 20
th

, 2021. 23:59 CEST.

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

It assesses the following learning outcome:

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

RUBRICS

Written answers Excellent 90-100% Good 80-89% Fair 70-79% Marginal Fail 60-69% Fail <60% Knowledge &Understanding (40%) 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. Application (40%) 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 s kills. 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.