# ELPA 823: Data Management for Education Policy Analysis | UW–Madison [View on UW Courses](https://uwcourses.com/courses/ELPA_823) ## Dataset ### revision e243353dcb7d79b7247ced91d69443ef4c2a6349 ### repository twangodev/uwcourses ### schema version 6 ### importer version 7 ### projection id 52a78527ff09011d88cb04c7d43867d9fbfec2930bf1dd2ec359ebd2844e0b07 ### observed at 2026-09-07T15:55:43.033547+00:00 ### built at 2026-09-10T19:50:42.743001+00:00 ### courses 8951 ### current instructors 5754 ### limited false ### terms * 1272 * 1264 * 1262 * 1254 * 1252 * 1244 * 1242 * 1234 * 1232 * 1224 * 1222 * 1212 * 1204 * 1202 * 1194 * 1192 * 1184 * 1182 * 1174 * 1172 * 1164 * 1162 * 1154 * 1152 * 1144 * 1142 * 1134 * 1132 * 1124 * 1122 * 1114 * 1112 * 1104 * 1102 * 1094 * 1092 * 1084 * 1082 * 1074 * 1072 ### term 1272 ### departments | subject | count | | --------- | ----- | | AAE | 90 | | ABT | 20 | | ACCTIS | 36 | | ACTSCI | 14 | | AFAERO | 10 | | AFRICAN | 87 | | AFROAMER | 71 | | AGROECOL | 21 | | AMERIND | 53 | | ANAT\&PHY | 7 | | ANATOMY | 2 | | ANESTHES | 8 | | ANSCI | 57 | | ANTHRO | 95 | | ART | 125 | | ARTED | 10 | | ARTHIST | 121 | | ASIALANG | 129 | | ASIAN | 109 | | ASIANAM | 28 | | ASTRON | 38 | | ATMOCN | 69 | | BIOCHEM | 51 | | BIOCORE | 10 | | BIOLOGY | 14 | | BIOMDSCI | 18 | | BME | 66 | | BMI | 41 | | BMOLCHEM | 10 | | BOTANY | 69 | | BSE | 44 | | C\&ESOC | 73 | | CBE | 48 | | CHEM | 101 | | CHICLA | 52 | | CIVENGR | 133 | | CLASSICS | 47 | | CNP | 10 | | CNSRSCI | 50 | | COMARTS | 137 | | COMPBIO | 15 | | COMPLIT | 11 | | COMPSCI | 138 | | COUNPSY | 78 | | CRB | 19 | | CS\&D | 71 | | CSCS | 40 | | CURRIC | 193 | | DANCE | 93 | | DERM | 8 | | DS | 88 | | DYSCI | 35 | | ECE | 155 | | ECON | 145 | | EDPOL | 114 | | EDPSYCH | 97 | | ELPA | 70 | | EMA | 53 | | EMERMED | 17 | | ENGL | 206 | | ENTOM | 40 | | ENVIRST | 148 | | EP | 15 | | EPD | 67 | | ESL | 16 | | F\&WECOL | 60 | | FAMMED | 22 | | FINANCE | 50 | | FOLKLORE | 40 | | FOODSCI | 43 | | FRENCH | 63 | | GEN\&WS | 145 | | GENBUS | 72 | | GENECSLR | 17 | | GENETICS | 60 | | GEOG | 113 | | GEOSCI | 83 | | GERMAN | 82 | | GLE | 48 | | GNS | 38 | | GREEK | 27 | | HDFS | 41 | | HEBR-BIB | 13 | | HEBR-MOD | 10 | | HISTORY | 233 | | HISTSCI | 56 | | HONCOL | 13 | | ILS | 43 | | INFOSYS | 9 | | INTEGART | 7 | | INTEGSCI | 22 | | INTER-AG | 18 | | INTER-HE | 11 | | INTER-LS | 22 | | INTEREGR | 16 | | INTLBUS | 21 | | INTLST | 50 | | ISYE | 83 | | ITALIAN | 53 | | JEWISH | 56 | | JOURN | 88 | | KINES | 128 | | LACIS | 26 | | LANDARC | 61 | | LATIN | 24 | | LAW | 120 | | LEGALST | 48 | | LINGUIS | 35 | | LIS | 89 | | LITTRANS | 78 | | LSC | 52 | | M\&ENVTOX | 7 | | MARKETNG | 62 | | MATH | 153 | | MDGENET | 8 | | ME | 130 | | MEDHIST | 43 | | MEDICINE | 60 | | MEDIEVAL | 32 | | MEDPHYS | 39 | | MEDSC-M | 29 | | MEDSC-V | 41 | | MHR | 68 | | MICROBIO | 45 | | MILSCI | 16 | | MM\&I | 22 | | MOLBIOL | 6 | | MS\&E | 59 | | MUSIC | 165 | | MUSPERF | 126 | | NAVSCI | 20 | | NE | 44 | | NEURODPT | 11 | | NEUROL | 7 | | NEURSURG | 4 | | NTP | 11 | | NURSING | 111 | | NUTRSCI | 65 | | OBS\&GYN | 18 | | OCCTHER | 39 | | ONCOLOGY | 14 | | OPHTHALM | 5 | | OTM | 43 | | PATH | 34 | | PATH-BIO | 29 | | PEDIAT | 26 | | PHARMACY | 31 | | PHILOS | 77 | | PHMCOL-M | 11 | | PHMPRAC | 45 | | PHMSCI | 60 | | PHYASST | 37 | | PHYSICS | 88 | | PHYSIOL | 3 | | PHYTHER | 37 | | PLANTSCI | 52 | | PLPATH | 35 | | POLISCI | 192 | | POPHLTH | 58 | | PORTUG | 33 | | PSYCH | 101 | | PSYCHIAT | 22 | | PUBAFFR | 54 | | PUBLHLTH | 23 | | RADIOL | 11 | | REALEST | 41 | | RELIGST | 90 | | RHABMED | 9 | | RMI | 24 | | RP\&SE | 102 | | S\&APHM | 17 | | SCANDST | 73 | | SLAVIC | 89 | | SOC | 149 | | SOCWORK | 87 | | SOILSCI | 46 | | SPANISH | 83 | | SRMED | 21 | | STAT | 94 | | STDYABRD | 52 | | STS | 8 | | SURGERY | 25 | | SURGSCI | 33 | | THEATRE | 91 | | URBRPL | 60 | | UROLOGY | 5 | | ZOOLOGY | 89 | ## course ### run id 20260907T155543-ce3781c4 ### semester 1272 ### observed at 2026-09-07 15:55:43.033547+00:00 ### record version id 94ad3440180fbe15ce28041c1266e0808f10167b6d289858bfe4b5523d9738bd ### course id ELPA 823 ### course uid course\_cf679c5c57bc98fef7fc9c41 ### catalog version id 287be1130283190c164b88455002bcf81401228c6c2abda87a8eccfd17bc880d ### course number 823 ### subjects * ELPA ### title DATA MANAGEMENT FOR EDUCATION POLICY ANALYSIS ### description Focuses on the knowledge and skills required to support rigorous quantitative inquiry. Acquire and import data; combine (merge/append) multiple data sets; organize directories and files for optimal workflow; clean data; document data manipulations for reproducibility and transparency; write code to facilitate collaboration; and summarize data in visual (graph, chart, map) and tabular forms. ### requirements text Graduate/professional standing ### credit offering ids None recorded. ### llm job id enrich-8b774950c2b6adfdc46d1b82 ### llm output id 00d306769739d5ccb4d1a957ce16f46f18f771bf961eca25b62a394608cd4868 ### llm model nvidia/Qwen3.6-35B-A3B-NVFP4 ### llm model revision 1355db6a052410cfd62085d94b58866fd0f2c3c5 ### llm task version 14 ### llm search status valid ### llm summary ELPA 823 teaches data management skills for education policy analysis, including data acquisition, cleaning, documentation, and visualization. ### llm topics * Quantitative inquiry support * Reproducible data science * Data visualization ### llm skills * Acquire and import data * Combine multiple data sets * Organize directories and files * Clean data * Document data manipulations * Write code for collaboration * Summarize data in visual and tabular forms ### llm assumed background None recorded. ### llm search phrases * data management education policy * quantitative inquiry data skills * data cleaning reproducibility code * data visualization graphs charts maps ### llm requirements status valid ### llm student summary status valid ### llm experience status insufficient\_evidence ### catalog variants None recorded. ### student summary #### context hash 3714fb360dacb98189a3b96ef23010f96826225f1534d5c3ae94cfc9abdf617c #### course id ELPA 823 #### current instructors None recorded. #### difficulty workload None recorded. #### errors None recorded. #### historical context None recorded. #### message No course-specific reviews available #### offered false #### profile hash 5cb4dabf887cdbcd8c00d5a1312e10828b95c63f30bc3ea76aea199565390d02 #### quick take Recent recorded grades — Spring 2022: 4.00 GPA, 100.0% A/AB (n=5 letter grades); Spring 2023: 4.00 GPA, 100.0% A/AB (n=10 letter grades); Spring 2026: 4.00 GPA, 100.0% A/AB (n=16 letter grades). ```json { "citations": [ { "course_id": "ELPA 823", "run_id": "20260907T155543-ce3781c4", "source_record": { "entity_id": "65f54d29-fb12-3309-a5a1-7102e25e53c0", "file": "tables/observations.parquet", "kind": "grades", "source": "madgrades" }, "table": "grades_latest", "term_id": "1224", "type": "grade" }, { "course_id": "ELPA 823", "run_id": "20260907T155543-ce3781c4", "source_record": { "entity_id": "65f54d29-fb12-3309-a5a1-7102e25e53c0", "file": "tables/observations.parquet", "kind": "grades", "source": "madgrades" }, "table": "grades_latest", "term_id": "1234", "type": "grade" }, { "course_id": "ELPA 823", "run_id": "20260907T155543-ce3781c4", "source_record": { "entity_id": "65f54d29-fb12-3309-a5a1-7102e25e53c0", "file": "tables/observations.parquet", "kind": "grades", "source": "madgrades" }, "table": "grades_latest", "term_id": "1264", "type": "grade" } ] } ``` #### student experience None recorded. #### task hash 74fb0997943e888960bbc9e47db8c4fd12e4292d55c20509d8d89db6a9910f68 #### teaching history None recorded. #### term id 1272 #### term name 2026 Fall #### version 2 ### requirements #### nodes ```json [ { "children": [], "condition": "Graduate/professional standing", "course": null, "evidence": "Graduate/professional standing", "id": "n0", "kind": "condition" } ] ``` #### notes None recorded. #### root n0 #### status parsed ### instructors None recorded. ### offerings None recorded. ### sections None recorded. ### grade instructors ```json [ { "instructor_uid": "instructor_4a0a977049912d61a368be9a", "source": "madgrades", "source_instructor_id": "5110032", "identity_basis": "source_id", "identity_status": "source_identified", "name": "PETER GOFF", "email": null, "first_observed_at": "2026-09-06 23:14:58.172943+00:00", "last_observed_at": "2026-09-07 15:55:43.033547+00:00", "grade_statistics": { "gpa": 3.932, "graded": 170, "counts": [ 152, 13, 5, 0, 0, 0, 0 ], "sections": 51 }, "instructor_url": "/instructors/PETER_GOFF" }, { "instructor_uid": "instructor_6facc5f3a9841783e4ac0e82", "source": "madgrades", "source_instructor_id": "5678111", "identity_basis": "source_id", "identity_status": "source_identified", "name": "MINSEOK YANG", "email": null, "first_observed_at": "2026-09-06 23:14:58.172943+00:00", "last_observed_at": "2026-09-07 15:55:43.033547+00:00", "grade_statistics": { "gpa": 3.917, "graded": 12, "counts": [ 10, 2, 0, 0, 0, 0, 0 ], "sections": 2 }, "instructor_url": "/instructors/MINSEOK_YANG" }, { "instructor_uid": "instructor_cdea66c0846cfcd75737aa8a", "source": "madgrades", "source_instructor_id": "6207521", "identity_basis": "source_id", "identity_status": "source_identified", "name": "QI ZHENG", "email": null, "first_observed_at": "2026-09-06 23:14:58.172943+00:00", "last_observed_at": "2026-09-07 15:55:43.033547+00:00", "grade_statistics": { "gpa": 3.917, "graded": 12, "counts": [ 10, 2, 0, 0, 0, 0, 0 ], "sections": 2 }, "instructor_url": "/instructors/QI_ZHENG--instructor_cdea66c0846cfcd75737aa8a" }, { "instructor_uid": "instructor_04fe654ec128f7d5601e56e1", "source": "madgrades", "source_instructor_id": "3496035", "identity_basis": "source_id", "identity_status": "source_identified", "name": "AR NELSON", "email": null, "first_observed_at": "2026-09-06 23:14:58.172943+00:00", "last_observed_at": "2026-09-07 15:55:43.033547+00:00", "grade_statistics": { "gpa": 3.973, "graded": 239, "counts": [ 230, 7, 1, 0, 1, 0, 0 ], "sections": 20 }, "instructor_url": "/instructors/AR_NELSON--instructor_04fe654ec128f7d5601e56e1" }, { "instructor_uid": "instructor_82d5cc1cbb4d8982e20e1fff", "source": "madgrades", "source_instructor_id": "4522153", "identity_basis": "source_id", "identity_status": "source_identified", "name": "CHRISTOPHER SALDANA", "email": null, "first_observed_at": "2026-09-06 23:14:58.172943+00:00", "last_observed_at": "2026-09-07 15:55:43.033547+00:00", "grade_statistics": { "gpa": 3.939, "graded": 90, "counts": [ 86, 3, 0, 0, 0, 0, 1 ], "sections": 12 }, "instructor_url": "/instructors/CHRISTOPHER_SALDANA--instructor_82d5cc1cbb4d8982e20e1fff" } ] ``` ### grades ```json [ { "run_id": "20260907T155543-ce3781c4", "semester": "1272", "observed_at": "2026-09-07 15:55:43.033547+00:00", "course_id": "ELPA 823", "course_uid": "course_cf679c5c57bc98fef7fc9c41", "term_id": "1204", "term_name": "Spring 2020", "instructors": [ "PETER GOFF" ], "a": 0, "ab": 0, "b": 0, "bc": 0, "c": 0, "d": 0, "f": 0, "satisfactory": 0, "unsatisfactory": 0, "credit": 0, "no_credit": 0, "passed": 0, "incomplete": 0, "no_work": 0, "not_reported": 0, "other": 0, "total": 0, "source_aliases": [ "ELPA 823" ] }, { "run_id": "20260907T155543-ce3781c4", "semester": "1272", "observed_at": "2026-09-07 15:55:43.033547+00:00", "course_id": "ELPA 823", "course_uid": "course_cf679c5c57bc98fef7fc9c41", "term_id": "1212", "term_name": "Fall 2020", "instructors": [ "MINSEOK YANG", "PETER GOFF", "QI ZHENG" ], "a": 0, "ab": 0, "b": 0, "bc": 0, "c": 0, "d": 0, "f": 0, "satisfactory": 0, "unsatisfactory": 0, "credit": 0, "no_credit": 0, "passed": 0, "incomplete": 0, "no_work": 0, "not_reported": 0, "other": 0, "total": 0, "source_aliases": [ "ELPA 823" ] }, { "run_id": "20260907T155543-ce3781c4", "semester": "1272", "observed_at": "2026-09-07 15:55:43.033547+00:00", "course_id": "ELPA 823", "course_uid": "course_cf679c5c57bc98fef7fc9c41", "term_id": "1224", "term_name": "Spring 2022", "instructors": [ "Ar Nelson" ], "a": 5, "ab": 0, "b": 0, "bc": 0, "c": 0, "d": 0, "f": 0, "satisfactory": 1, "unsatisfactory": 0, "credit": 0, "no_credit": 0, "passed": 0, "incomplete": 0, "no_work": 0, "not_reported": 0, "other": 0, "total": 6, "source_aliases": [ "ELPA 823" ] }, { "run_id": "20260907T155543-ce3781c4", "semester": "1272", "observed_at": "2026-09-07 15:55:43.033547+00:00", "course_id": "ELPA 823", "course_uid": "course_cf679c5c57bc98fef7fc9c41", "term_id": "1234", "term_name": "Spring 2023", "instructors": [ "Ar Nelson" ], "a": 10, "ab": 0, "b": 0, "bc": 0, "c": 0, "d": 0, "f": 0, "satisfactory": 0, "unsatisfactory": 0, "credit": 0, "no_credit": 0, "passed": 0, "incomplete": 0, "no_work": 0, "not_reported": 0, "other": 0, "total": 10, "source_aliases": [ "ELPA 823" ] }, { "run_id": "20260907T155543-ce3781c4", "semester": "1272", "observed_at": "2026-09-07 15:55:43.033547+00:00", "course_id": "ELPA 823", "course_uid": "course_cf679c5c57bc98fef7fc9c41", "term_id": "1244", "term_name": "Spring 2024", "instructors": [ "Ar Nelson" ], "a": 0, "ab": 0, "b": 0, "bc": 0, "c": 0, "d": 0, "f": 0, "satisfactory": 0, "unsatisfactory": 0, "credit": 0, "no_credit": 0, "passed": 0, "incomplete": 0, "no_work": 0, "not_reported": 0, "other": 0, "total": 0, "source_aliases": [ "ELPA 823" ] }, { "run_id": "20260907T155543-ce3781c4", "semester": "1272", "observed_at": "2026-09-07 15:55:43.033547+00:00", "course_id": "ELPA 823", "course_uid": "course_cf679c5c57bc98fef7fc9c41", "term_id": "1264", "term_name": "Spring 2026", "instructors": [ "Christopher Saldana" ], "a": 16, "ab": 0, "b": 0, "bc": 0, "c": 0, "d": 0, "f": 0, "satisfactory": 0, "unsatisfactory": 0, "credit": 0, "no_credit": 0, "passed": 0, "incomplete": 0, "no_work": 0, "not_reported": 0, "other": 0, "total": 16, "source_aliases": [ "ELPA 823" ] } ] ``` ### statistics #### gpa 4 #### graded 31 #### counts * 31 * 0 * 0 * 0 * 0 * 0 * 0 ### grade conflicts None recorded. ### evidence #### history * [/data/e243353dcb7d79b7247ced91d69443ef4c2a6349/history/course\_cf679c5c57bc98fef7fc9c41-0.json](https://uwcourses.com/data/e243353dcb7d79b7247ced91d69443ef4c2a6349/history/course_cf679c5c57bc98fef7fc9c41-0.json) #### traces * [/data/e243353dcb7d79b7247ced91d69443ef4c2a6349/traces/course\_cf679c5c57bc98fef7fc9c41-0.json](https://uwcourses.com/data/e243353dcb7d79b7247ced91d69443ef4c2a6349/traces/course_cf679c5c57bc98fef7fc9c41-0.json) #### results * [/data/e243353dcb7d79b7247ced91d69443ef4c2a6349/results/course\_cf679c5c57bc98fef7fc9c41-0.json](https://uwcourses.com/data/e243353dcb7d79b7247ced91d69443ef4c2a6349/results/course_cf679c5c57bc98fef7fc9c41-0.json) ### revision e243353dcb7d79b7247ced91d69443ef4c2a6349 ## context ### all #### term #### gpa 4 #### count 31 #### university ##### size 3365 ##### gpa Percentile 94 ##### count Percentile 2 ##### median Count 102 ##### histogram | range | count | current | | ------- | ----- | ------- | | 0.0–0.4 | 0 | false | | 0.4–0.8 | 0 | false | | 0.8–1.2 | 0 | false | | 1.2–1.6 | 0 | false | | 1.6–2.0 | 0 | false | | 2.0–2.4 | 0 | false | | 2.4–2.8 | 7 | false | | 2.8–3.2 | 198 | false | | 3.2–3.6 | 868 | false | | 3.6–4.0 | 2292 | true | #### departments ```json [ { "subject": "ELPA", "comparison": { "size": 30, "gpaPercentile": 86, "countPercentile": 0, "medianCount": 61.5, "histogram": [ { "range": "0.0–0.4", "count": 0, "current": false }, { "range": "0.4–0.8", "count": 0, "current": false }, { "range": "0.8–1.2", "count": 0, "current": false }, { "range": "1.2–1.6", "count": 0, "current": false }, { "range": "1.6–2.0", "count": 0, "current": false }, { "range": "2.0–2.4", "count": 0, "current": false }, { "range": "2.4–2.8", "count": 0, "current": false }, { "range": "2.8–3.2", "count": 0, "current": false }, { "range": "3.2–3.6", "count": 0, "current": false }, { "range": "3.6–4.0", "count": 30, "current": true } ] } } ] ``` ### terms #### 1224 ##### term 1224 ##### gpa 4 ##### count 5 ##### departments | subject | comparison | | ------- | ---------- | | ELPA | | #### 1234 ##### term 1234 ##### gpa 4 ##### count 10 ##### departments | subject | comparison | | ------- | ---------- | | ELPA | | #### 1264 ##### term 1264 ##### gpa 4 ##### count 16 ##### departments | subject | comparison | | ------- | ---------- | | ELPA | | ### benchmarks #### all ##### school ###### size 3365 ###### gpa 3.69120845424117 ###### top Share 83.88318085595236 ###### count 102 ##### ELPA ###### size 30 ###### gpa 3.938357396495328 ###### top Share 97.48243265043071 ###### count 61.5 #### terms ##### 1204 ###### school ###### size 1012 ###### gpa 3.703747431523761 ###### top Share 84.59811226304916 ###### count 65.5 ##### 1212 ###### school ###### size 1111 ###### gpa 3.5856416028074487 ###### top Share 77.58926748660845 ###### count 68 ##### 1224 ###### school ###### size 1171 ###### gpa 3.5627882428500937 ###### top Share 76.37271640560496 ###### count 64 ##### 1234 ###### school ###### size 1188 ###### gpa 3.5799441677552393 ###### top Share 77.18256448537606 ###### count 65 ##### 1244 ###### school ###### size 1241 ###### gpa 3.5975573126929192 ###### top Share 78.29036874847135 ###### count 65 ##### 1264 ###### school ###### size 1283 ###### gpa 3.6229729166451925 ###### top Share 80.13669149396227 ###### count 66 ## instructor Trends ```json [ { "uid": "instructor_82d5cc1cbb4d8982e20e1fff", "name": "CHRISTOPHER SALDANA", "count": 16, "terms": [ { "term": "1264", "count": 16, "sections": 1, "gpa": 4 } ] }, { "uid": "instructor_04fe654ec128f7d5601e56e1", "name": "AR NELSON", "count": 15, "terms": [ { "term": "1224", "count": 5, "sections": 1, "gpa": 4 }, { "term": "1234", "count": 10, "sections": 1, "gpa": 4 } ] } ] ``` ## following None recorded.