AP CSP 2.4 Exercise 2: Insight Pipeline Designer

Big Idea 2 · Topic 2.4 · Exercise 2

Insight Pipeline Designer

25 minutes - 3 datasets - design the passes

Back to the Topic 2.4 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 student council has a clean spreadsheet of 1,850 spirit-wear orders (date, item, size, price). Their question: 'What actually sells?' Design pass 1.

Pass 1 pipeline (moves in order, CED names):

Insight pass 1 yields + the follow-up question it raises:

Pass 2 change - the one move you add or swap, and why order matters (enrichment):

Scenario 2 · Core

The library's checkout log lists genres as 'SciFi,' 'sci-fi,' and 'Science Fiction,' and some books were scanned twice at checkout. The librarian's question: 'Which genres should we expand?'

Pass 1 pipeline (moves in order, CED names):

Insight pass 1 yields + the follow-up question it raises:

Pass 2 change - the one move you add or swap, and why order matters (enrichment):

Scenario 3 · Challenge

The athletics director has fall game attendance from the ticket scanners and a separate weather log from the district. The question: 'Does weather actually hurt our gate?'

Pass 1 pipeline (moves in order, CED names):

Insight pass 1 yields + the follow-up question it raises:

Pass 2 change - the one move you add or swap, and why order matters (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]