Student Attendance Dashboard — California chronic absenteeism & ADA check

For California K-12 attendance clerks, assistant principals and district data leads. Type one student's year-to-date numbers. The CDE rule: a student expected to attend 31 or more days who misses 10% or more of them is chronically absent.

—

Days absent	—
Absence rate (of days expected)	—
Eligible for the chronic absence count (31+ days expected, 1+ attended)	—
CDE status	—
Absence days left before the full-year 10% line	—
ADA value of these absences (CDE 2025–26 rate)	—

—

Why a free attendance template gets a different number

A generic template divides days attended by days enrolled. The CDE count first drops students expected to attend fewer than 31 days, then counts a student as chronically absent at 10% or more of the days they were expected to attend. The rate is chronically absent students divided by eligible students. Excused absences count as absences too.

What the paid .twb contains (8 calculated fields)

Days Absent — [Days Expected to Attend] - [Days Attended]
Chronic Eligible — 31+ days expected and 1+ day attended
Chronically Absent — eligible and absent 10% or more of expected days
Chronic Absenteeism Rate — chronically absent ÷ eligible students
Attendance Rate — days attended ÷ days expected
Absence Days Left — 10% of instructional days minus days absent
Absence Tier — Not eligible yet / Chronically absent / Watch (3 or fewer days left) / On track
ADA Value of Absences — days absent ÷ instructional days × the grade-span rate

Plus 5 named sheets and 1 dashboard (Attendance Overview), a sample CSV and a README. The .twb holds no data (a .twbx would): open it in Tableau Desktop or Tableau Public, then use Edit Connection to point it at your CSV. Menu names vary by Tableau version and UI language.

Columns your CSV needs, one row per student: SSID, Student Name, School Name, Grade, Teacher, Days Expected to Attend, Days Attended, Excused Absence Days, Unexcused Absence Days, Instructional Days in Year, Report Date

Sources

California Department of Education, “File Structure: Chronic Absenteeism Data” — 31-day eligibility, 10% rule, rate definition.
CDE, “Funding Rates and Information, Fiscal Year 2025–26” — adjusted base grant per ADA: TK–3 $11,323 · 4–6 $10,411 · 7–8 $10,719 · 9–12 $12,746.
BLS OEWS 2025 — data scientists (15-2051) median wage $57.80 per hour, if you were to pay someone to build this.

The ADA value prices absences at the base grant rate; how much reaches your budget depends on your LEA's funded-ADA rules. This page runs in your browser and sends nothing.

Open full tool → getreadystack.com