Signal and Silence
A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.
- Domain
- Data Modeling
- Difficulty
- medium
- Seniority
- L4
Problem
We run a digital classroom platform for K-12 schools where teachers post assignments and students submit them, sometimes past the due date. Leadership wants engagement insights that separate students who merely saw an assignment surface in their feed from those who actually opened and read it, and that stay accurate even as rosters change: students transfer or drop mid-semester, and the same course runs as different sections under different teachers each school year. Design a model that keeps these engagement rates correct for both a single teacher's roster and a district-wide dashboard.
Summary
They opened the assignment. Did they actually read it?
Practice This Problem
Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it automatically.