K-12 Environmental Theme Schools in the Park River Watershed

Posted on

Water quality and quantity are measurable in our bodies, rivers and built environments. We depend on this natural product to sustain us and keep communities flowing and regulated. Every being on this planet depends upon water. Yet, we still face challenges convincing our neighbors, peers, and communities to work together and give people the tools to make differences that improve our one and only shared natural earth.

Click on the map above to open in a new tab.
Click to view live map in a new tab/window.

In order to develop a successful watershed stewardship, we need to identify interested groups, such as schools, home owners, park friends & groups or municipalities, etc., who live on or around the river. Many people don’t realize that their own back yard contributes to the health of a stream ecosystem. For example, lawn fertilizers or salt deposits washed from rainstorms can quickly build up in our reservoirs or drainage systems. These problems created by us can lead to myriad issues including changing the pH, temperature, or even flow of the river, which can ultimately deteriorate the river and organisms over time. The Park River Watershed can help orient these interested groups towards annual activities that improve water quality and gather information from these events and organizations. Thus, we are able to gain aggregate site specific data.

Collected data can then be forwarded to state and federal environmental programs or government agencies as well as nonprofits that work on the larger water bodies such as Connecticut River Watershed Council and Save the Sound, which is the Long Island Sound coastal environmental nonprofit group.

With help from Trinity College students, Shaina Lo and Veronica Armendariz were able to create data visualizations about certain schools in the Park Watershed that incorporates environmental goals into their school curriculum. Public school information was obtained from the SmartChoices website, and the Park Watershed Project categorized the school data. From this website, one can read further on deciphering the differences between the types of SmartChoices schools around the Hartford area region. SmartChoices includes public school in the city of Hartford as well as 19 other suburban towns.

This interactive data visualization can help parents around the Hartford area view specific schools they are interested in for their children that are concentrated on environmental goals. It my also be helpful for teachers or people interested in the educational system to help them discover these specific schools that are in or around the Park River Watershed.

Below are the descriptions and color identifications for each school:

Yellow/1) Water or wetland adjacency: school grounds are within walking distance of a river, brook, or pond. This increases opportunity for water quality monitoring, environmental research and stream stewardship.

Green/2) Environmental goals: School curriculum prioritizes natural sciences, which increases potential for local environmental research and stewardship.

Purple/3) A nature trail, park, or open space within walking distances indicates opportunities for classroom or extra curricula site specific (environmental activities).

Pink/4) Science goals could include topics such as medicine or technology that is not directly related to the environment.

Red/5) STEM schools are schools that concentrate on Science, Technology, Engineering, and Math.

IPC Transition Plan

Posted on

The data I received came from a database of Pediatric Trauma Patients from 2007-2012 which is owned by Connecticut Children’s Medical Center. All the data that I have are either in Microsoft Excel format or Google Spreadsheet. Because a lot of information is confidential in the original data or easily identifiable, the original data set cannot be shown publicly. However, as long as it is de-identified , such as removing specific columns of data (ie. age, city/residency) data may be displayed.

All my graphs and visualization can be accessed through my github site here. As for the actual data, all my formatted data is on a Google Drive folder that is easily accessible with the visualizations as well.

Although these are simple charts, the formatting of the data may be useful for the future just in case a data visualization expert would want to create more sophisticated charts. Although I do not have the training in coding that is required for more complex visualizations, I feel like the ones I have now create potential ideas for future visualizations. However, complex visualization may not be necessary because there is still so much that can be visualized from the data set.  Just using Google Charts can be sufficient for creating more visualization that don’t require expertise in data visualization.

 

 

Seminar Redesign

Posted on

1) Reduce and insert data viz as a 3-week module into a topical seminar, similar to how I taught an abbreviated version during Ed 308 Cities Suburbs Schools seminar in Fall 2013
Pros:

  • The students get experience with data visualization

Cons:

  • The experience the students get doesn’t get to get developed and built upon as much as it would if it were a full semester course

2) Keep as-is with current 0.5 credit seminar combined with 0.5 credit internship.
Pros:

  • It’s good to get internship experience with a mentor and build a semester long relationship
  • Ability to get fairly extensive data visualization instruction, but still be able to apply it to a community partner internship

Cons:

  • It isn’t an entirely in depth instruction of data visualization, for example we don’t learn how to code

3) Expand into a larger 1-credit course, with more data viz content and coding instruction during the first half, and pairs of students working on community partner projects during the second half. Also, may count toward Numerical & Symbolic reasoning requirement.
Pros:

  • Get more focus on the data visualization which can help further understand it
  • Could lead to an ability to do more advanced visualizations 
  • Get numerical & symbolic reasoning credit for it

Cons:

  • Don’t get the full internship experience, particularly of building a relationship with a community partner throughout the whole semester

Recommendation: My preferred option of these three would to be to stay with the seminar as it is now with it being half credit seminar and half credit internship. I found the internship experience INCREDIBLY valuable, so I think that should definitely remain part of the course.

Redesign Seminar

Posted on

My recommendations for this course in a future semester would be similar to the third option. I think the semester the way it was this semester was great, keeping in my this semester was the first and thus a trial and error semester, but I the data viz and coding instruction definitely could seem appealing in the future.

Although there won’t be able to have as much of an internship experience, i think that even just working with a partnership outside of the college is very interesting and a great opportunity while also learning how to create these visualizations with a more in depth learning of the coding aspect.

The community partners are definitely a necessity for a course like this and they seemed to be extremely willing and helpful throughout the semester, but I know in my case, joining so last minute and being only .5 credit, it was hard for my partner and I to really create and maintain a structure for our semester project and partnership. Nevertheless I really enjoyed working with her and very much appreciated her allowing me to do so such last minute.