•
•

#### Article Title

Functions and Mathematical Modelling with Spreadsheets

#### Abstract

In this paper we intended to show how it is possible to encourage the use of computers in the learning of Mathematics, using development environments such as spreadsheets, with which teachers and students can develop interactive computer applications with graphical components and animation.

It also seeks to enhance the links between mathematics, technology and other sciences in order to enhance the power of mathematics for the simulation of physical phenomena.

The relationship between mathematics and observable physical phenomena are fundamental aspects for the implementation of an approach that favours the laboratory aspect of mathematics, together with the validation of hypotheses and mathematical modelling techniques (computer models) used to simulate the observed phenomena.

Pêndulo-Euler-RK-final_SN3.xlsm (846 kB)
Study of pendulum oscillations using spreadsheets and numerical methods for solving non-linear differential equations

In the application arise graphics of a quadratic function of the form y=dx^2+e and a line y = ax + b. On the left side of the application are the scrollbars that allows varying the parameters of analytical expressions. On the right side appear the tangency point coordinates whose abcissa can be changed by the scroll bar.

moinho-eolico2.xlsm (65 kB)
To represent, schematically, an Electrical wind generator and simulate its blades rotation movement, firstly it's necessary to "place" the turbine in a Cartesian axis and build a table comprised of the coordinates of the vertexes of the triangle that represents a blade (drawn in the vertical position in red). Coordinates that refer to the other two triangles which represent the green and yellow blades are obtained through a rotation around the origin of, respectively, 120º and 240º. Coordinates of the base triangle vertexes are entered directly.

ex1.xlsm (125 kB)
To encourage the establishment of between algebra and geometry connections is possible to develop a computer application that provides the study of the variation of a function associated with a geometric problem. Consider the function f(x)=-x^2+4x and the coordinate point (1,0). Now consider the function g which associates, for each value of x, the distance between the point P and the abcissa x belonging to the graph of f.

canonica.xlsm (92 kB)
The study of the quadratic function is part of the national curriculum of the 10th year, and is expected to study their properties and their graphical representations. It is also recommended the graphic exploration of families of quadratic functions by varying the parameters of their analytical expressions and their association to the modeling of physical phenomena. An important aspect for the use of the spreadsheet in this topic is the possibility of simultaneous display of graphical representations allowing students to experiment and discover the effect of changing the parameters in the graphs

vertice.xlsm (107 kB)
The study of the quadratic function is part of the national curriculum of the 10th year, and is expected to study their properties and their graphical representations. It is also recommended the graphic exploration of families of quadratic functions by varying the parameters of their analytical expressions and their association to the modeling of physical phenomena. An important aspect for the use of the spreadsheet in this topic is the possibility of simultaneous display of graphical representations allowing students to experiment and discover the effect of changing the parameters in the graphs

sistemas_ingles.xlsm (69 kB)
Suppose that two drivers A and B initiate simultaneously route in opposite directions between two locations that are distant 300 km. They run with different speeds and intend to meet during the trip. Assuming that the speed of each one remains constant, choose the meeting point to avoid waiting time for any one of the drivers.