GeoGebra Tutorial 19 – Basic Spreadsheet Recording

This is the 19th tutorial of the GeoGebra Intermediate Tutorial Series. If this is your first time to use GeoGebra, you might want to read first the GeoGebra Essentials Series.

A spreadsheet is a program that can be used to organize data in tables and  perform mathematical computations. Recently, GeoGebra integrated spreadsheet in its graphical user interface. In this tutorial, we learn how to use the GeoGebra spreadsheet.

Figure 1

The figure above shows the different parts of a spreadsheet.  The following are the descriptions. You should familiarize yourself with these terms because we are going to use them in this tutorial and the two more tutorials to come. » Read more

GeoGebra Short-Term Course Concluded

Last Saturday, June 5, 2010, we have concluded our 3-Saturday seminar on Using GeoGebra in Teaching Mathematics. Below are some of the pictures  taken from the said short-term course.

That’s me on the first pic explaining the mathematics behind the “how-to” construction. If you’re wondering why our whiteboard is high, well, I am just short. I am 5’3” feet, or maybe shorter (chuckles).

As you can see, the participants are really serious. 🙂

One of our participants constructing her GeoGebra applet.

______________

So if you want to invite me* to conduct a lecture on GeoGebra in your school, I am just an email away.

*Philippines only (unless, of course, your school is willing to shoulder my expenses. Just kidding  🙂 ).

Geometric Sequences and Series

Introduction

We have discussed about arithmetic sequences, its characteristics and its connection to linear functions. In this post, we will discuss another type of sequence.

The sequence of numbers 2, 6, 18, 54, 162, … is an example of an geometric sequence.  The first term 2 is multiplied by 3 to get the second term, the second term is multiplied by 3 to get the third term, the third term is multiplied by 3 to get the fourth term, and so on.  The same number that we multiplied to each term is called the common ratio. Expressing the sequence above in terms of the first term and the common ratio, we have 2, 2(3), 2(32), 2(33), …. Hence, a geometric sequence, also known as a geometric progression, is a sequence of numbers where each term after the first is found by multiplying the previous one by a fixed non-zero number called the common ratio.

The Sierpinski triangle below is an example of a geometric representation of a geometric sequence.  The number of blue triangles, the number of white triangles, their areas, and their side lengths form different geometric sequences. It is left to the reader, as an exercise, to find the rules of these geometric sequences.

Figure 1 - The Seriepinski Triangles.

To generalize, if a1 is its first term and the common ratio is r, then the general form of a geometric sequence is a1, a1r, a1r2, a1r3,…, and the nth term of the sequence is a1rn-1.

A geometric series, on the other hand, is the sum of the terms of a geometric sequence. Given a geometric sequence with terms a1r, a1r2, a1r3,…, the sum Sn of the geometric sequence with n terms is the geometric series a1 + a1r + a1r2, a1r3 + … + arn-1. Multiplying Sn by -r and adding it to Sn, we have

Hence, the sum of a geometric series with n terms, and r \neq 1 = \displaystyle\frac{a_1(1-r^n)}{1-r}.

Sum of Infinite Geometric Series  and a Little Bit of Calculus

Note: This portion is for those who have already taken elementary calculus.

The infinite geometric series \{a_n\} is the the symbol \sum_{n=1}^\infty a_n = a_1 + a_2 + a_3 + \cdots. From above, the sum of a finite geometric series with n terms is \displaystyle \sum_{k=1}^n \frac{a_1(1-r^n)}{1-r}. Hence, to get the sum of the infinite geometric series, we need to get the sum of \displaystyle \sum_{n=1}^\infty \frac{a_1(1-r^n)}{1-r}. However,  \displaystyle \sum_{k=1}^\infty \frac{a_1(1-r^n)}{1-r} = \lim_{n\to \infty} \frac{a_1(1-r^n)}{1-r}.

Also, that if |r| < 1, r^n approaches 0 (try (\frac{2}{3})^n or any other proper fraction and increase the value of n), thus, \displaystyle \sum_{n=1}^\infty \frac{a_1(1-r^n)}{1-r} = \lim_{n \to \infty} \frac{a_1(1-r^n)}{1-r} = \frac{a_1}{1-r}. Therefore, sum of the infinite series \displaystyle a_1 + a_2r + a_2r^2 + \cdots = \frac{a_1}{1-r}.

One very common infinite series is \displaystyle \sum_{n=1}^{\infty} \frac{1}{2n} = \frac{1}{2} + \frac{1}{4} + \frac{1}{8} + \frac{1}{16} + \cdots, or the sum of the areas of the partitions of the square with side length 1 unit shown below. Using the formula above,

\displaystyle \sum_{n=1}^{\infty} \frac{1}{2n} = \frac{a_1}{1-r} = \frac{\frac{1}{2}}{1-\frac{1}{2}} = 1.

Figure 2 - A representation of an infinite geometric series.

This is evident in the diagram because the sum of all the partitions is equal to the area of a square. We say that the series \displaystyle \sum_{n=1}^{\infty} \frac{1}{2n} converges to 1.

1 2 3 4 5 6