Lesson Planet
Search educational resources
  • Sign In Try It Free
  • AI Teacher Tools
    • Discover Resources Search reviewed educational resources by keyword, subject, grade, type, and more
    • Curriculum Manager (My Content) Manage saved and uploaded resources and folders To Access the Curriculum Manager Sign In or Join Now
    • Browse Resource Directory Browse educational resources by subject and topic
    • Curriculum Calendar Explore curriculum resources by date
    • Lesson Planning Articles Timely and inspiring teaching ideas that you can apply in your classroom
    • Our Story
    • Frequently Asked Questions
    • Testimonials
    • Contact Us
  • Pricing
  • School Access
    • Your school or district can sign up for Lesson Planet — with no cost to teachers
      Learn More
  • Sign In
  • Try It Free
Cleaning Data Lesson PlanCleaning Data Lesson Plan
Publisher
Code.org
Resource Details
Curator Rating
Educator Rating
Not yet Rated
Grade
9th - 12th
Subjects
STEM
1 more...
Resource Types
Handouts & References
1 more...
Audience
For Teacher Use
Duration
1 hr
Instructional Strategy
Hands-on Activity
Technology
Database & Spreadsheet
Internet Access
Lesson Plan

Cleaning Data

Curated and Reviewed by Lesson Planet
This Cleaning Data lesson plan also includes:
  • Excel Help
  • Google Sheets - Help Center
  • Join to access all included materials

"Clean the data!" "I did not know it was dirty." Introduce your class to the process of cleaning data so that it can analyze it. Groups work through a guide that demonstrates the common ways to filter and sort data. Pairs then discover that they need to summarize some data in a subjective way in order to analyze it. The activity builds critical thinking skills.

14 Views 10 Downloads

Concepts

data, data collection, data analysis, data representations, computer science, data sets, quantitative data, data organization, technology resources

Instructional Ideas

  • If survey data does not exist, you can create data that needs to be cleaned

Classroom Considerations

  • The lesson uses the survey data that students started collecting in the beginning of the unit
  • You will use the cleaned data in the following lesson, so be sure to save it
  • 13th lesson in a unit of 15

Pros

  • The lesson uses data that is personal to the class since they created it
  • The forum provides some insight in how to teach the lesson

Cons

  • If you are not comfortable working with raw data, this lesson may present a struggle

View 3,909 other resources for 9th - 12th Grade STEM

© 1999-2026 Learning Explorer, Inc.
Teacher Lesson Plans, Worksheets and Resources

Sign up for the Lesson Planet Monthly Newsletter

Open Educational Resources (OER)

  • Health
  • Language Arts
  • Languages
  • Math
  • Physical Education
  • Science
  • Social Studies
  • Special Education
  • Visual and Performing Arts
View All Lesson Plans

Discover Resources

  • Our Review Process
  • How it Works
  • How to Search
  • Create a Collection

Manage Curriculum

  • Edit a Collection
  • Assign to Students
  • Manage My Content
Contact Us Site Map Privacy Policy Terms of Use