Commit graph

400 commits

Author SHA1 Message Date
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
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
690f2db863 ECP-162 fix benefits so it gets scored correctly 2025-07-03 17:45:45 -07:00
rebuilt
94c5b1acba ECP-30 Delete legacy code and database tables 2025-06-30 11:20:29 -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
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
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
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
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
e3c866353b chore: Triton added new values to ell disaggregation data; 'Yes' => 'ELL', 'No' => 'Not ELL' 2025-03-18 12:25:57 -07:00
rebuilt
b9ba8abf73 Refactor GroupedBarColumnPresenter to accept a configuration so that a
column can by given on the fly (dependency injection). Show Parent
graphs on analyze page.
2025-03-11 12:56:41 -07:00
Nelson Jovel
1be11d1378 feat: remove errant zeros from 'survey item by item' report 2025-01-16 15:59:56 -08:00
Nelson Jovel
e2fe434bb5 feat: update response rates on the browse page to add esp to teachers for a more accurate response rate 2025-01-15 14:39:39 -08:00
Nelson Jovel
02bcb2b75b feat: add esp counts when calculating teacher participation rates on overview page 2025-01-15 13:39:41 -08:00
Nelson Jovel
ad779f5c5e fix: add response rate method back in to make sure student data gets included in report 2025-01-02 13:23:14 -08:00
Nelson Jovel
5f0bd8e73e Speed up survey item by item report from 75 to 23 seconds. Reduce
number of queries to the database.   Create a second thread of execution
2025-01-02 11:46:19 -08:00
Nelson Jovel
8a1c88b416 fix: set a threshold for participation count 2024-12-20 13:11:50 -08:00
Nelson Jovel
7fd441a56e feat: generate new bll report for Ashley 2024-12-13 13:55:05 -08:00
Nelson Jovel
f1eaad62c8 chore: Make sure survey items are uniq by survey item ids 2024-11-25 17:05:07 -08:00
Nelson Jovel
13a8e4dafd fix: enum format in question.rb 2024-11-20 15:41:42 -08:00
Nelson Jovel
e62d909896 chore: update format for enum in question.rb 2024-11-20 15:34:24 -08:00
Nelson Jovel
8946971cd3 fix: remove survey.rb which was causing errors on production startup because of the enum type 2024-11-20 15:28:07 -08:00
Nelson Jovel
d0721709f5 chore: update to rails 8 2024-11-20 15:16:22 -08:00
Nelson Jovel
0c661930e9 Show parent response rate 2024-11-03 12:47:25 -08:00
Nelson Jovel
7d4db37ee7 feat: show parent scales on variance chart 2024-10-11 10:19:23 -07:00
Nelson Jovel
6f3634582e feat: Add parent button to overview page and alter 'School Quality Framework Indicators' section to show parent scales 2024-10-08 15:16:50 -07:00
Nelson Jovel
6e4700c1f0 chore: extract overview partials 2024-10-01 12:05:48 -07:00
Nelson Jovel
37042aead5 feat: Show parent scales on browse page 2024-09-25 11:45:16 -07:00
Nelson Jovel
e5e969b968 feat: add parent survey gauges 2024-09-16 15:24:43 -07:00
Nelson Jovel
d8d2f0f91d fix: correctly load survey items from sample framework file. Fix broken tests 2024-08-27 12:45:52 -07:00
Nelson Jovel
aee0bc9883 feat: add ability to filter export data by student survey item type. Ability added to 'by grade' 'by item' and 'survey item responses' reports 2024-08-21 14:04:44 -07:00
Nelson Jovel
5a51de42ed fix: swap over to using respondents table to calculate which grades need to be included. This fixes a problem where errant responses were polluting the set of grades for a school. Also order the survey items by prompt(alphabetically) 2024-08-15 09:25:58 -07:00
Nelson Jovel
17f701ba0f fix: Report::SurveyItemByGrade.create_grade_report now runs without errors 2024-08-13 09:58:52 -07:00
Nelson Jovel
90def5d167 fix: SurveyItemByItem.create_item_report now runs without errors 2024-08-13 09:30:51 -07:00
Nelson Jovel
2d42036294 Add an exports page that allows a user to select which reports they want
to run
2024-08-08 15:53:05 -07:00
Nelson Jovel
f2e576a978 fix: correctly reference SurveyItemResponse in Subcategory report 2024-07-19 13:13:16 -07:00
Nelson Jovel
ffb989d8fd fix: correctly reference SurveyItemResponse instead of Report::SurveyItemResponse 2024-07-19 11:21:32 -07:00
Nelson Jovel
729cf328ef feat: use qualtrics code instead of designation when generating report 2024-07-19 10:52:05 -07:00
Nelson Jovel
8a2c34462b feat: create a report at the survey item response level that shows averages by student to selected measures 2024-07-18 15:47:37 -07:00