814 commits

Author	SHA1	Message	Date
Gabe Farrell	9b0cc1527f	candidate ~1.1s	2024-04-18 02:13:38 -04:00
Gabe Farrell	f6c6d26a2c	wip 3:14	2024-04-17 19:04:58 -04:00
Gabe Farrell	c146f23bd4	wip 3:14.12	2024-04-17 17:57:40 -04:00
Gabe Farrell	d82f40aa3d	Feat: add grade-level survey item report	2024-04-15 16:17:13 -04:00
Gabe Farrell	37766e777d	Fix: Isolate Report::SurveyItem	2024-04-10 17:06:48 -04:00
Gabe Farrell	b08214fe10	rename SurveyItemResponse method for clarity	2024-04-10 14:39:19 -04:00
Gabe Farrell	a085afb3b6	Feat: Add task to generate item-level survey report	2024-04-10 14:14:29 -04:00
Nelson Jovel	65d3733189	feat: ignore library survey items in csvs	2024-04-02 20:22:52 -07:00
Nelson Jovel	8a702efa51	fix: make sure staffing checks for zero	2024-04-01 09:52:41 -07:00
Nelson Jovel	ad23bb1816	fix:typo	2024-04-01 09:42:41 -07:00
Nelson Jovel	3106768175	fix: If all respondents have total_teachers set to 0, that will trigger cloning previous year data	2024-04-01 09:36:54 -07:00
Nelson Jovel	90363d8b86	fix: make sure we are only reseeding staffing and demographic numbers if the data for that year is empty	2024-04-01 09:21:33 -07:00
Nelson Jovel	51e71a7f83	fix: Fixes #187294757. Data is hidden when selecting multiple years if the default year has no student data to show	2024-03-26 15:31:48 -07: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	7a4eb8302b	feat: change the text of the prompts for survey items	2024-03-14 12:48:43 -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	4c017cf857	fix: add pre-k to list of grades	2024-03-05 22:31:56 -08:00
Nelson Jovel	2cb43058a0	fix: loosen restrictions on date format	2024-03-01 10:15:32 -08:00
Nelson Jovel	289b04bc69	match an additional format for Dates. Supported dates are now '1/10/2022 14:21:45' '2022-1-10T14:21:45' '2022-1-10 14:21:45'	2024-03-01 09:30:23 -08:00
Nelson Jovel	d6735d449d	feat: Support two date formats: ISO 8601 and the standard US date format ... used in google sheets	2024-02-27 11:55:47 -08:00
Nelson Jovel	03349b0ed5	chore: support alternate format for recorded date	2024-02-23 14:21:16 -08:00
Nelson Jovel	37610e732f	chore: alphabetize districts when writing filename for cleaned files	2024-02-23 11:27:59 -08:00
Nelson Jovel	b6de3349d6	fix: support alternate format for active admin data items. Support both 'True/False' and '1/0'	2024-02-23 08:57:35 -08:00
Nelson Jovel	0a32fb50ff	fix: no longer support 'form' in filename when cleaning. Only look for 'part X' and add that to the filename if it exists	2024-02-22 10:55:48 -08:00
Nelson Jovel	725bef2a8f	fix: Support true/false column values when categorizing income status. True is categorized as Economically Disadvantaged. False is categorized as Not Economically Disadvantaged	2024-02-20 21:26:02 -08:00
Nelson Jovel	48e1f941f5	fix: change the default to not an english language learner. Blank columns are treated as Not ELL. Only mark student as an english language learner if it's marked as such. Columns marked with 'NA' are treated as unknown	2024-02-20 21:24:14 -08:00
Nelson Jovel	3c210e0ab6	chore: rename admin data to school data on analyze page	2024-01-31 14:25:10 -08:00
Nelson Jovel	90d1419d9c	feat: change 'school admin data' to 'school data'	2024-01-31 10:59:39 -08:00
Nelson Jovel	6558ed491a	perf: reduce number of calls for student and teacher survey items in response rate calculators	2023-12-27 07:37:03 -08:00
Nelson Jovel	ec53cc9ae4	fix: correct a problem where survey items with insufficient responses were contributing to the response rate calculation	2023-12-26 22:14:56 -08:00
Nelson Jovel	c0b8c408ea	perf: reduce time spent in sql query for student response rate	2023-12-26 21:01:12 -08:00
Nelson Jovel	2f74153114	chore: refactor teacher response rate	2023-12-26 20:58:08 -08:00
Nelson Jovel	b0c9a0451e	perf: reduce number of queries for teacher survey_items	2023-12-26 17:32:39 -08:00
Nelson Jovel	8fb0a280ca	perf: reduce number of queries for respondents	2023-12-26 16:23:29 -08:00
Nelson Jovel	f026ea22ef	perf: reduce number of queries by requesting grouped_responses once instead of for each measure	2023-12-23 21:18:09 -08:00
Nelson Jovel	ed8e621333	chore: remove method that wasn't needed	2023-12-21 20:29:18 -08:00
Nelson Jovel	9e8f917457	chore: performance fixes for response rate calculation	2023-12-21 20:15:11 -08:00
Nelson Jovel	6a283b1fc8	chore: prevent multiple lookups for the boston district by inlining the ... sql	2023-12-21 13:54:54 -08:00
Nelson Jovel	cc5e0b142c	chore: memoize grades for school	2023-12-21 13:44:07 -08:00
Nelson Jovel	60927e3271	fix: reduce number of n+1 queries	2023-12-21 13:34:16 -08:00
Nelson Jovel	ebf4ca4166	chore: move code that normalizes race data to the Race class	2023-12-20 19:07:16 -08:00
Nelson Jovel	56b512810c	chore: remove lowell seeding rules	2023-12-20 14:03:15 -08:00
Nelson Jovel	880b438eb4	chore: reenable test spec that tests data loader for races	2023-12-20 12:39:44 -08:00
Nelson Jovel	36e21515c3	chore: refactor Race out of survey_item_values	2023-12-20 12:25:23 -08:00
Nelson Jovel	e7fb009425	chore: refactor Gender out out of survey_item_values row	2023-12-20 11:08:23 -08:00
Nelson Jovel	f9717f80c7	chore: remove todo	2023-12-19 15:51:13 -08:00
Nelson Jovel	5df890923f	feat: don't show collection date of response rate if there is no survey data	2023-12-18 15:16:56 -08:00
Nelson Jovel	ea079e927b	chore: rename counts_by_grade to enrollment_by_grade for clarity	2023-12-18 15:01:33 -08:00