Age Group: 11–14 – “Young Analysts”
Duration: 10–12 weeks
Objective: Use real-world tools (Excel, Tableau) and build mini data science projects.
Teaching Approach: “From learners to data storytellers – explore, analyze, and present with confidence”
🧩 Learning Focus:
- Use Excel and Tableau Public
- Analyze large datasets
- Tell compelling data stories
Week 1: What is Data Analytics?
Learning Outcome: Understand the data-to-insight journey
Tool: Excel
Sample Activity: Explore a simple dataset (e.g., student hobbies). Discuss what stories the data tells.
Week 2: Explore Real-World Datasets
Learning Outcome: Work with datasets from environment, sports, or education
Tool: Excel
Sample Activity: Analyze a dataset on global population or Olympic medals using sort and filter tools.
Week 3: Clean and Organize Data
Learning Outcome: Learn to clean and prepare data for analysis
Tool: Excel
Sample Activity: Remove duplicates, fix typos, and organize columns in a student survey dataset.
Week 4: Data Formatting & Basic Analysis
Learning Outcome: Format, apply formulas, and summarize data
Tool: Excel
Sample Activity: Use AutoSum, AVERAGE, and basic formatting to analyze daily screen time of students.
Week 5: Charts in Excel
Learning Outcome: Select and create visuals to represent data
Tool: Excel
Sample Activity: Create bar, pie, and line charts for data like favorite subjects or device usage.
Week 6: Introduction to Tableau Public
Learning Outcome: Learn Tableau interface and basic visual creation
Tool: Tableau Public
Sample Activity: Import cleaned Excel data and create bar and pie charts in Tableau.
Week 7: Visualizing with Tableau
Learning Outcome: Build interactive and visually appealing charts
Tool: Tableau Public
Sample Activity: Create a scatter plot (e.g., study hours vs marks) and use color to show gender or class groups.
Week 8: Dashboards in Tableau
Learning Outcome: Combine multiple visuals into dashboards
Tool: Tableau Public
Sample Activity: Create a dashboard on “How We Spend Our Weekends” using multiple charts.
Week 9: Compare & Analyze
Learning Outcome: Use both tools to compare variables
Tools: Excel + Tableau
Sample Activity: Compare “age vs screen time” or “gender vs sleep hours” to draw insights.
Week 10: Build Final Project
Learning Outcome: Plan, clean, visualize, and build a complete project
Tools: Excel + Tableau
Sample Activity: Choose a topic (e.g., health habits), clean data in Excel, and build visuals in Tableau.
Week 11: Present Insights
Learning Outcome: Present final dashboards and insights
Tools: Tableau Public + Class Presentation
Sample Activity: Showcase your dashboard, explain visuals, share insights, and answer peer questions.