Of the structured data published on the web, for instance as datasets on Open Data Platforms such as data.gov, but also in the form of HTML tables on the general web, only a small part is in a relational form. Instead the data is intermingled with formatting, layout and textual metadata, i.e., it is contained in partially structured documents. This makes transformation into a true relational form necessary, which is a precondition for most forms of data analysis and data integration. Studying data.gov as an example source for partially structured documents, we present a classification of typical normalization problems. We then present the DeExcelerator, which is a framework for extracting relations from partially structured documents such as spreadsheets and HTML tables.

Made available in DSpace on 2016-04-27T16:58:29Z (GMT). No. of bitstreams: 1 Nelson Dias Leme.pdf: 5327513 bytes, checksum: 4de15af5883da758e73a3351fa8b55d1 (MD5) Previous issue date: 2007-10-17 / Coordenação de Aperfeiçoamento de Pessoal de Nível Superior / This work aims to contribute to the investigation of the impact of a constructionist approach to the use of electronic spreadsheets on the teaching and learning of topics related to Financial Mathematics. To this end, a teaching experiment was designed which involved students in the construction of their own formulas, using spreadsheets, for calculating interests and future values of investments, under regimes of both simple and compound rates. The constructionist conceptions of Papert provided a theoretical base for the development of the activities. The methodology adopted for the study was modelled according to the design-based research methodologies. Two phases of experimentation were elaborated. The first phase involves students initiating their studies in Financial Mathematics in working on a set of activities with spreadsheets, and then completing a series of paper and pencil tasks. In the second phase, to provide a basis for comparing the approach adopted with the more usual practice of giving students previously defined formulae for calculating interest, the paper and pencil task were also administered to a group of students who has previously studied Financial Mathematics. The analysis of data followed the cycle of description-execution-reflectiondebugging- description described by Valente. According to these analyses, the formulae constructed by the students and implemented on the computer served as computational models providing feedback and enabling simulations of various possible situations. This in turn allowed students to engage in a cycle of expression, evaluation and reflection of the mathematical domain in question / O objetivo deste trabalho é colaborar na investigação do impacto da abordagem construcionista e das potencialidades das planilhas eletrônicas no ensino-aprendizagem de conteúdos da Matemática Financeira. Para alcançar o objetivo proposto, foi elaborado um experimento de ensino envolvendo alunos na construção de suas próprias fórmulas, usando planilhas eletrônicas, para o cálculo dos juros e do montante, nos regimes dos juros simples e compostos. Para o desenvolvimento das atividades buscamos referência na concepção construcionista de Seymour Papert (1994). A metodologia empregada neste trabalho está baseada no design-based research methodologies . Metodologia de Pesquisa Baseada em Design. Foram desenvolvidas duas fases de experimentação. A primeira fase envolveu um grupo de alunos iniciantes seus em estudos de Matemática Financeira, em um conjunto de atividades com planilhas eletrônicas e, em uma série de tarefas em papel e lápis. Na segunda fase para comparar com o desempenho do primeiro grupo, foram aplicadas as atividades com papel e lápis a um grupo de alunos que já concluiu seus estudos de Matemática Financeira e que vivenciou uma abordagem de ensino onde as fórmulas não foram construídas. A análise empregou o ciclo descrição-execução-reflexão-depuraçãodescrição de Valente (2002). Segundo nossas análises, as fórmulas deduzidas e implementadas no computador são modelos computacionais que possibilitam o feedback e a simulação, favorecendo o envolvimento dos aprendizes no ciclo básico de expressão, avaliação e reflexão sobre o domínio considerado

No description available.

The success of Web services comes from the benefits that it brings in reducing the cost and the time needed to develop data and applications by reusing them, and simplifying their integrations through standardization. However, standardization in Web services does not remove the need for adapters due to possible heterogeneity among service interface and protocol definitions. Moreover, the current service APIs are targeted toward professional programmers, but not accessible to a wider class of users without programming expertise, but would never the less like to build their own integrated applications. In this dissertation, we propose methods and tools to support both service developers and non-expert users in their data and application integration tasks. To support service developers, we propose a framework that enables rapid development of Web service adapters. We investigate particularly the problem of service adaptation focusing on business interface and protocol layers. Our study shows that many differences between business interfaces and protocols are recurring. We introduce mismatch patterns to capture these recurring differences and provide solutions to resolve them. We present the notion of adaptation aspects, which is based on the aspect-oriented programming paradigm, to enable rapid development and deployment of service adapters. We also present a comparative study between standalone and aspect-oriented adapters development. The study shows that the aspect-oriented approach is preferable in many cases, especially when adapters need to access internal states of services. The proposed approach is implemented in a prototype tool, which is used to illustrate how it simplifies adapters development through a case study. To support users without programming expertise, we propose a spreadsheet-based Web mashups development framework, which enables users to develop mashups in the popular spreadsheet environment. First, we provide a mechanism that makes structured data first class values of spreadsheet cells. Second, we propose a new component model that can be used to develop fairly sophisticated mashups, involving joining data sources and keeping spreadsheet data up to date. Third, to simplify mashup development, we provide a collection of spreadsheet-based mashup patterns that captures common Web data access and spreadsheet presentation functionalities. Users can reuse and customize these patterns to build spreadsheet-based Web mashups instead of developing them from scratch. Fourth, we enable users to manipulate structured data presented on spreadsheet in a drag-and-drop fashion. Finally, we have developed and tested a prototype tool to demonstrate the utility of the proposed framework.

The success of Web services comes from the benefits that it brings in reducing the cost and the time needed to develop data and applications by reusing them, and simplifying their integrations through standardization. However, standardization in Web services does not remove the need for adapters due to possible heterogeneity among service interface and protocol definitions. Moreover, the current service APIs are targeted toward professional programmers, but not accessible to a wider class of users without programming expertise, but would never the less like to build their own integrated applications. In this dissertation, we propose methods and tools to support both service developers and non-expert users in their data and application integration tasks. To support service developers, we propose a framework that enables rapid development of Web service adapters. We investigate particularly the problem of service adaptation focusing on business interface and protocol layers. Our study shows that many differences between business interfaces and protocols are recurring. We introduce mismatch patterns to capture these recurring differences and provide solutions to resolve them. We present the notion of adaptation aspects, which is based on the aspect-oriented programming paradigm, to enable rapid development and deployment of service adapters. We also present a comparative study between standalone and aspect-oriented adapters development. The study shows that the aspect-oriented approach is preferable in many cases, especially when adapters need to access internal states of services. The proposed approach is implemented in a prototype tool, which is used to illustrate how it simplifies adapters development through a case study. To support users without programming expertise, we propose a spreadsheet-based Web mashups development framework, which enables users to develop mashups in the popular spreadsheet environment. First, we provide a mechanism that makes structured data first class values of spreadsheet cells. Second, we propose a new component model that can be used to develop fairly sophisticated mashups, involving joining data sources and keeping spreadsheet data up to date. Third, to simplify mashup development, we provide a collection of spreadsheet-based mashup patterns that captures common Web data access and spreadsheet presentation functionalities. Users can reuse and customize these patterns to build spreadsheet-based Web mashups instead of developing them from scratch. Fourth, we enable users to manipulate structured data presented on spreadsheet in a drag-and-drop fashion. Finally, we have developed and tested a prototype tool to demonstrate the utility of the proposed framework.

Orientador: Prof. Dr. Antonio Cândido Faleiros / Dissertação (mestrado) - Universidade Federal do ABC, Programa de Pós-Graduação em Mestrado Profissional em Matemática em Rede Nacional, 2014. / O objetivo deste trabalho é associar o estudo da matemática financeira com os conteúdos matemáticos que a embasam, tais como funções e sequências numéricas, em especial as progressões geométricas, ressaltando que a relação desses conteúdos articulados com situações reais do cotidiano muito contribui para que a matemática financeira seja um elemento de motivação para o ensino da Matemática, e que essa motivação possa ser desenvolvida ao longo do ensino médio. Nossa proposta é uma abordagem conceitual e prática para o tema, levando em conta os princípios básicos da matemática financeira: fatores de correção e deslocamento de quantias ao longo do tempo. Utilizamos aqui métodos de cálculo algébrico nas resoluções de problemas financeiros com destaque para os logaritmos e o método iterativo. Também utilizamos ferramentas tecnológicas como as planilhas eletrônicas e a calculadora financeira HP 12C, enfatizando a possibilidade do trabalho com vários tipos de resoluções de modo que uma justifica e confirma a necessidade de conhecimento da outra. A articulação de conteúdos matemáticos, a contextualização do tema, bem como a utilização de recursos tecnológicos no ensino da matemática financeira são fatores de relevante importância no ensino da matemática. Espera-se que este trabalho possa ser útil aos professores interessados em desenvolver o tema com seus alunos. Pensamos que a aprendizagem da matemática financeira não pode ser tratada sem a devida conceituação e contextualização ou deixada de lado, pois o estudante que possui conhecimentos financeiros poderá ser, no futuro, um consumidor mais prudente e um cidadão com vida financeira estável / The aim of this work is to associate the study of financial mathematics to the mathematical content that lies behind it such as functions and numerical sequences, in particular the geometric progressions, stressing that the relationship of these articulated content with real-world situations greatly contributes to turn financial mathematics in an element of motivation for the teaching of mathematics, and that this motivation can be developed throughout high school. Our proposal is to approach the subject both in a conceptual and practical way, taking into account the basic principles of financial mathematics: factors of correction and flow of amounts over time. We have used methods of algebraic calculation in resolutions of financial problems especially the logarithms and the iterative method. We also use technological tools such as spreadsheets and the HP 12C Financial Calculator, emphasizing the possibility of working with various resolution methods so that the use of one justifies and confirms the need for knowledge of the other. The articulation of mathematical content, the context of the subject and the use of technological resources in teaching financial mathematics are factors of great importance in the mathematics education. It is hoped that this work can be useful to teachers interested in developing the topic with their students. We believe that the learning of financial mathematics should not be treated without proper conceptualization and contextualization or put aside, because the student who has financial expertise may be, in the future, a more cautious consumer and a citizen with a more stable financial life.

Made available in DSpace on 2014-06-11T19:24:51Z (GMT). No. of bitstreams: 0 Previous issue date: 2004-10-27Bitstream added on 2014-06-13T19:52:40Z : No. of bitstreams: 1 mussolini_af_me_rcla.pdf: 306703 bytes, checksum: 2844e21933fc8c32b8ed7b5f32ed2d19 (MD5) / Conselho Nacional de Desenvolvimento Científico e Tecnológico (CNPq) / Esta pesquisa trata da Formação Inicial de Professores de Matemática, em particular sobre o uso de tecnologia informática. Sabendo da problemática existente nos cursos de graduação, como, por exemplo, a desarticulação entre teoria e prática, entre formação universitária e realidade escolar, deteve-se na seguinte questão: Quais são as perspectivas, expectativas e dificuldades que os futuros professores apresentam quando refletem sobre uma prática educativa utilizando planilhas eletrônicas na escola básica?. A pesquisa contou com a participação de dois futuros professores de Matemática da UNESP de Rio Claro. Foram realizados três encontros de planejamento, dez encontros de intervenção em uma escola pública, e dez encontros de reflexão, que ocorreram sempre após cada intervenção. Os licenciandos tiveram a oportunidade de expor suas idéias sobre as experiências realizadas e, a partir de uma análise à luz do referencial teórico, foram extraindo temas que se referem às suas expectativas, perspectivas e dificuldades. Entre eles, a gestão da sala de aula e a transposição de conteúdo, a complexidade da sala de aula, como eles percebem os alunos, as condições de trabalho na escola, ser professor e o uso de tecnologia informática. / This research addresses the pre-service mathematics teacher education, in particular their practice with computer. Considering the problems concerning teacher education courses - as, for instance, the disarticulation between the theory and the practice, and between the university education and the school reality - it was formulated the following research question: What are the perspectives, expectations and difficulties that the future teachers experience when they reflect on an educational practice using spreadsheets at the basic school? The research was developed in collaboration with two future mathematics teachers from UNESP at Rio Claro, São Paulo, Brazil. It was organized three planning meetings, ten intervention meetings in a public school, and ten reflection meeting, that always took place right after each intervention meeting. The reflection meetings were videoed and transcribed. The data were analyzed with reference to the literature. Themes were identified that could be referred to their expectation, perspectives, and difficulties. These themes included: the teaching in the classroom and the transposition of the contents; the complexity of the classroom environment; the interaction with the students; the school working conditions; being a teacher; and the use of computers.

Made available in DSpace on 2014-06-11T19:29:12Z (GMT). No. of bitstreams: 0 Previous issue date: 2010-02-02Bitstream added on 2014-06-13T20:38:36Z : No. of bitstreams: 1 santim_tgs_me_ilha.pdf: 18665459 bytes, checksum: 8ef69010689f2306d41d9df43eef4563 (MD5) / A expansão das áreas urbanas promove consideráveis alterações no uso e ocupação da terra de uma bacia hidrográfica. Estas novas características condicionam a bacia hidrográfica a um novo regime das variáveis hidrológicas. Desse modo, antecipar o comportamento das variáveis hidrológicas passou a ser o desafio dos planejadores urbanos, pois com a redução de áreas permeáveis o volume que antes infiltrava passa a escoar superficialmente requerendo espaços para ser locado. Com o intuito de locar este acréscimo problemático da vazão as pesquisas em hidráulica e hidrologia passaram a recorrer aos modelos de previsão de vazão. Aos modelos de previsão de vazões somou-se o advento dos programas de geoprocessamento, possibilitando a estruturação de bancos de dados mais detalhados. Assim, este trabalho configurou um banco de dados no ArcMap 9.2 utilizando cartas temáticas confeccionadas no AutoCAD 2000 e planilhas cadastrais sobre o uso e ocupação da terra no Excel 2003 para a sub-bacia hidrográfica do Córrego Sem Nome, localizada no município de Ilha Solteira – SP. Esta bacia hidrográfica tornou-se um caso interessante para estudo, pois além de ser de pequeno porte, área de 3,47 km², em 45 anos deixou de ser rural e passou a ser 100% urbana, sofrendo com intensos processos erosivos. A aplicação do ArcMap 9.2 na determinação dos parâmetros da bacia de drenagem forneceu uma estimativa mais acurada dos coeficiente de runoff, parâmetros da fórmula de Horton e coeficientes de Manning. O Método do Balanço de Massas foi empregado para o cálculo das vazões, a fórmula de Horton para a determinação da infiltração e o método da onda cinética para o cálculo dos tempos de concentração dos trechos a serem analisados. Dessa forma, confeccionou-se um ferramental computacional que possibilitou simulações dos efeitos da urbanização ao longo dos anos... / The urban areas expansion brings significant changes in use and land cover watershed. These new features make the basin to a new system of hydrological variables. Thus, the challenge for urban planners was anticipate the behavior of hydrologic variables because the decrease of permeable areas decreased the volume that infiltrate, increasing runoff, requiring space to be leased. In order to resolve this flood's increase problem researches in hydraulics and hydrology are turning to predictive modeling of flow. Models for forecasting stream flow added to the advent of GIS programs, enabling the structuring more detailed databases. This paper set up a database in ArcMap 9.2 using thematic maps prepared in AutoCAD 2000 and cadastral spreadsheets about the use and land cover in Excel 2003 for the catchment area of the Sem Nome Stream, located in Ilha Solteira- SP, Brazil. This basin has become an interesting case to study, as well as being small, area of 3.47 square kilometers, in 45 years no longer rural and has become 100% urban, suffering from severe erosion. The application of ArcMap 9.2 on watershed parameters determination provides a more accurate estimate of runoff coefficient, of the parameters of the Horton’s formula and of the Manning coefficients. The method of mass balance was used to calculate the flow, the Horton’s formula for determining the infiltration and wave kinetic method for calculating time of concentration of watercourses to be analyzed. Thus, a simulations tool has been concocted turning possible to know the effects of urbanization all over the years, providing the peak flow for each stage of the occupation in the runoff launch. Finally, with the peak flows determined, we evaluated the efficiency of the existing drainage system in the watershed, since it was built along with the city's projected deployment Ilha Solteira – SP, Brazil

Made available in DSpace on 2015-03-03T15:36:12Z (GMT). No. of bitstreams: 1 EduardoSS_DISSERT.pdf: 804086 bytes, checksum: 7991c16751047e96e7a210e52bd8df36 (MD5) Previous issue date: 2013-08-14 / The aim of this work is to provide a text to support interested in the main systems of amortization of the current market: Constant Amortization System (SAC) and French System, also known as Table Price. We will use spreadsheets to facilitate calculations involving handling exponential and decimal. Based on [12], we show that the parcels of the SAC become smaller than the French system after a certain period. Further then that, we did a comparison to show that the total amount paid by SAC is less than the French System / O objetivo deste trabalho e oferecer um texto de apoio aos interessados nos principais sistemas de amortizac??o do mercado atual: Sistema de Amortiza??o Constante (SAC) e Sistema Franc?s, tamb?m conhecido por Tabela Price. Utilizamos planilhas eletr?nicas para facilitar os c?lculos que envolvem manipula??o de exponenciais e decimais. Baseados em [12], mostramos que as presta??es do SAC tornam-se menores que as do Sistema Franc?s a partir de certo per?odo de financiamento. Al?m disso, fazemos uma compara??o para mostrar que o montante total pago pelo SAC e menor que o do Sistema Franc?s

Resumo: A expansão das áreas urbanas promove consideráveis alterações no uso e ocupação da terra de uma bacia hidrográfica. Estas novas características condicionam a bacia hidrográfica a um novo regime das variáveis hidrológicas. Desse modo, antecipar o comportamento das variáveis hidrológicas passou a ser o desafio dos planejadores urbanos, pois com a redução de áreas permeáveis o volume que antes infiltrava passa a escoar superficialmente requerendo espaços para ser locado. Com o intuito de locar este acréscimo problemático da vazão as pesquisas em hidráulica e hidrologia passaram a recorrer aos modelos de previsão de vazão. Aos modelos de previsão de vazões somou-se o advento dos programas de geoprocessamento, possibilitando a estruturação de bancos de dados mais detalhados. Assim, este trabalho configurou um banco de dados no ArcMap 9.2 utilizando cartas temáticas confeccionadas no AutoCAD 2000 e planilhas cadastrais sobre o uso e ocupação da terra no Excel 2003 para a sub-bacia hidrográfica do Córrego Sem Nome, localizada no município de Ilha Solteira - SP. Esta bacia hidrográfica tornou-se um caso interessante para estudo, pois além de ser de pequeno porte, área de 3,47 km², em 45 anos deixou de ser rural e passou a ser 100% urbana, sofrendo com intensos processos erosivos. A aplicação do ArcMap 9.2 na determinação dos parâmetros da bacia de drenagem forneceu uma estimativa mais acurada dos coeficiente de runoff, parâmetros da fórmula de Horton e coeficientes de Manning. O Método do Balanço de Massas foi empregado para o cálculo das vazões, a fórmula de Horton para a determinação da infiltração e o método da onda cinética para o cálculo dos tempos de concentração dos trechos a serem analisados. Dessa forma, confeccionou-se um ferramental computacional que possibilitou simulações dos efeitos da urbanização ao longo dos anos... (Resumo completo, clicar acesso eletrônico abaixo) / Abstract: The urban areas expansion brings significant changes in use and land cover watershed. These new features make the basin to a new system of hydrological variables. Thus, the challenge for urban planners was anticipate the behavior of hydrologic variables because the decrease of permeable areas decreased the volume that infiltrate, increasing runoff, requiring space to be leased. In order to resolve this flood's increase problem researches in hydraulics and hydrology are turning to predictive modeling of flow. Models for forecasting stream flow added to the advent of GIS programs, enabling the structuring more detailed databases. This paper set up a database in ArcMap 9.2 using thematic maps prepared in AutoCAD 2000 and cadastral spreadsheets about the use and land cover in Excel 2003 for the catchment area of the Sem Nome Stream, located in Ilha Solteira- SP, Brazil. This basin has become an interesting case to study, as well as being small, area of 3.47 square kilometers, in 45 years no longer rural and has become 100% urban, suffering from severe erosion. The application of ArcMap 9.2 on watershed parameters determination provides a more accurate estimate of runoff coefficient, of the parameters of the Horton's formula and of the Manning coefficients. The method of mass balance was used to calculate the flow, the Horton's formula for determining the infiltration and wave kinetic method for calculating time of concentration of watercourses to be analyzed. Thus, a simulations tool has been concocted turning possible to know the effects of urbanization all over the years, providing the peak flow for each stage of the occupation in the runoff launch. Finally, with the peak flows determined, we evaluated the efficiency of the existing drainage system in the watershed, since it was built along with the city's projected deployment Ilha Solteira - SP, Brazil / Orientador: José Augusto de Lollo / Coorientador: Jefferson Nascimento de Oliveira / Banca: Paulo Augusto Romera e Silva / Banca: Sergio dos Anjos Ferreira Pinto / Mestre