AP CSP 2.3 Exercise 2: Messy Dataset Rescue

Big Idea 2 · Topic 2.3 · Exercise 2

Messy Dataset Rescue

25 minutes - 3 rescues - LO DAT-2.C

Back to the Topic 2.3 lessonAll CSP topics

How this page works

The writing boxes below are yours. What you type stays in this browser, is saved here as you go, and is never sent to us or to your teacher. Hand the written work in the way your teacher asked for it.

The graded check at the bottom is the part that records to your teacher's gradebook.

The cases, from your handoutNot recorded

The same cases as your handout, in the same order.

Scenario 1 · Foundational

The robotics club's sign-up spreadsheet has an open 'grade level' field. The column contains: 9, 9th, ninth, Freshman, 10, tenth, and two empty cells. The club president needs an accurate count of students per grade by Friday.

Challenge named (which CED problem is this):

Fix + justification (what you would do and why it's allowed):

Second consideration to layer (enrichment):

Scenario 2 · Core

The cafeteria surveys students about new menu options - but the survey link is posted only in the athletics team app. 900 responses arrive, overwhelmingly requesting high-protein options. The cafeteria director, thrilled with the turnout, proposes extending the survey two more weeks to 'make the data even stronger.'

Challenge named (which CED problem is this):

Fix + justification (what you would do and why it's allowed):

Second consideration to layer (enrichment):

Scenario 3 · Challenge

A statewide fitness study collects 200 million sensor readings. The lead researcher's laptop crashes every time the file opens, and the team debates two proposals: (a) delete 90% of the readings so the laptop can cope, or (b) find a better way to process all of them. The grant also requires the study to keep growing for five more years.

Challenge named (which CED problem is this):

Fix + justification (what you would do and why it's allowed):

Second consideration to layer (enrichment):

No graded check on this page yetNot recorded

About the line in your handout

Your handout says this exercise is available online and auto-graded. The exercise IS here, and it is the same work in the same order, but the auto-graded half is not written for this topic yet. Nothing on this page is scored or sent to your teacher.

Hand this in the way your teacher asked for it. Topic 1.1 has its graded check today, and the rest follow.

Get in Touch

Whether you're a student, parent, or teacher — I'd love to hear from you.

Just want free AP CS resources?

Enter your email below and check the subscribe box — no message needed. Students get daily practice questions and study tips. Teachers get curriculum resources and teaching strategies.

Typically responds within 24 hours

Message Sent!

Thanks for reaching out. I'll get back to you within 24 hours.

🏫 Welcome, fellow educator!

I offer curriculum resources, practice materials, and study guides designed for AP CS teachers. Let me know what you're looking for — whether it's classroom materials, a guest speaker, or Teachers Pay Teachers resources.

Email

[email protected]

📚

Courses

AP CSA, CSP, & Cybersecurity

Response Time

Within 24 hours

Prefer email? Reach me directly at [email protected]