TASK 1: Finding the data from databanks:
Download/produce an Excel spreadsheet including the data for your selection of 2 countries. Data that are required in your spreadsheet are as follows:
➢ Gross Domestic Product (Nominal GDP)
➢ Inflation rate
➢ Unemployment rate
➢ Interest rate
➢ Money Supply
➢ Covid-19 data (monthly/Case data)
Ex: First six columns of your Excel worksheet must contain the variables that you download:
Year/Month GDP Inflation Unemployment Interest Rate Money Supply Covid-19
(You are free to select any 2 countries but comparable countries are recommended).
· Put the years in Column A and your countries’ data through the other columns seen above.
· The year data series are from 2000 to present.
· Covid-19 data will be since December 2019, will be monthly.
· Name your file as Term Project_Name and Surname_ Data.xlsx
· Use the data sources that we discussed in the lecture: For this project, you need to use the data sources like: TURKSTAT, World Bank, OECD, IMF, Penn World Table, and etc.
TASK 2: Develop your research (2 or more pages):
➢ An introduction in which you are expected to explain: what type of data that you are studying with (quantitative, qualitative, time-series, panel or cross sectional, etc.). A brief statement about the selected countries: their location, geographic size, population, anything you think that might be useful to mention, as it will improve the quality of your research.
➢ A paragraph describing the data. Produce a summary statistics, explain how the data change (over what intervals is the GDP (or other data) increasing, decreasing or constant) and variate, what are the trends, comment on the descriptive statistics.
➢ Create charts (Scatter plot, line, bar, combo, etc.) for all variables (GDP, Inflation, Unemployment, Interest Rate, Money Supply and Covid-19) individually and for both countries. Make sure to have time on the vertical axis and your data on the horizontal axis. Format the chart by doing the followings:
· Give a title to your chart.
· Format the scale on the vertical axis to include dollar signs and 1000’s place commas.
Example: Label the horizontal axis appropriately, including units, and display the units on the GDP somewhere on the chart. (Tip: Look for “Number” in the vertical axis’ dialog box.)
➢ Compare the countries. Use proper charts to compare both countries, comment on these charts: which country surpasses the other one on which variable, etc. Remember, once you produce the charts in Excel, you can copy and paste it directly into a word file. Within the word file, you can change the formatting (colors, fonts, labels, line thickness and etc. if needed.)
➢ Show the current trend. Create a chart showing only the current trend, along with your model, labeling axes and providing a title.
TASK 3: Relationships (1 or 3 pages long):
1. What is the relationship between;
· GDP – Unemployment.
· GDP – Money Supply,
· GDP – Interest rate,
· GDP – Inflation rate
· GDP – Money supply
· GDP – Covid-19
· Covid-19 – Interest rate
· ……………………
Ø Use graphs and correlation analysis to show these relationships: comment on these relationships, think about whether there are structural breaks (i.e., sudden immense changes) or crisis during your observation interval and if so, how these may affect the stated relationships.
TASK 4. Findings in relation to Covid-19 (1 or 3 pages long):
Write a summary based on your general findings so far in relation to Covid-19 considering the aspects below.
Ø Think about the macroeconomic indicators of two countries since December 2019. How does Covid-19 affect the countries? (Think about the country risk)
· Exchange Rate
· Inflation Rate
· Interest Rate
· Unemployment and Employment Rates
· Health System: Health Expenditure, Health Packages
Ø Why is the financial sector so important for an economy in terms of a macro perspective? How is the financial system affected by Covid-19?
Ø How is the education affected by Covid-19?
References
Write the references you used including data sources, news sources, academic papers, etc., with APA citation style

BAHÇEŞEHİR UNIVERSITY DEPARTMENT OF ECONOMICS

ECO1163- RESEARCH METHODS AND STATISTICS I

TERM PROJECT_2020

1. Read the whole instruction and then start preparing the Term Project.
2. Prepare the project using Microsoft programs. Particularly, a power point presentation of your project, your project in Word including all details, an Excel Workbook showing your data and tools (such as graphs, functions etc.) requested to use.
3. Upload all documents to Itslearning.

4. Careless assignments such as untidy, illegible etc. will not be evaluated
.

5. Documents sent to the instructor via e-mail and Itslearning chat box will not be evaluated.

6. Do not wait until the last seconds of the deadline, as no excuse will be accepted for late submission. Documents sent after the deadline will not be evaluated and graded as 0.

7. Your project must be min 10- max 15-pages long, left-aligned, 1.5 line spacing with a font-size of 12 and normal margins, well-organized and well-written research paper.
8. Plagiarism is strictly forbidden. All projects will be evaluated first by plagiarism detection program called Turnitin.
9. Use your own words (i.e. paraphrase the sentences) when gathering information from academic or non-academic sources in order to avoid plagiarism. Projects with Turnitin score greater than 20% will be immediately graded as 0.

10. The time interval for your data must be from 2000 to the recent available data point.

11. Each student must select two countries for the project where at most one country can coincide with another student’s/Group’s choice, e.g., if student / Group A and B choose the U.S.A and the U.K, their project will be treated as duplicate and both graded as 0. However, if student A /Group A chooses the U.S.A and the U.K while student B /Group B chooses the U.K and Germany, both student / group will be graded. To avoid such overlaps, communicate through Teams using ECO 1163 course page under General channel. Drop a line of your country choices to inform other students (first-come-first-serve basis). It is the student’s responsibility to regularly check this communication.
12. There will be group work but maximum with 2 students. Performance will be evaluated based on each contribution to the project.

13. You should type your name & surname and selected countries in itslearning sytem. (you can see a word document under the resources)

14. The deadline for the upload of the documents in Itslearning is 3th of January 2021. Presentations will be held on in last two weeks of the semester.

The purpose of this report is to present your Excel skills when preparing a report. In the meanwhile, you will learn about the economic consequences of the Covid-19 on selected countries and global economy.

You have to use Excel Worksheet (COMPULSORY) to manipulate the data, a research paper in Word (COMPULSORY) and a Power Point Presentation (needed only for presentation) to present the findings.

TASK 1: Finding the data from databanks:

Download/produce an Excel spreadsheet including the data for your selection of 2 countries. Data that are required in your spreadsheet are as follows:

➢ Gross Domestic Product (Nominal GDP)
➢ Inflation rate
➢ Unemployment rate
➢ Interest rate
➢ Money Supply
➢ Covid-19 data (monthly/Case data)

Ex: First six columns of your Excel worksheet must contain the variables that you download:

Year/Month

GDP

Inflation

Unemployment

Interest Rate

Money Supply

Covid-19

(You are free to select any 2 countries but comparable countries are recommended).

· Put the years in Column A and your countries’ data through the other columns seen above.
· The year data series are from 2000 to present.

· Covid-19 data will be since December 2019, will be monthly.

· Name your file as Term Project_Name and Surname_ Data.xlsx

· Use the data sources that we discussed in the lecture: For this project, you need to use the data sources like: TURKSTAT, World Bank, OECD, IMF, Penn World Table, and etc.

TASK 2: Develop your research (2 or more pages):

➢ An introduction in which you are expected to explain: what type of data that you are studying with (quantitative, qualitative, time-series, panel or cross sectional, etc.). A brief statement about the selected countries: their location, geographic size, population, anything you think that might be useful to mention, as it will improve the quality of your research.

➢ A paragraph describing the data. Produce a summary statistics, explain how the data change (over what intervals is the GDP (or other data) increasing, decreasing or constant) and variate, what are the trends, comment on the descriptive statistics.

➢ Create charts (Scatter plot, line, bar, combo, etc.) for all variables (GDP, Inflation, Unemployment, Interest Rate, Money Supply and Covid-19) individually and for both countries. Make sure to have time on the vertical axis and your data on the horizontal axis. Format the chart by doing the followings:

· Give a title to your chart.
· Format the scale on the vertical axis to include dollar signs and 1000’s place commas.
Example: Label the horizontal axis appropriately, including units, and display the units on the GDP somewhere on the chart. (Tip: Look for “Number” in the vertical axis’ dialog box.)

➢ Compare the countries. Use proper charts to compare both countries, comment on these charts: which country surpasses the other one on which variable, etc. Remember, once you produce the charts in Excel, you can copy and paste it directly into a word file. Within the word file, you can change the formatting (colors, fonts, labels, line thickness and etc. if needed.)

➢ Show the current trend. Create a chart showing only the current trend, along with your model, labeling axes and providing a title.

TASK 3: Relationships (1 or 3 pages long):

1. What is the relationship between;

· GDP – Unemployment.
· GDP – Money Supply,
· GDP – Interest rate,
· GDP – Inflation rate
· GDP – Money supply
· GDP – Covid-19
· Covid-19 – Interest rate
· ……………………

· Use graphs and correlation analysis to show these relationships: comment on these relationships, think about whether there are structural breaks (i.e., sudden immense changes) or crisis during your observation interval and if so, how these may affect the stated relationships.

TASK 4. Findings in relation to Covid-19 (1 or 3 pages long):

Write a summary based on your general findings so far in relation to Covid-19 considering the aspects below.

· Think about the macroeconomic indicators of two countries since December 2019. How does Covid-19 affect the countries? (Think about the country risk)
· Exchange Rate
· Inflation Rate
· Interest Rate
· Unemployment and Employment Rates
· Health System: Health Expenditure, Health Packages
· Why is the financial sector so important for an economy in terms of a macro perspective? How is the financial system affected by Covid-19?
· How is the education affected by Covid-19?

References

Write the references you used including data sources, news sources, academic papers, etc., with APA citation style.