Vallyre and Lauren went over front-end Github issues to tackle ahead of August Spark Day. Looking forward to sharing this project at the event!
This is how you can help
If you are a…
- Citizen/Tester (non-techie): Look at the "Backlog" list of needs to help fill gaps in the site to make the profiles more understandable
- Front-End Developer: Enhancements to v1
- Back-End Developer: List of needs
- Data Wrangler: Collect info for School Profiles; principal emails, etc
- UX / Designer: List of needs
Durham School Navigator is web application tool to help parents understand the different public schools in Durham County and make informed schooling decisions. Durham School Navigator provides a common and easy-to-use platform for all public schools to share information about themselves with parents. The mapping web app provides a way to
- easily identify the Durham Public Schools (DPS) zoned schools based on a home location,
- determine the areas on the map these zones cover,
- and the distance to other magnet and charter options.
In addition the school profile survey to school principals, provides a common and easy-to-use platform for all public schools to share information about themselves with parents. Explore the sample school profile here
We have partnered with Durham Public Schools (DPS) to have them directly link to durhamschoolnavigator.org vs. the current mapping tool.
Durham Charter Collaborative, Durham PTA Council, and DPS are supporting Code for Durham in launching the School Navigator and the principal survey for the school profiles.
The code base for School Navigator is located at https://github.com/codefordurham/school-navigator. The README file shows links to documentation.
At the 1/31 meeting, Nicole and Lauren reviewed Lauren’s updated designs based on the outcome of usability testing with new CfD members, Sanchit and Lina.
The website was down as a result of the certificate being expired so we were unable to do any work directly on the site. It has since been updated.
Looking forward to getting the group together in the coming weeks to keep pushing forward on this initiative!
At the 12/13 meeting, Basia worked on converting profile change recommendations into Github issues. Jeremy, Alex, Nicole and Lauren discussed immediate next steps for the project. Lauren, Basia and newcomer Vallyre went over the profile design change recommendations.
Immediate next steps (thanks Nicole!):
|Email Chip (DPS) and Lisa (Charter School Collaborative) to give update; Provide list of schools who have not participated||Nicole|
|Add in teacher satisfaction links||Nicole|
|Assess state of ancillary pages (i.e. not profile pages) to determine what needs to be changed||All|
|Remove the “alpha”|
|Work on inputting updates to profile page from usability testing||Basia, Lauren|
|Work on revised profile page design mockups||Vallyre, Lauren|
|Identify marketing opportunities||All|
|Fix the map feature on the updated profile pages||Victor|
|Look into Spanish translation options||Alex|
|Work on accessibility assessment||Lauren|
|Remove 'Sample DPS school' from school names in the updated profile pages|
|QA Testing on mobile||All|
Bendte, Basia, and Kesley, have gone through the screen capture and various people's notes from usability testing sessions on the school profile page, and we have combined them into a recommendations document.
Kesley will start turning those bullet points into GitHub issues. Bendte and Basia will help as needed, and anyone else is welcome to jump in. So hopefully we can start getting some of this stuff done.
- Met with Chip at DPS Communications (Nicole, Jeremy)
- Met with charter school collaborative? (Jeremy)
- Began working on accessibility issues (Lauren)
- Prepped consent form for usability testing (Lauren)
- Sent out virtual usability testing invitations (Basia)
- Practice & planning for in person usability testing (Bendte, Nicole)
- Updated email template (Alex)
- Production deploys & PR review (Alex)
- Sent out emails to 46 schools who haven't or have only minimally responded to our survey (Nicole)
- Added URL field for teacher satisfaction survey to Schools (Prateek)
- Code cleanup (Will)
- Began looking at frontend caching via a manifest file (Will)
- Began getting set up (Brian)
- Merged pull requests from last two meetings and gave feedback.
- Deployed master to production
- Began working on scraper for teacher satisfaction survey
- Setting up meetings with DPS & the charter school collaborative
- Finalized script for school profile page usability testing
- Built user survey about school profile page
- Alice reviewed and analyzed school profile responses and compiled them into a Google Doc
- Nathan started adding teacher working conditions data to the database
- David and Jeremy reviewed new state accountability data
- Grant and Jonathan continued work on associated schools to state IDs
Great work today by all - thanks to everyone for joining!
- Basia, Lauren, Bendte – worked on designing a usability test for the new user interface design
- Nicole, Alex – worked on identifying and reaching out to schools who hadn’t started the survey — Nicole followed up with the lists to Chip at DPS and Laura at the Charter Collaborative to send a gentle reminder to these schools; once sent a survey with an updated link will be sent (by Nicole)
- Graham – made an update to the project setup documentation
- Jonathan – worked with Basia to make tab interface functional in the new design page; pushed a branch to add tabs to the school’s page that has a neighborhood tab
- David – discussed potential displays of datasets to allow for ease of understanding for families with varying backgrounds
To date, 18 schools have at least begun to fill in their profile! We're excited for more responses to trickle in. Specific updates below:
— Victor worked on fixing the photo upload features - in the coming days he plans to update the survey such that schools can upload the photo themselves. — Nicole will send an update to the reminder email to include the note about photos - the reminder is planned to go out next meeting (7/26) to give appropriate time for people who haven't started to get the survey in. (Currently due 7/29) — Basia, Bendte, and Lauren were doing a "card sorting" design exercise to help enhance the user experience on the website. — Lauren Hirsch and John Fredrickson got added to the github. — Alex and John were working on integrating the charter listing page to link to/be consistent with the other school listings. — Seth followed up to get a codeforamerica domain for an email address for the project team. — Jeremy worked on a link from the mini-profile to main profile on the search results. — David continued to assess NCDPI data.
Thanks to all!
We launched the School Profile Survey to DPS tonight!!!
- Victor reviewed and merged outstanding PR's
- adds the link to school report cards (Rolf)
- Add feeder school status to profile and survey (Jeremy)
Victor, Rolf, and Jeremy fixed issues blocking survey launch
- Add CC emails to charter
- Ask for an emailed picture in survey
- Rolf and Nicole edited and finalized survey emails for launch to DPS and Charter Schools
- Nicole set up schoolnavigatorteam gmail account for the survey communication
- Victor set the survey due date to match the letter from DPS to all pricipals
Seth and Nicole uploaded all public school principal email addresses in preparation for survey launch
- Nicole launched survey to DPS schools
- Sarah followed up with Lisa Stella at the Charter School Collaborative to send email out to charter school principal
- Nicole, Jeremy, & Sarah will launch the survey to the charters consistent with the feedback from Lisa
- Sarah and Basia discussed potential options for another round of user testing to refine information architecture of profile
- Sarah and Basia made a recommendation of how we should link the profiles to the map view page
- Seth reached out to the code for America team to get a Code for Durham email domain (@codefordurham.org)
- David worked on statistical analysis of public school data; David and William discussed the data
Tonight was Sarah's last night at Code for Durham, Thank You for all you have done for the School Navigator project. We wish you the best and will miss you.
- @ammraleigh (Ann) committed updates to the School Guide page table
- @BobbyBarbeau started a separate charter school email template
- @RolfBates added a migration to add a standardized
state_idto Schools. This can be used to add state data to schools.
- @elynch (Ellen) fixed collapsing of school info on map search page
- @schpatel (Seth) started to set up email account for durham school web domain. Will flesh out outreach plan for real estate agents.
- @npage915 (Nicole) Working with Jeremy on figuring out special case charter schools. Multiples location or multiple school leaders. Added new schools.
- @jtf621 (Jeremy) worked on adding relationships to the School model to represent schools "feeding" other schools.
- In the last week @basiacoulter and @bendte worked on a plan for a round of UX improvements. They worked on a plan for reaching out to the community and A/B testing multiple options.
- Planning for National Civic Day of Hacking
- Go to the Meetup to sign up to be here there with us
- Triaged lots of tickets.
- Cleaned out Phase 2 & 2.5 to cover only those items needed for public launch of new profiles & surveys
- Created new Phase 3 with a set of Phase 3 goals
- gturmel onboarded into Github & Angular
- Profile page changes + coming soon (Victor)
- Merged line breaks & changes (Victor)
- Systems administration due to broken dependencies (Victor)
- Narrow scope of Phase 3
- Planning doc for Civic Day of Hacking (Jeremy)
Cleaned up, tested, and fixed issues for Phase 2:
- cleaned issue backlog (Alex)
- fixed broken date in email template (Alex)
- fixed 6 issues on profile page (Victor)
- set up coming soon tags on profile (Victor)
- testing and updating sample profile (Sarah)
- updated links in school list to point to profile (Victor)
- corresponded with DPS on next steps to launch survey to principals (Sarah)
- set up email bounces (Colin)
- fixed 2 issues on profile/survey page (Jeremy)
- worked on preserving breaks in long survey text (Jeremy)
- got front end development environment setup and tarted on an issue (Terry)
- planning for Jun 4 Civic Day of Hacking (Alex, Adam, team)
We met today and got a lot done, including:
- Major SES/Emailing improvements (Colin)
- Updated School Profile & Survey Form Templates (Alex + Sarah)
- Fixed creating new schools in the admin (Jeremy)
- Fixed huge security hole in API permissions (Jeremy)
- Fixed Submit Date for new surveys (me)
- Created a new Resend Survey admin action (me)
- Updates to the school profile (Victor)
- Developer documentation improvements for running front-end + backend locally (Colin)
- Added Jeremy to production server (Jeremy + Colin)
- Setup default field values in survey/profile for specific fields depending on type of school (Victor)
Outstanding items for launch: More QA & Testing!
There's a sample schools: https://durhamschoolnavigator.org/#/school/247/ You can set your email to the principal email. Send yourself a survey. Fill it out. We will be using that sample school as a demo in our meeting next Tuesday at 9am….
Sarah, Colin, and Jeremy also had a productive meeting with DPS this week. Here are the notes: https://docs.google.com/document/d/1ua4pjyQsF8Ujqj7y0LkruMf5rNvrYuuUjz5yfqh5xWQ/edit
We will be at the meeting of school principals next week to demo the project and ask for everyone to fill out the survey.
- reviewed UI on touch/phone (Rosa)
- reviewed state test data consolidated by David
- tested production app and noted issues with WG Pearson shape file (Will)
- worked on NC teaching working conditions survey data cleaning
- more work on school profile survey design (Sarah)
- Migrated data from schools to the new School Profiles
- Created automated email survey tool to send to school principles to collect school profile data not currently available
- Collected feedback form User Design professional and made edits (Thanks Rosa!)
- 75% finished pulling NC DPI School Teacher Working Conditions Survey data
- Alex and Sarah met with the Durham Charter Collaborative (which is board members and principals from Durham's charter schools) last week and they were very excited about the site. They all agreed to complete the survey once it's ready.
- Sarah is reaching out to a handful of administrators from the 3 types of schools to get their feedback on the profile and confirm that we're not a) using the wrong language/categorizations anywhere b) asking for unrealistic info c) get their buy-in. So far so good.
- Onboarded Melissa - who made her first commit - Awesome!
- Victor cleaned up new survey form HTML & setup django environment
- Jeremy reviewed NC Teacher Satisfaction survey data
- Sarah continued providing user feedback and prepped for charter group meeting
- Squiggs did some tweaks for the profile page and the school list
- Jeremy looked at acceptance rates for magnets for scraping
- Alex committed a new API endpoint for school profile info
- Jeremy got his development environment set back up
- Fixed a couple of backlog Issues (Jeremy, Squiggs)
- Attempted to scraped data from PDF for Principles for each school (Chris K)
- Working on front end issues in waffle.io to improve centering on schools (Squiggs)
- Working on phase 2 School Profile backend (Jeremy)
- Unique URL for SchoolSurveys (Alex)
- Fixed UserSnap integration (Alex)
- Survey of fields for manual scraping of school pages (Sarah)
- School Guide page (James)
- Worked on school profile page (Squiggs)
- onboarded new team members
- refined fields for school profile
- pulled together information for a sample profile to collect user feedback
- began several UX tweaks including #235 lighting up the school icon on the map when you hover over the school name in the drop down list
- inputted remaining user feedback from Nov survey into github
- New profile field brainstorm
- New domain purchase by Colin
- Sarah closed ticket #238 fixing a user submitted bug about a school's data
- School profile page design rough out by Squiggs & Victor
- New profile backend rough out by Jeremy
- Suggestion to use django-reversions by Colin ( django-reversion.readthedocs.org/en/latest/ ) to track changes to school profiles due to survey submissions and data source pulls
Updates for the week:
- Sarah —- Shared & reviewed survey results. Starting to write up summary.
- Jeremy —- Triaged tickets.
- Alex —- Introed Iron Yard student ( https://github.com/jeremyrist ) to project, merged his PR, and deployed.
- Adam & Colin —- Met with PTA council. Discussed further outreach opportunities.
mega props for megamilestones, team!
- Partnering: Presented prototype to Durham Public Schools PTA and Chief Communications officer with extremely positive responses
- User testing feedback: Completed user testing with 80 individuals via Duke Engineering School's Design Thinking Class (thanks!)
- Data quality testing: ran 1000 test addresses throughout area both DPS and SchoolNav sites to test accuracy of results with 90-95% successful match
- Finished Parent Survey and sent out to a few friendlies
- Added Usersnap - feedback tool
- Added "priority" to magnets where there are zones
- Updated "magnet" page in Navigating DPS section
- Reviewed survey for parents
- a https://github.com/codefordurham/school-navigator/issues/104
- b The elusive https://github.com/codefordurham/school-navigator/issues/73
- c https://github.com/codefordurham/school-navigator/issues/89
- d https://github.com/codefordurham/school-navigator/issues/82
- e https://github.com/codefordurham/school-navigator/issues/54
- Schelling's segregation model and focus on schools performance over demographics
- Sarah worked on adding mission statements to schools
- Jeremy is automating attendance data input
- Squiggs emailed education related community groups & is working on a key for the school list https://github.com/codefordurham/school-navigator/issues/100
- Victor removed school list page. Added hours and renamed description -> mission statement. Frontend now shows mission statements.
- Squiggs' first merge https://github.com/codefordurham/school-navigator/commit/9fb6c063e95cea097e3f3524179d53747e3c5d01
- Reorganizing the ticket tracker to focus on Phase I / Phase II
- Colin manually merged two Club Blvd school records https://github.com/codefordurham/school-navigator/issues/86
- Discussions about next steps for adding additional school data: https://github.com/codefordurham/school-navigator/issues/85
- Planning for surveying parents about how they would use this tool
- Onboarded d-griffin-dev (angular/frontend) & kyleg0 (data importing)
- Added school URLs to API
- Added email address link in docs
- Reviewed outstanding backend issues
- Prototyped School Details page for users when exploring what schools are in their district
- Made the house location on map draggable to new locations (more dynamic browsing/results)
- Added Distance to Schools from house on map - in api and Ui
- Integrated Magnet school data (w grade_min / grade_max) from GIS
- Bug fixes
- Fixes: map doesn't load most of the time.
- New: each address has a unique url that can be shared.
- New: School detail page (currently blank, I need business for page design)
- New: Hovering over a school on the left panel highlights it on the map.
- New: Left panel's schools are now clickable (school detail page)
- Remove the 'all' tab.
- Removed selected school district when a tab is clicked.
- Added new classes to the school icon to allow for better styling
- Uncovered the reason why the option tab is not showing the list of school: the data is malformatted.