Computer Science · Class 11

Active learning ideas

Data Cleaning and Preprocessing

Active learning works especially well for data cleaning and preprocessing because students need to experience the real consequences of messy data. Handling errors themselves builds an intuitive grasp of why each method matters, which lectures alone cannot achieve.

• CBSE Learning Outcomes
• CBSE: Data Handling - Class 11

• 25–45 min
• Pairs → Whole Class
• 4 activities

Activity 01

• Collaborative Problem-Solving
• 30 min · Pairs

Pair Work: Dataset Audit

Provide pairs with a sample dataset containing missing values and inconsistencies. They list errors, choose handling methods, and apply fixes using spreadsheets. Pairs then swap datasets to verify each other's work.

Explain why data cleaning is a critical step before data analysis.

Facilitation Tip

During Pair Work: Dataset Audit, provide colour-coded printouts so pairs can physically circle errors before deciding how to fix them, making the process visual and collaborative.

What to look for

Present students with a small, pre-prepared table containing common data errors (e.g., a missing age, an outlier salary, inconsistent city names). Ask: 'Identify at least two types of errors present in this table and suggest one way to correct each error.'

• Apply
• Analyze
• Evaluate
• Create
• Relationship Skills
• Decision-Making
• Self-Management

Activity 02

• Collaborative Problem-Solving
• 45 min · Small Groups

Small Groups: Outlier Detection Challenge

Distribute datasets with outliers to small groups. Groups plot data, use IQR to identify outliers, and decide on removal or adjustment. They present findings and rationale to the class.

Differentiate between various techniques for handling missing data.

Facilitation Tip

During Small Groups: Outlier Detection Challenge, give each group a ruler to measure distances on printed box plots so they connect statistical positions to visual outliers.

What to look for

Pose the question: 'Imagine you are building a recommendation system for an e-commerce website. What kinds of data cleaning challenges might you encounter with user purchase history, and how could these challenges affect the recommendations given?' Facilitate a class discussion on their proposed solutions.

• Apply
• Analyze
• Evaluate
• Create
• Relationship Skills
• Decision-Making
• Self-Management

Activity 03

• Collaborative Problem-Solving
• 35 min · Whole Class

Whole Class: Cleaning Simulation

Project a large messy dataset. Class votes on issues via hand signals, then brainstorms strategies collectively. Implement top ideas live and discuss impact on summary statistics.

Critique a dataset for potential errors and propose cleaning strategies.

Facilitation Tip

During Whole Class: Cleaning Simulation, assign roles like 'data owner' and 'cleaner' so students hear each other articulate trade-offs between deletion and imputation.

What to look for

Give each student a card with a scenario (e.g., 'Cleaning data for a weather forecast model'). Ask them to write down: 1. One specific data quality issue they might find. 2. The technique they would use to address it. 3. Why that technique is appropriate for the scenario.

• Apply
• Analyze
• Evaluate
• Create
• Relationship Skills
• Decision-Making
• Self-Management

Activity 04

• Collaborative Problem-Solving
• 25 min · Individual

Individual: Personal Data Clean-Up

Students collect class survey data individually, clean it for missing entries and outliers, then compute basic statistics. Share cleaned versions in a class repository for comparison.

Explain why data cleaning is a critical step before data analysis.

Facilitation Tip

During Individual: Personal Data Clean-Up, set a strict 15-minute timer so students feel the pressure of real-world constraints and prioritise fixes accordingly.

What to look for

Present students with a small, pre-prepared table containing common data errors (e.g., a missing age, an outlier salary, inconsistent city names). Ask: 'Identify at least two types of errors present in this table and suggest one way to correct each error.'

• Apply
• Analyze
• Evaluate
• Create
• Relationship Skills
• Decision-Making
• Self-Management

A few notes on teaching this unit

Teachers should treat this topic as skill-building rather than theory. Avoid long lectures on methods; instead, let students fail with dirty data first, then guide them to discover corrections. Research shows that students retain cleaning techniques when they first experience the pain of unclean data themselves, so structure activities where errors have visible consequences.

Successful learning looks like students confidently identifying errors in raw data and justifying their chosen cleaning method. You will see them comparing 'before and after' datasets to prove that preprocessing improves data quality.

---

Watch Out for These Misconceptions

• During Pair Work: Dataset Audit, watch for students who immediately delete rows with missing values without discussing bias.

  Ask pairs to calculate the percentage of missing data and compare datasets before and after deletion; this will reveal how deletion shrinks the dataset and may skew results.

• During Small Groups: Outlier Detection Challenge, watch for students who remove all outliers without checking if they are valid extremes.

  Have groups plot the data before and after outlier removal and present whether the trend line changes significantly; this forces them to justify removal decisions.

• During Individual: Personal Data Clean-Up, watch for students who skip cleaning small datasets like class surveys, assuming errors are trivial.

  Require them to run a simple summary statistic (mean, median) before and after cleaning to demonstrate how even small errors shift results.

---

Methods used in this brief

• Collaborative Problem-Solving