Skip to content
Gallery
Data Portfolio
Khadim Hussain Baluch
Resumé
Projects & Products
More
Share
Explore
Projects & Products

icon picker
Progress Monitoring

User-facing:
See the live website
⁠
⁠

info
This tool is an interactive web dashboard created for school leadership teams to monitor their progress toward their School Performance Plan goals with targeted analysis for actionable decision-making to accelerate schoolwide achievement, improve climate & culture, and mitigate disparities. This document is currently tailored to Digital Harbor High School, but it is replicable for larger datasets and fully customizable.

Backend & Construction

By using Coda, formulas differ from spreadsheets as data are object-oriented rather than by cell reference. While some data is currently hard-coded, a helper workbook from Google Sheets automates algorithms directly from ad hoc .csv exports from Infinite Campus to summarize data into Coda tables which are then manipulated for graphic data communication.

Structure

The general flow of this document hinges on graph views of simple tables that which contain either pasted information and/or formulas in hidden helper pages for each domain.

Academic Achievement

Academic data is automatically generated from the calculations in the data rollups. From that google sheet, the coda outputs are dynamically generated for easy copying and pasting into the Coda helper.
⁠
image.png
⁠
⁠
⁠
image.png
⁠
⁠
Disparities are updated in the same way from the data automatically generated in the grade rollup.
Sample Code: Determining the disparity rate for students with IEPs in cohort 2026
='equity-helpers'!D54-'equity-helpers'!D53
Reference Table:
⁠
image.png
⁠
⁠
⁠
image.png
⁠
⁠
Formula in 'equity-helpers'!D54:
=iferror(
sum(
query(
'Student Detail'!$C:$I,
"select G where C matches '"&D$52&"' and F contains '"&$B54&"'"
)
)
/sum(
query(
'Student Detail'!$C:$I,
"select I where C matches '"&D$52&"' and F contains '"&$B54&"'"
)
)
)
Formula in 'equity-helpers'!D53:
=sum(
iferror(
query(
'Student Detail'!$C:$I,
"select G where C matches '"&D$40&"'"))
)
/sum(
iferror(
query(
'Student Detail'!$C:$I,
"select I where C matches '"&D$40&"'"
)
)
)
Student detail reference table:
⁠
image.png
⁠
⁠

Climate & Culture

There are two climate and culture helper documents with embedded tables.
helper: Suspensions
table: suspension log parent – copy & pasted from helper Google Sheet
table: suspension summary – Coda formulas
helper: Referrals
table: referral log parent – copy & pasted from helper Google Sheet
table: referral summary – Coda formulas
Both Suspensions and Referral helpers work essentially in the same way:
⁠
image.png
⁠
⁠
Each summary table iterates over the automated Google Sheet log to find the counts based on the reporting period. The Reporting period is a helper table that identifies the start and end dates for each reporting period which is linked to reference for generating counts. In Coda, the formulas are column-based rather than a typical spreadsheet which is cell-based.

Sample Code: Level 1-2 Behavior Referrals
Referral Log Parent
.Filter(
Date >=
thisRow.Reporting Period.Start Date
)
.Filter(
Date <=
thisRow.Reporting Period.End Date
)
.CountIf(
Referral Type
.Contains(
Ongoing Level 1-2 behavior(s)
)
)

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.