Commit graph

955 commits

Author SHA1 Message Date
rebuilt
fbaeb2769f scrape admin, enrollments, and staffing data 2026-03-05 13:20:21 -08:00
rebuilt
ddd20b2053 scrape admin, enrollments, and staffing data 2026-03-05 12:17:44 -08:00
rebuilt
b0d4f19bba update reports 2026-02-25 14:56:38 -08:00
rebuilt
adcc12a17d Measure by grade report runs with threads 2026-01-13 11:29:49 -08:00
rebuilt
1310fd9f1c ECP-215 prep for item level exports 2025-12-23 13:58:09 -08:00
rebuilt
20252bb9a1 ECP-212 SQM data summary by grade level 2025-12-23 13:58:08 -08:00
rebuilt
c2d15e1aa7 create measure by grade file 2025-12-23 13:58:08 -08:00
rebuilt
56fae7f825 ECP-204 Clean and upload all parent survey results from Revere 2025-12-09 13:25:00 -08:00
rebuilt
1bf35012d0 update admin data 2025-12-04 20:41:41 -08:00
rebuilt
f86e758371 ECP-209 Change label on parent survey analyze page 2025-11-19 12:58:32 -08:00
rebuilt
b6675c2516 ECP-206 Delete the 3 info boxes for each sub-category on the Browse page 2025-10-30 13:32:39 -07:00
rebuilt
aa39303dfc fix: keep alive long running sftp connections 2025-09-18 08:05:25 -07:00
rebuilt
6b75af4c7d fix: make survey data uploads threaded 2025-09-17 21:57:34 -07:00
rebuilt
23e5f9bb48 fix: don't concat nils into array 2025-09-17 20:19:30 -07:00
rebuilt
65acd68d84 fix: update how survey data is loaded because some data was missing from previous uploads 2025-09-17 19:22:31 -07:00
rebuilt
4331c01789 chore: add includes call to ensure we don't do an n+1 query 2025-07-09 22:08:56 -07:00
rebuilt
138c61e7f0 ECP-201 Add an unknown categories to the parent survey SES filter 2025-07-09 21:54:45 -07:00
rebuilt
df96f08c12 ECP-202 insufficient data indicators on analyze page are aware of the graph requested and get shown based on the data requested (student/teacher/parent) 2025-07-09 21:51:49 -07:00
rebuilt
690f2db863 ECP-162 fix benefits so it gets scored correctly 2025-07-03 17:45:45 -07:00
rebuilt
a3082037fa fix: ensure loaded survey item responses are uniq by id to avoid PG::CardinalityViolation: ERROR: ON CONFLICT DO UPDATE command cannot affect row a second time (PG::CardinalityViolation) 2025-07-03 08:10:42 -07:00
rebuilt
1da1b238e0 fix: PG::CardinalityViolation: ERROR: ON CONFLICT DO UPDATE command cannot affect row a second time (PG::CardinalityViolation) HINT: Ensure that no rows proposed for insertion within the same command have duplicate constrained values. 2025-07-02 19:24:29 -07:00
rebuilt
3426e0edea ECP-173 fix logo size 2025-07-02 11:42:30 -07:00
rebuilt
2b2a53ae5b ECP-173 fix about us and contact links 2025-07-02 11:27:33 -07:00
rebuilt
afd152e01d ECP-173 update logos 2025-07-02 10:29:09 -07:00
rebuilt
d3cbdbdaea fix: accidentally erased school name column-header from master list of schools and districts 2025-07-02 06:56:05 -07:00
rebuilt
94c5b1acba ECP-30 Delete legacy code and database tables 2025-06-30 11:20:29 -07:00
rebuilt
5bc9d27b64 ECP-167 upload waupun data 2025-06-27 09:13:24 -07:00
rebuilt
cab0a3955e finish up adding socio economic disag filter 2025-06-25 17:12:20 -07:00
rebuilt
a258b32b39 WIP: create backend for socio-economic-status 2025-06-25 11:08:12 -07:00
rebuilt
2068758ae4 ECP-170 Remove login requirement for Trition. Switch to using predefined passwords stored in the database for district login. 2025-06-11 13:54:56 -07:00
rebuilt
874f29a384 fix: fix failing test 2025-06-10 08:45:18 -07:00
rebuilt
686e89d0ba Create ability to run exports locally so they get created in
tmp/exports.
Fix measure summary for 'all years' output.

Slight speedup to survey item by grade.
Fix Survey item by item for the 'all years' output
2025-06-09 16:35:39 -07:00
rebuilt
7d41989a65 feat: Update cleaner and uploader to load gender data from parent surveys
Implement graph views for parent gender data
2025-05-27 13:57:51 -07:00
rebuilt
9d8543afae feat: Update cleaner and uploader to load gender data from parent surveys
Implement graph views for parent gender data
2025-05-27 11:13:00 -07:00
rebuilt
7ebe8234cb ECP-125 feat: update selector to say 'Student Race' instead of just 'Race'. Also make sure that the default selection is 'Language' instead of 'Student Race' 2025-05-23 15:14:25 -07:00
rebuilt
5b00454a1b ECP-125 feat:
Update cleaner to read parent races.
Update uploader to set races for parents.
Add race graphs to analyze page.  Show both measure and scale level graphs
2025-05-22 11:57:26 -07:00
rebuilt
76f2467b97 chore: ECP-152 Reduce batch size of survey uploads to 100 at a time from 500 to reduce memory usage and also explicitly run garbage collection so we stay under the 500 mb limit of heroku 2025-05-12 19:15:33 -07:00
rebuilt
545bb85b1c feat: add insufficiency message to parent graph 2025-05-12 15:07:47 -07:00
rebuilt
513445dc74 feat: ECP-126 Add measure and scale level graphs for parents by language
WIP: refactor so multiple graphs can be defined for a given slug

WIP: fixed scale view but broke 'All Parent' graph

WIP: working state.  All views working properly

WIP: Refactor graph_map into two collections; measure_level_graphs and scale_level_graphs

WIP: refacter GroupedBarColumnPresenter to accept a 'construct' instead of specifying measure or scale

WIP: fix scale graphs being shown on incorrect view

WIP: Merge parents_by_language class with parents_by_language_by_scale so it can handle display of both measure-level and scale-level graphs
2025-05-09 15:54:43 -07:00
rebuilt
7380d56064 feat: remove Beyond Learning Loss Exports from exports page 2025-04-30 08:31:28 -07:00
rebuilt
058cbb0f6e fix: ECP-124 Update grade range to be the union of grades found in the database and the enrollment of the school. "Subcategory - School & District"
# Fixed reported grades
	     # Runs faster
      "Measure - District only"
	      # Should only be run per district
	      # Runs faster
	      # Fixed reported grades
      "Measure - School & District"
	      # Reports the grades that took the survey for that school+year; not the grades that responded to the measure
	      # Runs faster
	      # Fixed reported grades
      "Beyond Learning Loss"
      		# Runs faster
      "Beyond Learning Loss - Response Rate"
      		# Fixed reported grades
      "Survey Item - By Item"
	      # may be able to speed it up by getting all averages in a single request
	      # Fixed reported grades
      "Survey Item - By Grade"
      		# Fixed reported grades
	      #may be able to speed it up by getting all averages in a single request
      "Survey Entries - by Measure"
      		# No changes
2025-04-29 11:06:38 -07:00
rebuilt
0f457becf0 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-28 16:42:11 -07:00
rebuilt
bedab713af chore: update sped rules so 'N/A' translates to 'Not Special Education' 2025-04-09 13:03:55 -07:00
rebuilt
3a5a368a35 feat: Update demographics file with housing statuses. Create housing class. Update survey_item_values.rb to parse housing info. Update cleaner to output housing info. 2025-03-27 15:20:40 -07:00
rebuilt
b5b4c3b9a6 ECP-106 : feat : Update formatting on data filters so that radio selectors are always on same row as text and allow text to wrap to the next line if there isn't enough room 2025-03-19 13:58:12 -07:00
rebuilt
2fce07e3cd chore: correctly detect missing grade header 2025-03-19 10:52:35 -07:00
rebuilt
5c61846447 chore: Reword text 'Students, Teachers & Parents' 2025-03-18 14:47:21 -07:00
rebuilt
8f96d4dea2 ECP-100 : feat : update colors on analyze and export pages 2025-03-18 13:36:20 -07:00
rebuilt
b577b06718 ECP-86 update copyright date 2025-03-18 12:29:15 -07:00
rebuilt
e3c866353b chore: Triton added new values to ell disaggregation data; 'Yes' => 'ELL', 'No' => 'Not ELL' 2025-03-18 12:25:57 -07:00