115b00145d
perf: add pghero and implement pghero suggestions. Remove unneeded indexes
2 years ago
48e795fcfb
feat: add special education disaggregation
2 years ago
060d7aa55a
Add disaggregation by ELL
2 years ago
4afa030141
chore: remove precalculated race scores. Calculate race scores on every reload
2 years ago
4f035f6a63
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
2 years ago
e8aa75bf66
feat: update survey_item_response table to indlude recorded date and import recorded date when loading responses
2 years ago
452876ef09
perf: Add another index to surveyitemresponses. Implement bullet suggestions. Memoize a function in measure.rb
3 years ago
596ce25737
Remove surveys table from codebase since it's no longer needed after changing logic surrounding response rates and score calculations
3 years ago
06f9d2f0e9
Scrape enrollment and staffing information. Seed enrollment and staffing information. Update DatabaseCleaner so it cleans up leftover information in the database. Remove old admin csvs from codebase.
3 years ago
52d2676f80
Populate db with grade level data
3 years ago
9b7c723ac9
remove gender from student table
3 years ago
a1f3dfaa33
Load gender information to survey item responses
3 years ago
8cdd1b6285
Create gender class. Load genders to database from demographics file
3 years ago
89a7f27b88
Finishes #183092367 . Adds ui and graphs to show grade level disaggregations
3 years ago
ead59d0f48
Add index to student_races table
3 years ago
105f30f220
Change race score calculations so the average bubbles up through survey_items
...
-> scales -> measure.
Precalculate averages for performance.
3 years ago
12e4e3f177
import students
3 years ago
765ad6a624
Create ui for data filters. Add listeners to direct to the correct url. Update ui based on the list of selected params
3 years ago
a6ad132c81
Add counter caches
4 years ago
dfc5202b88
Add index to survey item responses on school and academic year.
4 years ago
61aad20cb2
Create response rate model
4 years ago
57bfaa51c6
Exclude boston results. Completes #182117456
4 years ago
a613f6cb93
Add timestamps to academic years table
4 years ago
9ecc501e24
Display measure scores. Finishes #181754978
4 years ago
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
4 years ago
d4df7cbc06
Add scales to framework. Change calculations to first group and then
...
average those groupings and the way up the framework. Likert scores for
a survey_item are averaged. Then all the survey_items in a scale are
averaged. Then student scales in a measure are averaged. And teacher
scales in a measure are averaged. Then the average of those two
calculations becomes the score for a measure. Then the measures in a
subcategory are averaged.
4 years ago
fcec3de233
Modify collection rate for admin data items. Take into account if a
...
school is a high school and if the admin data item is for high schools
only. Finishes: #181154375 .
4 years ago
59865cd874
Show response rate for students
4 years ago
ad03606d66
Add benchmarks to survey and admin data items. Remove them from measures. Modify seeder
...
Calculate benchmarks for measures based on a weighted average of survey
and admin data items
Added architectural records
4 years ago
cacc853518
Adds category short description to database and renders descriptions in
...
their corresponding locations to the site. Finishes #180090033 .
4 years ago
1186579d1b
Add migration to make DESE IDs unique, update one-off script accordingly
4 years ago
b5badfaef5
Add DESE ID to schools
...
- Add migration
- Create one-off script `rake one_off:add_dese_ids` to add the DESE ID to schools
- Update seeder to seed schools based on DESE IDs
4 years ago
413096dfe2
Extract legacy parts of the codebase into its own module
4 years ago
4fd6dac791
Add category/subcategory ID columns to uniquely identify records
4 years ago
37f13716e8
Add timestamps to all SQM models
4 years ago
228cf137ad
Finishes #179904795 . Adds prompts to measures section on browse page
4 years ago
44fd077023
ran rails app:update
4 years ago
a406205e20
Completes Sub Categories and Measures for "All " Category Tabs -
...
Milford High School (Milford District). Add tabs to top navigation [#179727241 ]
4 years ago
ae525fdb2a
Completes Measures on the "Teachers & Leadership" Category Tab -
...
Milford High School (Milford District) [#179728008 ]
4 years ago
000bb52e1d
Display subcategory descriptions on browse page
...
[Finishes #179426091 ]
4 years ago
6a101eab76
Add description to sqm_category
4 years ago
b28f37d8b7
Add indexes on measures, survey items, and responses
4 years ago
e222edc7e7
Add academic years as an ActiveRecord object
4 years ago
a7de5b9ac2
Add response id to SurveyItemResponse
4 years ago
8fc6fae16b
Add qualtrics_code to District and School
4 years ago
12415861c1
Rename construct -> measure, seed with SqmCategories and Subcategories
4 years ago
71ad999dd0
Add slug to district
4 years ago
1782ef3482
Compute the score for a given construct, school, and academic year
4 years ago
8915cb9d45
Add Item, seed from .csv file
4 years ago
acac8f67b0
Seed db with Professional Qualifications construct
4 years ago
Nelson Jovel
Liam Morley
Alex Basson
Chad Serrant