Commit graph

124 commits

Author SHA1 Message Date
rebuilt
b0df611f4d feat: create a parents by language graph
Update demographics table with lanugage options

Create a lanugage table to hold the new languages

Update the demographic loader to input languages into the database

Update the cleaner to read the language column

Update the parent table to hold a reference to a language

Update the data uploader script to read the language from the csv and update the language information for any parent items that already exist (or create database entries if none already exist)

update the analyze interface to add controls for selecting ‘parents by group’ and a dropdown for ‘parent by language’

Update the analyze controller to read the parent-by-group parameter

Create a graph for the parent-by-group view

Bubble up averages for language calculations.

Make sure n-size only counts responses for a given measure.
2025-04-30 16:03:29 -07:00
rebuilt
8e5e2a030a feat: Add language filter for parent analysis 2025-04-25 16:35:53 -07:00
rebuilt
e90e6a4f0f WIP: add multiple languages to parent 2025-04-25 16:21:13 -07:00
rebuilt
446b3b1096 WIP: Update the parent table to hold a reference to a language
Update the data uploader script to read the language from the csv and update the language information for any parent items that already exist (or create database entries if none already exist)
2025-04-25 16:17:01 -07:00
rebuilt
498d702d95 fix: fix problem with schema and migration failing to remove indexes that didn't exist in this project 2025-01-23 13:05:38 -08:00
rebuilt
f42ee32df4 chore: add 2024-25 academic year 2025-01-23 11:46:45 -08:00
Nelson Jovel
8303d3bfdc feat: add esp counts when calculating teacher participation rates on overview page 2025-01-23 11:35:20 -08:00
Nelson Jovel
830b7bdfea chore: Make sure survey items are uniq by survey item ids 2024-11-25 17:05:34 -08:00
Nelson Jovel
c28a76ffe6 chore: update to rails 8 2024-11-21 13:58:05 -08:00
Nelson Jovel
d338003886 Show parent response rate 2024-11-14 09:22:51 -08:00
Nelson Jovel
74bed5b090 feat: Show parent scales on browse page 2024-09-27 13:50:39 -07:00
Nelson Jovel
6643ed82b5 chore: update schema 2024-07-15 11:42:55 -07:00
Nelson Jovel
8dc503f454 feat: restore hotwire functionality on analyze page 2024-06-27 10:58:45 -07:00
Nelson Jovel
efe5f8909a fix: restore seeds file 2024-04-27 14:26:39 -07:00
Nelson Jovel
ac5c1edfbf feat: Split academic year into seasons if the academic year's range is
initialized with a season, i.e. "2024-25 Fall".  Update scapers for
admin data, enrollment and staffing to use the new range standard
correctly.   Update the loaders for admin data, enrollment and staffing
so that it populates all seasons in a given year.  So admin data for
2024-25 gets loaded into "2024-25 Fall" and "2024-25 Spring".  Add tests
for the new range format.  Set the default cutoff for the start of Spring season will be the last Sunday in February
2024-04-27 14:24:05 -07:00
Nelson Jovel
e1fc5dbbaa feat: add 2023-24 academic year and make sure previous year enrollment
and staffing data get loaded when missing
2024-02-20 21:06:55 -08:00
Nelson Jovel
978942ab34 perf: add pghero and implement pghero suggestions. Remove unneeded indexes 2024-01-12 14:01:22 -08:00
Nelson Jovel
054e5603b7 chore: fix failing legacy tests 2023-11-03 10:18:46 -07:00
rebuilt
9d680c5159 chore: upgrade to rails 7.1.
upgrade rspec

fix failing tests

upgrade devise
2023-10-17 12:34:11 -07:00
rebuilt
acfdaf5587 feat: add special education disaggregation 2023-10-17 12:29:00 -07:00
rebuilt
5bdffec8f9 Add disaggregation by ELL 2023-10-17 12:06:19 -07:00
rebuilt
245cde85cd Add disaggregation by ELL 2023-10-17 11:18:47 -07:00
rebuilt
a1b580048b chore: remove precalculated race scores. Calculate race scores on every reload 2023-08-08 15:54:15 -07:00
rebuilt
76ebcc6ef3 feat: Add income table to the database. Add seeder for income. Add a reference to income from survey item response. Update the loader to import income data from the survey response csv. Refactor analyze controller to extract presenter. Add corresponding specs. Add income graph to analyze page 2023-08-08 15:52:12 -07:00
rebuilt
784e23982e feat: update survey_item_response table to indlude recorded date and import recorded date when loading responses 2023-06-23 11:28:14 -07:00
rebuilt
77e8d12a3b perf: Add another index to surveyitemresponses. Implement bullet suggestions. Memoize a function in measure.rb 2023-06-10 10:19:05 -07:00
rebuilt
09963c3323 Remove surveys table from codebase since it's no longer needed after changing logic surrounding response rates and score calculations 2023-04-22 14:21:48 -07:00
rebuilt
07ed8dd259 Update logic for calculating student response rate. Remove references
to survey table.  We no longer check or keep track of the survey type.
Instead we look in the database to see if a survey item has at least 10
responses.  If it does, that survey item was presented to the respondent
and we count it, and all responses when calculating the response rate.

Remove response rate timestamp from caching logic because we no longer
add the response rate to the database. All response rates are calculated
on the fly

Update three_b_two scraper to use teacher only numbers

swap over to using https://profiles.doe.mass.edu/statereport/gradesubjectstaffing.aspx as the source of staffing information
2023-04-22 14:00:20 -07:00
rebuilt
36ea63332b Add 2022-23 survey results 2023-03-17 18:55:35 -07:00
rebuilt
fc9e73f656 make sure survey responses for Butler get loaded correctly 2022-12-02 14:11:54 -08:00
Nelson Jovel
43bc55ed32 Query for survey items once instead of on each row 2022-11-28 11:58:58 -08:00
rebuilt
9b7c723ac9 remove gender from student table 2022-10-22 15:57:52 -07:00
rebuilt
a1f3dfaa33 Load gender information to survey item responses 2022-10-21 21:38:33 -07:00
rebuilt
8cdd1b6285 Create gender class. Load genders to database from demographics file 2022-10-21 17:47:52 -07:00
rebuilt
89a7f27b88 Finishes #183092367. Adds ui and graphs to show grade level disaggregations 2022-10-16 22:03:25 -07:00
Nelson Jovel
6ed405d16d Update student csvs 2022-09-26 15:57:56 -07:00
rebuilt
ead59d0f48 Add index to student_races table 2022-08-22 15:23:49 -07:00
rebuilt
105f30f220 Change race score calculations so the average bubbles up through survey_items
-> scales -> measure.
Precalculate averages for performance.
2022-08-10 09:58:11 -07:00
rebuilt
12e4e3f177 import students 2022-07-29 15:34:56 -07:00
rebuilt
765ad6a624 Create ui for data filters. Add listeners to direct to the correct url. Update ui based on the list of selected params 2022-07-26 06:52:50 -07:00
Nelson Jovel
757638f6ca continue refactoring 2022-07-13 15:32:48 -07:00
rebuilt
a6ad132c81 Add counter caches 2022-06-16 16:14:03 -07:00
rebuilt
dfc5202b88 Add index to survey item responses on school and academic year. 2022-06-14 15:28:38 -07:00
rebuilt
61aad20cb2 Create response rate model 2022-06-14 15:28:20 -07:00
Nelson Jovel
d7b0fe0e36 Add attleboro survey item responses for 2021-22. Finishes #182215755 2022-05-18 13:14:01 -07:00
Nelson Jovel
57bfaa51c6 Exclude boston results. Completes #182117456 2022-05-11 11:22:05 -07:00
Nelson Jovel
a613f6cb93 Add timestamps to academic years table 2022-05-03 11:11:17 -07:00
Nelson Jovel
9ecc501e24 Display measure scores. Finishes #181754978 2022-04-06 13:09:33 -07:00
Nelson Jovel
6f629e2feb Add survey responses from 2016 through 2018. Finishes #181255948 2022-03-31 17:21:27 -07:00
rebuilt
286e74b651 Seed db with surveys to keep track of school, year, and survey type
Seed db with survey_item information to keep track of which survey_item is on the short form survey.  REcalculate response rate depending on whether school to regular survey or short form survey.

Correct score for short form schools.  Finishes #181284202
2022-03-03 10:44:41 +01:00