Category Archives: K-12

School For Me

Helping parents and teachers šŸ™‚

School For Me will help parents find a new school for their child and teachers locate schools that have a shortage for certain subjects. Parents may search for a school with certain criteria such as “low student to teacher ratio”, “title 1 school”, and so much more. I am using public data provided by theĀ National Center for EducationĀ andĀ Data.gov, both are updated yearly for the information provided.

 

Steps

Once the data is downloaded, a few fields were sanitized or removed. There is no need for extra data that will not be used. After cleaning the data, I uploaded it to a MySQL database hosted on my VPS. Currently the data is downloaded once per application load as a JSON result, although this process will change.

The API accepts three parameters: lat, lng, and distance. The distance parameter is optional and will default to 50 miles. The haversine formula is used to calculate the distance from the users coordinates to the nearest schools based on the provided distance.

 

A more detailed and better write up will be available soon. This is mainly for me to gather my thoughts until the application is finished. Screenshots and development videos have been attached, please keep in mind the design and functionality will only get better as development progresses.

  1. School For MeĀ –Ā Project page