Data project
Make a chart people can read
Explain how Viet Nam’s urban population share changed from 1990 to 2020. Make a line chart and a short brief that distinguishes what you found from why it happened.
What you’ll finish with
One labeled chart, one sentence on the change in percentage points, and a source note. The brief should make sense to someone who has never seen your sheet.Build it in 4 steps
-
Read the unit before charting
2 hrMake
Import the CSV. Use commas as separators and confirm the population-share column contains numbers. Write down the question and the unit in a worksheet note.
LibreOffice · Import a CSV ↗Check
You can explain that 35 means roughly 35 out of every 100 people, and your years run from 1990 to 2020.
-
Calculate the change in share
2 hrMake
Subtract the 1990 percentage from the 2020 percentage. In the sample as shipped, these are cells B2 and B32. Keep the result in percentage points.
World Bank · Indicator definition ↗Check
Your result is about 16.4 percentage points. Check that year and value rows stayed together if you sorted them.
-
Draw a clean line chart
3 hrMake
Chart year on the horizontal axis and urban population share on the vertical axis. Add a specific title, show the unit, and keep the first and last years readable.
Google Sheets · Line charts ↗Check
The title names the place and time range. Your vertical scale is visible and your sheet contains all 31 years.
-
Write a three-sentence brief
2 hrMake
Name the question, describe the trend and its size, then note that the indicator uses national definitions. Add the World Bank source under the chart.
World Bank · Source and methodology ↗Check
A reader sees a change in share, the year range, and where the numbers came from. A claim about causes would need separate evidence.