// module overview
This module is built around a single exercise that tends to stop people cold the first
time they run it. You start with a list of 25 students flagged as chronically absent.
You join that list to the cultural holiday calendar. You recalculate.
Twenty students drop off the list.
Not because the attendance data was wrong, but because the school recorded absences during Diwali, Eid, Lunar New Year, and Yom Kippur as "unexcused" — and the algorithm treated them as truancy. This module teaches you to build the cultural context check that the flagging system should have run in the first place.
Twenty students drop off the list.
Not because the attendance data was wrong, but because the school recorded absences during Diwali, Eid, Lunar New Year, and Yom Kippur as "unexcused" — and the algorithm treated them as truancy. This module teaches you to build the cultural context check that the flagging system should have run in the first place.
// key insight
An algorithm that doesn't know about Eid isn't neutral — it's biased. The data is only as equitable as the context you bring to it.
// what you'll learn
What Educators Will Learn
- What a 'false positive' is in data terms — and why it matters for real students
- How absence coding practices create inequitable outcomes for students from non-dominant cultures
- Why cultural holidays deserve the same default respect as federal holidays in absence coding
- How to bring context data into a conversation with a family before making assumptions
- A practical process for reviewing at-risk flags through a cultural lens before acting on them
Python Walkthrough
- Loading the cultural holiday calendar and student context tables
- Performing a multi-table join: students → attendance → cultural group → holiday calendar
- Filtering absences that fall within holiday date ranges using
pd.merge_asof() - Recalculating absence counts after removing culturally-aligned absences
- Building a comparison: original at-risk list vs. equity-adjusted list — visualizing who was removed and why