BCO117MidtermActivityBrief.pdf

Midterm Assessment

Exam
Activity brief

BCO117 – IT Software for Business
Online campus

Professor: Henry Negreira | [email protected]

Description Timed Assessment.

Read full description below.

Format This activity must meet the following formatting
requirements:

• Font size 12

• Double-spaced

• Min. 300 words in Memo document

• Harvard Referencing System

• Word & Excel file

Goal(s) Elaboration of a Word memorandum based on the
information retrieved from an Excel spreadsheet.

Due date Date: Sunday, 21st June 2021

Time: 14:00

Weight towards
final grade

This activity has a weight of 40% towards the final
grade.

Learning
outcomes

• Demonstrate a working level and familiarity with

practical spreadsheet software formula.

Assessment
criteria

See Rubric below

Task Description

The task consists of 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.

• In the computational part, you are asked to apply the calculations and knowledge of spreadsheets studied in class to the scenarios provided.

• In the written part, make reference to the theory studied in class and provide examples to support your points.

You must upload the written answers and the spreadsheet via Turn-it-in. Save your documents with the filename: Axxxxxxx (where xxxxxxx is your last name). (Note: You

should save two files. One should be an EXCEL document and the other should be a Word document.)

Questions: (Each question is 20% of the assignment)

Part One

1. In the table below are the euro-dollar exchange rates for the first ten days of November 2020. The data shows dollar per euro. Draw a line chart that shows the evolution

of the euro relative to the dollar. Add a trendline. (See the picture as reference)

USD

10/11/2020 1,0385

09/11/2020 1,0443

08/11/2020 1,0262

07/11/2020 1,0481

06/11/2020 1,0385

05/11/2020 1,0566

04/11/2020 1,0384

03/11/2020 1,0301

02/11/2020 1,0139

01/11/2020 1,0019

2. Your company manufactures and exports construction cranes. The table below shows a series of models and their price in Euros.

• Create the table in excel.

• Insert the dollar rate on the 01/11/2020 in the cell below ´´Dollar rate´´.

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

• Repeat the procedure for the rate on 10/11/2020.

3. Your table should look like the one below after the previous steps. Now, in the column marked difference, show the difference in dollars between the two dates. Your

table should look like the one below.

Date Date

01/11/2020 10/11/2020

Dollar rate Dollar rate

1,0019 1,0385

Model Price in euros Price in dollars Price in dollars Difference

175 RTM 17.800 17.833,82 18.520,42 686,60

450 VRG 31.800 31.860,42 33.087,05 1.226,63

400 RTM 77.600 77.747,44 80.740,72 2.993,28

575 VRG 127.100 127.341,49 132.244,14 4.902,65

525 GRM 169.700 170.022,43 176.568,29 6.545,86

350 GRM 176.500 176.835,35 183.643,51 6.808,16

275 MTY 184.700 185.050,93 192.175,39 7.124,46

Model Price in euros

175 RTM 17.800

450 VRG 31.800

400 RTM 77.600

575 VRG 127.100

525 GRM 169.700

350 GRM 176.500

275 MTY 184.700

Part two

4. Create a memo in Word. Comment on the trend shown in question 1 above.

During the first 5 days, was the euro rising or falling? And during those 10 days? Write at least two paragraphs giving your insights about the situation regarding the

crane prices due to currency exchange.

5. Most of your exports to the US belong to the model 400 RTM. The experience shows that, if the price of this product rises over 78.000$, the exported units will be

reduced.

This product is priced in euros, and assuming the trend shown in question 1 continues, what would be the consequences for your company’s exports?

Reflect on this in your memo.

Rubric: written assignment

Criteria Accomplished (A) Proficient (B) Partially proficient (C) B line (D) Fail (F)

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