Commit graph

49 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
a258b32b39 WIP: create backend for socio-economic-status 2025-06-25 11:08:12 -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
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
Nelson Jovel
1be11d1378 feat: remove errant zeros from 'survey item by item' report 2025-01-16 15:59:56 -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
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
Nelson Jovel
c4e1023446 chore: add ability to filter survey item report by student survey type 2024-06-19 15:48:24 -07:00
Nelson Jovel
9a6db9235a chore: add report for listing district level averages for measure scores 2024-06-19 10:15:02 -07:00
Nelson Jovel
eb22fc344c feat: add measure name and id to the beginning of the csv report 2024-05-22 17:04:32 -07:00
40a35fff2d Bug Fix: survey item by grade report 2024-04-25 13:47:02 -04:00
963d945eea Feat: Add item-level reporting by grade 2024-04-19 15:04:51 -04:00
37766e777d Fix: Isolate Report::SurveyItem 2024-04-10 17:06:48 -04:00
b08214fe10 rename SurveyItemResponse method for clarity 2024-04-10 14:39:19 -04:00
a085afb3b6 Feat: Add task to generate item-level survey report 2024-04-10 14:14:29 -04:00
Nelson Jovel
0864b6e901 fix: make sure averages for admin data scales are included in report 2024-03-19 08:16:07 -07:00
Nelson Jovel
e83865ad55 feat: create beyond learning loss report 2024-03-19 07:13:51 -07:00
Nelson Jovel
f15ea64dec fix: Correctly namespace models to avoid crashing the build process 2024-03-08 14:10:43 -08:00
Nelson Jovel
ee4343383c feat: create a score csv report for measures 2024-03-06 15:32:10 -08:00
Nelson Jovel
8fb0a280ca perf: reduce number of queries for respondents 2023-12-26 16:23:29 -08:00
Nelson Jovel
ea079e927b chore: rename counts_by_grade to enrollment_by_grade for clarity 2023-12-18 15:01:33 -08:00
rebuilt
703928c234 Add date range to subcategory report export 2023-06-23 11:46:08 -07:00
rebuilt
1aaed0682e Modify subcategory report to be threaded 2023-06-09 21:26:00 -07:00
rebuilt
aab4e78a71 Add District, School Code, and Grade columns to subcategory report 2023-06-09 15:30:57 -07:00
rebuilt
87ca23df79 Add subcategory report 2023-05-23 18:55:05 -07:00
rebuilt
2e3461b685 Add subcategory report 2023-05-22 16:36:12 -07:00
rebuilt
c8ef3b11c9 file must exist so emptying the file to see if the app stops crashing 2023-03-18 13:49:44 -07:00
rebuilt
86e67d3965 Temporarily disable reporting because its crashing production. No data has been seeded and the logs are reporting this class as causing the crash? 2023-03-18 13:46:54 -07:00
rebuilt
e6f7d27e0c Implement bullet suggestions for GPS report 2023-03-01 10:53:45 -08:00
rebuilt
b6b88da328 Add all pillars 2023-02-28 19:08:11 -08:00
rebuilt
8128af200b add first pillar 2023-02-28 17:50:21 -08:00