I have a school district polygon divided up by neighborhood, and I am trying to determine the number of students from each grade per neighborhood. The student point file contains an attribute with grades 1-12. I would like the output to be the neighborhood polygons with 12 added columns containing the count of each grade. I am looking to do this with model builder or a script because their are over 200 neighborhoods.
Thus far my research points me to intersect the neighborhood ID numbers to the points, join the students to the neighborhoods, and then use the field calculator to populate a field for each grade.
Is there a simpler way to automate this in ArcGIS Pro, or am I on the right track?
I would rather create a model that counts the attribute 'grade 5'for all points located in each neighborhood and creates a new column or adds it to an attribute column in the neighborhood shapefile, but my brain is frozen at the ModelBuilder.
I have AcrGIS Pro 2.3 with the basic license.