Informática para Engenharia Ambiental - Unidade 4: Planilhas eletrônicas

Parte 1: Introdução às planilhas eletrônicas Parte 2: O ambiente de trabalho do programa BrOffice.org Calc Parte 3: Primeiros passos Parte 4: Trabalhando com vetores e matrizes Parte 5: Construindo gráficos Parte 6: Resolvendo problemas Parte 07: “Travando” uma célula na planilha

Muitas histórias, uma imagem: a percepção sócio-ambiental de alunos residentes da Escola Agrícola de Jundiaí

Tendo como base os conceitos de espaço, lugar, ambiente e imagem, sob as vertentes da Arquitetura e Urbanismo, Geografia e Psicologia Ambiental, esta pesquisa teve como objetivo averiguar a percepção de estudantes da Escola Agrícola de Jundiaí (EAJ UFRN) a fim de identificar aspectos das interrelações pessoa-ambiente que diferenciam tal escola de outras instituições. A coleta de dados utilizou multimétodos e investigou um grupo de alunos residentes na Escola que cursavam o ensino médio e técnico em agropecuária em 2006, analisando seus discursos, comportamentos e atitudes de modo a identificar os principais elementos da imagem sócio-ambiental da EAJ. Os resultados apontaram locais, práticas sociais e símbolos representativos da instituição, indicando espaços (construídos e naturais) adequados/inadequados às necessidades/expectativas dos estudantes incluindo a ampliação da interdisciplinaridade no conjunto de suas atividades. Além disso, a fim de incrementar a análise sócio-ambiental em instituições que promovem experiências exitosas, recomenda-se que os aspectos cotidiano e tempo sejam mais profundamente investigados em estudos futuros na área

Mobilidade urbana sustentável em projetos estruturantes: analise urbanística e ambiental do corredor de transporte da Avenida Bernardo Vieira Natal/RN

The search for a sustainable urban mobility, has recast the public policy of transport and movement for all, in order to contribute to the welfare economic, social and environmental. Within this context, has as its main objective review here in the city of Natal in the state of Rio Grande Norte, the deployment of the new road infrastructure of the transport corridor of Bernardo Vieira Avenue and checking at least with regard to urban areas and environmental chosen here, as will indicators to assess sustainable urban mobility, that the theory has been well constructed, but in practice little way to apply the proposed guidelines for sustainability. To achieve this result, is initially a literature review with the principal investigators of the matter, since the concepts of indicators of sustainable urban mobility. And a second time, participating in to the case study, using the methodology of environmental awareness, through analysis photographs, notes and testimony in the study area ace to reach conclusions

Percepção Ambiental em Museus Paisagens de Arte Contemporânea: a legibilidade dos museus Inhotim/Brasil e em Serralves/Portugal avaliada pelo público/visitante

This thesis nalyzes the wayfinding in Landscape Museum of Contemporary Art (MPAC), based on the Institute of Contemporary Art CACI, Minas Gerais, Brazil and the Museum of Contemporary Art of the Serralves Foundation, Porto, Portugal. The study focuses on the interrelationship of the public/visitors with the landscape, architecture and contemporary art museums in these, in order to understand visual perception and apprehension of such an environment for their users. For both were confronted documentation (visual and written) and people talk. The main hypothesis put forward is that the audience/visitor MPAC appreciates the interrelationship between the natural environment (park/garden) and built environment (the works of contemporary art and the galleries), giving equal value to both. To complement this, a second hypothesis is that during the visit to MPACS, visitors define their paths spontaneously, but strongly influenced by existing visual indicators (maps, signage and striking landscape elements), which facilitate the readability of space, which also contribute to the offered services and the experiences of similar institutions. The analytical basis of the research used the concepts of legibility (LYNCH, 2009), wayfinding (GIBSON, 2009; ARTHUR, PASSINI, 2002; WEISMAN, 1982), Experiential Cotinnum (TUAN, 1985), Space Bound (CRUZ PINTO, 2007) and habitus (BOURDIEU, 1992). Methodologically was used qualitative research (DEMO 2000) by means of a case study (YIN, 2005; STAKE, 1999) and participant observation (WHYTE, 2005). In the two institutions interviews with researchers and curators, behavior observation and questionnaires from employees, trainees, monitors and the public/visitor of the two museums were performed. Although partially referende the initial hypothesis, the research showed that the public/visitor value appears more natural environments, they experience a greater intensity and in addition to the factors listed in the second case, your perception and definition of paths suffer significant influence of emotional relations established with space. Generally the audience/visitor adapts easily to different demands of contemporary art exhibition in the two museums and the built environment (park/garden and museum) interferes with your reading path during the visit, perceived by the public/visitor condition as a factor that favors the enjoyment of works on different mounts (wayfinding), though often become a factor that hinders the legibility of the building and its built environment

UBS RN-7: proposta arquitetônica para um padrão flexível de unidade básica de saúde para a zona bioclimática 7 do RN, com ênfase na sustentabilidade ambiental

Standardization and sustainability: these two apparently antagonistic words find the challenge of uniting in a flexible architectonic proposal. This was the idea that motivated the proposal of this assignment, whose appearing is bound up with the necessity of thinking about standardized spaces that attend on functional criterias and environmental sustainability, in reply to an existing real demand. The assignment consists of an architectonic proposal for a flexible standard of a Basic Unit of Health for the bioclimatic zone 7 of RN (UBS RN-7), with emphasis in the environmental sustainability. The project contemplates innumerable involved variables, such as: obedience to the current law of the Health Ministry for the UBSs; formal/aesthetic aspects; criterias of expansiveness of the UBS I for the UBS II; relative aspects to the constructive rationality and, mainly, sustainability aspects. With the intention to unite the variables and, also, glimpsing a proposal that could reach a good functional performance, aesthetic, of environment comfort and energetic efficiency, it was also necessary to consider concepts about the flexibility of the envelopment. The elaboration of the architecture first draft was based on bibliographical research, conceptual studies and references, elaboration of the architectonic program and the draft development for the UBS port I and the UBS port II. To the end, an implantation data sheet for the project is proposed for the UBS standard project, where strategies of thermal isolation, shadowing and thermal inertia are adopted and combined to three possible types of lot, resulting in 24 possibilities of implantation

Comunidades tradicionais em áreas protegidas: convergências e lacunas da Política Urbana e Ambiental na Reserva de Desenvolvimento Sustentável Estadual Ponta do Tubarão/RN

This work presents a reflection on possibilities and boundaries of consolidation and expansion of human settlements characterized as traditional communities that are located within protected areas, using as study reference the State Sustainable Development Reserve Ponta do Tubarão, at Rio Grande do Norte state. The main topics highlight the conflict between the right to housing and the prevalence of fundamental rights of traditional populations, opposed to the diffuse right to environment, according to the regulatory framework of the Brazilian Urban and Environmental Policies. At the same time that these settlements, historically built, are substantiated by the principles of recognition of rights to traditional populations, they are in a condition of complexity to the resolution of conflicts in its urban dimension and lead to an impairment of natural sites. This work questions how the instruments of land use and occupation are defined and relate to environmental planning, especially considering that the settlements are located in Permanent Preservation Areas (APP). It aims to further the discussion of the urban dimension in settlements, characterizing its formation and growth process, to identify the gaps and convergences between the Urban and Environmental Policy, under the foundations of a socio-environmental approach. The results spotlights the conflicts between occupation and natural areas, inferring that the definition of Urban Policies instruments and its integration with Environmental Policies instruments account for essential and priority actions to the achievement to the rights to a sustainable city, as determined in the Cities Statute and environmental protection goals, defined for the Conservation Units

Todo Brasileiro merece nível A : habitação multifamiliar para o programa minha casa minha vida energeticamente eficiente

This thesis describes the theoretical, methodological and programmatic proposal for a multifamily residential building located in the urban expansion area of Parnamirim/RN, inserted in the program Minha Casa Minha Vida and level of energy efficiency "A", as the RegulamentoTécnico de Qualidade (RTQ-R/INMETRO) for residential buildings. The development project initially consists of procedures as the study of theoretical, architectural programming and cases studies. With the delimitation of a field solution, situated between the reference and the context, proposals are studied to determine the solution and architectural detailing of the proposal. The architectural program was built based on the method of Problem Seeking (Peña and Parshall, 2001) and research has highlighted aspects of reducing the environmental impact and of the program Minha Casa Minha Vida , among others. The design process was characterized by the incorporation of aspects reviewed and programmed, seeking them compatible and have an economically viable building, socio-spatial quality and energy efficient. The results show that it is possible to obtain a building that meets the constraints of the program that provides housing and energy efficiency level A - and many other environmental qualities and constructive, particularly through architectural design

Análise do licenciamento ambiental como instrumento de política do meio ambiente no Rio Grande do Norte Período 1992-2003

This analysis on the ambient licensing is based on a research that identifies the fragilities and advances of the application of this instrument of politics of the environment in the ambient politics of the Rio Grande do Norte, in the period of 1992 the 2003. The isolated urban area of Búzios, situated in the City of Nísia Floresta/RN, situated in the eastern coast of the State, where concentrates the boarding of the ambient question as a matter in the Brazilian process of urbanization, over all the institutionalization and implementation of the ambient licensing. They are distinguished in the used methodology in consultation to the diverse involved social segments with the ambient subject in study, the example of the managers, technician and specialists, as well as the application of the legislation and norms techniques, the forms of appropriation of the common wealth and the procedures of ambient licensing of the competent agencies. The results of the research designate that the ambient licensing while instrument of the ambient politics is one of the alternatives more efficient as techniques in the process of sustainable development, since it is beyond the prerogatives to conciliate the activities and enterprises with the conservation of the environmental resources and natural benefits to the societies. In the RN one evidenced progress in the ambient legislation and the instructions techniques, and that the imperfections and limitations in the system of ambient licensing are not directly on to the instruments, but in the implementation of mechanisms of the ambient agencies. This because they do not make use of operational structure to apply in practical and established abilities, as an ambient management, institutional joint and deliberations of the State Counselor for Environment

Percepção ambiental do patrimônio cultural: estudo de caso na Cidade Alta e Ribeira em Natal-RN

Contemporary studies have shown that the evolution of the heritage concepts is accompanied by an affirmation of the importance of social participation in recognizing heritage values and in managing cultural assets. We used the Brazilian context to emphasize the challenges for democratizing this process. This problematic is discussed based on the cases of Cidade Altaand Ribeira, neighborhoods that date from the formation of Natal-RNand have cultural assets recognized by levels of government. The study builds elements to answer the research question: what meanings and representations does the culturalheritage in the case study have for its users? The research method analyzes the representations and the meanings of the neighborhoods, firstly is based on historiographical studies, memories records of the city and on the process of heritage management. Secondly, it isbased on the field research, it is structured in environmental perception studies (areas of Environmental Psychology, Architecture and Urbanism) and has been applied with users with different bonds with the studied environment (residents, workers and visitors). The data were obtained with the multi-method which included direct observation, questionnaire survey and mentalmaps (that replicate Kevin Lynch). The analysis of result verified the research hypothesis, emphasizing aspects of the relationship between users and cultural heritage relevant to strengthening collective memory, local identity, contributing to heritage management. Among the results, the socio-environmental image obtained which emphasized a "cultural axis" linkingboth studied neighborhoods and confirms the influences of elements rein the memories records of the city and in the area s management. Identified aspects to strengthen the relationship between the users and cultural assets, such as the presence of placeswith affective ties to certain groups, as well as the need to fight off negative images (of degradation and insecurity) associated to the site and also expand the participation of the population, including residents, in policies and cultural activities. After all, recognition of value and the involvement of societycultural assets have the potential of contribute to integrate city development with heritage conservation

Determinação da toxicidade aguda e caracterização de risco ambiental do herbicida Roundup (glifosato) sobre três espécies de peixes

Considering their commercial importance, as these are the species of freshwater fish more commercialized in Brazil, their occurence in different kinds of aquatic environments (lakes, rivers and dams) and for being tolerant to a wide range of variation of various physical parameters and chemical water, the fish species Oreochromis niloticus, Cyprinus carpio and Colossoma macropomum were chosen for this study, furthermore, to test the toxicity we used the herbicide Roundup. The fingerlings of tilapia (Oreochromis niloticus), commun carp (Cyprinus carpio) and tambaqui (Colossoma macropomum) were submitted to the herbicide roundup in the following concentrations: 0.0 (control); 18,06; 19,10; 20,14; 21,18 and 22,22 mg.L-1, 0.0 (control); 13,89; 14,86; 15,83; 16,81 and 17,78 mg.L-1, and 0.0 (control); 18,06; 19,10; 20,14; 21,18 and 22,22 mg.L-1, respectively, three for 96 hours. The LC50 - 96h for O. niloticus, C. carpio and C. macropomum was 21,63, 15,33 and 20,06 mg.L-1 of the herbicide roundup, respectively. The results show that this herbicide is classified as slightly toxic to the three species. The values of dissolved oxygen, pH and temperature recorded in the aquarium control and aquarium experimental of the three fish species have remained without significant variations during the tests, which reduces the possibility of death caused by sudden variations of these parameters during the 96 hours the experiment. The values of LC50 between different species of fish were observed, noting that the species O.niloticus, C. carpio and C. macropomum showed no expressive differences. The values of environmental risk of Roundup were calculated to obtain more stringent parameters in assessing the dangerousness of those on nontargets. The risk of environmental contamination by Roundup for the Nile tilapia, common carp, and tambaqui are low for the lowest application rate (1 L.ha-1) and depths (1.5 and 2.0 m). The dilution of 100%, the highest recommended dose (5 L.ha-1) and depths (1.5 and 2.0 m) the risk is moderate for the three species. The values of the Risk Ratio (QR) were greater than 0,1, indicating that the values of the CAE and LC50 are above acceptable levels and there is a need, this study, a refinement in ecotoxicological tests

Diversidade de macroalgas marinhas bentônicas dos recifes de Maracajaú, área de preservação ambiental dos recifes de corais, Rio Grande do Norte, Brasil

Despite the importance of coral reefs to humanity, these environments have been threatened throughout the world. Several factors contribute to the degradation of these ecosystems. The Maracajaú Reef Complex, in Rio Grande do Norte state is part of the Coral Reefs Environment Preservation Area in northeastern Brazil. This area has been receiving an increasing influx of tourism and the integrity of the local reefs is a matter of concern. In this study, the reef macroalgae communities were studied and compared within two areas distinguished by the presence or absence of tourism activities. Two sample sites were chosen: the first one, where diving activities are intense; and the other, where these practices do not occur. Samples were collected at both sites within a quadrate of 625 cm2 of area randomly thrown 5 times along a 10 meters transect line. Richness, Shannon-Hill diversity and Simpson dominance indices were determined based on biomass data. Similarity between sites was analyzed with Bray-Curtis similarity and distance index. Fifty-eight macroalgae species were observed, including 7 Chlorophyta, 13 Phaeophyta and 38 Rhodophyta. In the non-disturbed site, 49 species were found, while at the disturbed site, there were 42 species. Dictyotaceae and Corallinaceae were the most representative families at the non-disturbed site, and Rhodomelaceae and Dictyotaceae at the disturbed site. The non-disturbed site presented a higher biomass and the greatest richness and diversity indices. In the disturbed site the dominance index was greater and Caulerpa racemosa was the dominant species. The dendogram based on similarity index showed two major clusters, and an isolated element at the center that corresponds to a sample from the disturbed site. In the first cluster, samples from the non-impacted site were predominant and fleshy brown algae were more conspicuous. The second cluster was composed primarily of samples from the impacted site, where C. racemosa and red filamentous and erect calcareous algae associations (turf forming) were observed covering large extensions. These associations are represented by groups of algae adapted to environments where disturbances are frequent. They can grow rapidly on substrate where benthic community was removed and do not allow the establishment of other species. The results of the present study show that tourism activity is an impacting factor that has been causing shifts in macroalgae communities in the Maracajaú Reef Complex

Compósitos poliméricos a base de fibras de licuri: efeitos da hibridização e do envelhecimento ambiental acelerado

The gradual replacement of conventional materials by the ones called composite materials is becoming a concern about the response of these composites against adverse environmental conditions, such as ultraviolet radiation, high temperature and moist. Also the search for new composite using natural fibers or a blend of it with synthetic fibers as reinforcement has been studied. In this sense, this research begins with a thorough study of microstructural characterization of licuri fiber, as a proposal of alternative reinforcement to polymeric composites. Thus, a study about the development of two composite laminates was done. The first one, involving only the fiber of licuri and the second comprising a hybrid composite based of fiber glass E and the fiber of licuri, in order to know the performance of the fiber when of fiber across the hybridization process. The laminates were made in the form of plates using the tereftálica ortho-polyester resin as matrix. The composite laminate made only by licuri fiber had two reinforcing fabric layers of unidirectional licuri and the hybrid composite had two reinforcing layers of unidirectional licuri fabric and three layers of fiber short glass-E mat. Finally, both laminates was exposed to aging acceleration in order to study the influence of environmental degradation involving the mechanical properties and fracture characteristics thereof. Regarding the mechanical properties of composites, these were determined through uniaxial tensile tests, uniaxial compression and three bending points for both laminates in original state, and uniaxial tensile tests and three bending points after accelerated aging. As regards the study of structural degradation due to aging of the laminates, it was carried out based on microscopic analysis and microstructure, as well as measuring weight loss. The characteristics of the fracture was performed by macroscopic and microscopic (optical and SEM) analysis. In general, the laminated composites based on fiber licuri showed some advantages in their responses to environmental aging. These advantages are observed in the behavior related to stiffness as well as the microstructural degradation and photo-oxidation processes. However, the structural integrity of this laminate was more affected in case the action of uniaxial tensile loads, where it was noted a lower rate of withholding his last resistance property