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!

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!):

• 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_id to 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)

TODO:

• Narrow scope of Phase 3
• Planning doc for Civic Day of Hacking (Jeremy)
  • Background

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

• Analyzed/Reviewed 80 survey responses
• Discussed strategy for info collection on School Profiles
• Mocked up and discussed UX improvements to make on mapping tool
• Scoped v2 on Waffle

Lot's of new backlog items on waffle

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

• Copy for "Navigating DPS" and "About" drafted here

Closed:

• 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

Discussed:

• 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

• Setup SSL cert
• Pulling in School Photo Field & School Description Field
• Added 10 Durham Charter Schools to school list
• Worked on structuring database for NC School Stats to pull in

• New issues added on Github - see Waffle
• Drafted User Feedback / Outreach letter to neighborhoods

• 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.