CAASP and ELPAC assessments

Analyze data from CAASP and ELPAC assessments.

All categories share the same Student Group ID / Student Group Name table and Test ID / Test Name table.

Compare columns

uv run compare_cols.py --caaspp To view the comparison of all CAASPP files.
There is a change to the blueprint of CSA data from 2024 to 2025. See California Spanish Assessment (CSA)/Understanding CSA.txt. Run uv run compare_yoy.py "California Spanish Assessment (CSA)" to compare the two files.
Pipe the output to a file because it is too large for the terminal with uv run compare_cols.py > compare_cols.txt.

Copy and paste the contents of create_table.sql and run it as a SQL query.
Upload to the database with uv run load_results.py. Make sure you have set up the database connection in the .env file.

POSTGRES_SERVER=localhost
POSTGRES_PORT=5432
POSTGRES_DB=
POSTGRES_USER=
POSTGRES_PASSWORD=

Name		Name	Last commit message	Last commit date
.vscode		.vscode
.gitignore		.gitignore
.python-version		.python-version
README.md		README.md
StudentGroups_caaspp.txt		StudentGroups_caaspp.txt
StudentGroups_elpac.txt		StudentGroups_elpac.txt
Tests_caaspp.txt		Tests_caaspp.txt
Tests_elpac.txt		Tests_elpac.txt
academic_indicator_record_layout.md		academic_indicator_record_layout.md
color_guide.md		color_guide.md
compare_cols.py		compare_cols.py
compare_yoy.py		compare_yoy.py
create_table.sql		create_table.sql
export_handoff.py		export_handoff.py
find_unique_key.py		find_unique_key.py
load_results.py		load_results.py
main.py		main.py
pubschls.txt		pubschls.txt
pubschls.xlsx		pubschls.xlsx
pyproject.toml		pyproject.toml
uv.lock		uv.lock