Duration: 8 Weeks
Total Hours: 24 Hours (3 Hours per Week)
Level: Beginner to Intermediate
Target Group: Grade 7–10
Course Content: FLYER
Students will explore data analysis using:
Python
Jupyter Notebook
Microsoft Excel
Microsoft Power BI
SQL & relational databases
📅 Course Structure (8 Weeks | 24 Hours)
📌 Week 1 – Introduction to Data & Excel Basics
Topics
What is data? (structured vs unstructured)
Types of data (numeric, categorical, time-based)
Introduction to Microsoft Excel
Sorting, filtering, basic formulas (SUM, AVERAGE)
Activity
📊 Analyze a class survey dataset
Create simple charts (bar, pie, line)
Mini Project: Build a Student Performance Tracker in Excel
🧹 Week 2 – Data Collection & Data Cleaning
Topics
Data collection methods (survey, forms, observation)
Common data errors (missing, duplicates, incorrect format)
Data cleansing techniques
Introduction to data sharing ethics
Activity
📋 Conduct a School Data Collection Challenge
Clean messy dataset in Excel
Mini Project: Create a Clean Dataset Report with before/after comparison
🐍 Week 3 – Introduction to Python & Jupyter
Topics
Basics of Python
Running code in Jupyter Notebook
Variables, lists, basic calculations
Reading simple datasets
Activity
🧮 Perform data calculations in Python
Generate summary statistics
Mini Project: Build a Simple Data Analyzer Script
🗄️ Week 4 – Databases & SQL Fundamentals
Topics
What is a database?
Tables, rows, columns
SQL basics (SELECT, WHERE, COUNT, GROUP BY)
Introduction to OLTP vs OLAP systems
Activity
🔎 Query a sample school database
Compare transaction systems vs analytics systems
Mini Project: Create SQL queries to answer business questions
🔄 Week 5 – Data Pipelines & Data Flow
Topics
What is a Data Pipeline?
Data collection → storage → processing → analysis → reporting
Data integration basics
Data sharing practices
Activity
🏗️ Draw a data pipeline diagram for a YouTube channel or school system
Mini Project: Design a Data Pipeline Plan for a small business
📈 Week 6 – Data Visualization & Dashboarding
Topics
Principles of good data visualization
Introduction to Microsoft Power BI
Creating charts and dashboards
KPIs (Key Performance Indicators)
Activity
📊 Build an interactive dashboard
Compare good vs misleading graphs
Mini Project : Create a Sales or School Performance Dashboard
🧠 Week 7 – Data-Driven Insights & Decision Making
Topics
Turning data into insights
Identifying trends and patterns
Making data-driven decisions
Communicating findings effectively
Activity
📉 Analyze a case study dataset
Present insights in small groups
Mini Project : Create a Data Insight Presentation
🚀 Week 8 – Final Project & Presentation
🎓 Capstone Project – Data Analysis Challenge
Project Scenario
Students choose one:
School attendance analysis
Sports performance analysis
Small business sales analysis
Social media engagement analysis
Requirements
Data collection or provided dataset
Data cleaning
Basic SQL or Python analysis
Dashboard (Excel or Power BI)
Final report with insights and recommendations
Presentation
5–7 minute presentation explaining:
Problem
Data used
Analysis process
Key insights
Suggested decisions
🛠 Tools & Technologies
Python
Jupyter Notebook
Microsoft Excel
Microsoft Power BI
SQL (MySQL / SQLite recommended)