Midterm Assessment
Exam Activity brief BCO117 IT Software for Business Online campus
Professor: Henry Negreira | henry.negreira@euruni.edu
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
