Data storytelling guide
Unit 8 · Data Storytelling · CBSE Class 12 AI
How to Create a
Data Story
Complete guide — Freytag's Pyramid · 5 story topics with data · Charts and visualizations · Python code · CBSE Subject Code 843
Unit 8
Freytag's Pyramid
5 Topics
Python Charts
Board Exam Ready
What is Data Storytelling?
The 3 essential elements — all three must be present
📊
DATA
Accurate facts, numbers and statistics from reliable sources
📈
VISUALS
Charts, graphs, infographics that make data easy to understand
📝
NARRATIVE
The human story that connects data points and gives meaning
Definition (write this in exams): Data Storytelling is the practice of building a compelling narrative around a set of data, combined with visualizations, to help audiences understand and act on the insights.
Freytag's Pyramid — The 5-Stage Story Structure
Every data story must follow these 5 stages — important for board exams
1
Exposition (Introduction)
Set the scene. Introduce the topic, the time period, the geography, and the characters (who is affected). Give background context so the audience understands what they are looking at.
2
Rising Action (Building Evidence)
Present the data trends, patterns, and evidence. Show how the situation developed over time. Use charts and graphs here. Build suspense — something is changing, a problem is growing.
3
Climax (Key Insight / Turning Point)
The most important moment — the "aha!" finding. The single most significant data insight. The turning point where something changed dramatically. This is the heart of your story.
4
Falling Action (Analysis)
Analyse WHY the climax happened. Explore causes, contributing factors, and connections to other data. Compare before and after. Look for correlations and patterns.
5
Resolution (Conclusion + Call to Action)
Summarise key findings. What does the data tell us to do? Provide recommendations, solutions, or predictions. End with a clear message that the audience can act on.
6 Steps to Create Any Data Story
Follow these steps for every data story you create
01
Choose Your Topic and Audience
Decide: what is the story about? Who will read it — students, teachers, government officials, general public? The audience determines the language level, chart complexity, and narrative style.
Example: Topic = "Impact of COVID-19 on school education in India" → Audience = "Education policymakers"
Example: Topic = "Impact of COVID-19 on school education in India" → Audience = "Education policymakers"
02
Collect Reliable Data
Find data from trustworthy sources — government websites, research papers, UN reports, UNICEF, WHO. Check the data is: recent, accurate, complete, and relevant.
Key sources: data.gov.in, niti.gov.in, unicef.org, who.int, kaggle.com
Key sources: data.gov.in, niti.gov.in, unicef.org, who.int, kaggle.com
03
Explore and Analyse the Data
Look for: trends over time, comparisons between groups, unexpected outliers, correlations between two variables. Use Python Pandas or Orange Data Mining.
Ask: What is surprising? What confirms what we expected? What is the biggest change?
Ask: What is surprising? What confirms what we expected? What is the biggest change?
04
Find Your Key Insight (The Climax)
Identify the ONE most important finding in your data. Everything else in your story supports this central insight.
Example: "Girls' school dropout rates fell by 45% after the MDMS was launched in 1995 — the biggest improvement in any gender category."
Example: "Girls' school dropout rates fell by 45% after the MDMS was launched in 1995 — the biggest improvement in any gender category."
💡 Tip: If you cannot identify one clear key insight — your data analysis is not deep enough. Go back to step 3.
05
Choose the Right Charts
Different data needs different charts. Use the chart type guide below. Every chart must have: a clear title, labelled axes, legend if needed, and data source mentioned.
06
Write the Narrative Using Freytag's Pyramid
Write your story following the 5 stages. Each stage should be 2–4 sentences. Include a chart or visualization at each stage. End with a clear recommendation or call to action.
Length: A complete data story for a practical file should be 1–2 pages with 3–5 visualizations.
Length: A complete data story for a practical file should be 1–2 pages with 3–5 visualizations.
Which Chart to Use — Quick Guide
Line Chart
Use when: showing change over time
Example: Dropout rates from 1995–2023
Bar Chart
Use when: comparing categories
Example: Literacy rates by state
Pie Chart
Use when: showing parts of a whole
Example: Energy source breakdown
Scatter Plot
Use when: finding correlation between two variables
Example: Study hours vs marks
Histogram
Use when: showing frequency distribution
Example: Age distribution of patients
Stacked Bar
Use when: comparing categories AND their composition
Example: Male vs female enrollment by year
📌 Exam Tip: In board exams, if asked "which chart is best for showing trends over time" — answer is Line Chart. For comparing groups — Bar Chart. For parts of a whole — Pie Chart.
Story 1 — MDMS (Mid-Day Meal Scheme)
Mandatory CBSE sample — must be in your practical file
CBSE MANDATORY SAMPLE
How the Mid-Day Meal Scheme Transformed School Education (1995–2023)
Data: Student enrollment, attendance, and dropout rates since 1995 launch of MDMS
EXPOSITION
Background — India's Education Crisis in 1995
In 1995, India faced a severe education crisis — over 52% of students dropped out before completing primary school. Poverty forced children, especially girls, to stay home or work instead of attending school. The Government of India launched the Mid-Day Meal Scheme (MDMS) to provide free nutritious meals to enrolled students, hoping to attract and retain them in school.
📊 Chart: Bar chart showing pre-MDMS dropout rates by state (1994)
RISING ACTION
Trend — Enrollment Rising, Dropout Falling
From 1995 to 2004, MDMS was implemented in phases across India. Enrollment began rising steadily — particularly among girls and children from lower-income families. Simultaneously, dropout rates began declining from 52% in 1995 to 35% by 2003. The trend was clear but the full impact was yet to be seen.
📊 Chart: Line chart showing enrollment growth 1995–2023 with MDMS expansion milestones marked
CLIMAX
Key Insight — The 2004 National Expansion Changed Everything
When MDMS was expanded nationally in 2004, the impact was dramatic. Within 5 years, dropout rates fell from 35% to below 15%. Girls' enrollment increased by 40%. This was the turning point — the data clearly shows a before-and-after inflection point in 2004 that transformed India's primary education landscape.
📊 Chart: Comparison bar chart — Average dropout rate BEFORE 2004 (40%) vs AFTER 2004 (11%)
FALLING ACTION
Analysis — Why Did MDMS Work?
The data reveals multiple contributing factors: (1) Food security — families no longer needed children to work for food, (2) Attendance incentive — students came to school consistently, (3) Nutrition — better-nourished children could concentrate and learn better, (4) Social equity — all children ate together regardless of caste or income, reducing discrimination.
📊 Chart: Correlation scatter plot — MDMS coverage vs dropout rate by district
RESOLUTION
Conclusion — From 52% to 7% Dropout in 28 Years
By 2023, India's primary school dropout rate reached approximately 7% — a 7× improvement over 28 years. The MDMS serves 120 million children daily, making it the world's largest school meal programme. The data conclusively shows that nutritional support directly improves educational outcomes. Recommendation: Expand MDMS to secondary schools and ensure consistent quality of meals.
📊 Chart: Line chart showing full journey 1995–2023 with 52% → 7% clearly labelled
# MDMS Data Story — Python Visualization Code # Unit 8: Data Storytelling | CBSE Class 12 | Sub Code 843 import matplotlib.pyplot as plt import numpy as np years = [1995,1997,1999,2001,2003,2005,2007,2009, 2011,2013,2015,2017,2019,2021,2023] dropout = [52,48,44,40,35,28,22,18, 15,13,11,10,9,8,7] fig, ax = plt.subplots(figsize=(12,6)) # Main line ax.plot(years, dropout, color='#e74c3c', lw=3, marker='o', markersize=8, label='Dropout Rate %') # Fill area under line ax.fill_between(years, dropout, alpha=0.1, color='#e74c3c') # Mark MDMS national expansion ax.axvline(x=2004, color='#27ae60', ls='--', lw=2, label='MDMS National Expansion (2004)') ax.annotate('MDMS\nExpanded', xy=(2004, 30), xytext=(2006, 38), arrowprops=dict(arrowstyle='->', color='green'), color='#27ae60', fontweight='bold') # Labels and formatting ax.set_xlabel('Year', fontsize=12) ax.set_ylabel('Dropout Rate (%)', fontsize=12) ax.set_title('Impact of Mid-Day Meal Scheme on School Dropout Rates\n' 'India 1995–2023', fontsize=14, fontweight='bold') ax.legend(); ax.grid(alpha=0.3) ax.set_ylim(0, 60) plt.tight_layout() plt.savefig('mdms_story.png', dpi=150) plt.show() print("Chart saved as mdms_story.png")
Story 2 — Climate Change & Rising Temperatures
SDG 13 aligned — original story topic
SDG 13 · CLIMATE ACTION
India's Rising Temperature — A Data Story of Climate Crisis
Data: India Meteorological Department temperature records, extreme weather events frequency
EXPOSITION
The Planet is Warming — Introduction
India has experienced measurable temperature increases over the past century. This story explores temperature data from India Meteorological Department (1900–2023) to understand the scale, speed, and regional impact of climate change in India.
📊 Chart: India map showing temperature anomaly zones
RISING ACTION
The Trend — Gradual But Accelerating
India's average temperature has risen by 0.7°C since 1900 — with most of this rise occurring after 1980. Extreme heat events (days above 45°C) have doubled in frequency since 2000. Monsoon patterns are becoming irregular.
📊 Chart: Line chart — India average temperature 1900–2023
CLIMAX
Key Insight — The Last Decade is the Hottest in History
2023 was India's hottest year on record. 8 of the 10 hottest years in India's recorded history have occurred after 2010. Heatwaves in states like Rajasthan and Telangana reached unprecedented 50°C+ temperatures. This is the climate crisis in data.
📊 Chart: Bar chart — 10 hottest years in India, all post-2010 highlighted in red
FALLING ACTION
Causes — Carbon Emissions and Deforestation
Data analysis reveals strong correlation between India's CO₂ emissions (increased 300% since 1990) and temperature rise. Forest cover reduction of 15% since 1970 has further accelerated local warming. Industrial growth without sufficient green policy is the primary driver.
📊 Chart: Dual-axis chart — CO₂ emissions vs temperature rise 1990–2023
RESOLUTION
What We Must Do — Data-Backed Recommendations
If current trends continue, India's average temperature could rise by 2.4°C by 2050. Recommendation: Accelerate solar energy adoption (India has 300+ sunny days/year), increase forest cover by 33% as targeted, reduce single-use plastic, and strengthen climate education in schools.
📊 Chart: Projection line chart — temperature if current trend continues vs if action taken
Story 3 — Digital India: Internet Access Across States
SDG 9 — Industry, Innovation and Infrastructure
SDG 9 · DIGITAL DIVIDE
The Digital Divide — Who Has Internet Access in India?
Data: TRAI reports, Census digital access data, rural-urban internet penetration
EXPOSITION
India Goes Online — But Not Equally
India crossed 800 million internet users in 2023, making it the world's second largest internet market. However, this growth masks a stark inequality — urban and rural access rates differ dramatically, and some states lag far behind national averages.
📊 Chart: India's internet user growth 2010–2023 (line chart)
RISING ACTION
Urban vs Rural — A Growing Gap
Urban internet penetration stands at 67% while rural penetration is only 34% — a 2× gap. States like Kerala (72% penetration) and Delhi (69%) lead, while Bihar (27%) and Jharkhand (29%) lag significantly behind.
📊 Chart: Grouped bar chart — Urban vs Rural penetration by state
CLIMAX
Key Insight — JIO Effect: 2016 Changed Everything
When Reliance JIO launched in September 2016 with free data, India's internet user base jumped from 270 million to 500 million in just 18 months. Data costs fell from ₹250/GB to ₹10/GB. This single event democratised internet access more than any government policy.
📊 Chart: Bar chart showing internet users per year — massive spike in 2016-17
FALLING ACTION
Impact — Education, Business and Governance
The digital boom enabled: 500 million UPI transactions per month, 600 million YouTube viewers, massive growth in ed-tech (BYJU's, Vedantu). However, digital literacy remains a challenge — 40% of internet users can only access social media and videos, not utilise digital services for education or banking.
📊 Chart: Pie chart — how Indians use internet (social media, video, banking, education)
RESOLUTION
Bridging the Gap — What Next?
The digital divide is narrowing but not fast enough. Recommendations: Expand BharatNet fiber connectivity to all gram panchayats, increase digital literacy programmes in rural schools, make smartphones more affordable through subsidy programmes. True Digital India means equal access for all 1.4 billion citizens.
📊 Chart: Target vs actual connectivity progress 2020–2025
Story 4 — Women's Health in India
SDG 3 + SDG 5 — Health and Gender Equality
SDG 3 + SDG 5 · HEALTH + EQUALITY
Maternal Mortality in India — A Story of Progress and Challenges
Data: Sample Registration System (SRS) data, National Family Health Survey (NFHS) reports
EXPOSITION
Setting the Scene — What is MMR?
Maternal Mortality Rate (MMR) measures the number of women who die per 100,000 live births due to pregnancy or childbirth complications. In 1990, India's MMR was 556 — one of the highest in the world. This data story tracks India's progress toward SDG 3 target of MMR below 70 by 2030.
📊 Chart: World map heat chart — MMR by country comparison
RISING ACTION
Progress — A Steady Decline
India's MMR fell from 556 in 1990 to 103 in 2020 — an 81% reduction. Government schemes like Janani Suraksha Yojana (2005) provided cash incentives for institutional deliveries. Institutional delivery rate rose from 40% in 2000 to 89% in 2021.
📊 Chart: Line chart — India MMR 1990-2020 with key policy milestones
CLIMAX
Key Insight — Extreme State Inequality
The national average hides shocking state-level inequality. Kerala's MMR is just 19 (world-class) while Assam's MMR is 195 — a 10× difference within the same country. This inequality reveals that the real problem is not lack of knowledge but lack of access to healthcare in rural, remote states.
📊 Chart: Horizontal bar chart — MMR by state, sorted, showing Kerala vs Assam gap
FALLING ACTION
Root Causes — Why Some States Still Struggle
Analysis of high-MMR states reveals: fewer doctors per 1000 population, higher proportion of home deliveries, lower female literacy (correlation: r=0.78 between MMR and female literacy), and inadequate emergency obstetric care facilities in rural areas.
📊 Chart: Scatter plot — Female literacy rate vs MMR by state (showing negative correlation)
RESOLUTION
Path to SDG 3 Target — MMR Below 70 by 2030
At current rate of decline, India will achieve MMR of approximately 75 by 2030 — close but not reaching the SDG target of 70. Urgent recommendations for high-MMR states: increase trained midwives, build rural health centres, expand female literacy programmes, and improve emergency transport for pregnant women.
📊 Chart: Projection chart — actual MMR vs SDG 3 target line to 2030
Story 5 — India at the Olympics
Fun topic — great for student engagement
SPORTS DATA · STUDENT FAVOURITE
India's Olympic Journey — From 1 Medal to 7: A Data Story
Data: International Olympic Committee (IOC) results database, India at Olympics records
EXPOSITION
India's Olympic History — A Nation of 1.4 Billion
India has participated in the Olympics since 1900. Despite being the world's most populous democracy, India's Olympic medal count has historically been low. This story analyses India's performance data from 1948 to 2024 to understand the patterns, peaks, and growth trajectory.
📊 Chart: Timeline of India's Olympic participation 1900–2024
RISING ACTION
The Data Pattern — Hockey Dominance Then Long Drought
India won 8 Hockey Gold medals between 1928–1980 — a golden era. After 1980, India won just 1–2 medals per Olympics for 20 years. The data shows a clear "drought period" from 1984–2000 when India's medal count fell to zero multiple times.
📊 Chart: Bar chart — medals per Olympic year 1948–2024, hockey medals highlighted
CLIMAX
Key Insight — Tokyo 2020 Was India's Best Olympics Ever
At Tokyo 2020, India won 7 medals — the best ever performance including Neeraj Chopra's historic Gold in Javelin. Paris 2024 matched this with 6 medals. The data shows a clear acceleration after 2008 when India began investing seriously in athlete training programmes (Khelo India, Target Olympic Podium Scheme).
📊 Chart: Growth chart — medals per Olympics 2004 to 2024 showing clear upward trend
FALLING ACTION
Why the Improvement — Policy and Investment Data
Government sports spending increased 400% from 2010 to 2023. TOPS (Target Olympic Podium Scheme) supported 250+ athletes with personalised training. Analysis shows: states with higher sports infrastructure investment (Haryana, Maharashtra) produce more Olympic athletes — Haryana alone produced 4 medals at Tokyo.
📊 Chart: Scatter plot — state sports investment vs number of Olympic athletes produced
RESOLUTION
India's Olympic Future — Target 2028 Los Angeles
Based on current trajectory, India could win 10–12 medals at Los Angeles 2028. Priority recommendations: increase grassroots sports talent identification, expand Khelo India programmes to rural areas, build world-class training centres in Tier-2 cities, and use AI-based performance analytics (like CBSE AI students are learning!) to optimise athlete training.
📊 Chart: Prediction chart — projected medals 2028 and 2032 based on trend
Where to Find Real Data for Your Stories
| Topic | Dataset Source | Website |
|---|---|---|
| MDMS / Education | DISE Flash Statistics, UDISE+ data | udiseplus.gov.in |
| Climate Change | India Meteorological Department data | imd.gov.in |
| Internet Access | TRAI Telecom Subscription reports | trai.gov.in |
| Women's Health / MMR | Sample Registration System (SRS) | censusindia.gov.in |
| Sports / Olympics | IOC Results Database | olympics.com/en/results |
| Agriculture / Crops | Ministry of Agriculture data portal | data.gov.in/catalog/agriculture |
| Air Quality / Pollution | Central Pollution Control Board | cpcb.nic.in |
| Any Topic | India Open Government Data Platform | data.gov.in |
⭐ Board Exam Key Points — Unit 8 Data Storytelling
3 Elements (must memorise)
Data + Visualizations + Narrative. All three are required — missing any one makes it incomplete.
Freytag's 5 Stages
Exposition → Rising Action → Climax → Falling Action → Resolution. In order — always.
Correlation ≠ Causation
Two trends happening together does not mean one caused the other. Always mention other possible factors.
Ethics in Data Stories
Cherry-picking data, misleading chart scales, missing context — these are unethical and must be avoided.
Comments
Post a Comment