首页    期刊浏览 2025年03月01日 星期六
登录注册

文章基本信息

  • 标题:Fourier Analysis: Graphical Animation and Analysis of Experimental Data with Excel
  • 本地全文:下载
  • 作者:Margarida Oliveira Prof. ; Suzana Nápoles Prof. ; Sérgio Oliveira Eng.
  • 期刊名称:Spreadsheets in Education
  • 印刷版ISSN:1448-6156
  • 出版年度:2012
  • 卷号:5
  • 期号:2
  • 出版社:Faculty of Information Technology, Bond University
  • 摘要:

    According to Fourier formulation, any function that can be represented in a graph may be approximated by the “sum” of infinite sinusoidal functions (Fourier series), termed as “waves”.The adopted approach is accessible to students of the first years of university studies, in which the emphasis is put on the understanding of mathematical concepts through illustrative graphic representations, the students being encouraged to prepare animated Excel-based computational modules (VBA-Visual Basic for Applications).Reference is made to the part played by both trigonometric and complex representations of Fourier series in the concept of discrete Fourier transform. Its connection with the continuous Fourier transform is demonstrated and a brief mention is made of the generalization leading to Laplace transform.As application, the example presented refers to the analysis of vibrations measured on engineering structures: horizontal accelerations of a one-storey building deriving from environment noise. This example is integrated in the curriculum of the discipline “Matemática Aplicada à Engenharia Civil” (Mathematics Applied to Civil Engineering), lectured at ISEL (Instituto Superior de Engenharia de Lisboa. In this discipline, the students have the possibility of performing measurements using an accelerometer and a data acquisition system, which, when connected to a PC, make it possible to record the accelerations measured in a file format recognizable by Excel.

国家哲学社会科学文献中心版权所有