Assessment Description Lithium ?? Australia ?? s ?? gold mine! ? ? Background: Australia supplies about 60 per cent of the world's lithium in the

Assessment Description

Lithium $\mathrm{â??}$ Australia$\mathrm{â??}$s $\mathrm{â??}$gold mine!$\mathrm{â?}$

$\mathrm{�}$ Background: Australia supplies about $\mathrm{60}$ per cent of the world's lithium in the form of a mineral

concentrate called spodumene. With an abundance of 'hard rock' lithium, we are amongst the

countries with the largest lithium deposits globally.

$\mathrm{â?¢}$ Business problem: As a member of Australia$\mathrm{â??}$s Department of Foreign Affairs & Trade, determine

whether Australia should give preference to China or USA when exporting Lithium, based on your

data analysis. Other trading partners for the export of Australian lithium can also be recommended.

$\mathrm{�}$ You will also be given a small amount of data on Lithium trading.

$\mathrm{�}$ The team has been asked to perform an analysis with visualisations $($Part A$),$ and present their findings

$($Part B$)$ to a Director from the Australian Department of Foreign Affairs and Trade.

$\mathrm{�}$ The reason for presenting to a government executive is to clarify which countries are preferable for

Australia to trade with for the export of Lithium, based on your data analysis.

See Part A and B Instructions below.

Kaplan Business School Assessment Outline

Data Sets

$\mathrm{�}$ You will be provided with the following Excel data sets in class in Week $\mathrm{6.}$

$\mathrm{�}$ Assessment $2$ Data File $1$A

$\mathrm{�}$ Assessment $2$ Data File Part A: Dashboard design

This should include:

$-$ Design of a simple dashboard with at least three charts $(6$ marks$)$

$-$ Construction of a dashboard that is easy to read and interpret $(4$ marks$)$

This may include:

$-$ Additional commentary accompanying the dashboard

Part B: Presentation of Dashboard and questions from the manager

This should include:

$-$ Presented aspects of the dashboard in a clear and engaging way as

follows:

$\mathrm{�}$ The Data Analyst will explain what data was available and the analysis.

$(4$ marks$)$

$\mathrm{�}$ The Data Visualiser will explain overall design consideration $(4$ marks$)$

$\mathrm{�}$ The Data Translator will explain aspects of the results in simple

language $(4$ marks$)$

$\mathrm{�}$ Questions from the executive must be concise and relevant $(4$ marks$)$

This may include

$-$ Very strong group dynamic