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 givin