This assessment is of TWO PARTS and accounts for 100% of your total mark and the deadline for submission is on 10 January 2024 BEFORE 11:00 a.m.

Part One: Data Analytics using Excel (50%).

You need to download the data file titled: “AG Tradeflows-2020 (CW-Data)”, also you need to watch the video titled “BDA Coursework Data File”. Both the data file and related video explaining the data set are available on LC under the tab “Assessment & Feedback” .

For part one you are required to submit two files a PDF/Word Document and an Excel working file.

PDF/Word  document:  1) Introduction (150  words): explain from your perspective the objective of this coursework. 2) Stage one (200 words): summarise the tasks completed in this part and reflect on the change of sample size from one task to another. 3) Stage two (500 words): reflect on your analysis and designing your display panel. Stage three (500 words): provide short essay type of answers to the questions. 4) Conclusion (150): a self- reflection on your learning after completing this coursework by providing (e.g. pros vs cons analysis).

Excel Spreadsheet: you need to structure a similar spreadsheet to the one explained in the “Case Study: US Crude Oil Trade Flows”, which is part of week 5 learning material.

In doing so you are required to complete the following tasks:

Stage One: cleaning, manipulating and structuring the dataset.

You are required to clean and manipulate the dataset “AG-Tradeflows-2020” prior running analysis and structuring your final display panel.

1)  Before cleaning the data (by deleting not needed data columns) you need to filter the dataset to only include shipments from “Saudi Arabia” and only for the period 2020 by filtering the data columns “Load Country” and “Departure Data”, respectively and accordingly.              (2%)

2)  Create the following new variable “Cargo” by multiplying the column “Volume” by 1000 (Volume × 1000).          (2%)

. If you use any image in your report, put it in the folder (img)

. If you use any rscript create a new folder (rscrip) and put all files there

. Feel free to create new folders , if required

4.   Use qmd to write your report. It should contain the following sections:

. Introduction:

The introduction should introduce your general topic and what you aim to do and

most importantly

. Business context and problem

Describe your research question/assumption, etc and what you want to know

about your data

. Data

Describe where it came from, what are the variables, a summary of variables.

. Data analysis & discussion

.    data  wrangling and visualisations to ensure the data quality and tidy format

.    Follow  the principles of a good visualisation in designing plots that answer your questions

.    Use R code to prepare your data and create visualisations

.    Explain how the visualisation/s help you learn more about your data. What is your conclusion based on visualisations?

5.   Conclusions

Marking

General Criteria

.     Content - What is the quality of research and/or policy question and relevancy of data to those questions?

.     Correctness  - Are data wrangling, visualisation and related R code carried out and explained correctly?

.     Writing and Presentation  -  What is the quality of the presentation, writing, and explanations?

.     Creativity and Critical Thought  -  Is  the project carefully thought out? Are the limitations carefully considered? Does it appear that time and effort went into the planning and implementation of the project?

The coursework should be NO MORE THAN 3,000 WORDS IN LENGTH and all sources should be acknowledged in the appropriate place in the text. You are advised to use the Cardiff Harvard referencing system.

Submission is on Wednesday 10th  of January 2024

Essays must be submitted online on Learning Central BEFORE 11:00 a.m.

Note: You are also advised to attach a cover sheet containing: the module code, module title, lecturer’s name, scheme of study and student number.

References

Ensure all sources of information are referenced correctly using the Cardiff Harvard Style of Referencing – if unsure see the handout from the library.

Unfair Practice

This is an individual assignment, and you are advised not to engage in any activity that might

lead to suspicions of Unfair Practice. Details of the University Regulations may be found at

https://intranet.cardiff.ac.uk/students/your-study/exams-and-assessment/sitting-

yourexam/cheating-and-unfair-practicand you should familiarise yourself with these regulations before starting your coursework.

On the front page of the assignment, you should include:

.    Student number

.    Title of coursework

.    Title of Module and module number

.    Name of lecturer

.    Date of submission

.    Word count

Students are advised to keep a second copy for themselves. Should there be special circumstances that mean you are unable to meet the submission deadline, you must obtain an extension from the Chair of the Board of Examiners. Forms are available from room A-04 or Learning Central. If you are not in Cardiff, then contact your Personal Tutor.

Coursework marking-criteria

For 90%+

An outstanding piece of work, showing mastery of the subject matter, with a highly developed ability to analyse, synthesise and apply knowledge and concepts.  All objectives of the assignment are covered and the work is free of error with very high level of technical competence. There is evidence of critical reflection; and the work demonstrates originality of thought, and the ability to tackle questions and issues not previously encountered. Ideas are expressed with fluency. All coursework requirements are met and exceeded.

For 70% - 89%

An excellent piece of work, showing a high degree of mastery of the subject matter, with a well-developed ability to analyse, synthesise and apply knowledge and concepts.  All major objectives of the set work are covered, and work is free of all but very minor errors, with a high level of technical competence.  There is evidence of critical reflection, and of ability to tackle questions and issues not previously encountered.  Ideas are expressed clearly. However the originality required for a 90+ mark is absent.  All coursework requirements are met and some are exceeded.

For 60%-69%

A very good piece of work, showing a sound and thorough grasp of the subject-matter, though lacking the breadth and depth required for a first class mark.  A good attempt at analysis, synthesis and application of knowledge and concepts, but more limited in scope than that required for a mark of 70+.  Most objectives of the work set are covered.  Work is generally technically competent, but there may be a few gaps leading to some errors.   Some evidence of critical reflection, and the ability to make a reasonable attempt at tackling questions and issues not previously encountered.  Ideas are generally expressed with clarity, with some minor exceptions.  All coursework requirements are addressed adequately.

For 50%-59%

A fair piece of work, showing grasp of major elements of the subject-matter but possibly with some gaps or areas of confusion.   Only the basic requirements of the work  are covered.   The  attempt at analysis, synthesis and application of knowledge and concepts is superficial, with a heavy reliance on course materials.   Work may contain some errors, and technical competence is at a routine level only. Ability to tackle questions and issues not previously encountered is limited.  Little critical reflection.   Some confusion and immaturity in expression of ideas.  Most coursework requirements are addressed.

For 40%-49%

A poor piece of work, showing some familiarity with the subject matter, but with major gaps and serious misconceptions. Only some of the basic requirements of the work set are achieved. Little or no attempt at analysis, synthesis or application of knowledge, and a low level of technical competence, with many errors.  Difficulty in beginning to address questions and issues not previously encountered.   Some intended learning outcomes are achieved.

For 30%-39%

Work not of passable standard, with serious gaps in knowledge of the subject matter, and many areas of confusion. Few or none of the basic requirements of the work set are achieved, and there is an inability to apply knowledge. Technical competence is poor, with many serious errors. The student finds it difficult to begin to address questions and issues not previously encountered.  The level of expression and structure is very inadequate.  Few intended learning outcomes are achieved.

Below 30%

A very poor piece of work, showing that the student has failed to engage seriously with any of the subject matter involved, and/or demonstrates total confusion over the requirements of the work set.   Virtually none  of the intended learning outcomes are achieved.