Module 8 Assignment – Excel Tutorials

The following tutorial is an optional resource meant to assist you in navigating the databases and collecting the necessary data for your analysis.

Note on recording your responses: In the assignment you will find all the necessary fields to record your answers and the data you collect. You will also find an optional Answer Sheet Excel file to keep record of the collected data and your findings. You will find this file in the assignment’s introduction.

Step 1: Are deposit-taking institutions required to offer basic financial products in your country?

  1. In the M8 – Step-by-step guide to analyze problems identifying customers-databases Excel file, open the “Step 1– FICP-FS&FI” sheet.
  1. Right-click on the status bar at the bottom of the Excel window > In the dialog box that appears, ensure that the checkbox for “Average” is checked.
  1. Select the header row > click the Data menu > Select “Filter.”
  1. Locate the “Country” column > Uncheck “Select all” > Check the box for your country.
  1. Under the “Are deposit-taking institutions required to offer basic financial products?” column, locate the six requirements for your country and answer the question on the platform.

Step 1: According to current law or regulation, which of the following information must be submitted to open a deposit account with commercial banks?

  1. Open the “Step 1 – FICP CDD” sheet > Locate the “Country” column > Filter by your country.
  1. Locate the “Which of the following information must be submitted to open a deposit account with commercial banks?” header.
  1. Under the header, locate the “Commercial banks” cell >Find the six requirements for your country and answer the question on the platform.

Step 1: Can non-bank institutions issue e-money in your country?

  1. Open the “Step 1– FICP – FI & FS” sheet.
  2. Locate the “Country” column > Filter by your country.
  3. Under the “Can non-bank institutions issue e-money in your country?” column, find your country’s value and answer the question on the platform.

Step 1: According to current law or regulation, which of the following information must be submitted to open a deposit account with NBEIs?

  1. Open the “Step 1– FICP CDD” sheet.
  2. Locate the “Country” column > Filter by your country.
  3. Locate the “Which of the following information must be submitted to open a deposit account with commercial banks?” header.
  4. Under the header, locate the “NBEIs” cell >Find the six requirements for your country and answer the question on the platform.

Step 1: How does your country’s restrictiveness for banks compare with countries in the same income group?

  1. In the “Step 1– FICP CDD” sheet, locate the “Country” column > Filter by your country.
  2. Locate the “Number of restrictions (banks)” column > Find your country’s value.
  1. Locate the “Country” column > Apply the filter > Check “Select all.”
  1. Locate the “Income group” column > Filter by your income group.
  1. Locate the “Number of restrictions (banks)” column > Click and drag to select the entire range of cells under this column > Find the average at the bottom of the sheet, compare it with your country’s value and answer the question on the platform.

Step 1: How does your country’s restrictiveness for NBEIs compare with countries in the same income group?

  1. In the “Step 1– FICP CDD” sheet, locate the “Country” column > Filter by your country.
  2. Locate the “Number of restrictions (NBEIs)” column > Find your country’s value.
  1. Locate the “Country” column > Apply the filter > Check “Select all.”
  2. Locate the “Income group” column > Filter by your income group.
  3. Locate the “Number of restrictions (NBEIs)” column > Click and drag to select the entire range of cells under this column > Find the average at the bottom of the sheet, compare it with your country’s value and answer the question on the platform.

Step 1: Is remote account opening allowed?

  1. In the “Step 1– FICP CDD” sheet, locate the “Country” column > Filter by your country.
  2. Locate the “Is non-face-to-face (i.e. remote) account opening allowed?” cell > Find your country’s values and answer the question on the platform.

Step 1: Requirements/Account ownership graph

  1. Open the “Step 1 – FICP-Findex account” sheet.
  1. Locate an empty cell outside the data range, not associated with any row or column containing data > Click on the empty cell.
  1. Click the Insert menu > Locate the charts icons > click the Scatter plot icon > select “Scatter.”
  1. Click on the chart area > Click the Chart Design menu > click “Select data.”
  1. Make sure the “Show data in hidden rows and columns” checkbox from the “Hidden and Empty Cells” options is unmarked.
  1. Click on the + sign to add a series > In the “Name” field, type “Requirements/account ownership.”
  1. Click the “X Values” field > Select all cells under the “Number of restrictions (banks)” column.
  1. Click the “Y Values” field > Select all cells under the “Account (% age 15+)” column and select “OK”

  1. Right click on one of the data points > select “Add data label.”
  1. Right click on one of the data points > select “Format data label.”
  1. Under “Label contains” check “Value from cells” > Select all cells with values under the “Country” column > Press OK.
  1. Uncheck “Y value.”
  1. Analyze the output and answer the question on the platform.

Step 1: Requirements/Mobile money account ownership graph

  1. Open the “Step 1 – FICP-Findex mobile” sheet > Locate an empty cell outside the data range, not associated with any row or column containing data > Click on the empty cell.
  1. Click the Insert menu > Locate the charts icons > click the Scatter plot icon > select “Scatter.”
  2. Click on the chart area > Click the Chart Design menu > click “Select data.”
  3. Make sure the “Show data in hidden rows and columns” checkbox from the “Hidden and Empty Cells” options is unmarked.
  4. Click on the + sign to add a series > In the “Name” field, type “Requirements/mobile money account ownership.”
  5. Click the “X Values” field > Select all cells under the “Number of restrictions (NBEIs)” column.
  1. Click the “Y Values” field > Select all cells under the “Mobile money account (% age 15+)” column. Press “OK”

  1. Right click on one of the data points > select “Add data label.”
  2. Right click on one of the data points > select “Format data label.”
  3. Under “Label contains” check “Value from cells” > Select all cells with values under the “Country” column > Press OK.
  4. Uncheck “Y value” >Analyze the output and answer the question on the platform.

Step 1: Does your country score 0 or 100 in the Permitted identification indicator?

  1. Open the “Step 1 – GSMA MMRI” sheet > Locate the “Country” column > Filter by your country.
  1. Locate the “Year” column > Filter by the most recent year.
  1. Locate the “Permitted identification” column > Find your country’s value and answer the question on the platform.
  1. Repeat these steps for the “KYC requirements” and “KYC proportionality” indicators.

Step 1: In comparison: How does your country perform in the overall KYC score?

  1. In the “Step 1 – GSMA MMRI” sheet, locate the “Country” column > Filter by your country.
  2. Locate the “KYC overall” column > Find your country’s value.
  3. Locate the “Country” column > Apply the filter > Check “Select all.”
  4. Locate the “KYC overall” column > Click and drag to select the entire range of cells under this column > Find the average at the bottom of the sheet, compare it with your country’s value and answer the question on the platform.

Step 2a: What is your country’s ID ownership rate in the last year with information available?

  1. Open the “Step 2a – ID4D” sheet > Locate the “Country” column > Filter by your country.
  1. Locate the “Year” column > Filter by the most recent year.
  2. Locate the “ID ownership (% age 15+)” column > Find your country’s value and answer the question on the platform.

Step 2a: How has ID ownership in your country changed between 2017 and 2021?

  1. In the “Step 2a – ID4D” sheet > Locate the “Country” column > Filter by your country.
  2. Locate the “Year” column > Apply the filter > Check “Select all.”
  3. Locate the “ID ownership (% age 15+)” column > Compare your country’s values for both years and answer the question on the platform.

Step 2a: Compare your country’s ID ownership rate with the world average. Does your country score below the average?

  1. In the “Step 2a – ID4D” sheet, locate the “Country” column > Apply the filter > Check “Select all.”
  2. Locate the “Year” column > Filter by your country’s most recent year.
  3. Locate the “ID ownership (% age 15+)” column > Click and drag to select the entire range of cells under this column > Find the average at the bottom of the sheet, compare it with your country’s value and answer the question on the platform.

Step 2a: Does your country’s ID ownership rate score below the regional average?

  1. In the “Step 2a – ID4D” sheet, locate the “Country” column > Apply the filter > Check “Select all.”
  2. Locate the “Year” column > Filter by your country’s most recent year.
  3. Locate the “Region” column > Filter by your region.
  1. Locate the “ID ownership (% age 15+)” column > Click and drag to select the entire range of cells under this column > Find the average at the bottom of the sheet, compare it with your country’s value and answer the question on the platform.

Step 2a: Does your country’s ID ownership rate score below your income group average?

  1. In the “Step 2a – ID4D” sheet, locate the “Country” column > Apply the filter > Check “Select all.”
  2. Locate the “Year” column > Filter by your country’s most recent year.
  3. Locate the “Income group” column > Filter by your income group.
  4. Locate the “ID ownership (% age 15+)” column > Click and drag to select the entire range of cells under this column > Find the average at the bottom of the sheet, compare it with your country’s value and answer the question on the platform

Step 2a: What is the gap in ID ownership between men and women?

  1. In the “Step 2a – ID4D” sheet, locate the “Country” column > Filter by your country.
  2. Locate the “Year” column > Filter by your country’s most recent year.
  3. Locate the “ID gender gap” column > Find your country’s value and answer the question on the platform.

Step 2a: What is the gap in ID ownership between urban and rural population?

  1. In the “Step 2a – ID4D” sheet, locate the “Country” column > Filter by your country.
  2. Locate the “Year” column > Filter by your country’s most recent year.
  3. Locate the “ID urban/rural gap” column > Find your country’s value and answer the question on the platform.

Step 2a: What is the gap in ID ownership between richest and poorest population?

  1. In the “Step 2a – ID4D” sheet, locate the “Country” column > Filter by your country.
  2. Locate the “Year” column > Filter by your country’s most recent year.
  3. Locate the “ID richest/poorest gap” column > Find your country’s value and answer the question on the platform.

Step 2a: Is your country’s gender gap (Male/Female) significantly above your income group average?

  1. In the “Step 2a – ID4D” sheet, locate the “Country” column > Apply the filter > Check “Select all.”
  2. Locate the “Year” column > Filter by your country’s most recent year.
  3. Locate the “Income group” column > Filter by your income group.
  4. Locate the “ID gender gap” column > Click and drag to select the entire range of cells under this column > Find the average at the bottom of the sheet, compare it with your country’s value and answer the question on the platform.

Step 2a: Is your country’s location gap (Urban/Rural) significantly above your income group average?

  1. In the “Step 2a – ID4D” sheet, locate the “Country” column > Apply the filter > Check “Select all.”
  2. Locate the “Year” column > Filter by your country’s most recent year.
  3. Locate the “Income group” column > Filter by your income group.
  4. Locate the “ID urban/rural gap” column > Click and drag to select the entire range of cells under this column > Find the average at the bottom of the sheet, compare it with your country’s value and answer the question on the platform.

Step 2a:  Is your country’s population income gap (Poorest/Richest) significantly above your income group average?

  1. In the “Step 2a – ID4D” sheet, locate the “Country” column > Apply the filter > Check “Select all.”
  2. Locate the “Year” column > Filter by your country’s most recent year.
  3. Locate the “Income group” column > Filter by your income group.
  4. Locate the “ID richest/poorest gap” column > Click and drag to select the entire range of cells under this column > Find the average at the bottom of the sheet, compare it with your country’s value and answer the question on the platform.

Step 2a: Which option best represents your country?

  1. Open the “Step 2a – ID4D – Findex” sheet > Locate the “Income group” column > Filter by your income group.
  1. Locate an empty cell outside the data range, not associated with any row or column containing data > Click on the empty cell.
  2. Click the Insert menu > Locate the charts icons > click the Scatter plot icon > select “Scatter.”
  3. Click on the chart area > Click the Chart Design menu > click “Select data.”
  4. Make sure the “Show data in hidden rows and columns” checkbox from the “Hidden and Empty Cells” options is unmarked.
  5. Click on the + sign to add a series > In the “Name” field, type “ID/ account ownership.”
  6. Click the “X Values” field > Select all cells under the “ID ownership (% age 15+)” column.
  1. Click the “Y Values” field > Select all cells under the “Account (% age 15+)” column. Press “OK.”
  1. Right click on one of the data points > select “Add data label.”
  2. Right click on one of the data points > select “Format data label.”
  3. Under “Label contains” check “Value from cells” > Select all cells with values under the “Country” column > Press OK.
  4. Uncheck “Y value” >Analyze the output and answer the question on the platform.

Step 2b: Is there a National digital identity system/ program in place in your country?

  1. Open the “Step 2b – ITU” sheet > Locate the “Country” column > Filter by your country.
  1. Locate the “Value” column > Find your country’s value and answer the question on the platform.

Step 2b: Does your country collect biometrics for the national ID system?

  1. Open the “Step 2b – ID4D 2018” sheet > Locate the “Country” column > Filter by your country.
  1. Locate the “Fingerprint and/or iris biometrics collected” column > Find your country’s value and answer the question on the platform.

Step 2b: How does your country score in the E-Government Development Index (EGDI)?

  1. Open the “Step 2b – UN EGOV – 2022” sheet > Locate the “Country” column > Filter by your country.
  1. Locate the “E-Government Development Index” column > Find your country’s value and answer the question on the platform.

Step 2b: How does your country score in the Online Service Index?

  1. In the “Step 2b – UN EGOV – 2022” sheet, locate the “Country” column > Filter by your country.
  2. Locate the Online Service Index” column > Find your country’s value and answer the question on the platform.

Step 3: Simplified requirements graph

  1. Open the “Step 3 – Simplified requirement” sheet > Locate an empty cell outside the data range, not associated with any row or column containing data > Click on the empty cell.
  1. Click the Insert menu > Locate the charts icons > click the Scatter plot icon > select “Scatter.”
  2. Click on the chart area > Click the Chart Design menu > click “Select data.”
  3. Make sure the “Show data in hidden rows and columns” checkbox from the “Hidden and Empty Cells” options is unmarked.
  4. Click on the + sign to add a series > In the “Name” field, type “Informality/Simplified requirements/Account ownership.”
  5. Click the “X Values” field > Select all cells under the “Informal Employment – Total” column.
  1. Click the “Y Values” field > Select all cells under the “Account (% age 15+)” column. Press “OK.”
  1. Right click on one of the data points > select “Add data label.”
  2. Right click on one of the data points > select “Format data label.”
  3. Under “Label contains” check “Value from cells” > Select all cells with values under the “Country” column > Press OK.
  4. Uncheck “Y value” >Analyze the output and answer the question on the platform.

Step 3: Stricter requirements graph

  1. Open the “Step 3 – Stricter requirements” sheet > Locate an empty cell outside the data range, not associated with any row or column containing data > Click on the empty cell.
  1. Click the Insert menu > Locate the charts icons > click the Scatter plot icon > select “Scatter.”
  2. Click on the chart area > Click the Chart Design menu > click “Select data.”
  3. Make sure the “Show data in hidden rows and columns” checkbox from the “Hidden and Empty Cells” options is unmarked.
  4. Click on the + sign to add a series > In the “Name” field, type “Informality/Stricter requirements/Account ownership.”
  5. Click the “X Values” field > Select all cells under the “Informal Employment – Total” column.
  1. Click the “Y Values” field > Select all cells under the “Account (% age 15+)” column. Press “OK.”
  1. Right click on one of the data points > select “Add data label.”
  2. Right click on one of the data points > select “Format data label.”
  3. Under “Label contains” check “Value from cells” > Select all cells with values under the “Country” column > Press OK.
  4. Uncheck “Y value” >Analyze the output and answer the question on the platform.

Step 3: Is your country’s female informal employment rate above the global average?

  1. Open the “Step 3 – ILOSTATS – female” sheet, locate the “Country” column > Filter by your country.
  1. Locate the “Value” column > Find your country’s value.
  2. Locate the “Country” column > Apply the filter > Check “Select all.”
  3. Locate the “Value” column > Click and drag to select the entire range of cells under this column > Find the average at the bottom of the sheet, compare it with your country’s value and answer the question on the platform.

Step 3: Is your country’s female informal employment rate above your income group average?

  1. In the “Step 3 – ILOSTATS – female” sheet, locate the “Country” column > Filter by your country.
  2. Locate the “Value” column > Find your country’s value.
  3. Locate the “Country” column > Apply the filter > Check “Select all.”
  4. Locate the “Income group” column > Filter by your income group.
  5. Locate the “Value” column > Click and drag to select the entire range of cells under this column > Find the average at the bottom of the sheet, compare it with your country’s value and answer the question on the platform.