IT Software for Business
COURSE CODE: BCO117 COURSE NAME: IT SOFTWARE FOR BUSINESS Task brief & rubrics

Task

This summa)ve assignment is divided in 2 parts. Each part consist on 3 prac)cal exercises.

*Note that each part has a different due date (see “Submission”). These are individual assignments.

Part 1.

1st quesLon

Contextual Informa)on:

• There are two wide used methodologies to manage a soGware development life cycle: Agile and Scrum. Create a Word Document briefly describing their differences. (word count 500 words).

• The document’s formaPng should be strictly as follows:

o First Page: Title. FormaPng 20 pts. Bold. Centered. Font: ?

o Table of Contents (TOC) Font:?

o Headings: Type 1, Bold, 16 pts, Font:?

o Main body Text: Jus)fied, Font ?, 12,5 pts.

o References (using hyperlinks).

o Pagina)on (Auto).

2nd quesLon

The table below shows the historical data of the Average Closing Price (2005-2020.) Es)mate the annual varia)on of crude oil prices (in %). Use the equa)on be- low. Draw a line chart showing the evolu)on of the annual varia)on and add a trend line and describe its type (posi)ve, nega)ve, neutral). There are 2 historical minimum values reached in 2008 and 2020; relate those minimum values to socio-economic events and include them as labels in the chart.

• You should submit the spreadsheet used to es)mate the annual Change (%)

Year Average Closing

Price

2020 38.78

2019 56.99

2018 65.23

2017 50.80

2016 43.29

2015 48.66

2014 93.17

2013 97.98

2012 94.05

2011 94.88

2010 79.48

2009 61.95

2008 99.67

2007 72.34

2006 66.05

2005 56.64

3rd quesLon

Calculate the annual payment for a loan with an annual constant interes

• t rate of 2%, a 35-year dura)on, a present value of €145,000 and a future value of 0.You should submit the spreadsheet used to es)mate the anual pay- ment.

Part 2.

1st quesLon

Each year, on average, more than two dozen large ships sink or disappear along the oceans. A shipbuilding company can produce one large vessel to transport oil (known as a tanker) at $105 million each. Suppose the company needs to replace 5 ships over a 4-year period. To cover the cost of replacing the ships, what is the best bank to invest in? Consider that their respec)ve accounts pay interest as follows:

• Bank of America : Interest 2% per year

• Deutsche bank: Interest 5% per two years

• Banco Nacional de España: Interest 6% per 5 years.

2nd quesLon

Create a Memo document in Word addressed to “Mr. Robert Hvide Macleod” CEO of Frontline (PO Box HM 1593, Par-la-Ville Place, 14 Par-la-Ville Road, Hamilton HM 08, Bermuda)

• Describe the issue to Mr. Hvide and jus)fy the conclusions reached in ques)on 1 using the following memo structure:

o Issue under study.

o Type of Analysis implemented.

o Jus)fica)on of the conclusions (use a table and any graphics that help to clarify the informa)on for the reader (bars, lines, etc.)).

3rd quesLon

A medium-sized company is opening a second office in New York. The main office will be based in London. In the diagram below you can find the hardware they have installed so far.

1. Draw a line showing the connec)on between hardware and the Internet.

2. Make a list of at least 5 fundamental resources that have to be shared among the offices for the proper func)oning of the business. Propose an ap- propriate soGware for each case.

3. List the computer tools to be used if a customer in London places an order for an item to be delivered to New York.

4. Propose an IT solu)on to manage communica)on between the New York office and the delivery company.

5. Describe the advantages of using The Cloud in this business scheme. It is necessary? Jus)fy.

6. Describe the advantages and disadvantages that the business will face if they want to implement an ERP in the next 3 years.

FormaliLes:

• References and Appendix are excluded of the total wordcount.

• Font: Arial 12,5 pts.

• Text alignment: Jus)fied.

• The in-text References and the Bibliography have to be in Harvard’s cita)on style.

Submission:

-Part 1 Week 2. Deadline: 15th November 2020 – Via Moodle (Turni)n). 23:59 CEST

-Part 2 Week 4. Deadline: 29th November 2020 – Via Moodle (Turni)n). 23:59 CEST

Weight:

-Part 1 is a 40% of your total grade for this subject.

-Part 2 is a 60% of your total grade for this subject.

Summa)ve assignment assesses the following learning outcomes:

• Part 1 Outcome: Demonstrate a working level and familiarity with prac)cal spreadsheet soGware formulae. Illustrate an awareness of how spreadsheet soGware op)mizes business opera)ons.

• Part 2 Outcome: Iden)fy and describe how companies are able to accurately measure corresponding IT infrastructures to suit their own needs and pur- pose. Illustrate an awareness of how spreadsheet soGware op)mizes business opera)ons. Demonstrate a working level and familiarity with prac)cal spreadsheet soGware formulae. Understand the impact Word Processing soGware plarorms have on a business’s overall profitability and success

Rubrics

ExcepLonal 90-100 Good 80-89 Fair 70-79 Marginal fail 60-69 ExcepLonal 90-100

Knowledge & Understan-

ding 30%

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.

CriLcal Thin- king 25%

There is good evidence of cri)cal appraisal of ideas and concepts, the insights are outstanding

Evidence of cri)cal analysis is generally weak but is at a reaso- nable level for this point in IT soGware for Busi- ness

There is some evidence of cri)cal appraisal of ideas and concepts, but the analysis and insights are rudimentary in terms of the IT soGware for Busi- ness

There is very limited evi- dence of cri)cal appraisal of ideas and concepts and those that are offered are weak

There is limited or no evi- dence of cri)cal appraisal of ideas and concepts in IT soGware for Business

ApplicaLon 25%

Applies knowledge and skills in familiar contexts with a high degree of effec)veness, providing relevant examples that support points.

Applies knowledge and skills in familiar contexts with considerable effec- )veness, providing some relevant examples that make a good atempt at suppor)ng points.

Applies knowledge and skills in familiar contexts with some effec)veness, providing examples alt- hough some may lack re- levance or provide limited support.

Applies knowledge and skills in familiar contexts with limited effec)veness, few/ irrelevant examples provided.

No applica)on of possible knowledge or ski- lls. No examples provided.

Communica- Lon 20%

Uses conven)ons, voca- bulary, and terminology of the discipline with a high degree of effec)ve- ness.

Uses conven)ons, voca- bulary, and terminology of the discipline with considerable effec)ve- ness.

Uses conven)ons, vocabu- lary, and terminology of the discipline with some effec)veness.

Uses conven)ons, vocabu- lary, and terminology of the discipline with limited effec)veness.

Lack of use of conven)ons, vocabulary, and termino- logy of the discipline.