Goal: By the end of this course, the students should be able to collect, clean, analyze, and
present data using Excel.
Course Content
Week 1: Introduction to Data & Excel Basics
What is Data? (Simple real-life examples: test scores, social media stats, game scores)
You don't currently have access to this content
Types of Data: Qualitative vs Quantitative
You don't currently have access to this content
Different Sources of Data
You don't currently have access to this content
Getting to Know Excel
You don't currently have access to this content
Hands-on Activity: Create a simple table of your favorite songs with artist, year, and rating
You don't currently have access to this content
Week 2: Data Entry, Cleaning & Sorting
Entering Data Accurately
You don't currently have access to this content
Spotting and fixing common errors
You don't currently have access to this content
Sorting and Filtering (e.g., filter top scores or sort by birth date)
You don't currently have access to this content
Removing duplicates
You don't currently have access to this content
Hands-on Activity: Clean a messy student score sheet
You don't currently have access to this content
Week 3: Basic Formulas and Functions
What are formulas? How do they work?
You don't currently have access to this content
Basic Functions: =SUM(), =AVERAGE(), =MAX(), =MIN(), =COUNT(), =IF()
You don't currently have access to this content
Using cell references (relative vs absolute)
You don't currently have access to this content
Hands-on Activity: Calculate total and average scores for a mock exam
You don't currently have access to this content
Mini-Project: Build a “Pocket Budget” sheet: pocket money, spending, balance
You don't currently have access to this content
Week 4: Data Visualization with Charts
Why visualize data?
You don't currently have access to this content
Types of Charts: Bar chart, Pie chart, Line chart
You don't currently have access to this content
Creating Charts in Excel
You don't currently have access to this content
Chart Customization: colors, labels, titles
You don't currently have access to this content
Hands-on Activity: Visualize favorite foods or school subjects’ popularity survey
You don't currently have access to this content
